This is an automated email from the ASF dual-hosted git repository.
morrySnow 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 f3216d8c1c6 [fix](cases) remove duplicate cases and useless out check
file (#64687)
f3216d8c1c6 is described below
commit f3216d8c1c6dd1d51e968bfa3db51fe21bcc4d28
Author: morrySnow <[email protected]>
AuthorDate: Tue Jun 23 10:26:51 2026 +0800
[fix](cases) remove duplicate cases and useless out check file (#64687)
test_show_create_table_nereids duplicate with test_show_create_table
test_show_create_table's outfile is useless
---
.../data/query_p0/show/test_show_create_table.out | 6 ---
.../show/test_show_create_table_nereids.groovy | 63 ----------------------
2 files changed, 69 deletions(-)
diff --git a/regression-test/data/query_p0/show/test_show_create_table.out
b/regression-test/data/query_p0/show/test_show_create_table.out
deleted file mode 100644
index 3455c2bb3d5..00000000000
--- a/regression-test/data/query_p0/show/test_show_create_table.out
+++ /dev/null
@@ -1,6 +0,0 @@
--- This file is automatically generated. You should know what you did if you
want to edit this
--- !select --
-tb_show_create_table CREATE TABLE `tb_show_create_table` (\n `datek1` date
NULL COMMENT 'a',\n `datetimek1` datetime NULL COMMENT 'b',\n `datetimek2`
datetime(3) NULL COMMENT 'c',\n `datetimek3` datetime(6) NULL COMMENT 'd',\n
`datev1` date MAX NOT NULL COMMENT 'e',\n `datetimev1` datetime MAX NOT NULL
COMMENT 'f',\n `datetimev2` datetime(3) MAX NOT NULL COMMENT 'g',\n
`datetimev3` datetime(6) MAX NOT NULL COMMENT 'h'\n) ENGINE=OLAP\nAGGREGATE
KEY(`datek1`, `datetimek1`, `datetim [...]
-
--- !select --
-tb_show_create_table CREATE TABLE `tb_show_create_table` (\n `datek1` date
NULL COMMENT 'a',\n `datetimek1` datetime NULL COMMENT 'b',\n `datetimek2`
datetime(3) NULL COMMENT 'c',\n `datetimek3` datetime(6) NULL COMMENT 'd',\n
`datev1` date NOT NULL COMMENT 'e',\n `datetimev1` datetime NOT NULL COMMENT
'f',\n `datetimev2` datetime(3) NOT NULL COMMENT 'g',\n `datetimev3`
datetime(6) NOT NULL COMMENT 'h'\n) ENGINE=OLAP\nDUPLICATE KEY(`datek1`,
`datetimek1`, `datetimek2`, `datetimek [...]
diff --git
a/regression-test/suites/query_p0/show/test_show_create_table_nereids.groovy
b/regression-test/suites/query_p0/show/test_show_create_table_nereids.groovy
deleted file mode 100644
index 53f2242d1fa..00000000000
--- a/regression-test/suites/query_p0/show/test_show_create_table_nereids.groovy
+++ /dev/null
@@ -1,63 +0,0 @@
-// 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_show_create_table_nereids", "query,arrow_flight_sql") {
- String tb_name = "tb_show_create_table";
- try {
- sql """drop table if exists ${tb_name} """
- sql """
- CREATE TABLE IF NOT EXISTS ${tb_name}(
- datek1 datev2 COMMENT "a",
- datetimek1 datetimev2 COMMENT "b",
- datetimek2 datetimev2(3) COMMENT "c",
- datetimek3 datetimev2(6) COMMENT "d",
- datev1 datev2 MAX NOT NULL COMMENT "e",
- datetimev1 datetimev2 MAX NOT NULL COMMENT "f",
- datetimev2 datetimev2(3) MAX NOT NULL COMMENT "g",
- datetimev3 datetimev2(6) MAX NOT NULL COMMENT "h"
- )
- AGGREGATE KEY (datek1, datetimek1, datetimek2, datetimek3)
- DISTRIBUTED BY HASH(datek1) BUCKETS 5 properties("replication_num"
= "1");
- """
-
- def res = sql "show create table `${tb_name}`"
- assertTrue(res.size() != 0)
-
- sql """drop table if exists ${tb_name} """
- sql """
- CREATE TABLE IF NOT EXISTS ${tb_name}(
- datek1 datev2 COMMENT "a",
- datetimek1 datetimev2 COMMENT "b",
- datetimek2 datetimev2(3) COMMENT "c",
- datetimek3 datetimev2(6) COMMENT "d",
- datev1 datev2 NOT NULL COMMENT "e",
- datetimev1 datetimev2 NOT NULL COMMENT "f",
- datetimev2 datetimev2(3) NOT NULL COMMENT "g",
- datetimev3 datetimev2(6) NOT NULL COMMENT "h"
- )
- DUPLICATE KEY (datek1, datetimek1, datetimek2, datetimek3)
- DISTRIBUTED BY RANDOM BUCKETS 5 properties("replication_num" =
"1");
- """
-
- checkNereidsExecute("""show create table `${tb_name}`;""")
-
- } finally {
-
- try_sql("DROP TABLE IF EXISTS `${tb_name}`")
- }
-
-}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]