为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8
【操作系统】:Linux、x86
【CPU】:
【问题描述】*:执行查询sql时,报错:字符串截断
执行sql:
select xuhao as xuhao, id as id, name as name from d_dict_dim_test where ('深圳市' = 'null' or name = '深圳市')
报错信息:
java.sql.SQLException: 字符串截断
at dm.jdbc.dbaccess.DBError.throwSQLException(DBError.java:44)
at dm.jdbc.dbaccess.Request_Response.resp_checkErr(Request_Response.java:2474)
at dm.jdbc.dbaccess.Request_Response.resp_execute(Request_Response.java:1073)
at dm.jdbc.dbaccess.DmdbCSI.getDescAndResultSet(DmdbCSI.java:678)
at dm.jdbc.dbaccess.DmdbCSI.executePrepared(DmdbCSI.java:558)
at dm.jdbc.dbaccess.DmdbCSI.executePrepared(DmdbCSI.java:536)
at dm.jdbc.driver.DmdbPreparedStatement_bs.preparedExceute(DmdbPreparedStatement_bs.java:2366)
at dm.jdbc.driver.DmdbPreparedStatement_bs.executeInner(DmdbPreparedStatement_bs.java:2489)
at dm.jdbc.driver.DmdbPreparedStatement_bs.execute(DmdbPreparedStatement_bs.java:1632)
at dm.jdbc.driver.DmdbPreparedStatement.do_execute(DmdbPreparedStatement.java:1929)
at dm.jdbc.filter.FilterChain.PreparedStatement_execute(FilterChain.java:1446)
at dm.jdbc.driver.DmdbPreparedStatement.execute(DmdbPreparedStatement.java:663)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
at org.apache.camel.component.jdbc.JdbcProducer.doCreateAndExecuteSqlStatementWithHeaders(JdbcProducer.java:362)
select length(xuhao) ,lengthb(xuhao), id as id, length(name),lengthb(name) from d_dict_dim_test where ('深圳市' = 'null' or name = '深圳市')
先查一下length和lengthb的结果
建议表字段精度扩大一些看一下。