This is an automated email from the ASF dual-hosted git repository.
sunnianjun 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 1497b20e1d5 Add more integration test case for encrypt dml statement
(#23481)
1497b20e1d5 is described below
commit 1497b20e1d5354621922056cd5d263bfbae5c75e
Author: Zhengqiang Duan <[email protected]>
AuthorDate: Tue Jan 10 23:06:39 2023 +0800
Add more integration test case for encrypt dml statement (#23481)
* Add more integration test case for encrypt dml statement
* fix BatchE2EIT error
---
.../shardingsphere/test/e2e/engine/BatchE2EIT.java | 4 ++-
.../test/e2e/engine/dal/BaseDALE2EIT.java | 4 ---
.../test/e2e/engine/dml/AdditionalDMLE2EIT.java | 28 ---------------
.../test/e2e/engine/dml/BaseDMLE2EIT.java | 4 ++-
.../test/e2e/engine/dml/BatchDMLE2EIT.java | 12 -------
.../test/e2e/engine/dml/GeneralDMLE2EIT.java | 12 -------
.../encrypt/batch_insert_into_user_table.xml | 41 ++++++++++++++++------
.../dml/dataset/encrypt/delete_user_table.xml | 35 ++++++++++++++----
.../dml/dataset/encrypt/update_user_table.xml | 37 ++++++++++++++-----
.../dataset/encrypt/update_user_table_by_pwd.xml | 37 ++++++++++++++-----
.../cases/dml/dml-integration-test-cases.xml | 36 +++++++++----------
.../env/scenario/encrypt/data/actual/dataset.xml | 40 ++++++++++-----------
12 files changed, 161 insertions(+), 129 deletions(-)
diff --git
a/test/e2e/suite/src/test/java/org/apache/shardingsphere/test/e2e/engine/BatchE2EIT.java
b/test/e2e/suite/src/test/java/org/apache/shardingsphere/test/e2e/engine/BatchE2EIT.java
index f08f2675a81..99f7751c596 100644
---
a/test/e2e/suite/src/test/java/org/apache/shardingsphere/test/e2e/engine/BatchE2EIT.java
+++
b/test/e2e/suite/src/test/java/org/apache/shardingsphere/test/e2e/engine/BatchE2EIT.java
@@ -25,9 +25,9 @@ import
org.apache.shardingsphere.test.e2e.cases.dataset.DataSetLoader;
import org.apache.shardingsphere.test.e2e.cases.dataset.metadata.DataSetColumn;
import
org.apache.shardingsphere.test.e2e.cases.dataset.metadata.DataSetMetaData;
import org.apache.shardingsphere.test.e2e.cases.dataset.row.DataSetRow;
+import org.apache.shardingsphere.test.e2e.env.DataSetEnvironmentManager;
import
org.apache.shardingsphere.test.e2e.env.runtime.scenario.path.ScenarioDataPath;
import
org.apache.shardingsphere.test.e2e.env.runtime.scenario.path.ScenarioDataPath.Type;
-import org.apache.shardingsphere.test.e2e.env.DataSetEnvironmentManager;
import
org.apache.shardingsphere.test.e2e.framework.param.model.CaseTestParameter;
import org.junit.After;
import org.junit.Before;
@@ -157,6 +157,8 @@ public abstract class BatchE2EIT extends BaseE2EIT {
if (!NOT_VERIFY_FLAG.equals(each)) {
assertThat(new
SimpleDateFormat("yyyy-MM-dd").format(actualResultSet.getDate(index)),
is(each));
}
+ } else if (Types.CHAR ==
actualResultSet.getMetaData().getColumnType(index) &&
("PostgreSQL".equals(getDatabaseType().getType()) ||
"openGauss".equals(getDatabaseType().getType()))) {
+
assertThat(String.valueOf(actualResultSet.getObject(index)).trim(), is(each));
} else {
assertThat(String.valueOf(actualResultSet.getObject(index)), is(each));
}
diff --git
a/test/e2e/suite/src/test/java/org/apache/shardingsphere/test/e2e/engine/dal/BaseDALE2EIT.java
b/test/e2e/suite/src/test/java/org/apache/shardingsphere/test/e2e/engine/dal/BaseDALE2EIT.java
index eab5b1a6344..d84e869d612 100644
---
a/test/e2e/suite/src/test/java/org/apache/shardingsphere/test/e2e/engine/dal/BaseDALE2EIT.java
+++
b/test/e2e/suite/src/test/java/org/apache/shardingsphere/test/e2e/engine/dal/BaseDALE2EIT.java
@@ -56,10 +56,6 @@ public abstract class BaseDALE2EIT extends SingleE2EIT {
}
private void assertMetaData(final ResultSetMetaData actual, final
Collection<DataSetColumn> expected) throws SQLException {
- // TODO Fix shadow
- if ("shadow".equals(getScenario())) {
- return;
- }
assertThat(actual.getColumnCount(), is(expected.size()));
int index = 1;
for (DataSetColumn each : expected) {
diff --git
a/test/e2e/suite/src/test/java/org/apache/shardingsphere/test/e2e/engine/dml/AdditionalDMLE2EIT.java
b/test/e2e/suite/src/test/java/org/apache/shardingsphere/test/e2e/engine/dml/AdditionalDMLE2EIT.java
index 72a055f2c86..674508ad548 100644
---
a/test/e2e/suite/src/test/java/org/apache/shardingsphere/test/e2e/engine/dml/AdditionalDMLE2EIT.java
+++
b/test/e2e/suite/src/test/java/org/apache/shardingsphere/test/e2e/engine/dml/AdditionalDMLE2EIT.java
@@ -55,10 +55,6 @@ public final class AdditionalDMLE2EIT extends BaseDMLE2EIT {
@Test
public void executeUpdateWithAutoGeneratedKeys() throws SQLException,
ParseException {
- // TODO fix replica_query
- if ("replica_query".equals(getScenario())) {
- return;
- }
int actualUpdateCount;
try (Connection connection = getTargetDataSource().getConnection()) {
actualUpdateCount = SQLExecuteType.Literal == getSqlExecuteType()
@@ -85,10 +81,6 @@ public final class AdditionalDMLE2EIT extends BaseDMLE2EIT {
@Test
public void assertExecuteUpdateWithColumnIndexes() throws SQLException,
ParseException {
- // TODO fix replica_query
- if ("PostgreSQL".equals(getDatabaseType().getType()) ||
"replica_query".equals(getScenario())) {
- return;
- }
int actualUpdateCount;
try (Connection connection = getTargetDataSource().getConnection()) {
actualUpdateCount = SQLExecuteType.Literal == getSqlExecuteType()
? executeUpdateForStatementWithColumnIndexes(connection) :
executeUpdateForPreparedStatementWithColumnIndexes(connection);
@@ -113,10 +105,6 @@ public final class AdditionalDMLE2EIT extends BaseDMLE2EIT
{
@Test
public void assertExecuteUpdateWithColumnNames() throws SQLException,
ParseException {
- // TODO fix replica_query
- if ("PostgreSQL".equals(getDatabaseType().getType()) ||
"replica_query".equals(getScenario())) {
- return;
- }
int actualUpdateCount;
try (Connection connection = getTargetDataSource().getConnection()) {
actualUpdateCount = SQLExecuteType.Literal == getSqlExecuteType()
? executeUpdateForStatementWithColumnNames(connection) :
executeUpdateForPreparedStatementWithColumnNames(connection);
@@ -141,10 +129,6 @@ public final class AdditionalDMLE2EIT extends BaseDMLE2EIT
{
@Test
public void assertExecuteWithoutAutoGeneratedKeys() throws SQLException,
ParseException {
- // TODO fix replica_query
- if ("replica_query".equals(getScenario())) {
- return;
- }
int actualUpdateCount;
try (Connection connection = getTargetDataSource().getConnection()) {
actualUpdateCount = SQLExecuteType.Literal == getSqlExecuteType()
@@ -173,10 +157,6 @@ public final class AdditionalDMLE2EIT extends BaseDMLE2EIT
{
@Test
public void assertExecuteWithAutoGeneratedKeys() throws SQLException,
ParseException {
- // TODO fix replica_query
- if ("replica_query".equals(getScenario())) {
- return;
- }
int actualUpdateCount;
try (Connection connection = getTargetDataSource().getConnection()) {
actualUpdateCount = SQLExecuteType.Literal == getSqlExecuteType()
? executeForStatementWithAutoGeneratedKeys(connection) :
executeForPreparedStatementWithAutoGeneratedKeys(connection);
@@ -205,10 +185,6 @@ public final class AdditionalDMLE2EIT extends BaseDMLE2EIT
{
@Test
public void assertExecuteWithColumnIndexes() throws SQLException,
ParseException {
- // TODO fix replica_query
- if ("PostgreSQL".equals(getDatabaseType().getType()) ||
"replica_query".equals(getScenario())) {
- return;
- }
int actualUpdateCount;
try (Connection connection = getTargetDataSource().getConnection()) {
actualUpdateCount = SQLExecuteType.Literal == getSqlExecuteType()
? executeForStatementWithColumnIndexes(connection) :
executeForPreparedStatementWithColumnIndexes(connection);
@@ -235,10 +211,6 @@ public final class AdditionalDMLE2EIT extends BaseDMLE2EIT
{
@Test
public void assertExecuteWithColumnNames() throws SQLException,
ParseException {
- // TODO fix replica_query
- if ("PostgreSQL".equals(getDatabaseType().getType()) ||
"replica_query".equals(getScenario())) {
- return;
- }
int actualUpdateCount;
try (Connection connection = getTargetDataSource().getConnection()) {
actualUpdateCount = SQLExecuteType.Literal == getSqlExecuteType()
? executeForStatementWithColumnNames(connection) :
executeForPreparedStatementWithColumnNames(connection);
diff --git
a/test/e2e/suite/src/test/java/org/apache/shardingsphere/test/e2e/engine/dml/BaseDMLE2EIT.java
b/test/e2e/suite/src/test/java/org/apache/shardingsphere/test/e2e/engine/dml/BaseDMLE2EIT.java
index 75fe19414f0..046f5b7c944 100644
---
a/test/e2e/suite/src/test/java/org/apache/shardingsphere/test/e2e/engine/dml/BaseDMLE2EIT.java
+++
b/test/e2e/suite/src/test/java/org/apache/shardingsphere/test/e2e/engine/dml/BaseDMLE2EIT.java
@@ -23,9 +23,9 @@ import
org.apache.shardingsphere.test.e2e.cases.dataset.metadata.DataSetColumn;
import
org.apache.shardingsphere.test.e2e.cases.dataset.metadata.DataSetMetaData;
import org.apache.shardingsphere.test.e2e.cases.dataset.row.DataSetRow;
import org.apache.shardingsphere.test.e2e.engine.SingleE2EIT;
+import org.apache.shardingsphere.test.e2e.env.DataSetEnvironmentManager;
import
org.apache.shardingsphere.test.e2e.env.runtime.scenario.path.ScenarioDataPath;
import
org.apache.shardingsphere.test.e2e.env.runtime.scenario.path.ScenarioDataPath.Type;
-import org.apache.shardingsphere.test.e2e.env.DataSetEnvironmentManager;
import
org.apache.shardingsphere.test.e2e.framework.database.DatabaseAssertionMetaData;
import
org.apache.shardingsphere.test.e2e.framework.database.DatabaseAssertionMetaDataFactory;
import
org.apache.shardingsphere.test.e2e.framework.param.model.AssertionTestParameter;
@@ -123,6 +123,8 @@ public abstract class BaseDMLE2EIT extends SingleE2EIT {
if (!NOT_VERIFY_FLAG.equals(expected)) {
assertThat(new
SimpleDateFormat("yyyy-MM-dd").format(actual.getDate(columnIndex)),
is(expected));
}
+ } else if (Types.CHAR ==
actual.getMetaData().getColumnType(columnIndex) &&
("PostgreSQL".equals(getDatabaseType().getType()) ||
"openGauss".equals(getDatabaseType().getType()))) {
+ assertThat(String.valueOf(actual.getObject(columnIndex)).trim(),
is(expected));
} else {
assertThat(String.valueOf(actual.getObject(columnIndex)),
is(expected));
}
diff --git
a/test/e2e/suite/src/test/java/org/apache/shardingsphere/test/e2e/engine/dml/BatchDMLE2EIT.java
b/test/e2e/suite/src/test/java/org/apache/shardingsphere/test/e2e/engine/dml/BatchDMLE2EIT.java
index 020fd738001..f40ef245a4a 100644
---
a/test/e2e/suite/src/test/java/org/apache/shardingsphere/test/e2e/engine/dml/BatchDMLE2EIT.java
+++
b/test/e2e/suite/src/test/java/org/apache/shardingsphere/test/e2e/engine/dml/BatchDMLE2EIT.java
@@ -52,12 +52,6 @@ public final class BatchDMLE2EIT extends BatchE2EIT {
@Test
public void assertExecuteBatch() throws SQLException, ParseException {
- switch (getScenario()) {
- case "replica_query":
- case "encrypt":
- return;
- default:
- }
int[] actualUpdateCounts;
try (Connection connection = getTargetDataSource().getConnection()) {
actualUpdateCounts = executeBatchForPreparedStatement(connection);
@@ -83,12 +77,6 @@ public final class BatchDMLE2EIT extends BatchE2EIT {
@Test
public void assertClearBatch() throws SQLException, ParseException {
- switch (getScenario()) {
- case "replica_query":
- case "encrypt":
- return;
- default:
- }
try (
Connection connection = getTargetDataSource().getConnection();
PreparedStatement preparedStatement =
connection.prepareStatement(getItCase().getSql())) {
diff --git
a/test/e2e/suite/src/test/java/org/apache/shardingsphere/test/e2e/engine/dml/GeneralDMLE2EIT.java
b/test/e2e/suite/src/test/java/org/apache/shardingsphere/test/e2e/engine/dml/GeneralDMLE2EIT.java
index 10adfb17a26..fc821071359 100644
---
a/test/e2e/suite/src/test/java/org/apache/shardingsphere/test/e2e/engine/dml/GeneralDMLE2EIT.java
+++
b/test/e2e/suite/src/test/java/org/apache/shardingsphere/test/e2e/engine/dml/GeneralDMLE2EIT.java
@@ -50,12 +50,6 @@ public final class GeneralDMLE2EIT extends BaseDMLE2EIT {
@Test
public void assertExecuteUpdate() throws SQLException, ParseException {
- switch (getScenario()) {
- case "replica_query":
- case "encrypt":
- return;
- default:
- }
int actualUpdateCount;
try (Connection connection = getTargetDataSource().getConnection()) {
actualUpdateCount = SQLExecuteType.Literal == getSqlExecuteType()
? executeUpdateForStatement(connection) :
executeUpdateForPreparedStatement(connection);
@@ -80,12 +74,6 @@ public final class GeneralDMLE2EIT extends BaseDMLE2EIT {
@Test
public void assertExecute() throws SQLException, ParseException {
- switch (getScenario()) {
- case "replica_query":
- case "encrypt":
- return;
- default:
- }
int actualUpdateCount;
try (Connection connection = getTargetDataSource().getConnection()) {
actualUpdateCount = SQLExecuteType.Literal == getSqlExecuteType()
? executeForStatement(connection) : executeForPreparedStatement(connection);
diff --git
a/test/e2e/suite/src/test/resources/cases/dml/dataset/encrypt/batch_insert_into_user_table.xml
b/test/e2e/suite/src/test/resources/cases/dml/dataset/encrypt/batch_insert_into_user_table.xml
index a9459390396..d1aef450530 100644
---
a/test/e2e/suite/src/test/resources/cases/dml/dataset/encrypt/batch_insert_into_user_table.xml
+++
b/test/e2e/suite/src/test/resources/cases/dml/dataset/encrypt/batch_insert_into_user_table.xml
@@ -18,15 +18,36 @@
<dataset update-count="2">
<metadata data-nodes="encrypt.t_user">
<column name="user_id" type="numeric" />
- <column name="address_id" type="numeric" />
- <column name="pwd_plain" type="varchar" />
- <column name="pwd_cipher" type="varchar" />
- <column name="status" type="varchar" />
+ <column name="user_name_cipher" type="varchar" />
+ <column name="user_name_like" type="varchar" />
+ <column name="user_name_plain" type="varchar" />
+ <column name="password_cipher" type="varchar" />
+ <column name="email_cipher" type="varchar" />
+ <column name="telephone_cipher" type="varchar" />
+ <column name="telephone_like" type="varchar" />
+ <column name="telephone_plain" type="varchar" />
+ <column name="creation_date" type="datetime" />
</metadata>
- <row data-node="encrypt.t_user" values="10, 10000, null,
yK+tn8E43EyCEgbqNOrJ4w==, init" />
- <row data-node="encrypt.t_user" values="11, 11000, null,
CIbxTwI742pGwxb18lQLkQ==, init" />
- <row data-node="encrypt.t_user" values="12, 12000, null,
VCHpNlwod9AiuS1V+7DSLw==, init" />
- <row data-node="encrypt.t_user" values="13, 13000, null,
8uxRFhW4c2rtSOoesudk/A==, init" />
- <row data-node="encrypt.t_user" values="100, 100000, a100,
H3tH4hBbXm/KoiEXezVLjA==, init" />
- <row data-node="encrypt.t_user" values="101, 101000, b101,
6HiMmKtpbbDtDNUBICWu8g==, init" />
+ <row data-node="encrypt.t_user" values="10, sVq8Lmm+j6bZE5EKSilJEQ==,
yi`mht`m, zhangsan, aQol0b6th65d0aXe+zFPsQ==,
WM0fHOH91JNWnHTkiqBdyNmzk4uJ7CCz4mB1va9Ya1M=, kLjLJIMnfyHT2nA+viaoaQ==,
01454589811, 12345678900, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="11, fQ7IzBxKVuNHtUF6h6WSBg==,
mhth, lisi, wuhmEKgdgrWQYt+Ev0hgGA==, svATu3uWv9KfiloWJeWx3A==,
0kDFxndQdzauFwL/wyCsNQ==, 01454589810, 12345678901, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="12, AQRWSlufQPog/b64YRhu6Q==,
x`mhxt, wangwu, x7A+2jq9B6DSOSFtSOibdA==,
nHJv9e6NiClIuGHOjHLvCAq2ZLhWcqfQ8/EQnIqMx+g=, a/SzSJLapt5iBXvF2c9ycw==,
01454589811, 12345678902, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="13, 5NqS4YvpT+mHBFqZOZ3QDA==,
yi`pmht, zhaoliu, zi6b4xYRjjV+bBk2R4wB+w==,
MLBZczLjriUXvg3aM5QPTxMJbLjNh8yeNrSNBek/VTw=, b6VVhG+F6ujG8IMUZJAIFg==,
01454589814, 12345678903, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="14, qeIY9od3u1KwhjihzLQUTQ==,
yitph, zhuqi, 51UmlLAC+tUvdOAj8CjWfQ==, JCmeNdPyrKO5BW5zvhAA+g==,
f995xinpZdKMVU5J5/yv3w==, 01454589815, 12345678904, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="15, VbNUtguwtpeGhHGnPJ3aXg==,
mha`, liba, +3/5CVbqoKhg3sqznKTFFQ==, T+X+e3Q3+ZNIXXmg/80uxg==,
GETj+S6DrO042E7NuBXLBQ==, 01454589814, 12345678905, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="16, U0/Ao/w1u7L5avR3fAH2Og==,
x`mhiht, wangjiu, jFfFMYxv02DjaFRuAoCDGw==,
RNW/KRq5HeL2YTfAdXSyARMJbLjNh8yeNrSNBek/VTw=, +lbvjJwO7VO4HUKc0Mw0NA==,
01454589815, 12345678906, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="17, zb1sgBigoMi7JPSoY4bAVw==,
yite`, zhuda, VFIjocgjujJCJc6waWXqJA==, 1vF/ET3nBxt7T7vVfAndZQ==,
wFvs5BH6OikgveBeTEBwsQ==, 01454589818, 12345678907, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="18, rJzNIrFEnx296kW+N1YmMw==,
ttmdq, suner, LaODSKGyR7vZ1IvmBOe9vA==, 5u4GIQkJsWRmnJHWaHNSjg==,
uwqm2O1Lv2tNTraJX1ym7Q==, 01454589819, 12345678908, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="19, qHwpQ9kteL8VX6iTUhNdbQ==,
yiptt`m, zhousan, MyOShk4kjRnds7CZfU5NCw==,
HmYCo7QBfJ2E0EvaGHBCOBMJbLjNh8yeNrSNBek/VTw=, YLNQuuUPMGA21nhKWPzzsg==,
01454589818, 12345678909, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="20, qCCmvf7OWRxbVbtLb0az1g==, upl,
tom, fzdTMkzpBvgNYmKSQAp8Fg==, gOoP4Mf0P4ISOJp6A4sRmg==,
l4xa4HwOfs/jusoJon9Wzw==, 01454589801, 12345678910, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="21, IYJ1COaRQ0gSjWMC/UAeMg==,
lpad, kobe, 1uEDMeYh2jstbOf6kx/cqw==, tikMAFiQ37u2VgWqUT38Eg==,
rGpr30UXfczXjCjdvPN+BA==, 01454589800, 12345678911, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="22, 7wvZZ7NVHgk6m1vB/sTC1Q==,
idqqx, jerry, OirN3gvz9uBnrq88nfa1wQ==, T7K/Uz1O2m+3xvB0+c4nGQ==,
7+fCU+VbQZKgLJXZPTTegA==, 01454589801, 12345678912, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="23, SbVQWl8JbnxflCfGJ7KZdA==,
i`ldt, james, hWVVYdkdTUTgm08haeq+tw==, Uk3ju6GteCD1qEHns5ZhKA==,
DpnV86FZefwBRmIAVBh2gg==, 01454589804, 12345678913, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="24, fx7OfSAYqVpjNa7LoKhXvw==,
x`ed, wade, N2W9ijAXNkBxhkvJiIwp0A==, lAAGItVLmb1H69++1MDrIA==,
QrE62wAb8B+2cEPcs4Lm1Q==, 01454589805, 12345678914, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="25, wH3/LdWShD9aCb8eCIm3Tg==,
qptd, rose, GDixtt6NzPOVv6H0dmov5g==, T1yfJSyVxumZUfkDnmUQxA==,
iU+AsGczboCRfU+Zr7mcpw==, 01454589804, 12345678915, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="26, GgJQTndbxyBZ2tECS8SmqQ==,
apti, bosh, gLgVFLFIyyKwdQCXaw78Ag==, O+JIn9XZ3yq6RnKElHuqlA==,
kwYlbu9aF7ndvMTcj8QBSg==, 01454589805, 12345678916, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="27, lv8w8g32kuTXNvSUUypOig==,
i`dl, jack, 8i0YH2mn6kXSyvBjM5p+Yg==, gqRoJF5S66SvBalc2RCo1A==,
2ob/3UYqRsZA5VdScnaWxQ==, 01454589808, 12345678917, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="28, P9YCbFvWCIhcS99KyKH2zA==,
ipqe`m, jordan, PRrI4z4FrWwLvcHPx9g4og==,
y8q31Jj4PFSyZHiLVIxKEQq2ZLhWcqfQ8/EQnIqMx+g=, kDF2za26uOerlNYWYHRT2Q==,
01454589809, 12345678918, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="29, 5wu9XvlJAVtjKijhxt6SQQ==,
itmhd, julie, O4pgkLgz34N+C4bIUOQVnA==, UH7ihg16J61Np/EYMQnXIA==,
z2hbJQD4dRkVVITNxAac5Q==, 01454589808, 12345678919, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="30, Dit2zNmv7pj+Jf5ND1tGQQ==,
upl`t, tomas, MyOShk4kjRnds7CZfU5NCw==, VvWKtMDr5+58OMAAu6BH5A==,
8Rj1Bg696vJMKwPNxzxGOg==, 01450145014, 12341234123, 2018-08-08" />
+ <row data-node="encrypt.t_user" values="31, YTfHI/5xnPNvpjCR20sPWw==,
lhld, mike, qbUuBn0oxdrV8sNNyoqDCg==, FRo1h44oclER1+0MeI1T0w==,
cD36lxxtVApK4QLzec87zg==, 14541454545, 23452345456, 2019-08-08" />
</dataset>
diff --git
a/test/e2e/suite/src/test/resources/cases/dml/dataset/encrypt/delete_user_table.xml
b/test/e2e/suite/src/test/resources/cases/dml/dataset/encrypt/delete_user_table.xml
index 0c8b57b4226..65ec0f65106 100644
---
a/test/e2e/suite/src/test/resources/cases/dml/dataset/encrypt/delete_user_table.xml
+++
b/test/e2e/suite/src/test/resources/cases/dml/dataset/encrypt/delete_user_table.xml
@@ -18,12 +18,33 @@
<dataset update-count="1">
<metadata data-nodes="encrypt.t_user">
<column name="user_id" type="numeric" />
- <column name="address_id" type="numeric" />
- <column name="pwd_plain" type="varchar" />
- <column name="pwd_cipher" type="varchar" />
- <column name="status" type="varchar" />
+ <column name="user_name_cipher" type="varchar" />
+ <column name="user_name_like" type="varchar" />
+ <column name="user_name_plain" type="varchar" />
+ <column name="password_cipher" type="varchar" />
+ <column name="email_cipher" type="varchar" />
+ <column name="telephone_cipher" type="varchar" />
+ <column name="telephone_like" type="varchar" />
+ <column name="telephone_plain" type="varchar" />
+ <column name="creation_date" type="datetime" />
</metadata>
- <row data-node="encrypt.t_user" values="11, 11000, null,
CIbxTwI742pGwxb18lQLkQ==, init" />
- <row data-node="encrypt.t_user" values="12, 12000, null,
VCHpNlwod9AiuS1V+7DSLw==, init" />
- <row data-node="encrypt.t_user" values="13, 13000, null,
8uxRFhW4c2rtSOoesudk/A==, init" />
+ <row data-node="encrypt.t_user" values="11, fQ7IzBxKVuNHtUF6h6WSBg==,
mhth, lisi, wuhmEKgdgrWQYt+Ev0hgGA==, svATu3uWv9KfiloWJeWx3A==,
0kDFxndQdzauFwL/wyCsNQ==, 01454589810, 12345678901, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="12, AQRWSlufQPog/b64YRhu6Q==,
x`mhxt, wangwu, x7A+2jq9B6DSOSFtSOibdA==,
nHJv9e6NiClIuGHOjHLvCAq2ZLhWcqfQ8/EQnIqMx+g=, a/SzSJLapt5iBXvF2c9ycw==,
01454589811, 12345678902, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="13, 5NqS4YvpT+mHBFqZOZ3QDA==,
yi`pmht, zhaoliu, zi6b4xYRjjV+bBk2R4wB+w==,
MLBZczLjriUXvg3aM5QPTxMJbLjNh8yeNrSNBek/VTw=, b6VVhG+F6ujG8IMUZJAIFg==,
01454589814, 12345678903, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="14, qeIY9od3u1KwhjihzLQUTQ==,
yitph, zhuqi, 51UmlLAC+tUvdOAj8CjWfQ==, JCmeNdPyrKO5BW5zvhAA+g==,
f995xinpZdKMVU5J5/yv3w==, 01454589815, 12345678904, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="15, VbNUtguwtpeGhHGnPJ3aXg==,
mha`, liba, +3/5CVbqoKhg3sqznKTFFQ==, T+X+e3Q3+ZNIXXmg/80uxg==,
GETj+S6DrO042E7NuBXLBQ==, 01454589814, 12345678905, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="16, U0/Ao/w1u7L5avR3fAH2Og==,
x`mhiht, wangjiu, jFfFMYxv02DjaFRuAoCDGw==,
RNW/KRq5HeL2YTfAdXSyARMJbLjNh8yeNrSNBek/VTw=, +lbvjJwO7VO4HUKc0Mw0NA==,
01454589815, 12345678906, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="17, zb1sgBigoMi7JPSoY4bAVw==,
yite`, zhuda, VFIjocgjujJCJc6waWXqJA==, 1vF/ET3nBxt7T7vVfAndZQ==,
wFvs5BH6OikgveBeTEBwsQ==, 01454589818, 12345678907, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="18, rJzNIrFEnx296kW+N1YmMw==,
ttmdq, suner, LaODSKGyR7vZ1IvmBOe9vA==, 5u4GIQkJsWRmnJHWaHNSjg==,
uwqm2O1Lv2tNTraJX1ym7Q==, 01454589819, 12345678908, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="19, qHwpQ9kteL8VX6iTUhNdbQ==,
yiptt`m, zhousan, MyOShk4kjRnds7CZfU5NCw==,
HmYCo7QBfJ2E0EvaGHBCOBMJbLjNh8yeNrSNBek/VTw=, YLNQuuUPMGA21nhKWPzzsg==,
01454589818, 12345678909, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="20, qCCmvf7OWRxbVbtLb0az1g==, upl,
tom, fzdTMkzpBvgNYmKSQAp8Fg==, gOoP4Mf0P4ISOJp6A4sRmg==,
l4xa4HwOfs/jusoJon9Wzw==, 01454589801, 12345678910, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="21, IYJ1COaRQ0gSjWMC/UAeMg==,
lpad, kobe, 1uEDMeYh2jstbOf6kx/cqw==, tikMAFiQ37u2VgWqUT38Eg==,
rGpr30UXfczXjCjdvPN+BA==, 01454589800, 12345678911, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="22, 7wvZZ7NVHgk6m1vB/sTC1Q==,
idqqx, jerry, OirN3gvz9uBnrq88nfa1wQ==, T7K/Uz1O2m+3xvB0+c4nGQ==,
7+fCU+VbQZKgLJXZPTTegA==, 01454589801, 12345678912, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="23, SbVQWl8JbnxflCfGJ7KZdA==,
i`ldt, james, hWVVYdkdTUTgm08haeq+tw==, Uk3ju6GteCD1qEHns5ZhKA==,
DpnV86FZefwBRmIAVBh2gg==, 01454589804, 12345678913, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="24, fx7OfSAYqVpjNa7LoKhXvw==,
x`ed, wade, N2W9ijAXNkBxhkvJiIwp0A==, lAAGItVLmb1H69++1MDrIA==,
QrE62wAb8B+2cEPcs4Lm1Q==, 01454589805, 12345678914, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="25, wH3/LdWShD9aCb8eCIm3Tg==,
qptd, rose, GDixtt6NzPOVv6H0dmov5g==, T1yfJSyVxumZUfkDnmUQxA==,
iU+AsGczboCRfU+Zr7mcpw==, 01454589804, 12345678915, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="26, GgJQTndbxyBZ2tECS8SmqQ==,
apti, bosh, gLgVFLFIyyKwdQCXaw78Ag==, O+JIn9XZ3yq6RnKElHuqlA==,
kwYlbu9aF7ndvMTcj8QBSg==, 01454589805, 12345678916, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="27, lv8w8g32kuTXNvSUUypOig==,
i`dl, jack, 8i0YH2mn6kXSyvBjM5p+Yg==, gqRoJF5S66SvBalc2RCo1A==,
2ob/3UYqRsZA5VdScnaWxQ==, 01454589808, 12345678917, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="28, P9YCbFvWCIhcS99KyKH2zA==,
ipqe`m, jordan, PRrI4z4FrWwLvcHPx9g4og==,
y8q31Jj4PFSyZHiLVIxKEQq2ZLhWcqfQ8/EQnIqMx+g=, kDF2za26uOerlNYWYHRT2Q==,
01454589809, 12345678918, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="29, 5wu9XvlJAVtjKijhxt6SQQ==,
itmhd, julie, O4pgkLgz34N+C4bIUOQVnA==, UH7ihg16J61Np/EYMQnXIA==,
z2hbJQD4dRkVVITNxAac5Q==, 01454589808, 12345678919, 2017-08-08" />
</dataset>
diff --git
a/test/e2e/suite/src/test/resources/cases/dml/dataset/encrypt/update_user_table.xml
b/test/e2e/suite/src/test/resources/cases/dml/dataset/encrypt/update_user_table.xml
index 9a16f3734f0..c5131c63080 100644
---
a/test/e2e/suite/src/test/resources/cases/dml/dataset/encrypt/update_user_table.xml
+++
b/test/e2e/suite/src/test/resources/cases/dml/dataset/encrypt/update_user_table.xml
@@ -18,13 +18,34 @@
<dataset update-count="1">
<metadata data-nodes="encrypt.t_user">
<column name="user_id" type="numeric" />
- <column name="address_id" type="numeric" />
- <column name="pwd_plain" type="varchar" />
- <column name="pwd_cipher" type="varchar" />
- <column name="status" type="varchar" />
+ <column name="user_name_cipher" type="varchar" />
+ <column name="user_name_like" type="varchar" />
+ <column name="user_name_plain" type="varchar" />
+ <column name="password_cipher" type="varchar" />
+ <column name="email_cipher" type="varchar" />
+ <column name="telephone_cipher" type="varchar" />
+ <column name="telephone_like" type="varchar" />
+ <column name="telephone_plain" type="varchar" />
+ <column name="creation_date" type="datetime" />
</metadata>
- <row data-node="encrypt.t_user" values="10, 10000, abc,
xdpUjIyP5dJQfX+2tOVbYg==, init" />
- <row data-node="encrypt.t_user" values="11, 11000, null,
CIbxTwI742pGwxb18lQLkQ==, init" />
- <row data-node="encrypt.t_user" values="12, 12000, null,
VCHpNlwod9AiuS1V+7DSLw==, init" />
- <row data-node="encrypt.t_user" values="13, 13000, null,
8uxRFhW4c2rtSOoesudk/A==, init" />
+ <row data-node="encrypt.t_user" values="10, sVq8Lmm+j6bZE5EKSilJEQ==,
yi`mht`m, zhangsan, wuhmEKgdgrWQYt+Ev0hgGA==,
WM0fHOH91JNWnHTkiqBdyNmzk4uJ7CCz4mB1va9Ya1M=, kLjLJIMnfyHT2nA+viaoaQ==,
01454589811, 12345678900, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="11, fQ7IzBxKVuNHtUF6h6WSBg==,
mhth, lisi, wuhmEKgdgrWQYt+Ev0hgGA==, svATu3uWv9KfiloWJeWx3A==,
0kDFxndQdzauFwL/wyCsNQ==, 01454589810, 12345678901, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="12, AQRWSlufQPog/b64YRhu6Q==,
x`mhxt, wangwu, x7A+2jq9B6DSOSFtSOibdA==,
nHJv9e6NiClIuGHOjHLvCAq2ZLhWcqfQ8/EQnIqMx+g=, a/SzSJLapt5iBXvF2c9ycw==,
01454589811, 12345678902, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="13, 5NqS4YvpT+mHBFqZOZ3QDA==,
yi`pmht, zhaoliu, zi6b4xYRjjV+bBk2R4wB+w==,
MLBZczLjriUXvg3aM5QPTxMJbLjNh8yeNrSNBek/VTw=, b6VVhG+F6ujG8IMUZJAIFg==,
01454589814, 12345678903, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="14, qeIY9od3u1KwhjihzLQUTQ==,
yitph, zhuqi, 51UmlLAC+tUvdOAj8CjWfQ==, JCmeNdPyrKO5BW5zvhAA+g==,
f995xinpZdKMVU5J5/yv3w==, 01454589815, 12345678904, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="15, VbNUtguwtpeGhHGnPJ3aXg==,
mha`, liba, +3/5CVbqoKhg3sqznKTFFQ==, T+X+e3Q3+ZNIXXmg/80uxg==,
GETj+S6DrO042E7NuBXLBQ==, 01454589814, 12345678905, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="16, U0/Ao/w1u7L5avR3fAH2Og==,
x`mhiht, wangjiu, jFfFMYxv02DjaFRuAoCDGw==,
RNW/KRq5HeL2YTfAdXSyARMJbLjNh8yeNrSNBek/VTw=, +lbvjJwO7VO4HUKc0Mw0NA==,
01454589815, 12345678906, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="17, zb1sgBigoMi7JPSoY4bAVw==,
yite`, zhuda, VFIjocgjujJCJc6waWXqJA==, 1vF/ET3nBxt7T7vVfAndZQ==,
wFvs5BH6OikgveBeTEBwsQ==, 01454589818, 12345678907, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="18, rJzNIrFEnx296kW+N1YmMw==,
ttmdq, suner, LaODSKGyR7vZ1IvmBOe9vA==, 5u4GIQkJsWRmnJHWaHNSjg==,
uwqm2O1Lv2tNTraJX1ym7Q==, 01454589819, 12345678908, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="19, qHwpQ9kteL8VX6iTUhNdbQ==,
yiptt`m, zhousan, MyOShk4kjRnds7CZfU5NCw==,
HmYCo7QBfJ2E0EvaGHBCOBMJbLjNh8yeNrSNBek/VTw=, YLNQuuUPMGA21nhKWPzzsg==,
01454589818, 12345678909, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="20, qCCmvf7OWRxbVbtLb0az1g==, upl,
tom, fzdTMkzpBvgNYmKSQAp8Fg==, gOoP4Mf0P4ISOJp6A4sRmg==,
l4xa4HwOfs/jusoJon9Wzw==, 01454589801, 12345678910, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="21, IYJ1COaRQ0gSjWMC/UAeMg==,
lpad, kobe, 1uEDMeYh2jstbOf6kx/cqw==, tikMAFiQ37u2VgWqUT38Eg==,
rGpr30UXfczXjCjdvPN+BA==, 01454589800, 12345678911, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="22, 7wvZZ7NVHgk6m1vB/sTC1Q==,
idqqx, jerry, OirN3gvz9uBnrq88nfa1wQ==, T7K/Uz1O2m+3xvB0+c4nGQ==,
7+fCU+VbQZKgLJXZPTTegA==, 01454589801, 12345678912, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="23, SbVQWl8JbnxflCfGJ7KZdA==,
i`ldt, james, hWVVYdkdTUTgm08haeq+tw==, Uk3ju6GteCD1qEHns5ZhKA==,
DpnV86FZefwBRmIAVBh2gg==, 01454589804, 12345678913, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="24, fx7OfSAYqVpjNa7LoKhXvw==,
x`ed, wade, N2W9ijAXNkBxhkvJiIwp0A==, lAAGItVLmb1H69++1MDrIA==,
QrE62wAb8B+2cEPcs4Lm1Q==, 01454589805, 12345678914, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="25, wH3/LdWShD9aCb8eCIm3Tg==,
qptd, rose, GDixtt6NzPOVv6H0dmov5g==, T1yfJSyVxumZUfkDnmUQxA==,
iU+AsGczboCRfU+Zr7mcpw==, 01454589804, 12345678915, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="26, GgJQTndbxyBZ2tECS8SmqQ==,
apti, bosh, gLgVFLFIyyKwdQCXaw78Ag==, O+JIn9XZ3yq6RnKElHuqlA==,
kwYlbu9aF7ndvMTcj8QBSg==, 01454589805, 12345678916, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="27, lv8w8g32kuTXNvSUUypOig==,
i`dl, jack, 8i0YH2mn6kXSyvBjM5p+Yg==, gqRoJF5S66SvBalc2RCo1A==,
2ob/3UYqRsZA5VdScnaWxQ==, 01454589808, 12345678917, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="28, P9YCbFvWCIhcS99KyKH2zA==,
ipqe`m, jordan, PRrI4z4FrWwLvcHPx9g4og==,
y8q31Jj4PFSyZHiLVIxKEQq2ZLhWcqfQ8/EQnIqMx+g=, kDF2za26uOerlNYWYHRT2Q==,
01454589809, 12345678918, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="29, 5wu9XvlJAVtjKijhxt6SQQ==,
itmhd, julie, O4pgkLgz34N+C4bIUOQVnA==, UH7ihg16J61Np/EYMQnXIA==,
z2hbJQD4dRkVVITNxAac5Q==, 01454589808, 12345678919, 2017-08-08" />
</dataset>
diff --git
a/test/e2e/suite/src/test/resources/cases/dml/dataset/encrypt/update_user_table_by_pwd.xml
b/test/e2e/suite/src/test/resources/cases/dml/dataset/encrypt/update_user_table_by_pwd.xml
index cfd023348f1..a2dcc842902 100644
---
a/test/e2e/suite/src/test/resources/cases/dml/dataset/encrypt/update_user_table_by_pwd.xml
+++
b/test/e2e/suite/src/test/resources/cases/dml/dataset/encrypt/update_user_table_by_pwd.xml
@@ -18,13 +18,34 @@
<dataset update-count="1">
<metadata data-nodes="encrypt.t_user">
<column name="user_id" type="numeric" />
- <column name="address_id" type="numeric" />
- <column name="pwd_plain" type="varchar" />
- <column name="pwd_cipher" type="varchar" />
- <column name="status" type="varchar" />
+ <column name="user_name_cipher" type="varchar" />
+ <column name="user_name_like" type="varchar" />
+ <column name="user_name_plain" type="varchar" />
+ <column name="password_cipher" type="varchar" />
+ <column name="email_cipher" type="varchar" />
+ <column name="telephone_cipher" type="varchar" />
+ <column name="telephone_like" type="varchar" />
+ <column name="telephone_plain" type="varchar" />
+ <column name="creation_date" type="datetime" />
</metadata>
- <row data-node="encrypt.t_user" values="10, 10000, null,
yK+tn8E43EyCEgbqNOrJ4w==, update" />
- <row data-node="encrypt.t_user" values="11, 11000, null,
CIbxTwI742pGwxb18lQLkQ==, init" />
- <row data-node="encrypt.t_user" values="12, 12000, null,
VCHpNlwod9AiuS1V+7DSLw==, init" />
- <row data-node="encrypt.t_user" values="13, 13000, null,
8uxRFhW4c2rtSOoesudk/A==, init" />
+ <row data-node="encrypt.t_user" values="10, sVq8Lmm+j6bZE5EKSilJEQ==,
yi`mht`m, zhangsan, aQol0b6th65d0aXe+zFPsQ==,
WM0fHOH91JNWnHTkiqBdyNmzk4uJ7CCz4mB1va9Ya1M=, 0kDFxndQdzauFwL/wyCsNQ==,
01454589810, 12345678901, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="11, fQ7IzBxKVuNHtUF6h6WSBg==,
mhth, lisi, wuhmEKgdgrWQYt+Ev0hgGA==, svATu3uWv9KfiloWJeWx3A==,
0kDFxndQdzauFwL/wyCsNQ==, 01454589810, 12345678901, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="12, AQRWSlufQPog/b64YRhu6Q==,
x`mhxt, wangwu, x7A+2jq9B6DSOSFtSOibdA==,
nHJv9e6NiClIuGHOjHLvCAq2ZLhWcqfQ8/EQnIqMx+g=, a/SzSJLapt5iBXvF2c9ycw==,
01454589811, 12345678902, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="13, 5NqS4YvpT+mHBFqZOZ3QDA==,
yi`pmht, zhaoliu, zi6b4xYRjjV+bBk2R4wB+w==,
MLBZczLjriUXvg3aM5QPTxMJbLjNh8yeNrSNBek/VTw=, b6VVhG+F6ujG8IMUZJAIFg==,
01454589814, 12345678903, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="14, qeIY9od3u1KwhjihzLQUTQ==,
yitph, zhuqi, 51UmlLAC+tUvdOAj8CjWfQ==, JCmeNdPyrKO5BW5zvhAA+g==,
f995xinpZdKMVU5J5/yv3w==, 01454589815, 12345678904, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="15, VbNUtguwtpeGhHGnPJ3aXg==,
mha`, liba, +3/5CVbqoKhg3sqznKTFFQ==, T+X+e3Q3+ZNIXXmg/80uxg==,
GETj+S6DrO042E7NuBXLBQ==, 01454589814, 12345678905, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="16, U0/Ao/w1u7L5avR3fAH2Og==,
x`mhiht, wangjiu, jFfFMYxv02DjaFRuAoCDGw==,
RNW/KRq5HeL2YTfAdXSyARMJbLjNh8yeNrSNBek/VTw=, +lbvjJwO7VO4HUKc0Mw0NA==,
01454589815, 12345678906, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="17, zb1sgBigoMi7JPSoY4bAVw==,
yite`, zhuda, VFIjocgjujJCJc6waWXqJA==, 1vF/ET3nBxt7T7vVfAndZQ==,
wFvs5BH6OikgveBeTEBwsQ==, 01454589818, 12345678907, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="18, rJzNIrFEnx296kW+N1YmMw==,
ttmdq, suner, LaODSKGyR7vZ1IvmBOe9vA==, 5u4GIQkJsWRmnJHWaHNSjg==,
uwqm2O1Lv2tNTraJX1ym7Q==, 01454589819, 12345678908, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="19, qHwpQ9kteL8VX6iTUhNdbQ==,
yiptt`m, zhousan, MyOShk4kjRnds7CZfU5NCw==,
HmYCo7QBfJ2E0EvaGHBCOBMJbLjNh8yeNrSNBek/VTw=, YLNQuuUPMGA21nhKWPzzsg==,
01454589818, 12345678909, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="20, qCCmvf7OWRxbVbtLb0az1g==, upl,
tom, fzdTMkzpBvgNYmKSQAp8Fg==, gOoP4Mf0P4ISOJp6A4sRmg==,
l4xa4HwOfs/jusoJon9Wzw==, 01454589801, 12345678910, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="21, IYJ1COaRQ0gSjWMC/UAeMg==,
lpad, kobe, 1uEDMeYh2jstbOf6kx/cqw==, tikMAFiQ37u2VgWqUT38Eg==,
rGpr30UXfczXjCjdvPN+BA==, 01454589800, 12345678911, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="22, 7wvZZ7NVHgk6m1vB/sTC1Q==,
idqqx, jerry, OirN3gvz9uBnrq88nfa1wQ==, T7K/Uz1O2m+3xvB0+c4nGQ==,
7+fCU+VbQZKgLJXZPTTegA==, 01454589801, 12345678912, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="23, SbVQWl8JbnxflCfGJ7KZdA==,
i`ldt, james, hWVVYdkdTUTgm08haeq+tw==, Uk3ju6GteCD1qEHns5ZhKA==,
DpnV86FZefwBRmIAVBh2gg==, 01454589804, 12345678913, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="24, fx7OfSAYqVpjNa7LoKhXvw==,
x`ed, wade, N2W9ijAXNkBxhkvJiIwp0A==, lAAGItVLmb1H69++1MDrIA==,
QrE62wAb8B+2cEPcs4Lm1Q==, 01454589805, 12345678914, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="25, wH3/LdWShD9aCb8eCIm3Tg==,
qptd, rose, GDixtt6NzPOVv6H0dmov5g==, T1yfJSyVxumZUfkDnmUQxA==,
iU+AsGczboCRfU+Zr7mcpw==, 01454589804, 12345678915, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="26, GgJQTndbxyBZ2tECS8SmqQ==,
apti, bosh, gLgVFLFIyyKwdQCXaw78Ag==, O+JIn9XZ3yq6RnKElHuqlA==,
kwYlbu9aF7ndvMTcj8QBSg==, 01454589805, 12345678916, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="27, lv8w8g32kuTXNvSUUypOig==,
i`dl, jack, 8i0YH2mn6kXSyvBjM5p+Yg==, gqRoJF5S66SvBalc2RCo1A==,
2ob/3UYqRsZA5VdScnaWxQ==, 01454589808, 12345678917, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="28, P9YCbFvWCIhcS99KyKH2zA==,
ipqe`m, jordan, PRrI4z4FrWwLvcHPx9g4og==,
y8q31Jj4PFSyZHiLVIxKEQq2ZLhWcqfQ8/EQnIqMx+g=, kDF2za26uOerlNYWYHRT2Q==,
01454589809, 12345678918, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="29, 5wu9XvlJAVtjKijhxt6SQQ==,
itmhd, julie, O4pgkLgz34N+C4bIUOQVnA==, UH7ihg16J61Np/EYMQnXIA==,
z2hbJQD4dRkVVITNxAac5Q==, 01454589808, 12345678919, 2017-08-08" />
</dataset>
diff --git
a/test/e2e/suite/src/test/resources/cases/dml/dml-integration-test-cases.xml
b/test/e2e/suite/src/test/resources/cases/dml/dml-integration-test-cases.xml
index 4c232286a79..137e2c139c0 100644
--- a/test/e2e/suite/src/test/resources/cases/dml/dml-integration-test-cases.xml
+++ b/test/e2e/suite/src/test/resources/cases/dml/dml-integration-test-cases.xml
@@ -121,12 +121,8 @@
<!-- <assertion parameters="5:int, 5000:int, 6:int, 6000:int"
expected-data-file="batch_insert_into_single_table.xml" />-->
<!-- </test-case>-->
- <test-case sql="INSERT INTO t_user(user_id, address_id, pwd, status)
values (?, ?, 'a100', 'init'),(?, ?, 'b101', 'init')"
scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt">
- <assertion parameters="100:int, 100000:int, 101:int, 101000:int"
expected-data-file="batch_insert_into_user_table.xml" />
- </test-case>
-
- <test-case sql="INSERT INTO t_user(user_id, address_id, pwd, status)
values (100, 100000, 'a100', 'init'),(101, 101000, 'b101', 'init')"
scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt">
- <assertion expected-data-file="batch_insert_into_user_table.xml" />
+ <test-case sql="INSERT INTO t_user (user_id, user_name, password, email,
telephone, creation_date) VALUES (?, ?, '123456', '[email protected]',
'12341234123', '2018-08-08'), (?, ?, '23456', '[email protected]', '23452345456',
'2019-08-08')" scenario-types="encrypt">
+ <assertion parameters="30:int, tomas:String, 31:int, mike:String"
expected-data-file="batch_insert_into_user_table.xml" />
</test-case>
<test-case sql="UPDATE t_order SET status = ? WHERE order_id = ? AND
user_id = ?"
scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting,sharding_governance">
@@ -167,14 +163,20 @@
<!-- <assertion expected-data-file="update_single_table.xml" />-->
<!-- </test-case>-->
- <!--fixme support encrypt scenario of PostgreSQL-->
- <test-case sql="UPDATE t_user u SET u.pwd = 'abc' WHERE user_id = 10"
db-types="H2,MySQL,SQLServer,Oracle"
scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt">
- <assertion expected-data-file="update_user_table.xml" />
+ <test-case sql="UPDATE t_user u SET u.password = ? WHERE u.user_id = ?"
db-types="H2,MySQL,openGauss,SQLServer,Oracle" scenario-types="encrypt">
+ <assertion parameters="222222:String, 10:int"
expected-data-file="update_user_table.xml" />
</test-case>
- <!--fixme support encrypt scenario of PostgreSQL-->
- <test-case sql="UPDATE t_user u SET u.status = 'update' WHERE u.pwd =
'a10'" db-types="H2,MySQL,SQLServer,Oracle"
scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt">
- <assertion expected-data-file="update_user_table_by_pwd.xml" />
+ <test-case sql="UPDATE t_user u SET u.telephone = ? WHERE u.password = ?"
db-types="H2,MySQL,openGauss,SQLServer,Oracle" scenario-types="encrypt">
+ <assertion parameters="12345678901:String, 111111:String"
expected-data-file="update_user_table_by_pwd.xml" />
+ </test-case>
+
+ <test-case sql="UPDATE t_user SET password = ? WHERE user_id = ?"
db-types="H2,MySQL,PostgreSQL,openGauss,SQLServer,Oracle"
scenario-types="encrypt">
+ <assertion parameters="222222:String, 10:int"
expected-data-file="update_user_table.xml" />
+ </test-case>
+
+ <test-case sql="UPDATE t_user SET telephone = ? WHERE password = ?"
db-types="H2,MySQL,PostgreSQL,openGauss,SQLServer,Oracle"
scenario-types="encrypt">
+ <assertion parameters="12345678901:String, 111111:String"
expected-data-file="update_user_table_by_pwd.xml" />
</test-case>
<test-case sql="DELETE FROM t_order WHERE order_id = ? AND user_id = ? AND
status= ?"
scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting,sharding_governance">
@@ -185,14 +187,12 @@
<assertion parameters="init:String"
expected-data-file="delete_without_sharding_value.xml" />
</test-case>
- <!--fixme support encrypt scenario of PostgreSQL-->
- <test-case sql="DELETE FROM t_user WHERE user_id = 10"
db-types="H2,MySQL,SQLServer,Oracle"
scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt">
- <assertion expected-data-file="delete_user_table.xml" />
+ <test-case sql="DELETE FROM t_user WHERE user_id = ?"
db-types="H2,MySQL,PostgreSQL,openGauss,SQLServer,Oracle"
scenario-types="encrypt">
+ <assertion parameters="10:int"
expected-data-file="delete_user_table.xml" />
</test-case>
- <!--fixme support encrypt scenario of PostgreSQL-->
- <test-case sql="DELETE FROM t_user WHERE pwd = 'a10'"
db-types="H2,MySQL,SQLServer,Oracle"
scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt">
- <assertion expected-data-file="delete_user_table.xml" />
+ <test-case sql="DELETE FROM t_user WHERE password = ?"
db-types="H2,MySQL,PostgreSQL,openGauss,SQLServer,Oracle"
scenario-types="encrypt">
+ <assertion parameters="111111:String"
expected-data-file="delete_user_table.xml" />
</test-case>
<!--fixme! issue #9769-->
diff --git
a/test/e2e/suite/src/test/resources/env/scenario/encrypt/data/actual/dataset.xml
b/test/e2e/suite/src/test/resources/env/scenario/encrypt/data/actual/dataset.xml
index 2ababc4295c..0e43c97483e 100644
---
a/test/e2e/suite/src/test/resources/env/scenario/encrypt/data/actual/dataset.xml
+++
b/test/e2e/suite/src/test/resources/env/scenario/encrypt/data/actual/dataset.xml
@@ -55,26 +55,26 @@
<row data-node="encrypt.t_single_table" values="2, 11, init" />
<row data-node="encrypt.t_single_table" values="3, 12, init" />
<row data-node="encrypt.t_single_table" values="4, 13, init" />
- <row data-node="encrypt.t_user" values="10, sVq8Lmm+j6bZE5EKSilJEQ==,
yi`mht`m, zhangsan, aQol0b6th65d0aXe+zFPsQ==,
WM0fHOH91JNWnHTkiqBdyNmzk4uJ7CCz4mB1va9Ya1M=, kLjLJIMnfyHT2nA+viaoaQ==,
1454589811, 12345678900, 2017-08-08" />
- <row data-node="encrypt.t_user" values="11, fQ7IzBxKVuNHtUF6h6WSBg==,
mhth, lisi, wuhmEKgdgrWQYt+Ev0hgGA==, svATu3uWv9KfiloWJeWx3A==,
0kDFxndQdzauFwL/wyCsNQ==, 1454589810, 12345678901, 2017-08-08" />
- <row data-node="encrypt.t_user" values="12, AQRWSlufQPog/b64YRhu6Q==,
x`mhxt, wangwu, x7A+2jq9B6DSOSFtSOibdA==,
nHJv9e6NiClIuGHOjHLvCAq2ZLhWcqfQ8/EQnIqMx+g=, a/SzSJLapt5iBXvF2c9ycw==,
1454589811, 12345678902, 2017-08-08" />
- <row data-node="encrypt.t_user" values="13, 5NqS4YvpT+mHBFqZOZ3QDA==,
yi`pmht, zhaoliu, zi6b4xYRjjV+bBk2R4wB+w==,
MLBZczLjriUXvg3aM5QPTxMJbLjNh8yeNrSNBek/VTw=, b6VVhG+F6ujG8IMUZJAIFg==,
1454589814, 12345678903, 2017-08-08" />
- <row data-node="encrypt.t_user" values="14, qeIY9od3u1KwhjihzLQUTQ==,
yitph, zhuqi, 51UmlLAC+tUvdOAj8CjWfQ==, JCmeNdPyrKO5BW5zvhAA+g==,
f995xinpZdKMVU5J5/yv3w==, 1454589815, 12345678904, 2017-08-08" />
- <row data-node="encrypt.t_user" values="15, VbNUtguwtpeGhHGnPJ3aXg==,
mha`, liba, +3/5CVbqoKhg3sqznKTFFQ==, T+X+e3Q3+ZNIXXmg/80uxg==,
GETj+S6DrO042E7NuBXLBQ==, 1454589814, 12345678905, 2017-08-08" />
- <row data-node="encrypt.t_user" values="16, U0/Ao/w1u7L5avR3fAH2Og==,
x`mhiht, wangjiu, jFfFMYxv02DjaFRuAoCDGw==,
RNW/KRq5HeL2YTfAdXSyARMJbLjNh8yeNrSNBek/VTw=, +lbvjJwO7VO4HUKc0Mw0NA==,
1454589815, 12345678906, 2017-08-08" />
- <row data-node="encrypt.t_user" values="17, zb1sgBigoMi7JPSoY4bAVw==,
yite`, zhuda, VFIjocgjujJCJc6waWXqJA==, 1vF/ET3nBxt7T7vVfAndZQ==,
wFvs5BH6OikgveBeTEBwsQ==, 1454589818, 12345678907, 2017-08-08" />
- <row data-node="encrypt.t_user" values="18, rJzNIrFEnx296kW+N1YmMw==,
ttmdq, suner, LaODSKGyR7vZ1IvmBOe9vA==, 5u4GIQkJsWRmnJHWaHNSjg==,
uwqm2O1Lv2tNTraJX1ym7Q==, 1454589819, 12345678908, 2017-08-08" />
- <row data-node="encrypt.t_user" values="19, qHwpQ9kteL8VX6iTUhNdbQ==,
yiptt`m, zhousan, MyOShk4kjRnds7CZfU5NCw==,
HmYCo7QBfJ2E0EvaGHBCOBMJbLjNh8yeNrSNBek/VTw=, YLNQuuUPMGA21nhKWPzzsg==,
1454589818, 12345678909, 2017-08-08" />
- <row data-node="encrypt.t_user" values="20, qCCmvf7OWRxbVbtLb0az1g==, upl,
tom, fzdTMkzpBvgNYmKSQAp8Fg==, gOoP4Mf0P4ISOJp6A4sRmg==,
l4xa4HwOfs/jusoJon9Wzw==, 1454589801, 12345678910, 2017-08-08" />
- <row data-node="encrypt.t_user" values="21, IYJ1COaRQ0gSjWMC/UAeMg==,
lpad, kobe, 1uEDMeYh2jstbOf6kx/cqw==, tikMAFiQ37u2VgWqUT38Eg==,
rGpr30UXfczXjCjdvPN+BA==, 1454589800, 12345678911, 2017-08-08" />
- <row data-node="encrypt.t_user" values="22, 7wvZZ7NVHgk6m1vB/sTC1Q==,
idqqx, jerry, OirN3gvz9uBnrq88nfa1wQ==, T7K/Uz1O2m+3xvB0+c4nGQ==,
7+fCU+VbQZKgLJXZPTTegA==, 1454589801, 12345678912, 2017-08-08" />
- <row data-node="encrypt.t_user" values="23, SbVQWl8JbnxflCfGJ7KZdA==,
i`ldt, james, hWVVYdkdTUTgm08haeq+tw==, Uk3ju6GteCD1qEHns5ZhKA==,
DpnV86FZefwBRmIAVBh2gg==, 1454589804, 12345678913, 2017-08-08" />
- <row data-node="encrypt.t_user" values="24, fx7OfSAYqVpjNa7LoKhXvw==,
x`ed, wade, N2W9ijAXNkBxhkvJiIwp0A==, lAAGItVLmb1H69++1MDrIA==,
QrE62wAb8B+2cEPcs4Lm1Q==, 1454589805, 12345678914, 2017-08-08" />
- <row data-node="encrypt.t_user" values="25, wH3/LdWShD9aCb8eCIm3Tg==,
qptd, rose, GDixtt6NzPOVv6H0dmov5g==, T1yfJSyVxumZUfkDnmUQxA==,
iU+AsGczboCRfU+Zr7mcpw==, 1454589804, 12345678915, 2017-08-08" />
- <row data-node="encrypt.t_user" values="26, GgJQTndbxyBZ2tECS8SmqQ==,
apti, bosh, gLgVFLFIyyKwdQCXaw78Ag==, O+JIn9XZ3yq6RnKElHuqlA==,
kwYlbu9aF7ndvMTcj8QBSg==, 1454589805, 12345678916, 2017-08-08" />
- <row data-node="encrypt.t_user" values="27, lv8w8g32kuTXNvSUUypOig==,
i`dl, jack, 8i0YH2mn6kXSyvBjM5p+Yg==, gqRoJF5S66SvBalc2RCo1A==,
2ob/3UYqRsZA5VdScnaWxQ==, 1454589808, 12345678917, 2017-08-08" />
- <row data-node="encrypt.t_user" values="28, P9YCbFvWCIhcS99KyKH2zA==,
ipqe`m, jordan, PRrI4z4FrWwLvcHPx9g4og==,
y8q31Jj4PFSyZHiLVIxKEQq2ZLhWcqfQ8/EQnIqMx+g=, kDF2za26uOerlNYWYHRT2Q==,
1454589809, 12345678918, 2017-08-08" />
- <row data-node="encrypt.t_user" values="29, 5wu9XvlJAVtjKijhxt6SQQ==,
itmhd, julie, O4pgkLgz34N+C4bIUOQVnA==, UH7ihg16J61Np/EYMQnXIA==,
z2hbJQD4dRkVVITNxAac5Q==, 1454589808, 12345678919, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="10, sVq8Lmm+j6bZE5EKSilJEQ==,
yi`mht`m, zhangsan, aQol0b6th65d0aXe+zFPsQ==,
WM0fHOH91JNWnHTkiqBdyNmzk4uJ7CCz4mB1va9Ya1M=, kLjLJIMnfyHT2nA+viaoaQ==,
01454589811, 12345678900, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="11, fQ7IzBxKVuNHtUF6h6WSBg==,
mhth, lisi, wuhmEKgdgrWQYt+Ev0hgGA==, svATu3uWv9KfiloWJeWx3A==,
0kDFxndQdzauFwL/wyCsNQ==, 01454589810, 12345678901, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="12, AQRWSlufQPog/b64YRhu6Q==,
x`mhxt, wangwu, x7A+2jq9B6DSOSFtSOibdA==,
nHJv9e6NiClIuGHOjHLvCAq2ZLhWcqfQ8/EQnIqMx+g=, a/SzSJLapt5iBXvF2c9ycw==,
01454589811, 12345678902, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="13, 5NqS4YvpT+mHBFqZOZ3QDA==,
yi`pmht, zhaoliu, zi6b4xYRjjV+bBk2R4wB+w==,
MLBZczLjriUXvg3aM5QPTxMJbLjNh8yeNrSNBek/VTw=, b6VVhG+F6ujG8IMUZJAIFg==,
01454589814, 12345678903, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="14, qeIY9od3u1KwhjihzLQUTQ==,
yitph, zhuqi, 51UmlLAC+tUvdOAj8CjWfQ==, JCmeNdPyrKO5BW5zvhAA+g==,
f995xinpZdKMVU5J5/yv3w==, 01454589815, 12345678904, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="15, VbNUtguwtpeGhHGnPJ3aXg==,
mha`, liba, +3/5CVbqoKhg3sqznKTFFQ==, T+X+e3Q3+ZNIXXmg/80uxg==,
GETj+S6DrO042E7NuBXLBQ==, 01454589814, 12345678905, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="16, U0/Ao/w1u7L5avR3fAH2Og==,
x`mhiht, wangjiu, jFfFMYxv02DjaFRuAoCDGw==,
RNW/KRq5HeL2YTfAdXSyARMJbLjNh8yeNrSNBek/VTw=, +lbvjJwO7VO4HUKc0Mw0NA==,
01454589815, 12345678906, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="17, zb1sgBigoMi7JPSoY4bAVw==,
yite`, zhuda, VFIjocgjujJCJc6waWXqJA==, 1vF/ET3nBxt7T7vVfAndZQ==,
wFvs5BH6OikgveBeTEBwsQ==, 01454589818, 12345678907, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="18, rJzNIrFEnx296kW+N1YmMw==,
ttmdq, suner, LaODSKGyR7vZ1IvmBOe9vA==, 5u4GIQkJsWRmnJHWaHNSjg==,
uwqm2O1Lv2tNTraJX1ym7Q==, 01454589819, 12345678908, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="19, qHwpQ9kteL8VX6iTUhNdbQ==,
yiptt`m, zhousan, MyOShk4kjRnds7CZfU5NCw==,
HmYCo7QBfJ2E0EvaGHBCOBMJbLjNh8yeNrSNBek/VTw=, YLNQuuUPMGA21nhKWPzzsg==,
01454589818, 12345678909, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="20, qCCmvf7OWRxbVbtLb0az1g==, upl,
tom, fzdTMkzpBvgNYmKSQAp8Fg==, gOoP4Mf0P4ISOJp6A4sRmg==,
l4xa4HwOfs/jusoJon9Wzw==, 01454589801, 12345678910, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="21, IYJ1COaRQ0gSjWMC/UAeMg==,
lpad, kobe, 1uEDMeYh2jstbOf6kx/cqw==, tikMAFiQ37u2VgWqUT38Eg==,
rGpr30UXfczXjCjdvPN+BA==, 01454589800, 12345678911, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="22, 7wvZZ7NVHgk6m1vB/sTC1Q==,
idqqx, jerry, OirN3gvz9uBnrq88nfa1wQ==, T7K/Uz1O2m+3xvB0+c4nGQ==,
7+fCU+VbQZKgLJXZPTTegA==, 01454589801, 12345678912, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="23, SbVQWl8JbnxflCfGJ7KZdA==,
i`ldt, james, hWVVYdkdTUTgm08haeq+tw==, Uk3ju6GteCD1qEHns5ZhKA==,
DpnV86FZefwBRmIAVBh2gg==, 01454589804, 12345678913, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="24, fx7OfSAYqVpjNa7LoKhXvw==,
x`ed, wade, N2W9ijAXNkBxhkvJiIwp0A==, lAAGItVLmb1H69++1MDrIA==,
QrE62wAb8B+2cEPcs4Lm1Q==, 01454589805, 12345678914, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="25, wH3/LdWShD9aCb8eCIm3Tg==,
qptd, rose, GDixtt6NzPOVv6H0dmov5g==, T1yfJSyVxumZUfkDnmUQxA==,
iU+AsGczboCRfU+Zr7mcpw==, 01454589804, 12345678915, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="26, GgJQTndbxyBZ2tECS8SmqQ==,
apti, bosh, gLgVFLFIyyKwdQCXaw78Ag==, O+JIn9XZ3yq6RnKElHuqlA==,
kwYlbu9aF7ndvMTcj8QBSg==, 01454589805, 12345678916, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="27, lv8w8g32kuTXNvSUUypOig==,
i`dl, jack, 8i0YH2mn6kXSyvBjM5p+Yg==, gqRoJF5S66SvBalc2RCo1A==,
2ob/3UYqRsZA5VdScnaWxQ==, 01454589808, 12345678917, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="28, P9YCbFvWCIhcS99KyKH2zA==,
ipqe`m, jordan, PRrI4z4FrWwLvcHPx9g4og==,
y8q31Jj4PFSyZHiLVIxKEQq2ZLhWcqfQ8/EQnIqMx+g=, kDF2za26uOerlNYWYHRT2Q==,
01454589809, 12345678918, 2017-08-08" />
+ <row data-node="encrypt.t_user" values="29, 5wu9XvlJAVtjKijhxt6SQQ==,
itmhd, julie, O4pgkLgz34N+C4bIUOQVnA==, UH7ihg16J61Np/EYMQnXIA==,
z2hbJQD4dRkVVITNxAac5Q==, 01454589808, 12345678919, 2017-08-08" />
<row data-node="encrypt.t_user_item" values="100000, 10, init, 2017-08-08"
/>
<row data-node="encrypt.t_user_item" values="110000, 11, init, 2017-08-08"
/>
<row data-node="encrypt.t_user_item" values="120000, 12, init, 2017-08-08"
/>
