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

Open
#176,225 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
3/5
Estimated time
1-2 days
Newbie friendliness
25/100
Issue type
Bug
Clarity
Needs clarification
Activity status
Active
Tech stack
go, sql
Domain
databases, testing

Research direction

Start by investigating pkg/ccl/testccl/sqlccl/sqlccl_test and the failed TestExplainGist run linked in the issue. The payload gives no assertion or expected behavior, so identify the test failure and reproduce it on the referenced release commit before determining what a fix should change.

Written by the indexing model from the issue text.

Description

branch-release-24.3 C-test-failure O-robot release-blocker T-sql-queries

pkg/ccl/testccl/sqlccl/sqlccl_test.TestExplainGist failed on release-24.3 @ 351de202ee921f8f2c0336bd5af8ee6f4872972f:

        INSERT
        INTO
        	defaultdb.public.seed AS tab_769
        WITH
        	with_136 (col_1209)
        		AS (
        			SELECT
        				*
        			FROM
        				(
        					VALUES
        						((4015430417:::REGROLE,)),
        						(
        							func_1(ARRAY[688522095:::OID,3220898625:::OID,1464086335:::OID]::OIDVECTOR, 416151536159739054:::INT8::INT8, (-2162973212448696440):::INT8::INT8, e'?\x1a\x1aCWZ':::STRING::VARCHAR, 238824613:::INT8::INT4, 1.2916066755323823:::FLOAT8::FLOAT8, (-3200996343838568209):::INT8::INT8)::RECORD
        						),
        						((3659099548:::REGROLE,)),
        						((383857573:::REGROLE,)),
        						((2518053072:::REGROLE,)),
        						((3506315302:::REGROLE,))
        				)
        					AS tab_770 (col_1209)
        		)
        SELECT
        	tab_772.crdb_internal_origin_id AS col_1210,
        	723751039:::INT8 AS col_1211,
        	(-8402932738810453898):::INT8 AS col_1212,
        	tab_771._float4 AS col_1213,
        	(-0.4133313291329803):::FLOAT8 AS col_1214,
        	'1992-09-28':::DATE AS col_1215,
        	tab_771._timestamp AS col_1216,
        	'2015-09-20 07:45:15.000471+00':::TIMESTAMPTZ AS col_1217,
        	tab_772._interval AS col_1218,
        	(tab_772._bool OR true) AS col_1219,
        	0.06572252484762642801:::DECIMAL AS col_1220,
        	tab_771._string AS col_1221,
        	tab_771._bytes AS col_1222,
        	tab_772._uuid AS col_1223,
        	tab_772._inet AS col_1224,
        	tab_772._jsonb AS col_1225,
        	'hi':::greeting AS col_1226
        FROM
        	with_136 AS cte_ref_42,
        	defaultdb.public.seed AS tab_771
        	JOIN defaultdb.public.seed AS tab_772 ON
        			(tab_771._timestamptz) = (tab_772._timestamptz) AND (tab_771._enum) = (tab_772._enum)
        WHERE
        	true
        LIMIT
        	23:::INT8;
    --- FAIL: TestExplainGist/main (6.35s)

Parameters:

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

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

This test on roachdash | Improve this report!

Jira issue: CRDB-71353

Dominant language
Go
Stars
32.6k
Forks
4.2k
PR merge metrics
No merged PRs in 30d

Getting set up

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from cockroachdb/cockroach

All issues in cockroachdb/cockroach

Similar issues

More Go issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.