This is an automated email from the ASF dual-hosted git repository.
dataroaring pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 263c86f389e [enhancement](regression-test) cover mow and mor (#36350)
263c86f389e is described below
commit 263c86f389e1138894b705ee4603d2d8c7e4c63f
Author: kkop <[email protected]>
AuthorDate: Fri Jun 21 20:24:47 2024 +0800
[enhancement](regression-test) cover mow and mor (#36350)
Co-authored-by: cjj2010 <[email protected]>
---
.../org/apache/doris/regression/suite/Suite.groovy | 6 +++
.../test_unique_model_schema_value_add.groovy | 4 +-
.../test_unique_model_schema_value_change.groovy | 26 +++++++------
.../test_unique_model_schema_value_change1.groovy | 16 ++++----
.../test_unique_model_schema_value_change2.groovy | 20 +++++-----
.../test_unique_model_schema_value_change3.groovy | 12 +++---
...st_unique_model_schema_value_change_drop.groovy | 44 +++++++++++-----------
.../test_unique_schema_key_change_add.groovy | 5 ++-
...y => test_unique_schema_key_change_drop.groovy} | 8 ++--
.../test_unique_schema_key_change_modify.groovy | 37 +++++++++---------
10 files changed, 100 insertions(+), 78 deletions(-)
diff --git
a/regression-test/framework/src/main/groovy/org/apache/doris/regression/suite/Suite.groovy
b/regression-test/framework/src/main/groovy/org/apache/doris/regression/suite/Suite.groovy
index c81e3fcb1c1..322cdac2caf 100644
---
a/regression-test/framework/src/main/groovy/org/apache/doris/regression/suite/Suite.groovy
+++
b/regression-test/framework/src/main/groovy/org/apache/doris/regression/suite/Suite.groovy
@@ -654,6 +654,12 @@ class Suite implements GroovyInterceptable {
}
}
+ String getRandomBoolean() {
+ Random random = new Random()
+ boolean randomBoolean = random.nextBoolean()
+ return randomBoolean ? "true" : "false"
+ }
+
void expectExceptionLike(Closure userFunction, String errorMessage = null)
{
try {
userFunction()
diff --git
a/regression-test/suites/schema_change_p0/test_unique_model_schema_value_add.groovy
b/regression-test/suites/schema_change_p0/test_unique_model_schema_value_add.groovy
index 9b246e895b2..1d478b2283d 100644
---
a/regression-test/suites/schema_change_p0/test_unique_model_schema_value_add.groovy
+++
b/regression-test/suites/schema_change_p0/test_unique_model_schema_value_add.groovy
@@ -18,6 +18,8 @@
suite("test_unique_model_schema_value_add","p0") {
def tbName = "test_unique_model_schema_value_add"
def tbName2 = "test_unique_model_schema_value_add_1"
+ def on_write = getRandomBoolean()
+ println String.format("current enable_unique_key_merge_on_write is : %s
",on_write)
//Test the unique model by adding a value column
sql """ DROP TABLE IF EXISTS ${tbName} """
def initTable = " CREATE TABLE IF NOT EXISTS ${tbName}\n" +
@@ -35,7 +37,7 @@ suite("test_unique_model_schema_value_add","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
def initTableData = "insert into ${tbName} values(123456789, 'Alice',
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00')," +
diff --git
a/regression-test/suites/schema_change_p0/test_unique_model_schema_value_change.groovy
b/regression-test/suites/schema_change_p0/test_unique_model_schema_value_change.groovy
index ce65ed25415..9a415159034 100644
---
a/regression-test/suites/schema_change_p0/test_unique_model_schema_value_change.groovy
+++
b/regression-test/suites/schema_change_p0/test_unique_model_schema_value_change.groovy
@@ -16,8 +16,10 @@
// under the License.
suite("test_unique_model_schema_value_change","p0") {
- def tbName = "test_unique_model_schema_value_change"
- def tbName2 = "test_unique_model_schema_value_change_1"
+ def tbName = "test_unique_model_value_change0"
+ def tbName2 = "test_unique_model_value_change_0"
+ def on_write = getRandomBoolean()
+ println String.format("current enable_unique_key_merge_on_write is : %s
",on_write)
//Test the unique model by adding a value column
sql """ DROP TABLE IF EXISTS ${tbName} """
def getTableStatusSql = " SHOW ALTER TABLE COLUMN WHERE
IndexName='${tbName}' ORDER BY createtime DESC LIMIT 1 "
@@ -44,7 +46,7 @@ suite("test_unique_model_schema_value_change","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
def initTableData = "insert into ${tbName} values(123456789, 'Alice', 0,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00')," +
@@ -219,7 +221,7 @@ suite("test_unique_model_schema_value_change","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice', 1,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00')," +
@@ -273,7 +275,7 @@ suite("test_unique_model_schema_value_change","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData2 = "insert into ${tbName2} values(123456789, 'Alice', 1,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00')," +
@@ -414,7 +416,7 @@ suite("test_unique_model_schema_value_change","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice', 13243,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00')," +
@@ -576,7 +578,7 @@ suite("test_unique_model_schema_value_change","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice',
2147483641, 'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00')," +
@@ -751,7 +753,7 @@ suite("test_unique_model_schema_value_change","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice',
21474832641, 'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00')," +
@@ -930,7 +932,7 @@ suite("test_unique_model_schema_value_change","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice',
21474832641, 'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00')," +
@@ -1116,7 +1118,7 @@ suite("test_unique_model_schema_value_change","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice', 1.8,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]')," +
@@ -1390,7 +1392,7 @@ suite("test_unique_model_schema_value_change","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice', 1.8,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]')," +
@@ -1663,7 +1665,7 @@ suite("test_unique_model_schema_value_change","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice', 1.83,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]')," +
diff --git
a/regression-test/suites/schema_change_p0/test_unique_model_schema_value_change1.groovy
b/regression-test/suites/schema_change_p0/test_unique_model_schema_value_change1.groovy
index 5715189915d..5b8efe6be0e 100644
---
a/regression-test/suites/schema_change_p0/test_unique_model_schema_value_change1.groovy
+++
b/regression-test/suites/schema_change_p0/test_unique_model_schema_value_change1.groovy
@@ -16,8 +16,10 @@
// under the License.
suite("test_unique_model_schema_value_change1","p0") {
- def tbName = "test_unique_model_schema_value_change1"
- def tbName2 = "test_unique_model_schema_value_change_1"
+ def tbName = "test_unique_model_value_change1"
+ def tbName2 = "test_unique_model_value_change_1"
+ def on_write = getRandomBoolean()
+ println String.format("current enable_unique_key_merge_on_write is : %s
",on_write)
//Test the unique model by adding a value column
sql """ DROP TABLE IF EXISTS ${tbName} """
def initTable = " CREATE TABLE IF NOT EXISTS ${tbName}\n" +
@@ -35,7 +37,7 @@ suite("test_unique_model_schema_value_change1","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
def initTableData = "insert into ${tbName} values(123456789, 'Alice',
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01')," +
@@ -78,7 +80,7 @@ suite("test_unique_model_schema_value_change1","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice', 1.8,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01', {'a':
100, 'b': 200}, '[\"abc\", \"def\"]')," +
@@ -330,7 +332,7 @@ suite("test_unique_model_schema_value_change1","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice', 1.8,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01', {'a':
100, 'b': 200}, '[\"abc\", \"def\"]')," +
@@ -583,7 +585,7 @@ suite("test_unique_model_schema_value_change1","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice', 1.8,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:48:26', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]')," +
@@ -834,7 +836,7 @@ suite("test_unique_model_schema_value_change1","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice', 1.8,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:48:26', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]')," +
diff --git
a/regression-test/suites/schema_change_p0/test_unique_model_schema_value_change2.groovy
b/regression-test/suites/schema_change_p0/test_unique_model_schema_value_change2.groovy
index 63f501d01c2..021835030bc 100644
---
a/regression-test/suites/schema_change_p0/test_unique_model_schema_value_change2.groovy
+++
b/regression-test/suites/schema_change_p0/test_unique_model_schema_value_change2.groovy
@@ -16,8 +16,10 @@
// under the License.
suite("test_unique_model_schema_value_change2", "p0") {
- def tbName = "test_unique_model_schema_value_change2"
- def tbName2 = "test_unique_model_schema_value_change_2"
+ def tbName = "test_unique_model_value_change2"
+ def tbName2 = "test_unique_model_value_change_2"
+ def on_write = getRandomBoolean()
+ println String.format("current enable_unique_key_merge_on_write is : %s
",on_write)
//Test the unique model by adding a value column
sql """ DROP TABLE IF EXISTS ${tbName} """
def initTable = " CREATE TABLE IF NOT EXISTS ${tbName}\n" +
@@ -35,7 +37,7 @@ suite("test_unique_model_schema_value_change2", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
def initTableData = "insert into ${tbName} values(123456789, 'Alice',
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00')," +
@@ -76,7 +78,7 @@ suite("test_unique_model_schema_value_change2", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice', 1.83,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]')," +
@@ -288,7 +290,7 @@ suite("test_unique_model_schema_value_change2", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData1 = "insert into ${tbName2} values(123456789, 'Alice', 1.83,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]')," +
@@ -336,7 +338,7 @@ suite("test_unique_model_schema_value_change2", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData1 = "insert into ${tbName2} values(123456789, 'Alice', 1.83,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]')," +
@@ -408,7 +410,7 @@ suite("test_unique_model_schema_value_change2", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice', 1.83,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]')," +
@@ -635,7 +637,7 @@ suite("test_unique_model_schema_value_change2", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData1 = "insert into ${tbName2} values(123456789, 'Alice', 1.83,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]')," +
@@ -706,7 +708,7 @@ suite("test_unique_model_schema_value_change2", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice', 1.83,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]')," +
diff --git
a/regression-test/suites/schema_change_p0/test_unique_model_schema_value_change3.groovy
b/regression-test/suites/schema_change_p0/test_unique_model_schema_value_change3.groovy
index dda857a56a9..7dac3bcbe4f 100644
---
a/regression-test/suites/schema_change_p0/test_unique_model_schema_value_change3.groovy
+++
b/regression-test/suites/schema_change_p0/test_unique_model_schema_value_change3.groovy
@@ -16,8 +16,10 @@
// under the License.
suite("test_unique_model_schema_value_change3", "p0") {
- def tbName = "test_unique_model_schema_value_change3"
- def tbName2 = "test_unique_model_schema_value_change_3"
+ def tbName = "test_unique_model_value_change3"
+ def tbName2 = "test_unique_model_value_change_3"
+ def on_write = getRandomBoolean()
+ println String.format("current enable_unique_key_merge_on_write is : %s
",on_write)
//Test the unique model by adding a value column
sql """ DROP TABLE IF EXISTS ${tbName} """
def initTable = " CREATE TABLE IF NOT EXISTS ${tbName}\n" +
@@ -35,7 +37,7 @@ suite("test_unique_model_schema_value_change3", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
def initTableData = "insert into ${tbName} values(123456789, 'Alice',
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00')," +
@@ -76,7 +78,7 @@ suite("test_unique_model_schema_value_change3", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice', 1.83,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]')," +
@@ -321,7 +323,7 @@ suite("test_unique_model_schema_value_change3", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice', 1.83,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]')," +
diff --git
a/regression-test/suites/schema_change_p0/test_unique_model_schema_value_change_drop.groovy
b/regression-test/suites/schema_change_p0/test_unique_model_schema_value_change_drop.groovy
index 9e169bad6e1..cc3f7d740b0 100644
---
a/regression-test/suites/schema_change_p0/test_unique_model_schema_value_change_drop.groovy
+++
b/regression-test/suites/schema_change_p0/test_unique_model_schema_value_change_drop.groovy
@@ -18,6 +18,8 @@
suite("test_unique_model_schema_value_drop", "p0") {
def tbName = "test_unique_model_schema_value_drop"
def tbName2 = "test_unique_model_schema_value_drop_1"
+ def on_write = getRandomBoolean()
+ println String.format("current enable_unique_key_merge_on_write is : %s
",on_write)
sql """ DROP TABLE IF EXISTS ${tbName} """
def initTable1 = ""
def initTableData1 = ""
@@ -56,7 +58,7 @@ suite("test_unique_model_schema_value_drop", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
def initTableData = "insert into ${tbName} values(1, 'John Doe', 95.5,
'New York', 25, 1, 1234567890, true, 10, 1000000000, '2024-06-11',
'2024-06-11', '2024-06-11 08:30:00', '2024-06-11 08:30:00', 'Test String 1',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]')," +
@@ -100,7 +102,7 @@ suite("test_unique_model_schema_value_drop", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData1 = "insert into ${tbName2} values(1, 'John Doe', 95.5, 'New
York', 25, 1, 1234567890, 10, 1000000000, '2024-06-11', '2024-06-11',
'2024-06-11 08:30:00', '2024-06-11 08:30:00', 'Test String 1', {'a': 100, 'b':
200}, '[\"abc\", \"def\"]')," +
@@ -151,7 +153,7 @@ suite("test_unique_model_schema_value_drop", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData1 = "insert into ${tbName2} values(1, 'John Doe', 95.5, 'New
York', 25, 1234567890, true, 10, 1000000000, '2024-06-11', '2024-06-11',
'2024-06-11 08:30:00', '2024-06-11 08:30:00', 'Test String 1', {'a': 100, 'b':
200}, '[\"abc\", \"def\"]')," +
@@ -202,7 +204,7 @@ suite("test_unique_model_schema_value_drop", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData1 = "insert into ${tbName2} values(1, 'John Doe', 95.5, 'New
York', 1, 1234567890, true, 10, 1000000000, '2024-06-11', '2024-06-11',
'2024-06-11 08:30:00', '2024-06-11 08:30:00', 'Test String 1', {'a': 100, 'b':
200}, '[\"abc\", \"def\"]')," +
@@ -253,7 +255,7 @@ suite("test_unique_model_schema_value_drop", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData1 = "insert into ${tbName2} values(1, 'John Doe', 95.5, 'New
York', 25, 1, 1234567890, true, 1000000000, '2024-06-11', '2024-06-11',
'2024-06-11 08:30:00', '2024-06-11 08:30:00', 'Test String 1', {'a': 100, 'b':
200}, '[\"abc\", \"def\"]')," +
@@ -304,7 +306,7 @@ suite("test_unique_model_schema_value_drop", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData1 = "insert into ${tbName2} values(1, 'John Doe', 95.5, 'New
York', 25, 1, 1234567890, true, 10, '2024-06-11', '2024-06-11', '2024-06-11
08:30:00', '2024-06-11 08:30:00', 'Test String 1', {'a': 100, 'b': 200},
'[\"abc\", \"def\"]')," +
@@ -355,7 +357,7 @@ suite("test_unique_model_schema_value_drop", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData1 = "insert into ${tbName2} values(1, 'John Doe', 95.5, 'New
York', 25, 1, true, 10, 1000000000, '2024-06-11', '2024-06-11', '2024-06-11
08:30:00', '2024-06-11 08:30:00', 'Test String 1', {'a': 100, 'b': 200},
'[\"abc\", \"def\"]')," +
@@ -406,7 +408,7 @@ suite("test_unique_model_schema_value_drop", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData1 = "insert into ${tbName2} values(1, 'John Doe', 95.5, 'New
York', 25, 1, 1234567890, true, 10, 1000000000, '2024-06-11', '2024-06-11
08:30:00', '2024-06-11 08:30:00', 'Test String 1', {'a': 100, 'b': 200},
'[\"abc\", \"def\"]')," +
@@ -457,7 +459,7 @@ suite("test_unique_model_schema_value_drop", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData1 = "insert into ${tbName2} values(1, 'John Doe', 95.5, 'New
York', 25, 1, 1234567890, true, 10, 1000000000, '2024-06-11', '2024-06-11
08:30:00', '2024-06-11 08:30:00', 'Test String 1', {'a': 100, 'b': 200},
'[\"abc\", \"def\"]')," +
@@ -508,7 +510,7 @@ suite("test_unique_model_schema_value_drop", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData1 = "insert into ${tbName2} values(1, 'John Doe', 95.5, 'New
York', 25, 1, 1234567890, true, 10, 1000000000, '2024-06-11', '2024-06-11',
'2024-06-11 08:30:00', 'Test String 1', {'a': 100, 'b': 200}, '[\"abc\",
\"def\"]')," +
@@ -559,7 +561,7 @@ suite("test_unique_model_schema_value_drop", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData1 = "insert into ${tbName2} values(1, 'John Doe', 95.5, 'New
York', 25, 1, 1234567890, true, 10, 1000000000, '2024-06-11', '2024-06-11',
'2024-06-11 08:30:00', 'Test String 1', {'a': 100, 'b': 200}, '[\"abc\",
\"def\"]')," +
@@ -610,7 +612,7 @@ suite("test_unique_model_schema_value_drop", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData1 = "insert into ${tbName2} values(1, 'John Doe', 95.5, 'New
York', 25, 1, 1234567890, true, 10, 1000000000, '2024-06-11', '2024-06-11',
'2024-06-11 08:30:00', 'Test String 1', {'a': 100, 'b': 200}, '[\"abc\",
\"def\"]')," +
@@ -661,7 +663,7 @@ suite("test_unique_model_schema_value_drop", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData1 = "insert into ${tbName2} values(1, 'John Doe', 95.5, 25,
1, 1234567890, true, 10, 1000000000, '2024-06-11', '2024-06-11', '2024-06-11
08:30:00', '2024-06-11 08:30:00', 'Test String 1', {'a': 100, 'b': 200},
'[\"abc\", \"def\"]')," +
@@ -712,7 +714,7 @@ suite("test_unique_model_schema_value_drop", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData1 = "insert into ${tbName2} values(1, 95.5, 'New York', 25,
1, 1234567890, true, 10, 1000000000, '2024-06-11', '2024-06-11', '2024-06-11
08:30:00', '2024-06-11 08:30:00', 'Test String 1', {'a': 100, 'b': 200},
'[\"abc\", \"def\"]')," +
@@ -763,7 +765,7 @@ suite("test_unique_model_schema_value_drop", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData1 = "insert into ${tbName2} values(1, 'John Doe', 95.5, 'New
York', 25, 1, 1234567890, true, 10, 1000000000, '2024-06-11', '2024-06-11',
'2024-06-11 08:30:00', '2024-06-11 08:30:00', {'a': 100, 'b': 200}, '[\"abc\",
\"def\"]')," +
@@ -814,7 +816,7 @@ suite("test_unique_model_schema_value_drop", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData1 = "insert into ${tbName2} values(1, 'John Doe', 95.5, 'New
York', 25, 1, 1234567890, true, 10, 1000000000, '2024-06-11', '2024-06-11',
'2024-06-11 08:30:00', '2024-06-11 08:30:00', 'Test String 1', '[\"abc\",
\"def\"]')," +
@@ -865,7 +867,7 @@ suite("test_unique_model_schema_value_drop", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData1 = "insert into ${tbName2} values(1, 'John Doe', 95.5, 'New
York', 25, 1, 1234567890, true, 10, 1000000000, '2024-06-11', '2024-06-11',
'2024-06-11 08:30:00', '2024-06-11 08:30:00', 'Test String 1', {'a': 100, 'b':
200})," +
@@ -892,7 +894,7 @@ suite("test_unique_model_schema_value_drop", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(1, 123.4567890123, 123.45,
1234.5678901234)," +
@@ -924,7 +926,7 @@ suite("test_unique_model_schema_value_drop", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData1 = "insert into ${tbName2} values(1, 123.45,
1234.5678901234)," +
@@ -962,7 +964,7 @@ suite("test_unique_model_schema_value_drop", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData1 = "insert into ${tbName2} values(1, 123.4567890123,
1234.5678901234)," +
@@ -1000,7 +1002,7 @@ suite("test_unique_model_schema_value_drop", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData1 = "insert into ${tbName2} values(1, 123.4567890123,
123.45)," +
diff --git
a/regression-test/suites/schema_change_p0/test_unique_schema_key_change_add.groovy
b/regression-test/suites/schema_change_p0/test_unique_schema_key_change_add.groovy
index cd9eb869efa..3894ba19478 100644
---
a/regression-test/suites/schema_change_p0/test_unique_schema_key_change_add.groovy
+++
b/regression-test/suites/schema_change_p0/test_unique_schema_key_change_add.groovy
@@ -17,7 +17,8 @@
suite("test_unique_schema_key_change_add","p0") {
def tbName = "test_unique_schema_key_change_add"
-
+ def on_write = getRandomBoolean()
+ println String.format("current enable_unique_key_merge_on_write is : %s
",on_write)
//Test the unique model by adding a key column
sql """ DROP TABLE IF EXISTS ${tbName} """
def initTable = " CREATE TABLE IF NOT EXISTS ${tbName}\n" +
@@ -35,7 +36,7 @@ suite("test_unique_schema_key_change_add","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
def initTableData = "insert into ${tbName} values(123456789, 'Alice',
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00')," +
diff --git
a/regression-test/suites/schema_change_p0/test_unique_model_schema_key_drop.groovy
b/regression-test/suites/schema_change_p0/test_unique_schema_key_change_drop.groovy
similarity index 97%
rename from
regression-test/suites/schema_change_p0/test_unique_model_schema_key_drop.groovy
rename to
regression-test/suites/schema_change_p0/test_unique_schema_key_change_drop.groovy
index 39a72f35622..92c52f78350 100644
---
a/regression-test/suites/schema_change_p0/test_unique_model_schema_key_drop.groovy
+++
b/regression-test/suites/schema_change_p0/test_unique_schema_key_change_drop.groovy
@@ -15,13 +15,15 @@
// specific language governing permissions and limitations
// under the License.
-suite("test_unique_model_schema_key_drop", "p0") {
- def tbName = "test_unique_model_schema_key_drop"
+suite("test_unique_schema_key_change_drop", "p0") {
+ def tbName = "test_unique_schema_key_change_drop"
def tbName2 = "test_unique_model_schema_key_drop_1"
sql """ DROP TABLE IF EXISTS ${tbName} """
def getTableStatusSql = " SHOW ALTER TABLE COLUMN WHERE
IndexName='${tbName}' ORDER BY createtime DESC LIMIT 1 "
def errorMessage = ""
def insertSql = "insert into ${tbName} values(123456689, 'Alice', '四川省',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00');"
+ def on_write = getRandomBoolean()
+ println String.format("current enable_unique_key_merge_on_write is : %s
",on_write)
/**
@@ -50,7 +52,7 @@ suite("test_unique_model_schema_key_drop", "p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
def initTableData = "insert into ${tbName} values(1, 'John Doe', 95.5,
'New York', 25, 1, 1234567890, true, 10, 1000000000, '2024-06-11',
'2024-06-11', '2024-06-11 08:30:00', '2024-06-11 08:30:00')," +
diff --git
a/regression-test/suites/schema_change_p0/test_unique_schema_key_change_modify.groovy
b/regression-test/suites/schema_change_p0/test_unique_schema_key_change_modify.groovy
index ad7877c1663..36f0feae978 100644
---
a/regression-test/suites/schema_change_p0/test_unique_schema_key_change_modify.groovy
+++
b/regression-test/suites/schema_change_p0/test_unique_schema_key_change_modify.groovy
@@ -18,6 +18,8 @@
suite("test_unique_schema_key_change_modify","p0") {
def tbName = "test_unique_schema_key_change_modify_1"
def tbName2 = "test_unique_schema_key_change_modify_2"
+ def on_write = getRandomBoolean()
+ println String.format("current enable_unique_key_merge_on_write is : %s
",on_write)
/**
* Test the unique model by modify a value type
*/
@@ -40,7 +42,7 @@ suite("test_unique_schema_key_change_modify","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
def initTableData = "insert into ${tbName} values(123456789, 'Alice', 0,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00')," +
@@ -200,7 +202,7 @@ suite("test_unique_schema_key_change_modify","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice', 1,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00')," +
@@ -226,7 +228,6 @@ suite("test_unique_schema_key_change_modify","p0") {
-
// Test the unique model by modify a key type from TINYINT to SMALLINT
sql initTable
sql initTableData
@@ -374,7 +375,7 @@ suite("test_unique_schema_key_change_modify","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice', 13243,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00')," +
@@ -551,7 +552,7 @@ suite("test_unique_schema_key_change_modify","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice',
2147483641, 'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00')," +
@@ -737,7 +738,7 @@ suite("test_unique_schema_key_change_modify","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice',
2147483641, 'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00')," +
@@ -927,7 +928,7 @@ suite("test_unique_schema_key_change_modify","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice',
2147483641, 'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00')," +
@@ -1090,7 +1091,7 @@ suite("test_unique_schema_key_change_modify","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData2 = "insert into ${tbName2} values(123456789, 'Alice',
2147483641, 'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00')," +
@@ -1156,7 +1157,7 @@ suite("test_unique_schema_key_change_modify","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice', 1.8,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00')," +
@@ -1340,7 +1341,7 @@ suite("test_unique_schema_key_change_modify","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice', 1.8,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00')," +
@@ -1522,7 +1523,7 @@ suite("test_unique_schema_key_change_modify","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice', 1.8,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00')," +
@@ -1684,7 +1685,7 @@ suite("test_unique_schema_key_change_modify","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData2 = "insert into ${tbName2} values(123456789, 'Alice',
'1.8000000000', 'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00')," +
@@ -1738,7 +1739,7 @@ suite("test_unique_schema_key_change_modify","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice',
'2022-01-01', 0, 'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00')," +
@@ -1913,7 +1914,7 @@ suite("test_unique_schema_key_change_modify","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice', 0,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01',
'2022-01-01 10:00:00')," +
@@ -2086,7 +2087,7 @@ suite("test_unique_schema_key_change_modify","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice', 0,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01',
'2022-01-01 10:00:00')," +
@@ -2260,7 +2261,7 @@ suite("test_unique_schema_key_change_modify","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice', 0,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01',
'2022-01-01 10:00:00')," +
@@ -2434,7 +2435,7 @@ suite("test_unique_schema_key_change_modify","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice',
'2022-01-01', 0, 'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00')," +
@@ -2607,7 +2608,7 @@ suite("test_unique_schema_key_change_modify","p0") {
" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1\n" +
" PROPERTIES (\n" +
" \"replication_allocation\" = \"tag.location.default:
1\",\n" +
- " \"enable_unique_key_merge_on_write\" = \"true\"\n" +
+ " \"enable_unique_key_merge_on_write\" =
\"${on_write}\"\n" +
" );"
initTableData = "insert into ${tbName} values(123456789, 'Alice', 0,
'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01',
'2022-01-01 10:00:00')," +
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
