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.

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

Type mismatch in LIKE clause results in an error even in permissive mode #1386

Open
jpschorr opened this issue Mar 11, 2024 · 0 comments
Open
Labels
bug Something isn't working

Comments

@jpschorr
Copy link
Contributor

Description

Type mismatch in LIKE clause results in an error even in permissive mode

To Reproduce

Steps to reproduce the behavior:

❯ partiql --typing-mode=PERMISSIVE
Welcome to the PartiQL shell!
Typing mode: PERMISSIVE
Using version: 0.14.3-68b59936
PartiQL> 123 LIKE 'abc'
   |

Evaluator Error: at line 1, column 5: Given: value = 123, pattern =  <UNKNOWN>, escape char = none given
LIKE expression must be given non-null strings as input

Expected Behavior

In permissive mode, I would expect this to result in MISSING

@jpschorr jpschorr added the bug Something isn't working label Mar 11, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant