An empty where in query takes 4+ seconds

SQL++
1

Hi,

I just noticed that the following query takes over 4+ seconds.

select * from bucket where something.somethingElse in [];

When the value for the “in” is empty, it is really slow.

Is this a bug?

2

Not a bug unless you are getting incorrect results. We will take a look to see why this is slow. Thanks.