On 9/11/08, Jay Pipes <[EMAIL PROTECTED]> wrote: > > Technically, the SQL Standard calls for NOT to have high precedence, > meaning that the evaluation of "NOT a" occurs before the filter on > whether the result of that evaluation is between 2 and 3.
[snip] > > If we stick with the current behaviour of Drizzle, there is a simple > workaround to enable the SQL Standard behaviour: use parentheses around > the "NOT a" in the example above. > > If we implement the SQL standard behaviour in Drizzle, there is no > workaround to enable the old behaviour. Unfortunately I think this is important. As much as I'd rather do it the standard way, it makes more sense to have a workaround (or at least an easier one! there's always a workaround, but parentheses are easier....) Thoughts and votes on this are appreciated, even if that though is "I > couldn't care less; people should learn to write SQL in a manner that is > not idiotic." Nah, if they did that, I'd be out of a job. As I always say, "The best part about MySQL is its accessibility -- any schmuck can write a query. The problem with MySQL is....any schmuck can write a query." -Sheeri
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
