[MCOL-126] analyze table/independent stats do not work for CS tables Created: 2016-06-12  Updated: 2019-07-10  Resolved: 2019-07-10

Status: Closed
Project: MariaDB ColumnStore
Component/s: ?
Affects Version/s: None
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Justin Swanhart (Inactive) Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MCOL-2223 Engine independent statistics for Col... Closed
Epic Link: ColumnStore Compatibility Improvements

 Description   

ANALYZE TABLE is not supported by CS, therefore it is not possible to collect engine independent statistics that were added in MariaDB 10.1

 Comments   
Comment by Justin Swanhart (Inactive) [ 2016-06-12 ]

mysql> analyze table lineorder;
-----------------------------------------------------------------------------------------+

Table Op Msg_type Msg_text

-----------------------------------------------------------------------------------------+

ssb_cs.lineorder analyze note The storage engine for the table doesn't support analyze

-----------------------------------------------------------------------------------------+
1 row in set (0.01 sec)

Comment by Justin Swanhart (Inactive) [ 2016-06-12 ]

mysql> use mysql
Database changed
mysql> select * from table_stats;
Empty set (0.00 sec)

Generated at Thu Feb 08 02:18:42 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.