cockroachdb / cockroachdb/cockroach
Can't combine lateral join with column and other joins
Open
branch-release-24.2
C-bug
O-community
T-sql-queries
X-blathers-triaged
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
**Describe the problem**
I am unable to combine lateral join with column and other joins, this works with postgres however
**To Reproduce**
```sql
create table employees(age int, name text);
insert into employees values(25, 'Name1');
insert into employees values(48, 'Name2');
select * from employees, generate_series(1, age)
cross join employees t2
ERROR: column "age" does not exist
SQLSTATE: 42703
```
**Expected behavior**
the ability to combine lateral join with column and other joins
**Environment:**
- CockroachDB version github.com/cockroachdb/cockroach-go/v2 v2.3.7
Jira issue: CRDB-43140
Contributor guide
Assessment
This issue has not been assessed yet.