search

lovasoa / SQLpage

SQL-only webapp builder, empowering data analysts to build websites and applications quickly
https://sql.ophir.dev
MIT License
880 stars 62 forks source link

Bad query results #452

Closed pchemguy closed 1 week ago

pchemguy commented 1 week ago

Evaluating files containing just the following:

Input Processed Result Correct?
SELECT NULL IS NULL; NULL IS NULL 1 :heavy_check_mark:
SELECT lower(NULL) IS NULL; LOWER(NULL) IS NULL 0 :x:
SELECT json(NULL) IS NULL; JSON(NULL) IS NULL 1 :heavy_check_mark:
SELECT CAST(NULL AS TEXT) IS NULL; CAST(NULL AS TEXT) IS NULL 1 :heavy_check_mark:
SELECT $_locale_code IS NULL; CAST(? AS TEXT) IS NULL 1 OK
SELECT lower($_locale_code) IS NULL; LOWER(CAST(? AS TEXT)) IS NULL 0 BAD
lovasoa commented 1 week ago

@pchemguy , there was an issue with our builtin lower() function. It's fixed now.