Type mismatch in LIKE clause results in an error even in permissive mode #1386
Open
Description
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