order of CTEs defined matters
Open
analyzer
bug
sql
- Dominant language
- Go
- Stars
- 24.4k
- Forks
- 873
- Avg merge
- 1d 5h
- Merged PRs (30d)
- 108
Description
In MySQL, CTEs that reference other CTEs can only see the ones to the left
```
mysql> with c as (select * from b), b as (select * from a), a as (select 1) select * from c;
ERROR: 1146: Table 'test_db.b' doesn't exist
```
dolt has no such restriction
```
dolt > with c as (select * from b), b as (select * from a), a as (select 1) select * from c;
+---+
| 1 |
+---+
| 1 |
+---+
```
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.