This is an automated email from the ASF dual-hosted git repository.
duanzhengqiang 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 d7c727f647a Add oracle aggregation function names (#27467)
d7c727f647a is described below
commit d7c727f647a33c1d0e83bd50aed13d0754e090d8
Author: ZhangCheng <[email protected]>
AuthorDate: Wed Jul 26 13:38:00 2023 +0800
Add oracle aggregation function names (#27467)
---
parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/BaseRule.g4 | 4 ++++
1 file changed, 4 insertions(+)
diff --git
a/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/BaseRule.g4
b/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/BaseRule.g4
index cabc4788895..02407dd05b0 100644
--- a/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/BaseRule.g4
+++ b/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/BaseRule.g4
@@ -699,6 +699,10 @@ keepClause
aggregationFunctionName
: MAX | MIN | SUM | COUNT | AVG | GROUPING | LISTAGG | PERCENT_RANK |
PERCENTILE_CONT | PERCENTILE_DISC | CUME_DIST | RANK
| REGR_SLOPE | REGR_INTERCEPT | REGR_COUNT | REGR_R2 | REGR_AVGX |
REGR_AVGY | REGR_SXX | REGR_SYY | REGR_SXY
+ | COLLECT | CORR | CORR_S | CORR_K | COVAR_POP | COVAR_SAMP | DENSE_RANK |
FIRST
+ | GROUP_ID | GROUPING_ID | LAST | MEDIAN | STATS_BINOMIAL_TEST |
STATS_CROSSTAB | STATS_F_TEST | STATS_KS_TEST
+ | STATS_MODE | STATS_MW_TEST | STATS_ONE_WAY_ANOVA | STATS_T_TEST_ONE |
STATS_T_TEST_PAIRED | STATS_T_TEST_INDEP
+ | STATS_T_TEST_INDEPU | STATS_WSR_TEST | STDDEV | STDDEV_POP | STDDEV_SAMP
| VAR_POP | VAR_SAMP | VARIANCE
;
listaggOverflowClause
