Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
23.10.0
-
None
-
None
Description
Currently TEXT column is not doing any extent elimination for WHERE...LIKE clauses. It should cover this clause also.
Repro
------
CREATE TABLE t(d TEXT) ENGINE=COLUMNSTORE;
INSERT INTO t(d) VALUES ('b'),('b'),('b');
SELECT CALSETTRACE(1);
MariaDB [MCOL4580]> SELECT COUNT FROM t WHERE d like '%c%';----------
COUNT |
----------
0 |
----------
1 row in set, 1 warning (0.010 sec)
MariaDB [MCOL4580]> SELECT REGEXP_SUBSTR(CALGETTRACE(1),'(BlocksTouched-[^;]);') AS touched, REGEXP_SUBSTR(CALGETTRACE(1),'(PartitionBlocksEliminated-[^;]);') AS eliminated;
----------------------------------------------+
touched | eliminated |
----------------------------------------------+
BlocksTouched-3; | PartitionBlocksEliminated-0; |
----------------------------------------------+
1 row in set (0.000 sec)
Attachments
Issue Links
- relates to
-
MCOL-4580 Extent's approximate range keeping for dictionaries
- Closed