cockroachdb / cockroachdb/cockroach

opt: handle different-width expressions in VALUES rows

Open
#129,186 7 comments 0 reactions 0 assignees View on GitHub
branch-master branch-release-23.2 branch-release-24.1 branch-release-24.2 C-test-failure O-roachtest O-robot O-rsg P-3 T-sql-queries
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

roachtest.costfuzz/rand-tables [failed](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RoachtestNightlyGceBazel/16516850?buildTab=log) with [artifacts](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RoachtestNightlyGceBazel/16516850?buildTab=artifacts#/costfuzz/rand-tables) on release-24.1 @ [c977778dc8419323431a990baf3d702db4fd584b](https://github.com/cockroachdb/cockroach/commits/c977778dc8419323431a990baf3d702db4fd584b):

```
(query_comparison_util.go:389).runOneRoundQueryComparison: . 3508 statements run: expected unperturbed and perturbed results to be equal
  []string{
-  "-23138",
+  "-1504043076756527714",
   "NULL",
  }
sql: SELECT
tab_4677.col_13219 AS col_13220
FROM
(
VALUES
(
(
SELECT
tab_4676.col1_0 AS col_13218
FROM
defaultdb.public."table _1"@[0] AS tab_4676
ORDER BY
col_13218 NULLS LAST
LIMIT
1:::INT8
)
),
((-1504043076756527714):::INT8)
)
AS tab_4677 (col_13219)
WHERE
e'\u00E0\u00E1':::STRING ~* '':::STRING
test artifacts and logs in: /artifacts/costfuzz/rand-tables/run_1
```

Parameters:
- ROACHTEST_arch=amd64
- ROACHTEST_cloud=gce
- ROACHTEST_coverageBuild=false
- ROACHTEST_cpu=4
- ROACHTEST_encrypted=false
- ROACHTEST_metamorphicBuild=false
- ROACHTEST_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-16516850/costfuzz-rand-tables/1723960780331/1723962472077)

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

Jira issue: CRDB-41425

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.