Hi,
Have encountered a regression somewhere imbetween 1.4.186 and 1.4.193
(pretty sure broken in 1.4.192 as well). Checked against the current head
version. Just got around to reducing my problem to a test case.
Hope this helps!
- mike
DROP SCHEMA "x";
CREATE SCHEMA IF NOT EXISTS "x";
CREATE CACHED TABLE IF NOT EXISTS "x"."A"( "name" VARCHAR NOT NULL);
CREATE CACHED TABLE IF NOT EXISTS "x"."B"("Id" BIGINT NOT NULL);
CREATE CACHED TABLE IF NOT EXISTS "x"."C"("B" BIGINT);
SELECT
t."Id"
FROM (SELECT * FROM "x"."B" as t0 WHERE t0."Id"=0) AS t
LEFT JOIN (
SELECT
count(*) AS "vc0"
FROM "x"."A" AS t_A
WHERE (true)
) AS t_A
LEFT JOIN (
SELECT
count(*) AS "vc0",
t_Cs."B" AS GROUPBY
FROM "x"."C" AS t_Cs
WHERE (NOT (((t_Cs."B") IS NULL)))
GROUP BY groupby
) AS t_Cs ON t."Id" IS t_Cs.groupby
WHERE (true)
LIMIT 25000
--
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.
