Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
22.08(EOL), 23.02, 23.10
-
2025-7, 2025-8
Description
Sometimes queries runs slow , but suddenly runs fast without "order by" clause
or wrapping into a subselect like select * from (<select query>)
Even every case must be fixed , it should be a possibility to force the behaviour
of wrapping the query in a subselect, so application must not be changed,
so something like
columnstore_forced_subselect,
so simply set
set columnstore_forced_subselect = 1;
can work as a workarround,
Must be certainly dynamically and possible with global and session level.
Description:
Add an extra step to tuple union step. This will enable processing of unions better. Thus handling it on the columnstore side. Enable order by after unions, enabling sorting. See leonid.fedorov for details
Attachments
Issue Links
- is blocked by
-
MDEV-36602 Pushdown UNION processing to the engine handler
-
- Closed
-
- is duplicated by
-
MCOL-5222 ORDER BY on UNIONs in outer selects does not work
-
- Closed
-