Critical Description
I have two nodes 192.168.10.10 and 192.168.10.11. For some reason when I prepared this statment on 192.168.10.11, it did not get prepared on 192.168.10.10. (All queries issued through the UI)
prepare p2 from select * from default d join bucket0 b on (d.click == b.click). However when prepared again as p4, this time it succesfully got prepared on both nodes. Also if a node sees that it does not have a prepared statement that exists it should autoprepare it right? When I try to execute p2 on the other node (192.168.10.10) it says p2 does not exist.
I have two buckets in my data called default and bucket0, both with documents that look like so:
{
"click": "to edit",
"with JSON": "there are no reserved field names"
}
I have a primary index and an index on the field click on both buckets
[
|
{
|
"encoded_plan": "H4sIAAAAAAAA/6RU3WobPRR8FTHfjRNECPaXuBbkIhQKKaEEUnpTjK3Vnl0rliVV0qZJw/bZi3bt2PmhP/GVfaThaGbO7HkAWeVKKmfeSAsBcFQkUxPovbMpOBMhjjm0Lenu3OsvFKJ2FmLEYeWKIOCH4HCegkwuQDzgv22Ba/rWkFUEjp9qoU0ZyEJ8fQo6b9LCBf0jo3zQt9pQTTG3utQxdfDPMtSUIFBSJRuTxPoXHFdB30KMW/4KqmjUktLxDmrabpi8iepF9uFaSTsCh4z5KazdgYAyWi039UyX+Xo0nlSTEyqGk6KQ4/8fb31wN6RSZ+ZDlr2S4X62pHuIFBpqOZZ0H71UtNWD3vSXp9FLGzuydCdV6ltwBGlr6o61VabpJ3fMYdx3CNjGGLTTdsrRRG1rCNRRIxu5K/kDJbXYVfvXvJ53upJBGkMGe43gE8VE5aVz/qPTNhMzuuNW5BzamTKyiZnGYDAv50fzbijzA3bGBvNiWx/sx+JlEIrfB6F4V41PJ6PRaXVayiGdvC0I20C/HgTbmTMzzvlNCP6YjYWuF9muXbc6do+RGW0i8xTzj9kpsJ+Udto+739hddLSXPUWgiNQbEyaJQqrjWafgZFMlb+TJMNjs+dctd12ym+9fO46BZIrdEsk6tp2ezJP7RACh2g5Et3l/eMDeRmI+SGrgluxSIZUYod9tdbISnbjtGVrI1jBnGWD8qizl52dsaL/e4D2VwAAAP//eGc4NKcFAAA=", |
"featureControls": 0, |
"indexApiVersion": 3, |
"name": "[192.168.10.11:8091]p2", |
"operator": { |
"#operator": "Sequence", |
"~children": [ |
{
|
"#operator": "Authorize", |
"privileges": { |
"List": [ |
{
|
"Priv": 7, |
"Target": "default:default" |
},
|
{
|
"Priv": 7, |
"Target": "default:bucket0" |
}
|
]
|
},
|
"~child": { |
"#operator": "Sequence", |
"~children": [ |
{
|
"#operator": "IndexScan3", |
"as": "d", |
"index": "click", |
"index_id": "d379f95eb29bba74", |
"index_projection": { |
"primary_key": true |
},
|
"keyspace": "default", |
"namespace": "default", |
"spans": [ |
{
|
"exact": true, |
"range": [ |
{
|
"inclusion": 0, |
"low": "null" |
}
|
]
|
}
|
],
|
"using": "gsi" |
},
|
{
|
"#operator": "Fetch", |
"as": "d", |
"keyspace": "default", |
"namespace": "default" |
},
|
{
|
"#operator": "Parallel", |
"~child": { |
"#operator": "Sequence", |
"~children": [ |
{
|
"#operator": "NestedLoopJoin", |
"alias": "b", |
"on_clause": "((`d`.`click`) = (`b`.`click`))", |
"~child": { |
"#operator": "Sequence", |
"~children": [ |
{
|
"#operator": "IndexScan3", |
"as": "b", |
"index": "click", |
"index_id": "b8f769336f6da2e5", |
"index_projection": { |
"primary_key": true |
},
|
"keyspace": "bucket0", |
"namespace": "default", |
"nested_loop": true, |
"spans": [ |
{
|
"exact": true, |
"range": [ |
{
|
"high": "(`d`.`click`)", |
"inclusion": 3, |
"low": "(`d`.`click`)" |
}
|
]
|
}
|
],
|
"using": "gsi" |
},
|
{
|
"#operator": "Fetch", |
"as": "b", |
"keyspace": "bucket0", |
"namespace": "default", |
"nested_loop": true |
}
|
]
|
}
|
},
|
{
|
"#operator": "InitialProject", |
"result_terms": [ |
{
|
"expr": "self", |
"star": true |
}
|
]
|
},
|
{
|
"#operator": "FinalProject" |
}
|
]
|
}
|
}
|
]
|
}
|
},
|
{
|
"#operator": "Stream" |
}
|
]
|
},
|
"signature": { |
"*": "*" |
},
|
"text": "prepare p2 from select * from default d join bucket0 b on (d.click == b.click)" |
}
|
]
|
