Details
Description
1. create bucket ITEM w/ index on I_ID
2. create prepare stmt
[root@centos-64-x64 bin]# curl http://10.6.2.194:8093/query/service -d 'statement=prepare _123 from select * from ITEM where I_ID>$r and I_ID<$s'
|
{
|
"requestID": "624dc175-709a-4e97-8f8c-3b190d2fffb3",
|
"signature": "json",
|
"results": [
|
{
|
"encoded_plan": "H4sIAAAJbogA/5xSwW7UMBD9FWvYw+4qQumGsiU3JKiIBFLF9gZVYjnTxNSxw9ihhSp8O2MvbdVtT715nt/MvPfsW0CrXIttPRppoQTIwMoB+VQfbQqu3IgkgyMob+HVQwE7/DlxLzLlr+q1aQm5/9tj0vsp9I70n8hKpBdNqWyLNzvF+jLQ8cwY4Wi0knV1XlcfGL/C336UKgqvzj9+YcToQQco3202RbHd5MXbk+M32+3xSb7dW7yjt3gpJxO4gxHr0/Yd4hWUdjImg6/Sdhh1f3bXfAkLgosMPumuT5WPVWWVmbx2rD2fZwa4sB0P77yGOXts50ySNAbNvecXhXKKQfXPGn/O3KGGU20CUnwVZ1sdknJYLhckvk95XiixbOK05nVTcb7NaiWkbcXyAL0jL/xq9WRFZXmuNGfkfqCK8RJ6llLz3mGfsg+SiYEmnC+eCrQPvXwdGTCS/qUNduhjZP+9lcl2eTQfjtgFQjlA6vS6szJMlB5yzZdr1gsBb/iH8FgcJaGIP15ckhuER8N7xXpfxQXiukemRN/JNHJUMZJ7QPFPmP8FAAD//6VvlklPAwAA",
|
"name": "_123",
|
"operator": {
|
"#operator": "Sequence",
|
"~children": [
|
{
|
"#operator": "Authorize",
|
"child": {
|
"#operator": "Sequence",
|
"~children": [
|
{
|
"#operator": "IndexScan",
|
"index": "replica_IT_ID",
|
"keyspace": "ITEM",
|
"limit": 9.223372036854776e+18,
|
"namespace": "default",
|
"spans": [
|
{
|
"Range": {
|
"High": [
|
"$s"
|
],
|
"Inclusion": 0,
|
"Low": [
|
"$r"
|
]
|
},
|
"Seek": null
|
}
|
],
|
"using": "gsi"
|
},
|
{
|
"#operator": "Parallel",
|
"~child": {
|
"#operator": "Sequence",
|
"~children": [
|
{
|
"#operator": "Fetch",
|
"keyspace": "ITEM",
|
"namespace": "default"
|
},
|
{
|
"#operator": "Filter",
|
"condition": "(($r \u003c (`ITEM`.`I_ID`)) and ((`ITEM`.`I_ID`) \u003c $s))"
|
},
|
{
|
"#operator": "InitialProject",
|
"result_terms": [
|
{
|
"star": true
|
}
|
]
|
},
|
{
|
"#operator": "FinalProject"
|
}
|
]
|
}
|
}
|
]
|
},
|
"privileges": {
|
"default:ITEM": 1
|
}
|
},
|
{
|
"#operator": "Stream"
|
}
|
]
|
},
|
"signature": {
|
"*": "*"
|
},
|
"text": "prepare _123 from select * from ITEM where I_ID\u003e$r and I_ID\u003c$s"
|
}
|
],
|
"status": "success",
|
"metrics": {
|
"elapsedTime": "5.414448ms",
|
"executionTime": "5.282698ms",
|
"resultCount": 1,
|
"resultSize": 4185
|
}
|
}
|
4. Issue Named prepared stmt - Success
5. Issue Named prepared stmt w/ encoded_plan - Error
[root@centos-64-x64 bin]# curl http://10.6.2.194:8093/query/service -d 'prepared="_123"&encoded_plan=H4sIAAAJbogA/5xSwW7UMBD9FWvYw+4qQumGsiU3JKiIBFLF9gZVYjnTxNSxw9ihhSp8O2MvbdVtT715nt/MvPfsW0CrXIttPRppoQTIwMoB+VQfbQqu3IgkgyMob+HVQwE7/DlxLzLlr+q1aQm5/9tj0vsp9I70n8hKpBdNqWyLNzvF+jLQ8cwY4Wi0knV1XlcfGL/C336UKgqvzj9+YcToQQco3202RbHd5MXbk+M32+3xSb7dW7yjt3gpJxO4gxHr0/Yd4hWUdjImg6/Sdhh1f3bXfAkLgosMPumuT5WPVWWVmbx2rD2fZwa4sB0P77yGOXts50ySNAbNvecXhXKKQfXPGn/O3KGGU20CUnwVZ1sdknJYLhckvk95XiixbOK05nVTcb7NaiWkbcXyAL0jL/xq9WRFZXmuNGfkfqCK8RJ6llLz3mGfsg+SiYEmnC+eCrQPvXwdGTCS/qUNduhjZP+9lcl2eTQfjtgFQjlA6vS6szJMlB5yzZdr1gsBb/iH8FgcJaGIP15ckhuER8N7xXpfxQXiukemRN/JNHJUMZJ7QPFPmP8FAAD//6VvlklPAwAA&$r=9950&$s=9958'
|
{
|
"requestID": "e6d21f21-3276-4893-9339-7cdcfaba4f7e",
|
"errors": [
|
{
|
"code": 4070,
|
"msg": "Unable to decode prepared statement - cause: illegal base64 data at input byte 29"
|
}
|
],
|
"status": "fatal",
|
"metrics": {
|
"elapsedTime": "143.446µs",
|
"executionTime": "137.11µs",
|
"resultCount": 0,
|
"resultSize": 0,
|
"errorCount": 1
|
}
|
}
|