This is an automated email from the ASF dual-hosted git repository.
yiguolei 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 f80ac34786 [regression](bloom filter) add test case for is not null
(#13310)
f80ac34786 is described below
commit f80ac3478675c04e60ba07f9266d86a76e96ec39
Author: TengJianPing <18241664+jackte...@users.noreply.github.com>
AuthorDate: Thu Oct 13 09:08:22 2022 +0800
[regression](bloom filter) add test case for is not null (#13310)
---
.../test_bloom_filter_is_not_null.out | 11 ++++++
.../test_bloom_filter_is_not_null.groovy | 39 ++++++++++++++++++++++
2 files changed, 50 insertions(+)
diff --git
a/regression-test/data/bloom_filter_p0/test_bloom_filter_is_not_null.out
b/regression-test/data/bloom_filter_p0/test_bloom_filter_is_not_null.out
new file mode 100644
index 0000000000..f578ece9b8
--- /dev/null
+++ b/regression-test/data/bloom_filter_p0/test_bloom_filter_is_not_null.out
@@ -0,0 +1,11 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !select_all --
+\N
+b
+
+-- !select_not_null --
+b
+
+-- !select_null --
+\N
+
diff --git
a/regression-test/suites/bloom_filter_p0/test_bloom_filter_is_not_null.groovy
b/regression-test/suites/bloom_filter_p0/test_bloom_filter_is_not_null.groovy
new file mode 100644
index 0000000000..e531b0774a
--- /dev/null
+++
b/regression-test/suites/bloom_filter_p0/test_bloom_filter_is_not_null.groovy
@@ -0,0 +1,39 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// specific language governing permissions and limitations
+// under the License.
+suite("test_bloom_filter_is_not_null") {
+ def table_name = "test_bloom_filter_is_not_null"
+
+ sql """drop TABLE if exists ${table_name}"""
+
+ sql """CREATE TABLE ${table_name} (
+ `a` varchar(150) NULL
+ ) ENGINE=OLAP
+ AGGREGATE KEY(`a`)
+ DISTRIBUTED BY HASH(`a`) BUCKETS 1
+ PROPERTIES (
+ "replication_allocation" = "tag.location.default: 1",
+ "bloom_filter_columns" = "a",
+ "in_memory" = "false",
+ "storage_format" = "V2"
+ )"""
+
+ sql """INSERT INTO ${table_name} values (null), ('b')"""
+
+ qt_select_all """select * from ${table_name} order by a"""
+ qt_select_not_null """select * from ${table_name} WHERE a is not null"""
+ qt_select_null """select * from ${table_name} WHERE a is null"""
+}
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
