Hi
There are 2 problems here - the first is that you are not using the
quoted form of the table name in your select statement.
The second problem is a bug in H2 - in the Parser class, in the
readTableFilter method, we are calling isSelect(), which is incorrectly
deciding that this is a UNION type clause.
Unfortunately, this is beyond my abilities to debug, maybe Thomas can
figure it out.
Thomas, this is an improved test case:
CREATE TABLE tri (s varchar,p varchar,o varchar);
INSERT INTO tri VALUES ('x1', 'p', '1');
INSERT INTO tri VALUES ('x2', 's', '2');
SELECT *
FROM
(SELECT * FROM tri) t1
LEFT JOIN
(
(SELECT * FROM tri) t2
LEFT JOIN
(SELECT * FROM tri) t3
ON t3.p = 't'
) ON t2.p = 's'
WHERE
t1.p = 'p'
Regards, Noel Grandin
--
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.
