On a table that has an after insert trigger where you need to call a view that uses a group by the insert fails with Invalid use of group function

however adding in a limit allows the query to run

the trigger is defined as follows

BEGIN

drop temporary table if exists fsstoredcalcs;

Create temporary table ttp1 as select * from myupdate_vw where fID = NEW.fID;

//updates to tables based on ttp1

END

Changing this to the below works.

BEGIN

drop temporary table if exists fsstoredcalcs;

Create temporary table ttp1 as select * from myupdate_vw where fID = NEW.fID limit 1000;

//updates to tables based on ttp1

END