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 a78ec55584d Update Oracle DML SLELECT PERCENTILE_CONT statement parse
(#22062)
a78ec55584d is described below
commit a78ec55584d8b88b4d3bb0ee0fe7cc87b3aa2353
Author: Zichao <[email protected]>
AuthorDate: Fri Nov 11 15:04:46 2022 +1300
Update Oracle DML SLELECT PERCENTILE_CONT statement parse (#22062)
* Update Oracle DML SLELECT PERCENT_CONT statement parse
* Update Oracle DML SLELECT PERCENT_CONT statement parse
---
.../dialect/oracle/src/main/antlr4/imports/oracle/BaseRule.g4 | 2 +-
.../dialect/oracle/src/main/antlr4/imports/oracle/Keyword.g4 | 6 +++++-
test/parser/src/main/resources/case/dml/select.xml | 10 ++++++++++
test/parser/src/main/resources/sql/supported/dml/select.xml | 1 +
4 files changed, 17 insertions(+), 2 deletions(-)
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 a97a4b7f6d3..dc450244e3f 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
@@ -515,7 +515,7 @@ aggregationFunction
;
aggregationFunctionName
- : MAX | MIN | SUM | COUNT | AVG | GROUPING | LISTAGG | PERCENT_RANK
+ : MAX | MIN | SUM | COUNT | AVG | GROUPING | LISTAGG | PERCENT_RANK |
PERCENTILE_CONT
;
listaggOverflowClause
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 e44012d959f..887f9683a48 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
@@ -578,4 +578,8 @@ GLOBAL_NAME
ROWTYPE
: R O W T Y P E
- ;
\ No newline at end of file
+ ;
+
+PERCENTILE_CONT
+ : P E R C E N T I L E UL_ C O N T
+ ;
diff --git a/test/parser/src/main/resources/case/dml/select.xml
b/test/parser/src/main/resources/case/dml/select.xml
index e46461f7241..b741d4b870d 100644
--- a/test/parser/src/main/resources/case/dml/select.xml
+++ b/test/parser/src/main/resources/case/dml/select.xml
@@ -4475,4 +4475,14 @@
<column-item name="last_name" start-index="153" stop-index="161" />
</order-by>
</select>
+
+ <select sql-case-id="select_aggregate_percentile_cont">
+ <projections start-index="7" stop-index="91">
+ <column-projection name="department_id" start-index="7"
stop-index="19" />
+ <expression-projection text="PERCENTILE_CONT(0.5) WITHIN GROUP
(ORDER BY salary DESC)" alias="Median cont" start-index="22" stop-index="91" />
+ </projections>
+ <from>
+ <simple-table name="employees" start-index="98" stop-index="106" />
+ </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 f1c2d785518..09ae96c16e3 100644
--- a/test/parser/src/main/resources/sql/supported/dml/select.xml
+++ b/test/parser/src/main/resources/sql/supported/dml/select.xml
@@ -136,4 +136,5 @@
<sql-case id="select_with_listagg_function_start_with_connect_by"
value="SELECT LISTAGG(c.category_name, '/') WITHIN GROUP (ORDER BY LENGTH
(c."level") DESC) AS category_level FROM t_product_category c START
WITH c.category_id = 1 CONNECT BY PRIOR c.parent_id = c.category_id"
db-types="Oracle" />
<sql-case id="select_aggregate_percent_rank" value="SELECT
PERCENT_RANK(15000, .05) WITHIN GROUP (ORDER BY salary, commission_pct)
'Percent-Rank' FROM employees;" db-types="Oracle" />
<sql-case id="select_analytic_percent_rank" value="SELECT department_id,
last_name, salary, PERCENT_RANK() OVER (PARTITION BY department_id ORDER BY
salary DESC) AS pr FROM employees ORDER BY pr, salary, last_name;"
db-types="Oracle" />
+ <sql-case id="select_aggregate_percentile_cont" value="SELECT
department_id, PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY salary DESC) 'Median
cont' FROM employees;" db-types="Oracle" />
</sql-cases>
