strongduanmu commented on issue #10563: URL: https://github.com/apache/shardingsphere/issues/10563#issuecomment-927413680
This exception is caused by the fact that the aggregate function must use `group by`, which is not supported by the native database. ``` ERROR 1140 (42000): In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column 'testdb_0.t_order_0.order_id'; this is incompatible with sql_mode=only_full_group_by ``` If sql is rewritten as `select count(1) from t_order group by order_id order by order_id desc;` it can be executed normally. `Can't find index` exception has been fixed by #11971. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
