create schema CS0617891; 

use CS0617891;

drop table if exists `test1`;

CREATE TABLE `test1` (`col1` decimal(12,2) DEFAULT NULL, `col2` smallint(5) unsigned DEFAULT NULL)

ENGINE=Columnstore DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

insert into test1 (col1,col2) values (99.99,2);

drop table if exists `test2`;

CREATE TABLE `test2` (`col1` decimal(12,2) DEFAULT NULL, `col2` int(10) unsigned DEFAULT NULL) 

ENGINE=Columnstore DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

insert into test2 (col1,col2) values (99.99,2);

--- RUN THIS UNION QUERY:

SELECT 'test1' AS table_name, count(*) as 'rows', SUM(col1*col2) AS losses FROM test1 UNION 

SELECT 'test2' AS table_name, count(*) as 'rows', SUM(col1*col2) AS losses FROM test2;

--- NOW, TRY THIS QUERY:

select * FROM (

SELECT 'test1' AS table_name, count(*) as 'rows', SUM(col1*col2) AS losses FROM test1 UNION 

SELECT 'test2' AS table_name, count(*) as 'rows', SUM(col1*col2) AS losses FROM test2) 

AS TABLES ORDER BY losses DESC, 'rows' DESC;

ERROR 1815 (HY000): Internal error: An unexpected condition within the query caused an internal processing error within Columnstore. Please check the log files for more details. Additional Information: error in UnionStep.

Jul 26 20:27:43 logs Calpont[216316]: 43.949355 |0|0|0| E 00 CAL0000: ./storage/columnstore/columnstore/utils/rowgroup/rowgroup.h@847: assertion '0' failed         %%10%%

Jul 26 20:27:43 logs joblist[216316]: 43.949490 |77|0|0| C 05 CAL0000: TupleUnion::readInput() MCS-2035: An internal error occurred.  Check the error log file & contact support.         %%10%%