This is an automated email from the ASF dual-hosted git repository.
zhaojinchao pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new 5d6d208f4e0 Fix shadow integration tests use PostgreSQL in cluster
mode (#20715)
5d6d208f4e0 is described below
commit 5d6d208f4e09c0cb433394e20846187f96f4baf5
Author: gin <[email protected]>
AuthorDate: Fri Sep 2 10:13:55 2022 +0800
Fix shadow integration tests use PostgreSQL in cluster mode (#20715)
* Fix dml it of shadow
* Update it yaml
---
.github/workflows/it.yml | 4 ----
.../src/test/resources/cases/dml/dml-integration-test-cases.xml | 4 ++--
2 files changed, 2 insertions(+), 6 deletions(-)
diff --git a/.github/workflows/it.yml b/.github/workflows/it.yml
index e6324aad52c..40fc64f03e9 100644
--- a/.github/workflows/it.yml
+++ b/.github/workflows/it.yml
@@ -145,10 +145,6 @@ jobs:
exclude:
- adapter: jdbc
mode: Cluster
- - adapter: proxy
- mode: Cluster
- database: PostgreSQL
- scenario: shadow
steps:
- uses: actions/checkout@v2
- name: Cache Maven Repos
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dml-integration-test-cases.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dml-integration-test-cases.xml
index ffcb5cebe59..6eef1391eea 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dml-integration-test-cases.xml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dml/dml-integration-test-cases.xml
@@ -266,13 +266,13 @@
expected-data-file="shadow_insert_order_value.xml" />
</test-case>
- <test-case sql="UPDATE t_shadow SET order_name = ?, type_char = ?,
type_boolean = ?, type_smallint = ?, type_decimal = ?, type_enum = ?::season
+ <test-case sql="UPDATE t_shadow SET order_name = ?, type_char = ?,
type_boolean = ?, type_smallint = ?, type_decimal = ?, type_enum = CAST(? AS
season)
WHERE user_id = ? and order_id in (?, ?)"
db-types="PostgreSQL" scenario-types="shadow">
<assertion parameters="pro_order_update:String, F:char, false:boolean,
60:smallint, 120.00:decimal, spring:enum#season, 1:int, 1:long, 2:long"
expected-data-file="pro_update_order_by_user_id.xml" />
</test-case>
- <test-case sql="UPDATE t_shadow SET order_name = ?, type_char = ?,
type_boolean = ?, type_smallint = ?, type_decimal = ?, type_enum = ?::season
+ <test-case sql="UPDATE t_shadow SET order_name = ?, type_char = ?,
type_boolean = ?, type_smallint = ?, type_decimal = ?, type_enum = CAST(? AS
season)
WHERE user_id = ? and order_id in (?, ?)"
db-types="PostgreSQL" scenario-types="shadow">
<assertion parameters="shadow_order_update:String, F:char,
false:boolean, 60:smallint, 120.00:decimal, spring:enum#season, 0:int, 1:long,
2:long"
expected-data-file="shadow_update_order_by_user_id.xml" />
