SQL Gotchas
time to read 2 min | 203 words

I think you can imagine the amount of paint involved in having a query behave in an unexpected manner. I have run into both of those recently. This one had me doubting my sanity (imagine this on a table with several hundred thousands records, with a fairly complex query around it:

select 1

where 1 not in (2,3,null)

And then there is this interesting little query:

select 1 where 'e' = 'e   '

I refused to believe the result until I saw it myself.

0 comments
Tags:

Related posts that you may find interesting:

17 Mar 2007 Performance: Multiply Collections Fetch With NHibernate
NHibernate
11 Jan 2007 Race Conditions, Synchornized methods and overloading, oh my...
Books Programming
12 Mar 2007 Querying Is A Business Concern: Sample
Design O/R Mappers