Skip to content

sql: Cannot use AOST on the select query of an insert #30534

@bladefist

Description

@bladefist

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

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions