In one of our development branches, I moved in a newer version of H2,
and one of the JUnit tests started spitting out this error. I don't
think I've ever seen this error running version 1.0.62, but on any
later version that I've tried, included 1.0.79 which is marked as
stable, the same SQL gets the error about one of the join conditions
being illegal. The stack trace is
Error: Unsupported outer join condition: ((QROOT.ID =
CC_RELATEDACTIVITY_2.OWNERID) AND (QROOT.CLAIMID =
CC_ACTIVITY_3.CLAIMID)); SQL statement:
[SQL statement goes here] then a stack trace:
at org.h2.message.Message.getSQLException(Message.java:103)
at org.h2.message.Message.getSQLException(Message.java:114)
at org.h2.message.Message.getSQLException(Message.java:77)
at org.h2.command.dml.Select.preparePlan(Select.java:815)
at org.h2.command.dml.Select.prepare(Select.java:729)
at org.h2.command.Parser.prepareCommand(Parser.java:233)
at org.h2.engine.Session.prepareLocal(Session.java:285)
at org.h2.engine.Session.prepareCommand(Session.java:246)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:
1035)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:151)
at org.h2.server.web.WebThread.getResult(WebThread.java:1714)
at org.h2.server.web.WebThread.query(WebThread.java:1277)
at org.h2.server.web.WebThread.process(WebThread.java:444)
at org.h2.server.web.WebThread.processRequest(WebThread.java:186)
at org.h2.server.web.WebThread.process(WebThread.java:241)
at org.h2.server.web.WebThread.run(WebThread.java:196)
The query I'll attach as a file.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
