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]

Reply via email to