Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-125

SHOW TABLE STATUS returns invalid data for CS tables

    XMLWordPrintable

Details

    Description

      mysql> show table status;
      ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

      Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment

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

      customer Columnstore 10 Dynamic 2000 0 0 0 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL    
      dim_date Columnstore 10 Fixed 2000 0 0 0 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL    
      lineorder Columnstore 10 Dynamic 2000 0 0 0 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL    
      part Columnstore 10 Dynamic 2000 0 0 0 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL    
      supplier Columnstore 10 Dynamic 2000 0 0 0 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL    

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

      All tables have rows set to 2000, 0 for all other fields. For some reason dim_date shows as type 'fixed' while other tables are 'Dynamic'

      Attachments

        Issue Links

          is part of

          New Feature - A new feature of the product, which has yet to be developed. MCOL-4713 Optimizer statistics

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            People

              denis0x0D Denis Khalikov
              jswanhart Justin Swanhart (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.