Search results

opt: poor cardinality estimate for self-join with aggregation

A-sql-optimizerSQL logical planning and optimizations.SQL logical planning and optimizations.

A-sql-table-statsTable statistics (and their automatic refresh).Table statistics (and their automatic refresh).

branch-release-23.1Used to mark GA and release blockers, technical advisories, and bugs for 23.1Used to mark GA and release blockers, technical advisories, and bugs for 23.1

branch-release-23.2Used to mark GA and release blockers, technical advisories, and bugs for 23.2Used to mark GA and release blockers, technical advisories, and bugs for 23.2

branch-release-24.1Used to mark GA and release blockers, technical advisories, and bugs for 24.1Used to mark GA and release blockers, technical advisories, and bugs for 24.1

branch-release-24.3Used to mark GA and release blockers, technical advisories, and bugs for 24.3Used to mark GA and release blockers, technical advisories, and bugs for 24.3

branch-release-25.1

branch-release-25.2

C-performancePerf of queries or internals. Solution not expected to change functional behavior.Perf of queries or internals. Solution not expected to change functional behavior.

O-supportWould prevent or help troubleshoot a customer escalation - bugs, missing observability/tooling, docsWould prevent or help troubleshoot a customer escalation - bugs, missing observability/tooling, docs

P-3Issues/test failures with no fix SLAIssues/test failures with no fix SLA

T-sql-queriesSQL Queries TeamSQL Queries Team

Status: Open.

#148632 In cockroachdb/cockroach;

· michae2 opened on Jun 21, 2025

opt: add implicit FOR SHARE locking to initial scan of INSERT SELECT

A-sql-mutationsMutation statements: UPDATE/INSERT/UPSERT/DELETE.Mutation statements: UPDATE/INSERT/UPSERT/DELETE.

A-sql-optimizerSQL logical planning and optimizations.SQL logical planning and optimizations.

C-performancePerf of queries or internals. Solution not expected to change functional behavior.Perf of queries or internals. Solution not expected to change functional behavior.

T-sql-queriesSQL Queries TeamSQL Queries Team

Status: Open.

#148208 In cockroachdb/cockroach;

· michae2 opened on Jun 12, 2025

opt/exec: add implicit locking to upsert with distinct

A-sql-optimizerSQL logical planning and optimizations.SQL logical planning and optimizations.

C-performancePerf of queries or internals. Solution not expected to change functional behavior.Perf of queries or internals. Solution not expected to change functional behavior.

E-quick-winLikely to be a quick win for someone experienced.Likely to be a quick win for someone experienced.

O-25.2.1-scale-testing

O-testclusterIssues found or occurred on a test cluster, i.e. a long-running internal clusterIssues found or occurred on a test cluster, i.e. a long-running internal cluster

P-3Issues/test failures with no fix SLAIssues/test failures with no fix SLA

T-sql-queriesSQL Queries TeamSQL Queries Team

Status: Open.

#147806 In cockroachdb/cockroach;

· michae2 opened on Jun 4, 2025

opt: tighten constraints on range scans of hash-sharded indexes to only necessary buckets

A-hash-shardingHash-sharded indexesHash-sharded indexes

A-sql-optimizerSQL logical planning and optimizations.SQL logical planning and optimizations.

C-performancePerf of queries or internals. Solution not expected to change functional behavior.Perf of queries or internals. Solution not expected to change functional behavior.

E-quick-winLikely to be a quick win for someone experienced.Likely to be a quick win for someone experienced.

T-sql-queriesSQL Queries TeamSQL Queries Team

Status: Open.

#147188 In cockroachdb/cockroach;

· michae2 opened on May 23, 2025

sql: fast-path blind UPSERT does not have distinct check

A-sql-optimizerSQL logical planning and optimizations.SQL logical planning and optimizations.

branch-release-20.1Used to mark GA and release blockers, technical advisories, and bugs for 20.1Used to mark GA and release blockers, technical advisories, and bugs for 20.1

C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.

T-sql-queriesSQL Queries TeamSQL Queries Team

Status: Open.

#146759 In cockroachdb/cockroach;

· michae2 opened on May 14, 2025

opt: delete cascade fast path can be sub-optimal

A-multiregionRelated to multi-regionRelated to multi-region

A-sql-optimizerSQL logical planning and optimizations.SQL logical planning and optimizations.

C-performancePerf of queries or internals. Solution not expected to change functional behavior.Perf of queries or internals. Solution not expected to change functional behavior.

T-sql-queriesSQL Queries TeamSQL Queries Team

Status: Open.

#146705 In cockroachdb/cockroach;

· DrewKimball opened on May 14, 2025

opt: incorrect costing of some streaming set ops

A-sql-optimizerSQL logical planning and optimizations.SQL logical planning and optimizations.

