<set>, <where> and <choos> elements are thread-safe.
Query using functions with colon : generate error at parser.
select id, name from Roles where dt = to_date(:dt,‘YYYY-MM-DD HH24:MI:SS’) and name = :name and status = :status
'YYYY-MM-DD HH24:MI:SS' error was fixed at parser.
Before:
<statements .. xmlns:xi="http://www.w3.org/2001/XInclude" <xi:include href="/my-other-sql-file.xml" /> ...
Now:
<statements .. <include href="/my-other-sql-file.xml" /> ...
<where> <if test="name != null"> AND name = #{name} </if> ...