mysql使用UnionAll和PartitionBy,会报错 返回

反馈
64

Table 'expandoobject' doesn't exist

但是运行生成的sql,会报group by的错误

1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'unionTable.Title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by


在文档中这样写道:

image.png

并且即使不写Take(1),也会默认生成 LIMIT 0,1

热忱回答0

版块

学习文档

最新会员

发布达人

回贴达人