Re: BUG #18705: Segmentation fault when create brin index on user-defined type.

On 11/14/24 03:40, PG Bug reporting form wrote:
> ...
>
> CREATE OPERATOR CLASS sva_special_ops FOR TYPE text using brin AS OPERATOR 1
> <#,
> OPERATOR 2 <=#, OPERATOR 3 >=#, OPERATOR 4 >#, function 1
> si_same(text,text);
> CREATE INDEX idx_special1 ON t_sva using brin(sva sva_special_ops);
>

I think this is a bit confused about CREATE OPERATOR CLASS. For BRIN
indexes this expects these 4 functions:

Support Function 1 internal function brin_minmax_opcinfo()
Support Function 2 internal function brin_minmax_add_value()
Support Function 3 internal function brin_minmax_consistent()
Support Function 4 internal function brin_minmax_union()

No wonder it crashes if CREATE OPERATOR CLASS passes si_same() instead
of brin_minmax_opcinfo.

The operators seem a bit off too, because there's no 'equality'
operator, and if I add '=#' as equality operator, then this seems to
work for me:

CREATE OPERATOR CLASS sva_special_ops FOR TYPE text using brin AS
FUNCTION 1 brin_minmax_opcinfo(internal),
FUNCTION 2 brin_minmax_add_value(internal, internal, internal, internal),
FUNCTION 3 brin_minmax_consistent(internal, internal, internal),
FUNCTION 4 brin_minmax_union(internal, internal, internal),
OPERATOR 1 <#,
OPERATOR 2 <=#,
OPERATOR 3 =#,
OPERATOR 4 >=#,
OPERATOR 5 >#;

regards

--
Tomas Vondra