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: should not allow AOST on crdb_internal #25342

Open
tbg opened this issue May 7, 2018 · 3 comments
Open

sql: should not allow AOST on crdb_internal #25342

tbg opened this issue May 7, 2018 · 3 comments
Labels
A-sql-builtins SQL built-in functions and semantics thereof. C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-queries SQL Queries Team

Comments

@tbg
Copy link
Member

tbg commented May 7, 2018

select * from crdb_internal.gossip_alerts AS OF SYSTEM TIME '2018-01-01';

works, but the AOST clause has no effect (and there's no possible world in which it could have a desired effect).

This doesn't seem particularly urgent to fix since crdb_internal is undocumented anyway.

cc @knz

Jira issue: CRDB-5719

@tbg tbg added the A-sql-builtins SQL built-in functions and semantics thereof. label May 7, 2018
@tbg tbg assigned knz May 7, 2018
@knz knz added this to Triage in (DEPRECATED) SQL Front-end, Lang & Semantics via automation May 7, 2018
@knz knz added the C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) label May 7, 2018
@knz knz moved this from Triage to Backlog in (DEPRECATED) SQL Front-end, Lang & Semantics May 9, 2018
@knz knz removed their assignment May 6, 2019
@jordanlewis
Copy link
Member

Hey @RaduBerinde I'm kicking this over to your team.

@jordanlewis jordanlewis added this to To do in BACKLOG, NO NEW ISSUES: SQL Optimizer via automation May 7, 2019
@RaduBerinde RaduBerinde moved this from To do to Lower Priority Backlog in BACKLOG, NO NEW ISSUES: SQL Optimizer Jul 2, 2019
@RaduBerinde RaduBerinde moved this from Lower Priority Backlog to Functional issues in BACKLOG, NO NEW ISSUES: SQL Optimizer Apr 18, 2020
@github-actions
Copy link

github-actions bot commented Jun 6, 2021

We have marked this issue as stale because it has been inactive for
18 months. If this issue is still relevant, removing the stale label
or adding a comment will keep it active. Otherwise, we'll close it in
5 days to keep the issue queue tidy. Thank you for your contribution
to CockroachDB!

@github-actions
Copy link

We have marked this issue as stale because it has been inactive for
18 months. If this issue is still relevant, removing the stale label
or adding a comment will keep it active. Otherwise, we'll close it in
10 days to keep the issue queue tidy. Thank you for your contribution
to CockroachDB!

@github-actions github-actions bot closed this as not planned Won't fix, can't repro, duplicate, stale Oct 9, 2023
BACKLOG, NO NEW ISSUES: SQL Optimizer automation moved this from Functional issues to Done Oct 9, 2023
@yuzefovich yuzefovich reopened this May 2, 2024
BACKLOG, NO NEW ISSUES: SQL Optimizer automation moved this from Done to Triage May 2, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-sql-builtins SQL built-in functions and semantics thereof. 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
Development

No branches or pull requests

6 participants