You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-07-11 18:21:49 +03:00
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
|