partiql/partiql-lang-kotlin

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

jpschorr opened this issue · 0 comments

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