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].
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.
