8000
We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
There was an error while loading. Please reload this page.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
I'm using the latest ArangoDB of the respective release series:
Mode:
Storage-Engine:
On this operating system:
I'm issuing AQL via:
I've run db._explain("<my aql query>") and it didn't shed more light on this. The AQL query in question is:
db._explain("<my aql query>")
FOR i IN 1..3 INSERT {title: CONCAT("Foo" + i), _key: TO_STRING(i)} INTO test RETURN NEW
The issue can be reproduced using this dataset: A blank collection "test"
These are the steps to reproduce:
_system
The following problem occurs: It does not concatenate the title string like "Foo" + number, but instead, it becomes "number" only.
[ { "_key": "1", "_id": "test/1", "_rev": "_W-yM97m---", "title": "1" }, { "_key": "2", "_id": "test/2", "_rev": "_W-yM97m--_", "title": "2" }, { "_key": "3", "_id": "test/3", "_rev": "_W-yM97m--A", "title": "3" } ]
The execution plan looks fine however:
Execution plan: Id NodeType Est. Comment 1 SingletonNode 1 * ROOT 2 CalculationNode 1 - LET #2 = 1 .. 3 /* range */ /* simple expression */ 3 EnumerateListNode 3 - FOR i IN #2 /* list iteration */ 4 CalculationNode 3 - LET #4 = { "title" : CONCAT(("Foo" + i)), "_key" : TO_STRING(i) } /* simple expression */ 5 InsertNode 3 - INSERT #4 IN test 6 ReturnNode 3 - RETURN $NEW Indexes used: none Optimization rules applied: Id RuleName 1 remove-data-modification-out-variables Write query options: Option Value ignoreErrors false waitForSync false nullMeansRemove false mergeObjects true ignoreDocumentNotFound false readCompleteInput false useIsRestore false consultAqlWriteFilter false
The text was updated successfully, but these errors were encountered:
Shouldn't it be CONCAT("Foo", i) instead of CONCAT("Foo" + i)?
CONCAT("Foo", i)
CONCAT("Foo" + i)
Sorry, something went wrong.
Then it will work just fine. The "+" operator will not concatenate strings in AQL. It is an arithmetic operator.
Yeah, sorry for that stupid mistake.
jsteemann
No branches or pull requests
Uh oh!
There was an error while loading. Please reload this page.
my environment running ArangoDB
I'm using the latest ArangoDB of the respective release series:
Mode:
Storage-Engine:
On this operating system:
this is an AQL-related issue:
I'm issuing AQL via:
I've run
db._explain("<my aql query>")
and it didn't shed more light on this.The AQL query in question is:
The issue can be reproduced using this dataset:
A blank collection "test"
These are the steps to reproduce:
_system
The following problem occurs:
It does not concatenate the title string like "Foo" + number, but instead, it becomes "number" only.
The execution plan looks fine however:
The text was updated successfully, but these errors were encountered: