drop table if exists decimal_test_CS;
create table if not exists decimal_test_CS (
 cnt int,
 val1 decimal(12,9),  -- 10,8 works!!!, 11,9 also does not work.
 val2 decimal(12,9)
) ENGINE=Columnstore;

drop table if exists decimal_test_InnoDB;
create table if not exists decimal_test_InnoDB (
 cnt int,
 val1 decimal(12,9),
 val2 decimal(12,9) 
) ENGINE=InnoDB;

insert into decimal_test_CS values (2, 11.42, 48.76);
insert into decimal_test_InnoDB values (2, 11.42, 48.76);

select val1*val2 from decimal_test_CS; -- 3.4368777 ==> WRONG
select val1*val2 from decimal_test_InnoDB; -- 556.8392 ==> CORRECT