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 8a09f0478f [regressiontest](improvement)SQL query conditions, if the
data type is expanded with single quotes, an error will occur case (#11437)
8a09f0478f is described below
commit 8a09f0478f89fb210c74793ef52856780383a1a8
Author: caoliang-web <[email protected]>
AuthorDate: Thu Aug 4 11:28:12 2022 +0800
[regressiontest](improvement)SQL query conditions, if the data type is
expanded with single quotes, an error will occur case (#11437)
---
.../data/query/test_data_type_marks.out | 7 ++++
.../suites/query/test_data_type_marks.groovy | 42 ++++++++++++++++++++++
2 files changed, 49 insertions(+)
diff --git a/regression-test/data/query/test_data_type_marks.out
b/regression-test/data/query/test_data_type_marks.out
new file mode 100644
index 0000000000..9e6993e9ba
--- /dev/null
+++ b/regression-test/data/query/test_data_type_marks.out
@@ -0,0 +1,7 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !select_no_marks --
+
+-- !select_one_marks --
+639215401565159424 1143681147589283841 test
+
+-- !select_two_marks --
diff --git a/regression-test/suites/query/test_data_type_marks.groovy
b/regression-test/suites/query/test_data_type_marks.groovy
new file mode 100644
index 0000000000..60e55196ee
--- /dev/null
+++ b/regression-test/suites/query/test_data_type_marks.groovy
@@ -0,0 +1,42 @@
+// 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_data_type_marks", "query") {
+ def tbName = "org"
+ sql "DROP TABLE IF EXISTS ${tbName}"
+ sql """
+ CREATE TABLE IF NOT EXISTS ${tbName} (
+ `id` bigint(20) NULL COMMENT "主键id",
+ `tenant_id` bigint(20) NULL COMMENT "租户ID",
+ `name` text NULL COMMENT "名称"
+ ) ENGINE=OLAP
+ UNIQUE KEY(`id`)
+ COMMENT "OLAP"
+ DISTRIBUTED BY HASH(`id`) BUCKETS 8
+ PROPERTIES (
+ "replication_allocation" = "tag.location.default: 1",
+ "in_memory" = "false",
+ "storage_format" = "V2"
+ )
+ """
+ sql "insert into ${tbName} values
(639215401565159424,1143681147589283841,'test'),(639237839376089088,1143681147589283841,'test123');"
+
+ qt_select_no_marks "select * from org where id in (639215401565159424) and
id=639237839376089088;"
+ qt_select_one_marks "select * from org where id in ('639215401565159424')
;"
+ qt_select_two_marks "select * from org where id in ('639215401565159424')
and id='639237839376089088';"
+ sql "DROP TABLE ${tbName}"
+}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
