GitHub

sql: CREATE TABLE AS in an explicit transaction does not flush batched rows

Fixes: cockroachdb#81554 Previously, when running a CREATE TABLE AS in explicit transactions, a single batch inserted all rows. This can lead to errors running into the KV command size limits. To ...
GitHub

sql : create table ... as(select nextval('x'))

mgartner commented Jan 21, 2022 Thanks for the report! We do indeed evaluate nextval twice when executing CREATE TABLE mosquito_tb1 AS (SELECT nextval ('mosquito_t1')). This seems incorrect. That ...