memgraph / mage

MAGE - Memgraph Advanced Graph Extensions :crystal_ball:
Apache License 2.0
238 stars 23 forks source link

Calling a procedure inside periodic.iterate returns "query failed" #439

Open karmenrabar opened 5 months ago

karmenrabar commented 5 months ago

Is calling a query module create.node inside a periodic.iterate supported? Or more generally, can an argument of a query module also be a query module?

Running the following query returns: Query failed: periodic.iterate: Error while executing periodic iterate!

CALL periodic.iterate(
  'WITH [1,2,3] as nodes UNWIND nodes as node return node',
  'CALL create.node(["Person"], {name: "A"}) YIELD node RETURN node',
  {batch_size:2000}
) YIELD success
return success

But, running this query works well.

CALL periodic.iterate(
  'WITH [1,2,3] as nodes UNWIND nodes as node return node',
  'CREATE (p:Person {name: "A"})',
  {batch_size:2000}
) YIELD success
return success

Source and context: discord