Skip to content

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

@cockroach-teamcity

Description

@cockroach-teamcity

pkg/ccl/testccl/sqlccl/sqlccl_test.TestExplainGist failed on release-25.2 @ 6dde391c3f240c55975c10a3afc537bcc04405d3:

        			SELECT
        				*
        			FROM
        				(VALUES (0:::OID), (0:::OID), (3872276679:::REGTYPE), (3062243101:::REGTYPE)) AS tab_802 (col_1385)
        		)
        SELECT
        	1046576381:::INT8 AS col_1386, '1986-10-21 13:12:21.000552+00':::TIMESTAMPTZ AS col_1387, tab_803._bytes AS col_1388
        FROM
        	with_141 AS cte_ref_42, defaultdb.public.seed AS tab_803
        WHERE
        	tab_803._bool;
        -- cancelled:	DELETE FROM defaultdb.public.seed AS tab_811 WHERE tab_811._bool;
        -- cancelled:	CREATE STATISTICS stats_3 FROM defaultdb.public.seed WITH OPTIONS THROTTLING 0.2153675427014906 AS OF SYSTEM TIME '-0.001ms';
        INSERT
        INTO
        	defaultdb.public.seed AS tab_813
        		(_int4, _int8, _float8, _date, _timestamptz, _interval, _bool, _bytes, _uuid, _jsonb, _enum)
        VALUES
        	(
        		1351428587:::INT8,
        		(-2282963905591570152):::INT8,
        		2.2488585208274867:::FLOAT8,
        		'1971-12-12':::DATE,
        		'2010-03-31 11:32:59.000204+00':::TIMESTAMPTZ,
        		'-81 years -4 mons -35 days -02:55:15.68577':::INTERVAL,
        		true,
        		NULL,
        		'8c4f3e2a-dee3-4b87-afd8-f995888665fa':::UUID,
        		'{"bBUQZ": [null], "bar": false, "c": {"TLiA": [null, false], "foo": 1.9359286151571249, "n3cvE7A": {"foo": true, "foobar": null}}}':::JSONB,
        		'morning':::greeting
        	);
        -- cancelled:	UPDATE		defaultdb.public.seed AS tab_814	SET		_int8 = tab_818._int8	FROM		defaultdb.public.seed AS tab_815,		defaultdb.public.seed AS tab_816,		defaultdb.public.seed AS tab_817,		defaultdb.public.seed AS tab_818,		defaultdb.public.seed AS tab_819	LIMIT		87:::INT8;
        -- cancelled:	DELETE FROM		defaultdb.public.seed AS tab_820	USING		defaultdb.public.seed AS tab_821, defaultdb.public.seed AS tab_822	LIMIT		3:::INT8;
        ALTER TABLE defaultdb.public.seed ALTER COLUMN _timestamp SET DATA TYPE TIMESTAMPTZ;
        SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED;
        
    explain_test.go:212: pq: internal error: type check failed while initializing stat 1117809230820343809: histogram for table seed column _timestamp created_at 2025-10-23 05:51:45.267253 does not match column type TIMESTAMPTZ: TIMESTAMP:
        SELECT
        	tab_825._enum AS col_1390,
        	tab_824._timestamptz AS col_1391,
        	tab_824.tableoid AS col_1392,
        	(tab_824._jsonb::JSONB#>ARRAY[e'=jYo\x12':::STRING,e'+\x13\x1b|=YU81':::STRING,e'e\b':::STRING,'C{Hw"':::STRING]::STRING[])::JSONB
        		AS col_1393,
        	true AS col_1394,
        	'fbc7568a-2949-4f8c-8705-10f3b172c9d6':::UUID AS col_1395
        FROM
        	defaultdb.public.seed AS tab_824, defaultdb.public.seed AS tab_825
        LIMIT
        	13:::INT8;
--- FAIL: TestExplainGist/main (12.40s)

Parameters:

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

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

This test on roachdash | Improve this report!

Jira issue: CRDB-55706

Metadata

Metadata

Assignees

No one assigned

    Labels

    C-test-failureBroken test (automatically or manually discovered).O-robotOriginated from a bot.T-sql-queriesSQL Queries Teambranch-release-25.2release-blockerIndicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked.

    Type

    No type

    Projects

    Status

    Done

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions