Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-56504

[sbe][query_fuzzer_sharded] SBE query results do not match classic engine

    • Type: Icon: Bug Bug
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Labels:
      None
    • ALL
    • Query Execution 2021-05-03, Query Execution 2021-05-17

      In this task:

      [js_test:query_fuzzer-2eaf33-1619674683229-3] Unexpected failure for command: {
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 	"find" : "fuzzer_coll",
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 	"filter" : {
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 		"$expr" : {
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 			"$dateFromParts" : {
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 				"year" : NumberLong(19),
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 				"hour" : 2,
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 				"millisecond" : {
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 					"$ln" : "$obj.obj.obj.obj.num"
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 				},
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 				"timezone" : "-8949"
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 			}
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 		}
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 	},
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 	"projection" : {
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 		"obj.obj.obj.obj.obj" : 0,
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 		"obj.obj.obj.obj.array" : 0,
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 		"num" : 0,
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 		"sortKey" : {
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 			"$meta" : "sortKey"
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 		}
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 	},
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 	"sort" : {
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 		"obj.obj" : 1,
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 		"date" : -1,
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 		"_id" : 1
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 	},
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 	"limit" : 12
      [js_test:query_fuzzer-2eaf33-1619674683229-3] }
      [js_test:query_fuzzer-2eaf33-1619674683229-3] Error: Find and aggregate commands failed with different errors: [null] != [Error: error: {
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 	"ok" : 0,
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 	"errmsg" : "PlanExecutor error during aggregation :: caused by :: 'millisecond' must evaluate to an integer",
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 	"code" : 4848979,
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 	"codeName" : "Location4848979",
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 	"$clusterTime" : {
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 		"clusterTime" : Timestamp(1619674791, 38),
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 		"signature" : {
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 			"hash" : BinData(0,"AAAAAAAAAAAAAAAAAAAAAAAAAAA="),
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 			"keyId" : NumberLong(0)
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 		}
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 	},
      [js_test:query_fuzzer-2eaf33-1619674683229-3] 	"operationTime" : Timestamp(1619674791, 38)
      [js_test:query_fuzzer-2eaf33-1619674683229-3] }] :
      

            Assignee:
            eric.cox@mongodb.com Eric Cox (Inactive)
            Reporter:
            kyle.suarez@mongodb.com Kyle Suarez
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: