Critical Description
CREATE INDEX ix1 ON default(k1,k2);
PREPARE p1 FROM SELECT COUNT(1) FROM default WHERE k1 =10 AND k2 = 5;
Note down encoded plan. replace in the following curl command.
delete from system:prepareds where name = "p1"; OR
restart server OR kill cbq-engine OR send the encoded plan to another query node
curl -v http://localhost:8093/query/service -H "Content-Type: application/json" -d '{"prepared":"p1", "encoded_plan": "H4sIAAAAAAAA/5ySwW7bPBCEX4WY/z/YABGINlIHLHII2kuBogjg3gLDpqm1xFqi1CXpuA3UZy+o2DWStpeeJM5+2lnN8gnkbVdSue4b46EBCW9agkavINH1xCZ2DP2E/y4HLOlrIm8JEj9s7ZqSyUM/vITuUqw7dt8z1bM7uIYqCrnVRxfiiH82XFGERkk7k5qoT09I3LM7QC+G1XD2+KchPviSju+65OPSGj+DhO0OxAH64flNTCabk+vmarMvNtPpGXpVUi9LLUVzqU+vNq7MwErCZU9ouKPKIY7HtSuhsb3ZvVEFbRdzdTObzReQ2NO30BtLlxBOO/hdDb3xYfxDOhoboSMnkmDjKxrl2lU1NK5HU9uk4DoPPZdousdRH+QvSBV/oVSBYTWsJFJwvoJGFdz44Z9jvefuC9k8HlNITVxH4vY8ZZ9Zm7GJmo5th9edlpHJtBj3HFzlTUxMedX/K2j41G6JMUhEOuaL0jP1hkn0Suy4a0WghmwUZ49n8RSZeKyJSewLcSuuxd2n92KvxK1QxVsMPwMAAP//1JcRt/oCAAA=","creds":[
{"user":"Administrator","pass":"xxxx"}]}'
The execution fails.
https://forums.couchbase.com/t/prepared-queries-with-count-failing/11986/23