Performance issue with in / = on indexed property

[themajashurka]

• EdgeDB Version: 4.5+9324bab
• EdgeDB CLI Version: 4.1.0+c3b6bc7
• OS Version: macos 11.7.10

Steps to Reproduce:

With a populated (1M items) table,

1. it takes 130ms to run

select A
filter .value in {'0.26215992867653615'}

2. it takes 330ms to run

select A
filter .value = array_unpack(['0.26215992867653615'])

3. it takes no time (0.05ms) to run:

select A
filter .value in array_unpack(['0.26215992867653615'])

select A
filter .value = '0.26215992867653615'

Schema:

type A {
    required property value -> str {
        constraint exclusive;
    }
    property detail -> str;
}

[themajashurka]

It behaves the same with params instead of inlining .value:

with
  value := <str>$value
select A
filter .value ...

[jollygreenlaser]

I've also encountered this: #6668 - in is causing it to ignore the index

[themajashurka]

I've also encountered this: #6668 - in is causing it to ignore the index

What really interesting, is that wrapping the inlined data in array_unpack speeds up my example (130ms -> 0.05ms)