substrait-io / substrait

A cross platform way to express data transformation, relational algebra, standardized record expression and plans.
https://substrait.io
Apache License 2.0
1.14k stars 148 forks source link

feat: add ignore nulls options to concat function #605

Closed richtia closed 6 months ago

richtia commented 6 months ago

This PR adds an null_handling option to the concat function.

Some engines have two versions of the concat function. Where one ignores null arguments.

example: Postgres has the || operator which doesn't ignore nulls and concat which does ignore nulls

https://www.postgresqltutorial.com/postgresql-string-functions/postgresql-concat-function/