xuan2orange commented on issue #2137:
URL: https://github.com/apache/age/issues/2137#issuecomment-2522450609
> that
I have created the btree index and it works.
But when i use 'LIMIT 500' to filter data, it doesn't work.
Here is my query:
`
create index node_name_idx on graph_name."MyNode"
(ag_catalog.agtype_access_operator(properties,'"name"'));
EXPLAIN ANALYZE SELECT *
FROM cypher('graph_name', $$
MATCH (v:MyNode)
WHERE v.name = 'test'
RETURN v
SKIP 0
LIMIT 500
$$) as (V agtype);
----------------------------------------------------------------------------------------------------
Limit (cost=0.00..442.63 rows=500 width=32) (actual time=965.468..970.870
rows=500 loops=1)
-> Seq Scan on "MyNode" "v" (cost=0.00..50239.95 rows=56751 width=32)
(actual time=965.465..970.816 rows=500 loops=1)
Filter: (agtype_access_operator(VARIADIC ARRAY[properties,
'"name"'::agtype]) = '"test"'::agtype)
Rows Removed by Filter: 326964
Planning Time: 0.280 ms
Execution Time: 970.948 ms
`
Thanks!
--
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: dev-unsubscr...@age.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
