(shardingsphere) branch master updated: Improve the parsing of SYSTEM_USER() in MySQL (#32503)

[duanzhengqiang]

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

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


The following commit(s) were added to refs/heads/master by this push:
     new 706d8dfff1c Improve the parsing of  SYSTEM_USER() in MySQL (#32503)
706d8dfff1c is described below

commit 706d8dfff1c73223b7ec063d33baeeb10ebb426f
Author: lushaorong <wwwww...@163.com>
AuthorDate: Wed Aug 14 14:52:56 2024 +0800

    Improve the parsing of  SYSTEM_USER() in MySQL (#32503)
---
 test/it/parser/src/main/resources/case/ddl/create-table.xml        | 7 +++++++
 .../parser/src/main/resources/sql/supported/ddl/create-table.xml   | 1 +
 2 files changed, 8 insertions(+)

diff --git a/test/it/parser/src/main/resources/case/ddl/create-table.xml 
b/test/it/parser/src/main/resources/case/ddl/create-table.xml
index acce89c02a6..82520c027d0 100644
--- a/test/it/parser/src/main/resources/case/ddl/create-table.xml
+++ b/test/it/parser/src/main/resources/case/ddl/create-table.xml
@@ -2881,4 +2881,11 @@
             <engine name="OLAP" start-index="187" stop-index="190"/>
         </create-table-option>
     </create-table>
+
+    <create-table 
sql-case-id="create_table_with_column_default_system_user_function">
+        <table name="t" start-index="13" stop-index="13" />
+        <column-definition type="VARCHAR" start-index="16" stop-index="53">
+            <column name="c" />
+        </column-definition>
+    </create-table>
 </sql-parser-test-cases>
diff --git 
a/test/it/parser/src/main/resources/sql/supported/ddl/create-table.xml 
b/test/it/parser/src/main/resources/sql/supported/ddl/create-table.xml
index 13da0253883..74e7a6b56c8 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/create-table.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/create-table.xml
@@ -367,4 +367,5 @@
         &quot;enable_persistent_index&quot; = &quot;false&quot;,
         &quot;compression&quot; = &quot;LZ4&quot;
             );" db-types="Doris"/>
+    <sql-case id="create_table_with_column_default_system_user_function" 
value="CREATE TABLE t (c VARCHAR(288) DEFAULT (SYSTEM_USER()));" 
db-types="MySQL"/>
 </sql-cases>