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.

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

sql: type string literals as unknown initially #94718

Open
Tracked by #75101
mgartner opened this issue Jan 4, 2023 · 0 comments
Open
Tracked by #75101

sql: type string literals as unknown initially #94718

mgartner opened this issue Jan 4, 2023 · 0 comments
Labels
C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-queries SQL Queries Team
Projects

Comments

@mgartner
Copy link
Collaborator

mgartner commented Jan 4, 2023

In Postgres, string literals (e.g., in SELECT 'foo') are typed as unknown initially. It's type is then resolved later on based on type conversion rules of function calls, operators, and other constructs.

More information on string literal typing in Postgres can be found in the docs: https://www.postgresql.org/docs/current/typeconv-overview.html

Epic CRDB-2474

Jira issue: CRDB-23099

@mgartner mgartner added the C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) label Jan 4, 2023
@mgartner mgartner added this to Triage in SQL Queries via automation Jan 4, 2023
@blathers-crl blathers-crl bot added the T-sql-queries SQL Queries Team label Jan 4, 2023
@mgartner mgartner moved this from Triage to Backlog in SQL Queries Jan 4, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-queries SQL Queries Team
Projects
Status: Backlog
SQL Queries
Backlog (DO NOT ADD NEW ISSUES)
Development

No branches or pull requests

1 participant