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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
