MySQL 5.7 Bug Unknown type '14 in column 0 of 1 in binaryencoded result set

数据运维 2023-08-15 向阳逐梦手机阅读

一、问题背景

环境：

MySQL：Percona Server for MySQL 5.7.19
JDBC：mysql connector-J 5.1.45

Java代码通过JDBC执行SQL报错如下：

java.sql.SQLException: Unknown type '14 in column 0 of 1 in binary-encoded result set. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861) at com.mysql.jdbc.MysqlIO.extractNativeEncodedColumn(MysqlIO.java:4558) at com.mysql.jdbc.MysqlIO.unpackBinaryResultSetRow(MysqlIO.java:4472) at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:2045) at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:3400) at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:470) at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:3112) at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2341) at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1368) at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:783) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966) at JDBCClient.main(JDBCClient.java:39)