Re: Assert failure in _bt_preprocess_array_keys

2024-04-21 Thread Richard Guo
On Mon, Apr 22, 2024 at 10:52 AM Peter Geoghegan wrote: > On Sun, Apr 21, 2024 at 10:36 PM Richard Guo > wrote: > > I didn't spend much time digging into it, but I wonder if this Assert is > > sensible. I noticed that before commit 5bf748b86b, the two datatypes > > were not equal to each other

Re: Assert failure in _bt_preprocess_array_keys

2024-04-21 Thread Peter Geoghegan
On Sun, Apr 21, 2024 at 10:36 PM Richard Guo wrote: > I didn't spend much time digging into it, but I wonder if this Assert is > sensible. I noticed that before commit 5bf748b86b, the two datatypes > were not equal to each other either (anyrange vs. int4range). The assertion is wrong. It is test

Assert failure in _bt_preprocess_array_keys

2024-04-21 Thread Richard Guo
I came across an assert failure in _bt_preprocess_array_keys regarding the sanity check on the datatype of the array elements. It can be reproduced with the query below. create table t (c int4range); create unique index on t (c); select * from t where c in ('(1, 100]'::int4range,