From 7fd5dbf9db4e513faaabbe14aff3c10fca603415 Mon Sep 17 00:00:00 2001 From: Sean McGivern Date: Thu, 29 Nov 2018 12:52:48 +0000 Subject: Add a flag to use a subquery for group issues search We already had a flag to use a CTE, but this broke searching in some cases where we need to sort by a joined table. Disabling the CTE flag makes searches much slower. The new flag, to use a subquery, makes them slightly slower than the CTE, while maintaining correctness. If both it and the CTE flag are enabled, the subquery takes precedence. --- changelogs/unreleased/move-group-issues-search-cte-up-the-chain.yml | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 changelogs/unreleased/move-group-issues-search-cte-up-the-chain.yml (limited to 'changelogs') diff --git a/changelogs/unreleased/move-group-issues-search-cte-up-the-chain.yml b/changelogs/unreleased/move-group-issues-search-cte-up-the-chain.yml new file mode 100644 index 00000000000..0269e7b6196 --- /dev/null +++ b/changelogs/unreleased/move-group-issues-search-cte-up-the-chain.yml @@ -0,0 +1,5 @@ +--- +title: Fix error when searching for group issues with priority or popularity sort +merge_request: 23445 +author: +type: fixed -- cgit v1.2.1