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 c38df110b7f [enhancement](regression-test) fix table name conflict
(#36708)
c38df110b7f is described below
commit c38df110b7f683f7da445812196c654f7bc594fe
Author: kkop <[email protected]>
AuthorDate: Mon Jun 24 16:47:45 2024 +0800
[enhancement](regression-test) fix table name conflict (#36708)
---
.../test_unique_model_schema_value_add.out | 30 +--
.../test_unique_model_schema_value_change.out | 76 +++----
.../test_unique_model_schema_value_add.groovy | 39 ++--
.../test_unique_model_schema_value_change.groovy | 244 ++++++++++-----------
4 files changed, 194 insertions(+), 195 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
index 767314cf85e..1b9b2c53b10 100644
---
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
@@ -7,7 +7,7 @@
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
+993456689 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
@@ -17,7 +17,7 @@
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
+993456689 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
@@ -27,7 +27,7 @@
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
+993456689 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
@@ -37,7 +37,7 @@
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
+993456689 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
@@ -47,7 +47,7 @@
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
+993456689 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
@@ -57,7 +57,7 @@
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
+993456689 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
@@ -67,7 +67,7 @@
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
+993456689 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
@@ -77,7 +77,7 @@
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
+993456689 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
@@ -87,7 +87,7 @@
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
+993456689 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
@@ -97,7 +97,7 @@
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
+993456689 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
@@ -107,7 +107,7 @@
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
+993456689 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
@@ -117,7 +117,7 @@
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
+993456689 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
@@ -127,7 +127,7 @@
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
+993456689 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
@@ -137,7 +137,7 @@
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
+993456689 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
@@ -147,5 +147,5 @@
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
+993456689 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 10c43a9d49f..a815449d45a 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
@@ -7,7 +7,7 @@
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 1 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
+993456689 Alice 1 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
@@ -17,7 +17,7 @@
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 1 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
+993456689 Alice 1 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
@@ -27,7 +27,7 @@
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 1 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
+993456689 Alice 1 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
-- ! --
123456789 Alice 1.0 Beijing 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
@@ -37,7 +37,7 @@
567890123 Eve 0.0 Chengdu 27 0 13572468091 No. 654
Street, Chengdu 2022-05-05T18:00
678901234 Frank 0.0 Hangzhou 32 1 13467985213
No. 321 Street, Hangzhou 2022-06-06T20:00
789012345 Grace 1.0 Xian 29 0 13333333333 No. 222
Street, Xian 2022-07-07T22:00
-123456689 Alice 1.2 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
+993456689 Alice 1.2 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
-- ! --
123456789 Alice 1.0 Beijing 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
@@ -47,7 +47,7 @@
567890123 Eve 0.0 Chengdu 27 0 13572468091 No. 654
Street, Chengdu 2022-05-05T18:00
678901234 Frank 0.0 Hangzhou 32 1 13467985213
No. 321 Street, Hangzhou 2022-06-06T20:00
789012345 Grace 1.0 Xian 29 0 13333333333 No. 222
Street, Xian 2022-07-07T22:00
-123456689 Alice 1.23 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
+993456689 Alice 1.23 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
@@ -57,7 +57,7 @@
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 1 Xian 29 0 13333333333 No. 222
Street, Xian 2022-07-07T22:00
-123456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
+993456689 Alice asd 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
@@ -67,7 +67,7 @@
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 1 Xian 29 0 13333333333 No. 222
Street, Xian 2022-07-07T22:00
-123456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
+993456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
-- ! --
123456789 Alice 13243 Beijing 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
@@ -77,7 +77,7 @@
567890123 Eve 10768 Chengdu 27 0 13572468091 No. 654
Street, Chengdu 2022-05-05T18:00
678901234 Frank 14325 Hangzhou 32 1 13467985213
No. 321 Street, Hangzhou 2022-06-06T20:00
789012345 Grace 15686 Xian 29 0 13333333333 No. 222
Street, Xian 2022-07-07T22:00
-123456689 Alice 3 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
+993456689 Alice 3 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
-- ! --
123456789 Alice 13243 Beijing 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
@@ -87,7 +87,7 @@
567890123 Eve 10768 Chengdu 27 0 13572468091 No. 654
Street, Chengdu 2022-05-05T18:00
678901234 Frank 14325 Hangzhou 32 1 13467985213
No. 321 Street, Hangzhou 2022-06-06T20:00
789012345 Grace 15686 Xian 29 0 13333333333 No. 222
Street, Xian 2022-07-07T22:00
-123456689 Alice 4 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
+993456689 Alice 4 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
-- ! --
123456789 Alice 13243 Beijing 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
@@ -97,7 +97,7 @@
567890123 Eve 10768 Chengdu 27 0 13572468091 No. 654
Street, Chengdu 2022-05-05T18:00
678901234 Frank 14325 Hangzhou 32 1 13467985213
No. 321 Street, Hangzhou 2022-06-06T20:00
789012345 Grace 15686 Xian 29 0 13333333333 No. 222
Street, Xian 2022-07-07T22:00
-123456689 Alice 5 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
+993456689 Alice 5 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
-- ! --
123456789 Alice 13243.0 Beijing 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
@@ -107,7 +107,7 @@
567890123 Eve 10768.0 Chengdu 27 0 13572468091 No. 654
Street, Chengdu 2022-05-05T18:00
678901234 Frank 14325.0 Hangzhou 32 1 13467985213
No. 321 Street, Hangzhou 2022-06-06T20:00
789012345 Grace 15686.0 Xian 29 0 13333333333 No. 222
Street, Xian 2022-07-07T22:00
-123456689 Alice 1.2 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
+993456689 Alice 1.2 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
-- ! --
123456789 Alice 13243.0 Beijing 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
@@ -117,7 +117,7 @@
567890123 Eve 10768.0 Chengdu 27 0 13572468091 No. 654
Street, Chengdu 2022-05-05T18:00
678901234 Frank 14325.0 Hangzhou 32 1 13467985213
No. 321 Street, Hangzhou 2022-06-06T20:00
789012345 Grace 15686.0 Xian 29 0 13333333333 No. 222
Street, Xian 2022-07-07T22:00
-123456689 Alice 1.23 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
+993456689 Alice 1.23 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
-- ! --
123456789 Alice 13243 Beijing 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
@@ -127,7 +127,7 @@
567890123 Eve 10768 Chengdu 27 0 13572468091 No. 654
Street, Chengdu 2022-05-05T18:00
678901234 Frank 14325 Hangzhou 32 1 13467985213
No. 321 Street, Hangzhou 2022-06-06T20:00
789012345 Grace 15686 Xian 29 0 13333333333 No. 222
Street, Xian 2022-07-07T22:00
-123456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
+993456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
-- ! --
123456789 Alice 13243 Beijing 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
@@ -137,7 +137,7 @@
567890123 Eve 10768 Chengdu 27 0 13572468091 No. 654
Street, Chengdu 2022-05-05T18:00
678901234 Frank 14325 Hangzhou 32 1 13467985213
No. 321 Street, Hangzhou 2022-06-06T20:00
789012345 Grace 15686 Xian 29 0 13333333333 No. 222
Street, Xian 2022-07-07T22:00
-123456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
+993456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
-- ! --
123456789 Alice 2147483641 Beijing 25 0 13812345678
No. 123 Street, Beijing 2022-01-01T10:00
@@ -147,7 +147,7 @@
567890123 Eve 2127483141 Chengdu 27 0 13572468091
No. 654 Street, Chengdu 2022-05-05T18:00
678901234 Frank 2124483141 Hangzhou 32 1
13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
789012345 Grace 2123483141 Xian 29 0 13333333333
No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice 3 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
+993456689 Alice 3 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
-- ! --
123456789 Alice 2147483641 Beijing 25 0 13812345678
No. 123 Street, Beijing 2022-01-01T10:00
@@ -157,7 +157,7 @@
567890123 Eve 2127483141 Chengdu 27 0 13572468091
No. 654 Street, Chengdu 2022-05-05T18:00
678901234 Frank 2124483141 Hangzhou 32 1
13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
789012345 Grace 2123483141 Xian 29 0 13333333333
No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice 4 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
+993456689 Alice 4 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
-- ! --
123456789 Alice 2147483641 Beijing 25 0 13812345678
No. 123 Street, Beijing 2022-01-01T10:00
@@ -167,7 +167,7 @@
567890123 Eve 2127483141 Chengdu 27 0 13572468091
No. 654 Street, Chengdu 2022-05-05T18:00
678901234 Frank 2124483141 Hangzhou 32 1
13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
789012345 Grace 2123483141 Xian 29 0 13333333333
No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice 5 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
+993456689 Alice 5 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
-- ! --
123456789 Alice 2.14748365E9 Beijing 25 0 13812345678
No. 123 Street, Beijing 2022-01-01T10:00
@@ -177,7 +177,7 @@
567890123 Eve 2.12748314E9 Chengdu 27 0 13572468091
No. 654 Street, Chengdu 2022-05-05T18:00
678901234 Frank 2.1244832E9 Hangzhou 32 1
13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
789012345 Grace 2.12348314E9 Xian 29 0 13333333333
No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice 1.2 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
+993456689 Alice 1.2 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
-- ! --
123456789 Alice 2.147483641E9 Beijing 25 0 13812345678
No. 123 Street, Beijing 2022-01-01T10:00
@@ -187,7 +187,7 @@
567890123 Eve 2.127483141E9 Chengdu 27 0 13572468091
No. 654 Street, Chengdu 2022-05-05T18:00
678901234 Frank 2.124483141E9 Hangzhou 32 1
13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
789012345 Grace 2.123483141E9 Xian 29 0 13333333333
No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice 1.23 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
+993456689 Alice 1.23 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
-- ! --
123456789 Alice 2147483641 Beijing 25 0 13812345678
No. 123 Street, Beijing 2022-01-01T10:00
@@ -197,7 +197,7 @@
567890123 Eve 2127483141 Chengdu 27 0 13572468091
No. 654 Street, Chengdu 2022-05-05T18:00
678901234 Frank 2124483141 Hangzhou 32 1
13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
789012345 Grace 2123483141 Xian 29 0 13333333333
No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
+993456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
-- ! --
123456789 Alice 2147483641 Beijing 25 0 13812345678
No. 123 Street, Beijing 2022-01-01T10:00
@@ -207,7 +207,7 @@
567890123 Eve 2127483141 Chengdu 27 0 13572468091
No. 654 Street, Chengdu 2022-05-05T18:00
678901234 Frank 2124483141 Hangzhou 32 1
13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
789012345 Grace 2123483141 Xian 29 0 13333333333
No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
+993456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
-- ! --
123456789 Alice 21474832641 Beijing 25 0 13812345678
No. 123 Street, Beijing 2022-01-01T10:00
@@ -217,7 +217,7 @@
567890123 Eve 21274863141 Chengdu 27 0 13572468091
No. 654 Street, Chengdu 2022-05-05T18:00
678901234 Frank 21244883141 Hangzhou 32 1
13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
789012345 Grace 21234683141 Xian 29 0 13333333333
No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice 5 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
+993456689 Alice 5 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
-- ! --
123456789 Alice 2.14748324E10 Beijing 25 0 13812345678
No. 123 Street, Beijing 2022-01-01T10:00
@@ -227,7 +227,7 @@
567890123 Eve 2.12748636E10 Chengdu 27 0 13572468091
No. 654 Street, Chengdu 2022-05-05T18:00
678901234 Frank 2.12448829E10 Hangzhou 32 1
13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
789012345 Grace 2.12346839E10 Xian 29 0 13333333333
No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice 1.2 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
+993456689 Alice 1.2 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
-- ! --
123456789 Alice 2.1474832641E10 Beijing 25 0 13812345678
No. 123 Street, Beijing 2022-01-01T10:00
@@ -237,7 +237,7 @@
567890123 Eve 2.1274863141E10 Chengdu 27 0 13572468091
No. 654 Street, Chengdu 2022-05-05T18:00
678901234 Frank 2.1244883141E10 Hangzhou 32 1
13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
789012345 Grace 2.1234683141E10 Xian 29 0 13333333333
No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice 1.23 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
+993456689 Alice 1.23 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
-- ! --
123456789 Alice 21474832641 Beijing 25 0 13812345678
No. 123 Street, Beijing 2022-01-01T10:00
@@ -247,7 +247,7 @@
567890123 Eve 21274863141 Chengdu 27 0 13572468091
No. 654 Street, Chengdu 2022-05-05T18:00
678901234 Frank 21244883141 Hangzhou 32 1
13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
789012345 Grace 21234683141 Xian 29 0 13333333333
No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
+993456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
-- ! --
123456789 Alice 21474832641 Beijing 25 0 13812345678
No. 123 Street, Beijing 2022-01-01T10:00
@@ -257,7 +257,7 @@
567890123 Eve 21274863141 Chengdu 27 0 13572468091
No. 654 Street, Chengdu 2022-05-05T18:00
678901234 Frank 21244883141 Hangzhou 32 1
13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
789012345 Grace 21234683141 Xian 29 0 13333333333
No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
+993456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
-- ! --
123456789 Alice 2.14748324E10 Beijing 25 0 13812345678
No. 123 Street, Beijing 2022-01-01T10:00
@@ -267,7 +267,7 @@
567890123 Eve 2.12748636E10 Chengdu 27 0 13572468091
No. 654 Street, Chengdu 2022-05-05T18:00
678901234 Frank 2.12448829E10 Hangzhou 32 1
13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
789012345 Grace 2.12346839E10 Xian 29 0 13333333333
No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice 1.2 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
+993456689 Alice 1.2 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
-- ! --
123456789 Alice 2.1474832641E10 Beijing 25 0 13812345678
No. 123 Street, Beijing 2022-01-01T10:00
@@ -277,7 +277,7 @@
567890123 Eve 2.1274863141E10 Chengdu 27 0 13572468091
No. 654 Street, Chengdu 2022-05-05T18:00
678901234 Frank 2.1244883141E10 Hangzhou 32 1
13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
789012345 Grace 2.1234683141E10 Xian 29 0 13333333333
No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice 1.23 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
+993456689 Alice 1.23 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
-- ! --
123456789 Alice 21474832641 Beijing 25 0 13812345678
No. 123 Street, Beijing 2022-01-01T10:00
@@ -287,7 +287,7 @@
567890123 Eve 21274863141 Chengdu 27 0 13572468091
No. 654 Street, Chengdu 2022-05-05T18:00
678901234 Frank 21244883141 Hangzhou 32 1
13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
789012345 Grace 21234683141 Xian 29 0 13333333333
No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
+993456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
-- ! --
123456789 Alice 21474832641 Beijing 25 0 13812345678
No. 123 Street, Beijing 2022-01-01T10:00
@@ -297,7 +297,7 @@
567890123 Eve 21274863141 Chengdu 27 0 13572468091
No. 654 Street, Chengdu 2022-05-05T18:00
678901234 Frank 21244883141 Hangzhou 32 1
13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
789012345 Grace 21234683141 Xian 29 0 13333333333
No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
+993456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
-- ! --
123456789 Alice 1.7999999523162842 Beijing 25 0
13812345678 No. 123 Street, Beijing 2022-01-01T10:00 {"a":100,
"b":200} ["abc","def"]
@@ -307,7 +307,7 @@
567890123 Eve 4.199999809265137 Chengdu 27 0
13572468091 No. 654 Street, Chengdu 2022-05-05T18:00 {"a":500,
"b":200} ["abc","def"]
678901234 Frank 2.5 Hangzhou 32 1 13467985213
No. 321 Street, Hangzhou 2022-06-06T20:00 {"a":600, "b":200}
["abc","def"]
789012345 Grace 2.0999999046325684 Xian 29 0
13333333333 No. 222 Street, Xian 2022-07-07T22:00 {"a":700,
"b":200} ["abc","def"]
-123456689 Alice 1.23 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00 {"a":100, "b":200} ["abc","def"]
+993456689 Alice 1.23 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00 {"a":100, "b":200} ["abc","def"]
-- ! --
123456789 Alice 1.8 Beijing 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00 {"a":100, "b":200} ["abc","def"]
@@ -317,7 +317,7 @@
567890123 Eve 4.2 Chengdu 27 0 13572468091 No. 654
Street, Chengdu 2022-05-05T18:00 {"a":500, "b":200} ["abc","def"]
678901234 Frank 2.5 Hangzhou 32 1 13467985213
No. 321 Street, Hangzhou 2022-06-06T20:00 {"a":600, "b":200}
["abc","def"]
789012345 Grace 2.1 Xian 29 0 13333333333 No. 222
Street, Xian 2022-07-07T22:00 {"a":700, "b":200} ["abc","def"]
-123456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00 {"a":100, "b":200} ["abc","def"]
+993456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00 {"a":100, "b":200} ["abc","def"]
-- ! --
123456789 Alice 1.8 Beijing 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00 {"a":100, "b":200} ["abc","def"]
@@ -327,7 +327,7 @@
567890123 Eve 4.2 Chengdu 27 0 13572468091 No. 654
Street, Chengdu 2022-05-05T18:00 {"a":500, "b":200} ["abc","def"]
678901234 Frank 2.5 Hangzhou 32 1 13467985213
No. 321 Street, Hangzhou 2022-06-06T20:00 {"a":600, "b":200}
["abc","def"]
789012345 Grace 2.1 Xian 29 0 13333333333 No. 222
Street, Xian 2022-07-07T22:00 {"a":700, "b":200} ["abc","def"]
-123456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00 {"a":100, "b":200} ["abc","def"]
+993456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00 {"a":100, "b":200} ["abc","def"]
-- ! --
123456789 Alice 1.8 Beijing 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00 {"a":100, "b":200} ["abc","def"]
@@ -337,7 +337,7 @@
567890123 Eve 4.2 Chengdu 27 0 13572468091 No. 654
Street, Chengdu 2022-05-05T18:00 {"a":500, "b":200} ["abc","def"]
678901234 Frank 2.5 Hangzhou 32 1 13467985213
No. 321 Street, Hangzhou 2022-06-06T20:00 {"a":600, "b":200}
["abc","def"]
789012345 Grace 2.1 Xian 29 0 13333333333 No. 222
Street, Xian 2022-07-07T22:00 {"a":700, "b":200} ["abc","def"]
-123456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00 {"a":100, "b":200} ["abc","def"]
+993456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00 {"a":100, "b":200} ["abc","def"]
-- ! --
123456789 Alice 1.8 Beijing 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00 {"a":100, "b":200} ["abc","def"]
@@ -347,7 +347,7 @@
567890123 Eve 4.2 Chengdu 27 0 13572468091 No. 654
Street, Chengdu 2022-05-05T18:00 {"a":500, "b":200} ["abc","def"]
678901234 Frank 2.5 Hangzhou 32 1 13467985213
No. 321 Street, Hangzhou 2022-06-06T20:00 {"a":600, "b":200}
["abc","def"]
789012345 Grace 2.1 Xian 29 0 13333333333 No. 222
Street, Xian 2022-07-07T22:00 {"a":700, "b":200} ["abc","def"]
-123456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00 {"a":100, "b":200} ["abc","def"]
+993456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00 {"a":100, "b":200} ["abc","def"]
-- ! --
123456789 Alice 2 Beijing 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00 {"a":100, "b":200} ["abc","def"]
@@ -357,7 +357,7 @@
567890123 Eve 4 Chengdu 27 0 13572468091 No. 654
Street, Chengdu 2022-05-05T18:00 {"a":500, "b":200} ["abc","def"]
678901234 Frank 3 Hangzhou 32 1 13467985213
No. 321 Street, Hangzhou 2022-06-06T20:00 {"a":600, "b":200}
["abc","def"]
789012345 Grace 2 Xian 29 0 13333333333 No. 222
Street, Xian 2022-07-07T22:00 {"a":700, "b":200} ["abc","def"]
-123456689 Alice 1 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00 {"a":100, "b":200} ["abc","def"]
+993456689 Alice 1 Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00 {"a":100, "b":200} ["abc","def"]
-- ! --
123456789 Alice 1.8300000000 Beijing 25 0 13812345678
No. 123 Street, Beijing 2022-01-01T10:00 {"a":100, "b":200}
["abc","def"]
@@ -367,7 +367,7 @@
567890123 Eve 4.2230000000 Chengdu 27 0 13572468091
No. 654 Street, Chengdu 2022-05-05T18:00 {"a":500, "b":200}
["abc","def"]
678901234 Frank 2.5454000000 Hangzhou 32 1
13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
{"a":600, "b":200} ["abc","def"]
789012345 Grace 2.1965600000 Xian 29 0 13333333333
No. 222 Street, Xian 2022-07-07T22:00 {"a":700, "b":200}
["abc","def"]
-123456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00 {"a":100, "b":200} ["abc","def"]
+993456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00 {"a":100, "b":200} ["abc","def"]
-- ! --
123456789 Alice 1.8300000000 Beijing 25 0 13812345678
No. 123 Street, Beijing 2022-01-01T10:00 {"a":100, "b":200}
["abc","def"]
@@ -377,5 +377,5 @@
567890123 Eve 4.2230000000 Chengdu 27 0 13572468091
No. 654 Street, Chengdu 2022-05-05T18:00 {"a":500, "b":200}
["abc","def"]
678901234 Frank 2.5454000000 Hangzhou 32 1
13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
{"a":600, "b":200} ["abc","def"]
789012345 Grace 2.1965600000 Xian 29 0 13333333333
No. 222 Street, Xian 2022-07-07T22:00 {"a":700, "b":200}
["abc","def"]
-123456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00 {"a":100, "b":200} ["abc","def"]
+993456689 Alice asd Yaan 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00 {"a":100, "b":200} ["abc","def"]
diff --git
a/regression-test/suites/schema_change_p0/test_unique_model_schema_value_add.groovy
b/regression-test/suites/schema_change_p0/test_unique_model_schema_value_add.groovy
index 1d478b2283d..1b7dcf70565 100644
---
a/regression-test/suites/schema_change_p0/test_unique_model_schema_value_add.groovy
+++
b/regression-test/suites/schema_change_p0/test_unique_model_schema_value_add.groovy
@@ -16,8 +16,7 @@
// 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"
+ def tbName = "unique_model_schema_value_add"
def on_write = getRandomBoolean()
println String.format("current enable_unique_key_merge_on_write is : %s
",on_write)
//Test the unique model by adding a value column
@@ -54,7 +53,7 @@ suite("test_unique_model_schema_value_add","p0") {
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');"
+ def insertSql = "insert into ${tbName} values(993456689, 'Alice', '四川省',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00');"
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -65,7 +64,7 @@ suite("test_unique_model_schema_value_add","p0") {
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'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1, 'Yaan',
25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -77,7 +76,7 @@ suite("test_unique_model_schema_value_add","p0") {
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'); "
+ insertSql = " insert into ${tbName} values(993456689, 'Alice', 1, 'Yaan',
25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -89,7 +88,7 @@ suite("test_unique_model_schema_value_add","p0") {
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'); "
+ insertSql = " insert into ${tbName} values(993456689, 'Alice', 567,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -100,7 +99,7 @@ suite("test_unique_model_schema_value_add","p0") {
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'); "
+ insertSql = " insert into ${tbName} values(993456689, 'Alice', 2, 'Yaan',
25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -111,7 +110,7 @@ suite("test_unique_model_schema_value_add","p0") {
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'); "
+ insertSql = " insert into ${tbName} values(993456689, 'Alice',
88889494646, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -123,7 +122,7 @@ suite("test_unique_model_schema_value_add","p0") {
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');"
+ insertSql = " insert into ${tbName} values(993456689, 'Alice', 555888555,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00');"
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -138,7 +137,7 @@ suite("test_unique_model_schema_value_add","p0") {
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');"
+ insertSql = " insert into ${tbName} values(993456689, 'Alice', 189.98,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00');"
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -156,7 +155,7 @@ suite("test_unique_model_schema_value_add","p0") {
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'); "
+ insertSql = " insert into ${tbName} values(993456689, 'Alice',
189.479, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -168,7 +167,7 @@ suite("test_unique_model_schema_value_add","p0") {
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');"
+ insertSql = " insert into ${tbName} values(993456689, 'Alice',
16499.6464689, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00');"
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -180,7 +179,7 @@ suite("test_unique_model_schema_value_add","p0") {
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'); "
+ insertSql = " insert into ${tbName} values(993456689, 'Alice',
\"2024-01-01\", 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -193,7 +192,7 @@ suite("test_unique_model_schema_value_add","p0") {
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'); "
+ insertSql = " insert into ${tbName} values(993456689, '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
@@ -207,7 +206,7 @@ suite("test_unique_model_schema_value_add","p0") {
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');
"
+ insertSql = " insert into ${tbName} values(993456689, 'Alice', \"1\",
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00');
"
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -219,7 +218,7 @@ suite("test_unique_model_schema_value_add","p0") {
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');
"
+ insertSql = " insert into ${tbName} values(993456689, 'Alice', '我是侦探家',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00');
"
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -231,7 +230,7 @@ suite("test_unique_model_schema_value_add","p0") {
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');
"
+ insertSql = " insert into ${tbName} values(993456689, 'Alice', '2',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00');
"
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -245,7 +244,7 @@ suite("test_unique_model_schema_value_add","p0") {
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'); "
+ insertSql = " insert into ${tbName} values(993456689, 'Alice',
to_bitmap(243), 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -259,7 +258,7 @@ suite("test_unique_model_schema_value_add","p0") {
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'); "
+ insertSql = " insert into ${tbName} values(993456689, 'Alice', {'a': 100,
'b': 200}, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -271,7 +270,7 @@ suite("test_unique_model_schema_value_add","p0") {
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'); "
+ insertSql = " insert into ${tbName} values(993456689, 'Alice',
'{\"k1\":\"v31\", \"k2\": 300}', 'Yaan', 25, 0, 13812345678, 'No. 123 Street,
Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
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 9a415159034..2f21627064d 100644
---
a/regression-test/suites/schema_change_p0/test_unique_model_schema_value_change.groovy
+++
b/regression-test/suites/schema_change_p0/test_unique_model_schema_value_change.groovy
@@ -16,8 +16,8 @@
// under the License.
suite("test_unique_model_schema_value_change","p0") {
- def tbName = "test_unique_model_value_change0"
- def tbName2 = "test_unique_model_value_change_0"
+ def tbName = "unique_model_value_change0"
+ def tbName2 = "unique_model_value_change_0"
def on_write = getRandomBoolean()
println String.format("current enable_unique_key_merge_on_write is : %s
",on_write)
//Test the unique model by adding a value column
@@ -63,7 +63,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column is_teacher TINYINT
DEFAULT "0" """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -77,7 +77,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column is_teacher SMALLINT
DEFAULT "0" """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -91,7 +91,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column is_teacher INT
DEFAULT "0" """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -106,7 +106,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column is_teacher BIGINT
DEFAULT "0" """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -121,7 +121,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column is_teacher FLOAT
DEFAULT "0" """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1.0,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1.0,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -135,7 +135,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column is_teacher DOUBLE
DEFAULT "0" """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1.0,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1.0,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -149,7 +149,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column is_teacher DECIMAL
DEFAULT "0" """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1.0,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1.0,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -163,7 +163,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column is_teacher CHAR
DEFAULT "0" """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', '1',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', '1',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -177,7 +177,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column is_teacher STRING
DEFAULT "0" """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', '1',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', '1',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -191,7 +191,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column is_teacher VARCHAR(32)
DEFAULT "0" """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', '1',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', '1',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -238,7 +238,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column is_student BOOLEAN
DEFAULT "true" """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', false,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', false,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -252,7 +252,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column is_student SMALLINT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1, 'Yaan',
25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1, 'Yaan',
25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -285,7 +285,7 @@ suite("test_unique_model_schema_value_change","p0") {
" (567890123, 'Eve', 0, 'Chengdu', 27, 0,
13572468091, 'No. 654 Street, Chengdu', '2022-05-05 18:00:00')," +
" (678901234, 'Frank', 0, 'Hangzhou', 32, 1,
13467985213, 'No. 321 Street, Hangzhou', '2022-06-06 20:00:00')," +
" (789012345, 'Grace', 1, 'Xian', 29, 0,
13333333333, 'No. 222 Street, Xian', '2022-07-07 22:00:00')," +
- " (123456689, 'Alice', 1, 'Yaan', 25, 0,
13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00');"
+ " (993456689, 'Alice', 1, 'Yaan', 25, 0,
13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00');"
sql initTable2
sql initTableData2
checkTableData("${tbName}","${tbName2}","is_student")
@@ -295,7 +295,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column is_student INT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1, 'Yaan',
25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1, 'Yaan',
25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -306,7 +306,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column is_student BIGINT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1, 'Yaan',
25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1, 'Yaan',
25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -316,7 +316,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column is_student LARGEINT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1, 'Yaan',
25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1, 'Yaan',
25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -327,7 +327,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column is_student FLOAT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1.2,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1.2,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -337,7 +337,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column is_student DOUBLE """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -350,7 +350,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column is_student DECIMAL """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -364,7 +364,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column is_student CHAR(15)
"""
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -378,7 +378,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column is_student VARCHAR(100) """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -389,7 +389,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column is_student STRING """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -433,7 +433,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column car_number BOOLEAN
"""
- insertSql = "insert into ${tbName} values(123456689, 'Alice', false,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', false,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -447,7 +447,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column car_number TINYINT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 2,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 2,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -459,7 +459,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column car_number INT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 3, 'Yaan',
25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 3, 'Yaan',
25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -470,7 +470,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column car_number BIGINT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 4, 'Yaan',
25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 4, 'Yaan',
25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -480,7 +480,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column car_number LARGEINT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 5, 'Yaan',
25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 5, 'Yaan',
25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -490,7 +490,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column car_number FLOAT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1.2,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1.2,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -500,7 +500,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column car_number DOUBLE """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -513,7 +513,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column car_number DECIMAL """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -527,7 +527,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column car_number CHAR(15)
"""
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -539,7 +539,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column car_number VARCHAR(100) """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -550,7 +550,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column car_number STRING """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -595,7 +595,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column sn_number BOOLEAN """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', false,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', false,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -609,7 +609,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column sn_number TINYINT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 2,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 2,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -623,7 +623,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column sn_number INT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 3,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 3,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -634,7 +634,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column sn_number BIGINT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 4, 'Yaan',
25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 4, 'Yaan',
25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -644,7 +644,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column sn_number LARGEINT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 5, 'Yaan',
25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 5, 'Yaan',
25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -654,7 +654,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column sn_number FLOAT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1.2,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1.2,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -664,7 +664,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column sn_number DOUBLE """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -677,7 +677,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column sn_number
DECIMAL(38,0) """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -691,7 +691,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column sn_number CHAR(15) """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -703,7 +703,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column sn_number VARCHAR(100) """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -715,7 +715,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column sn_number VARCHAR(2)
"""
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -726,7 +726,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column sn_number STRING """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -770,7 +770,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column fan_number BOOLEAN
"""
- insertSql = "insert into ${tbName} values(123456689, 'Alice', false,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', false,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -784,7 +784,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column fan_number TINYINT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 2,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 2,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -798,7 +798,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column fan_number SMALLINT
"""
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 3,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 3,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -811,7 +811,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column fan_number INT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 4, 'Yaan',
25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 4, 'Yaan',
25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -822,7 +822,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column fan_number LARGEINT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 5, 'Yaan',
25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 5, 'Yaan',
25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -832,7 +832,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column fan_number FLOAT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1.2,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1.2,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -842,7 +842,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column fan_number DOUBLE """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -855,7 +855,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column fan_number
DECIMAL(38,0) """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -869,7 +869,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column fan_number CHAR(15)
"""
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -881,7 +881,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column fan_number VARCHAR(100) """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -894,7 +894,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column fan_number VARCHAR(2)
"""
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -906,7 +906,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column fan_number STRING """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -949,7 +949,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column item_number BOOLEAN
"""
- insertSql = "insert into ${tbName} values(123456689, 'Alice', false,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', false,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -963,7 +963,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column item_number TINYINT
"""
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 2,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 2,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -977,7 +977,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column item_number SMALLINT
"""
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 3,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 3,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -990,7 +990,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column item_number INT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 4,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 4,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1003,7 +1003,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column item_number BIGINT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 5,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 5,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1015,7 +1015,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column item_number FLOAT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1.2,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1.2,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1025,7 +1025,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column item_number DOUBLE """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1038,7 +1038,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column item_number
DECIMAL(38,0) """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1052,7 +1052,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column item_number CHAR(15)
"""
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1064,7 +1064,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column item_number VARCHAR(100)
"""
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1077,7 +1077,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column item_number VARCHAR(2)
"""
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1089,7 +1089,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column item_number STRING """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1135,7 +1135,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score BOOLEAN """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', false,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '{\"k1\":\"v1\", \"k2\": 200}'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', false,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '{\"k1\":\"v1\", \"k2\": 200}'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1149,7 +1149,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score TINYINT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 2,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '{\"k1\":\"v1\", \"k2\": 200}'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 2,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '{\"k1\":\"v1\", \"k2\": 200}'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1163,7 +1163,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score SMALLINT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 3,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, [\"abc\", \"def\"]); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 3,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, [\"abc\", \"def\"]); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1177,7 +1177,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTableData
sql """ alter table ${tbName} MODIFY column score INT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 4,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, [\"abc\", \"def\"]); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 4,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, [\"abc\", \"def\"]); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1191,7 +1191,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score BIGINT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice',
545645, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00', {'a': 100, 'b': 200}, [\"abc\", \"def\"]); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice',
545645, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00', {'a': 100, 'b': 200}, [\"abc\", \"def\"]); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1204,7 +1204,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score LARGEINT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice',
156546, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00', {'a': 100, 'b': 200}, [\"abc\", \"def\"]); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice',
156546, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00', {'a': 100, 'b': 200}, [\"abc\", \"def\"]); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1218,7 +1218,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score DOUBLE """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1232,7 +1232,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score DECIMAL(38,0)
"""
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1247,7 +1247,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score DATE """
- insertSql = "insert into ${tbName} values(123456689, 'Alice',
'2003-12-31', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice',
'2003-12-31', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1261,7 +1261,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score DATEV2 """
- insertSql = "insert into ${tbName} values(123456689, 'Alice',
'2003-12-31', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice',
'2003-12-31', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1276,7 +1276,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score DATETIME """
- insertSql = "insert into ${tbName} values(123456689, 'Alice',
'2003-12-31 20:12:12', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice',
'2003-12-31 20:12:12', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1290,7 +1290,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score DATETIMEV2 """
- insertSql = "insert into ${tbName} values(123456689, 'Alice',
'2003-12-31 20:12:12', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice',
'2003-12-31 20:12:12', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1304,7 +1304,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score CHAR(15) """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1318,7 +1318,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score VARCHAR(100) """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1332,7 +1332,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score STRING """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1347,7 +1347,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score Map<STRING, INT>
"""
- 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', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', {'a':
100, 'b': 200}, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1361,7 +1361,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score JSON """
- 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', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', '{'a':
100, 'b': 200}', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1409,7 +1409,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score BOOLEAN """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', false,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '{\"k1\":\"v1\", \"k2\": 200}'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', false,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '{\"k1\":\"v1\", \"k2\": 200}'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1423,7 +1423,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score TINYINT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 2,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '{\"k1\":\"v1\", \"k2\": 200}'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 2,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '{\"k1\":\"v1\", \"k2\": 200}'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1437,7 +1437,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score SMALLINT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 3,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, [\"abc\", \"def\"]); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 3,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, [\"abc\", \"def\"]); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1451,7 +1451,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTableData
sql """ alter table ${tbName} MODIFY column score INT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 4,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, [\"abc\", \"def\"]); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 4,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, [\"abc\", \"def\"]); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1465,7 +1465,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score BIGINT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice',
545645, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00', {'a': 100, 'b': 200}, [\"abc\", \"def\"]); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice',
545645, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00', {'a': 100, 'b': 200}, [\"abc\", \"def\"]); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1478,7 +1478,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score LARGEINT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice',
156546, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00', {'a': 100, 'b': 200}, [\"abc\", \"def\"]); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice',
156546, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00', {'a': 100, 'b': 200}, [\"abc\", \"def\"]); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1492,7 +1492,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score FLOAT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1506,7 +1506,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score DECIMAL(38,0)
"""
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1521,7 +1521,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score DATE """
- insertSql = "insert into ${tbName} values(123456689, 'Alice',
'2003-12-31', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice',
'2003-12-31', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1535,7 +1535,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score DATEV2 """
- insertSql = "insert into ${tbName} values(123456689, 'Alice',
'2003-12-31', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice',
'2003-12-31', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1550,7 +1550,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score DATETIME """
- insertSql = "insert into ${tbName} values(123456689, 'Alice',
'2003-12-31 20:12:12', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice',
'2003-12-31 20:12:12', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1564,7 +1564,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score DATETIMEV2 """
- insertSql = "insert into ${tbName} values(123456689, 'Alice',
'2003-12-31 20:12:12', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice',
'2003-12-31 20:12:12', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1578,7 +1578,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score CHAR(15) """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1592,7 +1592,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score VARCHAR(100) """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1606,7 +1606,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score STRING """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1621,7 +1621,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score Map<STRING, INT>
"""
- 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', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', {'a':
100, 'b': 200}, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1635,7 +1635,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score JSON """
- 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', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', '{'a':
100, 'b': 200}', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1682,7 +1682,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score BOOLEAN """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', false,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '{\"k1\":\"v1\", \"k2\": 200}'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', false,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '{\"k1\":\"v1\", \"k2\": 200}'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1696,7 +1696,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score TINYINT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 2,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '{\"k1\":\"v1\", \"k2\": 200}'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 2,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '{\"k1\":\"v1\", \"k2\": 200}'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1710,7 +1710,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score SMALLINT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 3,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, [\"abc\", \"def\"]); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 3,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, [\"abc\", \"def\"]); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1724,7 +1724,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTableData
sql """ alter table ${tbName} MODIFY column score INT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 4,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, [\"abc\", \"def\"]); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 4,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, [\"abc\", \"def\"]); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1738,7 +1738,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score BIGINT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice',
545645, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00', {'a': 100, 'b': 200}, [\"abc\", \"def\"]); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice',
545645, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00', {'a': 100, 'b': 200}, [\"abc\", \"def\"]); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1751,7 +1751,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score LARGEINT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice',
156546, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00', {'a': 100, 'b': 200}, [\"abc\", \"def\"]); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice',
156546, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01
10:00:00', {'a': 100, 'b': 200}, [\"abc\", \"def\"]); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1765,7 +1765,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score FLOAT """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1779,7 +1779,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score DECIMAL(38,0)
"""
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 1.23,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1794,7 +1794,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score DATE """
- insertSql = "insert into ${tbName} values(123456689, 'Alice',
'2003-12-31', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice',
'2003-12-31', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1808,7 +1808,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score DATEV2 """
- insertSql = "insert into ${tbName} values(123456689, 'Alice',
'2003-12-31', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice',
'2003-12-31', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1823,7 +1823,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score DATETIME """
- insertSql = "insert into ${tbName} values(123456689, 'Alice',
'2003-12-31 20:12:12', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice',
'2003-12-31 20:12:12', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1837,7 +1837,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score DATETIMEV2 """
- insertSql = "insert into ${tbName} values(123456689, 'Alice',
'2003-12-31 20:12:12', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice',
'2003-12-31 20:12:12', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1851,7 +1851,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score CHAR(15) """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1865,7 +1865,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score VARCHAR(100) """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1879,7 +1879,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score STRING """
- insertSql = "insert into ${tbName} values(123456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', 'asd',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00',
{'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1894,7 +1894,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score Map<STRING, INT>
"""
- 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', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', {'a':
100, 'b': 200}, 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -1908,7 +1908,7 @@ suite("test_unique_model_schema_value_change","p0") {
sql initTable
sql initTableData
sql """ alter table ${tbName} MODIFY column score JSON """
- 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', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
+ insertSql = "insert into ${tbName} values(993456689, 'Alice', '{'a':
100, 'b': 200}', 'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing',
'2022-01-01 10:00:00', {'a': 100, 'b': 200}, '[\"abc\", \"def\"]'); "
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
