(doris) branch master updated: [regression test](schema change) add boolean type check for agg (#30186)

[dataroaring]

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 <liug...@gmail.com>
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: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org