You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by da...@apache.org on 2024/06/12 13:58:47 UTC
(doris) branch master updated: [enhancement](regression-test) drop a key type tests (#36178)
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 d0b6769fbd5 [enhancement](regression-test) drop a key type tests (#36178)
d0b6769fbd5 is described below
commit d0b6769fbd5f4c3265655cc229f465e8b8c20121
Author: kkop <ju...@gmail.com>
AuthorDate: Wed Jun 12 21:58:40 2024 +0800
[enhancement](regression-test) drop a key type tests (#36178)
---
.../test_unique_model_schema_value_add.out | 151 +++++++++++
.../test_unique_model_schema_value_change.out | 150 -----------
.../test_unique_model_schema_key_drop.groovy | 242 ++++++++++++++++++
.../test_unique_model_schema_value_add.groovy | 279 +++++++++++++++++++++
.../test_unique_model_schema_value_change.groovy | 261 +------------------
5 files changed, 674 insertions(+), 409 deletions(-)
diff --git a/regression-test/data/schema_change_p0/test_unique_model_schema_value_add.out b/regression-test/data/schema_change_p0/test_unique_model_schema_value_add.out
new file mode 100644
index 00000000000..767314cf85e
--- /dev/null
+++ b/regression-test/data/schema_change_p0/test_unique_model_schema_value_add.out
@@ -0,0 +1,151 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- ! --
+123456789 Alice 广东省 Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+234567890 Bob 广东省 Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
+345678901 Carol 广东省 Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
+456789012 Dave 广东省 Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
+567890123 Eve 广东省 Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
+678901234 Frank 广东省 Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
+789012345 Grace 广东省 Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
+123456689 Alice 四川省 Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+
+-- ! --
+123456789 Alice false Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+234567890 Bob false Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
+345678901 Carol false Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
+456789012 Dave false Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
+567890123 Eve false Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
+678901234 Frank false Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
+789012345 Grace false Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
+123456689 Alice true Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+
+-- ! --
+123456789 Alice 0 Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+234567890 Bob 0 Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
+345678901 Carol 0 Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
+456789012 Dave 0 Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
+567890123 Eve 0 Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
+678901234 Frank 0 Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
+789012345 Grace 0 Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
+123456689 Alice 1 Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+
+-- ! --
+123456789 Alice 999 Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+234567890 Bob 999 Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
+345678901 Carol 999 Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
+456789012 Dave 999 Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
+567890123 Eve 999 Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
+678901234 Frank 999 Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
+789012345 Grace 999 Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
+123456689 Alice 567 Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+
+-- ! --
+123456789 Alice 999 Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+234567890 Bob 999 Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
+345678901 Carol 999 Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
+456789012 Dave 999 Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
+567890123 Eve 999 Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
+678901234 Frank 999 Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
+789012345 Grace 999 Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
+123456689 Alice 2 Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+
+-- ! --
+123456789 Alice 99999991 Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+234567890 Bob 99999991 Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
+345678901 Carol 99999991 Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
+456789012 Dave 99999991 Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
+567890123 Eve 99999991 Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
+678901234 Frank 99999991 Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
+789012345 Grace 99999991 Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
+123456689 Alice 88889494646 Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+
+-- ! --
+123456789 Alice 9999 Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+234567890 Bob 9999 Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
+345678901 Carol 9999 Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
+456789012 Dave 9999 Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
+567890123 Eve 9999 Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
+678901234 Frank 9999 Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
+789012345 Grace 9999 Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
+123456689 Alice 555888555 Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+
+-- ! --
+123456789 Alice 166.689 Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+234567890 Bob 166.689 Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
+345678901 Carol 166.689 Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
+456789012 Dave 166.689 Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
+567890123 Eve 166.689 Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
+678901234 Frank 166.689 Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
+789012345 Grace 166.689 Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
+123456689 Alice 189.479 Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+
+-- ! --
+123456789 Alice 16899.6464689000 Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+234567890 Bob 16899.6464689000 Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
+345678901 Carol 16899.6464689000 Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
+456789012 Dave 16899.6464689000 Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
+567890123 Eve 16899.6464689000 Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
+678901234 Frank 16899.6464689000 Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
+789012345 Grace 16899.6464689000 Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
+123456689 Alice 16499.6464689000 Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+
+-- ! --
+123456789 Alice 1997-01-01 Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+234567890 Bob 1997-01-01 Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
+345678901 Carol 1997-01-01 Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
+456789012 Dave 1997-01-01 Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
+567890123 Eve 1997-01-01 Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
+678901234 Frank 1997-01-01 Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
+789012345 Grace 1997-01-01 Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
+123456689 Alice 2024-01-01 Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+
+-- ! --
+123456789 Alice 1997-01-01T00:00 Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+234567890 Bob 1997-01-01T00:00 Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
+345678901 Carol 1997-01-01T00:00 Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
+456789012 Dave 1997-01-01T00:00 Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
+567890123 Eve 1997-01-01T00:00 Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
+678901234 Frank 1997-01-01T00:00 Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
+789012345 Grace 1997-01-01T00:00 Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
+123456689 Alice 2024-01-04T09:00 Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+
+-- ! --
+123456789 Alice 0 Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+234567890 Bob 0 Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
+345678901 Carol 0 Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
+456789012 Dave 0 Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
+567890123 Eve 0 Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
+678901234 Frank 0 Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
+789012345 Grace 0 Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
+123456689 Alice 1 Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+
+-- ! --
+123456789 Alice 我是小说家 Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+234567890 Bob 我是小说家 Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
+345678901 Carol 我是小说家 Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
+456789012 Dave 我是小说家 Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
+567890123 Eve 我是小说家 Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
+678901234 Frank 我是小说家 Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
+789012345 Grace 我是小说家 Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
+123456689 Alice 我是侦探家 Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+
+-- ! --
+123456789 Alice \N Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+234567890 Bob \N Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
+345678901 Carol \N Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
+456789012 Dave \N Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
+567890123 Eve \N Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
+678901234 Frank \N Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
+789012345 Grace \N Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
+123456689 Alice {"a":100, "b":200} Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+
+-- ! --
+123456789 Alice \N Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+234567890 Bob \N Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
+345678901 Carol \N Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
+456789012 Dave \N Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
+567890123 Eve \N Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
+678901234 Frank \N Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
+789012345 Grace \N Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
+123456689 Alice {"k1":"v31","k2":300} Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
+
diff --git a/regression-test/data/schema_change_p0/test_unique_model_schema_value_change.out b/regression-test/data/schema_change_p0/test_unique_model_schema_value_change.out
index 1fec9504555..10c43a9d49f 100644
--- a/regression-test/data/schema_change_p0/test_unique_model_schema_value_change.out
+++ b/regression-test/data/schema_change_p0/test_unique_model_schema_value_change.out
@@ -1,154 +1,4 @@
-- This file is automatically generated. You should know what you did if you want to edit this
--- ! --
-123456789 Alice 广东省 Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-234567890 Bob 广东省 Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
-345678901 Carol 广东省 Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
-456789012 Dave 广东省 Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
-567890123 Eve 广东省 Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
-678901234 Frank 广东省 Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
-789012345 Grace 广东省 Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice 四川省 Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-
--- ! --
-123456789 Alice false Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-234567890 Bob false Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
-345678901 Carol false Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
-456789012 Dave false Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
-567890123 Eve false Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
-678901234 Frank false Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
-789012345 Grace false Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice true Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-
--- ! --
-123456789 Alice 0 Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-234567890 Bob 0 Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
-345678901 Carol 0 Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
-456789012 Dave 0 Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
-567890123 Eve 0 Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
-678901234 Frank 0 Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
-789012345 Grace 0 Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice 1 Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-
--- ! --
-123456789 Alice 999 Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-234567890 Bob 999 Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
-345678901 Carol 999 Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
-456789012 Dave 999 Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
-567890123 Eve 999 Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
-678901234 Frank 999 Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
-789012345 Grace 999 Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice 567 Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-
--- ! --
-123456789 Alice 999 Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-234567890 Bob 999 Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
-345678901 Carol 999 Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
-456789012 Dave 999 Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
-567890123 Eve 999 Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
-678901234 Frank 999 Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
-789012345 Grace 999 Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice 2 Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-
--- ! --
-123456789 Alice 99999991 Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-234567890 Bob 99999991 Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
-345678901 Carol 99999991 Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
-456789012 Dave 99999991 Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
-567890123 Eve 99999991 Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
-678901234 Frank 99999991 Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
-789012345 Grace 99999991 Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice 88889494646 Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-
--- ! --
-123456789 Alice 9999 Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-234567890 Bob 9999 Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
-345678901 Carol 9999 Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
-456789012 Dave 9999 Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
-567890123 Eve 9999 Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
-678901234 Frank 9999 Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
-789012345 Grace 9999 Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice 555888555 Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-
--- ! --
-123456789 Alice 166.689 Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-234567890 Bob 166.689 Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
-345678901 Carol 166.689 Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
-456789012 Dave 166.689 Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
-567890123 Eve 166.689 Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
-678901234 Frank 166.689 Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
-789012345 Grace 166.689 Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice 189.479 Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-
--- ! --
-123456789 Alice 16899.6464689000 Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-234567890 Bob 16899.6464689000 Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
-345678901 Carol 16899.6464689000 Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
-456789012 Dave 16899.6464689000 Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
-567890123 Eve 16899.6464689000 Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
-678901234 Frank 16899.6464689000 Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
-789012345 Grace 16899.6464689000 Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice 16499.6464689000 Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-
--- ! --
-123456789 Alice 1997-01-01 Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-234567890 Bob 1997-01-01 Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
-345678901 Carol 1997-01-01 Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
-456789012 Dave 1997-01-01 Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
-567890123 Eve 1997-01-01 Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
-678901234 Frank 1997-01-01 Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
-789012345 Grace 1997-01-01 Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice 2024-01-01 Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-
--- ! --
-123456789 Alice 1997-01-01T00:00 Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-234567890 Bob 1997-01-01T00:00 Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
-345678901 Carol 1997-01-01T00:00 Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
-456789012 Dave 1997-01-01T00:00 Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
-567890123 Eve 1997-01-01T00:00 Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
-678901234 Frank 1997-01-01T00:00 Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
-789012345 Grace 1997-01-01T00:00 Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice 2024-01-04T09:00 Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-
--- ! --
-123456789 Alice 0 Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-234567890 Bob 0 Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
-345678901 Carol 0 Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
-456789012 Dave 0 Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
-567890123 Eve 0 Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
-678901234 Frank 0 Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
-789012345 Grace 0 Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice 1 Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-
--- ! --
-123456789 Alice 我是小说家 Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-234567890 Bob 我是小说家 Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
-345678901 Carol 我是小说家 Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
-456789012 Dave 我是小说家 Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
-567890123 Eve 我是小说家 Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
-678901234 Frank 我是小说家 Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
-789012345 Grace 我是小说家 Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice 我是侦探家 Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-
--- ! --
-123456789 Alice \N Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-234567890 Bob \N Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
-345678901 Carol \N Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
-456789012 Dave \N Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
-567890123 Eve \N Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
-678901234 Frank \N Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
-789012345 Grace \N Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice {"a":100, "b":200} Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-
--- ! --
-123456789 Alice \N Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-234567890 Bob \N Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
-345678901 Carol \N Guangzhou 28 0 13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
-456789012 Dave \N Shenzhen 35 1 13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
-567890123 Eve \N Chengdu 27 0 13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
-678901234 Frank \N Hangzhou 32 1 13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
-789012345 Grace \N Xian 29 0 13333333333 No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice {"k1":"v31","k2":300} Yaan 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-
-- ! --
123456789 Alice 1 Beijing 25 0 13812345678 No. 123 Street, Beijing 2022-01-01T10:00
234567890 Bob 1 Shanghai 30 1 13998765432 No. 456 Street, Shanghai 2022-02-02T12: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_model_schema_key_drop.groovy
new file mode 100644
index 00000000000..39a72f35622
--- /dev/null
+++ b/regression-test/suites/schema_change_p0/test_unique_model_schema_key_drop.groovy
@@ -0,0 +1,242 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// 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"
+ 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');"
+
+
+ /**
+ * Test the unique model by dorp a key type
+ */
+
+ sql """ DROP TABLE IF EXISTS ${tbName} """
+ def initTable = " CREATE TABLE IF NOT EXISTS ${tbName}\n" +
+ " (\n" +
+ " `user_id` LARGEINT NOT NULL COMMENT \"用户id\",\n" +
+ " `username` VARCHAR(50) NOT NULL COMMENT \"用户昵称\",\n" +
+ " `score` DECIMAL(38,10) COMMENT \"分数\",\n" +
+ " `city` CHAR(20) COMMENT \"用户所在城市\",\n" +
+ " `age` SMALLINT COMMENT \"用户年龄\",\n" +
+ " `sex` TINYINT COMMENT \"用户性别\",\n" +
+ " `phone` LARGEINT COMMENT \"用户电话\",\n" +
+ " `is_ok` BOOLEAN COMMENT \"是否完成\",\n" +
+ " `t_int` INT COMMENT \"测试int\",\n" +
+ " `t_bigint` BIGINT COMMENT \"测试BIGINT\",\n" +
+ " `t_date` DATE COMMENT \"测试DATE\",\n" +
+ " `t_datev2` DATEV2 COMMENT \"测试DATEV2\",\n" +
+ " `t_datetimev2` DATETIMEV2 COMMENT \"测试DATETIMEV2\",\n" +
+ " `t_datetime` DATETIME COMMENT \"用户注册时间\"\n" +
+ " )\n" +
+ " UNIQUE KEY(`user_id`, `username`, `score`, `city`, `age`, `sex`, `phone`,`is_ok`, `t_int`, `t_bigint`, `t_date`, `t_datev2`, `t_datetimev2`, `t_datetime`)\n" +
+ " 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" +
+ " );"
+
+ 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')," +
+ " (2, 'Jane Smith', 85.2, 'Los Angeles', 30, 2, 9876543210, false, 20, 2000000000, '2024-06-12', '2024-06-12', '2024-06-12 09:45:00', '2024-06-12 09:45:00')," +
+ " (3, 'Mike Johnson', 77.8, 'Chicago', 35, 1, 1112223334, true, 30, 3000000000, '2024-06-13', '2024-06-13', '2024-06-13 11:15:00', '2024-06-13 11:15:00')," +
+ " (4, 'Emily Brown', 92.0, 'San Francisco', 28, 2, 5556667778, true, 40, 4000000000, '2024-06-14', '2024-06-14', '2024-06-14 13:30:00', '2024-06-14 13:30:00')," +
+ " (5, 'David Wilson', 88.9, 'Seattle', 32, 1, 9998887776, false, 50, 5000000000, '2024-06-15', '2024-06-15', '2024-06-15 15:45:00', '2024-06-15 15:45:00');"
+
+ //TODO Test the unique model by drop a key type from BOOLEAN
+ errorMessage = "errCode = 2, detailMessage = Can not drop key column in Unique data model table"
+ expectException({
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} DROP column is_ok """
+ insertSql = "insert into ${tbName} values(6, 'Sophia Lee', 91.3, 'Boston', 29, 2, 7778889990, 60, 6000000000, '2024-06-16', '2024-06-16', '2024-06-16 17:00:00', '2024-06-16 17:00:00', 'Test String 6', {'a': 500, 'b': 200}, '{\"k1\":\"v1\", \"k2\": 200}'); "
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true, "${tbName}")
+ }, errorMessage)
+
+
+ //TODO Test the unique model by drop a key type from TINYINT
+ errorMessage = "errCode = 2, detailMessage = Can not drop key column in Unique data model table"
+ expectException({
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} DROP column sex """
+ insertSql = "insert into ${tbName} values(6, 'Sophia Lee', 91.3, 'Boston', 29, 7778889990, true, 60, 6000000000, '2024-06-16', '2024-06-16', '2024-06-16 17:00:00', '2024-06-16 17:00:00', 'Test String 6', {'a': 500, 'b': 200}, '{\"k1\":\"v1\", \"k2\": 200}'); "
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true, "${tbName}")
+ }, errorMessage)
+
+
+ //TODO Test the unique model by drop a key type from SMALLINT
+ errorMessage = "errCode = 2, detailMessage = Can not drop key column in Unique data model table"
+ expectException({
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} DROP column age """
+ insertSql = "insert into ${tbName} values(6, 'Sophia Lee', 91.3, 'Boston', 2, 7778889990, true, 60, 6000000000, '2024-06-16', '2024-06-16', '2024-06-16 17:00:00', '2024-06-16 17:00:00', 'Test String 6', {'a': 500, 'b': 200}, '{\"k1\":\"v1\", \"k2\": 200}'); "
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true, "${tbName}")
+ }, errorMessage)
+
+ //TODO Test the unique model by drop a key type from INT
+ errorMessage = "errCode = 2, detailMessage = Can not drop key column in Unique data model table"
+ expectException({
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} DROP column t_int """
+ insertSql = "insert into ${tbName} values(6, 'Sophia Lee', 91.3, 'Boston', 29, 2, 7778889990, true, 6000000000, '2024-06-16', '2024-06-16', '2024-06-16 17:00:00', '2024-06-16 17:00:00', 'Test String 6', {'a': 500, 'b': 200}, '{\"k1\":\"v1\", \"k2\": 200}'); "
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true, "${tbName}")
+ }, errorMessage)
+
+
+ //TODO Test the unique model by drop a key type from BIGINT
+ errorMessage = "errCode = 2, detailMessage = Can not drop key column in Unique data model table"
+ expectException({
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} DROP column t_bigint """
+ insertSql = "insert into ${tbName} values(6, 'Sophia Lee', 91.3, 'Boston', 29, 2, 7778889990, true, 60, '2024-06-16', '2024-06-16', '2024-06-16 17:00:00', '2024-06-16 17:00:00', 'Test String 6', {'a': 500, 'b': 200}, '{\"k1\":\"v1\", \"k2\": 200}'); "
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true, "${tbName}")
+ }, errorMessage)
+
+
+ //TODO Test the unique model by drop a key type from LARGEINT
+ errorMessage = "errCode = 2, detailMessage = Can not drop key column in Unique data model table"
+ expectException({
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} DROP column phone """
+ insertSql = "insert into ${tbName} values(6, 'Sophia Lee', 91.3, 'Boston', 29, 2, true, 60, 6000000000, '2024-06-16', '2024-06-16', '2024-06-16 17:00:00', '2024-06-16 17:00:00', 'Test String 6', {'a': 500, 'b': 200}, '{\"k1\":\"v1\", \"k2\": 200}'); "
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true, "${tbName}")
+ }, errorMessage)
+
+ //TODO Test the unique model by drop a key type from DATE
+ errorMessage = "errCode = 2, detailMessage = Can not drop key column in Unique data model table"
+ expectException({
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} DROP column t_date """
+ insertSql = "insert into ${tbName} values(6, 'Sophia Lee', 91.3, 'Boston', 29, 2, 7778889990, true, 60, 6000000000, '2024-06-16', '2024-06-16 17:00:00', '2024-06-16 17:00:00', 'Test String 6', {'a': 500, 'b': 200}, '{\"k1\":\"v1\", \"k2\": 200}'); "
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true, "${tbName}")
+ }, errorMessage)
+
+
+ //TODO Test the unique model by drop a key type from DATEV2
+ errorMessage = "errCode = 2, detailMessage = Can not drop key column in Unique data model table"
+ expectException({
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} DROP column t_datev2 """
+ insertSql = "insert into ${tbName} values(6, 'Sophia Lee', 91.3, 'Boston', 29, 2, 7778889990, true, 60, 6000000000, '2024-06-16', '2024-06-16 17:00:00', '2024-06-16 17:00:00', 'Test String 6', {'a': 500, 'b': 200}, '{\"k1\":\"v1\", \"k2\": 200}'); "
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true, "${tbName}")
+ }, errorMessage)
+
+
+ //TODO Test the unique model by drop a key type from t_datetimev2
+ errorMessage = "errCode = 2, detailMessage = Can not drop key column in Unique data model table"
+ expectException({
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} DROP column t_datetimev2 """
+ insertSql = "insert into ${tbName} values(6, 'Sophia Lee', 91.3, 'Boston', 29, 2, 7778889990, true, 60, 6000000000, '2024-06-16', '2024-06-16', '2024-06-16 17:00:00', 'Test String 6', {'a': 500, 'b': 200}, '{\"k1\":\"v1\", \"k2\": 200}'); "
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true, "${tbName}")
+ }, errorMessage)
+
+
+ //TODO Test the unique model by drop a key type from t_datetimev2
+ errorMessage = "errCode = 2, detailMessage = Can not drop key column in Unique data model table"
+ expectException({
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} DROP column t_datetimev2 """
+ insertSql = "insert into ${tbName} values(6, 'Sophia Lee', 91.3, 'Boston', 29, 2, 7778889990, true, 60, 6000000000, '2024-06-16', '2024-06-16', '2024-06-16 17:00:00', 'Test String 6', {'a': 500, 'b': 200}, '{\"k1\":\"v1\", \"k2\": 200}'); "
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true, "${tbName}")
+ }, errorMessage)
+
+
+ //TODO Test the unique model by drop a key type from t_datetime
+ errorMessage = "errCode = 2, detailMessage = Can not drop key column in Unique data model table"
+ expectException({
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} DROP column t_datetime """
+ insertSql = "insert into ${tbName} values(6, 'Sophia Lee', 91.3, 'Boston', 29, 2, 7778889990, true, 60, 6000000000, '2024-06-16', '2024-06-16', '2024-06-16 17:00:00', 'Test String 6', {'a': 500, 'b': 200}, '{\"k1\":\"v1\", \"k2\": 200}'); "
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true, "${tbName}")
+ }, errorMessage)
+
+
+ //TODO Test the unique model by drop a key type from CHAR
+ errorMessage = "errCode = 2, detailMessage = Can not drop key column in Unique data model table"
+ expectException({
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} DROP column city """
+ insertSql = "insert into ${tbName} values(6, 'Sophia Lee', 91.3, 29, 2, 7778889990, true, 60, 6000000000, '2024-06-16', '2024-06-16', '2024-06-16 17:00:00', '2024-06-16 17:00:00', 'Test String 6', {'a': 500, 'b': 200}, '{\"k1\":\"v1\", \"k2\": 200}'); "
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true, "${tbName}")
+ }, errorMessage)
+
+
+ //TODO Test the unique model by drop a key type from VARCHAR
+ errorMessage = "errCode = 2, detailMessage = Can not drop key column in Unique data model table"
+ expectException({
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} DROP column username """
+ insertSql = "insert into ${tbName} values(6, 91.3, 'Boston', 29, 2, 7778889990, true, 60, 6000000000, '2024-06-16', '2024-06-16', '2024-06-16 17:00:00', '2024-06-16 17:00:00', 'Test String 6', {'a': 500, 'b': 200}, '{\"k1\":\"v1\", \"k2\": 200}'); "
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true, "${tbName}")
+ }, errorMessage)
+
+
+}
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
new file mode 100644
index 00000000000..9b246e895b2
--- /dev/null
+++ b/regression-test/suites/schema_change_p0/test_unique_model_schema_value_add.groovy
@@ -0,0 +1,279 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+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"
+ //Test the unique model by adding a value column
+ sql """ DROP TABLE IF EXISTS ${tbName} """
+ def initTable = " CREATE TABLE IF NOT EXISTS ${tbName}\n" +
+ " (\n" +
+ " `user_id` LARGEINT NOT NULL COMMENT \"用户id\",\n" +
+ " `username` VARCHAR(50) NOT NULL COMMENT \"用户昵称\",\n" +
+ " `city` VARCHAR(20) COMMENT \"用户所在城市\",\n" +
+ " `age` SMALLINT COMMENT \"用户年龄\",\n" +
+ " `sex` TINYINT COMMENT \"用户性别\",\n" +
+ " `phone` LARGEINT COMMENT \"用户电话\",\n" +
+ " `address` VARCHAR(500) COMMENT \"用户地址\",\n" +
+ " `register_time` DATETIME COMMENT \"用户注册时间\"\n" +
+ " )\n" +
+ " UNIQUE KEY(`user_id`, `username`)\n" +
+ " 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" +
+ " );"
+
+ def initTableData = "insert into ${tbName} values(123456789, 'Alice', 'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00')," +
+ " (234567890, 'Bob', 'Shanghai', 30, 1, 13998765432, 'No. 456 Street, Shanghai', '2022-02-02 12:00:00')," +
+ " (345678901, 'Carol', 'Guangzhou', 28, 0, 13724681357, 'No. 789 Street, Guangzhou', '2022-03-03 14:00:00')," +
+ " (456789012, 'Dave', 'Shenzhen', 35, 1, 13680864279, 'No. 987 Street, Shenzhen', '2022-04-04 16:00:00')," +
+ " (567890123, 'Eve', 'Chengdu', 27, 0, 13572468091, 'No. 654 Street, Chengdu', '2022-05-05 18:00:00')," +
+ " (678901234, 'Frank', 'Hangzhou', 32, 1, 13467985213, 'No. 321 Street, Hangzhou', '2022-06-06 20:00:00')," +
+ " (789012345, 'Grace', 'Xian', 29, 0, 13333333333, 'No. 222 Street, Xian', '2022-07-07 22:00:00');"
+
+ //Test the unique model by adding a value column with VARCHAR
+ sql initTable
+ sql initTableData
+ def getTableStatusSql = " SHOW ALTER TABLE COLUMN WHERE IndexName='${tbName}' ORDER BY createtime DESC LIMIT 1 "
+ def errorMessage=""
+ sql """ alter table ${tbName} add column province VARCHAR(20) DEFAULT "广东省" AFTER username """
+ def insertSql = "insert into ${tbName} values(123456689, 'Alice', '四川省', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00');"
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true,"${tbName}")
+
+
+ //Test the unique model by adding a value column with BOOLEAN
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} add column special_area BOOLEAN DEFAULT "0" AFTER username """
+ insertSql = "insert into ${tbName} values(123456689, 'Alice', 1, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true,"${tbName}")
+
+
+
+ //Test the unique model by adding a value column with TINYINT
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} add column special_area TINYINT DEFAULT "0" AFTER username """
+ insertSql = " insert into ${tbName} values(123456689, 'Alice', 1, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true,"${tbName}")
+
+
+
+ //Test the unique model by adding a value column with SMALLINT
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} add column area_num SMALLINT DEFAULT "999" AFTER username """
+ insertSql = " insert into ${tbName} values(123456689, 'Alice', 567, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true,"${tbName}")
+
+
+ //Test the unique model by adding a value column with INT
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} add column house_price INT DEFAULT "999" AFTER username """
+ insertSql = " insert into ${tbName} values(123456689, 'Alice', 2, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true,"${tbName}")
+
+
+ //Test the unique model by adding a value column with BIGINT
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} add column house_price1 BIGINT DEFAULT "99999991" AFTER username """
+ insertSql = " insert into ${tbName} values(123456689, 'Alice', 88889494646, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true,"${tbName}")
+
+
+
+ //Test the unique model by adding a value column with LARGEINT
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} add column car_price LARGEINT DEFAULT "9999" AFTER username """
+ insertSql = " insert into ${tbName} values(123456689, 'Alice', 555888555, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00');"
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true,"${tbName}")
+
+
+
+
+ //TODO Test the unique model by adding a value column with FLOAT
+ errorMessage="errCode = 2, detailMessage = Default value will loose precision: 166.68"
+ expectException({
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} add column phone FLOAT DEFAULT "166.68" AFTER username """
+ insertSql = " insert into ${tbName} values(123456689, 'Alice', 189.98, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00');"
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true,"${tbName}")
+ },errorMessage)
+
+
+
+
+
+ //TODO Test the unique model by adding a value column with DOUBLE
+ //java.sql.SQLException:
+ errorMessage="errCode = 2, detailMessage = Default value will loose precision: 166.689"
+ expectException({
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} add column watch DOUBLE DEFAULT "166.689" AFTER username """
+ insertSql = " insert into ${tbName} values(123456689, 'Alice', 189.479, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true,"${tbName}")
+ },errorMessage)
+
+
+ //Test the unique model by adding a value column with DECIMAL
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} add column watch DECIMAL(38,10) DEFAULT "16899.6464689" AFTER username """
+ insertSql = " insert into ${tbName} values(123456689, 'Alice', 16499.6464689, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00');"
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true,"${tbName}")
+
+
+
+ //Test the unique model by adding a value column with DATE
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} add column watch DATE DEFAULT "1997-01-01" AFTER username """
+ insertSql = " insert into ${tbName} values(123456689, 'Alice', \"2024-01-01\", 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true,"${tbName}")
+
+
+
+
+ //Test the unique model by adding a value column with DATETIME
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} add column anniversary DATETIME DEFAULT "1997-01-01 00:00:00" AFTER username """
+ insertSql = " insert into ${tbName} values(123456689, 'Alice', \"2024-01-04 09:00:00\", 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true,"${tbName}")
+
+
+
+
+
+ //Test the unique model by adding a value column with CHAR
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} add column teacher CHAR DEFAULT "0" AFTER username """
+ insertSql = " insert into ${tbName} values(123456689, 'Alice', \"1\", 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true,"${tbName}")
+
+
+
+ //Test the unique model by adding a value column with STRING
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} add column comment STRING DEFAULT "我是小说家" AFTER username """
+ insertSql = " insert into ${tbName} values(123456689, 'Alice', '我是侦探家', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true,"${tbName}")
+
+ //TODO Test the unique model by adding a value column with HLL
+ errorMessage="errCode = 2, detailMessage = Can not assign aggregation method on column in Unique data model table: comment"
+ expectException({
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} add column comment HLL HLL_UNION AFTER username """
+ insertSql = " insert into ${tbName} values(123456689, 'Alice', '2', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true,"${tbName}")
+ },errorMessage)
+
+
+ //TODO Test the unique model by adding a value column with bitmap
+ errorMessage="errCode = 2, detailMessage = Can not assign aggregation method on column in Unique data model table: device_id"
+ expectException({
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} add column device_id bitmap BITMAP_UNION AFTER username """
+ insertSql = " insert into ${tbName} values(123456689, 'Alice', to_bitmap(243), 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true,"${tbName}")
+
+ },errorMessage)
+
+
+
+ //Test the unique model by adding a value column with Map
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} add column m Map<STRING, INT> AFTER username """
+ insertSql = " insert into ${tbName} values(123456689, 'Alice', {'a': 100, 'b': 200}, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true,"${tbName}")
+
+
+
+ //Test the unique model by adding a value column with JSON
+ sql initTable
+ sql initTableData
+ sql """ alter table ${tbName} add column j JSON AFTER username """
+ insertSql = " insert into ${tbName} values(123456689, 'Alice', '{\"k1\":\"v31\", \"k2\": 300}', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ waitForSchemaChangeDone({
+ sql getTableStatusSql
+ time 60
+ }, insertSql, true,"${tbName}")
+
+
+}
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 e9d8be3834b..ce65ed25415 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
@@ -20,272 +20,15 @@ suite("test_unique_model_schema_value_change","p0") {
def tbName2 = "test_unique_model_schema_value_change_1"
//Test the unique model by adding a value column
sql """ DROP TABLE IF EXISTS ${tbName} """
- def initTable = " CREATE TABLE IF NOT EXISTS ${tbName}\n" +
- " (\n" +
- " `user_id` LARGEINT NOT NULL COMMENT \"用户id\",\n" +
- " `username` VARCHAR(50) NOT NULL COMMENT \"用户昵称\",\n" +
- " `city` VARCHAR(20) COMMENT \"用户所在城市\",\n" +
- " `age` SMALLINT COMMENT \"用户年龄\",\n" +
- " `sex` TINYINT COMMENT \"用户性别\",\n" +
- " `phone` LARGEINT COMMENT \"用户电话\",\n" +
- " `address` VARCHAR(500) COMMENT \"用户地址\",\n" +
- " `register_time` DATETIME COMMENT \"用户注册时间\"\n" +
- " )\n" +
- " UNIQUE KEY(`user_id`, `username`)\n" +
- " 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" +
- " );"
-
- def initTableData = "insert into ${tbName} values(123456789, 'Alice', 'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00')," +
- " (234567890, 'Bob', 'Shanghai', 30, 1, 13998765432, 'No. 456 Street, Shanghai', '2022-02-02 12:00:00')," +
- " (345678901, 'Carol', 'Guangzhou', 28, 0, 13724681357, 'No. 789 Street, Guangzhou', '2022-03-03 14:00:00')," +
- " (456789012, 'Dave', 'Shenzhen', 35, 1, 13680864279, 'No. 987 Street, Shenzhen', '2022-04-04 16:00:00')," +
- " (567890123, 'Eve', 'Chengdu', 27, 0, 13572468091, 'No. 654 Street, Chengdu', '2022-05-05 18:00:00')," +
- " (678901234, 'Frank', 'Hangzhou', 32, 1, 13467985213, 'No. 321 Street, Hangzhou', '2022-06-06 20:00:00')," +
- " (789012345, 'Grace', 'Xian', 29, 0, 13333333333, 'No. 222 Street, Xian', '2022-07-07 22:00:00');"
-
- //Test the unique model by adding a value column with VARCHAR
- sql initTable
- sql initTableData
def getTableStatusSql = " SHOW ALTER TABLE COLUMN WHERE IndexName='${tbName}' ORDER BY createtime DESC LIMIT 1 "
def errorMessage=""
- sql """ alter table ${tbName} add column province VARCHAR(20) DEFAULT "广东省" AFTER username """
- def insertSql = "insert into ${tbName} values(123456689, 'Alice', '四川省', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00');"
- waitForSchemaChangeDone({
- sql getTableStatusSql
- time 60
- }, insertSql, true,"${tbName}")
-
-
- //Test the unique model by adding a value column with BOOLEAN
- sql initTable
- sql initTableData
- sql """ alter table ${tbName} add column special_area BOOLEAN DEFAULT "0" AFTER username """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
- waitForSchemaChangeDone({
- sql getTableStatusSql
- time 60
- }, insertSql, true,"${tbName}")
-
-
-
- //Test the unique model by adding a value column with TINYINT
- sql initTable
- sql initTableData
- sql """ alter table ${tbName} add column special_area TINYINT DEFAULT "0" AFTER username """
- insertSql = " insert into ${tbName} values(123456689, 'Alice', 1, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
- waitForSchemaChangeDone({
- sql getTableStatusSql
- time 60
- }, insertSql, true,"${tbName}")
-
-
-
- //Test the unique model by adding a value column with SMALLINT
- sql initTable
- sql initTableData
- sql """ alter table ${tbName} add column area_num SMALLINT DEFAULT "999" AFTER username """
- insertSql = " insert into ${tbName} values(123456689, 'Alice', 567, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
- waitForSchemaChangeDone({
- sql getTableStatusSql
- time 60
- }, insertSql, true,"${tbName}")
-
-
- //Test the unique model by adding a value column with INT
- sql initTable
- sql initTableData
- sql """ alter table ${tbName} add column house_price INT DEFAULT "999" AFTER username """
- insertSql = " insert into ${tbName} values(123456689, 'Alice', 2, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
- waitForSchemaChangeDone({
- sql getTableStatusSql
- time 60
- }, insertSql, true,"${tbName}")
-
-
- //Test the unique model by adding a value column with BIGINT
- sql initTable
- sql initTableData
- sql """ alter table ${tbName} add column house_price1 BIGINT DEFAULT "99999991" AFTER username """
- insertSql = " insert into ${tbName} values(123456689, 'Alice', 88889494646, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
- waitForSchemaChangeDone({
- sql getTableStatusSql
- time 60
- }, insertSql, true,"${tbName}")
-
-
-
- //Test the unique model by adding a value column with LARGEINT
- sql initTable
- sql initTableData
- sql """ alter table ${tbName} add column car_price LARGEINT DEFAULT "9999" AFTER username """
- insertSql = " insert into ${tbName} values(123456689, 'Alice', 555888555, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00');"
- waitForSchemaChangeDone({
- sql getTableStatusSql
- time 60
- }, insertSql, true,"${tbName}")
-
-
-
-
- //TODO Test the unique model by adding a value column with FLOAT
- errorMessage="errCode = 2, detailMessage = Default value will loose precision: 166.68"
- expectException({
- sql initTable
- sql initTableData
- sql """ alter table ${tbName} add column phone FLOAT DEFAULT "166.68" AFTER username """
- insertSql = " insert into ${tbName} values(123456689, 'Alice', 189.98, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00');"
- waitForSchemaChangeDone({
- sql getTableStatusSql
- time 60
- }, insertSql, true,"${tbName}")
- },errorMessage)
-
-
-
-
-
- //TODO Test the unique model by adding a value column with DOUBLE
- //java.sql.SQLException:
- errorMessage="errCode = 2, detailMessage = Default value will loose precision: 166.689"
- expectException({
- sql initTable
- sql initTableData
- sql """ alter table ${tbName} add column watch DOUBLE DEFAULT "166.689" AFTER username """
- insertSql = " insert into ${tbName} values(123456689, 'Alice', 189.479, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
- waitForSchemaChangeDone({
- sql getTableStatusSql
- time 60
- }, insertSql, true,"${tbName}")
- },errorMessage)
-
-
-
-
-
- //Test the unique model by adding a value column with DECIMAL
- sql initTable
- sql initTableData
- sql """ alter table ${tbName} add column watch DECIMAL(38,10) DEFAULT "16899.6464689" AFTER username """
- insertSql = " insert into ${tbName} values(123456689, 'Alice', 16499.6464689, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00');"
- waitForSchemaChangeDone({
- sql getTableStatusSql
- time 60
- }, insertSql, true,"${tbName}")
-
-
-
- //Test the unique model by adding a value column with DATE
- sql initTable
- sql initTableData
- sql """ alter table ${tbName} add column watch DATE DEFAULT "1997-01-01" AFTER username """
- insertSql = " insert into ${tbName} values(123456689, 'Alice', \"2024-01-01\", 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
- waitForSchemaChangeDone({
- sql getTableStatusSql
- time 60
- }, insertSql, true,"${tbName}")
-
-
-
-
- //Test the unique model by adding a value column with DATETIME
- sql initTable
- sql initTableData
- sql """ alter table ${tbName} add column anniversary DATETIME DEFAULT "1997-01-01 00:00:00" AFTER username """
- insertSql = " insert into ${tbName} values(123456689, 'Alice', \"2024-01-04 09:00:00\", 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
- waitForSchemaChangeDone({
- sql getTableStatusSql
- time 60
- }, insertSql, true,"${tbName}")
-
-
-
-
-
- //Test the unique model by adding a value column with CHAR
- sql initTable
- sql initTableData
- sql """ alter table ${tbName} add column teacher CHAR DEFAULT "0" AFTER username """
- insertSql = " insert into ${tbName} values(123456689, 'Alice', \"1\", 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
- waitForSchemaChangeDone({
- sql getTableStatusSql
- time 60
- }, insertSql, true,"${tbName}")
-
-
-
- //Test the unique model by adding a value column with STRING
- sql initTable
- sql initTableData
- sql """ alter table ${tbName} add column comment STRING DEFAULT "我是小说家" AFTER username """
- insertSql = " insert into ${tbName} values(123456689, 'Alice', '我是侦探家', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
- waitForSchemaChangeDone({
- sql getTableStatusSql
- time 60
- }, insertSql, true,"${tbName}")
-
- //TODO Test the unique model by adding a value column with HLL
- errorMessage="errCode = 2, detailMessage = Can not assign aggregation method on column in Unique data model table: comment"
- expectException({
- sql initTable
- sql initTableData
- sql """ alter table ${tbName} add column comment HLL HLL_UNION AFTER username """
- insertSql = " insert into ${tbName} values(123456689, 'Alice', '2', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
- waitForSchemaChangeDone({
- sql getTableStatusSql
- time 60
- }, insertSql, true,"${tbName}")
- },errorMessage)
-
-
- //TODO Test the unique model by adding a value column with bitmap
- errorMessage="errCode = 2, detailMessage = Can not assign aggregation method on column in Unique data model table: device_id"
- expectException({
- sql initTable
- sql initTableData
- sql """ alter table ${tbName} add column device_id bitmap BITMAP_UNION AFTER username """
- insertSql = " insert into ${tbName} values(123456689, 'Alice', to_bitmap(243), 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
- waitForSchemaChangeDone({
- sql getTableStatusSql
- time 60
- }, insertSql, true,"${tbName}")
-
- },errorMessage)
-
-
-
- //Test the unique model by adding a value column with Map
- sql initTable
- sql initTableData
- sql """ alter table ${tbName} add column m Map<STRING, INT> AFTER username """
- insertSql = " insert into ${tbName} values(123456689, 'Alice', {'a': 100, 'b': 200}, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
- waitForSchemaChangeDone({
- sql getTableStatusSql
- time 60
- }, insertSql, true,"${tbName}")
-
-
-
- //Test the unique model by adding a value column with JSON
- sql initTable
- sql initTableData
- sql """ alter table ${tbName} add column j JSON AFTER username """
- insertSql = " insert into ${tbName} values(123456689, 'Alice', '{\"k1\":\"v31\", \"k2\": 300}', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
- waitForSchemaChangeDone({
- sql getTableStatusSql
- time 60
- }, insertSql, true,"${tbName}")
-
-
/**
* Test the unique model by modify a value type
*/
def initTable2 = ""
def initTableData2 = ""
sql """ DROP TABLE IF EXISTS ${tbName} """
- initTable = " CREATE TABLE IF NOT EXISTS ${tbName}\n" +
+ def initTable = " CREATE TABLE IF NOT EXISTS ${tbName}\n" +
" (\n" +
" `user_id` LARGEINT NOT NULL COMMENT \"用户id\",\n" +
" `username` VARCHAR(50) NOT NULL COMMENT \"用户昵称\",\n" +
@@ -304,7 +47,7 @@ suite("test_unique_model_schema_value_change","p0") {
" \"enable_unique_key_merge_on_write\" = \"true\"\n" +
" );"
- initTableData = "insert into ${tbName} values(123456789, 'Alice', 0, 'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00')," +
+ def initTableData = "insert into ${tbName} values(123456789, 'Alice', 0, 'Beijing', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00')," +
" (234567890, 'Bob', 0, 'Shanghai', 30, 1, 13998765432, 'No. 456 Street, Shanghai', '2022-02-02 12:00:00')," +
" (345678901, 'Carol', 1, 'Guangzhou', 28, 0, 13724681357, 'No. 789 Street, Guangzhou', '2022-03-03 14:00:00')," +
" (456789012, 'Dave', 0, 'Shenzhen', 35, 1, 13680864279, 'No. 987 Street, Shenzhen', '2022-04-04 16:00:00')," +
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org