mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-21 19:45:56 +03:00
627a4b5819
This reverts commit 8b8ee98fd2b299bbc149545d368ed29de1c85b7e. Co-authored-by: Roman Nozdrin <rnozdrin@mariadb.com>
27 lines
650 B
Plaintext
27 lines
650 B
Plaintext
--source ../include/have_columnstore.inc
|
|
|
|
--echo #
|
|
--echo # MCOL-4614 calShowPartitions() precision loss for huge narrow decimal
|
|
--echo #
|
|
|
|
let $func_exists=`SELECT COUNT(*) FROM mysql.func WHERE name='calshowpartitions'`;
|
|
--disable_query_log
|
|
if (!$func_exists)
|
|
{
|
|
CREATE FUNCTION calshowpartitions RETURNS STRING SONAME "ha_columnstore.so";
|
|
}
|
|
--enable_query_log
|
|
|
|
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');
|
|
DROP TABLE IF EXISTS t1;
|
|
|
|
--disable_query_log
|
|
if (!$func_exists)
|
|
{
|
|
DROP FUNCTION calshowpartitions;
|
|
}
|
|
--enable_query_log
|