I do a sum query, the sql looks like below:
select material.code as material_code,material.name as material_name, sum(inventories.qty) as qty from inventories inner join materials on inventories.material_id=materials.id group by material.code,material.name
It run correctly.But when I add the group item, one day the rails told me something error.And report the identifier is too long.Then I find,each time,rails alway run a sql like below:
select count(*) as count_all,material.code,material.name as material_code_material_name from inventories inner join materials on inventories.material_id=materials.id group by material.code,material.name
when I add the group item,one day the identifier like material_code_material_name become too long
why?? And How can I fix it??