Comments (2)
roachtest.unoptimized-query-oracle/disable-rules=half/rand-tables failed with artifacts on master @ e0068814dfcb4f975a53b79b5546b5fb85c0f927:
(query_comparison_util.go:389).runOneRoundQueryComparison: . 1905 statements run: expected unoptimized and optimized results to be equal
[]string{
... // 26 identical elements
"Q,NULL,0000-01-01 08:20:00 +0000 UTC",
"X,NULL,0000-01-01 08:20:00 +0000 UTC",
+ "[,NULL,0000-01-01 08:20:00 +0000 UTC",
``\,NULL,0000-01-01 08:20:00 +0000 UTC``,
"],NULL,0000-01-01 08:20:00 +0000 UTC",
+ "_,NULL,0000-01-01 08:20:00 +0000 UTC",
+ "a,NULL,0000-01-01 08:20:00 +0000 UTC",
+ "b,NULL,0000-01-01 08:20:00 +0000 UTC",
+ "c,NULL,0000-01-01 08:20:00 +0000 UTC",
+ "d,NULL,0000-01-01 08:20:00 +0000 UTC",
+ "e,NULL,0000-01-01 08:20:00 +0000 UTC",
+ "g,NULL,0000-01-01 08:20:00 +0000 UTC",
+ "p,NULL,0000-01-01 08:20:00 +0000 UTC",
"q,NULL,0000-01-01 08:20:00 +0000 UTC",
+ "u,NULL,0000-01-01 08:20:00 +0000 UTC",
+ "v,NULL,0000-01-01 08:20:00 +0000 UTC",
+ "x,NULL,0000-01-01 08:20:00 +0000 UTC",
+ "\x7f,NULL,0000-01-01 08:20:00 +0000 UTC",
+ "À,NULL,0000-01-01 08:20:00 +0000 UTC",
"à,NULL,0000-01-01 08:20:00 +0000 UTC",
+ "á,NULL,0000-01-01 08:20:00 +0000 UTC",
+ "�,NULL,0000-01-01 08:20:00 +0000 UTC",
}
sql: SELECT
tab_1172.col3_0 AS col_3511, NULL AS col_3512, '08:20:00':::TIME AS col_3513
FROM
defaultdb.public."ta%qb%plE%q_3"@[0] AS tab_1172
ORDER BY
tab_1172.col3_7 DESC NULLS LAST,
tab_1172.col3_4 ASC NULLS FIRST,
col_3511 NULLS LAST,
tab_1172.col3_0 DESC NULLS LAST,
col_3512 NULLS LAST,
tab_1172.col3_3 ASC NULLS FIRST,
tab_1172.tableoid DESC NULLS FIRST,
col_3513 ASC,
tab_1172.col3_9 ASC NULLS LAST,
tab_1172.crdb_internal_mvcc_timestamp DESC NULLS FIRST,
tab_1172."col 3_5" NULLS FIRST,
tab_1172.col3_8 NULLS LAST,
tab_1172.col3_10 NULLS LAST,
tab_1172.col3_6 DESC NULLS FIRST,
tab_1172.col3_2 DESC NULLS LAST,
tab_1172.col̲3_1 DESC NULLS FIRST
LIMIT
32:::INT8
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/rand-tables/run_1
Parameters:
ROACHTEST_arch=amd64
ROACHTEST_cloud=gce
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_fs=ext4
ROACHTEST_localSSD=true
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0
Same failure on other branches
- #122752 roachtest: unoptimized-query-oracle/disable-rules=half/rand-tables failed [C-test-failure O-roachtest O-robot T-sql-queries branch-release-23.1 release-blocker]
- #122751 roachtest: unoptimized-query-oracle/disable-rules=half/rand-tables failed [C-test-failure O-roachtest O-robot O-rsg T-sql-queries branch-release-23.2 release-blocker]
This test on roachdash | Improve this report!
from cockroach.
Dup of #122748
from cockroach.
Related Issues (20)
- roachtest: extend large schema benchmark into multi-region
- sql: explicit zone configuration for the timeseries range on a new cluster
- sql: TestExplainRedact failed HOT 1
- roachtest: test server endpoints in large schema benchmark
- online restore: limit disk bandwidth used by downloads in mb/s to avoid starving wal syncs HOT 2
- roachprod: support zfs vms for azure and aws HOT 1
- Update scheduled changefeeds to pause if resumed on a different cluster HOT 1
- roachprod: support specifying SSD count on azure and aws
- sql: full scans of virtual tables don't error out with `disallow_full_table_scans`
- catalog/lease: transactions are not producing deadline errors when they should HOT 1
- pkg/sql/logictest/tests/cockroach-go-testserver-23.2/cockroach-go-testserver-23_2_test: TestLogic_upgrade_skip_version failed HOT 1
- pkg/sql/logictest/tests/cockroach-go-testserver-23.2/cockroach-go-testserver-23_2_test: TestLogic_mixed_version_sequence_per_node_cache failed HOT 1
- Sentry: fold_constants_funcs.go:677: function current_schema() not defined (1) assertion failure Wraps: (2) attached stack trace -- stack trace: | github.com/cockroachdb/cockroach/pkg/sql/opt/norm... HOT 1
- roachtest: backup-restore/mixed-version failed HOT 1
- roachtest: kv/gracefuldraining failed
- roachtest: jasync failed HOT 4
- sql/importer: TestImportWorkerFailure failed HOT 1
- server: TestDatabasesTablesV2 failed HOT 1
- roachtest: ruby-pg failed HOT 2
- roachtest: indexes/2/nodes=6/multi-region failed HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from cockroach.