16 params or more in cypher = BOOM | 15 is fine

[ExtReMLapin]

Hello,

Tested on version 25.5.1, will test on latest release but I don't see anything related to this in the changelogs.

Code to reproduce the error :

MATCH (n:CHUNK) WHERE ID(n) IN [$id_0, $id_1, $id_2, $id_3, $id_4, $id_5, $id_6, $id_7, $id_8, $id_9, $id_10, $id_11, $id_12, $id_13, $id_14, $id_15] RETURN n

(Yes i know the array can be ONE param)

params :

params = {"id_0":"#1:21",
"id_1":"#1:21",
"id_2":"#1:21",
"id_3":"#1:21",
"id_4":"#1:21",
"id_5":"#1:21",
"id_6":"#1:24",
"id_7":"#1:24",
"id_8":"#1:24",
"id_9":"#1:20",
"id_10":"#1:20",
"id_11":"#1:20",
"id_12":"#1:20",
"id_13":"#1:20",
"id_14":"#1:19",
"id_15":"#1:19"}

Exception: ('com.arcadedb.exception.CommandExecutionException', 'Error on executing command')

Console logs :

juil. 23 16:04:48 cfia-3x5090 server.sh[1720]: 2025-07-23 16:02:50.786 INFO [PostQueryHandler] <ArcadeDB_0> Error on command execution (PostQueryHandler): Error on executing Cypher query

I'm 100% sure it used to be working with MUCH MORE PARAMS something like 128 or 256

[ExtReMLapin]

Tested on latest release, same error

[lvca]

This should be fixed with the new Cypher engine.... Testing.

[lvca]

1. The issue affects only the legacy Cypher engine (Gremlin-based, language ID: cypher) - not the native OpenCypher engine (language ID: opencypher).
2. The native OpenCypher engine handles 16+ parameters correctly. I verified this with tests using 15, 16, and 20 parameters - all pass.
3. Root cause for legacy engine: The Gremlin-based Cypher engine translates Cypher to Gremlin, but the Java Gremlin parser (GremlinLangScriptEngine) has issues parsing the
   generated within() predicate with many parameter references.

Added testManyParametersInIdQuery() to engine/src/test/java/com/arcadedb/query/opencypher/ParameterTest.java to ensure this continues to work with 15, 16, and 20+ parameters.

Recommendation

Users experiencing this issue should switch from:
database.query("cypher", "MATCH (n:CHUNK) WHERE ID(n) IN [$id_0, ...] RETURN n", params)
to:
database.query("opencypher", "MATCH (n:CHUNK) WHERE ID(n) IN [$id_0, ...] RETURN n", params)