Details
-
Bug
-
Resolution: Incomplete
-
Major
-
None
-
None
-
None
-
None
-
0
Description
QueryOptionTest.noProfileRequestedGivesEmptyProfile
Cluster: Capella provisioned 7.6
The test created below query request:
query_result {
|
content {
|
content_as_bytes: "{\"default\":{\"foo\":\"bar\"}}"
|
}
|
meta_data {
|
request_id: "f1223e0b-1810-43f9-b247-944b2210fb4d"
|
client_context_id: "a624e9cd-308d-4345-b716-86a67971915b"
|
status: SUCCESS
|
signature: "{\"*\":\"*\"}"
|
profile: "{\"requestTime\":\"2024-02-08T09:47:54.127Z\",\"phaseOperators\":{\"filter\":1,\"indexScan\":1,\"indexScan.GSI\":1,\"stream\":1,\"fetch\":1,\"project\":1,\"authorize\":1},\"servicingHost\":\"svc-dqisea-node-003.q3eog8gunyibntyw.nonprod-project-avengers.com:8091\",\"optimizerEstimates\":{\"cardinality\":0.010000000000000002,\"cost\":2.4161100000000006},\"cpuTime\":\"70.243\302\265s\",\"phaseCounts\":{\"filter\":1,\"indexScan\":1,\"indexScan.GSI\":1,\"fetch\":1},\"executionTimings\":{\"#stats\":{\"execTime\":\"1.282\302\265s\",\"servTime\":\"4.698\302\265s\",\"#phaseSwitches\":4},\"~child\":{\"~children\":[{\"keyspace\":\"default\",\"spans\":[{\"exact\":true,\"range\":[{\"inclusion\":3,\"low\":\"\\\"5c97db88-eff4-4dad-a26b-a411e4707624\\\"\",\"high\":\"\\\"5c97db88-eff4-4dad-a26b-a411e4707624\\\"\"}]}],\"#operator\":\"IndexScan3\",\"using\":\"gsi\",\"#stats\":{\"#phaseSwitches\":7,\"kernTime\":\"14.322\302\265s\",\"usedMemory\":550,\"execTime\":\"21.692\302\265s\",\"servTime\":\"1.613167ms\",\"#itemsOut\":1,\"#itemsIn\":1},\"namespace\":\"default\",\"index\":\"#primary\",\"optimizer_estimates\":{\"cost\":1.205,\"size\":1,\"fr_cost\":1.205,\"cardinality\":0.1},\"index_id\":\"53dedc04151d5161\"},{\"#stats\":{\"#phaseSwitches\":10,\"kernTime\":\"1.659144ms\",\"usedMemory\":1966,\"execTime\":\"20.777\302\265s\",\"servTime\":\"469.419\302\265s\",\"#itemsOut\":1,\"#itemsIn\":1},\"namespace\":\"default\",\"keyspace\":\"default\",\"optimizer_estimates\":{\"cost\":2.4160000000000004,\"size\":1,\"fr_cost\":2.4160000000000004,\"cardinality\":0.1},\"#operator\":\"Fetch\"},{\"~children\":[{\"#stats\":{\"execTime\":\"8.39\302\265s\",\"#phaseSwitches\":8,\"#itemsOut\":1,\"kernTime\":\"2.154786ms\",\"usedMemory\":1966,\"#itemsIn\":1},\"optimizer_estimates\":{\"cost\":2.4161000000000006,\"size\":1,\"fr_cost\":2.4161000000000006,\"cardinality\":0.010000000000000002},\"#operator\":\"Filter\",\"condition\":\"((meta(`default`).`id`) = \\\"5c97db88-eff4-4dad-a26b-a411e4707624\\\")\"},{\"#stats\":{\"execTime\":\"4.181\302\265s\",\"#phaseSwitches\":7,\"#itemsOut\":1,\"kernTime\":\"2.166957ms\",\"#itemsIn\":1},\"optimizer_estimates\":{\"cost\":2.4161100000000006,\"size\":1,\"fr_cost\":2.4161100000000006,\"cardinality\":0.010000000000000002},\"#operator\":\"InitialProject\",\"result_terms\":[{\"star\":true,\"expr\":\"self\"}],\"discard_original\":true,\"preserve_order\":true}],\"#stats\":{\"execTime\":\"7.449\302\265s\",\"#phaseSwitches\":1},\"#operator\":\"Sequence\"},{\"#stats\":{\"execTime\":\"4.531\302\265s\",\"#phaseSwitches\":3,\"#itemsOut\":1,\"#itemsIn\":1},\"optimizer_estimates\":{\"cost\":2.4161100000000006,\"size\":1,\"fr_cost\":2.4161100000000006,\"cardinality\":0.010000000000000002},\"#operator\":\"Stream\",\"serializable\":true}],\"#stats\":{\"execTime\":\"1.941\302\265s\",\"#phaseSwitches\":2},\"#operator\":\"Sequence\"},\"privileges\":{\"List\":[{\"Props\":0,\"Priv\":7,\"Target\":\"default:default\"}]},\"#operator\":\"Authorize\",\"~versions\":[\"7.6.0-N1QL\",\"7.6.0-2071-enterprise\"],\"#planPreparedTime\":\"2024-02-08T09:47:54.128Z\"},\"phaseTimes\":{\"plan.keyspace.metadata\":\"3.653\302\265s\",\"plan.index.metadata\":\"22.651\302\265s\",\"project\":\"4.181\302\265s\",\"run\":\"2.21186ms\",\"parse\":\"326.514\302\265s\",\"instantiate\":\"16.746\302\265s\",\"filter\":\"8.39\302\265s\",\"indexScan\":\"1.634859ms\",\"indexScan.GSI\":\"1.634859ms\",\"stream\":\"4.531\302\265s\",\"fetch\":\"490.196\302\265s\",\"authorize\":\"5.98\302\265s\",\"plan\":\"193.247\302\265s\"}}"
|
}
|
}
|
while we expect the `meta_data` not to contain `profile` key.
Attaching driver and performer logs for reference.
Thanks!