还是达梦数据库问题 返回
使用达梦数据库时,当我使用分页查询语句时,类似下方截图

sql语句会转成如下格式
SELECT * FROM (SELECT *,ROW_NUMBER() OVER(ORDER BY Id Desc) AS RowIndex FROM (SELECT "MonitorID","DateTime","MaxValue","MaxTime","MinValue","MinTime","MeanValue","StaticsState","StartTime","EndTime","TenantId","CreateTime","UpdateTime","CreateUserId","CreateUserName","UpdateUserId","UpdateUserName","IsDelete","Id" FROM "Statistics_Min_Drift_20251013" WHERE ( "TenantId" = :TenantId0UnionAll1 ) AND ("MonitorID" IN (1977996393784152064)) AND (( "StartTime" >= '2025-10-15 09:00:00' ) AND ( "StartTime" < '2025-10-15 09:30:00' )) AND "DateTime">=:spBeginTimeUnionAll1 AND "DateTime"<= :spEndTimeUnionAll1 ) unionTable ) T WHERE RowIndex BETWEEN 1 AND 20
此处的Id,会被达梦默认转成大写ID,导致与数据库中不匹配,报如下错误


sqlsugarCore:5.1.4.160
sqlsugarCore.DM:8.8.2
热忱回答(1)
-
matt VIP0
1个月前可以关闭了,我的问题,是admin.net框架下的OrderBuilder方法里加个达梦数据库判断加“”即可
0 回复