You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by tu...@apache.org on 2022/11/15 02:35:03 UTC
[shardingsphere] branch master updated: Update Oracle DML SLELECT LPAD statement parse (#22160)
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 <57...@users.noreply.github.com>
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>