Issue 1:
Sharding proxy version 5.1.0

Using Python to import data, an error is reported when it reaches one million:

Pymysql is used

OperationalError: (1997, 'Runtime exception: [Sequence ID of MySQL command packet must be `0`.]')

Props configuration information:

proxy-frontend-executor-size: 0
proxy-frontend-flush-threshold: 128
allow.range.query.with.inline.sharding: true
proxy-frontend-max-connections: 0
check-duplicate-table-enabled: false
proxy-backend-query-fetch-size: -1
kernel-executor-size: 16
show-process-list-enabled: false
proxy-backend-executor-suitable: OLAP
proxy-hint-enabled: false
sql-show: true
proxy-opentracing-enabled: false
sql-federation-enabled: false
max-connections-size-per-query: 1
check-table-metadata-enabled: false

Rules configuration:

- !SHARDING
keyGenerators:
csys_build_demand_sx61_snowflake:
type: snowflake
csys_company_demand_sx61_snowflake:
type: snowflake
tables:
csys_build_demand_sx61:
actualDataNodes: ds_0.csys_build_demand_sx61
keyGenerateStrategy:
column: id
keyGeneratorName: csys_build_demand_sx61_snowflake
logicTable: csys_build_demand_sx61
csys_company_demand_sx61:
actualDataNodes: ds_0.csys_company_demand_sx61
keyGenerateStrategy:
column: id
keyGeneratorName: csys_company_demand_sx61_snowflake
logicTable: csys_company_demand_sx61

Issue 2:
TODO:

