Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

SQL equality cannot accept literal on LHS #3682

Open
f4t4nt opened this issue Jan 14, 2025 · 0 comments
Open

SQL equality cannot accept literal on LHS #3682

f4t4nt opened this issue Jan 14, 2025 · 0 comments
Assignees
@universalmind303
Labels
bug Something isn't working p2 (backlog) Nice to have features sql

Comments

@f4t4nt
Copy link
Contributor

f4t4nt commented Jan 14, 2025

Describe the bug

SELECT * FROM df1 WHERE val <=> 20 is valid but SELECT * FROM df1 WHERE 20 <=> val is not. This behavior extends to equality and other comparisons as well. Other SQL engines handle this just fine.

To Reproduce

No response

Expected behavior

No response

Component(s)

SQL

Additional context

No response
@f4t4nt f4t4nt added bug Something isn't working needs triage labels Jan 14, 2025
@f4t4nt f4t4nt assigned f4t4nt and universalmind303 and unassigned f4t4nt Jan 14, 2025
@f4t4nt f4t4nt added p2 (backlog) Nice to have features and removed needs triage labels Jan 14, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@universalmind303 universalmind303

Labels
bug Something isn't working p2 (backlog) Nice to have features sql
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@f4t4nt @universalmind303