Can't combine lateral join with column and other joins

[nunoo]

Describe the problem

I am unable to combine lateral join with column and other joins, this works with postgres however

To Reproduce

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

[blathers-crl[bot]]

Hi @nunoo, please add branch-* labels to identify which branch(es) this C-bug affects.

_{:owl: Hoot! I am a Blathers, a bot for CockroachDB. My owner is dev-inf.}

[blathers-crl[bot]]

Hello, I am Blathers. I am here to help you get the issue triaged.

Hoot - a bug! Though bugs are the bane of my existence, rest assured the wretched thing will get the best of care here.

I have CC'd a few people who may be able to assist you:

• @cockroachdb/sql-foundations (found keywords: cockroach-go)

If we have not gotten back to your issue within a few business days, you can try the following:

• Join our community slack channel and ask on #cockroachdb.
• Try find someone from here if you know they worked closely on the area and CC them.

_{:owl: Hoot! I am a Blathers, a bot for CockroachDB. My owner is dev-inf.}

[mgartner]

Thanks for the report! I've confirmed this is a problem on v24.2.0.