################# issue repro cases:
-- testcase1, replication table concurrent delete crash
[mppdb@ecs-8869-0009 gaussdb-transaction]$ cat config/gaussdb/rep.txt
CREATE TABLE IF NOT EXISTS t69 (c1 CLOB, PRIMARY KEY (c1)) WITH (ORIENTATION=COLUMN, COLVERSION=2.0, COMPRESSION=HIGH) DISTRIBUTE BY REPLICATION;
CREATE TABLE t70 (c1 INTEGER[] NOT NULL, c2 NUMERIC (10,0), c3 TIME(0) WITH TIME ZONE PRIMARY KEY, UNIQUE (c3, c2, c1)) WITH (ORIENTATION=ROW) DISTRIBUTE BY REPLICATION;
CREATE TABLE t71 (c1 SMALLSERIAL, PRIMARY KEY (c1)) WITH (ORIENTATION=COLUMN, COLVERSION=2.0, ENABLE_DELTA=ON, COMPRESSION=LOW) DISTRIBUTE BY REPLICATION;
CREATE TABLE t72 (c1 SERIAL, c2 SERIAL, PRIMARY KEY (c2, c1)) WITH (ORIENTATION=ROW) DISTRIBUTE BY REPLICATION;
INSERT INTO t71 (c1) VALUES (1);
INSERT INTO t69 (c1) VALUES ('d');
INSERT INTO t69 (c1) VALUES ('S');
INSERT INTO t71 (c1) VALUES (2);
INSERT INTO t69 (c1) VALUES ('P');
INSERT INTO t71 (c1) VALUES (3);
INSERT INTO t70 (c1,c2,c3) VALUES ('{-343070449,1823582248,673752580,-910238253,1998721243}',2515997,'22:34:04');
INSERT INTO t69 (c1) VALUES ('H');
INSERT INTO t70 (c1,c2,c3) VALUES ('{-1581443963,-1547079441,-704907258,-2056970649}',6972054387,'08:21:28');
INSERT INTO t72 (c1,c2) VALUES (1,1);
INSERT INTO t70 (c1,c2,c3) VALUES ('{1961096021,-174362894,1981873003,-1527325667,-72706201,1494644118,-50011519,-694467321}',-9713780844,'13:59:11'), ('{-403795231,-1949312873,713320670}',411,'02:20:01'), ('{-2124999169,198826670,945138232,1069676584,1416748520,455270101,-807197937}',-9162178,'16:47:53');
INSERT INTO t69 (c1) VALUES ('r');
INSERT INTO t70 (c1,c2,c3) VALUES ('{946719164}',-6,'05:26:43'), ('{1060234104,350271867,-482363481,1685929571,-673954378,-82170410}',3197849,'18:41:13'), ('{-810073380,-1769134461,1909345215,-1096722359,394049679,-1093703943,14488353,1666068372,-118217685,-767168436}',8001,'21:33:27');
INSERT INTO t69 (c1) VALUES ('2'), ('Y');
INSERT INTO t71 (c1) VALUES (4);
CREATE INDEX IF NOT EXISTS i68 ON t70 (c1, c2, c3) COMMENT 'text' WITH (INVISIBLE = ON);
CREATE UNIQUE INDEX IF NOT EXISTS i69 ON t72 USING btree (c2, c1) COMMENT 'text';
86
BEGIN;
DELETE FROM t69 WHERE ((92) IS NOT NULL);
SELECT DISTINCT ta2.ca4 AS ca1, c1 AS ca2 FROM (SELECT ALL c2 AS ca3 FROM ONLY t72) AS ta1, (SELECT c1 AS ca4 FROM ONLY t69 WHERE FALSE LIMIT 1611036437, 623481348) AS ta2, ONLY t69 LIMIT ALL OFFSET 357287796 ROWS;
COMMIT;
87
BEGIN;
SELECT DISTINCT ta1.ca2 AS ca1 FROM (SELECT DISTINCT c3 AS ca2, c3 AS ca3, c3 AS ca4 FROM ONLY t70 LIMIT 1326861282, ALL) AS ta1, ONLY t71, (SELECT DISTINCT t69.c1 AS ca5, t70.c1 AS ca6 FROM t69, (SELECT c1 AS ca7 FROM t71 WHERE ((+ c1) IS NOT NULL)) AS ta2, t70 WHERE (t69.c1) NOT LIKE (((encode('FY8Y', 'base64')) :: TEXT) :: TEXT)) AS ta3 LIMIT 1571484544, 92676250;
DELETE FROM ONLY t69;
ROLLBACK WORK;
86-87-87-86-86-86-87-87
-- testcase2，specific type aggregation crash
CREATE TABLE t0(c0 DECIMAL )with(orientation=column, enable_hstore_opt=on);
CREATE TABLE IF NOT EXISTS t3(LIKE t0 including all);
INSERT INTO t3(c0) VALUES(0.13301633700746984);
SELECT ALL CAST(CAST(5.3863776E7 AS MONEY) AS VARCHAR) FROM t3* GROUP BY CAST(0.5983424 AS MONEY);
--testcase3，system column array operation crash
CREATE TABLE t0(c1 int, c2 int)with(orientation=column, enable_hstore_opt=on);
INSERT INTO t0 VALUES (generate_series(1, 200), 5);
SELECT ARRAY[ctid], c1 FROM ONLY t0 a0 WHERE true;
################# test tool bugs:
postgresql-2025-07-08_201805.log:2025-07-08 20:20:27.038996 +2004882 686d0d03.8207 txninfer0 dbadmin TID:139745690321256/139744568694528 LWP:14347 PostgreSQL JDBC Driver XID:0 cn_5001 42883 QUERYID:73464968921512244 [BACKEND] ERROR: function quote_ident() does not exist at character 463
postgresql-2025-07-08_201805.log:2025-07-08 20:20:27.040329 +000060 686d0d03.8207 txninfer0 dbadmin TID:139745690321256/139744568694528 LWP:14347 PostgreSQL JDBC Driver XID:0 cn_5001 00000 QUERYID:73464968921512244 [BACKEND] STATEMENT: SELECT ALL ca11 AS ca1, ta3.ca4 AS ca2, ta5.ca11 AS ca3 FROM (SELECT ca7 AS ca4, ta1.ca7 AS ca5 FROM t3, (SELECT ALL c2 AS ca6, c2 AS ca7, c3 AS ca8 FROM ONLY t1, t3 LIMIT 3391815291, ALL) AS ta1, (SELECT ALL c1 AS ca9, c1 AS ca10 FROM t3 LIMIT 926662796, ALL) ta2 WHERE NOT(NOT((((c1) :: TEXT) IS NULL))) LIMIT 863440116, ALL) ta3, (SELECT DISTINCT ta4.ca12 AS ca11 FROM (SELECT c1 AS ca12 FROM t5 WHERE NOT((((- c1) IS NOT NULL)) AND (FALSE))) AS ta4 WHERE (((quote_ident()) :: TEXT) IS NULL) LIMIT 2184701073, ALL) AS ta5 LIMIT 3787932949
postgresql-2025-07-08_201805.log:2025-07-08 20:20:28.217045 +020953 686d0d0c.8203 txninfer1 dbadmin TID:139745690324336/139744039143168 LWP:14769 PostgreSQL JDBC Driver XID:0 cn_5001 23505 QUERYID:73464968921512462 [ALL] ERROR: dn_6001: duplicate key value violates unique constraint "t6_pkey"
postgresql-2025-07-08_201805.log:2025-07-08 20:20:28.217324 +000016 686d0d0c.8203 txninfer1 dbadmin TID:139745690324336/139744039143168 LWP:14769 PostgreSQL JDBC Driver XID:0 cn_5001 00000 QUERYID:73464968921512462 [BACKEND] STATEMENT: UPDATE ONLY t6 SET c1 = 6517001591106999017 WHERE (224) :: BOOLEAN
postgresql-2025-07-08_202039.log:2025-07-08 20:21:03.738017 +007816 686d0cf6.8212 txninfer0 dbadmin TID:139745690305856/139745044731648 LWP:13874 PostgreSQL JDBC Driver XID:0 cn_5001 42704 QUERYID:73464968921517731 [BACKEND] ERROR: unrecognized configuration parameter "warnings"
postgresql-2025-07-08_202039.log:2025-07-08 20:21:03.738042 +000011 686d0cf6.8212 txninfer0 dbadmin TID:139745690305856/139745044731648 LWP:13874 PostgreSQL JDBC Driver XID:0 cn_5001 42704 QUERYID:73464968921517731 [BACKEND] STATEMENT: SHOW WARNINGS
postgresql-2025-07-08_205554.log:2025-07-08 20:55:56.799197 +004901 686d154a.8207 txninfer5 dbadmin TID:139745690323720/139744018167552 LWP:4526 PostgreSQL JDBC Driver XID:0 cn_5001 0A000 QUERYID:73464968921676383 [BACKEND] ERROR: access method "psort" does not support row store
postgresql-2025-07-08_205554.log:2025-07-08 20:55:57.127409 +004918 686d154a.8207 txninfer5 dbadmin TID:139745690323720/139744018167552 LWP:4526 PostgreSQL JDBC Driver XID:0 cn_5001 42704 QUERYID:73464968921676439 [BACKEND] ERROR: data type integer has no default operator class for access method "cgin"
postgresql-2025-07-08_205846.log:2025-07-08 20:59:02.448717 +002975 686d15bf.8204 txninfer7 dbadmin TID:139745690322488/139744652568320 LWP:9106 PostgreSQL JDBC Driver XID:0 cn_5001 42601 QUERYID:73464968921693876 [BACKEND] ERROR: syntax error at or near "," at character 348
postgresql-2025-07-08_205846.log:2025-07-08 20:59:02.448961 +000048 686d15bf.8204 txninfer7 dbadmin TID:139745690322488/139744652568320 LWP:9106 PostgreSQL JDBC Driver XID:0 cn_5001 00000 QUERYID:73464968921693876 [BACKEND] STATEMENT: SELECT DISTINCT _infer_t23.c2 AS ca1, ta3.ca4 AS ca2, c3 AS ca3 FROM (SELECT ca9 AS ca4, ca8 AS ca5 FROM (SELECT c1 AS ca6 FROM ONLY _infer_t23 LIMIT 495733042, ALL) ta1, (SELECT _infer_t25.c1 AS ca7, c2 AS ca8, _infer_t26.c1 AS ca9 FROM ONLY _infer_t25, _infer_t26 WHERE FALSE LIMIT 212396147, 2741514349) ta2 WHERE NOT(((lpad('n6yq7RqvbwPG2RH5',, 'BH5jUzhgzJcFk8l8Cm')) :: TEXT) NOT LIKE ((((+(-56))) + (degrees(0))) :: TEXT)) LIMIT 51649604, 2975931443) ta3, ONLY _infer_t23, _infer_t25 WHERE TRUE
data type xml has no default operator class for access method "btree"
dn_6002: bigint out of range
dn_6002: cannot take square root of a negative number
numeric field overflow
评论（0）