You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
SETpg_strom.regression_test_mode=on;
SET client_min_messages = error;
DROPSCHEMA IF EXISTS regtest_miscs CASCADE;
CREATESCHEMAregtest_miscs;
SET search_path = regtest_miscs,public;
SETpg_strom.enabled=on;
SET enable_seqscan=0;
-- #624CREATETABLEt1(c0 money , c1 money);
INSERT INTO t1(c0, c1) VALUES(1, 1);
EXPLAIN(costs off, verbose)
SELECTSUM(t1.c1) FROM t1;
SELECTSUM(t1.c1) FROM t1;
-- #625DROPTABLE IF EXISTS t0;
DROPTABLE IF EXISTS t1;
CREATETABLEt0(c0 int , c1 int);
INSERT INTO t0(c0, c1) VALUES(0, 1);
CREATETABLEt1(LIKE t0);
ALTERTABLE t0 DROP c1;
EXPLAIN(costs off, verbose)
SELECT*FROM t1 LEFT OUTER JOIN t0 ON (t1.c0=t1.c1);
SELECT*FROM t1 LEFT OUTER JOIN t0 ON (t1.c0=t1.c1); #ここで発生
以下のように#625部分だけだと発生しない。
DROPTABLE IF EXISTS t0;
DROPTABLE IF EXISTS t1;
CREATETABLEt0(c0 int , c1 int);
INSERT INTO t0(c0, c1) VALUES(0, 1);
CREATETABLEt1(LIKE t0);
ALTERTABLE t0 DROP c1;
EXPLAIN(costs off, verbose)
SELECT*FROM t1 LEFT OUTER JOIN t0 ON (t1.c0=t1.c1);
SELECT*FROM t1 LEFT OUTER JOIN t0 ON (t1.c0=t1.c1); #ここで発生
The text was updated successfully, but these errors were encountered:
0-kaz
added
the
bug
developer confirmed the steps to reproduce the problem, and does not work as expected
label
Mar 8, 2025
0-kaz
changed the title
ALTER TABLE後のLEFT OUTER JOINでサーバプロセス異常終了
PG15:ALTER TABLE後のLEFT OUTER JOINでサーバプロセス異常終了
Mar 8, 2025
#625 のリグレッションテストでサーバプロセスが異常終了する。
ただし、再現性が100%でなく、タイミングの問題がある模様。
再現クエリ。以下のクエリを間をおかず一気に実行すると発生する。
以下のように#625部分だけだと発生しない。
The text was updated successfully, but these errors were encountered: