diff -U3 /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/compat_informix-sqlda.stderr /tmp/cirrus-ci-build/build/testrun/ecpg/ecpg/results/compat_informix-sqlda.stderr --- /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/compat_informix-sqlda.stderr 2024-03-21 16:29:26.392075000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/ecpg/ecpg/results/compat_informix-sqlda.stderr 2024-03-21 16:48:17.851046000 +0000 @@ -16,10 +16,14 @@ [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_execute on line 82: query: insert into t1 values ( 1 , 'a' , 1.0 , 1 , 'a' ) , ( 2 , null , null , null , null ) , ( 4 , 'd' , 4.0 , 4 , 'd' ); with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 82: using PQexec +[NO_PID]: ECPGnoticeReceiver: outfuncs/readfuncs failed to produce an equal rewritten parse tree [NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: raising sqlcode 0 +[NO_PID]: sqlca: code: 0, state: 01000 +[NO_PID]: ecpg_execute on line 82: using PQexec +[NO_PID]: sqlca: code: 0, state: 01000 [NO_PID]: ecpg_process_output on line 82: OK: INSERT 0 3 -[NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: sqlca: code: 0, state: 01000 [NO_PID]: ECPGtrans on line 88: action "commit"; connection "regress1" [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: prepare_common on line 95: name st_id1; query: "SELECT * FROM t1" diff -U3 /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/pgtypeslib-nan_test.stderr /tmp/cirrus-ci-build/build/testrun/ecpg/ecpg/results/pgtypeslib-nan_test.stderr --- /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/pgtypeslib-nan_test.stderr 2024-03-21 16:29:26.392688000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/ecpg/ecpg/results/pgtypeslib-nan_test.stderr 2024-03-21 16:48:18.076344000 +0000 @@ -10,10 +10,14 @@ [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_execute on line 26: query: insert into nantest1 ( id , d ) values ( 1 , 'nan' :: float8 ) , ( 2 , 'infinity' :: float8 ) , ( 3 , '-infinity' :: float8 ); with 0 parameter(s) on connection ecpg1_regression [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 26: using PQexec +[NO_PID]: ECPGnoticeReceiver: outfuncs/readfuncs failed to produce an equal rewritten parse tree [NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: raising sqlcode 0 +[NO_PID]: sqlca: code: 0, state: 01000 +[NO_PID]: ecpg_execute on line 26: using PQexec +[NO_PID]: sqlca: code: 0, state: 01000 [NO_PID]: ecpg_process_output on line 26: OK: INSERT 0 3 -[NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: sqlca: code: 0, state: 01000 [NO_PID]: ecpg_execute on line 29: query: declare cur cursor for select id , d , d from nantest1; with 0 parameter(s) on connection ecpg1_regression [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_execute on line 29: using PQexec diff -U3 /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/sql-code100.stderr /tmp/cirrus-ci-build/build/testrun/ecpg/ecpg/results/sql-code100.stderr --- /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/sql-code100.stderr 2024-03-21 16:29:26.393534000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/ecpg/ecpg/results/sql-code100.stderr 2024-03-21 16:48:18.362805000 +0000 @@ -110,10 +110,14 @@ [NO_PID]: sqlca: code: 100, state: 02000 [NO_PID]: ecpg_execute on line 41: query: insert into test ( select * from test where index = - 1 ); with 0 parameter(s) on connection ecpg1_regression [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 41: using PQexec +[NO_PID]: ECPGnoticeReceiver: outfuncs/readfuncs failed to produce an equal rewritten parse tree [NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: raising sqlcode 0 +[NO_PID]: sqlca: code: 0, state: 01000 +[NO_PID]: ecpg_execute on line 41: using PQexec +[NO_PID]: sqlca: code: 0, state: 01000 [NO_PID]: ecpg_process_output on line 41: OK: INSERT 0 0 -[NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: sqlca: code: 0, state: 01000 [NO_PID]: raising sqlcode 100 on line 41: no data found on line 41 [NO_PID]: sqlca: code: 100, state: 02000 [NO_PID]: ecpg_execute on line 44: query: drop table test; with 0 parameter(s) on connection ecpg1_regression diff -U3 /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/sql-sqlda.stderr /tmp/cirrus-ci-build/build/testrun/ecpg/ecpg/results/sql-sqlda.stderr --- /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/sql-sqlda.stderr 2024-03-21 16:29:26.394378000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/ecpg/ecpg/results/sql-sqlda.stderr 2024-03-21 16:48:18.452021000 +0000 @@ -16,10 +16,14 @@ [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_execute on line 98: query: insert into t1 values ( 1 , 'a' , 1.0 , 1 , 'a' , 1111111111111111111 ) , ( 2 , null , null , null , null , null ) , ( 3 , 'c' , 0.0 , 3 , 'c' , 3333333333333333333 ) , ( 4 , 'd' , 'NaN' , 4 , 'd' , 4444444444444444444 ) , ( 5 , 'e' , 0.001234 , 5 , 'e' , 5555555555555555555 ); with 0 parameter(s) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 98: using PQexec +[NO_PID]: ECPGnoticeReceiver: outfuncs/readfuncs failed to produce an equal rewritten parse tree [NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: raising sqlcode 0 +[NO_PID]: sqlca: code: 0, state: 01000 +[NO_PID]: ecpg_execute on line 98: using PQexec +[NO_PID]: sqlca: code: 0, state: 01000 [NO_PID]: ecpg_process_output on line 98: OK: INSERT 0 5 -[NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: sqlca: code: 0, state: 01000 [NO_PID]: ECPGtrans on line 106: action "commit"; connection "regress1" [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: prepare_common on line 113: name st_id1; query: "SELECT * FROM t1" diff -U3 /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/sql-execute.stderr /tmp/cirrus-ci-build/build/testrun/ecpg/ecpg/results/sql-execute.stderr --- /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/sql-execute.stderr 2024-03-21 16:29:26.393939000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/ecpg/ecpg/results/sql-execute.stderr 2024-03-21 16:48:18.537512000 +0000 @@ -24,12 +24,20 @@ [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_execute on line 35: query: insert into test (name, amount, letter) select name, amount+10, letter from test; with 0 parameter(s) on connection main [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 35: using PQexec +[NO_PID]: ECPGnoticeReceiver: outfuncs/readfuncs failed to produce an equal rewritten parse tree [NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: raising sqlcode 0 +[NO_PID]: sqlca: code: 0, state: 01000 +[NO_PID]: ecpg_execute on line 35: using PQexec +[NO_PID]: sqlca: code: 0, state: 01000 [NO_PID]: ecpg_process_output on line 35: OK: INSERT 0 2 +[NO_PID]: sqlca: code: 0, state: 01000 +[NO_PID]: ECPGnoticeReceiver: outfuncs/readfuncs failed to produce an equal rewritten parse tree [NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: raising sqlcode 0 +[NO_PID]: sqlca: code: 0, state: 01000 [NO_PID]: prepare_common on line 40: name i; query: "insert into test (name, amount, letter) select name, amount+$1, letter from test" -[NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: sqlca: code: 0, state: 01000 [NO_PID]: ecpg_execute on line 41: query: insert into test (name, amount, letter) select name, amount+$1, letter from test; with 1 parameter(s) on connection main [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_execute on line 41: using PQexecPrepared for "insert into test (name, amount, letter) select name, amount+$1, letter from test" diff -U3 /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/sql-oldexec.stderr /tmp/cirrus-ci-build/build/testrun/ecpg/ecpg/results/sql-oldexec.stderr --- /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/sql-oldexec.stderr 2024-03-21 16:29:26.394143000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/ecpg/ecpg/results/sql-oldexec.stderr 2024-03-21 16:48:18.614018000 +0000 @@ -24,12 +24,20 @@ [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_execute on line 36: query: insert into test (name, amount, letter) select name, amount+10, letter from test; with 0 parameter(s) on connection main [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 36: using PQexec +[NO_PID]: ECPGnoticeReceiver: outfuncs/readfuncs failed to produce an equal rewritten parse tree [NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: raising sqlcode 0 +[NO_PID]: sqlca: code: 0, state: 01000 +[NO_PID]: ecpg_execute on line 36: using PQexec +[NO_PID]: sqlca: code: 0, state: 01000 [NO_PID]: ecpg_process_output on line 36: OK: INSERT 0 2 +[NO_PID]: sqlca: code: 0, state: 01000 +[NO_PID]: ECPGnoticeReceiver: outfuncs/readfuncs failed to produce an equal rewritten parse tree [NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: raising sqlcode 0 +[NO_PID]: sqlca: code: 0, state: 01000 [NO_PID]: prepare_common on line 41: name i; query: "insert into test (name, amount, letter) select name, amount+$1, letter from test" -[NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: sqlca: code: 0, state: 01000 [NO_PID]: ecpg_execute on line 42: query: insert into test (name, amount, letter) select name, amount+$1, letter from test; with 1 parameter(s) on connection main [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_execute on line 42: using PQexecPrepared for "insert into test (name, amount, letter) select name, amount+$1, letter from test" diff -U3 /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/sql-sqljson.stderr /tmp/cirrus-ci-build/build/testrun/ecpg/ecpg/results/sql-sqljson.stderr --- /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/sql-sqljson.stderr 2024-03-21 16:29:26.394437000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/ecpg/ecpg/results/sql-sqljson.stderr 2024-03-21 16:48:18.663106000 +0000 @@ -248,25 +248,29 @@ SQL error: cannot use RETURNING type jsonb in JSON_SERIALIZE() on line 99 [NO_PID]: ecpg_execute on line 102: query: with val ( js ) as ( values ( '{ "a": 1, "b": [{ "a": 1, "b": 0, "a": 2 }] }' ) ) select js is json "IS JSON" , js is not json "IS NOT JSON" , js is json value "IS VALUE" , js is json object "IS OBJECT" , js is json array "IS ARRAY" , js is json scalar "IS SCALAR" , js is json without unique keys "WITHOUT UNIQUE" , js is json with unique keys "WITH UNIQUE" from val; with 0 parameter(s) on connection ecpg1_regression [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 102: using PQexec +[NO_PID]: ECPGnoticeReceiver: outfuncs/readfuncs failed to produce an equal rewritten parse tree [NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: raising sqlcode 0 +[NO_PID]: sqlca: code: 0, state: 01000 +[NO_PID]: ecpg_execute on line 102: using PQexec +[NO_PID]: sqlca: code: 0, state: 01000 [NO_PID]: ecpg_process_output on line 102: correctly got 1 tuples with 8 fields -[NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: sqlca: code: 0, state: 01000 [NO_PID]: ecpg_get_data on line 102: RESULT: t offset: -1; array: no -[NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: sqlca: code: 0, state: 01000 [NO_PID]: ecpg_get_data on line 102: RESULT: f offset: -1; array: no -[NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: sqlca: code: 0, state: 01000 [NO_PID]: ecpg_get_data on line 102: RESULT: t offset: -1; array: no -[NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: sqlca: code: 0, state: 01000 [NO_PID]: ecpg_get_data on line 102: RESULT: t offset: -1; array: no -[NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: sqlca: code: 0, state: 01000 [NO_PID]: ecpg_get_data on line 102: RESULT: f offset: -1; array: no -[NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: sqlca: code: 0, state: 01000 [NO_PID]: ecpg_get_data on line 102: RESULT: f offset: -1; array: no -[NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: sqlca: code: 0, state: 01000 [NO_PID]: ecpg_get_data on line 102: RESULT: t offset: -1; array: no -[NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: sqlca: code: 0, state: 01000 [NO_PID]: ecpg_get_data on line 102: RESULT: f offset: -1; array: no -[NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: sqlca: code: 0, state: 01000 [NO_PID]: ecpg_finish: connection ecpg1_regression closed [NO_PID]: sqlca: code: 0, state: 00000 diff -U3 /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/sql-parser.stderr /tmp/cirrus-ci-build/build/testrun/ecpg/ecpg/results/sql-parser.stderr --- /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/sql-parser.stderr 2024-03-21 16:29:26.394187000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/ecpg/ecpg/results/sql-parser.stderr 2024-03-21 16:48:18.696517000 +0000 @@ -12,10 +12,15 @@ [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_execute on line 22: query: insert into t select 1 , nullif ( y - 1 , 0 ) from generate_series ( 1 , 3 ) with ordinality as series ( x , y ); with 0 parameter(s) on connection ecpg1_regression [NO_PID]: sqlca: code: 0, state: 00000 -[NO_PID]: ecpg_execute on line 22: using PQexec +[NO_PID]: ECPGnoticeReceiver: outfuncs/readfuncs failed to produce an equal rewritten parse tree [NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: raising sqlcode 0 +[NO_PID]: sqlca: code: 0, state: 01000 +[NO_PID]: ecpg_execute on line 22: using PQexec +[NO_PID]: sqlca: code: 0, state: 01000 [NO_PID]: ecpg_process_output on line 22: OK: INSERT 0 3 -[NO_PID]: sqlca: code: 0, state: 00000 +[NO_PID]: sqlca: code: 0, state: 01000 +SQL error: outfuncs/readfuncs failed to produce an equal rewritten parse tree [NO_PID]: ecpg_execute on line 26: query: select Item2 from T order by Item2 nulls last; with 0 parameter(s) on connection ecpg1_regression [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_execute on line 26: using PQexec