mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-26 11:48:52 +03:00
51 lines
1.7 KiB
Plaintext
51 lines
1.7 KiB
Plaintext
# -------------------------------------------------------------- #
|
|
# Test case migrated from regression test suite: bug3292.sql
|
|
#
|
|
# Author: Daniel Lee, daniel.lee@mariadb.com
|
|
# -------------------------------------------------------------- #
|
|
#
|
|
--source ../include/have_columnstore.inc
|
|
#
|
|
USE tpch1;
|
|
#
|
|
--disable_warnings
|
|
drop table if exists bug3292;
|
|
--enable_warnings
|
|
|
|
create table bug3292 (c1 double, c2 float, c3 char(12)) engine=columnstore;
|
|
insert into bug3292 values
|
|
(5.24062, 5.24062, '5.24062'),
|
|
(5.24062, 5.24062, '5.24062'),
|
|
(3.24062, 3.24062, '3.24062'),
|
|
(9.24062, 9.24062, '9.24062'),
|
|
(-5.24062, -5.24062, '-5.24062'),
|
|
(-3.24062, -3.24062, '-3.24062'),
|
|
(-9.24062, -9.24062, '-9.24062'),
|
|
(5.24562, 5.24562, '5.24562'),
|
|
(3.24562, 3.24562, '3.24562'),
|
|
(9.94562, 9.94562, '9.94562'),
|
|
(-5.24562, -5.24562, '-5.24562'),
|
|
(-3.24562, -3.24562, '-3.24562'),
|
|
(-9.94562, -9.94562, '-9.94562'),
|
|
(-3.2e-10, -3.2e-10, '-3.2e-10'),
|
|
(3.2e-10, 3.2e-10, '3.2e-10'),
|
|
(-3.2e10, -3.2e10, '-3.2e10'),
|
|
(3.2e10, 3.2e10, '3.2e10'),
|
|
(-3.2e30, -3.2e30, '-3.2e30'),
|
|
(3.2e30, 3.2e30, '3.2e30');
|
|
|
|
select c1, format(c1, 0), format(c2,0), format(c3,0) from bug3292;
|
|
select c1, format(c1, 1), format(c2,1), format(c3,1) from bug3292;
|
|
select c1, format(c1, 2), format(c2,2), format(c3,2) from bug3292;
|
|
select c1, format(c1, 3), format(c2,2), format(c3,2) from bug3292;
|
|
select c1, format(c1, 4), format(c2,2), format(c3,2) from bug3292;
|
|
select c1, format(c1, 5), format(c2,2), format(c3,2) from bug3292;
|
|
select c1, format(c1, 6), format(c2,6), format(c3,6) from bug3292;
|
|
select c1, format(c1, -1), format(c2,-1), format(c3,-1) from bug3292;
|
|
|
|
--disable_warnings
|
|
drop table if exists bug3292;
|
|
--enable_warnings
|
|
#
|
|
|