Details
-
Bug
-
Resolution: Fixed
-
Major
-
7.1.0
-
7.1.0-1801
-
Untriaged
-
1
-
Unknown
Description
To repro:
- register function
curl -s -k -X POST http://172.23.104.91:8093/evaluator/v1/libraries/n1ql -u Administrator:password -H 'content-type: application/json' -d 'function execute_prepare_positional() { var params = ["Lyon"]; var query = N1QL("EXECUTE lyon_airport", params); var acc = []; for (const row of query) { acc.push(row); } return acc; }' |
- create function:
CREATE OR REPLACE FUNCTION execute_prepare_positional() LANGUAGE JAVASCRIPT AS "execute_prepare_positional" AT "n1ql"; |
- prepare statement:
prepare lyon_airport as select airportname from `travel-sample`.inventory.airport where city = $1; |
- execute function:
Returns empty result:
cbq> execute function execute_prepare_positional();
|
{
|
"requestID": "dc43de52-aba6-4cf8-8c82-e659e6c229fa", |
"signature": null, |
"results": [ |
[]
|
],
|
"status": "success", |
"metrics": { |
"elapsedTime": "22.07583ms", |
"executionTime": "21.896501ms", |
"resultCount": 1, |
"resultSize": 2, |
"serviceLoad": 18 |
}
|
}
|
|
Attachments
For Gerrit Dashboard: MB-49824 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
167030,2 | MB-49824 : Fix positional parameters array allocation | unstable | eventing-ee | Status: MERGED | +2 | +1 |