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/[email protected]/2012-04/msg00285.html On Wednesday, October 17, 2012 11:43:27 AM UTC+2, Noel Grandin wrote: > > 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 view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/ZFNILHGoScoJ. 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.
