1
0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-08-07 03:22:57 +03:00
Files
mariadb-columnstore-engine/mysql-test/columnstore/bugfixes/mcol_5386.test

22 lines
477 B
Plaintext

-- source ../include/have_columnstore.inc
--disable_warnings
DROP DATABASE IF EXISTS mcol_5386;
--enable_warnings
CREATE DATABASE mcol_5386;
USE mcol_5386;
--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings
create table t1(c decimal(19)) engine=columnstore;
insert into t1(c) values (-2);
select bit_or(c), bit_xor(c), bit_and(c) from t1;
--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings
--disable_warnings
DROP DATABASE mcol_5386;
--enable_warnings