单条Sql可执行：SELECT count(*) FROM [Z_TB_REPORT_Zqjg_LC] WHERE ( 1=1 and GJAHR ='2017' and MONAT='4' ) GROUP BY GJAHR,MONAT,BUKRSname
分页paginate： SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM
(SELECT COUNT(*) AS tp_count FROM
( SELECT T1.* FROM
(SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM
(SELECT count(*) FROM [Z_TB_REPORT_Zqjg_LC] WHERE ( 1=1 and GJAHR ='2017' and MONAT='4' ) GROUP BY GJAHR,MONAT,BUKRSname
) AS thinkphp) AS T1
) [_group_count_]) AS thinkphp
) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1)
报错没有为 'thinkphp' 的列 1 指定任何列名称。
解决方法可修改源码：Query.php文件455行代码，
// 支持GROUP
$options = $this->getOptions();
$subSql = $this->options($options)->field('count(' . $field . ') AS tp_count')->bind($this->bind)->buildSql();