issue-20251022

[mppdb@ecs-8869-0009 gaussdb-transaction]$ /usr/local/java/jdk-11.0.8/bin/java -jar ./DBMSForge.jar ./config/gaussdb/gaussdbconfig_transaction_reproduce.yaml 
Starting to test gaussdb, using oracle: TRANSACTION_INFER_REPRODUCE
com.huawei.gauss200.jdbc.util.PSQLException: ERROR: syntax error at or near "86"
  Position: 1
Overall execution statistics (DBMS: gaussdb, Oracle: TRANSACTION_INFER_REPRODUCE)
============================================================
           0 queries
           1 databases
           0 successfully-executed statements
           0 unsuccessfully-executed statements
           0 successfully-executed test cases
           0 unsuccessfully-executed test cases
Total runtime: 2 seconds

[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-0, 87-0, 87-1, 86-1, 86-2, 86-3, 87-2, 87-3
END