kangpinghuang opened a new issue #3163: delete result is invalid when there is no predicate URL: https://github.com/apache/incubator-doris/issues/3163 **Describe the bug** the result is invalid when there is no predicate for count(*) agaist a table with delete. **To Reproduce** CREATE DATABASE test_sys_bloom_filter_c_test_delete_on_bf_column_db; CREATE TABLE test_sys_bloom_filter_c_test_delete_on_bf_column_db.test_sys_bloom_filter_c_test_delete_on_bf_column_tb ( tinyint_key TINYINT NOT NULL, smallint_key SMALLINT NOT NULL, int_key INT NOT NULL, bigint_key BIGINT NOT NULL, char_50_key CHAR(50) NOT NULL, character_key VARCHAR(500) NOT NULL, char_key CHAR NOT NULL, character_most_key VARCHAR(65533) NOT NULL, decimal_key DECIMAL(20, 6) NOT NULL, decimal_most_key DECIMAL(27, 9) NOT NULL, date_key DATE NOT NULL, datetime_key DATETIME NOT NULL, tinyint_value TINYINT SUM NOT NULL, smallint_value SMALLINT SUM NOT NULL, int_value int SUM NOT NULL, bigint_value BIGINT SUM NOT NULL, char_50_value CHAR(50) REPLACE NOT NULL, character_value VARCHAR(500) REPLACE NOT NULL, char_value CHAR REPLACE NOT NULL, character_most_value VARCHAR(65533) REPLACE NOT NULL, decimal_value DECIMAL(20, 6) SUM NOT NULL, decimal_most_value DECIMAL(27, 9) SUM NOT NULL, date_value_replace DATE REPLACE NOT NULL, date_value_max DATE REPLACE NOT NULL, date_value_min DATE REPLACE NOT NULL, datetime_value_replace DATETIME REPLACE NOT NULL, datetime_value_max DATETIME REPLACE NOT NULL, datetime_value_min DATETIME REPLACE NOT NULL, float_value FLOAT SUM NOT NULL, double_value DOUBLE SUM NOT NULL ) AGGREGATE KEY(tinyint_key,smallint_key,int_key,bigint_key,char_50_key,character_key,char_key,character_most_key,decimal_key,decimal_most_key,date_key,datetime_key) PARTITION BY RANGE(tinyint_key) ( PARTITION p_0 VALUES LESS THAN ("0"), PARTITION p_1 VALUES LESS THAN MAXVALUE ) DISTRIBUTED BY HASH(tinyint_key) BUCKETS 10 PROPERTIES ( "bloom_filter_columns"="smallint_key,int_key,bigint_key,char_50_key,character_key,char_key,character_most_key,decimal_key,decimal_most_key,date_key,datetime_key,char_50_value,character_value,char_value,character_most_value,date_value_replace,date_value_max,date_value_min,datetime_value_replace,datetime_value_max,datetime_value_min" ); LOAD LABEL test_sys_bloom_filter_c_test_delete_on_bf_column_db.label_17_01_30_35_279380_79953931 (DATA INFILE("hdfs://host:port/user/palo/test/data/sys/all_type.txt") INTO TABLE `test_sys_bloom_filter_c_test_delete_on_bf_column_tb`) WITH BROKER "hdfs" ("username"="xxx", "password"="xxx") PROPERTIES( "max_filter_ratio"="0.05" ); DELETE FROM test_sys_bloom_filter_c_test_delete_on_bf_column_db.test_sys_bloom_filter_c_test_delete_on_bf_column_tb PARTITION p_1 WHERE bigint_key <= "2"; select count(*) from test_sys_bloom_filter_c_test_delete_on_bf_column_tb where bigint_key > 2; 823 select count(*) from test_sys_bloom_filter_c_test_delete_on_bf_column_tb; 5
---------------------------------------------------------------- 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
