-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql: Cannot use AOST on the select query of an insert #30534
Copy link
Copy link
Closed as not planned
Labels
A-sql-executionRelating to SQL execution.Relating to SQL execution.A-sql-mutationsMutation statements: UPDATE/INSERT/UPSERT/DELETE.Mutation statements: UPDATE/INSERT/UPSERT/DELETE.A-sql-optimizerSQL logical planning and optimizations.SQL logical planning and optimizations.C-wishlistA wishlist feature.A wishlist feature.T-sql-queriesSQL Queries TeamSQL Queries Teamdocs-donedocs-known-limitation
Milestone
Description
Cockroach 2.1 Sept 17th.
insert into Table(cols) select cols from table2 as of system time '-1m' where -something- fails with:
pq: AS OF SYSTEM TIME must be provided on a top-level statement.
It would be useful to do this so you could do a large table copy as a non-blocking/locking statement.
Thanks.
Epic: CRDB-9838
Jira issue: CRDB-4829
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
A-sql-executionRelating to SQL execution.Relating to SQL execution.A-sql-mutationsMutation statements: UPDATE/INSERT/UPSERT/DELETE.Mutation statements: UPDATE/INSERT/UPSERT/DELETE.A-sql-optimizerSQL logical planning and optimizations.SQL logical planning and optimizations.C-wishlistA wishlist feature.A wishlist feature.T-sql-queriesSQL Queries TeamSQL Queries Teamdocs-donedocs-known-limitation