You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by ji...@apache.org on 2023/03/08 02:01:16 UTC
[shardingsphere] branch master updated: support for Extract Function (#24490)
This is an automated email from the ASF dual-hosted git repository.
jianglongtao 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 f63828727ea support for Extract Function (#24490)
f63828727ea is described below
commit f63828727ea5a8a4060b0c27eff924d9a90a9756
Author: kanha gupta <92...@users.noreply.github.com>
AuthorDate: Wed Mar 8 07:31:09 2023 +0530
support for Extract Function (#24490)
---
.../dialect/mysql/src/main/antlr4/imports/mysql/BaseRule.g4 | 2 ++
.../src/main/resources/case/dml/select-special-function.xml | 9 ++++++++-
2 files changed, 10 insertions(+), 1 deletion(-)
diff --git a/sql-parser/dialect/mysql/src/main/antlr4/imports/mysql/BaseRule.g4 b/sql-parser/dialect/mysql/src/main/antlr4/imports/mysql/BaseRule.g4
index 3352f130e4a..d2041722089 100644
--- a/sql-parser/dialect/mysql/src/main/antlr4/imports/mysql/BaseRule.g4
+++ b/sql-parser/dialect/mysql/src/main/antlr4/imports/mysql/BaseRule.g4
@@ -179,6 +179,7 @@ identifierKeywordsUnambiguous
| DATETIME
| DATE
| DAY
+ | DAY_MINUTE
| DEFAULT_AUTH
| DEFINER
| DEFINITION
@@ -500,6 +501,7 @@ identifierKeywordsUnambiguous
| XID
| XML
| YEAR
+ | YEAR_MONTH
;
identifierKeywordsAmbiguous1RolesAndLabels
diff --git a/test/it/parser/src/main/resources/case/dml/select-special-function.xml b/test/it/parser/src/main/resources/case/dml/select-special-function.xml
index a63b6eff049..8ed2bb7123c 100644
--- a/test/it/parser/src/main/resources/case/dml/select-special-function.xml
+++ b/test/it/parser/src/main/resources/case/dml/select-special-function.xml
@@ -100,7 +100,14 @@
<projections start-index="7" stop-index="37">
<expression-projection text="EXTRACT(YEAR FROM '2019-07-02')" start-index="7" stop-index="37">
<expr>
- <function function-name="EXTRACT" start-index="7" stop-index="37" text="EXTRACT(YEAR FROM '2019-07-02')" />
+ <function function-name="EXTRACT" start-index="7" stop-index="37" text="EXTRACT(YEAR FROM '2019-07-02')" >
+ <parameter>
+ <literal-expression value="YEAR" start-index="15" stop-index="18" />
+ </parameter>
+ <parameter>
+ <literal-expression value="2019-07-02" start-index="23" stop-index="32" />
+ </parameter>
+ </function>
</expr>
</expression-projection>
</projections>