1
0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-04-21 19:45:56 +03:00

24 lines
645 B
Plaintext

# -------------------------------------------------------------- #
# Test case migrated from regression test suite: bug3532.sql
#
# Author: Daniel Lee, daniel.lee@mariadb.com
# -------------------------------------------------------------- #
#
--source ../include/have_columnstore.inc
#
USE tpch1;
#
--disable_warnings
drop table if exists bug3532;
--enable_warnings
create table `bug3532` (`c1` char(1) default null, `c2` int(11) default null) engine=columnstore;
insert into bug3532 values (1,1), (0,0), (1,12), (1,-1), (null, null);
select round(c1,c1) from bug3532 where c1 = 1;
--disable_warnings
drop table bug3532;
--enable_warnings
#