Hi, Thanks a lot for your help!
I could now reproduce the problem. This will be fixed in the next release (which will be probably later today). I understand why it happened, but unfortunately I couldn't create a simple test case so far. It is related to the INSERT ... FROM SELECT ... query. Regards, Thomas On Mon, Dec 29, 2008 at 5:48 PM, Markus Plesser <[email protected]> wrote: > > Hi Thomas, > > thanks again for your excellent support! > >> > even if i manually set the timeout to 10000000 the exception occurs. >> > I can not provide you with a simple test case for this since the >> > process involved is non trivial. >> > If you want I could provide you with instructions how to reproduce >> > this behaviour using our test cases - please let me know. >> >> That would be great... So far I can't reproduce this problem. > > I wrote a short HowTo at > http://wiki.flexive.org/confluence/display/FX/Running+Unit+Tests > specifically for running H2 unit tests. > To get the timeout error just edit the file src/framework/java/com/ > flexive/core/search/H2/H2SQLDataFilter.java and change line 65 (method > isQueryTimeoutSupported()) to "return true;" > Please run the first test run like explained in the wiki, for > subsequent you can just issue "ant db.noupdate tests.groups - > Dtests.groups=search" to avoid re-creating the database. > > The timeouts are then set in files src/framework/java/com/flexive/core/ > search/SqlSearch.java line 267 and src/framework/java/com/flexive/core/ > search/genericSQL/GenericSQLDataFilter.java line 197. The default > value used is 15. To test higher values just change the 2 mentioned > lines to a higher value replacing search.getParams().getQueryTimeout() > with numeric values. > >> >> > Here are the create table statements without any constraints, etc. >> > needed to produce a test case. >> >> Hm, I still can't reproduce it... I tried with your query and no data, >> and with one row for each table, but it works for me (however the >> result was zero rows). > > Zero rows is the expected result. > However I can no longer reproduce this issue using version 105. > Reverting back to 103 I still get this error: > "Order by expression 2 must be in the result list in this case" > >> >> Sure! Already done, seehttp://www.h2database.com/html/links.html >> > Thanks a lot! :-) > > Cheers, > Markus > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
