ESQL: CONCAT on null - Githubissues

elastic / elasticsearch

Free and Open Source, Distributed, RESTful Search Engine

https://www.elastic.co/products/elasticsearch

Other

1.38k stars 24.87k forks source link

Open nik9000 opened 3 days ago

nik9000 commented 3 days ago

In ESQL CONCAT("a", NULL, "b") is null. That's true in MySQL but not in Postgres!

Do we want to be more like Postgres here? That comes with some fun side effects, maybe.

elasticsearchmachine commented 3 days ago

Pinging @elastic/es-analytical-engine (Team:Analytics)