Hi,
I have a few queries that do something like:
select t1.id, t2.names
from table1 t1
left join (
select id,group_concat(name) as names
from table2
group by id
) t2 on (t2.id=t1.id)
group by t1.id;
If I run the select in the left join by itself it runs pretty fast:
select id,group_concat(name) as names
from table2
group by id;
But when I add the group_concat into another query (inside the left join or any other complex query) it takes forever to run even when the tables just have a few thousand rows.
Are there any plans to implement group_concat on Infobright so that queries don’t run on MySQL engine?
Thanks,
Ivan.
