Can H2, using Oracle compatibility mode, execute CONNECT BY PRIOR hierarchical queries?
http://psoug.org/reference/connectby.html I think not, since I am getting error: Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SELECT ID, NAME FROM SOMETABLE START[*] WITH PARENT_ID IS NULL CONNECT BY PRIOR ID = PARENT_ID "; SQL s tatement: SELECT id, name FROM SOMETABLE START WITH parent_id is null CONNECT BY PRIOR id = parent_id [42000-153] - will this be supported in future releases? - is there any way to work around this currently? I have already implemented TRUNC() as a Java function using CREATE ALIAS IF NOT EXISTS TRUNC FOR "myclass.mymethod", is similar possible with CONNECT BY? I am using H2 to run integration tests with in-memory H2 db while actual db is Oracle. -- 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.
