Search results

sql: support pgvector

A-vector-index

C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)

T-sql-queriesSQL Queries TeamSQL Queries Team

Status: Open.

#121432 In cockroachdb/cockroach;

· jordanlewis opened on Mar 31, 2024

status: include disk capacity used/total in runtime logging

C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)

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

T-storageStorage TeamStorage Team

Status: Open.

#101569 In cockroachdb/cockroach;

· jordanlewis opened on Apr 14, 2023

tsearch: support all token types in text search parser

C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)

T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)SQL Foundations Team (formerly SQL Schema + SQL Sessions)

Status: Open.

#97669 In cockroachdb/cockroach;

· jordanlewis opened on Feb 25, 2023

sql: permit automatic retries even if results have been returned by memoizing and comparing returned data

C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)

T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)SQL Foundations Team (formerly SQL Schema + SQL Sessions)

Status: Open.

#93798 In cockroachdb/cockroach;

· jordanlewis opened on Dec 16, 2022

sql: window functions next to SRFs behave differently from Postgres

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-pg-regressOriginated from the pg_regress test suite.Originated from the pg_regress test suite.

T-sql-queriesSQL Queries TeamSQL Queries Team

Status: Open.

#93386 In cockroachdb/cockroach;

· jordanlewis opened on Dec 10, 2022

sql: ANALYZE hangs forever if run within a transaction that modifies the table it is analyzing

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-pg-regressOriginated from the pg_regress test suite.Originated from the pg_regress test suite.

T-sql-queriesSQL Queries TeamSQL Queries Team

Status: Open.

#93372 In cockroachdb/cockroach;

· jordanlewis opened on Dec 10, 2022

sql: unexpected infinite loop in recursive CTE

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-pg-regressOriginated from the pg_regress test suite.Originated from the pg_regress test suite.

T-sql-queriesSQL Queries TeamSQL Queries Team

Status: Open.

#93369 In cockroachdb/cockroach;

· jordanlewis opened on Dec 10, 2022

sql: infinite loop with recursive common table expression

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-pg-regressOriginated from the pg_regress test suite.Originated from the pg_regress test suite.

T-sql-queriesSQL Queries TeamSQL Queries Team

Status: Open.

#93368 In cockroachdb/cockroach;

· jordanlewis opened on Dec 10, 2022

sql: typechecking values clauses with tuples containing nulls is inconsistent with Postgres

A-sql-pgcompatSemantic compatibility with PostgreSQLSemantic compatibility with PostgreSQL

A-sql-typingSQLtype inference, typing rules, type compatibility.SQLtype inference, typing rules, type compatibility.

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.

#93349 In cockroachdb/cockroach;

· jordanlewis opened on Dec 9, 2022

sql: support ordering by TSVector, TSQuery, and VECTOR

A-sql-pgcompatSemantic compatibility with PostgreSQLSemantic compatibility with PostgreSQL

C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)

T-sql-queriesSQL Queries TeamSQL Queries Team

X-anchored-telemetryThe issue number is anchored by telemetry references.The issue number is anchored by telemetry references.

Status: Open.

#92165 In cockroachdb/cockroach;

· jordanlewis opened on Nov 18, 2022

sql: ANALYZE doesn't collect inverted stats on columns that are indexed with both forward and inverted indexes

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).

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.

docs-done

docs-known-limitation

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.

#92036 In cockroachdb/cockroach;

· jordanlewis opened on Nov 17, 2022

sql: old schema changer doesn't handle type back references properly in alter column

A-schema-changer-implRelated to the implementation of the new schema changerRelated to the implementation of the new schema changer

A-schema-descriptorsRelating to SQL table/db descriptor handling.Relating to SQL table/db descriptor handling.

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-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)SQL Foundations Team (formerly SQL Schema + SQL Sessions)

Status: Open.

#91972 In cockroachdb/cockroach;

· jordanlewis opened on Nov 16, 2022