-
Type:
Bug
-
Resolution: Duplicate
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Optimization
-
ALL
-
None
-
None
-
None
-
None
-
None
-
None
-
None
If the base table is empty:
[js_test:join_costing_invariants] [jsTest] command failed: {
[js_test:join_costing_invariants] [jsTest] "ok" : 0,
[js_test:join_costing_invariants] [jsTest] "errmsg" : "estimateMackertLohmanRandIO() expected numPagesColl > 0",
[js_test:join_costing_invariants] [jsTest] "code" : 11943801,
[js_test:join_costing_invariants] [jsTest] "codeName" : "Location11943801"
[js_test:join_costing_invariants] [jsTest] } with original command request: {
[js_test:join_costing_invariants] [jsTest] "explain" : {
[js_test:join_costing_invariants] [jsTest] "aggregate" : "no_rows",
[js_test:join_costing_invariants] [jsTest] "pipeline" : [
[js_test:join_costing_invariants] [jsTest] {
[js_test:join_costing_invariants] [jsTest] "$lookup" : {
[js_test:join_costing_invariants] [jsTest] "from" : "many_rows",
[js_test:join_costing_invariants] [jsTest] "localField" : "i_idx",
[js_test:join_costing_invariants] [jsTest] "foreignField" : "i_idx",
[js_test:join_costing_invariants] [jsTest] "as" : "a"
[js_test:join_costing_invariants] [jsTest] }
[js_test:join_costing_invariants] [jsTest] },
[js_test:join_costing_invariants] [jsTest] {
[js_test:join_costing_invariants] [jsTest] "$unwind" : "$a"
[js_test:join_costing_invariants] [jsTest] },
[js_test:join_costing_invariants] [jsTest] {
[js_test:join_costing_invariants] [jsTest] "$lookup" : {
[js_test:join_costing_invariants] [jsTest] "from" : "many_rows",
[js_test:join_costing_invariants] [jsTest] "localField" : "i_idx",
[js_test:join_costing_invariants] [jsTest] "foreignField" : "i_idx",
[js_test:join_costing_invariants] [jsTest] "as" : "b"
[js_test:join_costing_invariants] [jsTest] }
[j0] {"t":{"$date":"2026-02-20T08:37:19.691+00:00"},"s":"I", "c":"NETWORK", "id":22944, "ctx":"conn9","msg":"Connection ended","attr":{"remote":"127.0.0.1:49290","isLoadBalanced":false,"isPriority":false,"uuid":{"uuid":{"$uuid":"d9ef145f-324d-48ab-b8da-411d2a5b37e5"}},"connectionId":9,"connectionCount":0}}
[js_test:join_costing_invariants] [jsTest] },
[js_test:join_costing_invariants] [jsTest] {
[js_test:join_costing_invariants] [jsTest] "$unwind" : "$b"
[js_test:join_costing_invariants] [jsTest] }
[js_test:join_costing_invariants] [jsTest] ],
[js_test:join_costing_invariants] [jsTest] "cursor" : { }
[js_test:join_costing_invariants] [jsTest] },
[js_test:join_costing_invariants] [jsTest] "lsid" : {
[js_test:join_costing_invariants] [jsTest] "id" : UUID("ef517b6a-e97b-4a49-bd84-08ab7322c6c4")
[js_test:join_costing_invariants] [jsTest] },
[js_test:join_costing_invariants] [jsTest] "$traceCtx" : {
[js_test:join_costing_invariants] [jsTest] "traceparent" : "00-42ee0bb8b1804b338f3d972fac2ac2db-6a8f6b189ed04d05-01"
[js_test:join_costing_invariants] [jsTest] }
[js_test:join_costing_invariants] [jsTest] } on connection: connection to localhost:20000 with errmsg: estimateMackertLohmanRandIO() expected numPagesColl > 0
Let me know if a complete test case is required.
- duplicates
-
SERVER-119780 [Join Optimization] Implement buffer aware index scan cost formula
-
- Closed
-