Re: POC, WIP: OR-clause support for indexes - Mailing list pgsql-hackers

From Alexander Lakhin
Subject Re: POC, WIP: OR-clause support for indexes
Date
Msg-id 8174de69-9e1a-0827-0e81-ef97f56a5939@gmail.com
Whole thread Raw
In response to Re: POC, WIP: OR-clause support for indexes  (Alexander Korotkov <aekorotkov@gmail.com>)
List pgsql-hackers
Hello Alexander,

21.11.2024 09:34, Alexander Korotkov wrote:
> I'm going to push this if no objections.

Please look at the following query, which triggers an error after ae4569161:
SET random_page_cost = 1;
CREATE TABLE tbl(u UUID);
CREATE INDEX idx ON tbl USING HASH (u);
SELECT COUNT(*) FROM tbl WHERE u = '00000000000000000000000000000000' OR
   u = '11111111111111111111111111111111';

ERROR:  XX000: ScalarArrayOpExpr index qual found where not allowed
LOCATION:  ExecIndexBuildScanKeys, nodeIndexscan.c:1625

Best regards,
Alexander



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Changing shared_buffers without restart
Next
From: Matthias van de Meent
Date:
Subject: Re: Changing shared_buffers without restart