When working on
MCOL-902, which complains about the reported execution time time, the sample query crashes mysqld. The crash is due to a failure to check return code at ha_exec_plan.cpp around line 3608. The call to buildReturnedColumn() fails, sets gwi.fatalParseError and returns NULL. The return value is used without checking first. In general, buildReturnedColumn() should never fail, as all syntax is checked before getting to this point. However, something is stripping the schema name off of the GROUP_CONCAT's ORDER BY clause.
After fixing the crash issue, the query fails with:
ERROR 1178 (42000): The storage engine for the table doesn't support IDB-3009: Unknown column '..g_position', which is why buildReturnedColumn() reports an error.
This query works in 1.0
CREATE TABLE `phased_genotype` ( `animalID` varchar(18) DEFAULT NULL, `mid` int(11) DEFAULT NULL, `phase` tinyint(4) DEFAULT NULL ) ENGINE=Columnstore DEFAULT CHARSET=utf8;
CREATE TABLE `phased_snp_info` ( `mid` int(11) DEFAULT NULL, `chr` tinyint(4) DEFAULT NULL, `position` bigint(20) DEFAULT NULL, `g_position` int(11) DEFAULT NULL ) ENGINE=Columnstore DEFAULT CHARSET=utf8;
select animalID,group_concat(phase order by b.g_position separator '') as g from phased_genotype a,phased_snp_info b where a.mid=b.mid group by animalID;