cockroachdb / cockroachdb/cockroach

sql: secondary index corruption for `0::REGCLASS::STRING` when handling Oid column

Open
#151,457 3 comments 0 reactions 0 assignees View on GitHub
branch-release-25.2 C-test-failure O-roachtest O-robot O-rsg P-3 S-3-erroneous-edge-case T-sql-queries
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

roachtest.tlp [failed](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RoachtestNightlyGceBazel/20301941?buildTab=log) with [artifacts](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RoachtestNightlyGceBazel/20301941?buildTab=artifacts#/tlp) on release-25.2 @ [b08173d402e6221096a79d14e647f87084dd114b](https://github.com/cockroachdb/cockroach/commits/b08173d402e6221096a79d14e647f87084dd114b):

```
(tlp.go:177).runOneTLP: expected unpartitioned and partitioned results to be equal
[]string{
- "1",
+ "0",
}
sql: SELECT COUNT(first) FROM (SELECT * FROM defaultdb.public.table_3 AS tab_15322) tab_15322(first)
SELECT SUM(agg) FROM (SELECT COUNT(first) AS agg FROM (SELECT * FROM defaultdb.public.table_3 AS tab_15322 WHERE (true AND (e'M\x05_':::STRING !~ tab_15322."co%00 l3_8"))) tab_15322(first) UNION ALL SELECT COUNT(first) AS agg FROM (SELECT * FROM defaultdb.public.table_3 AS tab_15322 WHERE NOT ((true AND (e'M\x05_':::STRING !~ tab_15322."co%00 l3_8")))) tab_15322(first) UNION ALL SELECT COUNT(first) AS agg FROM (SELECT * FROM defaultdb.public.table_3 AS tab_15322 WHERE ((true AND (e'M\x05_':::STRING !~ tab_15322."co%00 l3_8"))) IS NULL) tab_15322(first))
with args: []
test artifacts and logs in: /artifacts/tlp/run_1
```

Parameters:
- arch=amd64
- cloud=gce
- coverageBuild=false
- cpu=4
- encrypted=false
- metamorphicBufferedSender=true
- metamorphicLeases=epoch
- runtimeAssertionsBuild=false
- ssd=0
Help

See: [roachtest README](https://github.com/cockroachdb/cockroach/blob/master/pkg/cmd/roachtest/README.md)

See: [How To Investigate \(internal\)](https://cockroachlabs.atlassian.net/l/c/SSSBr8c7)

See: [Grafana](https://go.crdb.dev/roachtest-grafana/teamcity-20301941/tlp/1754467339552/1754469735984)

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

Jira issue: CRDB-53286

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.