(kyuubi) branch master updated: [KYUUBI #6949] Test adding column position

[yao]

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

yao pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/kyuubi.git


The following commit(s) were added to refs/heads/master by this push:
     new 37eaf75ae3 [KYUUBI #6949] Test adding column position
37eaf75ae3 is described below

commit 37eaf75ae30941ac07852446f3249a4eba277255
Author: davidyuan <yuanfuy...@mafengwo.com>
AuthorDate: Wed Mar 5 14:17:51 2025 +0800

    [KYUUBI #6949] Test adding column position
    
    ### Why are the changes needed?
    
    Ranger check test case missing paimon adding column position command, add 
the test case
    #6949
    
    ### How was this patch tested?
    
    Test ranger check with paimon adding column position command
    
    ### Was this patch authored or co-authored using generative AI tooling?
    
    No
    
    Closes #6954 from davidyuan1223/test_adding_column_position.
    
    Closes #6949
    
    262ecaaca [davidyuan] Merge remote-tracking branch 'origin/master' into 
test_adding_column_position
    154765fc3 [davidyuan] Merge branch 'master' into test_adding_column_position
    4ebf985a9 [davidyuan] test adding column position
    
    Authored-by: davidyuan <yuanfuy...@mafengwo.com>
    Signed-off-by: Kent Yao <y...@apache.org>
---
 .../PaimonCatalogRangerSparkExtensionSuite.scala   | 29 ++++++++++++++++++++++
 1 file changed, 29 insertions(+)

diff --git 
a/extensions/spark/kyuubi-spark-authz/src/test/scala/org/apache/kyuubi/plugin/spark/authz/ranger/PaimonCatalogRangerSparkExtensionSuite.scala
 
b/extensions/spark/kyuubi-spark-authz/src/test/scala/org/apache/kyuubi/plugin/spark/authz/ranger/PaimonCatalogRangerSparkExtensionSuite.scala
index 7fe69f4434..76a90d5b82 100644
--- 
a/extensions/spark/kyuubi-spark-authz/src/test/scala/org/apache/kyuubi/plugin/spark/authz/ranger/PaimonCatalogRangerSparkExtensionSuite.scala
+++ 
b/extensions/spark/kyuubi-spark-authz/src/test/scala/org/apache/kyuubi/plugin/spark/authz/ranger/PaimonCatalogRangerSparkExtensionSuite.scala
@@ -252,6 +252,35 @@ class PaimonCatalogRangerSparkExtensionSuite extends 
RangerSparkExtensionSuite {
     }
   }
 
+  test("Adding Column Position") {
+    withCleanTmpResources(Seq(
+      (s"$catalogV2.$namespace1.$table1", "table"))) {
+      val createTable = createTableSql(namespace1, table1)
+      doAs(admin, sql(createTable))
+      val addingColumnPositionFirst =
+        s"""
+           |ALTER TABLE $catalogV2.$namespace1.$table1
+           |ADD COLUMN a INT FIRST
+           |""".stripMargin
+
+      interceptEndsWith[AccessControlException] {
+        doAs(someone, sql(addingColumnPositionFirst))
+      }(s"does not have [alter] privilege on [$namespace1/$table1]")
+      doAs(admin, sql(addingColumnPositionFirst))
+
+      val addingColumnPositionAfter =
+        s"""
+           |ALTER TABLE $catalogV2.$namespace1.$table1
+           |ADD COLUMN b INT AFTER a
+           |""".stripMargin
+
+      interceptEndsWith[AccessControlException] {
+        doAs(someone, sql(addingColumnPositionAfter))
+      }(s"does not have [alter] privilege on [$namespace1/$table1]")
+      doAs(admin, sql(addingColumnPositionAfter))
+    }
+  }
+
   def createTableSql(namespace: String, table: String): String =
     s"""
        |CREATE TABLE IF NOT EXISTS $catalogV2.$namespace.$table