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 <[email protected]>
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: [email protected]
For additional commands, e-mail: [email protected]
