dolthub / dolthub/dolt

Multi-part `ALTER TABLE` statements can't reference columns added in the same statement.

Open
#8,293 0 comments 0 reactions 1 assignee Claimed by @zachmu View on GitHub
correctness enhancement sql
Dominant language
Go
Stars
24.4k
Forks
873
Avg merge
1d 5h
Merged PRs (30d)
108

Description

This works in MySQL (and in the GMS in-memory DB):

```
create table t1(pk int primary key);
alter table t1 add column b int, add column c int as (b+1);
```

But trying it in Dolt results in an error:

```
column "b" could not be found in any table in scope
```

Most likely this happens because we attempt to resolve all parts of the statement before any of the new columns are added.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.