Comments (2)
Hm, I'd think that it's the same as #118273 the fix for which is included in the SHA.
from cockroach.
Reduced repro on 0d7d1ec (and on master 270e1e3)
CREATE TABLE t (
col_0 REGROLE, col_1 OID, col_2 INT,
INDEX (col_1 DESC) STORING (col_2),
INDEX (col_0) STORING (col_1)
);
INSERT INTO t (col_0, col_1, col_2) VALUES (0, 0, 0);
SET testing_optimizer_random_seed = 6047211422050928467;
SET testing_optimizer_disable_rule_probability = 0.500000;
SET vectorize = off;
SELECT
t2.col_1
FROM
t AS t1
JOIN t AS t2 ON (t1.col_0) = (t2.col_1)
ORDER BY
t1.col_0;
RESET testing_optimizer_random_seed;
RESET testing_optimizer_disable_rule_probability;
RESET vectorize;
SELECT
t2.col_1
FROM
t AS t1
JOIN t AS t2 ON (t1.col_0) = (t2.col_1)
ORDER BY
t1.col_0;
from cockroach.
Related Issues (20)
- roachtest: splits/largerange/size=32GiB,nodes=6 failed HOT 1
- pg_catalog: fix up contents of `pg_catalog.pg_proc`
- : failed HOT 1
- roachtest: declarative_schema_changer/job-compatibility-mixed-version-V222-V231 failed HOT 6
- roachtest: dns_problem failed
- roachtest: rebalance/by-load/leases/mixed-version failed HOT 4
- roachtest: sqlsmith/setup=rand-tables/setting=default failed HOT 1
- roachtest: schemachange/secondary-index-multi-version failed HOT 3
- ERROR: unsupported binary operator: `<int4> * <float4>` HOT 2
- pkg/ccl/testccl/sqlccl/sqlccl_test: TestReadCommittedStmtRetry failed
- ccl/streamingccl/streamingest: TestTenantStreamingJobRetryReset failed
- telemetry: convert fields currently using type uint64 to strings
- sql: support FOUND variable in PL/pgSQL HOT 1
- pkg/sql/ttl/ttljob/ttljob_test: TestRowLevelTTLJobRandomEntries failed HOT 1
- sql: support print_strict_params option in PL/pgSQL
- sql: calling EXECUTE in PL/pgSQL should return more helpful error HOT 1
- ccl/streamingccl/streamingest: TestProtectedTimestampManagement failed
- cli: redact stacktrace information in debug.zip
- admission: integrate snapshot ingest with CPU limiter
- cockroach-go-testserver-23_1_test: TestLogic_mixed_version_udf_mutations failed [inability to maintain liveness during initial cluster startup] HOT 3
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.