This is an automated email from the ASF dual-hosted git repository.

morningman 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 8b6c46cfd1 [fix] fix create table like when having sequence column 
(#10464)
8b6c46cfd1 is described below

commit 8b6c46cfd1654b4f75def4f9f39e65cb99440e87
Author: xueweizhang <[email protected]>
AuthorDate: Sun Jul 3 23:19:46 2022 +0800

    [fix] fix create table like when having sequence column (#10464)
---
 fe/fe-core/src/main/java/org/apache/doris/catalog/Catalog.java     | 7 +++++++
 regression-test/data/data_model/unique/test_unique_table_like.out  | 2 ++
 .../suites/data_model/unique/test_unique_table_like.groovy         | 3 ++-
 3 files changed, 11 insertions(+), 1 deletion(-)

diff --git a/fe/fe-core/src/main/java/org/apache/doris/catalog/Catalog.java 
b/fe/fe-core/src/main/java/org/apache/doris/catalog/Catalog.java
index 7b79774fef..2798b2b36e 100755
--- a/fe/fe-core/src/main/java/org/apache/doris/catalog/Catalog.java
+++ b/fe/fe-core/src/main/java/org/apache/doris/catalog/Catalog.java
@@ -2872,6 +2872,13 @@ public class Catalog {
                 sb.append(olapTable.getCompressionType()).append("\"");
             }
 
+            // sequence type
+            if (olapTable.hasSequenceCol()) {
+                
sb.append(",\n\"").append(PropertyAnalyzer.PROPERTIES_FUNCTION_COLUMN + "."
+                    + PropertyAnalyzer.PROPERTIES_SEQUENCE_TYPE).append("\" = 
\"");
+                sb.append(olapTable.getSequenceType().toString()).append("\"");
+            }
+
             sb.append("\n)");
         } else if (table.getType() == TableType.MYSQL) {
             MysqlTable mysqlTable = (MysqlTable) table;
diff --git a/regression-test/data/data_model/unique/test_unique_table_like.out 
b/regression-test/data/data_model/unique/test_unique_table_like.out
index ffcbaf18cc..d728d493c7 100644
--- a/regression-test/data/data_model/unique/test_unique_table_like.out
+++ b/regression-test/data/data_model/unique/test_unique_table_like.out
@@ -5,6 +5,7 @@ int_value       INT     Yes     false   \N      REPLACE
 char_value     CHAR(10)        Yes     false   \N      REPLACE
 date_value     DATE    Yes     false   \N      REPLACE
 __DORIS_DELETE_SIGN__  TINYINT No      false   0       REPLACE
+__DORIS_SEQUENCE_COL__ INT     Yes     false   \N      REPLACE
 
 -- !desc_uniq_table --
 k      INT     Yes     true    \N      
@@ -12,4 +13,5 @@ int_value     INT     Yes     false   \N      REPLACE
 char_value     CHAR(10)        Yes     false   \N      REPLACE
 date_value     DATE    Yes     false   \N      REPLACE
 __DORIS_DELETE_SIGN__  TINYINT No      false   0       REPLACE
+__DORIS_SEQUENCE_COL__ INT     Yes     false   \N      REPLACE
 
diff --git 
a/regression-test/suites/data_model/unique/test_unique_table_like.groovy 
b/regression-test/suites/data_model/unique/test_unique_table_like.groovy
index 6250b61138..0bdc5e93b1 100644
--- a/regression-test/suites/data_model/unique/test_unique_table_like.groovy
+++ b/regression-test/suites/data_model/unique/test_unique_table_like.groovy
@@ -38,7 +38,8 @@ suite("test_unique_table_like", "data_model") {
             )
             ENGINE=OLAP
             UNIQUE KEY(k)
-            DISTRIBUTED BY HASH(k) BUCKETS 5 properties("replication_num" = 
"1");
+            DISTRIBUTED BY HASH(k) BUCKETS 5 properties("replication_num" = 
"1",
+                "function_column.sequence_type" = "int");
         """
     qt_desc_uniq_table "desc ${tbNameA}"    
     sql """


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to