compose: TestComposeCompare failed

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.

https://www.cockroachlabs.com

Other

29.85k stars 3.77k forks source link

compose: TestComposeCompare failed #113814

Closed cockroach-teamcity closed 9 months ago

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 135acce473babb0109e796343581823b69146ebe:

        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_13491.col_22223 AS col_22224
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (6.0::FLOAT8::FLOAT8),
        test_1        |                                 (5.0::FLOAT8::FLOAT8),
        test_1        |                                 (asinh(NULL::FLOAT8::FLOAT8)::FLOAT8),
        test_1        |                                 (5.0::FLOAT8::FLOAT8)
        test_1        |                         )
        test_1        |                             AS tab_13491 (col_22223)
        test_1        |                 )
        test_1        |                     AS tab_13492
        test_1        |             ORDER BY
        test_1        |                 col_22224;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_13491.col_22223 AS col_22224
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (6.0:::FLOAT8::FLOAT8),
        test_1        |                                 (5.0:::FLOAT8::FLOAT8),
        test_1        |                                 (asinh(NULL::FLOAT8::FLOAT8)::FLOAT8),
        test_1        |                                 (5.0:::FLOAT8::FLOAT8)
        test_1        |                         )
        test_1        |                             AS tab_13491 (col_22223)
        test_1        |                 )
        test_1        |                     AS tab_13492
        test_1        |             ORDER BY
        test_1        |                 col_22224;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (648.39s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

- #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #111157 compose: TestComposeCompare failed [C-test-failure FROZEN.branch-release-23.1.11-rc O-robot O-rsg T-sql-queries] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-33173

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 135acce473babb0109e796343581823b69146ebe:

        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_32756.col_65557 AS col_65558
        test_1        |                     FROM
        test_1        |                         (VALUES (NULL::INTERVAL), ('00:00:05'::INTERVAL::INTERVAL), ('00:00:08'::INTERVAL::INTERVAL))
        test_1        |                             AS tab_32756 (col_65557)
        test_1        |                     ORDER BY
        test_1        |                         tab_32756.col_65557 ASC NULLS FIRST, tab_32756.col_65557 NULLS LAST
        test_1        |                 )
        test_1        |                     AS tab_32757
        test_1        |             ORDER BY
        test_1        |                 col_65558 DESC;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_32756.col_65557 AS col_65558
        test_1        |                     FROM
        test_1        |                         (VALUES (NULL::INTERVAL), ('00:00:05':::INTERVAL::INTERVAL), ('00:00:08':::INTERVAL::INTERVAL))
        test_1        |                             AS tab_32756 (col_65557)
        test_1        |                     ORDER BY
        test_1        |                         tab_32756.col_65557 ASC NULLS FIRST, tab_32756.col_65557 NULLS LAST
        test_1        |                 )
        test_1        |                     AS tab_32757
        test_1        |             ORDER BY
        test_1        |                 col_65558 DESC;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.42s)
        test_1        |         compare_test.go:126: starting test: mutators
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:157: CREATE TABLE table3 (col3_0 INET NOT NULL, col3_1 FLOAT8 NOT NULL, col3_2 VARCHAR NOT NULL, col3_3 INT4 NOT NULL, col3_4 INTERVAL, col3_5 BYTES NOT NULL, col3_6 INTERVAL NOT NULL, col3_7 BOX2D NOT NULL, col3_8 BYTES NOT NULL, col3_9 OID NOT NULL, col3_10 BIT(21) NULL, col3_11 GEOMETRY NOT NULL, col3_12 FLOAT4 NOT NULL, col3_13 DATE NULL, col3_14 STRING AS (CASE WHEN col3_4 IS NULL THEN NULL ELSE e'\x11[<4\x1b':::STRING END) VIRTUAL, PRIMARY KEY (col3_1 DESC, col3_3 ASC, col3_7 ASC, col3_9 DESC), INDEX (col3_9 DESC, col3_13 DESC, col3_7 ASC, col3_12, col3_14 DESC) STORING (col3_0, col3_2, col3_4, col3_5, col3_8, col3_10) WHERE ((table3.col3_12 != 'NaN':::FLOAT8) OR (table3.col3_2 >= 'X':::STRING)) AND (table3.col3_3 = 127:::INT8), INDEX (col3_5 ASC, col3_6, col3_4 ASC, col3_10 ASC, col3_2, col3_13 DESC, col3_1 DESC, col3_0, lower(CAST(col3_7 AS STRING)) ASC, col3_9 ASC, col3_3 ASC) STORING (col3_8), UNIQUE (col3_7, (CASE WHEN col3_4 IS NULL THEN e'icXX\x04g\nK\x1c':::STRING ELSE e']J\x10M\x06~R':::STRING END) DESC, col3_14 ASC, col3_3 DESC, col3_0, col3_10 DESC, col3_6 ASC, col3_13 ASC, col3_9 DESC, col3_5 DESC, col3_12 DESC, col3_2 DESC, col3_8 DESC, col3_4) PARTITION BY LIST (col3_7) (PARTITION table3_part_0 VALUES IN (('BOX(-1.8996458335899202 -1.189438477886754,1.5576689718974746 0.011963674994766915)':::BOX2D,), ('BOX(-10 -10,10 10)':::BOX2D,), ('BOX(0.48701061721538264 -0.6926929765523798,1.1604295363954495 1.0449926317010054)':::BOX2D,), ('BOX(-0.5943243279400543 -0.40897750076234923,0.08887007479386677 0.8509532101023964)':::BOX2D,), ('BOX(-1.0001909658949213 -0.36034535181494254,-0.5136073273641097 0.6196986825233988)':::BOX2D,), ('BOX(-0.6817329929627247 -1.287917697297943,-0.3310340413081883 0.11369016014574546)':::BOX2D,), ('BOX(-0.861123816259042 -2.6171850209920016,-0.5048400637688369 0.8982424506397299)':::BOX2D,), ('BOX(-2.07903383927109 -1.274133722614141,0.1644833702381127 1.2897956756795215)':::BOX2D,), ('BOX(0.6144743139652631 -0.8667034996952769,1.73051399613718 1.8122071711145673)':::BOX2D,), ('BOX(-0.8288725027526525 -0.9218293087652615,1.4764998795463642 0.7160444919644324)':::BOX2D,)), PARTITION "DEFAULT" VALUES IN ((DEFAULT,))), INDEX (col3_12 ASC, col3_4 ASC, col3_9 DESC, col3_0, col3_7) STORING (col3_2, col3_5, col3_6, col3_8, col3_11, col3_13) PARTITION BY LIST (col3_12) (PARTITION table3_part_0 VALUES IN (((-0.6621426939964294):::FLOAT8,), ((-0.20133119821548462):::FLOAT8,), ((-0.6385779976844788):::FLOAT8,), ((-0.6129680275917053):::FLOAT8,), (0.7176252603530884:::FLOAT8,), ((-0.7886047959327698):::FLOAT8,), ((-0.029506098479032516):::FLOAT8,), ((-2.100295305252075):::FLOAT8,)), PARTITION table3_part_1 VALUES IN (((-0.4605267345905304):::FLOAT8,), ((-0.64680415391922):::FLOAT8,), (0.011549250222742558:::FLOAT8,), (0.9307316541671753:::FLOAT8,), ((-0.8324136137962341):::FLOAT8,), ((-0.9085146188735962):::FLOAT8,), (0.31035536527633667:::FLOAT8,), ((-0.9716839790344238):::FLOAT8,)), PARTITION table3_part_2 VALUES IN (((-0.18100209534168243):::FLOAT8,), (0.1748587042093277:::FLOAT8,), ((-2.4023172855377197):::FLOAT8,), (0.67168128490448:::FLOAT8,), ((-0.3968650698661804):::FLOAT8,), ((-1.3832759857177734):::FLOAT8,), (1.0:::FLOAT8,), ((-1.290611982345581):::FLOAT8,)), PARTITION table3_part_3 VALUES IN ((0.014159012585878372:::FLOAT8,), ((-2.503978729248047):::FLOAT8,), ((-0.7141995429992676):::FLOAT8,), ((-0.7172301411628723):::FLOAT8,), ((-0.42250460386276245):::FLOAT8,), ((-1.002611517906189):::FLOAT8,), ((-0.5971670746803284):::FLOAT8,), ((-0.24944747984409332):::FLOAT8,)), PARTITION table3_part_4 VALUES IN ((0.32516443729400635:::FLOAT8,), ((-1.5062326192855835):::FLOAT8,), ((-1.291641116142273):::FLOAT8,), (1.401298464324817e-45:::FLOAT8,), (0.6932903528213501:::FLOAT8,), ((-0.5692518949508667):::FLOAT8,), (0.4033709168434143:::FLOAT8,), (1.6160862445831299:::FLOAT8,)), PARTITION table3_part_5 VALUES IN (((-0.8793397545814514):::FLOAT8,), (0.8943597674369812:::FLOAT8,), ((-0.7349891662597656):::FLOAT8,), ((-1.7740882635116577):::FLOAT8,), ((-0.3306620121002197):::FLOAT8,), ((-0.24983049929141998):::FLOAT8,), ((-0.7315473556518555):::FLOAT8,), ((-0.20291045308113098):::FLOAT8,)), PARTITION table3_part_6 VALUES IN (((-0.4763046205043793):::FLOAT8,), (0.9500002861022949:::FLOAT8,), (0.21405592560768127:::FLOAT8,), ((-0.2751708924770355):::FLOAT8,), (0.0:::FLOAT8,), (1.6857879161834717:::FLOAT8,), ((-0.12071477621793747):::FLOAT8,), ((-0.2619031071662903):::FLOAT8,)), PARTITION table3_part_7 VALUES IN ((0.05404258891940117:::FLOAT8,), (2.2442092895507812:::FLOAT8,), (0.1731470376253128:::FLOAT8,), ((-0.7697845697402954):::FLOAT8,), (1.584816575050354:::FLOAT8,), ((-0.3174867331981659):::FLOAT8,), (1.3878264427185059:::FLOAT8,), ((-1.1724311113357544):::FLOAT8,)), PARTITION table3_part_8 VALUES IN ((0.12307500839233398:::FLOAT8,), (0.2585725486278534:::FLOAT8,), ((-1.0969796180725098):::FLOAT8,), ((-0.5349792242050171):::FLOAT8,), ((-0.03237592801451683):::FLOAT8,), ((-1.8346285820007324):::FLOAT8,), (0.06396644562482834:::FLOAT8,), (0.05336027219891548:::FLOAT8,)), PARTITION table3_part_9 VALUES IN (((-1.3943272829055786):::FLOAT8,), (0.4459216296672821:::FLOAT8,), ((-0.4587530195713043):::FLOAT8,), ((-0.896481990814209):::FLOAT8,), (0.4892887473106384:::FLOAT8,), (1.0264110565185547:::FLOAT8,), ((-0.8252577185630798):::FLOAT8,), ((-0.11878287047147751):::FLOAT8,))) WHERE (((((((table3.col3_1 <= 0.0:::FLOAT8) AND (table3.col3_13 > '5874897-12-31':::DATE)) OR (table3.col3_12 < '+Inf':::FLOAT8)) OR (table3.col3_14 <= '"':::STRING)) AND (table3.col3_2 > e'\U00002603':::STRING)) AND (table3.col3_3 >= (-1):::INT8)) OR (table3.col3_8 <= '\xe29883':::BYTES)) AND (table3.col3_5 >= '\x58':::BYTES), INDEX (col3_12 DESC) STORING (col3_0, col3_6, col3_11, col3_13), UNIQUE (col3_1 DESC, col3_4 DESC, col3_6 DESC, lower(CAST(col3_11 AS STRING)) DESC, col3_12 ASC) STORING (col3_2, col3_5, col3_8, col3_10, col3_11, col3_13) PARTITION BY LIST (col3_1, col3_4) (PARTITION table3_part_0 VALUES IN ((2.055313278913118:::FLOAT8, '-37 years -8 mons -273 days -12:48:49.109903':::INTERVAL), ((-0.008970987320005008):::FLOAT8, '-20 years -1 mons -833 days -13:14:59.221169':::INTERVAL), (0.038458081012243656:::FLOAT8, '-72 years -3 mons -65 days -00:21:06.342973':::INTERVAL), ((-0.8147421202809106):::FLOAT8, '00:00:00':::INTERVAL), ((-1.0297756865388723):::FLOAT8, '51 years 11 mons 343 days 19:22:21.956852':::INTERVAL), (0.27627509362082636:::FLOAT8, '1 mon 1 day':::INTERVAL), (0.025730803082925524:::FLOAT8, '6 years 11 mons 806 days 24:29:21.10986':::INTERVAL), (0.30021538125040437:::FLOAT8, '-31 years -8 mons -615 days -04:01:40.525469':::INTERVAL), (5e-324:::FLOAT8, '32 years 8 mons 179 days 03:19:40.027293':::INTERVAL), (1.0:::FLOAT8, '62 years 10 mons 666 days 09:31:15.277194':::INTERVAL)), PARTITION table3_part_1 VALUES IN (((-1.1473692976381233):::FLOAT8, '14 years 5 mons 799 days 00:42:58.389642':::INTERVAL), (0.14676976797920632:::FLOAT8, '18 years 3 mons 813 days 02:56:45.942736':::INTERVAL), ((-0.7348661362140982):::FLOAT8, '31 years 11 mons 875 days 12:13:54.27739':::INTERVAL), ((-1.6075369554544081):::FLOAT8, '48 years 6 mons 974 days 19:43:13.151757':::INTERVAL), ((-1.7441013784230375):::FLOAT8, '15 years 2 mons 907 days 07:37:12.290867':::INTERVAL), ((-1.2629497254204303):::FLOAT8, '-64 years -6 mons -626 days -05:52:32.908376':::INTERVAL), (0.418184387509447:::FLOAT8, '74 years 11 mons 716 days 16:49:54.136392':::INTERVAL), ((-0.9222906783357379):::FLOAT8, '-12 years -4 mons -636 days -11:22:40.811041':::INTERVAL), (0.0:::FLOAT8, '26 years 7 mons 686 days 09:14:04.156463':::INTERVAL), ((-0.6465766675067599):::FLOAT8, '-34 years -121 days -03:15:50.25701':::INTERVAL)), PARTITION table3_part_2 VALUES IN (((-0.5483760455148461):::FLOAT8, '27 years 3 mons 870 days 22:55:25.094442':::INTERVAL), ((-0.3448414434629843):::FLOAT8, '72 years 6 mons 384 days 06:05:16.787749':::INTERVAL), ((-0.6631108411179829):::FLOAT8, '-25 years -10 mons -749 days -19:59:00.311413':::INTERVAL), ((-1.3218787407358823):::FLOAT8, '-79 years -11 mons -515 days -19:58:16.056521':::INTERVAL), ((-0.813656926957737):::FLOAT8, '-62 years -5 mons -89 days -11:59:57.708263':::INTERVAL), (0.6439380363931058:::FLOAT8, '55 years 2 mons 1 day 13:34:25.929651':::INTERVAL), (0.6640435499927443:::FLOAT8, '57 years 7 mons 196 days 07:20:33.862972':::INTERVAL), ((-0.10100541924513762):::FLOAT8, '31 years 11 mons 546 days 19:52:20.521585':::INTERVAL), (0.9931536365012836:::FLOAT8, '8 years 11 mons 624 days 00:14:27.806463':::INTERVAL), ((-0.2923974101055501):::FLOAT8, '-82 years -1 mons -465 days -21:00:21.910499':::INTERVAL)), PARTITION table3_part_3 VALUES IN (((-1.4104979368079327):::FLOAT8, '-1 years -5 mons -703 days -19:40:43.258405':::INTERVAL), (0.5015092869645414:::FLOAT8, '-30 years -7 mons -693 days -08:34:31.781936':::INTERVAL), ((-1.1186098174119712):::FLOAT8, '-28 years -711 days -21:29:27.944546':::INTERVAL), ((-0.5867475038970638):::FLOAT8, '8 mons 188 days 04:08:31.514796':::INTERVAL), (1.2850162147648845:::FLOAT8, '-18 years -2 mons -649 days -16:29:54.538734':::INTERVAL), ((-0.36409656318642175):::FLOAT8, '-74 years -7 mons -728 days -23:23:53.000459':::INTERVAL), (2.4236297492529912:::FLOAT8, '66 years 5 mons 418 days 09:09:39.436714':::INTERVAL), (1.0:::FLOAT8, '-43 years -6 mons -736 days -22:33:15.555826':::INTERVAL), (1.7976931348623157e+308:::FLOAT8, '-18 years -4 mons -434 days -24:36:22.743508':::INTERVAL), ((-0.3882383730636505):::FLOAT8, '00:00:00':::INTERVAL)), PARTITION "DEFAULT" VALUES IN ((DEFAULT, DEFAULT))))
        test_1        |         compare_test.go:158: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=5f0114d4-d3a4-4aae-b093-55be80ad9916 for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (77.89s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 135acce473babb0109e796343581823b69146ebe:

        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 ('\x41':::BYTES::BYTES),
        test_1        |                                 ('\x48':::BYTES::BYTES),
        test_1        |                                 (('\x4a':::BYTES::BYTES::BYTES || NULL::BYTES::BYTES)::BYTES),
        test_1        |                                 ('\x41':::BYTES::BYTES)
        test_1        |                         )
        test_1        |                             AS tab_3587 (col_5606)
        test_1        |                     ORDER BY
        test_1        |                         tab_3587.col_5606 NULLS LAST, tab_3587.col_5606, tab_3587.col_5606 DESC NULLS LAST
        test_1        |                 )
        test_1        |                     AS tab_3588
        test_1        |             ORDER BY
        test_1        |                 col_5607;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_3587.col_5606 AS col_5607
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 ('\x41'::BYTEA::BYTEA),
        test_1        |                                 ('\x48'::BYTEA::BYTEA),
        test_1        |                                 (('\x4a'::BYTEA::BYTEA::BYTEA || NULL::BYTEA::BYTEA)::BYTEA),
        test_1        |                                 ('\x41'::BYTEA::BYTEA)
        test_1        |                         )
        test_1        |                             AS tab_3587 (col_5606)
        test_1        |                     ORDER BY
        test_1        |                         tab_3587.col_5606 NULLS LAST, tab_3587.col_5606, tab_3587.col_5606 DESC NULLS LAST
        test_1        |                 )
        test_1        |                     AS tab_3588
        test_1        |             ORDER BY
        test_1        |                 col_5607;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (633.83s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

- #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 135acce473babb0109e796343581823b69146ebe:

        test_1        |                     SELECT
        test_1        |                         tab_31514.col_56377 AS col_56379, tab_31514.col_56378 AS col_56380, tab_31514.col_56376 AS col_56381
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (NULL::GEOGRAPHY, NULL::CHAR, 3.0::FLOAT8::FLOAT8),
        test_1        |                                 (NULL::GEOGRAPHY, 'G'::TEXT::CHAR, NULL::FLOAT8)
        test_1        |                         )
        test_1        |                             AS tab_31514 (col_56376, col_56377, col_56378)
        test_1        |                 )
        test_1        |                     AS tab_31515
        test_1        |             ORDER BY
        test_1        |                 col_56379, col_56380 DESC NULLS FIRST, col_56381 ASC NULLS LAST;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_31514.col_56377 AS col_56379, tab_31514.col_56378 AS col_56380, tab_31514.col_56376 AS col_56381
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (NULL::GEOGRAPHY, NULL::CHAR, 3.0:::FLOAT8::FLOAT8),
        test_1        |                                 (NULL::GEOGRAPHY, 'G':::STRING::CHAR, NULL::FLOAT8)
        test_1        |                         )
        test_1        |                             AS tab_31514 (col_56376, col_56377, col_56378)
        test_1        |                 )
        test_1        |                     AS tab_31515
        test_1        |             ORDER BY
        test_1        |                 col_56379, col_56380 DESC NULLS FIRST, col_56381 ASC NULLS LAST;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.31s)
        test_1        |         compare_test.go:126: starting test: mutators
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:157: CREATE TABLE table1 (col1_0 CHAR NOT NULL, col1_1 REGCLASS, col1_2 TIMETZ NOT NULL, col1_3 BIT(28) NOT NULL, col1_4 TIME NOT NULL, col1_5 BIT(10) NOT NULL, col1_6 DATE NOT NULL, col1_7 FLOAT8 NOT NULL, PRIMARY KEY (col1_5 DESC, col1_4 ASC, col1_6, col1_3 DESC, col1_7 DESC), INDEX (col1_3 DESC), INDEX (col1_7, col1_0 ASC, col1_4 DESC, col1_1 DESC), INDEX ((CASE WHEN col1_1 IS NULL THEN 'Mq':::STRING ELSE e'\'':::STRING END) DESC, (col1_7 + (-0.13647084120024822):::FLOAT8), lower(CAST(col1_4 AS STRING)) DESC, col1_6 DESC, col1_5 ASC, col1_4, col1_0, col1_1 ASC), INDEX (col1_3, col1_1 DESC, col1_4 ASC, col1_0 ASC, col1_7, col1_2), INDEX ((CASE WHEN col1_6 IS NULL THEN e'\x03':::STRING ELSE 'z?':::STRING END), col1_6, col1_5 DESC) STORING (col1_1, col1_2) WHERE ((((table1.col1_6 != '5874897-12-31':::DATE) OR (table1.col1_2 = '24:00:00-15:59:00':::TIMETZ)) OR (table1.col1_4 >= '24:00:00':::TIME)) OR (table1.col1_7 < 5e-324:::FLOAT8)) OR (table1.col1_0 != e'\U00002603':::STRING), UNIQUE (col1_3 ASC, col1_6 DESC, col1_0, col1_4, (CASE WHEN col1_1 IS NULL THEN e'O\x19':::STRING ELSE e'f/\x01iB7':::STRING END) DESC, col1_1 DESC), UNIQUE (col1_1) STORING (col1_2) WHERE ((((table1.col1_4 > '24:00:00':::TIME) OR (table1.col1_2 = '24:00:00-15:59:00':::TIMETZ)) OR (table1.col1_7 < '-Inf':::FLOAT8)) OR (table1.col1_6 >= '1970-01-01':::DATE)) OR (table1.col1_0 != '':::STRING), UNIQUE (col1_6, col1_0) STORING (col1_2) PARTITION BY LIST (col1_6, col1_0) (PARTITION table1_part_0 VALUES IN (('1994-05-08':::DATE, 'S':::STRING)), PARTITION table1_part_1 VALUES IN (('1990-12-26':::DATE, e'\x1e':::STRING)), PARTITION table1_part_2 VALUES IN (('1981-08-25':::DATE, 'J':::STRING)), PARTITION table1_part_3 VALUES IN (('1976-04-28':::DATE, '^':::STRING)), PARTITION table1_part_4 VALUES IN (('1982-12-06':::DATE, e'\U00002603':::STRING)), PARTITION table1_part_5 VALUES IN (('1977-07-15':::DATE, 'F':::STRING)), PARTITION "DEFAULT" VALUES IN ((DEFAULT, DEFAULT))), INDEX (col1_4 ASC, col1_5, col1_7 ASC, col1_6, col1_1 ASC, col1_0, col1_3) STORING (col1_2), FAMILY (col1_2), FAMILY (col1_3, col1_4, col1_7), FAMILY (col1_1), FAMILY (col1_5, col1_6, col1_0))
        test_1        |         compare_test.go:158: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=3a86ce1c-9f38-4f81-9022-9f0052bd38dc for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (67.62s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

- #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 272d49bece0b5debdde6e5b537c50a1314b389d2:

        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_14215.col_22817 AS col_22818
        test_1        |                     FROM
        test_1        |                         (VALUES (4:::INT8::INT8), (NULL::INT8), (7:::INT8::INT8), (9:::INT8::INT8), (6:::INT8::INT8), (NULL::INT8))
        test_1        |                             AS tab_14215 (col_22817)
        test_1        |                     ORDER BY
        test_1        |                         tab_14215.col_22817 NULLS FIRST, tab_14215.col_22817 ASC NULLS FIRST
        test_1        |                 )
        test_1        |                     AS tab_14216
        test_1        |             ORDER BY
        test_1        |                 col_22818 ASC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_14215.col_22817 AS col_22818
        test_1        |                     FROM
        test_1        |                         (VALUES (4::INT8::INT8), (NULL::INT8), (7::INT8::INT8), (9::INT8::INT8), (6::INT8::INT8), (NULL::INT8))
        test_1        |                             AS tab_14215 (col_22817)
        test_1        |                     ORDER BY
        test_1        |                         tab_14215.col_22817 NULLS FIRST, tab_14215.col_22817 ASC NULLS FIRST
        test_1        |                 )
        test_1        |                     AS tab_14216
        test_1        |             ORDER BY
        test_1        |                 col_22818 ASC;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.24s)
        test_1        |         compare_test.go:126: starting test: mutators
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:157: CREATE TABLE table1 (col1_0 FLOAT8 NULL, col1_1 INT8 NOT NULL, col1_2 INT8 NOT NULL, col1_3 TIMESTAMPTZ NOT NULL, col1_4 STRING NOT NULL, col1_5 TIMETZ NULL, col1_6 STRING COLLATE de_DE NOT NULL, col1_7 TIMESTAMP, col1_8 STRING NOT NULL AS (lower(CAST(col1_6 AS STRING))) VIRTUAL, col1_9 INT8 NOT NULL AS (col1_2 + 8864541394488415288:::INT8) STORED, col1_10 STRING NOT NULL AS (lower(col1_4)) STORED, col1_11 INT8 NOT NULL AS (col1_1 + col1_2) VIRTUAL, PRIMARY KEY (col1_8 DESC, col1_3 ASC, col1_9 DESC, col1_6 DESC), UNIQUE (col1_3 ASC, col1_1 DESC, (col1_0 + 0.22713919000659805:::FLOAT8) ASC, col1_5 DESC, col1_6 ASC, col1_7 ASC, col1_4, lower(CAST(col1_6 AS STRING)) ASC, col1_10 ASC, col1_0) STORING (col1_2) WHERE (table1.col1_10 < e'\U00002603':::STRING) AND (table1.col1_5 = '24:00:00-15:59:00':::TIMETZ), UNIQUE (col1_10 DESC, col1_3 ASC, col1_6 ASC, col1_7 DESC, col1_8 ASC, col1_9 DESC, col1_5 DESC, col1_4 ASC) WHERE (table1.col1_10 > 'X':::STRING) AND (table1.col1_4 < 'X':::STRING), INDEX (col1_6 DESC) WHERE (((((((((table1.col1_7 < '3000-01-01 00:00:00':::TIMESTAMP) OR (table1.col1_8 >= '':::STRING)) AND (table1.col1_11 < 32767:::INT8)) AND (table1.col1_5 >= '24:00:00-15:59:00':::TIMETZ)) AND (table1.col1_10 < '':::STRING)) AND (table1.col1_1 != (-32768):::INT8)) AND (table1.col1_2 >= 32767:::INT8)) AND (table1.col1_3 < '294276-12-31 23:59:59.999999+00:00':::TIMESTAMPTZ)) AND (table1.col1_0 >= (-1.0):::FLOAT8)) OR (table1.col1_9 = 2147483647:::INT8), UNIQUE (col1_9 ASC), UNIQUE (col1_7, (col1_1 + col1_2), col1_4 DESC, col1_11 ASC, col1_9 DESC, col1_8 DESC, (CASE WHEN col1_7 IS NULL THEN '*d#ARIQM':::STRING ELSE e'``\f':::STRING END), col1_3 ASC) PARTITION BY LIST (col1_7) (PARTITION table1_part_0 VALUES IN (('1987-01-03 10:02:17.000414':::TIMESTAMP,), ('2005-03-24 09:27:33.000841':::TIMESTAMP,), ('1970-01-04 19:56:53.000655':::TIMESTAMP,)), PARTITION table1_part_1 VALUES IN (('1973-10-06 04:58:00.000212':::TIMESTAMP,), ('1988-12-28 07:34:53.000372':::TIMESTAMP,), ('1970-03-30 22:53:47.000931':::TIMESTAMP,)), PARTITION table1_part_2 VALUES IN (('2029-09-07 18:38:27.000103':::TIMESTAMP,), ('1999-06-14 00:38:47.000261':::TIMESTAMP,), ('2020-08-09 15:37:21.000093':::TIMESTAMP,)), PARTITION table1_part_3 VALUES IN (('1998-04-09 10:48:04.000516':::TIMESTAMP,), ('2014-01-02 05:39:34.000199':::TIMESTAMP,), ('2016-07-08 07:58:56.000008':::TIMESTAMP,)), PARTITION table1_part_4 VALUES IN (('-4713-11-24 00:00:00':::TIMESTAMP,), ('2014-11-11 03:43:12.000213':::TIMESTAMP,), ('0001-01-01 00:00:00':::TIMESTAMP,)), PARTITION table1_part_5 VALUES IN (('1999-09-07 03:36:13.000201':::TIMESTAMP,), ('1999-07-20 15:19:21.00061':::TIMESTAMP,), ('2017-11-29 21:52:44.000225':::TIMESTAMP,)), PARTITION table1_part_6 VALUES IN (('1974-08-08 21:57:21.000377':::TIMESTAMP,), ('2019-03-03 20:28:03.000569':::TIMESTAMP,), ('2017-02-12 11:05:08.000103':::TIMESTAMP,)), PARTITION table1_part_7 VALUES IN (('2001-05-06 15:07:50.000302':::TIMESTAMP,), ('2015-10-24 13:32:40.000748':::TIMESTAMP,), ('1971-04-20 08:39:41.000631':::TIMESTAMP,)), PARTITION table1_part_8 VALUES IN (('3000-01-01 00:00:00':::TIMESTAMP,), ('2018-01-18 16:49:01.000465':::TIMESTAMP,), ('294276-12-31 23:59:59.999999':::TIMESTAMP,)), PARTITION table1_part_9 VALUES IN (('1988-02-14 18:17:35.000188':::TIMESTAMP,), ('2022-03-01 07:21:37.000878':::TIMESTAMP,), ('2024-12-29 01:02:22.000132':::TIMESTAMP,)), PARTITION "DEFAULT" VALUES IN ((DEFAULT,))))
        test_1        |         compare_test.go:158: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=f37774ec-0018-45fa-8094-51db9ed45bc4 for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (48.37s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

- #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 272d49bece0b5debdde6e5b537c50a1314b389d2:

        test_1        |                                 ('B':::STRING::STRING),
        test_1        |                                 ('E':::STRING::STRING),
        test_1        |                                 ('I':::STRING::STRING)
        test_1        |                         )
        test_1        |                             AS tab_133765 (col_205412)
        test_1        |                     GROUP BY
        test_1        |                         tab_133765.col_205412
        test_1        |                 )
        test_1        |                     AS tab_133766
        test_1        |             ORDER BY
        test_1        |                 col_205413 DESC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         string_agg(tab_133765.col_205412::TEXT, tab_133765.col_205412::TEXT ORDER BY tab_133765.col_205412::TEXT DESC NULLS FIRST, tab_133765.col_205412::TEXT ASC)::TEXT
        test_1        |                             AS col_205413
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 ('F'::TEXT::TEXT),
        test_1        |                                 ((NULL::BOX2D::BOX2D || 'G'::TEXT::TEXT::TEXT)::TEXT),
        test_1        |                                 (NULL::TEXT),
        test_1        |                                 ('B'::TEXT::TEXT),
        test_1        |                                 ('E'::TEXT::TEXT),
        test_1        |                                 ('I'::TEXT::TEXT)
        test_1        |                         )
        test_1        |                             AS tab_133765 (col_205412)
        test_1        |                     GROUP BY
        test_1        |                         tab_133765.col_205412
        test_1        |                 )
        test_1        |                     AS tab_133766
        test_1        |             ORDER BY
        test_1        |                 col_205413 DESC;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (189.96s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

- #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 272d49bece0b5debdde6e5b537c50a1314b389d2:

        test_1        |                                 ((NULL::FLOAT8[]::FLOAT8[] || 0.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8[]),
        test_1        |                                 ((9.0:::FLOAT8::FLOAT8::FLOAT8 || NULL::FLOAT8[]::FLOAT8[])::FLOAT8[])
        test_1        |                         )
        test_1        |                             AS tab_220595 (col_328130)
        test_1        |                     WHERE
        test_1        |                         true::BOOL
        test_1        |                 )
        test_1        |                     AS tab_220596
        test_1        |             ORDER BY
        test_1        |                 col_328131;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_220595.col_328130 AS col_328131
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (NULL::FLOAT8[]),
        test_1        |                                 ((NULL::FLOAT8[]::FLOAT8[] || 0.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8[]),
        test_1        |                                 ((9.0::FLOAT8::FLOAT8::FLOAT8 || NULL::FLOAT8[]::FLOAT8[])::FLOAT8[])
        test_1        |                         )
        test_1        |                             AS tab_220595 (col_328130)
        test_1        |                     WHERE
        test_1        |                         true::BOOL
        test_1        |                 )
        test_1        |                     AS tab_220596
        test_1        |             ORDER BY
        test_1        |                 col_328131;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.27s)
        test_1        |         compare_test.go:126: starting test: mutators
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:157: CREATE TABLE table2 (col2_0 TIMESTAMP NOT NULL, col2_1 OID NULL, PRIMARY KEY (col2_0 ASC), INDEX (col2_0 ASC) STORING (col2_1) PARTITION BY LIST (col2_0) (PARTITION table2_part_0 VALUES IN (('2002-03-21 03:21:34.000981':::TIMESTAMP,)), PARTITION table2_part_1 VALUES IN (('2007-03-05 11:14:18.000795':::TIMESTAMP,)), PARTITION table2_part_2 VALUES IN (('2033-01-17 20:06:38.000655':::TIMESTAMP,)), PARTITION table2_part_3 VALUES IN (('2021-06-04 14:17:37.000097':::TIMESTAMP,)), PARTITION table2_part_4 VALUES IN (('1990-10-22 14:34:40.000662':::TIMESTAMP,)), PARTITION table2_part_5 VALUES IN (('1996-08-18 02:40:03.000909':::TIMESTAMP,)), PARTITION table2_part_6 VALUES IN (('2014-06-10 01:17:03.000858':::TIMESTAMP,)), PARTITION table2_part_7 VALUES IN (('1990-08-12 11:56:26.000703':::TIMESTAMP,)), PARTITION table2_part_8 VALUES IN (('2025-07-31 00:12:54.000188':::TIMESTAMP,)), PARTITION table2_part_9 VALUES IN (('2024-09-13 08:11:43.000545':::TIMESTAMP,))) NOT VISIBLE, FAMILY (col2_1, col2_0))
        test_1        |         compare_test.go:158: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=4bb84017-075a-4697-9afc-a7c69efd3fa1 for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (327.71s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

- #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 272d49bece0b5debdde6e5b537c50a1314b389d2:

        test_1        |               []any(Inverse(func1, []any{
        test_1        |             -   nil,
        test_1        |             +   string("D"),
        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_28374.col_51974 AS col_51975
        test_1        |                     FROM
        test_1        |                         (VALUES ('D'::TEXT::CHAR), (NULL::CHAR), ('J'::TEXT::CHAR), ('E'::TEXT::CHAR))
        test_1        |                             AS tab_28374 (col_51974)
        test_1        |                     WHERE
        test_1        |                         true::BOOL
        test_1        |                 )
        test_1        |                     AS tab_28375
        test_1        |             ORDER BY
        test_1        |                 col_51975 ASC;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_28374.col_51974 AS col_51975
        test_1        |                     FROM
        test_1        |                         (VALUES ('D':::STRING::CHAR), (NULL::CHAR), ('J':::STRING::CHAR), ('E':::STRING::CHAR))
        test_1        |                             AS tab_28374 (col_51974)
        test_1        |                     WHERE
        test_1        |                         true::BOOL
        test_1        |                 )
        test_1        |                     AS tab_28375
        test_1        |             ORDER BY
        test_1        |                 col_51975 ASC;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (671.26s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

- #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 10 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 272d49bece0b5debdde6e5b537c50a1314b389d2:

        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | 
        postgres_1    | waiting for server to shut down....2023-11-12 06:18:49.846 UTC [49] LOG:  received fast shutdown request
        postgres_1    | 2023-11-12 06:18:49.848 UTC [49] LOG:  aborting any active transactions
        postgres_1    | 2023-11-12 06:18:49.850 UTC [49] LOG:  background worker "logical replication launcher" (PID 56) exited with exit code 1
        postgres_1    | 2023-11-12 06:18:49.852 UTC [51] LOG:  shutting down
        postgres_1    | 2023-11-12 06:18:49.960 UTC [49] LOG:  database system is shut down
        postgres_1    |  done
        postgres_1    | server stopped
        postgres_1    | 
        postgres_1    | PostgreSQL init process complete; ready for start up.
        postgres_1    | 
        postgres_1    | 2023-11-12 06:18:50.069 UTC [1] LOG:  starting PostgreSQL 13.5 (Debian 13.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
        postgres_1    | 2023-11-12 06:18:50.069 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2023-11-12 06:18:50.069 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2023-11-12 06:18:50.073 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2023-11-12 06:18:50.078 UTC [68] LOG:  database system was shut down at 2023-11-12 06:18:49 UTC
        postgres_1    | 2023-11-12 06:18:50.083 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2023-11-12 06:18:51.480 UTC [78] ERROR:  foreign key constraint "table3_col3_8_col3_1_fkey" cannot be implemented
        postgres_1    | 2023-11-12 06:18:51.480 UTC [78] DETAIL:  Key columns "col3_8" and "col1_15" are of incompatible types: "char" and name.
        postgres_1    | 2023-11-12 06:18:51.480 UTC [78] STATEMENT:  ALTER TABLE table3 ADD FOREIGN KEY (col3_8, col3_1) REFERENCES table1 (col1_15, col1_3)
        test_1        | --- FAIL: TestCompare (4.90s)
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (1.37s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:135: initializing connection: postgres
        test_1        |         compare_test.go:157: ALTER TABLE table3 ADD FOREIGN KEY (col3_8, col3_1) REFERENCES table1 (col1_15, col1_3)
        test_1        |         compare_test.go:158: postgres: exec: ERROR: foreign key constraint "table3_col3_8_col3_1_fkey" cannot be implemented (SQLSTATE 42804)
        test_1        |     --- FAIL: TestCompare/mutators (0.40s)
        test_1        |         compare_test.go:126: starting test: mutators
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:157: CREATE TABLE table2 (col2_0 BYTES, col2_1 STRING NOT NULL, col2_2 INTERVAL NOT NULL, col2_3 TIMESTAMP NOT NULL, col2_4 DECIMAL NULL, col2_5 STRING NOT NULL, col2_6 STRING NOT NULL, col2_7 INTERVAL NOT NULL, col2_8 BOOL NOT NULL, col2_9 FLOAT8 NOT NULL, col2_10 STRING NOT NULL AS (CASE WHEN col2_3 IS NULL THEN e'bPw\x1e\x0e_\x1c{':::STRING ELSE e'\U00002603':::STRING END) VIRTUAL, col2_11 STRING NOT NULL AS (CASE WHEN col2_7 IS NULL THEN e'\x17\x1eJ)^}\\':::STRING ELSE '"':::STRING END) VIRTUAL, PRIMARY KEY (col2_8 DESC, col2_10 DESC, col2_9, col2_2), UNIQUE (col2_3 ASC) STORING (col2_0, col2_5, col2_7), UNIQUE (col2_5, col2_1, col2_8 DESC, col2_3 DESC, col2_2, col2_7, col2_9 ASC, col2_10 DESC, col2_11 DESC, col2_6 DESC) STORING (col2_0, col2_4), INVERTED INDEX (col2_10, col2_9 DESC, col2_7, col2_2 DESC, col2_3 ASC, col2_6 DESC, col2_1 ASC, col2_0 DESC, col2_11 ASC, col2_8 ASC, col2_4 ASC, col2_5 gin_trgm_ops ASC), UNIQUE (col2_9 ASC, col2_6, col2_3, col2_0) STORING (col2_1, col2_4, col2_5) WHERE ((((table2.col2_0 > '\x':::BYTES) OR (table2.col2_10 = 'X':::STRING)) OR (NOT table2.col2_8)) AND (table2.col2_4 < '-Infinity':::DECIMAL)) AND (table2.col2_9 != 1.401298464324817e-45:::FLOAT8), INDEX (col2_10 ASC) STORING (col2_0, col2_1, col2_3, col2_6) PARTITION BY LIST (col2_10) (PARTITION table2_part_0 VALUES IN (('Q_':::STRING,), ('':::STRING,), (e'\x03{i{\x1d':::STRING,), (';Xspb;(':::STRING,), (e's\x19':::STRING,), (e'jGkdGX~\x049':::STRING,), (e'+\x1c\x1a':::STRING,), (e'\x16':::STRING,), ('eSm6':::STRING,), ('~mHtF*':::STRING,)), PARTITION table2_part_1 VALUES IN (('GJ':::STRING,), (e'\ntt':::STRING,), (e'\'':::STRING,), (e'\x03\n*\x03]':::STRING,), ('}':::STRING,)), PARTITION table2_part_2 VALUES IN ((e'\x1b&p@%\'\\\x17':::STRING,), ('^s':::STRING,), (e'[[\x11,\x04\x0f':::STRING,), ('H]':::STRING,), (e'u\b\x13d':::STRING,), (e'VeR\x05e\x1f8R\x15':::STRING,), (e'lyViJp\'':::STRING,), (e'\x061_\rJh':::STRING,)), PARTITION table2_part_3 VALUES IN ((e'$R+H4\x0e\x015i':::STRING,), ('NN#':::STRING,), (e'-,f\\':::STRING,), (e'*\x13':::STRING,), (e'&{I8a\x10':::STRING,), (e'z\x14ii':::STRING,), (e'\x166Y\x12':::STRING,), ('"':::STRING,), (e'.=M{\x051\x0e':::STRING,), (e'\x17p\x19':::STRING,)), PARTITION table2_part_4 VALUES IN (('1``f@K79tn':::STRING,), ('+A':::STRING,), ('[':::STRING,), (e'L\x03B':::STRING,), ('n':::STRING,), (e'\x03\x0fT\x06':::STRING,), (e'\b':::STRING,)), PARTITION table2_part_5 VALUES IN (('sG':::STRING,), (e')\x7fJ':::STRING,), (e'j\x16v\x13q+@~':::STRING,), ('8Ax{X':::STRING,), (e'\x00':::STRING,), (e'\x0bCR5':::STRING,), (e'6TE\x02':::STRING,), (e'cH\x1dDZ0U\x10.':::STRING,), (e'\x01.dCp]':::STRING,), (e'\x0f\t|;VuaE':::STRING,)), PARTITION table2_part_6 VALUES IN ((e'cs\x10\x19':::STRING,), (e'\x0f<':::STRING,), (e'\x19\x151qk-\x1db':::STRING,), (e'\x13':::STRING,), ('*':::STRING,), (e'~\x11(cM\x0fe\x1f^':::STRING,), (e'C\x15"f\x07\x1f':::STRING,), ('@':::STRING,)), PARTITION table2_part_7 VALUES IN ((e'x\rnGL4':::STRING,), (e'\x19X\x18I\x14x':::STRING,), ('b<e8p':::STRING,), ('eLI``p.u':::STRING,), ('-':::STRING,), (e'$\x12n/\x16N':::STRING,), (e'\x1a"\x04@eSXB~':::STRING,), (e'gy\t\x07^p$~\f':::STRING,), (')<r':::STRING,), (e'Rp\x1e':::STRING,)), PARTITION "DEFAULT" VALUES IN ((DEFAULT,))), INVERTED INDEX (col2_7 DESC, col2_11 ASC, col2_4 ASC, col2_1 gin_trgm_ops) WHERE ((table2.col2_1 <= e'\x00':::STRING) OR (table2.col2_4 != 1:::DECIMAL)) AND (table2.col2_11 < e'\x00':::STRING), INDEX (col2_11 ASC, col2_0, col2_10 DESC, col2_5 ASC, col2_3 DESC), INDEX (col2_6 ASC, col2_1, lower(col2_5) ASC, col2_3 ASC, col2_5 DESC, col2_11, col2_7 DESC, col2_10, col2_9 DESC, col2_8 ASC), FAMILY (col2_4, col2_8, col2_2, col2_7, col2_3), FAMILY (col2_9, col2_1), FAMILY (col2_6), FAMILY (col2_5, col2_0))
        test_1        |         compare_test.go:158: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=2e7a509b-65b7-4876-85f3-27a57931eff6 for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (20.87s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

- #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 272d49bece0b5debdde6e5b537c50a1314b389d2:

        test_1        |                                 ('::4/0':::INET::INET),
        test_1        |                                 ('::5/0':::INET::INET),
        test_1        |                                 ('::2/0':::INET::INET)
        test_1        |                         )
        test_1        |                             AS tab_57154 (col_107803)
        test_1        |                 )
        test_1        |                     AS tab_57155
        test_1        |             ORDER BY
        test_1        |                 col_107804 ASC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_57154.col_107803 AS col_107804
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 ('::8/0'::INET::INET),
        test_1        |                                 (NULL::INET),
        test_1        |                                 ('::3/0'::INET::INET),
        test_1        |                                 ('::4/0'::INET::INET),
        test_1        |                                 ('::5/0'::INET::INET),
        test_1        |                                 ('::2/0'::INET::INET)
        test_1        |                         )
        test_1        |                             AS tab_57154 (col_107803)
        test_1        |                 )
        test_1        |                     AS tab_57155
        test_1        |             ORDER BY
        test_1        |                 col_107804 ASC;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.47s)
        test_1        |         compare_test.go:126: starting test: mutators
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:157: CREATE TABLE table1 (col1_0 BIT(12) NOT NULL, col1_1 INT8 NOT NULL, col1_2 INT8 NOT NULL AS (col1_1 + (-3231743763082421576):::INT8) VIRTUAL, PRIMARY KEY (col1_2 ASC, col1_1 ASC, col1_0 ASC), INDEX (col1_0 DESC) PARTITION BY LIST (col1_0) (PARTITION table1_part_0 VALUES IN ((B'010100110101',), (B'001011101101',), (B'100111111101',), (B'111010111100',), (B'001001000010',), (B'100000010011',), (B'011011111111',), (B'100101100100',), (B'000000000000',), (B'010001100011',)), PARTITION table1_part_1 VALUES IN ((B'001011011110',), (B'011100011101',), (B'010010101111',), (B'011110001111',), (B'000100101001',), (B'010000111110',), (B'110000111111',), (B'111001100101',), (B'000011000101',), (B'000000001110',)), PARTITION table1_part_2 VALUES IN ((B'001001100111',), (B'001101000110',), (B'111001000111',), (B'011111111111',), (B'011011100100',), (B'000111110100',), (B'110100110110',), (B'000001001100',), (B'011000101010',), (B'101111010010',)), PARTITION table1_part_3 VALUES IN ((B'110000011011',), (B'100111001011',), (B'000111110101',), (B'110010010011',), (B'000111111100',), (B'001110000101',), (B'111110001100',), (B'101010100110',), (B'010101100001',), (B'101111100010',)), PARTITION table1_part_4 VALUES IN ((B'110111011111',), (B'100110011000',), (B'110110000100',), (B'101100111001',), (B'100111001100',), (B'011010111001',), (B'101110011100',), (B'011000100000',), (B'111000100110',), (B'010001000000',)), PARTITION table1_part_5 VALUES IN ((B'001001110100',), (B'111111110101',), (B'110010100110',), (B'111000000110',), (B'101111111001',), (B'111111100101',), (B'011010001010',), (B'011011100101',), (B'110011000000',), (B'110011100101',))) WHERE (table1.col1_2 != 1:::INT8) AND (table1.col1_1 >= (-2147483648):::INT8), INDEX (col1_1, (col1_1 + 936048857077221893:::INT8), col1_2), INDEX (col1_1) PARTITION BY LIST (col1_1) (PARTITION table1_part_0 VALUES IN ((7703017179001837711:::INT8,)), PARTITION table1_part_1 VALUES IN ((477119749167789846:::INT8,)), PARTITION table1_part_2 VALUES IN (((-8565869544838246291):::INT8,)), PARTITION "DEFAULT" VALUES IN ((DEFAULT,))) WHERE (table1.col1_2 = 9223372036854775807:::INT8) OR (table1.col1_1 < (-9223372036854775807):::INT8) NOT VISIBLE, INDEX (col1_2 DESC, col1_1 DESC) WHERE table1.col1_1 >= 1:::INT8 NOT VISIBLE, INDEX (col1_2 DESC, col1_1 ASC) WHERE table1.col1_1 >= 9223372036854775807:::INT8, INDEX (col1_2 ASC, col1_0, col1_1 DESC), UNIQUE (col1_1, (col1_1 + 4589048231504857482:::INT8) ASC), UNIQUE (col1_2 ASC, col1_1) WHERE (table1.col1_1 <= (-1):::INT8) AND (table1.col1_2 != (-1):::INT8), FAMILY (col1_0), FAMILY (col1_1))
        test_1        |         compare_test.go:158: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=05290851-79ce-4815-9cec-a4a28afed4e0 for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (119.04s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

- #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 272d49bece0b5debdde6e5b537c50a1314b389d2:

        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (64.03s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:135: initializing connection: postgres
        test_1        |         compare_test.go:186: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare307386453/002/postgres.log: no such file or directory
        test_1        |         compare_test.go:188: compare cockroach1 to postgres: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |             -   string("010300000000000000"),
        test_1        |             +   string("010300000001000000050000000000000000001C4000000000000020400000000000001C40000000000000F03F0000000000000840000000000000F03F000000000000084000000000000020400000000000001C400000000000002040"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_makeenvelope(7.0:::FLOAT8::FLOAT8::FLOAT8, 8.0:::FLOAT8::FLOAT8::FLOAT8, 3.0:::FLOAT8::FLOAT8::FLOAT8, 1.0:::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |                             AS col_46394
        test_1        |                 )
        test_1        |                     AS tab_28172
        test_1        |             ORDER BY
        test_1        |                 col_46394 NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         st_makeenvelope(7.0::FLOAT8::FLOAT8::FLOAT8, 8.0::FLOAT8::FLOAT8::FLOAT8, 3.0::FLOAT8::FLOAT8::FLOAT8, 1.0::FLOAT8::FLOAT8::FLOAT8)::GEOMETRY
        test_1        |                             AS col_46394
        test_1        |                 )
        test_1        |                     AS tab_28172
        test_1        |             ORDER BY
        test_1        |                 col_46394 NULLS LAST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (692.38s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

- #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 9bfc3cbd18058886152ab35359cb86e1cd83ffae:

        test_1        |         compare_test.go:135: initializing connection: postgres
        test_1        |         compare_test.go:186: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare3829319907/002/postgres.log: no such file or directory
        test_1        |         compare_test.go:188: compare postgres to cockroach1: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |             -   nil,
        test_1        |             +   string("0011000000000000000000000000000000000000000000000"),
        test_1        |               }))
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_26707.col_50577 AS col_50578
        test_1        |                     FROM
        test_1        |                         (VALUES (B'0000'::BIT(49)), (B'0010'::BIT(49)), (NULL::BIT(49)), (B'0011'::BIT(49)))
        test_1        |                             AS tab_26707 (col_50577)
        test_1        |                     WHERE
        test_1        |                         true::BOOL
        test_1        |                     GROUP BY
        test_1        |                         tab_26707.col_50577
        test_1        |                     HAVING
        test_1        |                         bool_and(true::BOOL::BOOL)::BOOL
        test_1        |                     ORDER BY
        test_1        |                         tab_26707.col_50577 ASC, tab_26707.col_50577 DESC NULLS FIRST
        test_1        |                 )
        test_1        |                     AS tab_26708
        test_1        |             ORDER BY
        test_1        |                 col_50578 DESC;
        test_1        |             
        test_1        |             cockroach1: [same as previous]
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.79s)
        test_1        |         compare_test.go:126: starting test: mutators
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:135: initializing connection: cockroach2
        test_1        |         compare_test.go:157: ALTER TABLE table3 ADD FOREIGN KEY (col3_4) REFERENCES table2 (col2_9)
        test_1        |         compare_test.go:158: cockroach2: exec: ERROR: there is no unique constraint matching given keys for referenced table table2 (SQLSTATE 23503)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (84.02s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

- #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 0ad77cfcc5a81b96dd2f27ed608536388b680537:

        test_1        |             +   nil,
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_29743.col_48416 AS col_48417
        test_1        |                     FROM
        test_1        |                         (VALUES (6.0:::FLOAT8::FLOAT4), (NULL::FLOAT4), (0.0:::FLOAT8::FLOAT4)) AS tab_29743 (col_48416)
        test_1        |                     WHERE
        test_1        |                         (NOT false::BOOL)
        test_1        |                     ORDER BY
        test_1        |                         tab_29743.col_48416 NULLS FIRST, tab_29743.col_48416, tab_29743.col_48416 DESC
        test_1        |                 )
        test_1        |                     AS tab_29744
        test_1        |             ORDER BY
        test_1        |                 col_48417;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_29743.col_48416 AS col_48417
        test_1        |                     FROM
        test_1        |                         (VALUES (6.0::FLOAT8::FLOAT4), (NULL::FLOAT4), (0.0::FLOAT8::FLOAT4)) AS tab_29743 (col_48416)
        test_1        |                     WHERE
        test_1        |                         (NOT false::BOOL)
        test_1        |                     ORDER BY
        test_1        |                         tab_29743.col_48416 NULLS FIRST, tab_29743.col_48416, tab_29743.col_48416 DESC
        test_1        |                 )
        test_1        |                     AS tab_29744
        test_1        |             ORDER BY
        test_1        |                 col_48417;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (68.19s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

- #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109969 compose: TestComposeCompare failed [FROZEN.branch-release-23.1.11-rc O-robot T-sql-foundations] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #108652 compose: TestComposeCompare failed [O-robot T-sql-foundations TODO-deprecate.branch-release-23.1.9-rc] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 0ad77cfcc5a81b96dd2f27ed608536388b680537:

        test_1        |                             VALUES
        test_1        |                                 ('00000000-0000-0000-0000-000000000008'::UUID::UUID),
        test_1        |                                 ('00000000-0000-0000-0000-000000000004'::UUID::UUID),
        test_1        |                                 ('00000000-0000-0000-0000-000000000008'::UUID::UUID),
        test_1        |                                 (NULL::UUID)
        test_1        |                         )
        test_1        |                             AS tab_72490 (col_113510)
        test_1        |                 )
        test_1        |                     AS tab_72491
        test_1        |             ORDER BY
        test_1        |                 col_113511 DESC;
        test_1        |             
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_72490.col_113510 AS col_113511
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 ('00000000-0000-0000-0000-000000000008':::UUID::UUID),
        test_1        |                                 ('00000000-0000-0000-0000-000000000004':::UUID::UUID),
        test_1        |                                 ('00000000-0000-0000-0000-000000000008':::UUID::UUID),
        test_1        |                                 (NULL::UUID)
        test_1        |                         )
        test_1        |                             AS tab_72490 (col_113510)
        test_1        |                 )
        test_1        |                     AS tab_72491
        test_1        |             ORDER BY
        test_1        |                 col_113511 DESC;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.23s)
        test_1        |         compare_test.go:126: starting test: mutators
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:157: CREATE TABLE table3 (col3_0 INET NOT NULL, col3_1 INT2 NOT NULL, col3_2 TIMESTAMPTZ NOT NULL, col3_3 REGROLE NOT NULL, col3_4 CHAR NOT NULL, col3_5 "char" NOT NULL, col3_6 FLOAT4 NOT NULL, col3_7 BOOL NOT NULL, col3_8 INT8, col3_9 STRING NOT NULL AS (lower(col3_5)) VIRTUAL, col3_10 INT8 AS (col3_8 + col3_1) STORED, col3_11 INT8 NOT NULL AS (col3_8 + col3_1) VIRTUAL, col3_12 FLOAT8 NOT NULL AS (col3_6 + (-0.20032493770122528):::FLOAT8) VIRTUAL, col3_13 INT8 NOT NULL AS (col3_8 + col3_1) STORED, col3_14 INT8 NOT NULL AS (col3_8 + col3_1) STORED, PRIMARY KEY (col3_12 ASC, col3_14, col3_4 ASC, col3_3 ASC, col3_0 DESC, col3_13, col3_6 ASC, col3_2 ASC, col3_7 ASC, col3_11 DESC, col3_1 ASC), INDEX (col3_11, col3_0, col3_3 ASC, col3_2 ASC, col3_12 ASC, col3_7 DESC, col3_8 ASC, col3_5 DESC, lower(col3_5), col3_14) WHERE ((((((((((((table3.col3_4 <= 'X':::STRING) OR table3.col3_7) OR (table3.col3_9 >= 'X':::STRING)) OR (table3.col3_12 != 0.0:::FLOAT8)) AND (table3.col3_11 = 32767:::INT8)) OR (table3.col3_13 = 9223372036854775807:::INT8)) OR (table3.col3_2 < '0001-01-01 00:00:00+00:00':::TIMESTAMPTZ)) OR (table3.col3_10 <= (-128):::INT8)) OR (table3.col3_5 <= e'\U00002603':::STRING)) OR (table3.col3_1 = 127:::INT8)) OR (table3.col3_8 != 1:::INT8)) AND (table3.col3_14 >= 1:::INT8)) AND (table3.col3_6 != (-1.0):::FLOAT8), INDEX (col3_4 ASC, col3_9, col3_14 ASC, col3_12 ASC, col3_0, col3_7 DESC, col3_3 DESC, col3_11, col3_2, col3_5, col3_8 ASC, col3_13 DESC, col3_1 ASC, col3_6 ASC, col3_10 DESC), INDEX (col3_9 ASC, col3_13 DESC, col3_0 ASC, col3_12, col3_8 DESC, col3_6 DESC) STORING (col3_5, col3_10) PARTITION BY LIST (col3_9, col3_13, col3_0) (PARTITION table3_part_0 VALUES IN (('%e':::STRING, 7259356352270734665:::INT8, 'bccb:320e:ad13:2c5b:95e8:9987:1d65:9dd0/12':::INET), (e'\x7f\\\x13\x12o':::STRING, (-4521527607372546938):::INT8, '160.98.21.170/23':::INET), (e'u\x0f6\x02};\x7f':::STRING, (-8938159762660513945):::INT8, 'fdfa:8507:4743:a400:2eb9:8711:4edc:b21c/70':::INET), ('':::STRING, 7889687213715868105:::INT8, '72.154.54.226/20':::INET)), PARTITION "DEFAULT" VALUES IN ((DEFAULT, DEFAULT, DEFAULT))) NOT VISIBLE, FAMILY (col3_14, col3_8, col3_2), FAMILY (col3_4, col3_13, col3_5), FAMILY (col3_3), FAMILY (col3_7), FAMILY (col3_0), FAMILY (col3_6, col3_10), FAMILY (col3_1))
        test_1        |         compare_test.go:158: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=5901071d-ac17-42a8-9338-9adf1760e531 for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (122.49s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 0ad77cfcc5a81b96dd2f27ed608536388b680537:

        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (
        test_1        |                                     age(('2000-01-02':::DATE::DATE::DATE + NULL::TIMETZ::TIMETZ)::TIMESTAMPTZ::TIMESTAMPTZ, '2000-01-01 07:00:00+00:00':::TIMESTAMPTZ::TIMESTAMPTZ::TIMESTAMPTZ)::INTERVAL
        test_1        |                                 ),
        test_1        |                                 ('00:00:05':::INTERVAL::INTERVAL)
        test_1        |                         )
        test_1        |                             AS tab_132911 (col_251908)
        test_1        |                     WHERE
        test_1        |                         true::BOOL
        test_1        |                 )
        test_1        |                     AS tab_132912
        test_1        |             ORDER BY
        test_1        |                 col_251909;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_132911.col_251908 AS col_251909
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (
        test_1        |                                     age(('2000-01-02'::DATE::DATE::DATE + NULL::TIMETZ::TIMETZ)::TIMESTAMPTZ::TIMESTAMPTZ, '2000-01-01 07:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ::TIMESTAMPTZ)::INTERVAL
        test_1        |                                 ),
        test_1        |                                 ('00:00:05'::INTERVAL::INTERVAL)
        test_1        |                         )
        test_1        |                             AS tab_132911 (col_251908)
        test_1        |                     WHERE
        test_1        |                         true::BOOL
        test_1        |                 )
        test_1        |                     AS tab_132912
        test_1        |             ORDER BY
        test_1        |                 col_251909;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (855.75s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 0ad77cfcc5a81b96dd2f27ed608536388b680537:

        test_1        |                         )
        test_1        |                             AS tab_3089 (col_4710)
        test_1        |                     GROUP BY
        test_1        |                         tab_3089.col_4710
        test_1        |                 )
        test_1        |                     AS tab_3090
        test_1        |             ORDER BY
        test_1        |                 col_4711;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         var_samp(tab_3089.col_4710::DECIMAL)::DECIMAL AS col_4711
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (4::DECIMAL::DECIMAL),
        test_1        |                                 (0::DECIMAL::DECIMAL),
        test_1        |                                 (NULL::DECIMAL),
        test_1        |                                 (8::DECIMAL::DECIMAL),
        test_1        |                                 (8::DECIMAL::DECIMAL)
        test_1        |                         )
        test_1        |                             AS tab_3089 (col_4710)
        test_1        |                     GROUP BY
        test_1        |                         tab_3089.col_4710
        test_1        |                 )
        test_1        |                     AS tab_3090
        test_1        |             ORDER BY
        test_1        |                 col_4711;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.33s)
        test_1        |         compare_test.go:126: starting test: mutators
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:157: CREATE TABLE table2 (col2_0 DATE NOT NULL, col2_1 VARCHAR NOT NULL, col2_2 DATE NOT NULL, col2_3 INTERVAL NOT NULL, col2_4 DATE NOT NULL, col2_5 REGROLE, col2_6 REGROLE, col2_7 BIT(40) NOT NULL, col2_8 VARCHAR NOT NULL, col2_9 DECIMAL NOT NULL, col2_10 STRING NOT NULL AS (CASE WHEN col2_0 IS NULL THEN e'-e\x06W\x1c\x19':::STRING ELSE e'\x00':::STRING END) STORED, col2_11 STRING NOT NULL AS (lower(col2_8)) STORED, col2_12 STRING NOT NULL AS (lower(CAST(col2_7 AS STRING))) VIRTUAL, col2_13 STRING NOT NULL AS (CASE WHEN col2_6 IS NULL THEN e'h)+8@0\x03NY':::STRING ELSE '``C':::STRING END) STORED, col2_14 STRING AS (CASE WHEN col2_3 IS NULL THEN '"':::STRING ELSE e'\x17$f[q':::STRING END) VIRTUAL, col2_15 STRING NOT NULL AS (CASE WHEN col2_6 IS NULL THEN e'\x15Dzv':::STRING ELSE e'Qoe_\x1a':::STRING END) VIRTUAL, col2_16 STRING NOT NULL AS (CASE WHEN col2_0 IS NULL THEN e'v%b\x0fS<P)':::STRING ELSE e'\U00002603':::STRING END) STORED, PRIMARY KEY (col2_13, col2_11 DESC, col2_9, col2_15, col2_10 DESC, col2_3 DESC, col2_2, col2_1, col2_7, col2_8 ASC, col2_0 ASC), UNIQUE (col2_16 DESC, col2_15, col2_5 ASC, (CASE WHEN col2_3 IS NULL THEN '3':::STRING ELSE e'\x11MM\x1cH\x10Gh':::STRING END) ASC, col2_0 ASC, col2_10, col2_11, col2_9 ASC) STORING (col2_4) WHERE table2.col2_1 >= e'\x00':::STRING, UNIQUE ((CASE WHEN col2_5 IS NULL THEN 'Ja"#}':::STRING ELSE 'b':::STRING END) ASC, col2_1 DESC, col2_9 DESC, col2_5 ASC, col2_11 ASC, col2_3 DESC) STORING (col2_4) WHERE ((table2.col2_14 = e'\'':::STRING) AND (table2.col2_11 = 'X':::STRING)) AND (table2.col2_15 = 'X':::STRING), UNIQUE (col2_7, col2_6, col2_2 DESC, col2_10 DESC, col2_16 ASC, col2_13, col2_5 DESC, col2_9 DESC, col2_14 DESC, col2_15) STORING (col2_4), INDEX (col2_8, col2_16, col2_10, col2_0 DESC) STORING (col2_5) WHERE (((((((((((table2.col2_11 < e'\'':::STRING) OR (table2.col2_12 <= 'X':::STRING)) OR (table2.col2_2 != '4714-11-24 BC':::DATE)) AND (table2.col2_13 != e'\'':::STRING)) AND (table2.col2_15 <= '':::STRING)) AND (table2.col2_10 <= 'X':::STRING)) OR (table2.col2_0 >= '4714-11-24 BC':::DATE)) OR (table2.col2_8 >= e'\'':::STRING)) OR (table2.col2_1 > '"':::STRING)) OR (table2.col2_9 <= (-1):::DECIMAL)) OR (table2.col2_14 > e'\'':::STRING)) OR (table2.col2_4 < 'infinity':::DATE) NOT VISIBLE, INDEX (col2_2 ASC, col2_12 ASC, col2_4 DESC) STORING (col2_5, col2_16), UNIQUE (col2_16 ASC, col2_7, col2_9 ASC, col2_12 ASC, col2_11 DESC, col2_15, (CASE WHEN col2_4 IS NULL THEN e'\x1a/l\x17':::STRING ELSE e'\x1f.;=V\x13\x1e':::STRING END) ASC, col2_0, col2_14 ASC, col2_5 DESC, col2_6, col2_8 DESC, col2_2, col2_4, col2_13 DESC, col2_10 DESC), INDEX (col2_13 ASC, col2_10 ASC) STORING (col2_4, col2_5, col2_6), INDEX (col2_13, col2_1 ASC, col2_6 ASC, col2_3, col2_5, col2_4, col2_15 DESC, col2_8, col2_2 ASC, col2_12 DESC, col2_7 DESC) PARTITION BY LIST (col2_13, col2_1, col2_6, col2_3, col2_5, col2_4, col2_15, col2_8) (PARTITION table2_part_0 VALUES IN ((e'\x10LS':::STRING, '':::STRING, 0:::OID, '-28 years -9 mons -504 days -12:25:46.002853':::INTERVAL, 0:::OID, '1979-08-02':::DATE, 'sfn':::STRING, 'V':::STRING), (e'2\x12N\x160':::STRING, e'\x02\x1fs*L':::STRING, 1745611599:::OID, '-61 years -1 mons -774 days -21:01:48.427066':::INTERVAL, 2817919264:::OID, '1987-07-28':::DATE, ')KIAA':::STRING, e'\\\x06\x03\x1bCy:F':::STRING), (e']\x1fg\\l\x11':::STRING, 'X_y':::STRING, 2838716861:::OID, '32 years 6 mons 465 days 15:21:13.493437':::INTERVAL, 4170455996:::OID, '1991-03-24':::DATE, e'Yd\tS%':::STRING, e'lpd\x05':::STRING), ('{U.':::STRING, e'\x033SWe':::STRING, 820959089:::OID, '-36 years -9 mons -80 days -01:00:36.112848':::INTERVAL, 1577497467:::OID, '1993-11-24':::DATE, e'>\x18m+o':::STRING, e'\nA\nP$Op}':::STRING), ('wkn':::STRING, '>g':::STRING, 0:::OID, '-52 years -9 mons -508 days -09:25:55.606553':::INTERVAL, 1263395101:::OID, '5874897-12-31':::DATE, e'\x06iZJ{r':::STRING, '':::STRING), ('"':::STRING, e'E;Zq\x19tT$+':::STRING, 2938082396:::OID, '-23 years -2 mons -505 days -15:31:24.377826':::INTERVAL, 965272031:::OID, '1985-11-15':::DATE, e'\f\n!\x0bR\x1c1W':::STRING, e'nq\x07V\x15m%\\':::STRING), (e'\x19':::STRING, '':::STRING, 3545102681:::OID, '-47 years -2 mons -202 days -09:34:50.564073':::INTERVAL, 4037534254:::OID, '1983-03-11':::DATE, '{q':::STRING, '00':::STRING), ('tX':::STRING, e'3\x1d':::STRING, 0:::OID, '36 years 9 mons 150 days 22:10:34.496143':::INTERVAL, 1237569877:::OID, '1970-04-09':::DATE, e'xMvsW\x04T':::STRING, e'\U00002603':::STRING), (e'4\x07]\x16%':::STRING, 'X':::STRING, 2988241572:::OID, '21 years 4 mons 135 days 02:11:01.940189':::INTERVAL, 860337546:::OID, '1992-07-18':::DATE, e'\x15tm$\n0Vy':::STRING, e'ss\x12F':::STRING), (e'i[C/0sZ\x15':::STRING, e'f6\x07<\x7f{':::STRING, 0:::OID, '40 years 1 mon 565 days 22:33:22.305493':::INTERVAL, 4079553652:::OID, '4714-11-24 BC':::DATE, e'qDo/+\x1c':::STRING, e'\r"O9':::STRING)), PARTITION "DEFAULT" VALUES IN ((DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT))) WHERE ((((((((table2.col2_8 <= '':::STRING) OR (table2.col2_16 <= e'\x00':::STRING)) AND (table2.col2_13 != e'\'':::STRING)) OR (table2.col2_4 <= '1970-01-01':::DATE)) AND (table2.col2_9 != (-1.234E+401):::DECIMAL)) OR (table2.col2_12 < 'X':::STRING)) AND (table2.col2_11 <= 'X':::STRING)) AND (table2.col2_0 <= '1970-01-01':::DATE)) OR (table2.col2_1 = e'\'':::STRING), FAMILY (col2_2), FAMILY (col2_16, col2_3, col2_4), FAMILY (col2_7), FAMILY (col2_6, col2_13), FAMILY (col2_9, col2_10), FAMILY (col2_5, col2_0, col2_11), FAMILY (col2_1, col2_8))
        test_1        |         compare_test.go:158: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=4bbf9b1f-4883-42e9-84de-912fd68ef248 for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (33.28s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 0ad77cfcc5a81b96dd2f27ed608536388b680537:

        test_1        |             +               Int:              s"10986122886681097",
        test_1        |             -               Exp:              -19,
        test_1        |             +               Exp:              -16,
        test_1        |                             Status:           2,
        test_1        |                             NaN:              false,
        test_1        |                             InfinityModifier: s"none",
        test_1        |                         },
        test_1        |                     },
        test_1        |                     Dimensions: {{Length: 1, LowerBound: 1}},
        test_1        |                     Status:     2,
        test_1        |                 },
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         ((ln(3:::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL || NULL::DECIMAL[]::DECIMAL[])::DECIMAL[]::DECIMAL[] || NULL::DECIMAL[]::DECIMAL[])::DECIMAL[]
        test_1        |                             AS col_5127
        test_1        |                 )
        test_1        |                     AS tab_3208
        test_1        |             ORDER BY
        test_1        |                 col_5127 ASC NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         ((ln(3::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL || NULL::DECIMAL[]::DECIMAL[])::DECIMAL[]::DECIMAL[] || NULL::DECIMAL[]::DECIMAL[])::DECIMAL[]
        test_1        |                             AS col_5127
        test_1        |                 )
        test_1        |                     AS tab_3208
        test_1        |             ORDER BY
        test_1        |                 col_5127 ASC NULLS LAST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (34.03s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 0ad77cfcc5a81b96dd2f27ed608536388b680537:

        test_1        |             -   nil,
        test_1        |             +   s"4",
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_68537.col_126775 AS col_126776
        test_1        |                     FROM
        test_1        |                         (VALUES (5:::INT8::INT8), (6:::INT8::INT8), (7:::INT8::INT8), (NULL::INT8), (4:::INT8::INT8))
        test_1        |                             AS tab_68537 (col_126775)
        test_1        |                 )
        test_1        |                     AS tab_68538
        test_1        |             ORDER BY
        test_1        |                 col_126776 ASC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_68537.col_126775 AS col_126776
        test_1        |                     FROM
        test_1        |                         (VALUES (5::INT8::INT8), (6::INT8::INT8), (7::INT8::INT8), (NULL::INT8), (4::INT8::INT8))
        test_1        |                             AS tab_68537 (col_126775)
        test_1        |                 )
        test_1        |                     AS tab_68538
        test_1        |             ORDER BY
        test_1        |                 col_126776 ASC;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.34s)
        test_1        |         compare_test.go:126: starting test: mutators
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:157: CREATE TABLE table1 (col1_0 NAME NOT NULL, col1_1 REGCLASS NOT NULL, col1_2 OID NOT NULL, col1_3 FLOAT4 NOT NULL, col1_4 TIMESTAMP NOT NULL, col1_5 CHAR NOT NULL, col1_6 BYTES NOT NULL, col1_7 TIMESTAMPTZ NOT NULL, col1_8 STRING NOT NULL AS (lower(col1_0)) VIRTUAL, col1_9 STRING NOT NULL AS (CASE WHEN col1_7 IS NULL THEN NULL ELSE 'A>':::STRING END) VIRTUAL, col1_10 STRING NOT NULL AS (CASE WHEN col1_4 IS NULL THEN e'\x106q,)\x13k':::STRING ELSE NULL END) STORED, PRIMARY KEY (col1_1 DESC, col1_10 DESC, col1_0, col1_4, col1_9 DESC, col1_5 DESC, col1_6, col1_2, col1_7 DESC, col1_8 ASC), UNIQUE (col1_8 ASC, (CASE WHEN col1_4 IS NULL THEN e'!\x045n1r#':::STRING ELSE '.Y*Jn/':::STRING END) DESC) PARTITION BY LIST (col1_8) (PARTITION table1_part_0 VALUES IN ((e'*\x18\x10c\x1c58':::STRING,), (e'c\'|i':::STRING,), (e'>f;\x07WIuY\t':::STRING,), (';Lv{':::STRING,), (';':::STRING,), (e'\x1a$':::STRING,)), PARTITION table1_part_1 VALUES IN (('':::STRING,), ('~)f':::STRING,), ('i$u[Q':::STRING,), (e'=!~Ij\x7f\x1e':::STRING,), (e'6f\'\'/aKSg':::STRING,)), PARTITION table1_part_2 VALUES IN ((e'.u\r\x03M':::STRING,), (e'6(\bb%A':::STRING,), ('P':::STRING,), (e'\x00':::STRING,), (e'K\x19\b\r\x15``':::STRING,), ('y':::STRING,)), PARTITION table1_part_3 VALUES IN (('"':::STRING,), (e'O\x18S':::STRING,), (e'?\\u%':::STRING,), (e'y\x0b':::STRING,), (e',s\x0f':::STRING,), (e'_\x0f\x1aPV4G\bM':::STRING,)), PARTITION table1_part_4 VALUES IN ((e'4f\x01':::STRING,), (e'im\x17\x1a':::STRING,), (e'\x1em?G':::STRING,), ('X=#:hw/':::STRING,), ('$3a8_be':::STRING,)), PARTITION table1_part_5 VALUES IN ((e'*:J\x1d1o"SI':::STRING,), (e'q_\\HR81':::STRING,), ('U|!':::STRING,), ('E(':::STRING,)), PARTITION table1_part_6 VALUES IN ((e'\'':::STRING,), ('p3':::STRING,), ('f["c:':::STRING,), (e'\x14':::STRING,), (e' \x04!L':::STRING,), (e'\x04~\x1bwO\x12yj>':::STRING,)), PARTITION table1_part_7 VALUES IN ((e'O1\x13\x13\f':::STRING,), (e'@g\x0bZy}s\x11h':::STRING,), (e'#\x17\x10\x02nvJ\x03':::STRING,), ('2M#7 o.':::STRING,), (e'\x071>g1A%{':::STRING,), (e'\x12\x03':::STRING,)), PARTITION table1_part_8 VALUES IN ((e'D\x18w\x12h;\x14\x1f':::STRING,), ('sL %A4':::STRING,), ('X':::STRING,)), PARTITION table1_part_9 VALUES IN ((e'\x13cxLW\x13B':::STRING,), (e's\x1f':::STRING,), (e'N\tj2[\x1f':::STRING,))), UNIQUE (col1_8 ASC, col1_9 ASC, col1_6 ASC, col1_0, col1_5 ASC), UNIQUE (col1_3 DESC, col1_0 ASC, col1_10 DESC, col1_8, col1_2 ASC, col1_9 ASC, col1_6, col1_7, lower(col1_0) DESC) WHERE (((((((table1.col1_10 >= 'X':::STRING) AND (table1.col1_8 < 'X':::STRING)) OR (table1.col1_6 > '\x22':::BYTES)) AND (table1.col1_0 != e'\U00002603':::STRING:::NAME)) AND (table1.col1_3 <= '-Inf':::FLOAT8)) AND (table1.col1_9 > e'\'':::STRING)) AND (table1.col1_7 != '0001-01-01 00:00:00+00:00':::TIMESTAMPTZ)) OR (table1.col1_4 = '0001-01-01 00:00:00':::TIMESTAMP), UNIQUE (lower(CAST(col1_2 AS STRING)), col1_2, col1_1, col1_6, col1_10 DESC), UNIQUE (col1_4 DESC, lower(CAST(col1_2 AS STRING)) ASC, (col1_3 + (-2.1798489093780518):::FLOAT8) DESC, col1_1 ASC) STORING (col1_3))
        test_1        |         compare_test.go:158: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=59fe0687-b538-4f10-8f36-a2e949445d1f for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (118.91s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 0ad77cfcc5a81b96dd2f27ed608536388b680537:

        test_1        |                                 )
        test_1        |                         )
        test_1        |                             AS tab_1766 (col_1553)
        test_1        |                     ORDER BY
        test_1        |                         tab_1766.col_1553 ASC NULLS LAST, tab_1766.col_1553 DESC NULLS LAST, tab_1766.col_1553 NULLS LAST
        test_1        |                 )
        test_1        |                     AS tab_1767
        test_1        |             ORDER BY
        test_1        |                 col_1554;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_1766.col_1553 AS col_1554
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 ('I'::TEXT::TEXT),
        test_1        |                                 (
        test_1        |                                     (NULL::GEOGRAPHY::GEOGRAPHY || (NULL::JSONB::JSONB->>4::INT8::INT4::INT4)::TEXT::TEXT)::TEXT
        test_1        |                                 )
        test_1        |                         )
        test_1        |                             AS tab_1766 (col_1553)
        test_1        |                     ORDER BY
        test_1        |                         tab_1766.col_1553 ASC NULLS LAST, tab_1766.col_1553 DESC NULLS LAST, tab_1766.col_1553 NULLS LAST
        test_1        |                 )
        test_1        |                     AS tab_1767
        test_1        |             ORDER BY
        test_1        |                 col_1554;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.13s)
        test_1        |         compare_test.go:126: starting test: mutators
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:157: CREATE TABLE table2 (col2_0 REGTYPE, col2_1 TIMETZ, col2_2 INET NOT NULL, col2_3 INT4 NOT NULL, PRIMARY KEY (col2_3), INDEX (col2_2 ASC) WHERE (table2.col2_3 != (-32768):::INT8) AND (table2.col2_1 > '00:00:00+15:59:00':::TIMETZ), INDEX (col2_2 DESC, col2_0 DESC) WHERE (table2.col2_1 >= '24:00:00-15:59:00':::TIMETZ) OR (table2.col2_3 > 2147483647:::INT8), UNIQUE ((col2_3 + 130478026:::INT8) DESC) WHERE table2.col2_3 < (-1):::INT8, INDEX (col2_0 ASC, (CASE WHEN col2_0 IS NULL THEN e'\x18(>]j':::STRING ELSE e'8\x14x':::STRING END) ASC) NOT VISIBLE, UNIQUE (col2_2, col2_3) STORING (col2_1) WHERE (table2.col2_1 != '24:00:00-15:59:00':::TIMETZ) AND (table2.col2_3 != (-128):::INT8), INDEX (col2_3, col2_1 ASC, col2_0, col2_2 ASC) PARTITION BY LIST (col2_3, col2_1, col2_0, col2_2) (PARTITION table2_part_0 VALUES IN (((-1097294066):::INT8, '01:14:31.719038-09:00:00':::TIMETZ, 735185756:::OID, '0.0.0.0/0':::INET), (127:::INT8, '11:51:10.141712-09:55:00':::TIMETZ, 3078715999:::OID, '109.45.157.58/22':::INET), (1889553033:::INT8, '03:03:10.470267-11:51:00':::TIMETZ, 357618255:::OID, '360b:a767:d5e5:192a:5a6b:31f0:8157:1d78/104':::INET), (664670951:::INT8, '13:13:01.932459-07:23:00':::TIMETZ, 1819835112:::OID, '5e0d:eeca:2bb9:a29a:e17b:8cbf:86d2:604f/84':::INET), ((-551098875):::INT8, '14:20:47.855976+06:41:00':::TIMETZ, 0:::OID, '46.208.206.197/9':::INET), (965485930:::INT8, '18:09:19.017759+05:04:00':::TIMETZ, 3858099431:::OID, '25d4:ffa3:b417:f024:de90:78ac:cf2d:2841/28':::INET), (1997547318:::INT8, '13:41:16.534789+03:27:00':::TIMETZ, 3194841546:::OID, '217.203.34.24/19':::INET), (1974917915:::INT8, '22:57:05.735531+13:16:00':::TIMETZ, 597736596:::OID, '245.244.219.61/10':::INET)), PARTITION table2_part_1 VALUES IN (((-1050205087):::INT8, '06:38:21.753622+10:52:00':::TIMETZ, 331490858:::OID, '113.165.58.193/3':::INET), (127320903:::INT8, '00:00:00+15:59:00':::TIMETZ, 1162684096:::OID, 'df3b:1be5:830d:7e4c:4593:844f:be5:bec0/43':::INET), ((-272459567):::INT8, '13:01:23.536811-10:30:00':::TIMETZ, 2195968215:::OID, '4735:b96b:d60d:2cdb:5500:94fd:6416:ed64/127':::INET), ((-1865154089):::INT8, '10:34:27.135441-08:26:00':::TIMETZ, 2568965069:::OID, '9714:ff58:da00:86d6:3144:77fd:f8c2:10ef/96':::INET), (1784539162:::INT8, '04:26:40.222473+14:31:00':::TIMETZ, 2698877264:::OID, 'f544:e0aa:38b1:923e:8c1e:93c1:d92e:a5bd/117':::INET), ((-1435109371):::INT8, '19:34:15.021355-08:51:00':::TIMETZ, 1223718590:::OID, '92.57.33.170/21':::INET), (5768635:::INT8, '11:36:43.343796-12:23:00':::TIMETZ, 3609192281:::OID, '141.56.242.40/20':::INET), (1851299370:::INT8, '06:20:51.234887+03:36:00':::TIMETZ, 3253924279:::OID, '218.119.76.50/0':::INET))) WHERE (table2.col2_3 <= 0:::INT8) OR (table2.col2_1 != '24:00:00-15:59:00':::TIMETZ), INDEX (col2_3 DESC) PARTITION BY LIST (col2_3) (PARTITION table2_part_0 VALUES IN ((1236853029:::INT8,), (2078513353:::INT8,), (956639708:::INT8,), ((-1):::INT8,)), PARTITION table2_part_1 VALUES IN (((-1614674887):::INT8,), (1552013373:::INT8,), (1498695710:::INT8,), (141067719:::INT8,)), PARTITION table2_part_2 VALUES IN ((152252703:::INT8,), (2147483647:::INT8,), ((-1401577371):::INT8,), ((-2147483648):::INT8,)), PARTITION table2_part_3 VALUES IN (((-1477539156):::INT8,), (1:::INT8,), (850874455:::INT8,), ((-638828642):::INT8,))) NOT VISIBLE, FAMILY (col2_2), FAMILY (col2_0), FAMILY (col2_1), FAMILY (col2_3))
        test_1        |         compare_test.go:158: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=7ead5d80-19d8-4037-9c9a-1bb68d3b52c5 for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (28.30s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 0ad77cfcc5a81b96dd2f27ed608536388b680537:

        postgres_1    | 2023-11-23 06:17:36.313 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2023-11-23 06:17:37.774 UTC [78] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
        postgres_1    | 2023-11-23 06:17:37.774 UTC [78] STATEMENT:  CREATE TABLE table3 (col3_0 "char" NOT NULL, col3_1 BIT(46) NOT NULL, col3_2 DATE NOT NULL, col3_3 BIT(36) NOT NULL, PRIMARY KEY (col3_3, col3_0, col3_1));
        postgres_1    |     CREATE UNIQUE INDEX ON table3 (col3_2 DESC, col3_0 DESC, col3_1 DESC);
        postgres_1    |     CREATE INDEX ON table3 (lower(CAST(col3_1 AS TEXT)) DESC, col3_0, col3_1, (CASE WHEN col3_2 IS NULL THEN e'\x00'::TEXT ELSE e'\'\x06VX~+yO'::TEXT END) DESC);
        postgres_1    |     CREATE INDEX ON table3 (col3_0, col3_2 ASC);
        postgres_1    |     CREATE INDEX ON table3 (lower(CAST(col3_1 AS TEXT)), col3_0 DESC, lower(col3_0) ASC);
        postgres_1    |     CREATE INDEX ON table3 (col3_0, col3_2 ASC);
        postgres_1    |     CREATE INDEX ON table3 (col3_1, col3_0 ASC, col3_3, col3_2 ASC);
        postgres_1    |     CREATE INDEX ON table3 (col3_1);
        postgres_1    |     CREATE UNIQUE INDEX ON table3 (col3_1, col3_2 ASC);
        postgres_1    |     CREATE UNIQUE INDEX ON table3 (col3_2);
        postgres_1    |     
        test_1        | --- FAIL: TestCompare (4.72s)
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (1.14s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:135: initializing connection: postgres
        test_1        |         compare_test.go:157: CREATE TABLE table3 (col3_0 "char" NOT NULL, col3_1 BIT(46) NOT NULL, col3_2 DATE NOT NULL, col3_3 BIT(36) NOT NULL, PRIMARY KEY (col3_3, col3_0, col3_1));
        test_1        |             CREATE UNIQUE INDEX ON table3 (col3_2 DESC, col3_0 DESC, col3_1 DESC);
        test_1        |             CREATE INDEX ON table3 (lower(CAST(col3_1 AS TEXT)) DESC, col3_0, col3_1, (CASE WHEN col3_2 IS NULL THEN e'\x00'::TEXT ELSE e'\'\x06VX~+yO'::TEXT END) DESC);
        test_1        |             CREATE INDEX ON table3 (col3_0, col3_2 ASC);
        test_1        |             CREATE INDEX ON table3 (lower(CAST(col3_1 AS TEXT)), col3_0 DESC, lower(col3_0) ASC);
        test_1        |             CREATE INDEX ON table3 (col3_0, col3_2 ASC);
        test_1        |             CREATE INDEX ON table3 (col3_1, col3_0 ASC, col3_3, col3_2 ASC);
        test_1        |             CREATE INDEX ON table3 (col3_1);
        test_1        |             CREATE UNIQUE INDEX ON table3 (col3_1, col3_2 ASC);
        test_1        |             CREATE UNIQUE INDEX ON table3 (col3_2);
        test_1        |             
        test_1        |         compare_test.go:158: postgres: exec: ERROR: invalid byte sequence for encoding "UTF8": 0x00 (SQLSTATE 22021)
        test_1        |     --- FAIL: TestCompare/mutators (0.45s)
        test_1        |         compare_test.go:126: starting test: mutators
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:157: CREATE TABLE table3 (col3_0 "char", col3_1 BIT(48) NOT NULL, col3_2 BOOL NOT NULL, col3_3 VARCHAR NOT NULL, col3_4 FLOAT8, col3_5 BIT(5) NOT NULL, col3_6 REGROLE, col3_7 INT8 NOT NULL, PRIMARY KEY (col3_7 DESC, col3_5 DESC, col3_1 DESC, col3_2), UNIQUE (col3_1 ASC, col3_3 DESC, col3_7 ASC, col3_4), INDEX (col3_5, col3_6 ASC, col3_4, col3_2, col3_0) STORING (col3_3), UNIQUE (lower(col3_0) ASC, col3_4 ASC, col3_1 ASC, col3_6, col3_7 ASC, col3_2) WHERE (((table3.col3_2 OR (table3.col3_4 > 1.7976931348623157e+308:::FLOAT8)) AND (table3.col3_7 = 32767:::INT8)) OR (table3.col3_0 != '':::STRING)) OR (table3.col3_3 > '"':::STRING), INDEX (col3_0 ASC, (CASE WHEN col3_6 IS NULL THEN e'\x00':::STRING ELSE e'9\'uj|J\tT':::STRING END), col3_5 DESC, col3_2, col3_6 ASC, col3_7 ASC, lower(CAST(col3_1 AS STRING)) DESC, col3_3) WHERE (table3.col3_4 > 0.0:::FLOAT8) AND (table3.col3_3 < e'\'':::STRING), INDEX ((CASE WHEN col3_6 IS NULL THEN 'w':::STRING ELSE e'\x1ek':::STRING END), col3_7 DESC, col3_4 ASC, col3_0 DESC, lower(CAST(col3_5 AS STRING)) ASC) STORING (col3_3), INVERTED INDEX (col3_2 DESC, col3_3 ASC, col3_5, col3_7, col3_1, col3_0 gin_trgm_ops ASC) PARTITION BY LIST (col3_2) (PARTITION table3_part_0 VALUES IN ((false,), (true,))) WHERE (((table3.col3_4 < '-Inf':::FLOAT8) OR (table3.col3_7 <= (-128):::INT8)) OR (NOT table3.col3_2)) OR (table3.col3_0 > e'\'':::STRING) NOT VISIBLE, INDEX (col3_5 DESC, col3_3 DESC, lower(CAST(col3_2 AS STRING)) ASC, col3_4 DESC, col3_0 DESC, col3_1 ASC, col3_2, col3_7 DESC) WHERE ((((table3.col3_0 < e'\'':::STRING) AND (table3.col3_4 = 3.4028234663852886e+38:::FLOAT8)) AND (table3.col3_3 >= '':::STRING)) OR (table3.col3_7 < 0:::INT8)) OR table3.col3_2)
        test_1        |         compare_test.go:158: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=a41a7c78-536d-486f-8c8a-70a0496e43ee for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (20.74s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 0ad77cfcc5a81b96dd2f27ed608536388b680537:

        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 ((3.0:::FLOAT8::FLOAT8::FLOAT8 ^ 7.0:::FLOAT8::FLOAT8::FLOAT8)::FLOAT8),
        test_1        |                                 (8.0:::FLOAT8::FLOAT8),
        test_1        |                                 (ceil(7:::INT8::INT4::INT4)::FLOAT8),
        test_1        |                                 (NULL::FLOAT8)
        test_1        |                         )
        test_1        |                             AS tab_37017 (col_57765)
        test_1        |                     ORDER BY
        test_1        |                         tab_37017.col_57765 NULLS FIRST
        test_1        |                 )
        test_1        |                     AS tab_37018
        test_1        |             ORDER BY
        test_1        |                 col_57766;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_37017.col_57765 AS col_57766
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 ((3.0::FLOAT8::FLOAT8::FLOAT8 ^ 7.0::FLOAT8::FLOAT8::FLOAT8)::FLOAT8),
        test_1        |                                 (8.0::FLOAT8::FLOAT8),
        test_1        |                                 (ceil(7::INT8::INT4::INT4)::FLOAT8),
        test_1        |                                 (NULL::FLOAT8)
        test_1        |                         )
        test_1        |                             AS tab_37017 (col_57765)
        test_1        |                     ORDER BY
        test_1        |                         tab_37017.col_57765 NULLS FIRST
        test_1        |                 )
        test_1        |                     AS tab_37018
        test_1        |             ORDER BY
        test_1        |                 col_57766;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (680.70s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 0ad77cfcc5a81b96dd2f27ed608536388b680537:

        postgres_1    | CREATE EXTENSION
        postgres_1    | 
        postgres_1    | waiting for server to shut down....2023-11-25 06:17:07.758 UTC [49] LOG:  received fast shutdown request
        postgres_1    | 2023-11-25 06:17:07.760 UTC [49] LOG:  aborting any active transactions
        postgres_1    | 2023-11-25 06:17:07.761 UTC [49] LOG:  background worker "logical replication launcher" (PID 56) exited with exit code 1
        postgres_1    | 2023-11-25 06:17:07.763 UTC [51] LOG:  shutting down
        postgres_1    | 2023-11-25 06:17:07.866 UTC [49] LOG:  database system is shut down
        postgres_1    |  done
        postgres_1    | server stopped
        postgres_1    | 
        postgres_1    | PostgreSQL init process complete; ready for start up.
        postgres_1    | 
        postgres_1    | 2023-11-25 06:17:07.980 UTC [1] LOG:  starting PostgreSQL 13.5 (Debian 13.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
        postgres_1    | 2023-11-25 06:17:07.980 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2023-11-25 06:17:07.980 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2023-11-25 06:17:07.983 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2023-11-25 06:17:07.988 UTC [68] LOG:  database system was shut down at 2023-11-25 06:17:07 UTC
        postgres_1    | 2023-11-25 06:17:07.993 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2023-11-25 06:17:09.225 UTC [78] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
        postgres_1    | 2023-11-25 06:17:09.225 UTC [78] STATEMENT:  CREATE TABLE table1 (col1_0 TIME NULL, col1_1 TIMETZ NOT NULL, col1_2 BYTEA, col1_3 JSONB NOT NULL, col1_4 OID NULL, col1_5 REGCLASS NULL, col1_6 TIME NULL, col1_7 REGTYPE, col1_8 INT8, col1_9 BIT(41) NOT NULL, col1_10 BIT(15) NOT NULL, col1_11 TIMESTAMPTZ NOT NULL, col1_12 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_1 AS TEXT))) STORED, col1_13 TEXT GENERATED ALWAYS AS (CASE WHEN col1_7 IS NULL THEN e'\f'::TEXT ELSE 'y<'::TEXT END) STORED, col1_14 TEXT NULL GENERATED ALWAYS AS (CASE WHEN col1_5 IS NULL THEN e'9\x03\x14L'::TEXT ELSE ''::TEXT END) STORED, col1_15 TEXT NULL GENERATED ALWAYS AS (lower(CAST(col1_0 AS TEXT))) STORED, col1_16 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_3 AS TEXT))) STORED);
        postgres_1    |     CREATE UNIQUE INDEX ON table1 ((CASE WHEN col1_11 IS NULL THEN e'\x00'::TEXT ELSE e'&W\x15ETKZ'::TEXT END) ASC, col1_6 DESC);
        postgres_1    |     CREATE UNIQUE INDEX ON table1 (col1_13 ASC, col1_15 ASC);
        postgres_1    |     CREATE UNIQUE INDEX ON table1 (col1_13);
        postgres_1    |     
        test_1        | --- FAIL: TestCompare (605.31s)
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (1.07s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:135: initializing connection: postgres
        test_1        |         compare_test.go:157: CREATE TABLE table1 (col1_0 TIME NULL, col1_1 TIMETZ NOT NULL, col1_2 BYTEA, col1_3 JSONB NOT NULL, col1_4 OID NULL, col1_5 REGCLASS NULL, col1_6 TIME NULL, col1_7 REGTYPE, col1_8 INT8, col1_9 BIT(41) NOT NULL, col1_10 BIT(15) NOT NULL, col1_11 TIMESTAMPTZ NOT NULL, col1_12 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_1 AS TEXT))) STORED, col1_13 TEXT GENERATED ALWAYS AS (CASE WHEN col1_7 IS NULL THEN e'\f'::TEXT ELSE 'y<'::TEXT END) STORED, col1_14 TEXT NULL GENERATED ALWAYS AS (CASE WHEN col1_5 IS NULL THEN e'9\x03\x14L'::TEXT ELSE ''::TEXT END) STORED, col1_15 TEXT NULL GENERATED ALWAYS AS (lower(CAST(col1_0 AS TEXT))) STORED, col1_16 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_3 AS TEXT))) STORED);
        test_1        |             CREATE UNIQUE INDEX ON table1 ((CASE WHEN col1_11 IS NULL THEN e'\x00'::TEXT ELSE e'&W\x15ETKZ'::TEXT END) ASC, col1_6 DESC);
        test_1        |             CREATE UNIQUE INDEX ON table1 (col1_13 ASC, col1_15 ASC);
        test_1        |             CREATE UNIQUE INDEX ON table1 (col1_13);
        test_1        |             
        test_1        |         compare_test.go:158: postgres: exec: ERROR: invalid byte sequence for encoding "UTF8": 0x00 (SQLSTATE 22021)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (629.79s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 0ad77cfcc5a81b96dd2f27ed608536388b680537:

        postgres_1    | Loading PostGIS extensions into postgres
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | CREATE EXTENSION
        postgres_1    | 
        postgres_1    | waiting for server to shut down...2023-11-26 06:18:20.423 UTC [49] LOG:  received fast shutdown request
        postgres_1    | .2023-11-26 06:18:20.425 UTC [49] LOG:  aborting any active transactions
        postgres_1    | 2023-11-26 06:18:20.427 UTC [49] LOG:  background worker "logical replication launcher" (PID 56) exited with exit code 1
        postgres_1    | 2023-11-26 06:18:20.429 UTC [51] LOG:  shutting down
        postgres_1    | 2023-11-26 06:18:20.526 UTC [49] LOG:  database system is shut down
        postgres_1    |  done
        postgres_1    | server stopped
        postgres_1    | 
        postgres_1    | PostgreSQL init process complete; ready for start up.
        postgres_1    | 
        postgres_1    | 2023-11-26 06:18:20.646 UTC [1] LOG:  starting PostgreSQL 13.5 (Debian 13.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
        postgres_1    | 2023-11-26 06:18:20.646 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2023-11-26 06:18:20.646 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2023-11-26 06:18:20.650 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2023-11-26 06:18:20.655 UTC [68] LOG:  database system was shut down at 2023-11-26 06:18:20 UTC
        postgres_1    | 2023-11-26 06:18:20.660 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2023-11-26 06:18:21.713 UTC [78] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
        postgres_1    | 2023-11-26 06:18:21.713 UTC [78] STATEMENT:  CREATE TABLE table1 (col1_0 BIT(10) NOT NULL, col1_1 INT2 NOT NULL, col1_2 REGROLE, col1_3 INTERVAL NOT NULL, col1_4 CHAR NOT NULL, col1_5 BOOL NOT NULL, col1_6 INET NOT NULL, col1_7 GEOMETRY, col1_8 TIMETZ NOT NULL, col1_9 TIMESTAMPTZ NOT NULL, col1_10 DECIMAL NOT NULL, col1_11 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_3 IS NULL THEN e'l{zZxO\x17_'::TEXT ELSE 'T'::TEXT END) STORED, col1_12 TEXT NULL GENERATED ALWAYS AS (lower(CAST(col1_8 AS TEXT))) STORED, col1_13 INT8 NOT NULL GENERATED ALWAYS AS (col1_1 + 13774::INT8) STORED, col1_14 DECIMAL NOT NULL GENERATED ALWAYS AS (col1_10 + (-6.996683250017624301E+35)::DECIMAL) STORED, col1_15 DECIMAL NOT NULL GENERATED ALWAYS AS (col1_10 + 10513236.074417715::DECIMAL) STORED, col1_16 INT8 NOT NULL GENERATED ALWAYS AS (col1_1 + (-23501)::INT8) STORED, col1_17 DECIMAL NOT NULL GENERATED ALWAYS AS (col1_10 + (-6.479164826567146043E+21)::DECIMAL) STORED, col1_18 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_9 IS NULL THEN e'VHm)\x03'::TEXT ELSE e'\x00'::TEXT END) STORED, PRIMARY KEY (col1_8));
        postgres_1    |     CREATE INDEX ON table1 (col1_0 ASC, col1_8 DESC, col1_13, col1_11 ASC, col1_6 DESC);
        postgres_1    |     
        test_1        | --- FAIL: TestCompare (605.24s)
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (0.91s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:135: initializing connection: postgres
        test_1        |         compare_test.go:157: CREATE TABLE table1 (col1_0 BIT(10) NOT NULL, col1_1 INT2 NOT NULL, col1_2 REGROLE, col1_3 INTERVAL NOT NULL, col1_4 CHAR NOT NULL, col1_5 BOOL NOT NULL, col1_6 INET NOT NULL, col1_7 GEOMETRY, col1_8 TIMETZ NOT NULL, col1_9 TIMESTAMPTZ NOT NULL, col1_10 DECIMAL NOT NULL, col1_11 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_3 IS NULL THEN e'l{zZxO\x17_'::TEXT ELSE 'T'::TEXT END) STORED, col1_12 TEXT NULL GENERATED ALWAYS AS (lower(CAST(col1_8 AS TEXT))) STORED, col1_13 INT8 NOT NULL GENERATED ALWAYS AS (col1_1 + 13774::INT8) STORED, col1_14 DECIMAL NOT NULL GENERATED ALWAYS AS (col1_10 + (-6.996683250017624301E+35)::DECIMAL) STORED, col1_15 DECIMAL NOT NULL GENERATED ALWAYS AS (col1_10 + 10513236.074417715::DECIMAL) STORED, col1_16 INT8 NOT NULL GENERATED ALWAYS AS (col1_1 + (-23501)::INT8) STORED, col1_17 DECIMAL NOT NULL GENERATED ALWAYS AS (col1_10 + (-6.479164826567146043E+21)::DECIMAL) STORED, col1_18 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_9 IS NULL THEN e'VHm)\x03'::TEXT ELSE e'\x00'::TEXT END) STORED, PRIMARY KEY (col1_8));
        test_1        |             CREATE INDEX ON table1 (col1_0 ASC, col1_8 DESC, col1_13, col1_11 ASC, col1_6 DESC);
        test_1        |             
        test_1        |         compare_test.go:158: postgres: exec: ERROR: invalid byte sequence for encoding "UTF8": 0x00 (SQLSTATE 22021)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (630.03s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 0ad77cfcc5a81b96dd2f27ed608536388b680537:

        test_1        |                         tab_35082.col_58935 AS col_58937, 'B':::STRING::"char" AS col_58938
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (NULL::TIMESTAMPTZ, 'B':::STRING::"char"),
        test_1        |                                 ('2000-01-01 00:00:00+00:00':::TIMESTAMPTZ::TIMESTAMPTZ, 'E':::STRING::"char"),
        test_1        |                                 ('2000-01-01 07:00:00+00:00':::TIMESTAMPTZ::TIMESTAMPTZ, 'C':::STRING::"char")
        test_1        |                         )
        test_1        |                             AS tab_35082 (col_58935, col_58936)
        test_1        |                     ORDER BY
        test_1        |                         tab_35082.col_58936 DESC, tab_35082.col_58935 ASC, tab_35082.col_58936 ASC NULLS LAST
        test_1        |                 )
        test_1        |                     AS tab_35083
        test_1        |             ORDER BY
        test_1        |                 col_58937 DESC, col_58938 ASC;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_35082.col_58935 AS col_58937, 'B'::TEXT::"char" AS col_58938
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (NULL::TIMESTAMPTZ, 'B'::TEXT::"char"),
        test_1        |                                 ('2000-01-01 00:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ, 'E'::TEXT::"char"),
        test_1        |                                 ('2000-01-01 07:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ, 'C'::TEXT::"char")
        test_1        |                         )
        test_1        |                             AS tab_35082 (col_58935, col_58936)
        test_1        |                     ORDER BY
        test_1        |                         tab_35082.col_58936 DESC, tab_35082.col_58935 ASC, tab_35082.col_58936 ASC NULLS LAST
        test_1        |                 )
        test_1        |                     AS tab_35083
        test_1        |             ORDER BY
        test_1        |                 col_58937 DESC, col_58938 ASC;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (678.85s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 0ad77cfcc5a81b96dd2f27ed608536388b680537:

        test_1        |         compare_test.go:135: initializing connection: postgres
        test_1        |         compare_test.go:186: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare486190223/002/postgres.log: no such file or directory
        test_1        |         compare_test.go:188: compare cockroach1 to postgres: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |             -   string("10010000000000"),
        test_1        |             +   nil,
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_106660.col_181847 AS col_181848
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (B'0001'::BIT(14)),
        test_1        |                                 (B'0101'::BIT(14)),
        test_1        |                                 (NULL::BIT(14)),
        test_1        |                                 (NULL::BIT(14)),
        test_1        |                                 (B'1001'::BIT(14)),
        test_1        |                                 (B'0101'::BIT(14))
        test_1        |                         )
        test_1        |                             AS tab_106660 (col_181847)
        test_1        |                     ORDER BY
        test_1        |                         tab_106660.col_181847 DESC NULLS LAST,
        test_1        |                         tab_106660.col_181847 NULLS LAST,
        test_1        |                         tab_106660.col_181847 DESC NULLS FIRST,
        test_1        |                         tab_106660.col_181847 ASC,
        test_1        |                         tab_106660.col_181847 DESC NULLS LAST
        test_1        |                 )
        test_1        |                     AS tab_106661
        test_1        |             ORDER BY
        test_1        |                 col_181848 DESC;
        test_1        |             
        test_1        |             postgres: [same as previous]
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (176.71s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 0ad77cfcc5a81b96dd2f27ed608536388b680537:

        test_1        |                                 (1.0:::FLOAT8::FLOAT8, B'0010'::BIT(33)),
        test_1        |                                 (2.0:::FLOAT8::FLOAT8, NULL::BIT(33))
        test_1        |                         )
        test_1        |                             AS tab_42596 (col_74260, col_74261)
        test_1        |                     ORDER BY
        test_1        |                         tab_42596.col_74261 DESC, tab_42596.col_74261 NULLS FIRST
        test_1        |                 )
        test_1        |                     AS tab_42597
        test_1        |             ORDER BY
        test_1        |                 col_74262, col_74263 DESC NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_42596.col_74261 AS col_74262, tab_42596.col_74260 AS col_74263
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (NULL::FLOAT8, B'0011'::BIT(33)),
        test_1        |                                 (1.0::FLOAT8::FLOAT8, B'0010'::BIT(33)),
        test_1        |                                 (2.0::FLOAT8::FLOAT8, NULL::BIT(33))
        test_1        |                         )
        test_1        |                             AS tab_42596 (col_74260, col_74261)
        test_1        |                     ORDER BY
        test_1        |                         tab_42596.col_74261 DESC, tab_42596.col_74261 NULLS FIRST
        test_1        |                 )
        test_1        |                     AS tab_42597
        test_1        |             ORDER BY
        test_1        |                 col_74262, col_74263 DESC NULLS LAST;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.18s)
        test_1        |         compare_test.go:126: starting test: mutators
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:157: CREATE TABLE table2 (col2_0 BOOL NOT NULL, col2_1 VARCHAR NOT NULL, col2_2 UUID NOT NULL, col2_3 DATE NOT NULL, col2_4 UUID NOT NULL, col2_5 BYTES NOT NULL, col2_6 TIME NOT NULL, col2_7 BYTES NOT NULL, col2_8 STRING NOT NULL AS (lower(CAST(col2_2 AS STRING))) STORED, col2_9 STRING NOT NULL AS (CASE WHEN col2_5 IS NULL THEN e'\x0eG':::STRING ELSE e'4Nv9\x1d_\x19\x1b':::STRING END) VIRTUAL, col2_10 STRING NOT NULL AS (CASE WHEN col2_5 IS NULL THEN 'QX':::STRING ELSE '':::STRING END) VIRTUAL, col2_11 STRING NOT NULL AS (lower(CAST(col2_0 AS STRING))) VIRTUAL, col2_12 STRING NOT NULL AS (lower(CAST(col2_0 AS STRING))) VIRTUAL, col2_13 STRING NOT NULL AS (CASE WHEN col2_5 IS NULL THEN 'Gn,*':::STRING ELSE e'(3{\x05^;':::STRING END) VIRTUAL, col2_14 STRING NOT NULL AS (lower(CAST(col2_4 AS STRING))) STORED, INDEX (col2_6 ASC, col2_0 ASC, col2_4 DESC), INDEX (col2_2 DESC, col2_4 ASC, col2_11, col2_6 DESC, col2_0 DESC, col2_9, col2_14 DESC, col2_5, col2_1 ASC, col2_7 DESC, col2_12 DESC, col2_10 ASC) WHERE table2.col2_10 <= e'\x00':::STRING, UNIQUE (col2_1 DESC), INDEX (col2_6 DESC, col2_0 DESC, col2_11, lower(CAST(col2_0 AS STRING)) ASC, col2_12 ASC, col2_7 DESC) STORING (col2_1, col2_3, col2_8, col2_14) WHERE ((table2.col2_1 <= e'\U00002603':::STRING) AND (table2.col2_9 != e'\x00':::STRING)) AND (table2.col2_6 >= '00:00:00':::TIME), INDEX (col2_10 DESC, col2_12 DESC, col2_14 DESC, col2_2, col2_5 ASC, col2_7 ASC, col2_1) PARTITION BY LIST (col2_10, col2_12, col2_14, col2_2) (PARTITION table2_part_0 VALUES IN ((e'P)\x07-s]m':::STRING, e';J\x03A)J':::STRING, 'Ueil':::STRING, '91f02ce8-bacc-4a54-886d-69d2239e511a':::UUID)), PARTITION table2_part_1 VALUES IN ((e'RZV]\x11B\x19\x05':::STRING, e'\x19\x17\f\x15':::STRING, '':::STRING, '2d711b9f-1e37-4031-890a-7a02c7b6d455':::UUID)), PARTITION table2_part_2 VALUES IN ((e'b\x04f\x0b':::STRING, 'tzi':::STRING, e'p\rBVR':::STRING, 'c5e1ff4c-8ea5-41d0-a169-c34a278ab2cc':::UUID)), PARTITION table2_part_3 VALUES IN ((e'\x01MF\x16p@pf':::STRING, 'e7':::STRING, 'j':::STRING, '736b4f18-5d25-4897-99fa-c8ca8ab6d37a':::UUID)), PARTITION table2_part_4 VALUES IN ((e'=>,\x13>\x05\\43':::STRING, e'\x1d\x021\tV6u}@':::STRING, e'\x1e!W!':::STRING, '007e8860-734b-468d-b9e9-55f4db4e1349':::UUID)), PARTITION table2_part_5 VALUES IN ((e'\'_':::STRING, '#0F@V':::STRING, '':::STRING, '4994c381-4c8c-4404-954f-7ee13b53c00f':::UUID)), PARTITION table2_part_6 VALUES IN (('':::STRING, e'\x01\x12N#Mk``':::STRING, e'qj\x0f\x02|r_':::STRING, 'd43fc808-e004-4a9e-8d79-930fd38e07cb':::UUID)), PARTITION table2_part_7 VALUES IN ((e'V_~s\rc%S':::STRING, e'\f\\\x0b_R\\g,':::STRING, '<':::STRING, 'c8f82f62-af19-4273-adcb-f5ad4d65ce39':::UUID)), PARTITION table2_part_8 VALUES IN ((e'e s\rBA\x17':::STRING, '':::STRING, 'F(j':::STRING, 'a499180e-bacc-4e97-ad5e-96fc6ca36424':::UUID)), PARTITION table2_part_9 VALUES IN ((e'\x7fb+\x04_c':::STRING, e'e#,\x0eW[\x06\x03':::STRING, '&':::STRING, '00000000-0000-0000-0000-000000000000':::UUID))), UNIQUE (col2_3 DESC, col2_6, col2_13 DESC) STORING (col2_0, col2_2, col2_4, col2_8) WHERE ((((((((table2.col2_12 = '':::STRING) OR (table2.col2_14 < 'X':::STRING)) OR (table2.col2_5 < '\xe29883':::BYTES)) OR (table2.col2_13 < e'\'':::STRING)) AND (table2.col2_9 != 'X':::STRING)) OR (table2.col2_6 < '24:00:00':::TIME)) AND (table2.col2_3 <= '-infinity':::DATE)) OR (table2.col2_1 >= e'\x00':::STRING)) OR (table2.col2_10 >= 'X':::STRING), UNIQUE (col2_3 DESC, col2_10, col2_8 DESC, col2_2, col2_5 ASC, col2_1, col2_14 DESC, col2_0 ASC, col2_6 ASC, col2_11, lower(CAST(col2_2 AS STRING)) DESC, col2_12, col2_13 DESC, col2_9 ASC), INDEX (col2_9, col2_14, col2_8 DESC, col2_2, col2_7, col2_0, col2_4 DESC) STORING (col2_1, col2_5, col2_6), FAMILY (col2_8, col2_7), FAMILY (col2_4, col2_3), FAMILY (col2_5), FAMILY (col2_14), FAMILY (col2_6, col2_2, col2_0), FAMILY (col2_1))
        test_1        |         compare_test.go:158: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=bd401cde-8ace-4e31-ba37-d5b14d9f12f1 for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (89.13s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 0ad77cfcc5a81b96dd2f27ed608536388b680537:

        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         '2000-01-01 01:00:00+00:00':::TIMESTAMPTZ::TIMESTAMPTZ AS col_75133,
        test_1        |                         NULL::INT2VECTOR AS col_75134,
        test_1        |                         tab_45232.col_75130 AS col_75135
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (NULL::INTERVAL, '2000-01-01 09:00:00+00:00':::TIMESTAMPTZ::TIMESTAMPTZ, NULL::INT2VECTOR),
        test_1        |                                 ('00:00:01':::INTERVAL::INTERVAL, NULL::TIMESTAMPTZ, NULL::INT2VECTOR),
        test_1        |                                 (
        test_1        |                                     '00:00:03':::INTERVAL::INTERVAL,
        test_1        |                                     '2000-01-01 05:00:00+00:00':::TIMESTAMPTZ::TIMESTAMPTZ,
        test_1        |                                     NULL::INT2VECTOR
        test_1        |                                 ),
        test_1        |                                 (
        test_1        |                                     '00:00:08':::INTERVAL::INTERVAL,
        test_1        |                                     '2000-01-01 08:00:00+00:00':::TIMESTAMPTZ::TIMESTAMPTZ,
        test_1        |                                     NULL::INT2VECTOR
        test_1        |                                 ),
        test_1        |                                 (NULL::INTERVAL, '2000-01-01 04:00:00+00:00':::TIMESTAMPTZ::TIMESTAMPTZ, NULL::INT2VECTOR)
        test_1        |                         )
        test_1        |                             AS tab_45232 (col_75130, col_75131, col_75132)
        test_1        |                     WHERE
        test_1        |                         true::BOOL
        test_1        |                 )
        test_1        |                     AS tab_45233
        test_1        |             ORDER BY
        test_1        |                 col_75133 ASC NULLS LAST, col_75134 DESC, col_75135;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.36s)
        test_1        |         compare_test.go:126: starting test: mutators
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:157: CREATE TABLE table2 (col2_0 INTERVAL NOT NULL, col2_1 CHAR NOT NULL, col2_2 BYTES NOT NULL, col2_3 "char" NOT NULL, col2_4 GEOGRAPHY NOT NULL, col2_5 FLOAT8 NOT NULL, col2_6 DECIMAL NOT NULL, col2_7 BOOL NOT NULL, col2_8 INET NULL, col2_9 STRING COLLATE da_DK NOT NULL, col2_10 TIMESTAMP NOT NULL, col2_11 STRING NOT NULL AS (lower(col2_3)) VIRTUAL, PRIMARY KEY (col2_9 DESC, col2_7, col2_10, col2_11, col2_5 ASC, col2_1 DESC), UNIQUE (col2_9 ASC, col2_2, col2_3 DESC, col2_5, col2_6 ASC, col2_8 DESC) PARTITION BY LIST (col2_9, col2_2, col2_3) (PARTITION table2_part_0 VALUES IN ((e'\U00026606\U00058E7B\U000A7958' COLLATE da_DK, '\xb0e368675a':::BYTES, '%':::STRING), (e'\U0001EE68\U00064F49\U000C9694\U000347E7\U000C165B\U00012F44' COLLATE da_DK, '\x5a':::BYTES, '6':::STRING), (e'\U0001C9D6\U0004DF57\U000B2449\U000E97F9\U000BA82B\U00092666' COLLATE da_DK, '\x08de51c5f3ce7f':::BYTES, e'\x1a':::STRING), (e'\U0000B26E' COLLATE da_DK, '\x00':::BYTES, e'\x10':::STRING), (e'\U0003B000\U000CC8C5\U00072B31' COLLATE da_DK, '\xf382f0e65fa3':::BYTES, e'\x07':::STRING), ('' COLLATE da_DK, '\xf9126ef990':::BYTES, '-':::STRING), (e'\U00080BB6' COLLATE da_DK, '\x93cc':::BYTES, 'O':::STRING)), PARTITION table2_part_1 VALUES IN ((e'\U0004ABCB\U00026B51' COLLATE da_DK, '\xdb2a889c35':::BYTES, 'W':::STRING), (e'\U00022AAE\U0003D57D' COLLATE da_DK, '\x67579f4fa5f41b71':::BYTES, '3':::STRING), ('' COLLATE da_DK, '\xa4ed71':::BYTES, ',':::STRING), ('' COLLATE da_DK, '\x786443ba3306':::BYTES, 'I':::STRING), (e'\U00070A6D\U000A1BA7\U0008B1D0\U0009D77F\U000B2368\U000BDDA1' COLLATE da_DK, '\xfe0188':::BYTES, 'i':::STRING), (e'\U000064A1' COLLATE da_DK, '\x':::BYTES, e'\x00':::STRING), (e'\U00040300\U0003D402\U000AFBD6' COLLATE da_DK, '\x':::BYTES, e'\x11':::STRING)), PARTITION table2_part_2 VALUES IN ((e'\U0009FE0E\U000B5F0F' COLLATE da_DK, '\x0e41326cd3bff6':::BYTES, '@':::STRING), (e'\U00078D7C' COLLATE da_DK, '\x81':::BYTES, ';':::STRING), (e'\U00025337\U0006552B\U000308C8\U00044DBA\U00069E9A\U000439E1\U0004593A\U0002421D\U000CB133' COLLATE da_DK, '\xb12e':::BYTES, 'k':::STRING), (e'\U0007165C\U0009F9C0\U0003F41F\U0005BCF7\U000B7F3F\U000350B8' COLLATE da_DK, '\xadb458353e22658c0e':::BYTES, '0':::STRING), (e'\U0008C2AA' COLLATE da_DK, '\x29c5ffc70c':::BYTES, e'\r':::STRING), (e'\U00064A59\U000CEC6B\U00089837' COLLATE da_DK, '\x35a37c1dab61':::BYTES, 'u':::STRING), (e'\U000CB438\U0008BCB6\U0009B2CA\U000A4451' COLLATE da_DK, '\x45259f4d3edf35cd0c':::BYTES, e'\x18':::STRING)), PARTITION table2_part_3 VALUES IN ((e'\U00018BA4' COLLATE da_DK, '\x524c':::BYTES, 'X':::STRING), (e'\U0006A1E3\U0005DF86\U000C2752\U0003C9BE\U00045595' COLLATE da_DK, '\xf594e794218f90':::BYTES, 'M':::STRING), ('' COLLATE da_DK, '\x09161f1da6d88f624c':::BYTES, '"':::STRING), (e'\U000AAEE9\U0008744D\U000AD509\U000691B1\U0007F79C\U000A8B93\U00069FF1' COLLATE da_DK, '\xff':::BYTES, 'l':::STRING), (e'\U000D4078\U0001A7BB\U00083219' COLLATE da_DK, '\x58':::BYTES, '|':::STRING), (e'\U000B53F9\U0005F3DC\U0002B0D4\U00082ACD\U000E0582\U0004445B\U000B043B\U000B4CC4\U000EBDD0' COLLATE da_DK, '\x6e396a07761057':::BYTES, e'\x0b':::STRING), (e'\U0006A4C8' COLLATE da_DK, '\x76':::BYTES, e'\x1f':::STRING)), PARTITION table2_part_4 VALUES IN ((e'\U000090C9\U000E8947\U000A3447\U00048DDE\U000E0876\U00071FC5\U0005293D\U0005F0AB' COLLATE da_DK, '\x5e5fab75946e':::BYTES, 'Z':::STRING), (e'\U00004318\U00037B5D' COLLATE da_DK, '\x3a6c05cf296f':::BYTES, '``':::STRING), ('' COLLATE da_DK, '\xd4645b47802a41499b':::BYTES, '':::STRING), (e'\U0003D799\U00066B23\U000605CC\U000EEDA0\U000B3AD3\U0003218C' COLLATE da_DK, '\x2a5bba5fb3':::BYTES, 'o':::STRING), (e'\U000C73E1\U00041327\U000C539F\U000E662E\U00004005\U0002C4A9\U00079760\U000B4023\U000AF0A9' COLLATE da_DK, '\xc2b81c239d4d':::BYTES, 'N':::STRING), (e'\U0003E5B3\U000C2E3D\U000100D6\U0003DCE6\U000C95C4\U00049341\U000C6AEE' COLLATE da_DK, '\xc56cd91b4107':::BYTES, '9':::STRING), (e'\U0008D520\U000E2762\U00021D01\U00080649' COLLATE da_DK, '\x4827a7':::BYTES, '&':::STRING)), PARTITION table2_part_5 VALUES IN ((e'\U00029218\U0002CFC2\U000CE416\U0009967F\U0004B697' COLLATE da_DK, '\xc9d9523f':::BYTES, '=':::STRING), (e'\U000D00C0\U00093333\U000E6464\U00041689\U00013D5D\U000175C9' COLLATE da_DK, '\x':::BYTES, 'L':::STRING), (e'\U000AEEB5\U0008C7B7\U000D7E9C' COLLATE da_DK, '\x0b':::BYTES, 'T':::STRING), ('' COLLATE da_DK, '\x5d174b731793':::BYTES, e'\'':::STRING), (e'\U00008951\U000088C0' COLLATE da_DK, '\xb6274fc6de':::BYTES, e'\x00':::STRING), ('' COLLATE da_DK, '\x4df99bc03e67':::BYTES, e'\x18':::STRING), (e'\U000614A9\U00032B5F\U000ABA56\U00096666\U000994FF\U000D983D' COLLATE da_DK, '\x9f251f097a':::BYTES, e'\b':::STRING)), PARTITION table2_part_6 VALUES IN (('' COLLATE da_DK, '\x2c2348':::BYTES, 'e':::STRING), (e'\U000AD4A4\U000CE20E\U000E9DD6\U0006F6B0\U000EFB67\U00036B08\U000722B4\U0009B62B\U0004449C' COLLATE da_DK, '\x6aa8ea805a5a43':::BYTES, 'l':::STRING), (e'\U000BE23C\U00092724\U00045A90' COLLATE da_DK, '\x0a92ea7dcb82':::BYTES, 'T':::STRING), (e'\U000DD1EB\U000C4443\U000BE117' COLLATE da_DK, '\xf1e27acbeaad9443':::BYTES, 'f':::STRING), (e'\U000EA5E9\U00050B15\U0008BF13\U000AC955' COLLATE da_DK, '\xce4b3d':::BYTES, e'\x1e':::STRING), (e'\U0008C94E\U0003BB5E' COLLATE da_DK, '\xc5bd6a5d7b':::BYTES, 'w':::STRING), (e'\U00064BC4\U00035974\U000B105D' COLLATE da_DK, '\xff':::BYTES, e'\x12':::STRING))), INVERTED INDEX (col2_10, col2_2, col2_8 ASC, col2_1 ASC, col2_3 DESC, col2_0 DESC, col2_11 DESC, col2_6, col2_5 DESC, col2_9 ASC, col2_4), FAMILY (col2_7), FAMILY (col2_6), FAMILY (col2_9), FAMILY (col2_5), FAMILY (col2_0), FAMILY (col2_1, col2_10, col2_8), FAMILY (col2_3, col2_4, col2_2))
        test_1        |         compare_test.go:158: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=17b83e19-3e50-4d22-8af3-31b1e8530583 for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (96.36s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ 0ad77cfcc5a81b96dd2f27ed608536388b680537:

        postgres_1    |         col_8712 DESC NULLS FIRST, col_8713 NULLS LAST, col_8714 NULLS FIRST
        test_1        | --- FAIL: TestCompare (11.05s)
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (7.75s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:135: initializing connection: postgres
        test_1        |         compare_test.go:186: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare2168096803/002/postgres.log: no such file or directory
        test_1        |         compare_test.go:188: compare cockroach1 to postgres: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |             -   nil,
        test_1        |             +   string("0101000000000000000000"),
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_5695.col_8719 AS col_8720
        test_1        |                     FROM
        test_1        |                         (VALUES (B'0101'::BIT(22)), (B'1001'::BIT(22)), (NULL::BIT(22))) AS tab_5695 (col_8719)
        test_1        |                     ORDER BY
        test_1        |                         tab_5695.col_8719 DESC NULLS FIRST
        test_1        |                 )
        test_1        |                     AS tab_5696
        test_1        |             ORDER BY
        test_1        |                 col_8720 ASC;
        test_1        |             
        test_1        |             postgres: [same as previous]
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.18s)
        test_1        |         compare_test.go:126: starting test: mutators
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:157: CREATE TABLE table1 (col1_0 TIMESTAMPTZ NOT NULL, col1_1 REGCLASS NOT NULL, col1_2 GEOMETRY, col1_3 REGCLASS NOT NULL, col1_4 DECIMAL NOT NULL, col1_5 STRING NOT NULL, col1_6 STRING NOT NULL AS (CASE WHEN col1_1 IS NULL THEN 'z':::STRING ELSE e'Ept[H\x05Fy':::STRING END) VIRTUAL, col1_7 STRING NOT NULL AS (lower(CAST(col1_2 AS STRING))) STORED, col1_8 STRING NOT NULL AS (CASE WHEN col1_0 IS NULL THEN e'A7\f\x05':::STRING ELSE e'\x19B\x19\x11\x102\x1a':::STRING END) STORED, PRIMARY KEY (col1_1 DESC, col1_5 ASC, col1_0 DESC, col1_4 ASC, col1_7 ASC, col1_6 ASC, col1_3, col1_8 DESC), UNIQUE (col1_4 ASC, col1_6, col1_7) STORING (col1_2), UNIQUE (col1_8 ASC, col1_7 ASC, col1_1 DESC, col1_0 ASC, col1_6, col1_3, col1_5, (CASE WHEN col1_1 IS NULL THEN '':::STRING ELSE e'u\x7f5K\x0e':::STRING END)) WHERE table1.col1_4 = 1:::DECIMAL, INDEX (col1_1 ASC, col1_4 DESC, col1_6 DESC, col1_3 ASC, (CASE WHEN col1_1 IS NULL THEN e'F3\x02\f\x19\x05\x02b':::STRING ELSE e'\x0e_\x01Q':::STRING END) ASC, col1_5 ASC) STORING (col1_2) PARTITION BY LIST (col1_1, col1_4) (PARTITION table1_part_0 VALUES IN ((3330994356:::OID, 20810.26822628233076:::DECIMAL), (2728238425:::OID, (-2645774.26071359979):::DECIMAL), (4115180785:::OID, (-909.8306811860080578):::DECIMAL), (3958756413:::OID, (-4.243951374905190559E+21):::DECIMAL), (946782614:::OID, 3156354870651179.383:::DECIMAL), (3367230260:::OID, (-124098011066110.4193):::DECIMAL))), FAMILY (col1_5, col1_4), FAMILY (col1_7), FAMILY (col1_3, col1_2, col1_1), FAMILY (col1_8, col1_0))
        test_1        |         compare_test.go:158: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=742a66f7-e7e4-45d8-a2c0-0283f5da506f for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (35.04s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ fe952a17ef54e8ca628e9287e07b660fc87a5830:

        postgres_1    | server stopped
        postgres_1    | 
        postgres_1    | PostgreSQL init process complete; ready for start up.
        postgres_1    | 
        postgres_1    | 2023-12-02 06:17:17.404 UTC [1] LOG:  starting PostgreSQL 13.5 (Debian 13.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
        postgres_1    | 2023-12-02 06:17:17.404 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2023-12-02 06:17:17.404 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2023-12-02 06:17:17.407 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2023-12-02 06:17:17.412 UTC [69] LOG:  database system was shut down at 2023-12-02 06:17:17 UTC
        postgres_1    | 2023-12-02 06:17:17.417 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2023-12-02 06:17:18.552 UTC [79] ERROR:  invalid input syntax for type numeric: "Infinity" at character 795
        postgres_1    | 2023-12-02 06:17:18.552 UTC [79] STATEMENT:  CREATE TABLE table2 (col2_0 DECIMAL NOT NULL, col2_1 INT2 NOT NULL, col2_2 BYTEA NULL, col2_3 FLOAT4 NOT NULL, col2_4 FLOAT8 NOT NULL GENERATED ALWAYS AS (col2_3 + (-0.8347389101982117)::FLOAT8) STORED, PRIMARY KEY (col2_3));
        postgres_1    |     CREATE UNIQUE INDEX ON table2 (col2_0, col2_2, (col2_1 + (-19255)::INT8), col2_1 DESC, col2_3 ASC);
        postgres_1    |     CREATE UNIQUE INDEX ON table2 (col2_3 ASC, col2_0, (col2_3 + (-1.376515507698059)::FLOAT8), col2_2 DESC) INCLUDE (col2_1);
        postgres_1    |     CREATE UNIQUE INDEX ON table2 (col2_3 ASC, col2_0, col2_1, col2_2 DESC);
        postgres_1    |     CREATE UNIQUE INDEX ON table2 (col2_3 ASC);
        postgres_1    |     CREATE UNIQUE INDEX ON table2 (col2_1, col2_4 DESC, col2_0, col2_2 DESC, col2_3);
        postgres_1    |     CREATE UNIQUE INDEX ON table2 ((col2_1 + 11661::INT8) ASC, col2_4, col2_0 DESC);
        postgres_1    |     CREATE UNIQUE INDEX ON table2 (col2_1 ASC, col2_3 ASC, (col2_0 + 'Infinity'::DECIMAL) DESC, col2_2);
        postgres_1    |     
        test_1        | --- FAIL: TestCompare (604.59s)
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (0.90s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:135: initializing connection: postgres
        test_1        |         compare_test.go:157: CREATE TABLE table2 (col2_0 DECIMAL NOT NULL, col2_1 INT2 NOT NULL, col2_2 BYTEA NULL, col2_3 FLOAT4 NOT NULL, col2_4 FLOAT8 NOT NULL GENERATED ALWAYS AS (col2_3 + (-0.8347389101982117)::FLOAT8) STORED, PRIMARY KEY (col2_3));
        test_1        |             CREATE UNIQUE INDEX ON table2 (col2_0, col2_2, (col2_1 + (-19255)::INT8), col2_1 DESC, col2_3 ASC);
        test_1        |             CREATE UNIQUE INDEX ON table2 (col2_3 ASC, col2_0, (col2_3 + (-1.376515507698059)::FLOAT8), col2_2 DESC) INCLUDE (col2_1);
        test_1        |             CREATE UNIQUE INDEX ON table2 (col2_3 ASC, col2_0, col2_1, col2_2 DESC);
        test_1        |             CREATE UNIQUE INDEX ON table2 (col2_3 ASC);
        test_1        |             CREATE UNIQUE INDEX ON table2 (col2_1, col2_4 DESC, col2_0, col2_2 DESC, col2_3);
        test_1        |             CREATE UNIQUE INDEX ON table2 ((col2_1 + 11661::INT8) ASC, col2_4, col2_0 DESC);
        test_1        |             CREATE UNIQUE INDEX ON table2 (col2_1 ASC, col2_3 ASC, (col2_0 + 'Infinity'::DECIMAL) DESC, col2_2);
        test_1        |             
        test_1        |         compare_test.go:158: postgres: exec: ERROR: invalid input syntax for type numeric: "Infinity" (SQLSTATE 22P02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (629.15s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ fe952a17ef54e8ca628e9287e07b660fc87a5830:

        test_1        |         compare_test.go:186: open /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/_tmp/018812dfcf0ce383ac3e799915a61396/TestComposeCompare2662473284/002/postgres.log: no such file or directory
        test_1        |         compare_test.go:188: compare postgres to cockroach1: unexpected diff:
        test_1        |               []any(Inverse(func1, []any{
        test_1        |             -   string("00000000000000000000000000000000000000000000"),
        test_1        |             +   nil,
        test_1        |               }))
        test_1        |             cockroach1:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_11153.col_20797 AS col_20798
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (B'0011'::BIT(44)),
        test_1        |                                 (B'0010'::BIT(44)),
        test_1        |                                 (B'0001'::BIT(44)),
        test_1        |                                 (B'0101'::BIT(44)),
        test_1        |                                 (NULL::BIT(44)),
        test_1        |                                 (B'0000'::BIT(44))
        test_1        |                         )
        test_1        |                             AS tab_11153 (col_20797)
        test_1        |                     ORDER BY
        test_1        |                         tab_11153.col_20797 NULLS LAST, tab_11153.col_20797 NULLS LAST, tab_11153.col_20797 DESC
        test_1        |                 )
        test_1        |                     AS tab_11154
        test_1        |             ORDER BY
        test_1        |                 col_20798;
        test_1        |             
        test_1        |             postgres: [same as previous]
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.14s)
        test_1        |         compare_test.go:126: starting test: mutators
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:157: CREATE TABLE table1 (col1_0 TIMETZ NOT NULL, col1_1 DECIMAL NOT NULL, col1_2 INT8 NOT NULL, col1_3 OID[] NOT NULL, col1_4 BIT(22) NOT NULL, UNIQUE (col1_1 DESC, col1_4, col1_0) PARTITION BY LIST (col1_1) (PARTITION table1_part_0 VALUES IN ((851.6186859338704348:::DECIMAL,), (8.568265883964343884E+24:::DECIMAL,)), PARTITION table1_part_1 VALUES IN (((-68305409330327.06532):::DECIMAL,), ((-1.747040426888965701E+29):::DECIMAL,)), PARTITION table1_part_2 VALUES IN ((1028022747750.496780:::DECIMAL,), ((-7536339888136390757):::DECIMAL,)), PARTITION "DEFAULT" VALUES IN ((DEFAULT,))) WHERE ((table1.col1_2 = (-128):::INT8) AND (table1.col1_1 <= (-1.234E+401):::DECIMAL)) OR (table1.col1_0 > '24:00:00-15:59:00':::TIMETZ), INDEX (col1_4 DESC, lower(CAST(col1_4 AS STRING)) DESC, col1_0) STORING (col1_2, col1_3))
        test_1        |         compare_test.go:158: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=a2e44c4f-b448-4712-ad3b-b449ecefd1c0 for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (41.98s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ fe952a17ef54e8ca628e9287e07b660fc87a5830:

        postgres_1    | 
        postgres_1    | PostgreSQL init process complete; ready for start up.
        postgres_1    | 
        postgres_1    | 2023-12-04 06:18:12.844 UTC [1] LOG:  starting PostgreSQL 13.5 (Debian 13.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
        postgres_1    | 2023-12-04 06:18:12.845 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
        postgres_1    | 2023-12-04 06:18:12.845 UTC [1] LOG:  listening on IPv6 address "::", port 5432
        postgres_1    | 2023-12-04 06:18:12.849 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
        postgres_1    | 2023-12-04 06:18:12.855 UTC [68] LOG:  database system was shut down at 2023-12-04 06:18:12 UTC
        postgres_1    | 2023-12-04 06:18:12.861 UTC [1] LOG:  database system is ready to accept connections
        postgres_1    | 2023-12-04 06:18:14.210 UTC [78] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
        postgres_1    | 2023-12-04 06:18:14.210 UTC [78] STATEMENT:  CREATE TABLE table4 (col4_0 INTERVAL NOT NULL, col4_1 INT2 NOT NULL, col4_2 DECIMAL, col4_3 TIMETZ NOT NULL, col4_4 REGROLE NOT NULL, col4_5 TEXT NOT NULL, col4_6 TEXT NOT NULL, col4_7 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col4_0 IS NULL THEN ''::TEXT ELSE e'%8\x0e^'::TEXT END) STORED, col4_8 TEXT NOT NULL GENERATED ALWAYS AS (lower(col4_6)) STORED, col4_9 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col4_4 IS NULL THEN e'\x00'::TEXT ELSE e'\\Y|\x1d``'::TEXT END) STORED);
        postgres_1    |     CREATE UNIQUE INDEX ON table4 (col4_3 DESC) INCLUDE (col4_1, col4_6);
        postgres_1    |     CREATE UNIQUE INDEX ON table4 (col4_4 ASC) INCLUDE (col4_1, col4_2, col4_3, col4_7);
        postgres_1    |     CREATE INDEX ON table4 ((CASE WHEN col4_4 IS NULL THEN 'nL'::TEXT ELSE '#j'::TEXT END) DESC, col4_6, col4_7) INCLUDE (col4_1, col4_2, col4_4, col4_5, col4_9);
        postgres_1    |     CREATE UNIQUE INDEX ON table4 (col4_7 DESC, col4_6, col4_9 DESC, col4_3 ASC, col4_2 ASC, col4_1 ASC, col4_0 DESC, col4_5 DESC);
        postgres_1    |     CREATE INDEX ON table4 (col4_0 DESC, col4_5 ASC, col4_4 ASC);
        postgres_1    |     
        test_1        | --- FAIL: TestCompare (4.58s)
        test_1        |     compare_test.go:117: Checking connection to: postgres
        test_1        |     compare_test.go:117: Checking connection to: cockroach1
        test_1        |     compare_test.go:117: Checking connection to: cockroach2
        test_1        |     --- FAIL: TestCompare/postgres (1.09s)
        test_1        |         compare_test.go:126: starting test: postgres
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:135: initializing connection: postgres
        test_1        |         compare_test.go:157: CREATE TABLE table4 (col4_0 INTERVAL NOT NULL, col4_1 INT2 NOT NULL, col4_2 DECIMAL, col4_3 TIMETZ NOT NULL, col4_4 REGROLE NOT NULL, col4_5 TEXT NOT NULL, col4_6 TEXT NOT NULL, col4_7 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col4_0 IS NULL THEN ''::TEXT ELSE e'%8\x0e^'::TEXT END) STORED, col4_8 TEXT NOT NULL GENERATED ALWAYS AS (lower(col4_6)) STORED, col4_9 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col4_4 IS NULL THEN e'\x00'::TEXT ELSE e'\\Y|\x1d``'::TEXT END) STORED);
        test_1        |             CREATE UNIQUE INDEX ON table4 (col4_3 DESC) INCLUDE (col4_1, col4_6);
        test_1        |             CREATE UNIQUE INDEX ON table4 (col4_4 ASC) INCLUDE (col4_1, col4_2, col4_3, col4_7);
        test_1        |             CREATE INDEX ON table4 ((CASE WHEN col4_4 IS NULL THEN 'nL'::TEXT ELSE '#j'::TEXT END) DESC, col4_6, col4_7) INCLUDE (col4_1, col4_2, col4_4, col4_5, col4_9);
        test_1        |             CREATE UNIQUE INDEX ON table4 (col4_7 DESC, col4_6, col4_9 DESC, col4_3 ASC, col4_2 ASC, col4_1 ASC, col4_0 DESC, col4_5 DESC);
        test_1        |             CREATE INDEX ON table4 (col4_0 DESC, col4_5 ASC, col4_4 ASC);
        test_1        |             
        test_1        |         compare_test.go:158: postgres: exec: ERROR: invalid byte sequence for encoding "UTF8": 0x00 (SQLSTATE 22021)
        test_1        |     --- FAIL: TestCompare/mutators (0.35s)
        test_1        |         compare_test.go:126: starting test: mutators
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:157: CREATE TABLE table1 (col1_0 JSONB NOT NULL, col1_1 BIT(18) NULL, col1_2 REGCLASS, col1_3 STRING, col1_4 OID, col1_5 INTERVAL NOT NULL, col1_6 STRING COLLATE de_DE NOT NULL, col1_7 REGTYPE, col1_8 INTERVAL NULL, col1_9 BYTES NOT NULL, col1_10 CHAR NOT NULL, col1_11 BOX2D NULL, col1_12 INTERVAL NULL, col1_13 INET NULL, col1_14 STRING AS (lower(col1_3)) STORED, INVERTED INDEX (col1_14, col1_4, col1_0) NOT VISIBLE, UNIQUE (col1_12 ASC) STORING (col1_0, col1_2, col1_3, col1_7, col1_8, col1_9, col1_13), INDEX (col1_2, col1_13, col1_1 ASC, col1_6 ASC, col1_10, lower(CAST(col1_11 AS STRING)), col1_11 ASC) PARTITION BY LIST (col1_2) (PARTITION table1_part_0 VALUES IN ((1943293673:::OID,), (1440819827:::OID,), (1314152851:::OID,)), PARTITION table1_part_1 VALUES IN ((1104867421:::OID,), (0:::OID,), (3590468418:::OID,)), PARTITION table1_part_2 VALUES IN ((984732120:::OID,), (3255529650:::OID,), (852824761:::OID,)), PARTITION table1_part_3 VALUES IN ((1060477767:::OID,), (1294911981:::OID,)), PARTITION table1_part_4 VALUES IN ((3484731166:::OID,), (504456886:::OID,)), PARTITION table1_part_5 VALUES IN ((2876533297:::OID,), (2442237009:::OID,), (3300680969:::OID,)), PARTITION "DEFAULT" VALUES IN ((DEFAULT,))) NOT VISIBLE, INDEX (col1_2 ASC, col1_11, col1_7 DESC, col1_1 ASC, col1_12 ASC, col1_14 ASC, col1_10 ASC), FAMILY (col1_1), FAMILY (col1_5), FAMILY (col1_13, col1_14, col1_10, col1_12, col1_0), FAMILY (col1_8, col1_4, col1_6, col1_3, col1_9, col1_11, col1_7), FAMILY (col1_2))
        test_1        |         compare_test.go:158: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=4dce214f-a5e3-4fef-9677-3a68d74df8b0 for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (21.16s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ fe952a17ef54e8ca628e9287e07b660fc87a5830:

        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (3:::INT8::INT8, NULL::DATE),
        test_1        |                                 (0:::INT8::INT8, '2000-01-08':::DATE::DATE),
        test_1        |                                 (num_nonnulls(NULL::GEOGRAPHY)::INT8, '2000-01-06':::DATE::DATE),
        test_1        |                                 (NULL::INT8, NULL::DATE)
        test_1        |                         )
        test_1        |                             AS tab_72035 (col_113791, col_113792)
        test_1        |                     ORDER BY
        test_1        |                         tab_72035.col_113791 NULLS LAST
        test_1        |                 )
        test_1        |                     AS tab_72036
        test_1        |             ORDER BY
        test_1        |                 col_113793 ASC, col_113794 ASC NULLS LAST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_72035.col_113791 AS col_113793, tab_72035.col_113792 AS col_113794
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (3::INT8::INT8, NULL::DATE),
        test_1        |                                 (0::INT8::INT8, '2000-01-08'::DATE::DATE),
        test_1        |                                 (num_nonnulls(NULL::GEOGRAPHY)::INT8, '2000-01-06'::DATE::DATE),
        test_1        |                                 (NULL::INT8, NULL::DATE)
        test_1        |                         )
        test_1        |                             AS tab_72035 (col_113791, col_113792)
        test_1        |                     ORDER BY
        test_1        |                         tab_72035.col_113791 NULLS LAST
        test_1        |                 )
        test_1        |                     AS tab_72036
        test_1        |             ORDER BY
        test_1        |                 col_113793 ASC, col_113794 ASC NULLS LAST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach2_1 ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach1_1 ... done
        Stopping compare_cockroach2_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (778.99s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ fe952a17ef54e8ca628e9287e07b660fc87a5830:

        test_1        |                                 ('\x48':::BYTES::BYTES),
        test_1        |                                 ('\x44':::BYTES::BYTES),
        test_1        |                                 ((NULL::BYTES::BYTES || '\x46':::BYTES::BYTES::BYTES)::BYTES),
        test_1        |                                 ('\x4a':::BYTES::BYTES)
        test_1        |                         )
        test_1        |                             AS tab_25932 (col_46418)
        test_1        |                 )
        test_1        |                     AS tab_25933
        test_1        |             ORDER BY
        test_1        |                 col_46419;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_25932.col_46418 AS col_46419
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 ('\x47'::BYTEA::BYTEA),
        test_1        |                                 ('\x48'::BYTEA::BYTEA),
        test_1        |                                 ('\x44'::BYTEA::BYTEA),
        test_1        |                                 ((NULL::BYTEA::BYTEA || '\x46'::BYTEA::BYTEA::BYTEA)::BYTEA),
        test_1        |                                 ('\x4a'::BYTEA::BYTEA)
        test_1        |                         )
        test_1        |                             AS tab_25932 (col_46418)
        test_1        |                 )
        test_1        |                     AS tab_25933
        test_1        |             ORDER BY
        test_1        |                 col_46419;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.40s)
        test_1        |         compare_test.go:126: starting test: mutators
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:157: CREATE TABLE table1 (col1_0 TIME NOT NULL, col1_1 CHAR NULL, col1_2 INT2 NOT NULL, col1_3 OID NULL, col1_4 REGTYPE NULL, PRIMARY KEY (col1_0), INVERTED INDEX (col1_0 DESC, col1_2 ASC, col1_4 ASC, col1_3, col1_1 gin_trgm_ops) NOT VISIBLE, UNIQUE (col1_0, col1_4, col1_2, col1_1 DESC, col1_3 DESC), INDEX (col1_1 ASC, col1_2, col1_0 DESC, col1_3 ASC, col1_4 ASC) WHERE table1.col1_1 >= e'\'':::STRING, UNIQUE (col1_1, col1_0 ASC) STORING (col1_4) PARTITION BY LIST (col1_1, col1_0) (PARTITION table1_part_0 VALUES IN ((e'\r':::STRING, '01:09:23.899922':::TIME), (e'\'':::STRING, '21:55:54.200829':::TIME)), PARTITION table1_part_1 VALUES IN (('/':::STRING, '24:00:00':::TIME), ('=':::STRING, '11:47:08.072156':::TIME)), PARTITION table1_part_2 VALUES IN ((e'\x03':::STRING, '00:21:55.914828':::TIME), ('H':::STRING, '17:12:52.373437':::TIME)), PARTITION "DEFAULT" VALUES IN ((DEFAULT, DEFAULT))) WHERE ((table1.col1_2 < (-32768):::INT8) AND (table1.col1_1 < e'\x00':::STRING)) AND (table1.col1_0 != '24:00:00':::TIME), INDEX ((CASE WHEN col1_4 IS NULL THEN e'iUiE\x173&-':::STRING ELSE e'\'':::STRING END) ASC, col1_0 ASC, col1_4 ASC, col1_1, lower(col1_1)), INDEX (col1_0 DESC) STORING (col1_2, col1_3) WHERE (table1.col1_1 <= e'\x00':::STRING) OR (table1.col1_0 = '24:00:00':::TIME), FAMILY (col1_1, col1_3, col1_4), FAMILY (col1_2, col1_0))
        test_1        |         compare_test.go:158: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=0baa1f97-9d54-48e1-8070-4993b9417302 for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (66.19s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ fe952a17ef54e8ca628e9287e07b660fc87a5830:

        test_1        |                                 (NULL::INT4, CASE WHEN NULL::BOOL THEN 9:::DECIMAL::DECIMAL ELSE 2:::DECIMAL::DECIMAL END),
        test_1        |                                 (5:::INT8::INT4, 5:::DECIMAL::DECIMAL),
        test_1        |                                 (8:::INT8::INT4, 4:::DECIMAL::DECIMAL)
        test_1        |                         )
        test_1        |                             AS tab_10606 (col_19427, col_19428)
        test_1        |                     ORDER BY
        test_1        |                         tab_10606.col_19427 NULLS FIRST, tab_10606.col_19428 DESC NULLS LAST
        test_1        |                 )
        test_1        |                     AS tab_10607
        test_1        |             ORDER BY
        test_1        |                 col_19429, col_19430 DESC NULLS FIRST;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_10606.col_19428 AS col_19429, 0::INT8::INT4 AS col_19430
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (
        test_1        |                                     6::INT8::INT4,
        test_1        |                                     ((cbrt(pow(CASE WHEN (true::BOOL OR false::BOOL) THEN 9::DECIMAL::DECIMAL ELSE 8::DECIMAL::DECIMAL END::DECIMAL, 8::DECIMAL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL)::DECIMAL::DECIMAL * NULL::DECIMAL::DECIMAL)::DECIMAL::DECIMAL + 9::DECIMAL::DECIMAL::DECIMAL)::DECIMAL
        test_1        |                                 ),
        test_1        |                                 (NULL::INT4, CASE WHEN NULL::BOOL THEN 9::DECIMAL::DECIMAL ELSE 2::DECIMAL::DECIMAL END),
        test_1        |                                 (5::INT8::INT4, 5::DECIMAL::DECIMAL),
        test_1        |                                 (8::INT8::INT4, 4::DECIMAL::DECIMAL)
        test_1        |                         )
        test_1        |                             AS tab_10606 (col_19427, col_19428)
        test_1        |                     ORDER BY
        test_1        |                         tab_10606.col_19427 NULLS FIRST, tab_10606.col_19428 DESC NULLS LAST
        test_1        |                 )
        test_1        |                     AS tab_10607
        test_1        |             ORDER BY
        test_1        |                 col_19429, col_19430 DESC NULLS FIRST;
        test_1        |             
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_cockroach1_1 ... 
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (42.16s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

This test on roachdash | Improve this report!

cockroach-teamcity commented 9 months ago

compose.TestComposeCompare failed with artifacts on release-22.2.17-rc @ fe952a17ef54e8ca628e9287e07b660fc87a5830:

        test_1        |                             AS tab_16533 (col_22180)
        test_1        |                     ORDER BY
        test_1        |                         tab_16533.col_22180 ASC NULLS FIRST
        test_1        |                 )
        test_1        |                     AS tab_16534
        test_1        |             ORDER BY
        test_1        |                 col_22181;
        test_1        |             
        test_1        |             postgres:
        test_1        |             SELECT
        test_1        |                 *
        test_1        |             FROM
        test_1        |                 (
        test_1        |                     SELECT
        test_1        |                         tab_16533.col_22180 AS col_22181
        test_1        |                     FROM
        test_1        |                         (
        test_1        |                             VALUES
        test_1        |                                 (7::INT8::INT8),
        test_1        |                                 (4::INT8::INT8),
        test_1        |                                 ((NULL::INT8::INT8 ^ 9::INT8::INT8::INT8)::INT8),
        test_1        |                                 (8::INT8::INT8),
        test_1        |                                 (6::INT8::INT8),
        test_1        |                                 (1::INT8::INT8)
        test_1        |                         )
        test_1        |                             AS tab_16533 (col_22180)
        test_1        |                     ORDER BY
        test_1        |                         tab_16533.col_22180 ASC NULLS FIRST
        test_1        |                 )
        test_1        |                     AS tab_16534
        test_1        |             ORDER BY
        test_1        |                 col_22181;
        test_1        |             
        test_1        |     --- FAIL: TestCompare/mutators (0.18s)
        test_1        |         compare_test.go:126: starting test: mutators
        test_1        |         compare_test.go:135: initializing connection: cockroach1
        test_1        |         compare_test.go:157: CREATE TABLE table2 (col2_0 NAME, col2_1 INT8 NOT NULL, col2_2 JSONB NOT NULL, col2_3 STRING COLLATE da_DK NOT NULL, col2_4 VARCHAR NOT NULL, col2_5 FLOAT8 NOT NULL, col2_6 TIMESTAMPTZ NOT NULL, col2_7 INT8 NOT NULL, col2_8 INT8 NOT NULL AS (col2_7 + col2_1) VIRTUAL, PRIMARY KEY (col2_5), INDEX (col2_1 DESC, col2_7, (col2_5 + (-0.10136350358865087):::FLOAT8) ASC, col2_6 ASC) PARTITION BY LIST (col2_1, col2_7) (PARTITION table2_part_0 VALUES IN (((-3241441830142896616):::INT8, 7279628857328888746:::INT8)), PARTITION table2_part_1 VALUES IN (((-5433529569632073596):::INT8, (-2363991873418424295):::INT8)), PARTITION "DEFAULT" VALUES IN ((DEFAULT, DEFAULT))), INDEX (col2_0 DESC, col2_7 ASC, col2_6 DESC) PARTITION BY LIST (col2_0, col2_7) (PARTITION table2_part_0 VALUES IN ((e'\x1d\x0eD\x04f!:8\x05':::STRING:::NAME, 4792334511632461591:::INT8)), PARTITION table2_part_1 VALUES IN ((e'\x19N*j\x1a':::STRING:::NAME, 937105216329855476:::INT8)), PARTITION table2_part_2 VALUES IN (('':::STRING:::NAME, (-1980963586438690088):::INT8)), PARTITION table2_part_3 VALUES IN ((e',~\x1e\x17\x0b]\x18\rf':::STRING:::NAME, 5556328679104368070:::INT8)), PARTITION table2_part_4 VALUES IN ((e'K\'9':::STRING:::NAME, 4781634486550774947:::INT8)), PARTITION table2_part_5 VALUES IN ((e'\x03 2\x0b\x13:l':::STRING:::NAME, (-8963686342231358197):::INT8)), PARTITION table2_part_6 VALUES IN ((e'Co\x19PC':::STRING:::NAME, (-4566494650919105429):::INT8))) WHERE ((((((table2.col2_7 <= 2147483647:::INT8) AND (table2.col2_1 > 32767:::INT8)) OR (table2.col2_4 < e'\U00002603':::STRING)) OR (table2.col2_6 != '0001-01-01 00:00:00+00:00':::TIMESTAMPTZ)) AND (table2.col2_0 < e'\'':::STRING:::NAME)) AND (table2.col2_5 <= 0.0:::FLOAT8)) AND (table2.col2_8 != (-2147483648):::INT8), UNIQUE (col2_1 DESC, col2_5), INVERTED INDEX (col2_3 ASC, lower(CAST(col2_3 AS STRING)) DESC, col2_5 DESC, col2_6 ASC, col2_1 DESC, col2_2) WHERE (((table2.col2_6 <= '-2000-01-01 00:00:00+00:00':::TIMESTAMPTZ) AND (table2.col2_4 > e'\U00002603':::STRING)) AND (table2.col2_1 <= (-2147483648):::INT8)) OR (table2.col2_8 < (-32768):::INT8), FAMILY (col2_4), FAMILY (col2_3, col2_5, col2_2), FAMILY (col2_1, col2_6, col2_0, col2_7))
        test_1        |         compare_test.go:158: cockroach1: exec: ERROR: use of partitions requires an enterprise license. see https://cockroachlabs.com/pricing?cluster=915752c9-42cd-4886-b1e6-dc721a2f2d1d for details on how to enable enterprise features (SQLSTATE XXC02)
        test_1        | FAIL
        compare_test_1 exited with code 1
        Stopping compare_postgres_1   ... 
        Stopping compare_cockroach1_1 ... 
        Stopping compare_cockroach2_1 ... 
        Stopping compare_postgres_1   ... done
        Stopping compare_cockroach2_1 ... done
        Stopping compare_cockroach1_1 ... done
        Aborting on container exit...

    compose_test.go:122: exit status 1
--- FAIL: TestComposeCompare (47.69s)

Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

- #115745 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2.0-rc] - #112510 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1.12-rc.FROZEN] - #112154 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.2] - #109400 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-23.1] - #109341 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-master] - #89361 compose: TestComposeCompare failed [O-robot T-sql-foundations branch-release-22.2]

This test on roachdash | Improve this report!

celiala commented 9 months ago

temp release-22.2.17-rc branch has been deleted (as of 12/8). closing this issue.