This is an automated email from the ASF dual-hosted git repository.
morningman pushed a commit to branch branch-1.2-lts
in repository https://gitbox.apache.org/repos/asf/doris.git
commit 88b2308baf4e242c34b959045a906a36fddcc355
Author: caoliang-web <71004656+caoliang-...@users.noreply.github.com>
AuthorDate: Mon Apr 3 14:20:09 2023 +0800
[regression](decimalv3)Add decimal type as filter condition in regression
test (#17160)
Add decimal type as filter condition in regression test
---
.../data/decimalv3/test_decimalv3_where.out | 6 +++++
.../suites/decimalv3/test_decimalv3_where.groovy | 26 ++++++++++++++++++++++
2 files changed, 32 insertions(+)
diff --git a/regression-test/data/decimalv3/test_decimalv3_where.out
b/regression-test/data/decimalv3/test_decimalv3_where.out
new file mode 100644
index 0000000000..04ffc21d83
--- /dev/null
+++ b/regression-test/data/decimalv3/test_decimalv3_where.out
@@ -0,0 +1,6 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !decimalv3 --
+3 flink 9 20
+2 spark 10 95
+1 doris 20 324
+
diff --git a/regression-test/suites/decimalv3/test_decimalv3_where.groovy
b/regression-test/suites/decimalv3/test_decimalv3_where.groovy
new file mode 100644
index 0000000000..287a77cbd1
--- /dev/null
+++ b/regression-test/suites/decimalv3/test_decimalv3_where.groovy
@@ -0,0 +1,26 @@
+// 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_decimalv3_where") {
+
+
+ def tableName = "test_decimalv3_demo"
+ sql """drop table if exists ${tableName}"""
+ sql """CREATE TABLE ${tableName} ( `id` varchar(11) NULL COMMENT
'唯一标识', `name` varchar(10) NULL COMMENT '采集时间', `age` int(11) NULL, `dr`
decimalv3(10, 0) ) ENGINE=OLAP UNIQUE KEY(`id`) COMMENT 'test' DISTRIBUTED BY
HASH(`id`) BUCKETS 10 PROPERTIES ( "replication_allocation" =
"tag.location.default: 1", "in_memory" = "false", "storage_format" = "V2",
"light_schema_change" = "true", "disable_auto_compaction" = "false" );"""
+ sql """insert into ${tableName} values
(1,'doris',20,324.10),(2,'spark',10,95.5),(3,'flink',9,20)"""
+ qt_decimalv3 "select * from ${tableName} where dr != 1 order by age;"
+}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
