Details
-
Task
-
Resolution: Fixed
-
Major
-
None
-
DOC-2019-S22-Nov01
-
1
Description
Build 6.5.0-4744
Have created 2 prepareds:
named:
{
|
"prepareds": { |
"avgElapsedTime": "2.184962ms", |
"avgServiceTime": "2.087493ms", |
"encoded_plan": "H4sIAAAAAAAA/6STUWvbMBSF/4o53UNbRFm6QFeNPoTisEHHTFK2hxESYd8kd5Vl70ouyYL324ccl9BmD2UDg+2rI51zP3R3IJdXBRXz2hoHDSgsyYRG6LZyQSrroQeXCuwK2oxq/kriuXLQQwVnSoLuXsXchzJgX/O1yeNCQUvT2FitahITKoHe4eTwgyn9bMjlBIXf+ZptIeSgvz8XjZqwroR/RVUt/MiWVuTjUXfsQye/N7KicLDUB+tM+BH6qp21Tx7/FCITLo1sp7lx76CQGynYGcthC335dnCtkFcxzPvr4cVwcNUDg8ZJvd+JvjSvpfpBeegg7tCvzh9oCx2koVbhgbbHCP8OtvHsVtBYeUarnkceU8jXr8r6asOXFpkRYy1Z/BfbMdtAEpNWruA9GZyeLnrXxcWCSsN2cZbcJG+6z7OjJJ8cBzY228OFgpBvbJgHktJ3jrSpo9CTXULBByM98NkRuEjr6aR21sbnhWQahEyJ7lZ5XrluYmLz59A4R6sQaBMvZDZJs9EkTQ5DkoymyTS9S2/vk/NkPPnyOen7TL59TCdp0jV4s+/zA9o/AQAA//8zQX/SogMAAA==", |
"featuresControl": 12, |
"indexApiVersion": 4, |
"lastUse": "2019-11-11 08:37:37.791920304 -0800 PST m=+17869.524226608", |
"maxElapsedTime": "2.341504ms", |
"maxServiceTime": "2.206478ms", |
"minElapsedTime": "2.028421ms", |
"minServiceTime": "1.968508ms", |
"name": "named_stmt", |
"node": "192.168.10.10:8091", |
"statement": "PREPARE named_stmt AS SELECT * FROM default WHERE email=$email;", |
"uses": 2 |
}
|
}
|
positional:
{
|
"prepareds": { |
"avgElapsedTime": "1.454818ms", |
"avgServiceTime": "1.263023ms", |
"encoded_plan": "H4sIAAAAAAAA/6STUWvbMBSF/4o57UMbRFm6QFdBH0Jx2KBjJinbwwiJsG+cu8qSJ8klWfB++5DjEprsoWzgF+se6Zz7ce8OZHJbULGotTKQgMCKVGgc3VsTnNUecngtwKagzbjmr+Q8WwM5EjCqIkjU1nNga5Re+FAF7Au+VnmsFrRSjY6ntiangnWQO5wdfjCjnw2ZnCDwO1+zLhwZyO+vReMmrK3jX1FVO35mTSX5+NQD+9DJH5UrKRws5cE6c/wMedPO2xePfwqROa6U285yZd5DIFeuYKM0hy3k9bvhrUBuY5gPt6Or0fCmpwaJs3p/E/3Ronb2B+WhI7lDX1080RYyuIZagSfaniL8O9jGsykhUXpGK15HnlDI12/K+mbDY4tMOaU1afwX2wnrQC4mtabgPRlcXCx71+XVkirFenmZ3CXnw8uTFJ8MB1Y624OFgCPf6LAI5CrfudGmjkJPegUBH5TrYc9PoEVSLy+18zZ+R5JZcKQqdBPluTTdysTGB5AYoBUItInDmE3TbDxNk6MtScazZJY+pPePySCZTL98TvpGk28f02madM3enQ/R/gkAAP//tZ050aMDAAA=", |
"featuresControl": 12, |
"indexApiVersion": 4, |
"lastUse": "2019-11-11 08:38:33.067094919 -0800 PST m=+17924.799401244", |
"maxElapsedTime": "1.454818ms", |
"maxServiceTime": "1.263023ms", |
"minElapsedTime": "1.454818ms", |
"minServiceTime": "1.263023ms", |
"name": "positional_stmt", |
"node": "192.168.10.10:8091", |
"statement": "PREPARE positional_stmt AS SELECT * FROM default WHERE email=$1", |
"uses": 1 |
}
|
}
|
According to documentation:
https://docs.couchbase.com/server/6.5/n1ql/n1ql-language-reference/execute.html
I'm trying to call those prepareds using parameters:
named:
execute named_stmt using {"email": "9-mail@couchbase.com"} |
which returns:
[
|
{
|
"code": 5003, |
"msg": "Execution parameter error: cannot have both USING clause and request parameters", |
"query": "execute named_stmt using {\"email\": \"9-mail@couchbase.com\"}" |
}
|
]
|
positional:
execute positional_stmt using ["9-mail@couchbase.com"] |
which returns:
[
|
{
|
"code": 5003, |
"msg": "Execution parameter error: cannot have both USING clause and request parameters", |
"query": "execute positional_stmt using [\"9-mail@couchbase.com\"]" |
}
|
]
|