diff -U3 /tmp/cirrus-ci-build/contrib/cube/expected/cube.out /tmp/cirrus-ci-build/build/testrun/cube/regress/results/cube.out --- /tmp/cirrus-ci-build/contrib/cube/expected/cube.out 2024-03-19 00:05:09.489407000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/cube/regress/results/cube.out 2024-03-19 00:22:30.985592000 +0000 @@ -6,6 +6,7 @@ SELECT amname, opcname FROM pg_opclass opc LEFT JOIN pg_am am ON am.oid = opcmethod WHERE opc.oid >= 16384 AND NOT amvalidate(opc.oid); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree amname | opcname --------+--------- (0 rows) @@ -345,6 +346,7 @@ (1 row) SELECT * FROM pg_input_error_info('-1e-700', 'cube'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree message | detail | hint | sql_error_code -----------------------------------------------------+--------+------+---------------- "-1e-700" is out of range for type double precision | | | 22003 @@ -445,6 +447,7 @@ ERROR: Index out of bounds -- test for limits: this should pass SELECT cube_subset(cube('(6,7,8),(6,7,8)'), array(SELECT 1 as a FROM generate_series(1,100))); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree cube_subset -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- (6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6, 6) @@ -452,6 +455,7 @@ -- and this should fail SELECT cube_subset(cube('(6,7,8),(6,7,8)'), array(SELECT 1 as a FROM generate_series(1,101))); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: array is too long DETAIL: A cube cannot have more than 100 dimensions. -- @@ -539,20 +543,24 @@ DETAIL: A cube cannot have more than 100 dimensions. -- from an array select cube(array(SELECT 0 as a FROM generate_series(1,101))); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: array is too long DETAIL: A cube cannot have more than 100 dimensions. select cube(array(SELECT 0 as a FROM generate_series(1,101)),array(SELECT 0 as a FROM generate_series(1,101))); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: can't extend cube DETAIL: A cube cannot have more than 100 dimensions. -- extend cube beyond limit -- this should work select cube(array(SELECT 0 as a FROM generate_series(1,100))); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree cube -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- (0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) (1 row) select cube(array(SELECT 0 as a FROM generate_series(1,100)),array(SELECT 0 as a FROM generate_series(1,100))); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree cube -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- (0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) @@ -560,9 +568,11 @@ -- this should fail select cube(cube(array(SELECT 0 as a FROM generate_series(1,100))), 0); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: can't extend cube DETAIL: A cube cannot have more than 100 dimensions. select cube(cube(array(SELECT 0 as a FROM generate_series(1,100)),array(SELECT 0 as a FROM generate_series(1,100))), 0, 0); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: can't extend cube DETAIL: A cube cannot have more than 100 dimensions. -- @@ -1582,6 +1592,7 @@ RESET enable_bitmapscan; -- Test kNN INSERT INTO test_cube VALUES ('(1,1)'), ('(100000)'), ('(0, 100000)'); -- Some corner cases +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SET enable_seqscan = false; -- Test different metrics SET extra_float_digits = 0;