cockroachdb / cockroachdb/cockroach

sql: assertion failure: expected non-intersecting equiv groups

Open
#149,552 6 comments 0 reactions 0 assignees View on GitHub
branch-release-25.3 C-test-failure O-robot P-3 T-sql-queries
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

pkg/ccl/testccl/sqlccl/sqlccl_test.TestExplainGist [failed](https://mesolite.cluster.engflow.com/invocations/default/ce7fe21e-c00f-4172-8e01-37064b974c80?testReportRun=1&testReportShard=2&testReportAttempt=1#targets-Ly9wa2cvY2NsL3Rlc3RjY2wvc3FsY2NsOnNxbGNjbF90ZXN0) on release-25.3 @ [8ff393f62bac772c07b6d48897bf918191f9fe6f](https://github.com/cockroachdb/cockroach/commits/8ff393f62bac772c07b6d48897bf918191f9fe6f):

```
AS (
SELECT
*
FROM
(
VALUES
(nextval('defaultdb.public.seq_1':::STRING)::INTERVAL),
('3 years 3 mons 843 days 16:52:01.807392':::INTERVAL),
('47 years 7 mons 154 days 20:43:07.912935':::INTERVAL)
)
AS tab_691 (col_938)
),
with_111 (col_939)
AS (
SELECT
*
FROM
(VALUES (NULL), ('':::VOID), ('':::VOID), ('':::VOID), ('':::VOID), ('':::VOID)) AS tab_692 (col_939)
)
SELECT
tab_693.col_239 AS col_940,
'-48 years -8 mons -653 days -22:10:41.002732':::INTERVAL AS col_941,
1.9683893192367080E+25:::DECIMAL AS col_942,
tab_693.crdb_internal_origin_timestamp AS col_943,
3939573430:::OID AS col_944,
int4(e'\x01a\x10u0j(\x05':::STRING::STRING)::INT4 AS col_945,
'+r':::STRING AS col_946
FROM
defaultdb.public.tab_65@tab_65_col0_0_key AS tab_693
ORDER BY
tab_693.crdb_internal_origin_timestamp
LIMIT
36:::INT8;

explain_test.go:201: pq: internal error: expected non-intersecting equiv groups: INSERT
INTO
defaultdb.public.tab_65 AS tab_694
SELECT
'-24 years -9 mons -367 days -03:14:21.480937':::INTERVAL AS col_947, e'\x15e=n5Ou\x05':::STRING AS col_948
FROM
defaultdb.public.tab_65@tab_65_col0_0_key AS tab_695
JOIN defaultdb.public.tab_65 AS tab_696 ON
(tab_695.col_239) = (tab_696.col_239)
AND (tab_695.col0_0) = (tab_696.col0_0)
AND (tab_695.col_239) = (tab_696.col0_0)
ORDER BY
tab_695.tableoid NULLS LAST
LIMIT
14:::INT8
--- FAIL: TestExplainGist/main (6.02s)
```

Parameters:
- attempt=1
- run=1
- shard=2
Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

Same failure on other branches

- #148405 pkg/ccl/testccl/sqlccl/sqlccl_test: TestExplainGist failed [column not in index error during ALTER PRIMARY KEY] [C-test-failure O-robot P-2 T-sql-foundations branch-master]

[This test on roachdash](https://roachdash.crdb.dev/?filter=status:open%20t:.*TestExplainGist.*&sort=title+created&display=lastcommented+project) | [Improve this report!](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/bazci/githubpost/issues)

Jira issue: CRDB-52192

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.