IN :keys queries and array parameters behave differently in 3.2.43 (worked in 3.0.37)

[riverlover]

Queries like the following now throw an error, but worked correctly in version 3.0.37:

when using server-side custom functions implemented in JavaScript. For example:

history_rs = db.query(
    "SELECT id,data FROM model_history WHERE [id, version] IN ?", 
    versions
);

It only ever matches the first condition ['5050_globalData', 40L].

Also, in previous version 3.0.37, the following worked:

var rs3 = db.command(
    "INSERT INTO " + clazz + " SET id = ?, model = ?, children = ?",
    [id++, model, clonedMap]
);

But in 3.2.43, the [] around [id++, model, clonedMap] must be removed for it to work properly.

It seems that handling of array parameters and IN conditions has changed between versions. Could you clarify if this is a known change or provide guidance on how to write equivalent queries in the current version?

[tglman]

Hi,

The query engine was updated so it may be there some underlying changes on how the script are interpreted, can you double check if this works fine in the last release 3.2.44 ?