Details
-
New Feature
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
13.2
-
None
-
None
Description
MDEV-31342 implemented a streaming optimization for information_schema tables.
It's currently subject to many restrictions, some of them are inherently incompatible with streaming, others were artificially introduced to simplify the original implementation.
This task is to remove those artificial limitations, such as
- UNION ALL
- HAVING (w/o ORDER BY or GROUP BY)
- SELECT *
- constants, expressions, or function calls in the SELECT clause
- ANALYZE SELECT
- SELECT ... INTO
- stored functions
- LIMIT / OFFSET
- SQL_CALC_FOUND_ROWS
- ROWNUM() —
MDEV-41171 - LIMIT ROWS EXAMINED —
MDEV-41171 - MAX_STATEMENT_TIME —
MDEV-41165
may be I'm wrong and some of these limitations are indeed inherent and cannot be lifted
Attachments
Issue Links
- is caused by
-
MDEV-31342 I_S optimization: avoid temp table
-
- Closed
-