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

colexec: support (Date | TimestampTZ) + or - Interval projections #46198

Open
yuzefovich opened this issue Mar 17, 2020 · 0 comments
Open

colexec: support (Date | TimestampTZ) + or - Interval projections #46198

yuzefovich opened this issue Mar 17, 2020 · 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
BACKLOG, NO NEW ISSUES: SQL Execution

Comments

@yuzefovich
Copy link
Member

yuzefovich commented Mar 17, 2020 •
edited

We added support for Interval type recently and we've had (somewhat broken) support for Date type for a while now, but we don't have the arithmetic projections between them. The reason is that we lose information about Date type once we convert it to coltypes.Int64, so if we were to add the corresponding projections, we might allow projection like Int + Interval which don't make sense. I think this can be solved once #43559 is resolved.

This issue also tracks adding the support of TimestampTZ +/- Interval (Timestamp is supported).

Jira issue: CRDB-5101
@yuzefovich yuzefovich added the C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) label Mar 17, 2020
@yuzefovich yuzefovich added this to Triage in BACKLOG, NO NEW ISSUES: SQL Execution via automation Mar 17, 2020
@yuzefovich yuzefovich moved this from Triage to [BACKLOG] Enhancements/Features in BACKLOG, NO NEW ISSUES: SQL Execution Mar 17, 2020
@jlinder jlinder added the T-sql-queries SQL Queries Team label Jun 16, 2021
@yuzefovich yuzefovich changed the title colexec: support Date + or - Interval projections colexec: support (Date | TimestampTZ) + or - Interval projections Aug 12, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-queries SQL Queries Team
Projects
BACKLOG, NO NEW ISSUES: SQL Execution
[VECTORIZED BACKLOG] Enhancements/Fea...
SQL Queries
Status: Backlog
Milestone
No milestone
Development

No branches or pull requests
2 participants
@jlinder @yuzefovich