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 c753b220362 [regression test](schema change) add boolean type check
for agg (#30186)
c753b220362 is described below
commit c753b2203625de358ac24156039bc8881283c3b8
Author: Guangdong Liu <[email protected]>
AuthorDate: Mon Jan 22 12:16:58 2024 +0800
[regression test](schema change) add boolean type check for agg (#30186)
---
.../schema_change_p0/test_schema_change_agg.groovy | 28 ++++++++++++++++++++++
1 file changed, 28 insertions(+)
diff --git
a/regression-test/suites/schema_change_p0/test_schema_change_agg.groovy
b/regression-test/suites/schema_change_p0/test_schema_change_agg.groovy
index 3b2526cfbc1..2534c219ca2 100644
--- a/regression-test/suites/schema_change_p0/test_schema_change_agg.groovy
+++ b/regression-test/suites/schema_change_p0/test_schema_change_agg.groovy
@@ -191,5 +191,33 @@ suite("test_schema_change_agg", "p0") {
assertEquals(2, row[1]);
assertEquals(3, row[2]);
}
+
+ // boolean type
+ sql """ alter table ${tableName3} add column v15 boolean replace NOT NULL
default "0" after k13 """
+
+ sleep(10)
+ max_try_num = 6000
+ while (max_try_num--) {
+ String res = getJobState(tableName3)
+ if (res == "FINISHED" || res == "CANCELLED") {
+ assertEquals("FINISHED", res)
+ sleep(3000)
+ break
+ } else {
+ sleep(2000)
+ if (max_try_num < 1){
+ assertEquals(1,2)
+ }
+ }
+ }
+
+ sql """ insert into ${tableName3} values (10002, 2, 3, 4, 5, 6.6, 1.7,
8.81,
+ 'a', 'b', 'c', '2021-10-30', '2021-10-30 00:00:00', true) """
+
+ test {
+ sql """ALTER table ${tableName3} modify COLUMN v15 int replace NOT
NULL default "0" after k13"""
+ exception "Can not change BOOLEAN to INT"
+ }
+
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
