This is an automated email from the ASF dual-hosted git repository. yiguolei pushed a commit to branch branch-2.1 in repository https://gitbox.apache.org/repos/asf/doris.git
commit 06f8266ca21c66b3f646834e908843dff8fcc789 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]
