Re: [h2] Syntax error in SQL statement WITH keyword

2014-03-31 Thread Anteneh Mamo
, Noel Grandin wrote: On 2014-03-27 23:57, Anteneh Mamo wrote: when we try to run the sql statement : *WITH TMP1 AS (SELECT col1 FROM table1) SELECT TMP1.col1 FROM TMP1*. we are getting the below exception At the moment we only support recursive with statements i.e. WITH X(N) so

[h2] Re: Syntax error in SQL statement WITH keyword

2014-03-31 Thread Anteneh Mamo
On Thursday, March 27, 2014 2:57:14 PM UTC-7, Anteneh Mamo wrote: Hi, jdbc:h2:mem:request_no;MODE=Oracle We are using the h2 version 1.3.171 with windows 7 (64 bit) and jdk 1.7.0_25. when we try to run the sql statement : *WITH TMP1 AS (SELECT col1 FROM table1) SELECT TMP1.col1 FROM

[h2] Syntax error in SQL statement WITH keyword

2014-03-27 Thread Anteneh Mamo
Hi, jdbc:h2:mem:request_no;MODE=Oracle We are using the h2 version 1.3.171 with windows 7 (64 bit) and jdk 1.7.0_25. when we try to run the sql statement : *WITH TMP1 AS (SELECT col1 FROM table1) SELECT TMP1.col1 FROM TMP1* . we are getting the below exception org.h2.jdbc.JdbcSQLException: