Hello. Is it possible to have a variable referencing another variable inside the LET clause?
I've tried the following:
LET a=1, b=a+1
but b is not printed, as a is not recognized in b's assignment. Thanks!
In the LET expression, RHS can have constant expressions or references to data from the projected document. In this case, this is treated as:
SELECT a,bFROM defaultLET a=1, b= default.a+1
Since default.a is missing, b goes missing in the projection.
So there is no way to achieve the functionality I mentioned above? I ask this because I have quite an extensive operation going on in the first part of the LET statement that I would like to reuse on the second part, and the only way I am seeing that we can solve this is to duplicate all of the code again...
There is feature request for this https://issues.couchbase.com/browse/MB-19772