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

Regression: calShowPartition returns N/A

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 6.1.1
    • 6.1.1
    • ExeMgr
    • None

    Description

      If I compile this ColumnStore revision:

      commit 47772cff10a094b2e2a1937a397378d4cb25faf0 (HEAD -> develop)
      Merge: f33b8605 16002e28
      Author: Roman Nozdrin <drrtuy@gmail.com>
      Date:   Tue Apr 6 12:44:04 2021 +0300
       
          Merge pull request #1848 from mariadb-AlexeyAntipovsky/MCOL-4573-dev
          
          [MCOL-4573] resize cpimport.bin arg vector as needed
      

      and run this SQL script:

      DROP TABLE IF EXISTS t1;
      CREATE TABLE t1 (a DECIMAL(17,1)) ENGINE=ColumnStore;
      INSERT INTO t1 VALUES (-8999999999999999.9);
      SELECT * FROM t1 WHERE a=0;
      SELECT calShowPartitions('t1','a');
      

      in prints the following output:

      +--------------------------------------------------------------------------------------------------------------------------------------------------------------+
      | calShowPartitions('t1','a')                                                                                                                                  |
      +--------------------------------------------------------------------------------------------------------------------------------------------------------------+
      | Part#     Min                           Max                           Status
        0.0.1     -8999999999999999.9           -8999999999999999.9           Enabled |
      +--------------------------------------------------------------------------------------------------------------------------------------------------------------+
      1 row in set (0.002 sec)
      

      Notice, it prints good Min and Max values.

      If I compile ColumnStore with the next revision in the history:

      commit c1138c4793c39772e73502c945d6ba6102b3aba3 (HEAD -> develop)
      Merge: 47772cff 1143e89f
      Author: Roman Nozdrin <drrtuy@gmail.com>
      Date:   Tue Apr 6 12:46:02 2021 +0300
       
          Merge pull request #1771 from mariadb-SergeyZefirov/MCOL-2044-update-ranges-during-DML
      

      and rerun the same script, it does not print Min/Max values anymore:

      +--------------------------------------------------------------------------------------------------------------------------------------------------------------+
      | calShowPartitions('t1','a')                                                                                                                                  |
      +--------------------------------------------------------------------------------------------------------------------------------------------------------------+
      | Part#     Min                           Max                           Status
        0.0.1     N/A                           N/A                           Enabled |
      +--------------------------------------------------------------------------------------------------------------------------------------------------------------+
      1 row in set (0.002 sec)
      

      I don't know if this change was intentional. Probably not.

      Attachments

        Issue Links

          Activity

            People

              sergey.zefirov Sergey Zefirov
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.