I want some Moore

Blog about stuff and things and stuff. Mostly about SQL server and .Net
posts - 216, comments - 2277, trackbacks - 33

My Links

Advertisement

News

Hi! My name is 
Mladen Prajdić  I'm from Slovenia and I'm currently working as a .Net (C#) and SQL Server developer.

I also speak at local user group meetings and conferences like SQLBits and NT Conference
Welcome to my blog.
SQL Server MVP

My Books

SQL Server MVP Deep Dives 2
The Red Gate Guide to SQL Server Team based Development Free e-book
My Blog Feed via Email
Follow MladenPrajdic on Twitter
Users Online: who's online

Article Categories

Archives

Post Categories

Cool software

Other Blogs

Other stuff

SQL stuff
<< I want a culture insensitive decimal separator for Sql server | Home | A bit about sql server's local temp tables >>

Annoying SQL Server "bug feature"

here's a select. don't run it just look at it and think what it returns:

SELECT 123.654, 123d6, 123e4, '123'e4

ok now run it.

the results are:

(No column name) d6 (No column name) e4
123.654 123 1230000 123

 

I lost 2 hours of debugging this little annoying as hell "feature" for 123d6 value.

i mean come on... where is the freakin' logic here???

why not just say error in parsing or something??

Print | posted on Thursday, November 02, 2006 11:41 AM |

Feedback

Gravatar

# re: Annoying SQL Server "bug feature"

select 1from sysobjects;
SELECT top 1a from (select 1 a) a;
SELECT 123'col2';
11/3/2006 7:52 AM | Alexander Gladchenko
Gravatar

# re: Annoying SQL Server "bug feature"

select'4'bag;
11/3/2006 10:07 AM | Alexander Gladchenko
Gravatar

# re: Annoying SQL Server "bug feature"

isn't that annoying as hell? at least to me it is...

i really wish that would be syntacticaly wrong.
11/3/2006 10:08 AM | Mladen
Gravatar

# re: Annoying SQL Server "bug feature"

If you'd ever written a yacc/lex parser, especially one for SQL, you'd be familiar with these kind of 'features'. In short, white-space isn't the only thing that can separate grammatical elements, if those elements can be 'lexed' separately................
11/6/2006 9:59 AM | Mark Buckle
Gravatar

# re: Annoying SQL Server "bug feature"

In my home language, we have a proverb stating that a knowledgable person needs only half a word. Well, computers are not knowledgable (yet) so, give them a "full" word. ;-D
11/7/2006 6:10 AM | Johan
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET

Copyright © Mladen Prajdić