EmiyaXzero commented on issue #25763:
URL:
https://github.com/apache/shardingsphere/issues/25763#issuecomment-1564407361
> Hi @EmiyaXzero , we've resolved some similar problems before. But i'm not
sure, could you supply the full error message and stack trace? We'll verify it.
the e.getMessage() is `no viable alternative at input 'system' at line 1,
position 59, near [@16,59:64='system',<680>,1:59]`
and the e.getStackTrace()[0].toString()
`org.apache.shardingsphere.sql.parser.core.database.parser.SQLParserErrorListener.syntaxError(SQLParserErrorListener.java:47)`
and the e.getStackTrace()[1].toString()
`org.antlr.v4.runtime.ProxyErrorListener.syntaxError(ProxyErrorListener.java:41)`
the sql is `SELECT count(0) FROM vtx_project WHERE state IN (1, 2) AND
system = 'busihill' AND system_id = ? `\
ddl sql is
CREATE TABLE `vtx_project` (
`SYSTEM_ID` decimal(20,0) DEFAULT NULL ,
`SYSTEM` varchar(20) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=30000003062 DEFAULT CHARSET=utf8;
mapper.xml is
<select id="qryProjectListByCondition" parameterType="com.vo.ProjectQueryVo"
resultType="com.vo.VtxProject">
select <include refid="Base_Column_List"></include>
from vtx_project
<where>
state in (1,2) and system = 'systemhill'
<if test="sysId!=null">
and system_id = #{sysId}
</if>
</where>
</select>
--
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]