Fix BaseIT.createTables:131 exception, support keyword table name for different databases (#6912)

Fix BaseIT.createDatabases:121 exception, databases not cleaned by previous BaseIT (#6912)

Current PostgreSQL login user's password is changed by DCL test (#6943)

Remove duplicated test case (#6962)

DQL dataset select_count_tilde_concat.xml not found cause GeneralDQLIT.assertExecuteQuery failed (#7007)

PostgreSQL dedicated column missed in t_order cause GeneralDQLIT.assertExecuteQuery failed (#7010)

Print exception context for engine (#7005)

Integration test of PostgreSQL failed to drop database (#7174)

LockSegment absent of PostgreSQL parser (#7200)

Unexpected SELECT DISTINCT result (#7201)

remove unexpected error log (#7205)

assertRows failed in PostgreSQL DML integration test (#7204)

INSERT...RETURING statement failed in PostgreSQL DML integration test (#7207)

DROP ROLE/USER throws Exception for all database types (#7215)

Failure test cases of DCL for PostgreSQL (#7224)

Failure test cases of DCL for PostgreSQL 1 (#7230)

[Improve Performance] remove unnecessary clear procedure (#7254)

[Improve Performance] concurrent truncate (#7300 , #7305)

[Improve Performance] do not close thread pool for each test (#7327)

[Improve Performance] use delete instead of truncate to improve performance (#7333)

[Improve Performance] remove connection test SELECT 1 to improve performance (#7334)

[Improve Performance] concurrent insert (#7356)

add PostgreSQL default pwd (#7364)

add dataset (#7365)

add log for BatchIT (#7382)

INSERT...RETURNING test cases failed of BatchDMLIT (#7398)

Unexpected failed test cases of PostgreSQL DQL test cases (#7481)

Bug Report

Which version of ShardingSphere did you use?

master branch, 5.0.0-RC1-SNAPSHOT

Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?

ShardingSphere-JDBC

Expected behavior

Integration test using PostgreSQL instead of H2. Expect real test cases could run.

Actual behavior

BaseXyzIT @BeforeClass and @afterclass method thrown exception.

Reason analyze (If you can)

Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.

1, env.properties:

databases=PostgreSQL

postgresql.host=127.0.0.1 (suppose your PostgreSQL is on localhost)

postgresql.password=test

2, go to shardingsphere-test-suite module

3, mvn clean install

Example codes for reproduce this issue (such as a github link).

[INFO] Running org.apache.shardingsphere.dbtest.engine.dcl.GeneralDCLIT
[INFO ] 15:57:37.967 [main] o.a.s.d.e.u.IntegrateTestParameters - [INFO] ======= Test Plan =======
[INFO ] 15:57:37.979 [main] o.a.s.d.e.u.IntegrateTestParameters - [WARN] Total: 3760, Active: PostgreSQL(1664), Disabled: MySQL(416), Oracle(832), SQLServer(848)

[ERROR] Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 39.665 s <<< FAILURE! - in org.apache.shardingsphere.dbtest.engine.dcl.GeneralDC
LIT
[ERROR] org.apache.shardingsphere.dbtest.engine.dcl.GeneralDCLIT Time elapsed: 39.664 s <<< ERROR!
java.lang.RuntimeException:
org.postgresql.util.PSQLException: ERROR: syntax error at or near "`"
位置：15
Caused by: org.postgresql.util.PSQLException:
ERROR: syntax error at or near "`"
位置：15

[INFO] Running org.apache.shardingsphere.dbtest.engine.ddl.GeneralDDLIT
[INFO ] 15:58:16.790 [main] o.a.s.d.e.u.IntegrateTestParameters - [INFO] ======= Test Plan =======
[INFO ] 15:58:16.790 [main] o.a.s.d.e.u.IntegrateTestParameters - [INFO] Total: 0, Active: 0, Disabled: 0

[INFO] Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.014 s - in org.apache.shardingsphere.dbtest.engine.ddl.GeneralDDLIT
[INFO] Running org.apache.shardingsphere.dbtest.engine.dml.AdditionalDMLIT
[INFO] Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.009 s - in org.apache.shardingsphere.dbtest.engine.dml.AdditionalDMLIT
[INFO] Running org.apache.shardingsphere.dbtest.engine.dml.BatchDMLIT
[INFO ] 15:58:16.816 [main] o.a.s.d.e.u.IntegrateTestParameters - [INFO] ======= Test Plan =======
[INFO ] 15:58:16.816 [main] o.a.s.d.e.u.IntegrateTestParameters - [WARN] Total: 832, Active: PostgreSQL(144), Disabled: H2(152), MySQL(240), Oracle(160)
, SQLServer(136)

[ERROR] Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 40.144 s <<< FAILURE! - in org.apache.shardingsphere.dbtest.engine.dml.BatchDMLI
T
[ERROR] org.apache.shardingsphere.dbtest.engine.dml.BatchDMLIT Time elapsed: 40.144 s <<< ERROR!
java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: database "db_0" already exists
Caused by: org.postgresql.util.PSQLException: ERROR: database "db_0" already exists

[INFO] Running org.apache.shardingsphere.dbtest.engine.dml.GeneralDMLIT
[INFO ] 15:58:57.066 [main] o.a.s.d.e.u.IntegrateTestParameters - [INFO] ======= Test Plan =======
[INFO ] 15:58:57.066 [main] o.a.s.d.e.u.IntegrateTestParameters - [WARN] Total: 1936, Active: PostgreSQL(336), Disabled: H2(352), MySQL(560), Oracle(368
), SQLServer(320)

[ERROR] Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 40.279 s <<< FAILURE! - in org.apache.shardingsphere.dbtest.engine.dml.GeneralDM
LIT
[ERROR] org.apache.shardingsphere.dbtest.engine.dml.GeneralDMLIT Time elapsed: 40.279 s <<< ERROR!
java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: database "db_0" already exists
Caused by: org.postgresql.util.PSQLException: ERROR: database "db_0" already exists

[INFO] Running org.apache.shardingsphere.dbtest.engine.dql.AdditionalDQLIT
[INFO] Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 s - in org.apache.shardingsphere.dbtest.engine.dql.AdditionalDQLIT
[INFO] Running org.apache.shardingsphere.dbtest.engine.dql.GeneralDQLIT
[INFO ] 15:59:37.378 [main] o.a.s.d.e.u.IntegrateTestParameters - [INFO] ======= Test Plan =======
[INFO ] 15:59:37.378 [main] o.a.s.d.e.u.IntegrateTestParameters - [WARN] Total: 6752, Active: PostgreSQL(1328), Disabled: H2(1312), MySQL(1664), Oracle(
1232), SQLServer(1216)

[ERROR] Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 42.819 s <<< FAILURE! - in org.apache.shardingsphere.dbtest.engine.dql.GeneralDQ
LIT
[ERROR] org.apache.shardingsphere.dbtest.engine.dql.GeneralDQLIT Time elapsed: 42.819 s <<< ERROR!
java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: database "db_0" already exists
Caused by: org.postgresql.util.PSQLException: ERROR: database "db_0" already exists

[INFO]
[INFO] Results:
[INFO]
[ERROR] Errors:
[ERROR] GeneralDCLIT>BaseDCLIT.initDatabasesAndTables:100->BaseIT.createDatabasesAndTables:109->BaseIT.createTables:131 ? Runtime
[ERROR] BatchDMLIT>BatchIT.initDatabasesAndTables:85->BaseIT.createDatabasesAndTables:107->BaseIT.createDatabases:121 ? Runtime
[ERROR] GeneralDMLIT>BaseDMLIT.initDatabasesAndTables:68->BaseIT.createDatabasesAndTables:107->BaseIT.createDatabases:121 ? Runtime
[ERROR] GeneralDQLIT>BaseDQLIT.insertData:68->BaseIT.createDatabasesAndTables:107->BaseIT.createDatabases:121 ? Runtime
[INFO]
[ERROR] Tests run: 4, Failures: 0, Errors: 4, Skipped: 0