Comments (2)
There's a SemiJoinApply
beneath a Project
. The SemiJoinApply
filters are a contradiction, and there's logic that sets its rowcount to zero in that case, but no logic that sets the cardinality to zero. The Project
inherits both, and then the assertion is triggered.
from cockroach.
roachtest.unoptimized-query-oracle/disable-rules=half/rand-tables failed with artifacts on master @ e5f5597b1c1570fff03ee6dfd4a1e8be65c0e008:
(query_comparison_util.go:396).runOneRoundQueryComparison: . 1280 statements run: expected unoptimized and optimized results to be equal
[]string{
- "table_2",
+ "105",
}
sql: SELECT
(
SELECT
tab_463."co|l2_10" AS col_1445
FROM
defaultdb.public.table_2 AS tab_463
WHERE
('a:e:e:a:e:a:a:e/0':::INET::INET >> 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET::INET)::BOOL
ORDER BY
col_1445 DESC NULLS LAST
LIMIT
1:::INT8
)
AS col_1446
ORDER BY
col_1446
LIMIT
14:::INT8
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/rand-tables/run_1
Parameters:
ROACHTEST_arch=amd64
ROACHTEST_cloud=azure
ROACHTEST_coverageBuild=false
ROACHTEST_cpu=4
ROACHTEST_encrypted=false
ROACHTEST_metamorphicBuild=false
ROACHTEST_ssd=0
Help
See: roachtest README
See: How To Investigate (internal)
Grafana is not yet available for azure clusters
This test on roachdash | Improve this report!
from cockroach.
Related Issues (20)
- sql/stats: TestCreateStatsProgress failed HOT 1
- pkg/ccl/testccl/sqlccl/sqlccl_test: TestReadCommittedStmtRetry failed HOT 1
- pkg/sql/logictest/tests/5node/5node_test: TestLogic_distsql_stats failed HOT 1
- roachtest: unoptimized-query-oracle/disable-rules=half/seed-multi-region failed HOT 1
- ccl/backupccl: TestDataDriven_user_defined_functions failed HOT 1
- util/log: TestHTTPSinkContentTypePlainText failed HOT 1
- pkg/compose/compose_test: TestComposeCompare failed HOT 2
- roachtest: disagg-rebalance/aws/n4cpu4 failed HOT 1
- jwtauthccl: add support for jwks url corresponding to issuer urls in auto fetch jwks
- roachtest: disk-stalled/wal-failover/among-stores failed HOT 2
- pkg/sql/logictest/tests/5node/5node_test: TestLogic_distsql_stats failed HOT 1
- roachtest: unoptimized-query-oracle/disable-rules=half/rand-tables failed HOT 2
- sql: support `FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } { ONLY | WITH TIES }` clause
- roachtest: unoptimized-query-oracle/disable-rules=half/seed-multi-region failed HOT 1
- sql: `statement_timeout` not respected for implicit read-write transactions HOT 1
- Document method to ask a running node for its ID HOT 2
- roachtest: follower-reads/survival=region/locality=regional/reads=bounded-staleness failed HOT 3
- doctor: disregard jobs in debug doctor recreate HOT 2
- acceptance: TestCompose failed [port 26257 failed: Connection refused] HOT 10
- util/log: TestHTTPSinkContentTypeJSON 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.