mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-26 11:48:52 +03:00
4c9d6e39ac
* Restructured test suites and added autopilot and extended suites * Updated autopilot with correct branch - develop * Moved setup test case to a 'setup' directory, for consistency * Fixed a path issue * Updated some tests cases to keep up with development Co-authored-by: root <root@rocky8.localdomain>
116 lines
3.8 KiB
Plaintext
116 lines
3.8 KiB
Plaintext
USE tpch1;
|
|
set default_storage_engine=columnstore;
|
|
drop table if exists bug4388;
|
|
create table bug4388(
|
|
`venta_clave` int(10) DEFAULT NULL,
|
|
`cantidad` decimal(10,3) DEFAULT NULL,
|
|
`changev` decimal(18,4) DEFAULT NULL
|
|
);
|
|
insert into bug4388 values (null,null,6.8000);
|
|
select coalesce(sum(changev),0) as col1 from bug4388;
|
|
col1
|
|
6.8000
|
|
select sum(co) + 0 from ( select sum(col1) as co from ( select 0
|
|
as col1 union all select coalesce(sum(changev),0) as col1 from
|
|
bug4388 ) t ) res;
|
|
sum(co) + 0
|
|
6.8000
|
|
select sum(co) + 0 from ( select sum(col1) as co from ( select
|
|
coalesce(sum(changev),0) as col1 from bug4388 union all select 0
|
|
as col1 ) t ) res;
|
|
sum(co) + 0
|
|
6.8000
|
|
select sum(co) + 0 from ( select sum(col1) as co from ( select 0
|
|
as col1 union all select coalesce(sum(6.800),0) as col1 ) t ) res;
|
|
sum(co) + 0
|
|
6.800
|
|
select sum(col1) + 0 from( select 0 as col1 union all
|
|
select sum(changev) as col1 from bug4388 ) res;
|
|
sum(col1) + 0
|
|
6.8000
|
|
select sum(col1) from
|
|
( select 0 as col1 union all
|
|
select sum(changev) as col1 from bug4388 ) res;
|
|
sum(col1)
|
|
6.8000
|
|
select sum(co) from (select sum(changev) as co from bug4388 ) t;
|
|
sum(co)
|
|
6.8000
|
|
select sum(co) from ( select sum(col1) as co from (select sum(changev)
|
|
as col1 from bug4388 ) t ) res;
|
|
sum(co)
|
|
6.8000
|
|
select sum(col1) as co from ( select 984467440737095516
|
|
as col1 union all select coalesce(sum(changev),0) as col1 from
|
|
bug4388 ) t;
|
|
co
|
|
984467440737095522.8000
|
|
select sum(col1) as co from ( select 18446744073709551612
|
|
as col1 union all select coalesce(sum(changev),0) as col1 from
|
|
bug4388 ) t;
|
|
co
|
|
18446744073709551618.8000
|
|
drop table bug4388;
|
|
#
|
|
# MCOL-4613 Garbage result of a union between huge narrow DECIMAL and BIGINT
|
|
#
|
|
drop table if exists t1;
|
|
drop table if exists t2;
|
|
drop table if exists t3;
|
|
create table t1 (a decimal(17,1), b bigint);
|
|
insert into t1 values (9999999999999999.9, 999999999999999999);
|
|
select * from (select a from t1 union select b from t1) tu order by a;
|
|
a
|
|
9999999999999999.9
|
|
999999999999999999.0
|
|
drop table t1;
|
|
#
|
|
# MCOL-4612 A subquery with a union for DECIMAL and BIGINT returns zeros
|
|
#
|
|
create table t1 (a decimal(17,1), b bigint);
|
|
insert into t1 values (1, 1);
|
|
insert into t1 values (9999999999999999, 99999999999999999);
|
|
select * from (select a from t1 union select b from t1) tu order by a;
|
|
a
|
|
1.0
|
|
9999999999999999.0
|
|
99999999999999999.0
|
|
select * from (select a from t1 union all select b from t1) tu order by a;
|
|
a
|
|
1.0
|
|
1.0
|
|
9999999999999999.0
|
|
99999999999999999.0
|
|
drop table t1;
|
|
create table t1 (a decimal(18,5), b decimal(18,5) unsigned);
|
|
create table t2 (a bigint, b bigint unsigned);
|
|
create table t3 (a decimal(38,10), b decimal(38,10) unsigned);
|
|
insert into t1 values
|
|
(-1234567890123.12345, 1234567890123.12345),
|
|
(-1234567890123.1234, 1234567890123.1234),
|
|
(-9999999999999.99999, 9999999999999.99999),
|
|
(-999999999999.99999, 999999999999.99999),
|
|
(-99999999999.99999, 99999999999.99999);
|
|
insert into t2 values
|
|
(-123456789012345, 123456789012345),
|
|
(9223372036854775807, 18446744073709551613),
|
|
(-9223372036854775806, 0);
|
|
insert into t3 values
|
|
(-9999999999999999999999999999.9999999999, 9999999999999999999999999999.9999999999),
|
|
(-1234567890123456789012345678.9012345678, 1234567890123456789012345678.9012345678);
|
|
select * from (select a,b from t1 union select a,b from t2 union select a,b from t3) tu order by a,b;
|
|
a b
|
|
-9999999999999999999999999999.9999999999 9999999999999999999999999999.9999999999
|
|
-1234567890123456789012345678.9012345678 1234567890123456789012345678.9012345678
|
|
-9223372036854775806.0000000000 0.0000000000
|
|
-123456789012345.0000000000 123456789012345.0000000000
|
|
-9999999999999.9999900000 9999999999999.9999900000
|
|
-1234567890123.1234500000 1234567890123.1234500000
|
|
-1234567890123.1234000000 1234567890123.1234000000
|
|
-999999999999.9999900000 999999999999.9999900000
|
|
-99999999999.9999900000 99999999999.9999900000
|
|
9223372036854775807.0000000000 18446744073709551613.0000000000
|
|
drop table t1;
|
|
drop table t2;
|
|
drop table t3;
|