Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

sql: support ordering by TSVector, TSQuery, and VECTOR #92165

Open
jordanlewis opened this issue Nov 18, 2022 · 0 comments
Open

sql: support ordering by TSVector, TSQuery, and VECTOR #92165

jordanlewis opened this issue Nov 18, 2022 · 0 comments
Labels
A-sql-pgcompat Semantic compatibility with PostgreSQL C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-queries SQL Queries Team X-anchored-telemetry The issue number is anchored by telemetry references.

Comments

@jordanlewis
Copy link
Member

jordanlewis commented Nov 18, 2022 •
edited by cockroach-jira-scripts
Loading

We don't support ordering by the TSQuery or TSVector datatypes. This is because we haven't defined an order-preserving encoding for these datatypes.

Follow-up from #41288.
Similar to #35706.

Jira issue: CRDB-21610
@jordanlewis jordanlewis added C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) A-sql-pgcompat Semantic compatibility with PostgreSQL X-anchored-telemetry The issue number is anchored by telemetry references. labels Nov 18, 2022
@blathers-crl blathers-crl bot added the T-sql-queries SQL Queries Team label Nov 18, 2022
@mgartner mgartner moved this to Backlog (DO NOT ADD NEW ISSUES) in SQL Queries Jul 24, 2023
@mgartner mgartner moved this from Backlog (DO NOT ADD NEW ISSUES) to New Backlog in SQL Queries Apr 23, 2024
@mgartner mgartner changed the title sql: support ordering by TSVector and TSQuery sql: support ordering by TSVector, TSQuery, and VECTOR Oct 1, 2024
@mgartner mgartner mentioned this issue Oct 1, 2024
Merged
mgartner added a commit to mgartner/cockroach that referenced this issue Oct 2, 2024
@mgartner
sql: disallow ordering by VECTOR columns
ea61769 
Fixes cockroachdb#131573

Release note (bug fix): Ordering by `VECTOR` columns now results in an
"unimplemented" error. Previously it would result in internal errors in
some cases. See cockroachdb#92165.
craig bot pushed a commit that referenced this issue Oct 5, 2024
@mgartner
Merge #131607 #131703
20466a6 
131607: opt: pretty-print encoded inverted keys in constraints r=mgartner a=mgartner

Encoded inverted keys in constraints are now printed in a more
human-readable format.

Epic: None

Release note: None


131703: sql: disallow ordering by VECTOR columns r=mgartner a=mgartner

Fixes #131573

Release note (bug fix): Ordering by `VECTOR` columns now results in an
"unimplemented" error. Previously it would result in internal errors in
some cases. See #92165.


Co-authored-by: Marcus Gartner <[email protected]>
mgartner added a commit to mgartner/cockroach that referenced this issue Oct 7, 2024
@mgartner
sql: disallow ordering by VECTOR columns
80b74d6 
Fixes cockroachdb#131573

Release note (bug fix): Ordering by `VECTOR` columns now results in an
"unimplemented" error. Previously it would result in internal errors in
some cases. See cockroachdb#92165.
@mgartner mgartner mentioned this issue Oct 7, 2024
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
A-sql-pgcompat Semantic compatibility with PostgreSQL C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-queries SQL Queries Team X-anchored-telemetry The issue number is anchored by telemetry references.
Projects
SQL Queries
Status: Backlog
Milestone
No milestone
Development

No branches or pull requests
1 participant
@jordanlewis