branch-release-23.2Used to mark GA and release blockers, technical advisories, and bugs for 23.2Used to mark GA and release blockers, technical advisories, and bugs for 23.2

C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.

T-sql-queriesSQL Queries TeamSQL Queries Team

Status: Open.

#146231 In cockroachdb/cockroach;

· mgartner opened on May 6, 2025

sql: hoisting of many uncorrelated subqueries can use large amount of memory

A-sql-executionRelating to SQL execution.Relating to SQL execution.

A-sql-optimizerSQL logical planning and optimizations.SQL logical planning and optimizations.

branch-release-23.2Used to mark GA and release blockers, technical advisories, and bugs for 23.2Used to mark GA and release blockers, technical advisories, and bugs for 23.2

branch-release-24.1Used to mark GA and release blockers, technical advisories, and bugs for 24.1Used to mark GA and release blockers, technical advisories, and bugs for 24.1

branch-release-24.2Used to mark GA and release blockers, technical advisories, and bugs for 24.2Used to mark GA and release blockers, technical advisories, and bugs for 24.2

branch-release-24.3Used to mark GA and release blockers, technical advisories, and bugs for 24.3Used to mark GA and release blockers, technical advisories, and bugs for 24.3

branch-release-25.1

C-performancePerf of queries or internals. Solution not expected to change functional behavior.Perf of queries or internals. Solution not expected to change functional behavior.

O-supportWould prevent or help troubleshoot a customer escalation - bugs, missing observability/tooling, docsWould prevent or help troubleshoot a customer escalation - bugs, missing observability/tooling, docs

P-3Issues/test failures with no fix SLAIssues/test failures with no fix SLA

T-sql-queriesSQL Queries TeamSQL Queries Team

Status: Open.

#141110 In cockroachdb/cockroach;

· michae2 opened on Feb 11, 2025

opt: internal error: inconsistent Case return types

A-sql-optimizerSQL logical planning and optimizations.SQL logical planning and optimizations.

branch-release-23.1Used to mark GA and release blockers, technical advisories, and bugs for 23.1Used to mark GA and release blockers, technical advisories, and bugs for 23.1

branch-release-23.2Used to mark GA and release blockers, technical advisories, and bugs for 23.2Used to mark GA and release blockers, technical advisories, and bugs for 23.2

branch-release-24.1Used to mark GA and release blockers, technical advisories, and bugs for 24.1Used to mark GA and release blockers, technical advisories, and bugs for 24.1

branch-release-24.2Used to mark GA and release blockers, technical advisories, and bugs for 24.2Used to mark GA and release blockers, technical advisories, and bugs for 24.2

branch-release-24.3Used to mark GA and release blockers, technical advisories, and bugs for 24.3Used to mark GA and release blockers, technical advisories, and bugs for 24.3

C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.

P-3Issues/test failures with no fix SLAIssues/test failures with no fix SLA

T-sql-queriesSQL Queries TeamSQL Queries Team

Status: Open.

#138896 In cockroachdb/cockroach;

· yuzefovich opened on Jan 12, 2025

SQL Optimizer - not choosing the better join order

A-sql-optimizerSQL logical planning and optimizations.SQL logical planning and optimizations.

branch-release-24.2Used to mark GA and release blockers, technical advisories, and bugs for 24.2Used to mark GA and release blockers, technical advisories, and bugs for 24.2

C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.

O-supportWould prevent or help troubleshoot a customer escalation - bugs, missing observability/tooling, docsWould prevent or help troubleshoot a customer escalation - bugs, missing observability/tooling, docs

P-3Issues/test failures with no fix SLAIssues/test failures with no fix SLA

T-sql-queriesSQL Queries TeamSQL Queries Team

Status: Open.

#137701 In cockroachdb/cockroach;

· sheaffej opened on Dec 18, 2024

opt: propagate properties through some projects

A-sql-optimizerSQL logical planning and optimizations.SQL logical planning and optimizations.

C-performancePerf of queries or internals. Solution not expected to change functional behavior.Perf of queries or internals. Solution not expected to change functional behavior.

T-sql-queriesSQL Queries TeamSQL Queries Team

Status: Open.

#137501 In cockroachdb/cockroach;

· yuzefovich opened on Dec 15, 2024

Performance of Query 63 in TPC-DS Benchmark

A-sql-optimizerSQL logical planning and optimizations.SQL logical planning and optimizations.

branch-masterFailures and bugs on the master branch.Failures and bugs on the master branch.

C-performancePerf of queries or internals. Solution not expected to change functional behavior.Perf of queries or internals. Solution not expected to change functional behavior.

O-communityOriginated from the communityOriginated from the community

T-sql-queriesSQL Queries TeamSQL Queries Team

X-blathers-triagedblathers was able to find an ownerblathers was able to find an owner

Status: Open.

#136350 In cockroachdb/cockroach;

· bajinsheng opened on Nov 28, 2024