, 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
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
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: