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 0a939633b7e Support Parsing `ALTER TYPE` in PostgreSQL (#20618)
0a939633b7e is described below
commit 0a939633b7ec4586011e3a086ca5ff666ac6dd53
Author: Everly Precia Suresh <[email protected]>
AuthorDate: Sun Aug 28 14:08:08 2022 +0530
Support Parsing `ALTER TYPE` in PostgreSQL (#20618)
* Proof read grammar
* Support Parsing ALTER TYPE in PostgreSQL
---
.../main/antlr4/imports/postgresql/DDLStatement.g4 | 3 +-
.../parser/autogen/PostgreSQLStatementParser.g4 | 1 +
.../impl/PostgreSQLDDLStatementSQLVisitor.java | 7 ++
.../ddl/PostgreSQLAlterTypeStatement.java | 29 +++++++
.../resources/sql/supported/ddl/alter-type.xml | 12 +--
.../main/resources/sql/unsupported/unsupported.xml | 89 ----------------------
6 files changed, 44 insertions(+), 97 deletions(-)
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/imports/postgresql/DDLStatement.g4
b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/imports/postgresql/DDLStatement.g4
index ad3cecb52b4..22e8c5edd29 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/imports/postgresql/DDLStatement.g4
+++
b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/imports/postgresql/DDLStatement.g4
@@ -1152,8 +1152,7 @@ alterTypeCmds
alterTypeCmd
: ADD ATTRIBUTE tableFuncElement dropBehavior?
- | DROP ATTRIBUTE ifExists colId dropBehavior?
- | DROP ATTRIBUTE colId dropBehavior?
+ | DROP ATTRIBUTE ifExists? colId dropBehavior?
| ALTER ATTRIBUTE colId setData? TYPE typeName collateClause? dropBehavior?
;
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 c0c0a7acd24..3afb4110c25 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
@@ -177,6 +177,7 @@ execute
| createOperator
| alterTextSearchConfiguration
| createPolicy
+ | alterType
| alterTrigger
) 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 8db79e3f042..a820f378e66 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
@@ -52,6 +52,7 @@ import
org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser.Al
import
org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser.AlterStatisticsContext;
import
org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser.AlterSubscriptionContext;
import
org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser.AlterTriggerContext;
+import
org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser.AlterTypeContext;
import
org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser.AlterTableActionContext;
import
org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser.AlterTableContext;
import
org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser.AlterTablespaceContext;
@@ -229,6 +230,7 @@ import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.postgresql.ddl
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.postgresql.ddl.PostgreSQLAlterStatisticsStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.postgresql.ddl.PostgreSQLAlterSubscriptionStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.postgresql.ddl.PostgreSQLAlterTriggerStatement;
+import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.postgresql.ddl.PostgreSQLAlterTypeStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.postgresql.ddl.PostgreSQLAlterTableStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.postgresql.ddl.PostgreSQLAlterTablespaceStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.postgresql.ddl.PostgreSQLAlterTextSearchStatement;
@@ -516,6 +518,11 @@ public final class PostgreSQLDDLStatementSQLVisitor
extends PostgreSQLStatementS
return new PostgreSQLAlterTriggerStatement();
}
+ @Override
+ public ASTNode visitAlterType(final AlterTypeContext ctx) {
+ return new PostgreSQLAlterTypeStatement();
+ }
+
@Override
public ASTNode visitRenameTableSpecification(final
RenameTableSpecificationContext ctx) {
RenameTableDefinitionSegment result = new
RenameTableDefinitionSegment(ctx.start.getStartIndex(),
ctx.stop.getStopIndex());
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/postgresql/ddl/PostgreSQLAlterTypeStatement.java
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/postgresql/ddl/PostgreSQLAlterTypeStatement.java
new file mode 100644
index 00000000000..0be11aefaad
--- /dev/null
+++
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/postgresql/ddl/PostgreSQLAlterTypeStatement.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.AlterTypeStatement;
+import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.postgresql.PostgreSQLStatement;
+
+/**
+ * PostgreSQL alter type statement.
+ */
+@ToString(callSuper = true)
+public final class PostgreSQLAlterTypeStatement extends AlterTypeStatement
implements PostgreSQLStatement {
+}
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/ddl/alter-type.xml
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/ddl/alter-type.xml
index 50c90882197..93d62f4d78e 100644
---
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/ddl/alter-type.xml
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/ddl/alter-type.xml
@@ -17,10 +17,10 @@
-->
<sql-cases>
- <sql-case id="alter_type_owner" value="ALTER TYPE compfoo1 OWNER TO usr1"
db-types="openGauss" />
- <sql-case id="alter_type_rename" value="ALTER TYPE compfoo RENAME TO
compfoo1;" db-types="openGauss" />
- <sql-case id="alter_type_set_schema" value="ALTER TYPE compfoo1 SET SCHEMA
usr1;" db-types="openGauss" />
- <sql-case id="alter_type_add_attribute" value="ALTER TYPE usr1.compfoo1
ADD ATTRIBUTE f3 int;" db-types="openGauss" />
- <sql-case id="alter_type_add_value" value="ALTER TYPE bugstatus ADD VALUE
IF NOT EXISTS 'regress' BEFORE 'closed';" db-types="openGauss" />
- <sql-case id="alter_type_rename_value" value="ALTER TYPE bugstatus RENAME
VALUE 'create' TO 'new';" db-types="openGauss" />
+ <sql-case id="alter_type_owner" value="ALTER TYPE compfoo1 OWNER TO usr1"
db-types="openGauss,PostgreSQL" />
+ <sql-case id="alter_type_rename" value="ALTER TYPE compfoo RENAME TO
compfoo1;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="alter_type_set_schema" value="ALTER TYPE compfoo1 SET SCHEMA
usr1;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="alter_type_add_attribute" value="ALTER TYPE usr1.compfoo1
ADD ATTRIBUTE f3 int;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="alter_type_add_value" value="ALTER TYPE bugstatus ADD VALUE
IF NOT EXISTS 'regress' BEFORE 'closed';" db-types="openGauss,PostgreSQL" />
+ <sql-case id="alter_type_rename_value" value="ALTER TYPE bugstatus RENAME
VALUE 'create' TO 'new';" db-types="openGauss,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 e454a361744..8129ac0bf9f 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
@@ -3284,55 +3284,6 @@
<sql-case id="alter_by_postgresql_source_test_case387" value="ALTER TABLE
reloptions_test RESET (toast.autovacuum_vacuum_cost_delay);"
db-types="PostgreSQL" />
<sql-case id="alter_by_postgresql_source_test_case388" value="ALTER TABLE
reloptions_test SET (autovacuum_enabled, fillfactor=32);" db-types="PostgreSQL"
/>
<sql-case id="alter_by_postgresql_source_test_case389" value="ALTER TABLE
reloptions_test SET (toast.autovacuum_vacuum_cost_delay = 24);"
db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case412" value="ALTER TYPE
bogon ADD VALUE 'bad';" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case413" value="ALTER TYPE
bogon ADD VALUE 'bad';" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case414" value="ALTER TYPE
bogon ADD VALUE 'ugly';" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case415" value="ALTER TYPE
bogus ADD VALUE 'new';" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case416" value="ALTER TYPE
bogus RENAME TO bogon;" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case417" value="ALTER TYPE
bogus RENAME TO bogon;" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case418" value="ALTER TYPE
bogus RENAME TO bogon;" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case419" value="ALTER TYPE
bogus RENAME VALUE 'good' to 'bad';" db-types="PostgreSQL"
/>
- <sql-case id="alter_by_postgresql_source_test_case420" value="ALTER TYPE
myvarchar SET ( send = myvarcharsend, receive = myvarcharrecv,
typmod_in = varchartypmodin, typmod_out = varchartypmodout, analyze =
ts_typanalyze, subscript = raw_array_subscript_handler );"
db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case421" value="ALTER TYPE
myvarchar SET (storage = extended);" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case422" value="ALTER TYPE
myvarchar SET (storage = extended);" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case423" value="ALTER TYPE
myvarchar SET (storage = plain);" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case424" value="ALTER TYPE
nosuchtype ADD ATTRIBUTE b text;" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case425" value="ALTER TYPE
planets ADD VALUE
'plutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutoplutopluto';"
db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case426" value="ALTER TYPE
planets ADD VALUE 'jupiter' AFTER 'mars';"
db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case427" value="ALTER TYPE
planets ADD VALUE 'mercury' BEFORE 'venus';"
db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case428" value="ALTER TYPE
planets ADD VALUE 'mercury';" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case429" value="ALTER TYPE
planets ADD VALUE 'neptune' AFTER 'uranus';"
db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case430" value="ALTER TYPE
planets ADD VALUE 'pluto' AFTER 'zeus';"
db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case431" value="ALTER TYPE
planets ADD VALUE 'saturn' BEFORE 'uranus';"
db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case432" value="ALTER TYPE
planets ADD VALUE 'uranus';" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case433" value="ALTER TYPE
planets ADD VALUE IF NOT EXISTS 'mercury';" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case434" value="ALTER TYPE
planets ADD VALUE IF NOT EXISTS 'pluto';" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case435" value="ALTER TYPE
rainbow RENAME VALUE 'blue' TO 'green';"
db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case436" value="ALTER TYPE
rainbow RENAME VALUE 'red' TO 'crimson';"
db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case437" value="ALTER TYPE
rainbow RENAME VALUE 'red' TO 'crimson';"
db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case438" value="ALTER TYPE
test_type ADD ATTRIBUTE b text;" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case439" value="ALTER TYPE
test_type ADD ATTRIBUTE b text;" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case440" value="ALTER TYPE
test_type ALTER ATTRIBUTE b SET DATA TYPE integer;" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case441" value="ALTER TYPE
test_type ALTER ATTRIBUTE b SET DATA TYPE varchar;" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case442" value="ALTER TYPE
test_type DROP ATTRIBUTE IF EXISTS c;" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case443" value="ALTER TYPE
test_type DROP ATTRIBUTE a, ADD ATTRIBUTE d boolean;" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case444" value="ALTER TYPE
test_type DROP ATTRIBUTE b;" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case445" value="ALTER TYPE
test_type DROP ATTRIBUTE c;" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case446" value="ALTER TYPE
test_type RENAME ATTRIBUTE a TO aa;" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case447" value="ALTER TYPE
test_type RENAME ATTRIBUTE d TO dd;" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case448" value="ALTER TYPE
test_type1 ALTER ATTRIBUTE b TYPE varchar;" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case449" value="ALTER TYPE
test_type2 ADD ATTRIBUTE c text CASCADE;" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case450" value="ALTER TYPE
test_type2 ADD ATTRIBUTE c text;" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case451" value="ALTER TYPE
test_type2 ALTER ATTRIBUTE b TYPE varchar CASCADE;" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case452" value="ALTER TYPE
test_type2 ALTER ATTRIBUTE b TYPE varchar;" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case453" value="ALTER TYPE
test_type2 DROP ATTRIBUTE b CASCADE;" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case454" value="ALTER TYPE
test_type2 DROP ATTRIBUTE b;" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case455" value="ALTER TYPE
test_type2 RENAME ATTRIBUTE a TO aa CASCADE;" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case456" value="ALTER TYPE
test_type2 RENAME ATTRIBUTE a TO aa;" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case457" value="ALTER TYPE
test_type3 DROP ATTRIBUTE a, ADD ATTRIBUTE b int;" db-types="PostgreSQL" />
- <sql-case id="alter_by_postgresql_source_test_case458" value="ALTER TYPE
test_typex DROP ATTRIBUTE a CASCADE;" db-types="PostgreSQL" />
- <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_case124" value="CREATE
CONSTRAINT TRIGGER trigtest_constraint AFTER INSERT OR UPDATE OR DELETE ON
foreign_schema.foreign_table_1 FOR EACH ROW EXECUTE PROCEDURE dummy_trigger();"
db-types="PostgreSQL" />
<sql-case id="create_by_postgresql_source_test_case183" value="CREATE
FUNCTION addr_nsp.trig() RETURNS TRIGGER LANGUAGE plpgsql AS $$ BEGIN END; $$;"
db-types="PostgreSQL" />
@@ -5208,46 +5159,6 @@
<sql-case id="low_alter_by_postgresql_source_test_case61" value="alter
table anothertab alter column atcol1 type boolean using case when
atcol1 % 2 = 0 then true else fa alter table anothertab drop constraint
anothertab_chk;" db-types="PostgreSQL" />
<sql-case id="low_alter_by_postgresql_source_test_case62" value="alter
table check_con_tbl add check (check_con_function(check_con_tbl.*));"
db-types="PostgreSQL" />
<sql-case id="low_alter_by_postgresql_source_test_case63" value="alter
table rename;" db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case68" value="alter
type alter1.ctype set schema alter1;" db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case69" value="alter
type alter1.ctype set schema alter2;" db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case70" value="alter
type comptype alter attribute r type bigint;" db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case71" value="alter
type comptype alter attribute r type varchar;" db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case72" value="alter
type comptype drop attribute i;" db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case73" value="alter
type comptype drop attribute r;" db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case74" value="alter
type insenum add value 'i1' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case75" value="alter
type insenum add value 'i10' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case76" value="alter
type insenum add value 'i11' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case77" value="alter
type insenum add value 'i12' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case78" value="alter
type insenum add value 'i13' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case79" value="alter
type insenum add value 'i14' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case80" value="alter
type insenum add value 'i15' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case81" value="alter
type insenum add value 'i16' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case82" value="alter
type insenum add value 'i17' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case83" value="alter
type insenum add value 'i18' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case84" value="alter
type insenum add value 'i19' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case85" value="alter
type insenum add value 'i2' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case86" value="alter
type insenum add value 'i20' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case87" value="alter
type insenum add value 'i21' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case88" value="alter
type insenum add value 'i22' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case89" value="alter
type insenum add value 'i23' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case90" value="alter
type insenum add value 'i24' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case91" value="alter
type insenum add value 'i25' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case92" value="alter
type insenum add value 'i26' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case93" value="alter
type insenum add value 'i27' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case94" value="alter
type insenum add value 'i28' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case95" value="alter
type insenum add value 'i29' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case96" value="alter
type insenum add value 'i3' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case97" value="alter
type insenum add value 'i30' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case98" value="alter
type insenum add value 'i4' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case99" value="alter
type insenum add value 'i5' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case100" value="alter
type insenum add value 'i6' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case101" value="alter
type insenum add value 'i7' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case102" value="alter
type insenum add value 'i8' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case103" value="alter
type insenum add value 'i9' before 'L2';"
db-types="PostgreSQL" />
- <sql-case id="low_alter_by_postgresql_source_test_case104" value="alter
type rewritetype alter attribute a type text cascade;" db-types="PostgreSQL" />
- <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_case40" value="create
constraint trigger parted_trig after insert on parted_constr_ancestor
deferrable for each row execute procedure trigger_notice_ab();"
db-types="PostgreSQL" />
<sql-case id="low_create_by_postgresql_source_test_case41" value="create
constraint trigger parted_trig_two after insert on parted_constr deferrable
initially deferred for each row when (bark(new.b) AND new.a % 2 = 1)
execute procedure trigger_notice_ab();" db-types="PostgreSQL" />
<sql-case id="low_create_by_postgresql_source_test_case42" value="create
constraint trigger parted_trigger after update on parted_trigger from
parted_referenced for each row execute procedure trigger_notice_ab();"
db-types="PostgreSQL" />
