Weird. I wrote a simple self-contained program to demonstrate this
apparent discrepancy for a bug report. In a simple statement:
SELECT count(1) FROM test WHERE date_field >= (? - 42)
I get the exception anyway even with old versions of H2, yet I've been
using the above, complex statement for years and it still works up to
1.1.119. Maybe it's not supposed to work, and the mess of subqueries
has prevented the parser from rejecting it somehow.
I can get the complex SQL to work by substituting dateadd("DAY",
-42, ?), and I may need to do that.
On May 26, 11:04 am, Soupdragon <[email protected]>
wrote:
--
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.
