EmiyaXzero opened a new issue, #25763:
URL: https://github.com/apache/shardingsphere/issues/25763
ShardingSphere version:
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId>
<version>5.2.1</version>
</dependency>
My mybatis mapper looks like this,The mysql keyword system was used when the
table was designed for historical reasons.
When I use system in my where statement, the preparing statement exception
will be reported. I can only replace system with 'system'. I know that this
problem is caused by sql non-standard. However, without using shardingjdbc this
problem will not occur. Will this situation be compatible in the future?
select <include refid="Base_Column_List"></include>
from system_project
<where>
state in (1,2) and system = 'oldsystem'
<if test="projectName!=null and projectName!=''">
and project_name like concat('%', #{projectName}, '%')
</if>
<if test="projectType!=null and projectType!=''">
and project_type = #{projectType}
</if>
<if test="sysId!=null">
and system_id = #{sysId}
</if>
</where>
order by CREATE_TIME desc
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail:
[email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
