Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
6.1.1
-
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.
