You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Comma joining two values in a from source without any alias results in variable not found warnings from the planner
To Reproduce
Steps to reproduce the behavior:
PartiQL Shell
Version: 1.1.0-742e1501c
partiql ▶ SELECT * FROM <<{'a': 1}>>, <<{'a': 2}>>;
w: [semantic] Variable reference (_0) could not be found in the database environment or in the set of available locals. Locals: [_0].
w: [semantic] Expression always returns missing
w: [semantic] Variable reference (_0) could not be found in the database environment or in the set of available locals. Locals: [_0].
w: [semantic] Variable reference (_0) could not be found in the database environment or in the set of available locals. Locals: [_0].
w: [semantic] Variable reference (_0) could not be found in the database environment or in the set of available locals. Locals: [_0].
w: [semantic] Expression always returns missing
w: [semantic] Variable reference (_0) could not be found in the database environment or in the set of available locals. Locals: [_0].
w: [semantic] Variable reference (_0) could not be found in the database environment or in the set of available locals. Locals: [_0].
=== RESULT ===
<<
{}
>>
Expected Behavior
When doing a normal explicit CROSS JOIN or providing an alias to one or more values, it works as expected
Description
To Reproduce
Steps to reproduce the behavior:
Expected Behavior
When doing a normal explicit CROSS JOIN or providing an alias to one or more values, it works as expected
Using a CROSS JOIN
Providing an alias to the comma-join values:
Additional Context
The text was updated successfully, but these errors were encountered: