Is it possible that the parameter is not recognized because of the long query line? ORA-00937: not a single-group group function

[jejecrunch]

I ran the following query and got the error ORA-00937: not a single-group group function in mybatis, but not in toad. I don't know how it works or why I get this error only in mybatis.

SELECT CASE WHEN GROUPING(D(#{parameter}, E, F)) + GROUPING(B) = 2 THEN 'TOTAL' ELSE THEN NAME, ...
FROM CDB
WHERE ...
GROUP BY D(#{parameter}, E, F), B, ...

※ ... means many columns.

When I run it, the query line count seems to be between 100 and 200 lines, and I was wondering if this could be caused by a long query.

[harawata]

Hello @jejecrunch ,

I get this error only in mybatis.

This seems highly unlikely.
Have you tried executing the same query using pure JDBC code (with java.sql.PreparedStatement)?
Tools like sqlplus or SQL Developer do not use JDBC API, so you have to write pure JDBC code when comparing behavior in MyBatis.

[jejecrunch]

Hello @harawata ,
I tried what you said, and it works fine with pure JDBC...
In my prediction, if you have to use a custom Oracle function in the GROUP BY clause and put in the parameter ${}, if the number of lines in your query gets too long, it doesn't recognize that parameter and gives you an error saying that it is an incorrect GROUP BY clause.

[harawata]

@jejecrunch ,

There is no ${} in your explanation.
Please provide a small executable demo project so that we can reproduce the issue on our end.
And, please make it as small as possible.
Here are some project templates and examples : https://github.com/harawata/mybatis-issues
Thank you!