cockroachdb / cockroachdb/cockroach

Can't combine lateral join with column and other joins

Open
#132,554 3 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.