mysql 5.7.9 sql_MySQL 5.7.9版本sql_mode=only_full_group_by问题

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection idis 27Server version:5.7.12MySQL Community Server (GPL)

Copyright (c)2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracleis a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type'help;' or '\h' for help. Type '\c'to clear the current input statement.

mysql>SELECT @@GLOBAL.sql_mode;+-------------------------------------------------------------------------------------------------------------------------------------------+

| @@GLOBAL.sql_mode |

+-------------------------------------------------------------------------------------------------------------------------------------------+

| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |

+-------------------------------------------------------------------------------------------------------------------------------------------+

1 row in set (0.00sec)

mysql> SET sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

Query OK,0 rows affected (0.02sec)

mysql> select@@sql_mode;+------------------------------------------------------------------------------------------------------------------------+

| @@sql_mode |

+------------------------------------------------------------------------------------------------------------------------+

| STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |

+------------------------------------------------------------------------------------------------------------------------+

1 row in set (0.00 sec)

SELECT COUNT(*) FROM (

SELECT * FROM

(SELECT * FROM order_bid_did_relation

ORDER BY TIME DESC) AS T

GROUP BY T.BID

) AS TT

ORDER BY TT.time DESC

SELECT * FROM (

SELECT * FROM

(SELECT * FROM order_bid_did_relation

ORDER BY time DESC) AS T

GROUP BY T.BID

) AS TT

ORDER BY TT.time DESC

limit #{startRow},#{pageSize}