(Resend) Issues for Proxy with Postgres

[raigor_dev <ra...@163.com>]

Sorry, due to the reason of the mailbox, the content of the previously mail is lost, now resend. 


========================


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 <zh...@126.com> 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;




Maybe Postgres features need to be fully tested and imporved?  


Thank you!




| |
raigor_dev
|
|
raigor_dev@163.com
|
签名由网易邮箱大师定制