bigquery-emulator icon indicating copy to clipboard operation
bigquery-emulator copied to clipboard

Published 20 hours ago • verified publisher icon goccy

LOWER(null) gives error

Open jachymsol opened this issue 1 year ago • 1 comments

This has the consequence that calling LOWER() on a column with type STRING which also contains NULL values throws an error. In BigQuery, LOWER(null) = null.

jachymsol avatar Aug 08 '23 11:08 jachymsol

Hi @totem3, thanks for triaging this issue. We have addressed it with a PR at goccy/go-zetasqlite#112

ohaibbq avatar Jan 26 '24 23:01 ohaibbq

This can be closed now that goccy/go-zetasqlite#112 has been merged.

ohaibbq avatar Apr 14 '24 19:04 ohaibbq

Thank you. I have confirmed that this has been fixed since version 0.6.0, so I will close this issue.

totem3 avatar Apr 15 '24 05:04 totem3