Skip to content

sql: histogram does not match column type after ALTER TABLE ALTER COLUMN SET DATA TYPE #125620

@cockroach-teamcity

Description

@cockroach-teamcity

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=1
  • run=23
  • shard=2
Help

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

This test on roachdash | Improve this report!

Jira issue: CRDB-39531

Metadata

Metadata

Assignees

Labels

A-sql-table-statsTable statistics (and their automatic refresh).C-test-failureBroken test (automatically or manually discovered).O-robotOriginated from a bot.P-3Issues/test failures with no fix SLAS-2-temp-unavailabilityTemp crashes or other availability problems. Can be worked around or resolved by restarting.T-sql-queriesSQL Queries Teambranch-masterFailures and bugs on the master branch.branch-release-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.1target-release-25.4.7target-release-26.1.2target-release-26.2.0v26.2.0-prerelease

Type

No type

Projects

Status

Done

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions