Re: POC, WIP: OR-clause support for indexes

Sorry for repeating, but I have noticed that this message displays
incorrectly and just in case I'll duplicate it.

On 11.07.2024 19:17, Alena Rybakina wrote:
> The errorwascausedby the specificsof storingthe "OR"clausesinthe
> RestrictInfostructure.Scanning the orclauses list of the RestrictInfo
> variable, wecouldfacenotonlytheitem with RestrictInfo
> type,butalsotheBoolExpr type.
>
> For example, when we have both or clauses and "AND" clauses together,
> like x = 1 and (y =1 or y=2 or y=3 and z = 1). The structure looks like:
>
> RestrictInfo->orclauses = [RestrictInfo [x=1],
> RestrictInfo->orclauses = [RestrictInfo[y=1],
>                     RestrictInfo [y=2],
>                     BoolExpr = [Restrictinfo [y=3], RestrictInfo [z=1]
>                    ]
>                                          ]
>
> It'sworkingfinenow.
>
The error was caused by the specifics of storing the "OR" clauses in the
RestrictInfo structure. When viewing the list of or offers, we could
encounter not only the RestrictInfo type, but also the BoolExpr type.
It's working fine now.

For example, when we have both or clauses and "AND" clauses together,
like x = 1 and (y =1 or y=2 or y=3 and z = 1). The structure looks like:

RestrictInfo->orclauses = [RestrictInfo [x=1],
RestrictInfo->orclauses = [RestrictInfo[y=1],
RestrictInfo [y=2],
BoolExpr = [Restrictinfo [y=3], RestrictInfo [z=1]
]
                                         ]

It's working fine now.

--
Regards,
Alena Rybakina
Postgres Professional:http://www.postgrespro.com
The Russian Postgres Company