Zhou Sun

icon location @Mooncake-Labs Bring data intelligence to every application. Previously led Query Engine @memsql.

Results 1 issues of Zhou Sun

InList is rewritten into = ANY(ARRAY) and leads to bad duckdb plan

3 comment

### What happens? In List in postgres is represented as = ANY(ARRAY). Duckdb will then turn it into a semi join, which disables many optimizations and performs much worse than...

optimizer