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

Regression: calShowPartition returns N/A

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 6.1.1
    • Fix Version/s: 6.1.1
    • Component/s: ExeMgr
    • Labels:
      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

              Assignee:
              sergey.zefirov Sergey Zefirov
              Reporter:
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration