Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5.1, 5.6.1
-
None
-
2021-5, 2021-6, 2021-7, 2021-8
Description
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'); |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| calShowPartitions('t1','a') |
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Part# Min Max Status
|
0.0.1 -9000000000000000.0 -9000000000000000.0 Enabled |
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
Notice, the Min and Max values are wrong.
This happens because the underlying printing code uses double representation.
It should be fixed to use native representation.