Ok thanks On Thursday, 15 June 2017 20:23:27 UTC+2, Noel Grandin wrote: > > Not at the moment, currently tracked as this bug: > > https://github.com/h2database/h2database/issues/409 > > On 15 June 2017 at 18:28, Pieter Martin <[email protected] <javascript:> > > wrote: > >> Hi, >> >> I am trying to execute the following query. >> It works on Postgresql and Hsqldb but now is breaking on my H2database >> implementation. >> >> SELECT >> "index", >> "PUBLIC"."V_God"."ID" AS "alias1" >> FROM >> "PUBLIC"."V_Fantasy" INNER JOIN >> "PUBLIC"."E_godDream" ON "PUBLIC"."V_Fantasy"."ID" = "PUBLIC". >> "E_godDream"."PUBLIC.Fantasy__I" INNER JOIN >> "PUBLIC"."V_God" ON "PUBLIC"."E_godDream"."PUBLIC.God__O" = "PUBLIC". >> "V_God"."ID" INNER JOIN >> (VALUES(1, 1),(2, 2)) AS tmp ("tmpId", "index") ON "PUBLIC"."V_Fantasy" >> ."ID" = tmp."tmpId" >> ORDER BY >> "index"; >> >> I see that h2 does support value expressions and in the docs it mentions >> columnNames but I can not get it to work. >> >> Basically I'd like to use values to specify the values of a table and >> join onto it. >> To do so the values' columns need names. >> >> I tried hard coding the columns as C1 and C2 but that did not work either. >> >> Is this possible? >> >> Thanks >> Pieter >> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> Visit this group at https://groups.google.com/group/h2-database. >> For more options, visit https://groups.google.com/d/optout. >> > >
-- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
