This is an automated email from the ASF dual-hosted git repository.
tuichenchuxin 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 c7f824a4af9 Update Oracle DML SLELECT LPAD statement parse (#22160)
c7f824a4af9 is described below
commit c7f824a4af9a508d44c9251339f7958df1957908
Author: Zichao <[email protected]>
AuthorDate: Tue Nov 15 15:34:56 2022 +1300
Update Oracle DML SLELECT LPAD statement parse (#22160)
---
.../dialect/oracle/src/main/antlr4/imports/oracle/BaseRule.g4 | 1 +
.../dialect/oracle/src/main/antlr4/imports/oracle/Keyword.g4 | 4 ++++
test/parser/src/main/resources/case/dml/select.xml | 8 ++++++++
test/parser/src/main/resources/sql/supported/dml/select.xml | 1 +
4 files changed, 14 insertions(+)
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 2c0b78d8200..2837a2d81fe 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,6 +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
;
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 25fe9765600..cf27cd895c8 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
@@ -639,3 +639,7 @@ REGR_SYY
REGR_SXY
: R E G R UL_ S X Y
;
+
+LPAD
+ : L P A D
+ ;
diff --git a/test/parser/src/main/resources/case/dml/select.xml
b/test/parser/src/main/resources/case/dml/select.xml
index 5607b691d7f..f9f2206037d 100644
--- a/test/parser/src/main/resources/case/dml/select.xml
+++ b/test/parser/src/main/resources/case/dml/select.xml
@@ -4613,4 +4613,12 @@
<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" />
+ </projections>
+ <from>
+ <simple-table name="DUAL" start-index="50" stop-index="53"/>
+ </from>
+ </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 5c7d9e2f948..4274b1edc4b 100644
--- a/test/parser/src/main/resources/sql/supported/dml/select.xml
+++ b/test/parser/src/main/resources/sql/supported/dml/select.xml
@@ -142,4 +142,5 @@
<sql-case id="select_aggregate_rank" value="SELECT RANK(15500) WITHIN
GROUP (ORDER BY salary DESC) 'Rank of 15500' FROM employees;" db-types="Oracle"
/>
<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-cases>
