FreeSql oracle 自动分表，查询报错

oracle 自动分表，查询报错

Open sukney opened this issue 2 years ago • 7 comments

freesql 版本3.2.610 生成如下语句，

SELECT t.* FROM (SELECT t.* FROM (SELECT * from (SELECT a."ID" as1, a."CREATED_BY" as2, a."CREATED_BY_NAME" as3, a."CREATED_TIME" as4, a."REAL_NAME" as5, a."IP" as6, a."BROWSER" as7, a."OS" as8, a."DEVICE" as9, a."BROWSERINFO" as10, a."ELAPSED_MILLISECONDS" as11, a."STATUS" as12, a."MESSAGE" as13, a."RESULT" as14 FROM "SYS_L_LOG_202204" a ORDER BY a."ID" DESC) t WHERE ROWNUM < 21) ftb

UNION ALL

SELECT * from (SELECT a."ID" as1, a."CREATED_BY" as2, a."CREATED_BY_NAME" as3, a."CREATED_TIME" as4, a."REAL_NAME" as5, a."IP" as6, a."BROWSER" as7, a."OS" as8, a."DEVICE" as9, a."BROWSERINFO" as10, a."ELAPSED_MILLISECONDS" as11, a."STATUS" as12, a."MESSAGE" as13, a."RESULT" as14 FROM "SYS_L_LOG_202201" a ORDER BY a."ID" DESC) t WHERE ROWNUM < 21) ftb

报如下错