Hi, I will add a feature request:
MySQL compatibility: support comparing 1='a' Regards, Thomas On Wed, Feb 4, 2009 at 7:31 AM, Jacek <[email protected]> wrote: > > Hi, > >> > I generate SQL statement from the user input >> > "no error" policy. >> >> What about syntax errors, SQL injection, divide by zero? > > Oh, by "no error" policy I meant only the case being discussed, i.e. > comparing values of different data types. For the situations you > mentioned above exceptions are perfectly legitimate. But I'm not sure > that throwing exception when comparing values of different data types > is the best solution. > > To better illustrate what I mean let's consider a simple user > interface with two input boxes denoted by [ ], where user can enter > values to compare and decide whether he wants to compare their meaning > or literally. At the end of line is the output most users would > expected according to my opinion. <pre> > [1 ] =meaning [1.0 ] true > [1 ] =literal [1.0 ] false > [1 ] =meaning [a ] false > [1 ] =literal [a ] false</pre> > > In the third case H2 behaves contrary to the typical assumption. > > Regards, > Jacek > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
