You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
SELECT ID, CTMID, MISID, VALIDDATE1, VALIDDATE2, PURCHASENUM, AVAILABLENUMS, UPDATER, UPDATEDATE, CTRID, PDTNAME, CTRPDTID, AREACODE FROM S_AVAILABLEINVITATIONSNUM WHERE CTMID = ? AND VALIDDATE2 >= TRUNC(SYSDATE) AND VALIDDATE1 <= TRUNC(SYSDATE)
期望的结果:
SELECT ID, CTMID, MISID, VALIDDATE1, VALIDDATE2, PURCHASENUM, AVAILABLENUMS, UPDATER, UPDATEDATE, CTRID, PDTNAME, CTRPDTID, AREACODE FROM S_AVAILABLEINVITATIONSNUM WHERE CTMID = ? AND VALIDDATE2 >= TRUNC(SYSDATE) AND VALIDDATE1 <= TRUNC(SYSDATE) order by Id desc
异常模板
使用环境
SQL 解析错误
分页参数
原 SQL
期望的结果:
完整异常信息
其他类型的错误
无
功能建议
开源作者,您好,在不需要分页的时候设置pageSize = 0 & pageSizeZero=true时,为什么order by会失效哦。
详细说明,尽可能提供(伪)代码示例。
The text was updated successfully, but these errors were encountered: