Details
-
Bug
-
Resolution: Resolved
-
Major
-
4.6.4
-
4.6.4-4544
-
Untriaged
-
No
Description
1. create an empty bucket default.
2. create primary index on it.
3. prepare a statement through UI:
prepare p1 as explain SELECT * FROM default WHERE k10 > 10 AND k20 > 20 ORDER BY k20;
4. Encoded plan generated is:
"encoded_plan": "H4sIAAAJbogA/6xSwW4TMRD9lZF7SVCEknArJ6AbgQQk2iAhBKg7sqepu17bjL1Sqqh8O+NmaUW3B4pQchg/v3nvzXgPirwOhsx5dOjVqVIz5bEjqeJC6hCJMQdWpwd1cn9QW/rRSycJ5ae+tM4wSffXgzrK/CX5yaQN2w75eqvFZKasN7QX9CQeYYFauk4Rdclv6AJ7l4eBxmifrN8JsktW3cz+9FlR1pdPkXsosEFG58jdTfNPO1lZl4mFooM3NttQXmgyWczhWz+fv9AwaYYAzfOmXcyb6RTQG5gsH2csC2M6CvvOiza6DYcr0mVCpiQd5+LdpdtQtI+FmMhdyHXKKKfMPd18l5/8Hwiu2dzGToEfURlFUmOFlfX3gcq1yrTPZW/V++rNJ3gGq3r9AQYh+Py2qitofy+GQKpXH8+gXd4hUq3rs6qG118K/HK0hW1mwu5oluzOY+65PPFVCuVjG/wjU0QmiAvABDKRQ+vhP6b6FQAA//9FY4CqkgMAAA==",
5. Use an incorrect encoded plan while querying as:
curl -v http://172.23.107.182:8093/query/service -H "Content-Type: application/json" -d '{"prepared":"p1", "encoded_plan":"H4sIAAAJbogA/7xUQW8TPRD9K9Z8l7RafVpvCIHlVOhGRCqkSpAQgigx9jQxcbyL7YWFKvx2xsmGqkkOpQdOOx6/eX7zZrS3gFaWCtWsMsJCDpCAFWukqOIUlxU6EUoH+S38d3eACX6tqRIJ8ksutVEOqfrjfdBFHZal0z8jagt6FMuDQCOn0KEa2oDOowwTSd0k4Onjj8BDq7BpETrGlNNNlu6PM01Kocuf91L5NJOynwkpohsr/OErIaM7Cm9EbUJr13GWMu3LRSNkgDy4GhMYC7vAaMPQSlN7XVIraQJX5XfCAkmYbjbTBOjGLohv4TVskoeoT/l99c+ybu9zX/Y5Vwq7vSf/QD0/qX56qH+AQS7/Rs4hwbVwwhg0BF+LZn/Sfg053+/IozZtoA2tT1zW0iodtu1Bp8NT9qlO065knXmraf7/fMXT+dkZE1axTnYakUXE2YkBErcw1678QptKzzn0VDGjt9c707GpItCjuYnDCMLtJkBmRoePHNX2ji5eQ+X0N21wgT4a0UrK94bmfHNIMQkOxXpX7PXCilC77aTP6fKcWoCATYh/BYeVcMgqzoRnk+KqePWOnbPBePSGtfzs/etiXLDV3jdkFF28vWSr7E+GotH4shizlx9i+gVsfgcAAP//U7tejYoEAAA=","creds":[
]}'
6. We see the error message below:
< Date: Thu, 05 Oct 2017 22:40:36 GMT
<
{
"requestID": "fda2c0a7-c619-4917-8ac7-5eb40ab593fb",
"errors": [
],
"status": "fatal",
"metrics":
}
Attachments
Issue Links
- relates to
-
MB-27778 deprecate encoded_plans and object prepareds
- Closed