Merge remote-tracking branch 'upstream/main' into aggregation-pushdow…

…n-sqlite-3520
FerretDB · noisersup · Oct 23, 2023 · Oct 18, 2023 · Oct 18, 2023 · Oct 18, 2023
commit 100e9c3c890f4f9627c8f2aa2a088781fc0a7530
@@ -107,9 +107,18 @@
 		}
 	}
 
+	// Limit pushdown is not applied if:
+	//  - `filter` is set, it must fetch all documents to filter them in memory;
+	//  - `sort` is set but `EnableSortPushdown` is not set, it must fetch all documents
+	//  and sort them in memory;
+	//  - `skip` is non-zero value, skip pushdown is not supported yet.
+	if params.Filter.Len() == 0 && (params.Sort.Len() == 0 || h.EnableSortPushdown) && params.Skip == 0 {
+		qp.Limit = params.Limit
+	}
+
 	if h.DisableFilterPushdown {
 		qp.Filter = nil
 	}

 	if !h.EnableSortPushdown {
 		qp.Sort = nil