search

goccy / bigquery-emulator

BigQuery emulator server implemented in Go
MIT License
846 stars 108 forks source link

LOWER(null) gives error #220

Closed jachymsol closed 7 months ago

jachymsol commented 1 year ago

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.

ohaibbq commented 10 months ago

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

ohaibbq commented 7 months ago

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

totem3 commented 7 months ago

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