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 8c9d4b6425b Update Oracle DML SLELECT TO_CHAR function statement parse
(#22236)
8c9d4b6425b is described below
commit 8c9d4b6425b8e73dca66b1893738c33af881b6d2
Author: Zichao <[email protected]>
AuthorDate: Fri Nov 18 00:53:36 2022 +1300
Update Oracle DML SLELECT TO_CHAR function statement parse (#22236)
---
.../oracle/src/main/antlr4/imports/oracle/BaseRule.g4 | 2 +-
.../oracle/src/main/antlr4/imports/oracle/Keyword.g4 | 4 ++++
test/parser/src/main/resources/case/dml/select.xml | 13 +++++++++++++
test/parser/src/main/resources/sql/supported/dml/select.xml | 1 +
4 files changed, 19 insertions(+), 1 deletion(-)
diff --git
a/sql-parser/dialect/oracle/src/main/antlr4/imports/oracle/BaseRule.g4
b/sql-parser/dialect/oracle/src/main/antlr4/imports/oracle/BaseRule.g4
index 39f093f2b1c..04649c2092b 100644
--- a/sql-parser/dialect/oracle/src/main/antlr4/imports/oracle/BaseRule.g4
+++ b/sql-parser/dialect/oracle/src/main/antlr4/imports/oracle/BaseRule.g4
@@ -163,7 +163,7 @@ unreservedWord
| HOST | PORT | EVERY | MINUTES | HOURS | NORELOCATE | SAVE | DISCARD |
APPLICATION | INSTALL
| MINIMUM | VERSION | UNINSTALL | COMPATIBILITY | MATERIALIZE | SUBTYPE |
RECORD | CONSTANT | CURSOR
| OTHERS | EXCEPTION | CPU_PER_SESSION | CONNECT_TIME |
LOGICAL_READS_PER_SESSION | PRIVATE_SGA | PERCENT_RANK | ROWID
- | LPAD | ZONE | SESSIONTIMEZONE
+ | LPAD | ZONE | SESSIONTIMEZONE | TO_CHAR
;
schemaName
diff --git
a/sql-parser/dialect/oracle/src/main/antlr4/imports/oracle/Keyword.g4
b/sql-parser/dialect/oracle/src/main/antlr4/imports/oracle/Keyword.g4
index 178166ec443..c859b27efe3 100644
--- a/sql-parser/dialect/oracle/src/main/antlr4/imports/oracle/Keyword.g4
+++ b/sql-parser/dialect/oracle/src/main/antlr4/imports/oracle/Keyword.g4
@@ -663,3 +663,7 @@ SYSTIMESTAMP
DBTIMEZONE
: D B T I M E Z O N E
;
+
+TO_CHAR
+ : T O UL_ C H A R
+ ;
diff --git a/test/parser/src/main/resources/case/dml/select.xml
b/test/parser/src/main/resources/case/dml/select.xml
index f9f2206037d..8387e26359e 100644
--- a/test/parser/src/main/resources/case/dml/select.xml
+++ b/test/parser/src/main/resources/case/dml/select.xml
@@ -4613,6 +4613,7 @@
<column-item name="employee_id" start-index="531" stop-index="541"
/>
</order-by>
</select>
+
<select sql-case-id="select_lpad_function">
<projections start-index="7" stop-index="43">
<expression-projection text="LPAD('Page 1',15,'*.')" alias="LPAD
example" start-index="7" stop-index="43" />
@@ -4621,4 +4622,16 @@
<simple-table name="DUAL" start-index="50" stop-index="53"/>
</from>
</select>
+
+ <select sql-case-id="select_to_char_function">
+ <projections start-index="7" stop-index="60">
+ <expression-projection text="TO_CHAR(ts_col, 'DD-MON-YYYY
HH24:MI:SSxFF')" alias="ts_col" start-index="7" stop-index="60" />
+ </projections>
+ <from>
+ <simple-table name="date_tab" start-index="67" stop-index="74" />
+ </from>
+ <order-by>
+ <column-item name="ts_col" start-index="85" stop-index="90" />
+ </order-by>
+ </select>
</sql-parser-test-cases>
diff --git a/test/parser/src/main/resources/sql/supported/dml/select.xml
b/test/parser/src/main/resources/sql/supported/dml/select.xml
index 4274b1edc4b..2df4099f308 100644
--- a/test/parser/src/main/resources/sql/supported/dml/select.xml
+++ b/test/parser/src/main/resources/sql/supported/dml/select.xml
@@ -143,4 +143,5 @@
<sql-case id="select_rowid" value="SELECT ROWID FROM employees WHERE
ROWIDTOCHAR(ROWID) LIKE '%JAAB%' ORDER BY ROWID;" db-types="Oracle" />
<sql-case id="select_linear_regression_function" value="SELECT job_id,
employee_id ID, salary, REGR_SLOPE(SYSDATE-hire_date, salary) OVER (PARTITION
BY job_id) slope, REGR_INTERCEPT(SYSDATE-hire_date, salary) OVER (PARTITION BY
job_id) intcpt, REGR_R2(SYSDATE-hire_date, salary) OVER (PARTITION BY job_id)
rsqr, REGR_COUNT(SYSDATE-hire_date, salary) OVER (PARTITION BY job_id) count,
REGR_AVGX(SYSDATE-hire_date, salary) OVER (PARTITION BY job_id) avgx,
REGR_AVGY(SYSDATE-hire_date, salar [...]
<sql-case id="select_lpad_function" value="SELECT LPAD('Page 1',15,'*.')
'LPAD example' FROM DUAL;" db-types="Oracle" />
+ <sql-case id="select_to_char_function" value="SELECT TO_CHAR(ts_col,
'DD-MON-YYYY HH24:MI:SSxFF') AS ts_col FROM date_tab ORDER BY ts_col;" />
</sql-cases>
