Major Description
Cluster: Capella 7.6 - provisioned
When SDK request is sent to get a doc using meta().id, profile is received in response even when it is not asking for. But the expected behaviour is, profile should not be received if not mentioned in query/command.
Below is the request sent:
return_result: true |
cluster_command {
|
query {
|
statement: "select * from default where meta().id=\"99dc1d9a-97d8-4fe6-8082-ee756c30e803\"" |
content_as {
|
as_json_object: true |
}
|
}
|
}
|
Below is the response received:
query_result {
|
content {
|
content_as_bytes: "{\"default\":{\"foo\":\"bar\"}}"
|
}
|
meta_data {
|
request_id: "d516773f-9b67-4ade-a292-488b135b9b08"
|
client_context_id: "a04ce5dd-5847-436e-88b1-8ef01f1687d6"
|
status: SUCCESS
|
signature: "{\"*\":\"*\"}"
|
profile: "{\"cpuTime\":\"4.303699ms\",\"executionTimings\":{\"#operator\":\"Authorize\",\"#planPreparedTime\":\"2024-02-19T18:46:26.425Z\",\"#stats\":{\"#phaseSwitches\":4,\"execTime\":\"1.677\302\265s\",\"servTime\":\"314.657\302\265s\"},\"privileges\":{\"List\":[{\"Priv\":7,\"Props\":0,\"Target\":\"default:default\"}]},\"~child\":{\"#operator\":\"Sequence\",\"#stats\":{\"#phaseSwitches\":2,\"execTime\":\"4.209\302\265s\"},\"~children\":[{\"#operator\":\"IndexScan3\",\"#stats\":{\"#itemsIn\":1,\"#itemsOut\":1,\"#phaseSwitches\":7,\"execTime\":\"9.051\302\265s\",\"kernTime\":\"5.954\302\265s\",\"servTime\":\"1.46983ms\",\"usedMemory\":550},\"index\":\"#primary\",\"index_id\":\"7ba35111fb1a35c8\",\"keyspace\":\"default\",\"namespace\":\"default\",\"optimizer_estimates\":{\"cardinality\":0.1,\"cost\":1.205,\"fr_cost\":1.205,\"size\":1},\"spans\":[{\"exact\":true,\"range\":[{\"high\":\"\\\"99dc1d9a-97d8-4fe6-8082-ee756c30e803\\\"\",\"inclusion\":3,\"low\":\"\\\"99dc1d9a-97d8-4fe6-8082-ee756c30e803\\\"\"}]}],\"using\":\"gsi\"},{\"#operator\":\"Fetch\",\"#stats\":{\"#itemsIn\":1,\"#itemsOut\":1,\"#phaseSwitches\":10,\"execTime\":\"17.755\302\265s\",\"kernTime\":\"1.418457ms\",\"servTime\":\"849.622\302\265s\",\"usedMemory\":1966},\"keyspace\":\"default\",\"namespace\":\"default\",\"optimizer_estimates\":{\"cardinality\":0.1,\"cost\":2.4160000000000004,\"fr_cost\":2.4160000000000004,\"size\":1}},{\"#operator\":\"Sequence\",\"#stats\":{\"#phaseSwitches\":1,\"execTime\":\"7.817\302\265s\"},\"~children\":[{\"#operator\":\"Filter\",\"#stats\":{\"#itemsIn\":1,\"#itemsOut\":1,\"#phaseSwitches\":8,\"execTime\":\"10.46\302\265s\",\"kernTime\":\"2.291639ms\",\"usedMemory\":1966},\"condition\":\"((meta(`default`).`id`) = \\\"99dc1d9a-97d8-4fe6-8082-ee756c30e803\\\")\",\"optimizer_estimates\":{\"cardinality\":0.010000000000000002,\"cost\":2.4161000000000006,\"fr_cost\":2.4161000000000006,\"size\":1}},{\"#operator\":\"InitialProject\",\"#stats\":{\"#itemsIn\":1,\"#itemsOut\":1,\"#phaseSwitches\":7,\"execTime\":\"2.73\302\265s\",\"kernTime\":\"2.306981ms\"},\"discard_original\":true,\"optimizer_estimates\":{\"cardinality\":0.010000000000000002,\"cost\":2.4161100000000006,\"fr_cost\":2.4161100000000006,\"size\":1},\"preserve_order\":true,\"result_terms\":[{\"expr\":\"self\",\"star\":true}]}]},{\"#operator\":\"Stream\",\"#stats\":{\"#itemsIn\":1,\"#itemsOut\":1,\"#phaseSwitches\":3,\"execTime\":\"4.33\302\265s\"},\"optimizer_estimates\":{\"cardinality\":0.010000000000000002,\"cost\":2.4161100000000006,\"fr_cost\":2.4161100000000006,\"size\":1},\"serializable\":true}]},\"~versions\":[\"7.6.0-N1QL\",\"7.6.0-2149-enterprise\"]},\"optimizerEstimates\":{\"cardinality\":0.010000000000000002,\"cost\":2.4161100000000006},\"phaseCounts\":{\"fetch\":1,\"filter\":1,\"indexScan\":1,\"indexScan.GSI\":1},\"phaseOperators\":{\"authorize\":1,\"fetch\":1,\"filter\":1,\"indexScan\":1,\"indexScan.GSI\":1,\"project\":1,\"stream\":1},\"phaseTimes\":{\"authorize\":\"316.334\302\265s\",\"fetch\":\"867.377\302\265s\",\"filter\":\"10.46\302\265s\",\"indexScan\":\"1.478881ms\",\"indexScan.GSI\":\"1.478881ms\",\"instantiate\":\"20.132\302\265s\",\"parse\":\"364.562\302\265s\",\"plan\":\"1.121323ms\",\"project\":\"2.73\302\265s\",\"run\":\"6.93804ms\",\"stream\":\"4.33\302\265s\"},\"requestTime\":\"2024-02-19T18:46:26.424Z\",\"servicingHost\":\"svc-dqisea-node-002.an6lf8zqdswbjbgf.nonprod-project-avengers.com:8091\"}"
|
}
|
}
|
While the expected response is:
query_result {
|
content {
|
content_as_bytes: "{\"default\":{\"foo\":\"bar\"}}" |
}
|
meta_data {
|
request_id: "d516773f-9b67-4ade-a292-488b135b9b08" |
client_context_id: "a04ce5dd-5847-436e-88b1-8ef01f1687d6" |
status: SUCCESS
|
signature: "{\"*\":\"*\"}" |
}
|
}
|
This is seen only in Capella 7.6 provisioned and not in any on-prem clusters.
Thanks!