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 -~----------~----~----~----~------~----~------~--~---
