jrgemignani commented on issue #1000:
URL: https://github.com/apache/age/issues/1000#issuecomment-1688509994
@vladiksun From what I've found, I believe so. Every time I debug the index -
```
psql-15.3-5432-pgsql=# CREATE INDEX profile_pet_btree_check_in_operator ON
test_graph."profile" USING BTREE (
agtype_in_operator('["dog", "cat"]'::agtype, agtype_access_operator(VARIADIC
ARRAY[_agtype_build_vertex(id, _label_name('16954'::oid, id), properties),
'"pet"'::agtype])));
```
the function that creates the index paths - `create_index_paths` - returns
NULL partly because there isn't a support function defined for it. These
functions are defined in `pg_proc `and assigned under the `prosupport` column.
Assuming a support function would help here, we would need to research how
to create one; the documentation is rather limited and so are the examples.
It is possible there is another path that could create the index. However,
this particular path is the one that matches but returns NULL due to the lack
of a support function.
Of course, this is all after changing the volatility flag to IMMUTABLE for
`agtype_in_operator`.
Right now, I have to turn my attention to the Apache release process for AGE
for the next few weeks. So, I won't be able to give this issue as much time
until after the releases are out.
Hope this is helpful.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
