(doris) 24/30: [fix](Nereids): add order for constraint test (#33323)

[yiguolei]

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

yiguolei pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git

commit 35d5c9c8973c4b75de9b5a86ebf0984f2c4fdb2f
Author: 谢健 <jianx...@gmail.com>
AuthorDate: Tue Apr 9 14:53:36 2024 +0800

    [fix](Nereids): add order for constraint test (#33323)
---
 regression-test/data/nereids_syntax_p0/constraint.out      |  8 ++++----
 regression-test/suites/nereids_syntax_p0/constraint.groovy | 14 +++++++-------
 2 files changed, 11 insertions(+), 11 deletions(-)

diff --git a/regression-test/data/nereids_syntax_p0/constraint.out 
b/regression-test/data/nereids_syntax_p0/constraint.out
index daa4fde7745..cfb38f34dd4 100644
--- a/regression-test/data/nereids_syntax_p0/constraint.out
+++ b/regression-test/data/nereids_syntax_p0/constraint.out
@@ -3,17 +3,17 @@
 pk     PRIMARY KEY     PRIMARY KEY (id)
 
 -- !add_unique --
-uk     UNIQUE  UNIQUE (id)
 pk     PRIMARY KEY     PRIMARY KEY (id)
+uk     UNIQUE  UNIQUE (id)
 
 -- !add_foreign --
-uk     UNIQUE  UNIQUE (id)
-pk     PRIMARY KEY     PRIMARY KEY (id)
 fk1    FOREIGN KEY     FOREIGN KEY (id) REFERENCES 
regression_test_nereids_syntax_p0.t2 (id)
+pk     PRIMARY KEY     PRIMARY KEY (id)
+uk     UNIQUE  UNIQUE (id)
 
 -- !drop_uk --
-pk     PRIMARY KEY     PRIMARY KEY (id)
 fk1    FOREIGN KEY     FOREIGN KEY (id) REFERENCES 
regression_test_nereids_syntax_p0.t2 (id)
+pk     PRIMARY KEY     PRIMARY KEY (id)
 
 -- !drop_fk --
 pk     PRIMARY KEY     PRIMARY KEY (id)
diff --git a/regression-test/suites/nereids_syntax_p0/constraint.groovy 
b/regression-test/suites/nereids_syntax_p0/constraint.groovy
index 4ede619e5a5..e761caadc24 100644
--- a/regression-test/suites/nereids_syntax_p0/constraint.groovy
+++ b/regression-test/suites/nereids_syntax_p0/constraint.groovy
@@ -61,7 +61,7 @@ suite("show_constraint") {
     alter table t2 add constraint pk primary key (id)
     """
 
-    qt_add_primary """
+    order_qt_add_primary """
     show constraints from t1;
     """
 
@@ -69,7 +69,7 @@ suite("show_constraint") {
     alter table t1 add constraint uk unique (id)
     """
 
-    qt_add_unique """
+    order_qt_add_unique """
     show constraints from t1;
     """
 
@@ -80,7 +80,7 @@ suite("show_constraint") {
     alter table t2 add constraint fk2 foreign key (id) references t1(id)
     """
 
-    qt_add_foreign """
+    order_qt_add_foreign """
     show constraints from t1;
     """
 
@@ -88,7 +88,7 @@ suite("show_constraint") {
     alter table t1 drop constraint uk
     """
 
-    qt_drop_uk """
+    order_qt_drop_uk """
     show constraints from t1;
     """
 
@@ -96,7 +96,7 @@ suite("show_constraint") {
     alter table t1 drop constraint fk1
     """
 
-    qt_drop_fk """
+    order_qt_drop_fk """
     show constraints from t1;
     """
 
@@ -104,11 +104,11 @@ suite("show_constraint") {
     alter table t1 drop constraint pk
     """
 
-    qt_drop_pk """
+    order_qt_drop_pk """
     show constraints from t1;
     """
 
-    qt_drop_fk_cascades """
+    order_qt_drop_fk_cascades """
     show constraints from t2;
     """
 


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org