pkg/ccl/testccl/sqlccl/sqlccl_test: TestExplainGist failed

[github-actions[bot]]

pkg/ccl/testccl/sqlccl/sqlccl_test.TestExplainGist failed on master @ 99b7da557e4ae0cf133946e1d5631fde6f1e6c79:

                )
        SELECT
            cte_ref_43.col_1283 AS col_1284
        FROM
            with_131 AS cte_ref_43
        WHERE
            '196.48.52.21/12':::INET::INET
            NOT IN (
                    ('f824:d18a:14b8:4efb:4bde:a548:1c0:8605/119':::INET::INET + 127:::INT8::INT8)::INET,
                    '144.14.214.72/25':::INET,
                    '105.62.251.216/31':::INET,
                    'a2df:340a:a45a:b0c9:54a6:338e:d0a4:7abf/116':::INET
                )
        ORDER BY
            cte_ref_43.col_1283 NULLS FIRST;
        INSERT
        INTO
            defaultdb.public.seed AS tab_892
                (_int2, _int8, _float8, _interval, _decimal, _string, _bytes, _uuid, col_183, col_935)
        VALUES
            (
                21330:::INT8,
                (-5717921782198822981):::INT8,
                (-0.8910334468534007):::FLOAT8,
                '-20 years -8 mons -597 days -15:13:02.615809':::INTERVAL,
                (-5.090678101449028227E+19):::DECIMAL,
                e'\x1df.a\x19K':::STRING,
                '\xef3313201792':::BYTES,
                'ffffffff-ffff-ffff-ffff-ffffffffffff':::UUID,
                '''AWrEjcxip'' | !''uGrQo''':::TSQUERY,
                '559582EB/BE676767':::PG_LSN
            );
        DELETE FROM defaultdb.public.seed AS tab_893 WHERE false LIMIT 62:::INT8;

    explain_test.go:204: pq: internal error: requested column col_935 not in index: SELECT
            tab_896._float8 AS col_1285, tab_896._inet AS col_1286
        FROM
            defaultdb.public.seed AS tab_896
            JOIN defaultdb.public.seed AS tab_897
                JOIN defaultdb.public.seed AS tab_898 ON (tab_897._int8) = (tab_898._int8) ON
                    (tab_896._int8) = (tab_897._int8)
                    AND (tab_896._date) = (tab_898._date)
                    AND (tab_896._int8) = (tab_898._int8),
            defaultdb.public.seed AS tab_899,
            defaultdb.public.seed@seed__int8__float8__date_idx AS tab_900
        ORDER BY
            tab_896._float4 DESC NULLS LAST, tab_900._bytes DESC NULLS FIRST
        LIMIT
            5:::INT8
    --- FAIL: TestExplainGist/main (14.60s)

Parameters:

• attempt=1
• run=1
• shard=2
  Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

Jira issue: CRDB-42206

[cockroach-teamcity]

