Eng 6485 fix bug of limit and group by

Paul and I have discussed about this. Paul's idea was to disable all the aggregation cases here, and to try optimization in the future.