On 2013-07-12 16:42, Seb N/A wrote:
Sincere apologies, and point taken...
I extracted the DDL from code and I cut the commas while removing
double-quotes.
I have now fixed the DDL and loaded in a sandbox:
>>runscript from 'ddl.txt';
runscript from 'ddl.txt';
Update count: 25
(16 ms)
DDL.txt re-attached.
Once again, apologies for the concerns caused...
Thanks.
I've just tried this out, and it's "working" for me.
Explain plan generates a reasonable result, and your problematic query
returns in 16ms.
Now the reason the query "works" for me could be because I have no data
in the database, but that doesn't explain why EXPLAIN PLAN was failing
for you.
What version are you running?
If it's an older version, we may have fixed the bug already.
And what does your JDBC URL look like?
I'm interested in what extra options you are using.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
