MyBatis executes the query statement, you can query the data in the Plsql, but you cannot query in the program

Today with MyBatis query statements, the console output of the SQL statement can be executed in Plsql, but the query is no data.
The original query statement is as follows: (for privacy, the sensitive package name to the mosaic.) ）

This SQL can be executed correctly in Plsql, but the data cannot be queried.

The workaround is to replace "#" in the query condition with "$".

The reasons are as follows: MyBatis See #{} will think you are assigning a value to a variable in SQL, just as you would assign a question mark in JDBC programming (automatically before and after a single quotation mark) that means that the string you passed in does not serve as multiple values, but as a large string, so the query is not a value)

When MyBatis sees ${}, it is replaced directly with the value of the variable without any processing.

MyBatis executes the query statement, you can query the data in the Plsql, but you cannot query in the program