--source ../include/have_columnstore.inc
--disable_warnings
DROP DATABASE IF EXISTS mcol_4940;
--enable_warnings
CREATE DATABASE mcol_4940;
USE mcol_4940;

create table rounding_table ( a int, b double, c double) engine=columnstore;
insert into rounding_table values (26805, 1252, -9647);
insert into rounding_table values (26806, 573, -2804.5);

--sorted_result 
SELECT CASE a WHEN 26805 THEN ROUND(c/b, 2) WHEN 26806 THEN b END MCOL4940 FROM ( SELECT a, SUM(b) b, SUM(c) c FROM rounding_table GROUP BY a ) abc ;

DROP DATABASE mcol_4940;