mysql使用UnionAll和PartitionBy,会报错 返回
C#论坛
老数据
1890
悬赏:0 飞吻
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
在文档中这样写道:

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