On 2014-03-31 17:57, SARAVANAMANI S wrote:
Hi Noel,
Thank you for your response. We did modified the query to recursive like WITH
x(n) as (select n from t1) select n from x
then it started working fine but if we include one more select statement it
fails again.
Query:
WITH x(n) as (select n
Hi Noel,
Thank you for your response. We did modified the query to recursive like WITH
x(n) as (select n from t1) select n from x then it started working fine but
if we include one more select statement it fails again.
Query:
WITH x(n) as (select n from t1), y(m) as (select m from t2) select m
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 you'll have to rewrite that us
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: Syn