Details
-
Bug
-
Resolution: Fixed
-
Critical
-
Cheshire-Cat
-
7.0.0-3154
-
Untriaged
-
1
-
Unknown
Description
2 node cluster - kv,n1ql,index
create a default bucket
create a scope test
create a collection test1
prepare a statement using the absolute collection path:
prepare p1 as select * from default:default.test.test1
This is on both nodes
Prepared statements on buckets also work as usual
prepare a statement using query_context ( I use cbq)
\set -query_context default:default.test;
prepare p2 as select * from test1;
This statement is ONLY on the node it was prepared from instead of both nodes.
select * from system:prepareds;
[
|
{
|
"prepareds": {
|
"encoded_plan": "H4sIAAAAAAAA/6STUYsTMRSF/8pw9q0EsSoIeVsXBFGwsOKLlBLTO9PYTJK9uVlay/jbJTNTVksR1JeZTO5JzpkvuSdQsHFL203yJkADCi0ZKUx3MQhHn6GXLxRc2NLhNrnPxNnFAP1qnru3JrynY07GUoY+YUutKV70/H4mlKfHEro1PtOgEExP0EhLTONxNfR5LRRiIjYSue548/SB2yK7yO47QSGxe3Seusn3g8sC/eWET4Y7kqfdriVRWLF7hH5dBzFl6OfDelD4YXfOby9N7+mhULDVcxIwhdHqr0Urdr3hY4X2Egpfi93/GhUzVGjcpEl6ntokjt/Iygj/hLm62dMRWrhUqvv5GKBx/svrcLON6ayCQskudNDossOgfg/8lsTurif9N7tLg5Vh4z15/Bf8d8GJM341MYICUy5eNkLc51FNh1SFmXxbI4nhmdt6WA/17C9chcn0qDWFh0J8rP1AB5l6JLsujF1S0y6gscCgMNcTUzJMTVo2JjeZPFlpFk3LsW/+eCdLprs3H+dcPwMAAP//3ZqbKJsDAAA=",
|
"featuresControl": 12,
|
"indexApiVersion": 4,
|
"indexScanKeyspaces": {
|
"default:default.test.test1": false
|
},
|
"name": "p1",
|
"namespace": "default",
|
"node": "172.23.104.110:8091",
|
"statement": "prepare p1 as select * from default:default.test.test1",
|
"uses": 0
|
}
|
},
|
{
|
"prepareds": {
|
"encoded_plan": "H4sIAAAAAAAA/6ST0avTMBTG/5Xy3bcRxDsFIT5dLwii4OCKLzJGTE+7uDTJPTm9bI76t0vajumYD+pLmyZfzvfld5ojKNhYU71J3gRoQKEhIz3TfQzC0Wfo26WCCzXt75L7TJxdDNAv57kHa8J7OuRkLGXoI2pqTO9Fz+9nQnl63EI3xmcaFILpCBppiWk87oY+7YVCTMRGIpeKN+cP3PWyjey+ExQSuyfnqZ18P7gs0F+O+GS4JTlXu5ZEYcXuCfpVGcSUoZ8P60Hhh906X1+aPtBjT8EWz0nAFEarvxat2HWGDwXaCyh87e3u16iYoULjJk3S09QmcfxGVkb4R8yrmx0doIX7QnU3twEap1Neh5ttTCcVFPrsQguNNjsM6vfAb0ns9nrSf7O7NFgZNt6Tx3/BfxecOONXEyMoMOXey0aIuzyqaZ+KMJNvSiQxPHNbD+uh9P7CVZhMh7Km8NgTH8p9oP2f/qtS07VhvDnlBAtoLDAozHsSUzJMVVpWJleZPFmpFlXDsatGeq/HRtD9m49zrp8BAAD///MK4/KbAwAA",
|
"featuresControl": 12,
|
"indexApiVersion": 4,
|
"indexScanKeyspaces": {
|
"default:default.test.test1": false
|
},
|
"name": "p2(default:default.test)",
|
"namespace": "default",
|
"node": "172.23.104.110:8091",
|
"statement": "prepare p2 as select * from test1;",
|
"uses": 0
|
}
|
},
|
{
|
"prepareds": {
|
"encoded_plan": "H4sIAAAAAAAA/6STUYsTMRSF/8pw9q0EsSoIeVsXBFGwsOKLlBLTO9PYTJK9uVlay/jbJTNTVksR1JeZTO5JzpkvuSdQsHFL203yJkADCi0ZKUx3MQhHn6GXLxRc2NLhNrnPxNnFAP1qnru3JrynY07GUoY+YUutKV70/H4mlKfHEro1PtOgEExP0EhLTONxNfR5LRRiIjYSue548/SB2yK7yO47QSGxe3Seusn3g8sC/eWET4Y7kqfdriVRWLF7hH5dBzFl6OfDelD4YXfOby9N7+mhULDVcxIwhdHqr0Urdr3hY4X2Egpfi93/GhUzVGjcpEl6ntokjt/Iygj/hLm62dMRWrhUqvv5GKBx/svrcLON6ayCQskudNDossOgfg/8lsTurif9N7tLg5Vh4z15/Bf8d8GJM341MYICUy5eNkLc51FNh1SFmXxbI4nhmdt6WA/17C9chcn0qDWFh0J8rP1AB5l6JLsujF1S0y6gscCgMNcTUzJMTVo2JjeZPFlpFk3LsW/+eCdLprs3H+dcPwMAAP//3ZqbKJsDAAA=",
|
"featureControls": 12,
|
"indexApiVersion": 4,
|
"indexScanKeyspaces": {
|
"default:default.test.test1": false
|
},
|
"name": "p1",
|
"node": "172.23.104.173:8091",
|
"statement": "prepare p1 as select * from default:default.test.test1",
|
"uses": 0
|
}
|
}
|
]
|