[doris] branch master updated: [regression](bloom filter) add test case for is not null (#13310)

[yi...@apache.org]

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 <18...@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-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org