5.0.0 - 严重 - 已处理
环境配置如下:
执行代码:
Ads::where(['status' => ['eq', 1]])->chunk(100, function ($order) {
}, 'begin_time', 'asc');重现方式:如果参与排序字段的转换类型为"timestamp",那么排序规则为"asc"或"desc"都有可能死循环.
[ sql ] [ SQL ] SHOW COLUMNS FROM `cs_ads` [ RunTime:0.064000s ]
[ sql ] [ SQL ] SELECT * FROM `cs_ads` WHERE `status` = 1 ORDER BY `begin_time` asc LIMIT 100 [ RunTime:0.064000s ]
[ sql ] [ SQL ] SELECT * FROM `cs_ads` WHERE `status` = 1 AND `begin_time` > 2017 ORDER BY `begin_time` asc LIMIT 100 [ RunTime:0.065000s ]
........
[ sql ] [ SQL ] SELECT * FROM `cs_ads` WHERE `status` = 1 AND `begin_time` > 2017 ORDER BY `begin_time` asc LIMIT 100 [ RunTime:0.066000s ]
[ sql ] [ SQL ] SELECT * FROM `cs_ads` WHERE `status` = 1 AND `begin_time` > 2017 ORDER BY `begin_time` asc LIMIT 100 [ RunTime:0.066000s ]
[ error ] [1]Maximum execution time of 30 seconds exceeded[E:\wwwroot\careyshop\trunk\thinkphp\library\think\db\Connection.php:368] 