dao 列group by问题

已经提了
https://github.com/nutzam/nutz/issues/1180

现在这种用法也十分蛋疼。

Record fetch = dao.fetch("biz_dev_kilometers", Cnd.NEW().groupBy("day").asc("day"));

结果后台报错

org.nutz.dao.DaoException: !Nutz SQL Error: 'SELECT * FROM biz_dev_kilometers  GROUP BY day  ORDER BY day ASC   LIMIT 0, 1 '
PreparedStatement: 
'SELECT * FROM biz_dev_kilometers  GROUP BY day  ORDER BY day ASC   LIMIT 0, 1 '
CaseMessage=Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'fpiddb.biz_dev_kilometers.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

要是能过滤，是不是这个问题也能解决？

wendal

1楼•2936天前

能过滤的前提是预知有哪些列...

走自定义SQL吧

Record re = dao.execute(Sqls.fetchRecord("select count(age),xxx from yyy $cnd").setVar("cnd", Cnd.NEW().groupBy("day").asc("day"))).getObject(Record.class);

qq_16dd5808 2楼•2936天前

嗯，我想的不周到。一直觉得select后面肯定跟group by 的列。
目前我也是走的自定义sql

String s = "select day from biz_dev_kilometers GROUP BY day order by day limit 1";
        Sql sql = Sqls.fetchTimestamp(s);
        Date d = dao.execute(sql).getObject(Date.class);
        logger.debug("{}", TimeKit.format("yyyyMMdd", d));

请先登陆