-
Notifications
You must be signed in to change notification settings - Fork 4.1k
pkg/ccl/testccl/sqlccl/sqlccl_test: TestExplainGist failed #155948
Copy link
Copy link
Closed
Labels
C-test-failureBroken test (automatically or manually discovered).Broken test (automatically or manually discovered).O-robotOriginated from a bot.Originated from a bot.T-sql-queriesSQL Queries TeamSQL Queries Teambranch-release-25.2release-blockerIndicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked.Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked.
Description
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=1run=2shard=2
This test on roachdash | Improve this report!
Jira issue: CRDB-55706
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
C-test-failureBroken test (automatically or manually discovered).Broken test (automatically or manually discovered).O-robotOriginated from a bot.Originated from a bot.T-sql-queriesSQL Queries TeamSQL Queries Teambranch-release-25.2release-blockerIndicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked.Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked.
Type
Projects
Status
Done