Hi, everyone, I found some issues with Sharding-Proxy when using postgres and collected as follows:
First, I prepared an environment like: https://github.com/apache/incubator-shardingsphere/issues/3419, my postgres version is 12.0, and use the latest Proxy source code. (commit 962a9656 zhaojun <[email protected]> on 2019-11-17 at 17:18) The issues are: 1) Cannot find JDBC type '2003' in PostgreSQL column type (Existing) https://github.com/apache/incubator-shardingsphere/issues/3104 2) receiveErrorResponse for postgres client (new) When use JDBC client to insert record with Proxy, whether use Statement or PreparedStatement, the Proxy can insert successful, but the JDBC client receives error response. Error log of Statement: org.postgresql.util.PSQLException: at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:303) at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:289) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:266) at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:246) Error log of PreparedStatement: org.postgresql.util.PSQLException: at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168) at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:135) 3) when update a record, response of num is 0 (new) When use JDBC client to update record with Proxy, it will success, but the result num is 0; Otherwise, if excute update SQL without Proxy, the result num is 1; I don't know if these issues need to be dealt with together? 获取 Outlook for Android<https://aka.ms/ghei36>