pkg/ccl/testccl/sqlccl/sqlccl_test.TestExplainGist failed on master @ 197c6ee5537ffb211ebd8dbcbe49edc6d5c710e1:

        FROM
            defaultdb.public.tab_929 AS tab_1116,
            defaultdb.public.tab_854 AS tab_1117,
            defaultdb.public.tab_854 AS tab_1118,
            defaultdb.public.tab_929 AS tab_1119,
            defaultdb.public.tab_929 AS tab_1120,
            defaultdb.public.tab_929 AS tab_1121
        LIMIT
            58:::INT8;

    explain_test.go:204: pq: internal error: requested column col0_2 not in index: WITH
            with_279 (col_1693)
                AS (
                    SELECT
                        *
                    FROM
                        (VALUES (ARRAY[(-20195):::INT8,(-23106):::INT8]), (NULL), (ARRAY[(-20419):::INT8]))
                            AS tab_1123 (col_1693)
                ),
            with_280 (col_1694)
                AS (
                    SELECT
                        *
                    FROM
                        (
                            VALUES
                                ('2028-06-19 02:12:53.000359':::TIMESTAMP),
                                (
                                    date_trunc(e'\x07':::STRING::STRING, '1975-08-15 04:09:12.000505':::TIMESTAMP::TIMESTAMP)::TIMESTAMP
                                ),
                                ('1990-07-06 12:52:23.00022':::TIMESTAMP)
                        )
                            AS tab_1124 (col_1694)
                )
        SELECT
            NULL AS col_1695,
            tab_1125.crdb_internal_mvcc_timestamp AS col_1696,
            tab_1125.col0_7 AS col_1697,
            tab_1125.col0_9 AS col_1698,
            tab_1125.🙂col0_5 AS col_1699,
            '11:37:43.559792':::TIME AS col_1700,
            tab_1125.col0_4 AS col_1701,
            'X':::STRING AS col_1702
        FROM
            defaultdb.public.tab_854@tab_854_col0_9_expr_key AS tab_1125
        ORDER BY
            tab_1125.col0_4 ASC NULLS FIRST, tab_1125.col0_2 ASC NULLS LAST
        LIMIT
            32:::INT8
    --- FAIL: TestExplainGist/main (4.78s)

Parameters:

• attempt=1
• run=6
• shard=2
  Help

See also: How To Investigate a Go Test Failure (internal)

Same failure on other branches

- #130764 pkg/ccl/testccl/sqlccl/sqlccl_test: TestExplainGist failed [C-test-failure O-robot T-sql-queries branch-release-24.2.3-rc release-blocker]

This test on roachdash | Improve this report!

[cockroach-teamcity]

pkg/ccl/testccl/sqlccl/sqlccl_test.TestExplainGist failed on master @ 83589fb87caa92fb42e83994f1691978f37e4cbb:

        INTO
            defaultdb.public.seed AS tab_78
                (_int2, _int4, _date, _timestamp, _timestamptz, _interval, _decimal, _bytes, _uuid, _inet, _jsonb, col_39)
        VALUES
            (
                (-5384):::INT8,
                (-1653211492):::INT8,
                '1985-12-31':::DATE,
                '1995-10-19 10:00:53.00006':::TIMESTAMP,
                '2028-04-18 06:54:33.000022+00':::TIMESTAMPTZ,
                '43 years 2 mons 651 days 07:03:47.246113':::INTERVAL,
                43012454172746.92256:::DECIMAL,
                '\x58':::BYTES,
                '6b5e2a87-6dd7-4023-abd4-e8a1b49c6d75':::UUID,
                '30.167.243.25/12':::INET,
                '[{"b": null, "bar": [false, null], "foobar": {"mhZfiO": null}}, {"3vAMcqyP": {"b": 0.008940500205603372, "bar": 0.2722966377026306}, "JqfWM": [false], "foo": false}, 0.45491780879634347]':::JSONB,
                'f82c:2002:613:2718:1104:cbe1:a96f:7920/89':::INET
            );
        UPDATE
            defaultdb.public.seed AS tab_79
        SET
            _bool = true
        FROM
            defaultdb.public.seed AS tab_80, defaultdb.public.seed AS tab_81, defaultdb.public.seed AS tab_82
        LIMIT
            7:::INT8;

    explain_test.go:204: pq: internal error: requested column col_39 not in index: INSERT
        INTO
            defaultdb.public.seed AS tab_85 (_int2, _int8, _float4, _date, _timestamp, _decimal, _bytes, _uuid, _enum, col_39)
        SELECT
            (-1):::INT8 AS col_145,
            tab_86._int2 AS col_146,
            tab_86._float4 AS col_147,
            tab_86._date AS col_148,
            '2013-09-30 20:39:06.0004':::TIMESTAMP AS col_149,
            tab_86.crdb_internal_mvcc_timestamp AS col_150,
            tab_86._bytes AS col_151,
            NULL AS col_152,
            tab_86._enum AS col_153,
            '9d5d:71f6:a7:8318:4dcd:5a6f:aee3:490e/28':::INET AS col_154
        FROM
            defaultdb.public.seed@seed__int8__float8__date_idx AS tab_86
        WHERE
            (true OR true)
        ORDER BY
            tab_86.tableoid NULLS FIRST
        LIMIT
            73:::INT8
    --- FAIL: TestExplainGist/main (2.84s)

