Description

ostrichManX

opened on Feb 6, 2024

Issue body actions

Description

apijson写法：

"[]": {
    "count":3,
    'T_EVENT_MAIN': {
        "@schema": "ZHSQ",
        "EVENT_ID{}@": {
            "from": "WF_HI_TASK",
            "WF_HI_TASK": {
                "@schema": "CDA_FLOW",
                "@column": "BUSINESS_KEY",
            }
        },
    },
},

这是根据官网的模板去掉多余参数，写的子查询apijson语句，mysql的查询语句只有简单的子查询语句，但是oracle的查询语句也会强制加上分页语句，这样就会导致id无法获取到子查询内部对应的字段，进而报错，无法使用。

我想问一下，这个怎么处理，是否存在开关或者配置，关闭子查询中的默认分页操作？

Activity

1. ostrichManX

   changed the title [-][ORACLE] [/-] [+][ORACLE] 子查询内部默认分页，导致提示Error Msg = ORA-00913: 值过多的报错[/+] on Feb 6, 2024
2. ostrichManX

   changed the title [-][ORACLE] 子查询内部默认分页，导致提示Error Msg = ORA-00913: 值过多的报错[/-] [+][ORACLE] 子查询内部默认添加分页语句，导致in函数无法实现，提示Error Msg = ORA-00913: 值过多的报错[/+] on Feb 6, 2024
3. TommyLemon

   added

   Oracle

   on Feb 6, 2024
4. TommyLemon commented on Feb 6, 2024

   

   TommyLemon

   on Feb 6, 2024

   Member

   More actions

   像 getLimitString 一样在 getOraclePageSql 前拦截处理，不拼接分页 SQL 片段

   		if (count <= 0 || RequestMethod.isHeadMethod(getMethod(), true)) { // TODO HEAD 真的不需要 LIMIT ？
   			return sql;
   		}

   https://github.com/Tencent/APIJSON/blob/master/APIJSONORM/src/main/java/apijson/orm/AbstractSQLConfig.java#L4546-L4549

   https://github.com/Tencent/APIJSON/blob/master/APIJSONORM/src/main/java/apijson/orm/AbstractSQLConfig.java#L4584-L4595

   https://github.com/Tencent/APIJSON/blob/master/APIJSONORM/src/main/java/apijson/orm/AbstractSQLConfig.java#L2634-L2636
5. TommyLemon

   added

   Bug 漏洞

   on Feb 6, 2024
6. ostrichManX commented on Feb 7, 2024

   

   ostrichManX

   on Feb 7, 2024

   ContributorAuthor

   More actions

   问题解决，代码已提交
   #684

   Reacted by TommyLemon

   Reacted by TommyLemon
7. TommyLemon

   closed this as completedon Feb 7, 2024

Issue actions