sql: can't add column to table and insert values in the same transaction

[pmneo]

Tested with 2.1.0-beta20181015:

start transaction;
alter table my_table add column test varchar(100);
select test from my_table;
pq: column "test" does not exist

Those statements works pretty fine with pgsql ...

This may be related with #24626

Jira issue: CRDB-4791

[knz]

@pmneo as documented CockroachDB performs DDL statements asynchronously (at the end of the current transaction) so the behavior you observe is expected. This is a known difference from PostgreSQL that was introduced to make CockroachDB able to run schema changes faster.

Can you provide us some context about your use case? What makes you want to use this feature in that way? Is it not possible to issue the statements in separate transactions?

[pmneo]

This is because my liquibase migration scripts add some columns and fill them with some default values.

This scripts works fine with most other databases like mysql, mariadb, mssql, oracle, pgsql, hsql, ....

[knz]

cc @awoods187 for prioritization (LiquiBase compatiblity #13991)

[knz]

cc @awoods187 for prioritization (LiquiBase compatiblity #13991)