You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by du...@apache.org on 2022/06/21 06:57:09 UTC
[shardingsphere] branch master updated: Add PostgreSQL Create Aggregate Statement (#18486)
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 4d4ce180f0e Add PostgreSQL Create Aggregate Statement (#18486)
4d4ce180f0e is described below
commit 4d4ce180f0e6740b56799bc381a453dbc4477ce2
Author: Thanoshan MV <48...@users.noreply.github.com>
AuthorDate: Tue Jun 21 12:27:00 2022 +0530
Add PostgreSQL Create Aggregate Statement (#18486)
---
.../src/main/antlr4/imports/postgresql/BaseRule.g4 | 1 +
.../parser/autogen/PostgreSQLStatementParser.g4 | 1 +
.../impl/PostgreSQLDDLStatementSQLVisitor.java | 7 ++
.../ddl/PostgreSQLCreateAggregateStatement.java | 29 +++++
.../main/resources/case/ddl/create-aggregate.xml | 12 ++
.../sql/supported/ddl/create-aggregate.xml | 14 ++-
.../main/resources/sql/unsupported/unsupported.xml | 122 ---------------------
7 files changed, 63 insertions(+), 123 deletions(-)
diff --git a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/imports/postgresql/BaseRule.g4 b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/imports/postgresql/BaseRule.g4
index f9450b3763e..d5cf3842cc6 100644
--- a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/imports/postgresql/BaseRule.g4
+++ b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/imports/postgresql/BaseRule.g4
@@ -1384,6 +1384,7 @@ defArg
| NUMBER_
| STRING_
| NONE
+ | funcName (LP_ funcArgsList RP_ | LP_ RP_)
;
funcType
diff --git a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/org/apache/shardingsphere/sql/parser/autogen/PostgreSQLStatementParser.g4 b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/org/apache/shardingsphere/sql/parser/autogen/PostgreSQLStatementParser.g4
index 7091f692bf2..a00c9a3b97d 100644
--- a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/org/apache/shardingsphere/sql/parser/autogen/PostgreSQLStatementParser.g4
+++ b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/org/apache/shardingsphere/sql/parser/autogen/PostgreSQLStatementParser.g4
@@ -151,5 +151,6 @@ execute
| alterOperator
| createAccessMethod
| alterPublication
+ | createAggregate
) SEMI_? EOF
;
diff --git a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/java/org/apache/shardingsphere/sql/parser/postgresql/visitor/statement/impl/PostgreSQLDDLStatementSQLVisitor.java b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/java/org/apache/shardingsphere/sql/parser/postgresql/visitor/statement/impl/PostgreSQLDDLStatementSQLVisitor.java
index 3aff333293c..9a0ac3a7974 100644
--- a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/java/org/apache/shardingsphere/sql/parser/postgresql/visitor/statement/impl/PostgreSQLDDLStatementSQLVisitor.java
+++ b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/java/org/apache/shardingsphere/sql/parser/postgresql/visitor/statement/impl/PostgreSQLDDLStatementSQLVisitor.java
@@ -57,6 +57,7 @@ import org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser.Co
import org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser.ColumnDefinitionContext;
import org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser.CommentContext;
import org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser.CreateAccessMethodContext;
+import org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser.CreateAggregateContext;
import org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser.CreateConversionContext;
import org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser.CreateDatabaseContext;
import org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser.CreateDefinitionClauseContext;
@@ -190,6 +191,7 @@ import org.apache.shardingsphere.sql.parser.sql.dialect.statement.postgresql.ddl
import org.apache.shardingsphere.sql.parser.sql.dialect.statement.postgresql.ddl.PostgreSQLClusterStatement;
import org.apache.shardingsphere.sql.parser.sql.dialect.statement.postgresql.ddl.PostgreSQLCommentStatement;
import org.apache.shardingsphere.sql.parser.sql.dialect.statement.postgresql.ddl.PostgreSQLCreateAccessMethodStatement;
+import org.apache.shardingsphere.sql.parser.sql.dialect.statement.postgresql.ddl.PostgreSQLCreateAggregateStatement;
import org.apache.shardingsphere.sql.parser.sql.dialect.statement.postgresql.ddl.PostgreSQLCreateConversionStatement;
import org.apache.shardingsphere.sql.parser.sql.dialect.statement.postgresql.ddl.PostgreSQLCreateDatabaseStatement;
import org.apache.shardingsphere.sql.parser.sql.dialect.statement.postgresql.ddl.PostgreSQLCreateDomainStatement;
@@ -1092,4 +1094,9 @@ public final class PostgreSQLDDLStatementSQLVisitor extends PostgreSQLStatementS
public ASTNode visitCreateAccessMethod(final CreateAccessMethodContext ctx) {
return new PostgreSQLCreateAccessMethodStatement();
}
+
+ @Override
+ public ASTNode visitCreateAggregate(final CreateAggregateContext ctx) {
+ return new PostgreSQLCreateAggregateStatement();
+ }
}
diff --git a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/postgresql/ddl/PostgreSQLCreateAggregateStatement.java b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/postgresql/ddl/PostgreSQLCreateAggregateStatement.java
new file mode 100644
index 00000000000..760f86e27f0
--- /dev/null
+++ b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/postgresql/ddl/PostgreSQLCreateAggregateStatement.java
@@ -0,0 +1,29 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package org.apache.shardingsphere.sql.parser.sql.dialect.statement.postgresql.ddl;
+
+import lombok.ToString;
+import org.apache.shardingsphere.sql.parser.sql.common.statement.ddl.CreateAggregateStatement;
+import org.apache.shardingsphere.sql.parser.sql.dialect.statement.postgresql.PostgreSQLStatement;
+
+/**
+ * PostgreSQL create aggregate statement.
+ */
+@ToString
+public final class PostgreSQLCreateAggregateStatement extends CreateAggregateStatement implements PostgreSQLStatement {
+}
diff --git a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/create-aggregate.xml b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/create-aggregate.xml
index 93825fa55f5..4136a278016 100644
--- a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/create-aggregate.xml
+++ b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/create-aggregate.xml
@@ -18,4 +18,16 @@
<sql-parser-test-cases>
<create-aggregate sql-case-id="create_aggregate" />
+ <create-aggregate sql-case-id="create_aggregate_with_stype" />
+ <create-aggregate sql-case-id="create_aggregate_with_sfunc" />
+ <create-aggregate sql-case-id="create_aggregate_with_basetype" />
+ <create-aggregate sql-case-id="create_aggregate_with_init_cond" />
+ <create-aggregate sql-case-id="create_aggregate_with_parallel" />
+ <create-aggregate sql-case-id="create_aggregate_with_combinefunc" />
+ <create-aggregate sql-case-id="create_aggregate_with_mstype" />
+ <create-aggregate sql-case-id="create_aggregate_with_finalfunc" />
+ <create-aggregate sql-case-id="create_aggregate_with_basetype_finalfunc" />
+ <create-aggregate sql-case-id="create_or_replace_aggregate" />
+ <create-aggregate sql-case-id="create_or_replace_aggregate_sfunc" />
+ <create-aggregate sql-case-id="create_or_replace_aggregate_stype_sfunc" />
</sql-parser-test-cases>
diff --git a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/ddl/create-aggregate.xml b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/ddl/create-aggregate.xml
index 70ae1de5b22..0861531f049 100644
--- a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/ddl/create-aggregate.xml
+++ b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/ddl/create-aggregate.xml
@@ -17,5 +17,17 @@
-->
<sql-cases>
- <sql-case id="create_aggregate" value="CREATE AGGREGATE sum (complex) (sfunc = complex_add, stype = complex, initcond = '(0,0)');" db-types="openGauss" />
+ <sql-case id="create_aggregate" value="CREATE AGGREGATE sum (complex) (sfunc = complex_add, stype = complex, initcond = '(0,0)');" db-types="openGauss, PostgreSQL" />
+ <sql-case id="create_aggregate_with_stype" value="CREATE AGGREGATE my_avg(int4) (STYPE = avg_state, SFUNC = avg_transfn, FINALFUNC = avg_finalfn)" db-types="PostgreSQL" />
+ <sql-case id="create_aggregate_with_sfunc" value="CREATE AGGREGATE addr_nsp.genaggr(int4) (SFUNC = int4pl, STYPE = int4);" db-types="PostgreSQL" />
+ <sql-case id="create_aggregate_with_basetype" value="CREATE AGGREGATE alt_agg1 (SFUNC = int4pl, BASETYPE = int4, STYPE = int4, INITCOND = 0 );" db-types="PostgreSQL" />
+ <sql-case id="create_aggregate_with_init_cond" value="CREATE AGGREGATE array_larger_accum (anyarray) (SFUNC = array_larger, STYPE = anyarray, INITCOND = '{}' );" db-types="PostgreSQL" />
+ <sql-case id="create_aggregate_with_parallel" value="CREATE AGGREGATE balk(int4) (SFUNC = balkifnull(int8, int4), STYPE = int8, PARALLEL = SAFE, INITCOND = '0' );" db-types="PostgreSQL" />
+ <sql-case id="create_aggregate_with_combinefunc" value="CREATE AGGREGATE balk(int4) (SFUNC = int4_sum(int8, int4), STYPE = int8, COMBINEFUNC = balkifnull(int8, int8), PARALLEL = SAFE, INITCOND = '0' );" db-types="PostgreSQL" />
+ <sql-case id="create_aggregate_with_mstype" value="CREATE AGGREGATE invalidsumdouble (float8) (STYPE = float8, SFUNC = float8pl, MSTYPE = float8, MSFUNC = float8pl, MINVFUNC = float8mi_n );" db-types="PostgreSQL" />
+ <sql-case id="create_aggregate_with_finalfunc" value="CREATE AGGREGATE myaggn01a(*) (SFUNC = stfnp, STYPE = int4[], FINALFUNC = ffnp, INITCOND = '{}');" db-types="PostgreSQL" />
+ <sql-case id="create_aggregate_with_basetype_finalfunc" value="CREATE AGGREGATE myaggn05a(BASETYPE = int, SFUNC = tfnp, STYPE = int[], FINALFUNC = ffnp, INITCOND = '{}');" db-types="PostgreSQL" />
+ <sql-case id="create_or_replace_aggregate" value="CREATE OR REPLACE AGGREGATE myavg (numeric) (STYPE = internal, SFUNC = numeric_avg_accum, FINALFUNC = numeric_avg, SERIALFUNC = numeric_avg_serialize, DESERIALFUNC = numeric_avg_deserialize, COMBINEFUNC = numeric_avg_combine, FINALFUNC_MODIFY = shareable );" db-types="PostgreSQL" />
+ <sql-case id="create_or_replace_aggregate_sfunc" value="CREATE OR REPLACE AGGREGATE myavg (numeric) (STYPE = numeric, SFUNC = numeric_add );" db-types="PostgreSQL" />
+ <sql-case id="create_or_replace_aggregate_stype_sfunc" value="CREATE OR REPLACE AGGREGATE myavg (numeric) (STYPE = numeric, SFUNC = numeric_add, FINALFUNC = numeric_out );" db-types="PostgreSQL" />
</sql-cases>
diff --git a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/unsupported/unsupported.xml b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/unsupported/unsupported.xml
index 213d49fbc2c..3077e4d0d15 100644
--- a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/unsupported/unsupported.xml
+++ b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/unsupported/unsupported.xml
@@ -34,7 +34,6 @@
<sql-case id="with_select" value="WITH cte AS (SELECT 0 /*! ) */ SELECT * FROM cte a, cte b;" db-types="MySQL" />
<sql-case id="with_select_comment" value="WITH cte AS /*! ( */ SELECT 0) SELECT * FROM cte a, cte b;" db-types="MySQL" />
<sql-case id="select_cast" value="SELECT cast( NULL AT TIME ZONE 'UTC' AS DATETIME );" db-types="MySQL" />
- <sql-case id="create_aggregate" value="create aggregate my_avg(int4) (stype = avg_state, sfunc = avg_transfn, finalfunc = avg_finalfn)" db-types="PostgreSQL" />
<sql-case id="create_table_as_select" value="create table agg_data_2k as select g from generate_series(0, 1999) g;" db-types="PostgreSQL" />
<sql-case id="create_foreign_data_wrapper" value="CREATE FOREIGN DATA WRAPPER alt_fdw1" db-types="PostgreSQL" />
<sql-case id="create_server" value="CREATE SERVER alt_fserv1 FOREIGN DATA WRAPPER alt_fdw1;" db-types="PostgreSQL" />
@@ -3579,98 +3578,6 @@
<sql-case id="alter_by_postgresql_source_test_case459" value="ALTER TYPE test_typex DROP ATTRIBUTE a;" db-types="PostgreSQL" />
<sql-case id="alter_by_postgresql_source_test_case460" value="ALTER TYPE tt_t0 DROP ATTRIBUTE z;" db-types="PostgreSQL" />
<sql-case id="analyze_by_postgresql_source_test_case1" value="ANALYZE (nonexistent-arg) does_not_exist;" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case8" value="CREATE AGGREGATE addr_nsp.genaggr(int4) (sfunc = int4pl, stype = int4);" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case9" value="CREATE AGGREGATE alt_agg1 ( sfunc1 = int4pl, basetype = int4, stype1 = int4, initcond = 0 );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case10" value="CREATE AGGREGATE alt_agg1 ( sfunc1 = int4pl, basetype = int4, stype1 = int4, initcond = 100 );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case11" value="CREATE AGGREGATE alt_agg2 ( sfunc1 = int4mi, basetype = int4, stype1 = int4, initcond = -100 );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case12" value="CREATE AGGREGATE alt_agg2 ( sfunc1 = int4mi, basetype = int4, stype1 = int4, initcond = 0 );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case13" value="CREATE AGGREGATE array_larger_accum (anyarray) ( sfunc = array_larger, stype = anyarray, initcond = '{}' );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case14" value="CREATE AGGREGATE balk(int4) ( SFUNC = balkifnull(int8, int4), STYPE = int8, PARALLEL = SAFE, INITCOND = '0' );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case15" value="CREATE AGGREGATE balk(int4) ( SFUNC = int4_sum(int8, int4), STYPE = int8, COMBINEFUNC = balkifnull(int8, int8), PARALLEL = SAFE, INITCOND = '0' );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case16" value="CREATE AGGREGATE case_agg ( "Sfunc1" = int4pl, "Basetype" = int4, "Stype1" = int4, "Initcond1" = '0', "Parallel" = safe );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case17" value="CREATE AGGREGATE case_agg(float8) ( "Stype" = internal, "Sfunc" = ordered_set_transition, "Finalfunc" = percentile_disc_final, "Finalfunc_extra" = true, "Finalfunc_modify" = read_write, "Parallel" = safe );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case18" value="CREATE AGGREGATE invalidsumdouble (float8) ( stype = float8, sfunc = float8pl, mstype = float8, msfunc = float8pl, minvfunc = float8mi_n );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case19" value="CREATE AGGREGATE logging_agg_nonstrict (anyelement) ( stype = text, sfunc = logging_sfunc_nonstrict, mstype = text, msfunc = logging_msfunc_nonstrict, minvfunc = logging_minvfunc_nonstrict );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case20" value="CREATE AGGREGATE logging_agg_nonstrict_initcond (anyelement) ( stype = text, sfunc = logging_sfunc_nonstrict, mstype = text, msfunc = logging_msfunc_nonstrict, minvfunc = logging_minvfunc_nonstrict, initcond = 'I', minitcond = 'MI' );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case21" value="CREATE AGGREGATE logging_agg_strict (text) ( stype = text, sfunc = logging_sfunc_strict, mstype = text, msfunc = logging_msfunc_strict, minvfunc = logging_minvfunc_strict );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case22" value="CREATE AGGREGATE logging_agg_strict_initcond (anyelement) ( stype = text, sfunc = logging_sfunc_strict, mstype = text, msfunc = logging_msfunc_strict, minvfunc = logging_minvfunc_strict, initcond = 'I', minitcond = 'MI' );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case23" value="CREATE AGGREGATE myaggn01a(*) (SFUNC = stfnp, STYPE = int4[], FINALFUNC = ffnp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case24" value="CREATE AGGREGATE myaggn01b(*) (SFUNC = stfnp, STYPE = int4[], INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case25" value="CREATE AGGREGATE myaggn02a(*) (SFUNC = stfnp, STYPE = anyarray, FINALFUNC = ffnp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case26" value="CREATE AGGREGATE myaggn02b(*) (SFUNC = stfnp, STYPE = anyarray, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case27" value="CREATE AGGREGATE myaggn03a(*) (SFUNC = stfp, STYPE = int4[], FINALFUNC = ffnp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case28" value="CREATE AGGREGATE myaggn04a(*) (SFUNC = stfp, STYPE = anyarray, FINALFUNC = ffnp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case29" value="CREATE AGGREGATE myaggn05a(BASETYPE = int, SFUNC = tfnp, STYPE = int[], FINALFUNC = ffnp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case30" value="CREATE AGGREGATE myaggn05b(BASETYPE = int, SFUNC = tfnp, STYPE = int[], INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case31" value="CREATE AGGREGATE myaggn06a(BASETYPE = int, SFUNC = tf2p, STYPE = int[], FINALFUNC = ffnp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case32" value="CREATE AGGREGATE myaggn06b(BASETYPE = int, SFUNC = tf2p, STYPE = int[], INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case33" value="CREATE AGGREGATE myaggn07a(BASETYPE = anyelement, SFUNC = tfnp, STYPE = int[], FINALFUNC = ffnp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case34" value="CREATE AGGREGATE myaggn07b(BASETYPE = anyelement, SFUNC = tfnp, STYPE = int[], INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case35" value="CREATE AGGREGATE myaggn08a(BASETYPE = anyelement, SFUNC = tf2p, STYPE = int[], FINALFUNC = ffnp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case36" value="CREATE AGGREGATE myaggn08b(BASETYPE = anyelement, SFUNC = tf2p, STYPE = int[], INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case37" value="CREATE AGGREGATE myaggn09a(BASETYPE = int, SFUNC = tf1p, STYPE = int[], FINALFUNC = ffnp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case38" value="CREATE AGGREGATE myaggn10a(BASETYPE = int, SFUNC = tfp, STYPE = int[], FINALFUNC = ffnp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case39" value="CREATE AGGREGATE myaggn11a(BASETYPE = anyelement, SFUNC = tf1p, STYPE = int[], FINALFUNC = ffnp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case40" value="CREATE AGGREGATE myaggn12a(BASETYPE = anyelement, SFUNC = tfp, STYPE = int[], FINALFUNC = ffnp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case41" value="CREATE AGGREGATE myaggn13a(BASETYPE = int, SFUNC = tfnp, STYPE = anyarray, FINALFUNC = ffnp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case42" value="CREATE AGGREGATE myaggn13b(BASETYPE = int, SFUNC = tfnp, STYPE = anyarray, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case43" value="CREATE AGGREGATE myaggn14a(BASETYPE = int, SFUNC = tf2p, STYPE = anyarray, FINALFUNC = ffnp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case44" value="CREATE AGGREGATE myaggn14b(BASETYPE = int, SFUNC = tf2p, STYPE = anyarray, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case45" value="CREATE AGGREGATE myaggn15a(BASETYPE = anyelement, SFUNC = tfnp, STYPE = anyarray, FINALFUNC = ffnp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case46" value="CREATE AGGREGATE myaggn15b(BASETYPE = anyelement, SFUNC = tfnp, STYPE = anyarray, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case47" value="CREATE AGGREGATE myaggn16a(BASETYPE = anyelement, SFUNC = tf2p, STYPE = anyarray, FINALFUNC = ffnp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case48" value="CREATE AGGREGATE myaggn16b(BASETYPE = anyelement, SFUNC = tf2p, STYPE = anyarray, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case49" value="CREATE AGGREGATE myaggn17a(BASETYPE = int, SFUNC = tf1p, STYPE = anyarray, FINALFUNC = ffnp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case50" value="CREATE AGGREGATE myaggn18a(BASETYPE = int, SFUNC = tfp, STYPE = anyarray, FINALFUNC = ffnp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case51" value="CREATE AGGREGATE myaggn19a(BASETYPE = anyelement, SFUNC = tf1p, STYPE = anyarray, FINALFUNC = ffnp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case52" value="CREATE AGGREGATE myaggn20a(BASETYPE = anyelement, SFUNC = tfp, STYPE = anyarray, FINALFUNC = ffnp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case53" value="CREATE AGGREGATE myaggp01a(*) (SFUNC = stfnp, STYPE = int4[], FINALFUNC = ffp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case54" value="CREATE AGGREGATE myaggp02a(*) (SFUNC = stfnp, STYPE = anyarray, FINALFUNC = ffp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case55" value="CREATE AGGREGATE myaggp03a(*) (SFUNC = stfp, STYPE = int4[], FINALFUNC = ffp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case56" value="CREATE AGGREGATE myaggp03b(*) (SFUNC = stfp, STYPE = int4[], INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case57" value="CREATE AGGREGATE myaggp04a(*) (SFUNC = stfp, STYPE = anyarray, FINALFUNC = ffp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case58" value="CREATE AGGREGATE myaggp04b(*) (SFUNC = stfp, STYPE = anyarray, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case59" value="CREATE AGGREGATE myaggp05a(BASETYPE = int, SFUNC = tfnp, STYPE = int[], FINALFUNC = ffp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case60" value="CREATE AGGREGATE myaggp06a(BASETYPE = int, SFUNC = tf2p, STYPE = int[], FINALFUNC = ffp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case61" value="CREATE AGGREGATE myaggp07a(BASETYPE = anyelement, SFUNC = tfnp, STYPE = int[], FINALFUNC = ffp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case62" value="CREATE AGGREGATE myaggp08a(BASETYPE = anyelement, SFUNC = tf2p, STYPE = int[], FINALFUNC = ffp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case63" value="CREATE AGGREGATE myaggp09a(BASETYPE = int, SFUNC = tf1p, STYPE = int[], FINALFUNC = ffp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case64" value="CREATE AGGREGATE myaggp09b(BASETYPE = int, SFUNC = tf1p, STYPE = int[], INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case65" value="CREATE AGGREGATE myaggp10a(BASETYPE = int, SFUNC = tfp, STYPE = int[], FINALFUNC = ffp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case66" value="CREATE AGGREGATE myaggp10b(BASETYPE = int, SFUNC = tfp, STYPE = int[], INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case67" value="CREATE AGGREGATE myaggp11a(BASETYPE = anyelement, SFUNC = tf1p, STYPE = int[], FINALFUNC = ffp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case68" value="CREATE AGGREGATE myaggp11b(BASETYPE = anyelement, SFUNC = tf1p, STYPE = int[], INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case69" value="CREATE AGGREGATE myaggp12a(BASETYPE = anyelement, SFUNC = tfp, STYPE = int[], FINALFUNC = ffp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case70" value="CREATE AGGREGATE myaggp12b(BASETYPE = anyelement, SFUNC = tfp, STYPE = int[], INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case71" value="CREATE AGGREGATE myaggp13a(BASETYPE = int, SFUNC = tfnp, STYPE = anyarray, FINALFUNC = ffp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case72" value="CREATE AGGREGATE myaggp14a(BASETYPE = int, SFUNC = tf2p, STYPE = anyarray, FINALFUNC = ffp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case73" value="CREATE AGGREGATE myaggp15a(BASETYPE = anyelement, SFUNC = tfnp, STYPE = anyarray, FINALFUNC = ffp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case74" value="CREATE AGGREGATE myaggp16a(BASETYPE = anyelement, SFUNC = tf2p, STYPE = anyarray, FINALFUNC = ffp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case75" value="CREATE AGGREGATE myaggp17a(BASETYPE = int, SFUNC = tf1p, STYPE = anyarray, FINALFUNC = ffp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case76" value="CREATE AGGREGATE myaggp17b(BASETYPE = int, SFUNC = tf1p, STYPE = anyarray, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case77" value="CREATE AGGREGATE myaggp18a(BASETYPE = int, SFUNC = tfp, STYPE = anyarray, FINALFUNC = ffp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case78" value="CREATE AGGREGATE myaggp18b(BASETYPE = int, SFUNC = tfp, STYPE = anyarray, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case79" value="CREATE AGGREGATE myaggp19a(BASETYPE = anyelement, SFUNC = tf1p, STYPE = anyarray, FINALFUNC = ffp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case80" value="CREATE AGGREGATE myaggp19b(BASETYPE = anyelement, SFUNC = tf1p, STYPE = anyarray, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case81" value="CREATE AGGREGATE myaggp20a(BASETYPE = anyelement, SFUNC = tfp, STYPE = anyarray, FINALFUNC = ffp, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case82" value="CREATE AGGREGATE myaggp20b(BASETYPE = anyelement, SFUNC = tfp, STYPE = anyarray, INITCOND = '{}');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case83" value="CREATE AGGREGATE myavg (numeric) ( stype = internal, sfunc = numeric_avg_accum, finalfunc = numeric_avg );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case84" value="CREATE AGGREGATE myavg (numeric) ( stype = internal, sfunc = numeric_avg_accum, finalfunc = numeric_avg, serialfunc = numeric_avg_serialize, deserialfunc = numeric_avg_deserialize, combinefunc = numeric_avg_combine, finalfunc_modify = shareable );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case85" value="CREATE AGGREGATE myavg (numeric) ( stype = internal, sfunc = numeric_avg_accum, serialfunc = numeric_avg_deserialize, deserialfunc = numeric_avg_deserialize );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case86" value="CREATE AGGREGATE myavg (numeric) ( stype = internal, sfunc = numeric_avg_accum, serialfunc = numeric_avg_serialize );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case87" value="CREATE AGGREGATE myavg (numeric) ( stype = internal, sfunc = numeric_avg_accum, serialfunc = numeric_avg_serialize, deserialfunc = numeric_avg_deserialize, combinefunc = int4larger );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case88" value="CREATE AGGREGATE myavg (numeric) ( stype = internal, sfunc = numeric_avg_accum, serialfunc = numeric_avg_serialize, deserialfunc = numeric_avg_serialize );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case89" value="CREATE AGGREGATE mysum (int) ( stype = int, sfunc = int4pl, parallel = pear );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case90" value="CREATE AGGREGATE mysum2(anyelement,anyelement) (SFUNC = sum3, STYPE = anyelement, INITCOND = '0');" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case91" value="CREATE AGGREGATE newavg ( sfunc = int4_avg_accum, basetype = int4, stype = _int8, finalfunc = int8_avg, initcond1 = '{0,0}' );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case92" value="CREATE AGGREGATE newcnt ("any") ( sfunc = int8inc_any, stype = int8, initcond = '0' );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case93" value="CREATE AGGREGATE newcnt (*) ( sfunc = int8inc, stype = int8, initcond = '0', parallel = safe );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case94" value="CREATE AGGREGATE newsum ( sfunc1 = int4pl, basetype = int4, stype1 = int4, initcond1 = '0' );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case95" value="CREATE AGGREGATE oldcnt ( sfunc = int8inc, basetype = 'ANY', stype = int8, initcond = '0' );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case96" value="CREATE AGGREGATE schema_two.newton (BASETYPE = int, SFUNC = schema_two.add, STYPE = int);" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case97" value="CREATE AGGREGATE sum_int_randomrestart (int4) ( stype = int4, sfunc = int4pl, mstype = int4, msfunc = int4pl, minvfunc = sum_int_randrestart_minvfunc );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case98" value="CREATE AGGREGATE sumdouble (float8) ( stype = float8, sfunc = float8pl, mstype = float8, msfunc = float8pl, minvfunc = float8mi );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case99" value="CREATE AGGREGATE wrongreturntype (float8) ( stype = float8, sfunc = float8pl, mstype = float8, msfunc = float8pl, minvfunc = float8mi_int );" db-types="PostgreSQL" />
<sql-case id="create_by_postgresql_source_test_case100" value="CREATE CAST (int4 AS casttesttype) WITH FUNCTION int4_casttesttype(int4) AS IMPLICIT;" db-types="PostgreSQL" />
<sql-case id="create_by_postgresql_source_test_case101" value="CREATE CAST (int4 AS casttesttype) WITH INOUT;" db-types="PostgreSQL" />
<sql-case id="create_by_postgresql_source_test_case102" value="CREATE CAST (text AS casttesttype) WITHOUT FUNCTION AS IMPLICIT;" db-types="PostgreSQL" />
@@ -3970,11 +3877,6 @@
<sql-case id="create_by_postgresql_source_test_case396" value="CREATE OPERATOR schema_op1.#*# ( rightarg = int8, procedure = factorial );" db-types="PostgreSQL" />
<sql-case id="create_by_postgresql_source_test_case397" value="CREATE OPERATOR |> ( PROCEDURE = int8gt, LEFTARG = bigint, RIGHTARG = bigint, NEGATOR = <|, COMMUTATOR = <| );" db-types="PostgreSQL" />
<sql-case id="create_by_postgresql_source_test_case398" value="CREATE OPERATOR |@| (PROCEDURE = unnest, RIGHTARG = ANYARRAY);" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case399" value="CREATE OR REPLACE AGGREGATE myavg (numeric) ( stype = internal, sfunc = numeric_avg_accum, finalfunc = numeric_avg, serialfunc = numeric_avg_serialize, deserialfunc = numeric_avg_deserialize, combinefunc = numeric_avg_combine, finalfunc_modify = shareable );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case400" value="CREATE OR REPLACE AGGREGATE myavg (numeric) ( stype = numeric, sfunc = numeric_add );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case401" value="CREATE OR REPLACE AGGREGATE myavg (numeric) ( stype = numeric, sfunc = numeric_add, finalfunc = numeric_out );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case402" value="CREATE OR REPLACE AGGREGATE myavg (order by numeric) ( stype = numeric, sfunc = numeric_add );" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case403" value="CREATE OR REPLACE AGGREGATE sum3 (int8,int8,int8) ( stype = int8, sfunc = sum4 );" db-types="PostgreSQL" />
<sql-case id="create_by_postgresql_source_test_case404" value="CREATE OR REPLACE FUNCTION mylt2 (x text, y text) RETURNS boolean LANGUAGE plpgsql AS $$ declare xx text COLLATE "POSIX" := x; yy text := y; begin return xx < yy; end $$;" db-types="PostgreSQL" />
<sql-case id="create_by_postgresql_source_test_case405" value="CREATE OR REPLACE FUNCTION compare_relfilenode_part(tabname text) RETURNS TABLE (relname name, relkind "char", state text) AS $func$ BEGIN RETURN QUERY EXECUTE format( 'SELECT b.relname, b.relkind, CASE WHEN a.relfilenode = b.relfilenode THEN ''relfilenode is unchanged'' ELSE ''relfilenode has changed&a [...]
<sql-case id="create_by_postgresql_source_test_case406" value="CREATE OR REPLACE FUNCTION create_relfilenode_part(relname text, indname text) RETURNS VOID AS $func$ BEGIN EXECUTE format(' CREATE TABLE %I AS SELECT oid, relname, relfilenode, relkind, reltoastrelid FROM pg_class WHERE oid IN (SELECT relid FROM pg_partition_tree(''%I''));', relname, indname); END $func$ LANGUAGE plpgsql;" db-types="PostgreSQL" />
@@ -6491,30 +6393,6 @@
<sql-case id="low_alter_by_postgresql_source_test_case105" value="alter type rewritetype alter attribute a type varchar cascade;" db-types="PostgreSQL" />
<sql-case id="low_alter_by_postgresql_source_test_case106" value="alter type testdomain2 rename to testdomain3;" db-types="PostgreSQL" />
<sql-case id="low_alter_by_postgresql_source_test_case107" value="alter type two_ints add attribute c two_ints_range;" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case1" value="create aggregate aggfns(integer,integer,text) ( sfunc = aggfns_trans, stype = aggtype[], sspace = 10000, initcond = '{}' );" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case2" value="create aggregate aggfstr(integer,integer,text) ( sfunc = aggf_trans, stype = aggtype[], initcond = '{}' );" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case3" value="create aggregate build_group(anyelement, integer) ( SFUNC = add_group, STYPE = anyarray );" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case4" value="create aggregate build_group(int8, integer) ( SFUNC = add_group, STYPE = int2[] );" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case5" value="create aggregate build_group(int8, integer) ( SFUNC = add_group, STYPE = int8[] );" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case6" value="create aggregate cleast_agg(variadic items anycompatiblearray) ( stype = anycompatible, sfunc = cleast_accum );" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case7" value="create aggregate first_el_agg_any(anyelement) ( SFUNC = first_el_transfn, STYPE = anyarray, FINALFUNC = first_el );" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case8" value="create aggregate first_el_agg_f8(float8) ( SFUNC = array_append, STYPE = float8[], FINALFUNC = first_el );" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case9" value="create aggregate least_agg(int4) ( stype = int8, sfunc = least_accum );" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case10" value="create aggregate least_agg(int4) ( stype = int8, sfunc = least_accum );" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case11" value="create aggregate least_agg(int8) ( stype = int8, sfunc = least_accum );" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case12" value="create aggregate least_agg(variadic items anyarray) ( stype = anyelement, sfunc = least_accum );" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case13" value="create aggregate my_avg(int4) ( stype = avg_state, sfunc = avg_transfn, finalfunc = avg_finalfn );" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case14" value="create aggregate my_avg_init(int4) ( stype = avg_state, sfunc = avg_transfn, finalfunc = avg_finalfn, initcond = '(10,0)' );" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case15" value="create aggregate my_avg_init2(int4) ( stype = avg_state, sfunc = avg_transfn, finalfunc = avg_finalfn, initcond = '(4,0)' );" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case16" value="create aggregate my_half_sum(int4) ( stype = int4, sfunc = sum_transfn, finalfunc = halfsum_finalfn );" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case17" value="create aggregate my_percentile_disc(float8 ORDER BY anyelement) ( stype = internal, sfunc = ordered_set_transition, finalfunc = percentile_disc_final, finalfunc_extra = true, finalfunc_modify = read_write );" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case18" value="create aggregate my_rank(VARIADIC "any" ORDER BY VARIADIC "any") ( stype = internal, sfunc = ordered_set_transition_multi, finalfunc = rank_final, finalfunc_extra = true, hypothetical );" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case19" value="create aggregate my_sum(int4) ( stype = avg_state, sfunc = avg_transfn, finalfunc = sum_finalfn );" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case20" value="create aggregate my_sum(int4) ( stype = int4, sfunc = sum_transfn );" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case21" value="create aggregate my_sum_init(int4) ( stype = avg_state, sfunc = avg_transfn, finalfunc = sum_finalfn, initcond = '(10,0)' );" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case22" value="create aggregate newavg2 (sfunc = int4pl, basetype = int4, stype = int4, finalfunc = int2um, initcond = '0');" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case23" value="create aggregate newcnt1 (sfunc = int4inc, stype = int4, initcond = '0');" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case24" value="create aggregate sum2(int8,int8) ( sfunc = sum3, stype = int8, initcond = '0' );" db-types="PostgreSQL" />
<sql-case id="low_create_by_postgresql_source_test_case25" value="create cast (bigint as xfloat8) without function;" db-types="PostgreSQL" />
<sql-case id="low_create_by_postgresql_source_test_case26" value="create cast (float4 as xfloat4) without function;" db-types="PostgreSQL" />
<sql-case id="low_create_by_postgresql_source_test_case27" value="create cast (float8 as xfloat8) without function;" db-types="PostgreSQL" />