-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql: histogram does not match column type after ALTER TABLE ALTER COLUMN SET DATA TYPE #125620
Copy link
Copy link
Closed
Labels
A-sql-table-statsTable statistics (and their automatic refresh).Table statistics (and their automatic refresh).C-test-failureBroken test (automatically or manually discovered).Broken test (automatically or manually discovered).O-robotOriginated from a bot.Originated from a bot.P-3Issues/test failures with no fix SLAIssues/test failures with no fix SLAS-2-temp-unavailabilityTemp crashes or other availability problems. Can be worked around or resolved by restarting.Temp crashes or other availability problems. Can be worked around or resolved by restarting.T-sql-queriesSQL Queries TeamSQL Queries Teambranch-masterFailures and bugs on the master branch.Failures and bugs on the master branch.branch-release-25.4Used to mark GA and release blockers and technical advisories for 25.4Used to mark GA and release blockers and technical advisories for 25.4branch-release-26.1Used to mark GA and release blockers, technical advisories, and bugs for 26.1Used to mark GA and release blockers, technical advisories, and bugs for 26.1target-release-25.4.7target-release-26.1.2target-release-26.2.0v26.2.0-prerelease
Description
pkg/ccl/testccl/sqlccl/sqlccl_test.TestExplainGist failed on master @ 9d3dd0530818b9c5c0f7dac04e8a8de4acf1bba4:
count(*) AS col_975
FROM
defaultdb.public.seed AS tab_692
GROUP BY
tab_692._jsonb
HAVING
bool_and(true::BOOL)::BOOL
ORDER BY
tab_692._jsonb NULLS LAST, tab_692._jsonb DESC NULLS LAST, tab_692._jsonb ASC NULLS FIRST, tab_692._jsonb NULLS LAST
LIMIT
57:::INT8;
DELETE FROM defaultdb.public.seed AS tab_693 USING defaultdb.public.seed AS tab_694 WHERE true;
DELETE FROM defaultdb.public.seed AS tab_695 USING defaultdb.public.seed AS tab_696 WHERE false;
INSERT
INTO
defaultdb.public.seed AS tab_697
SELECT
NULL AS col_976,
tab_698._int2 AS col_977,
(-2136037883700172646):::INT8 AS col_978,
tab_698._float8 AS col_979,
0.47847028619282:::FLOAT8 AS col_980,
'1971-04-24':::DATE AS col_981,
tab_698._timestamp AS col_982,
NULL AS col_983,
NULL AS col_984,
true AS col_985,
tab_698._decimal AS col_986,
tab_698._string AS col_987,
'\xdd4e':::BYTES AS col_988,
tab_698._uuid AS col_989,
tab_698._inet AS col_990,
tab_698._jsonb AS col_991,
tab_698._enum AS col_992
FROM
defaultdb.public.seed AS tab_698;
SELECT
NULL AS col_993, '-16 years -10 mons -69 days -21:55:19.159286':::INTERVAL AS col_994
FROM
defaultdb.public.seed@seed__int8__float8__date_idx AS tab_699
WHERE
true
ORDER BY
tab_699._int8 ASC
LIMIT
48:::INT8;
ALTER TABLE defaultdb.public.seed ALTER COLUMN _timestamptz SET DATA TYPE TIMESTAMP;
explain_test.go:205: pq: internal error: type check failed while initializing stat 977112995467198465: histogram for table seed column _timestamptz created_at 2024-06-13 06:53:41.725681 does not match column type TIMESTAMP: TIMESTAMPTZ: UPDATE defaultdb.public.seed AS tab_701 SET _int4 = 1016711112:::INT8 WHERE tab_701._bool
--- FAIL: TestExplainGist/main (3.83s)
Parameters:
attempt=1run=23shard=2
This test on roachdash | Improve this report!
Jira issue: CRDB-39531
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
A-sql-table-statsTable statistics (and their automatic refresh).Table statistics (and their automatic refresh).C-test-failureBroken test (automatically or manually discovered).Broken test (automatically or manually discovered).O-robotOriginated from a bot.Originated from a bot.P-3Issues/test failures with no fix SLAIssues/test failures with no fix SLAS-2-temp-unavailabilityTemp crashes or other availability problems. Can be worked around or resolved by restarting.Temp crashes or other availability problems. Can be worked around or resolved by restarting.T-sql-queriesSQL Queries TeamSQL Queries Teambranch-masterFailures and bugs on the master branch.Failures and bugs on the master branch.branch-release-25.4Used to mark GA and release blockers and technical advisories for 25.4Used to mark GA and release blockers and technical advisories for 25.4branch-release-26.1Used to mark GA and release blockers, technical advisories, and bugs for 26.1Used to mark GA and release blockers, technical advisories, and bugs for 26.1target-release-25.4.7target-release-26.1.2target-release-26.2.0v26.2.0-prerelease
Type
Projects
Status
Done