jmk1011 opened a new issue #2679: insert into bitmap column with null value will return error URL: https://github.com/apache/incubator-doris/issues/2679 **Describe the bug** if i want to insert select with bitmap_hash(null), this action will return error **To Reproduce** create table baseall(k1 tinyint, k3 int, k9 float sum) engine=olap distributed by hash(k1) buckets 5 properties("storage_type"="column"); insert into baseall (k1,k3,k9) values (1, 1001,6.333 ); CREATE TABLE test_bitmap_tb ( id int COMMENT "", id1 tinyint COMMENT "", c_float float SUM COMMENT "", bitmap_set bitmap BITMAP_UNION COMMENT "",bitmap_set2 bitmap BITMAP_UNION COMMENT "" ) ENGINE=OLAP DISTRIBUTED BY HASH(id, id1) BUCKETS 5 PROPERTIES ( "storage_type" = "COLUMN" ); insert into test_bitmap_tb select k3, k1, k9, TO_BITMAP(k3),bitmap_hash(null) from baseall; **Expected behavior** insert k3,k1,k9,TO_BITMAP(k3) to column (id,id1,c_float,bitmap_set), and null value to bitmap_set2 **Screenshots** mysql> insert into test_bitmap_tb select k3, k1, k9, TO_BITMAP(k3),bitmap_hash(null) from baseall; ERROR 1064 (HY000): Column's type is BITMAP, SelectList must contains BITMAP column, to_bitmap, bitmap_hash, bitmap_empty or bitmap_union function's result, column=bitmap_set2 **Code Version** https://github.com/apache/incubator-doris/commit/3022955f32c9764fd2634d57faa14664212d1831
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
