AQL searches with an unquoted number fail

Symptoms: Changing the order of the same AQL search terms causes the search to fail.

Working AQL:

items.find({"repo": "test-repo", "type": "folder", "created":

{"$before": "1d"}

, "depth": 3})

Failing AQL:

items.find({"repo": "test-repo", "type": "folder", "depth": 3, "created": {"$before": "1d"}})

Running the Failing AQL causes Artifactory to return an error message:

2019-12-12 00:26:34,639 [http-nio-8081-exec-5] [ERROR] (o.a.r.r.a.AqlResource:104) - Fail to execute query: items.find({"repo": "test-repo", "type": "folder", "depth": 3, "created": {"$before": "1d"}}).include("name", "created", "repo", "path", "modified_by")

 

The "depth" term uses a number as a variable. I believe Artifactory is attempting to parse each term. Without quotes, the number is not read properly.

If the number is surrounded by quotes it can be used anywhere. If the number is the last search term, it runs normally as the last term is a single character.