mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-26 11:48:52 +03:00
627a4b5819
This reverts commit 8b8ee98fd2b299bbc149545d368ed29de1c85b7e. Co-authored-by: Roman Nozdrin <rnozdrin@mariadb.com>
13 lines
450 B
Plaintext
13 lines
450 B
Plaintext
#
|
|
# MCOL-4614 calShowPartitions() precision loss for huge narrow decimal
|
|
#
|
|
CREATE TABLE t1 (a DECIMAL(17,1)) ENGINE=ColumnStore;
|
|
INSERT INTO t1 VALUES (-8999999999999999.9);
|
|
SELECT * FROM t1 WHERE a=0;
|
|
a
|
|
SELECT calshowpartitions('t1','a');
|
|
calshowpartitions('t1','a')
|
|
Part# Min Max Status
|
|
0.0.1 -8999999999999999.9 -8999999999999999.9 Enabled
|
|
DROP TABLE IF EXISTS t1;
|