cockroachdb / cockroachdb/cockroach
sql: secondary index corruption for `0::REGCLASS::STRING` when handling Oid column
- 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
Assessment
This issue has not been assessed yet.