开发者

Where is the correct place to report a bug in SQL Server?

I have found a fairly insignificant bug in SQL Server 2008.

I would like to report this to Microsoft, however, when I went to https://support.microsoft.com/ I realized that I may need to spend $300 CAD to report it.

Is there a place where I can report this bug without it costing me any money?


Below is a sample of the bug:

Work开发者_StackOverflow中文版s:

USE [msdb]  
(SELECT * FROM msdbms)

Fails with "Incorrect syntax near the keyword 'order'."

USE [msdb]  
(SELECT * FROM msdbms ORDER BY dbms)

Also, if I am incorrect and this isn't a bug can it be explained why not?

EDIT

I've added this to Microsoft Connect


Now that Connect is being retired thanks to GDPR, they've migrated all Connect content (supposedly!) to UserVoice under the Azure feedback forums. Bugs/issues/product-feedback should be directed there.

Interestingly enough, they say "If you have a technical issue, please open a post on StackOverflow or MSDN." Not sure what they mean by "technical issue" and whether or not it's a synonym for "bug". But, given that Connect was used for filing bugs while it was alive, it stands to reason that this new location, wherein they've migrated 4000 bug reports from Connect, would continue to be the correct place for such... but I'm no MVP or "insider" or whatnot, so hopefully someone closer to the source can verify this.


you can report bugs at the sql server connect site https://connect.microsoft.com/SQLServer

however, here are 2 workarounds because you really don't need the parenthesis

USE [msdb]  
SELECT * FROM msdbms ORDER BY dbms

USE [msdb]  
select * from 
(SELECT * FROM msdbms) x
ORDER BY dbms


Connect is the usual site.

Another parentheses related issue.


It looks like UserVoice (as others suggested) has been retired also! The new place to report bugs seems to be https://learn.microsoft.com/en-us/answers/index.html


The funnier or smellier bug/feature would be to get a wrongly sorted list by running the following:

USE [msdb]  
select * from (SELECT top 100 percent * FROM msdbms order by 1 desc) t

Because, apparently, by design, sorting with top 100 percent doesn't work. And the funny part is that you are allowed to specify order by even though you're not gaining anything by it.

It's more of a 'view' comment and it's not really a bug. But it's interesting to mention.


I noticed bug in sql in my work place. I studied IT in management. Problem is Pointer of mouse in rectangle If pointer is held there <•••> after this sign something is different. I noticed this difference depending on this

  1. using finger on touchschreen
  2. using mouse to click on screen
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