Re: Subqueries in LEFT JOIN throw syntax error (regression? similar to error from April, maybe the same error)

[Noel Grandin]

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

[Mariano Rodriguez Muro]

Hi Noel and Thomas, 

Is there any news on this bug? Do you think we can expect a fix in the next release?

I have the impression this could really be a regression since this Thomas fixed a very similar issue back

in April 30. I attach the link, maybe it can help [1]. 

Cheers,

Mariano

[1] http://www.mailinglistarchive.com/html/h2-da...@googlegroups.com/2012-04/msg00285.html