Parameters:

• attempt=1
• run=4
• shard=2
  Help

See also: How To Investigate a Go Test Failure (internal)

Same failure on other branches

- #130764 pkg/ccl/testccl/sqlccl/sqlccl_test: TestExplainGist failed [C-test-failure O-robot T-sql-queries branch-release-24.2.3-rc release-blocker]

This test on roachdash | Improve this report!

[cockroach-teamcity]

pkg/ccl/testccl/sqlccl/sqlccl_test.TestExplainGist failed on master @ d8f9982677c207b9fda6364c0e47d9618f686141:

                (-8.866529342352052620):::DECIMAL,
                '\x72e463a5be1a':::BYTES,
                '00000000-0000-0000-0000-000000000000':::UUID,
                '177.25.221.43/27':::INET,
                '{"BR0YgXoo": {"foobar": null}, "c3WEvU": true}':::JSONB
            );
        CREATE SEQUENCE defaultdb.public.seq_2;
        UPDATE
            defaultdb.public.seed AS tab_679
        SET
            _int2 = 4739:::INT8
        FROM
            defaultdb.public.seed AS tab_680,
            defaultdb.public.seed AS tab_681,
            defaultdb.public.seed AS tab_682,
            defaultdb.public.seed AS tab_683
        LIMIT
            41:::INT8;
        INSERT
        INTO
            defaultdb.public.seed AS tab_684 (_int2, _int4, _float4, _float8, _interval, _bool, _inet)
        VALUES
            (
                23160:::INT8,
                (-32261755):::INT8,
                1.416521430015564:::FLOAT8,
                (-0.0537326617611103):::FLOAT8,
                '-30 years -10 mons -964 days -11:18:57.910542':::INTERVAL,
                NULL,
                'f791:2962:f71:74c0:35f:1285:be20:5bbe/43':::INET
            );
        UPDATE
            defaultdb.public.seed AS tab_685
        SET
            _bytes = ('\x':::BYTES::BYTES || tab_685._bytes::BYTES)::BYTES, _timestamptz = tab_685._timestamptz
        WHERE
            false
        LIMIT
            10:::INT8;
        DELETE FROM defaultdb.public.seed AS tab_686 USING defaultdb.public.seed AS tab_687;
        DELETE FROM
            defaultdb.public.seed AS tab_688
        ORDER BY
            tab_688._float4 ASC, tab_688._bytes ASC NULLS FIRST, tab_688._date DESC NULLS LAST
        LIMIT
            41:::INT8;
        ALTER TABLE defaultdb.public.seed ALTER COLUMN _timestamp SET DATA TYPE TIMESTAMPTZ;

    explain_test.go:204: pq: internal error: type check failed while initializing stat 1006012131597156353: histogram for table seed column _timestamp created_at 2024-09-23 08:42:18.180193 does not match column type TIMESTAMPTZ: TIMESTAMP: DELETE FROM defaultdb.public.seed AS tab_690 USING defaultdb.public.seed AS tab_691 WHERE tab_691._bool LIMIT 71:::INT8
    --- FAIL: TestExplainGist/main (4.48s)

Parameters:

• attempt=1
• run=5
• shard=2
  Help

See also: How To Investigate a Go Test Failure (internal)

Same failure on other branches

- #130764 pkg/ccl/testccl/sqlccl/sqlccl_test: TestExplainGist failed [C-test-failure O-robot T-sql-queries branch-release-24.2.3-rc release-blocker]

This test on roachdash | Improve this report!