Citus bug for bingo extension
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
When I Create table for structure, I got an Error Message, my SQL code is as follow:
```
CREATE TABLE struct(
id int not null,
binary_molcontent bytea,
primary key (id)
);
create index structIdx on struct using bingo_idx (binary_molcontent bingo.bmolecule);
```
all the above code was OK;but when I executed the following code:
`SELECT create_distributed_table('struct', 'id', 'hash');`
I got the error "table struct has dependency on unsupported object "operator class bingo.bmolecule for access method bingo_idx", bingo.bmolecule and bingo_idx are from bingo extension, which can be used in standalone postgresql well
the detailed definition of bmolecule is
```
CREATE OPERATOR CLASS bmolecule
FOR TYPE bytea USING bingo_idx
AS
OPERATOR 1 public.@ (bytea, sub),
OPERATOR 2 public.@ (bytea, exact),
OPERATOR 3 public.@ (bytea, smarts),
OPERATOR 4 public.@ (bytea, gross),
OPERATOR 5 public.< (bytea, mass),
OPERATOR 6 public.> (bytea, mass),
OPERATOR 7 public.@ (bytea, sim),
FUNCTION 1 matchSub(bytea, sub),
FUNCTION 2 matchExact(bytea, exact),
FUNCTION 3 matchSmarts(bytea, smarts),
FUNCTION 4 matchGross(bytea, gross),
FUNCTION 5 _match_mass_less(bytea, mass),
FUNCTION 6 _match_mass_great(bytea, mass),
FUNCTION 7 matchSim(bytea, sim);
```
OS System CentOS 7 2009
Postgresql Version 15.10
Citus Version: 12.1.4
bingo extension version :1.28.0
Contributor guide
Assessment
This issue has not been assessed yet.