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 07:59:14 UTC
[shardingsphere] branch master updated: Support fetch/move/close cursor statement in PostgreSQL (#18485)
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 ae54b48a348 Support fetch/move/close cursor statement in PostgreSQL (#18485)
ae54b48a348 is described below
commit ae54b48a34839b1a57f446efb3c5ee1447b6b16b
Author: Jiaqi Yan <13...@qq.com>
AuthorDate: Tue Jun 21 15:59:08 2022 +0800
Support fetch/move/close cursor statement in PostgreSQL (#18485)
* Support parsing FETCH cursor statement
* Support parsing MOVE cursor statement
* update fetch/move syntax
* update unsupported.xml
---
.../main/antlr4/imports/postgresql/DDLStatement.g4 | 23 +-
.../main/antlr4/imports/postgresql/DMLStatement.g4 | 22 --
.../parser/autogen/PostgreSQLStatementParser.g4 | 2 +
.../impl/PostgreSQLDDLStatementSQLVisitor.java | 25 +++
.../postgresql/ddl/PostgreSQLFetchStatement.java | 51 +++++
.../postgresql/ddl/PostgreSQLMoveStatement.java | 51 +++++
.../src/main/resources/sql/supported/ddl/fetch.xml | 32 +--
.../src/main/resources/sql/supported/ddl/move.xml | 32 +--
.../main/resources/sql/unsupported/unsupported.xml | 231 ---------------------
9 files changed, 183 insertions(+), 286 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 755737adaaa..68c14bc56d6 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
@@ -1787,7 +1787,28 @@ listen
;
move
- : MOVE fetchArgs
+ : MOVE direction? (FROM | IN)? cursorName
+ ;
+
+fetch
+ : FETCH direction? (FROM | IN)? cursorName
+ ;
+
+direction
+ : NEXT
+ | PRIOR
+ | FIRST
+ | LAST
+ | ABSOLUTE signedIconst
+ | RELATIVE signedIconst
+ | signedIconst
+ | ALL
+ | FORWARD
+ | FORWARD signedIconst
+ | FORWARD ALL
+ | BACKWARD
+ | BACKWARD signedIconst
+ | BACKWARD ALL
;
prepare
diff --git a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/imports/postgresql/DMLStatement.g4 b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/imports/postgresql/DMLStatement.g4
index ac61e59b326..7f810615b73 100644
--- a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/imports/postgresql/DMLStatement.g4
+++ b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/imports/postgresql/DMLStatement.g4
@@ -497,26 +497,4 @@ copyWithTableBinary
: COPY BINARY? qualifiedName (FROM | TO) (fileName | STDIN | STDOUT) (USING? DELIMITERS STRING_)? (WITH NULL AS STRING_)?
;
-fetch
- : FETCH fetchArgs
- ;
-
-fetchArgs
- : cursorName
- | (FROM | IN) cursorName
- | NEXT (FROM | IN)? cursorName
- | PRIOR (FROM | IN)? cursorName
- | FIRST (FROM | IN)? cursorName
- | LAST (FROM | IN)? cursorName
- | ABSOLUTE signedIconst (FROM | IN)? cursorName
- | RELATIVE signedIconst (FROM | IN)? cursorName
- | signedIconst (FROM | IN)? cursorName
- | ALL (FROM | IN)? cursorName
- | FORWARD (FROM | IN)? cursorName
- | FORWARD signedIconst (FROM | IN)? cursorName
- | FORWARD ALL (FROM | IN)? cursorName
- | BACKWARD (FROM | IN)? cursorName
- | BACKWARD signedIconst (FROM | IN)? cursorName
- | BACKWARD ALL (FROM | IN)? cursorName
- ;
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 a00c9a3b97d..65dfbc003d0 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
@@ -146,6 +146,8 @@ execute
| dropServer
| alterPolicy
| checkpoint
+ | fetch
+ | move
| close
| cluster
| alterOperator
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 9a0ac3a7974..b22b855d2c0 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
@@ -51,6 +51,8 @@ import org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser.Al
import org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser.AlterTextSearchParserContext;
import org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser.AlterTextSearchTemplateContext;
import org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser.AlterViewContext;
+import org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser.FetchContext;
+import org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser.MoveContext;
import org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser.CloseContext;
import org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser.ClusterContext;
import org.apache.shardingsphere.sql.parser.autogen.PostgreSQLStatementParser.ColumnConstraintContext;
@@ -149,6 +151,7 @@ import org.apache.shardingsphere.sql.parser.sql.common.segment.ddl.constraint.al
import org.apache.shardingsphere.sql.parser.sql.common.segment.ddl.constraint.alter.ModifyConstraintDefinitionSegment;
import org.apache.shardingsphere.sql.parser.sql.common.segment.ddl.constraint.alter.ValidateConstraintDefinitionSegment;
import org.apache.shardingsphere.sql.parser.sql.common.segment.ddl.cursor.CursorNameSegment;
+import org.apache.shardingsphere.sql.parser.sql.common.segment.ddl.cursor.DirectionSegment;
import org.apache.shardingsphere.sql.parser.sql.common.segment.ddl.index.IndexNameSegment;
import org.apache.shardingsphere.sql.parser.sql.common.segment.ddl.index.IndexSegment;
import org.apache.shardingsphere.sql.parser.sql.common.segment.ddl.table.RenameTableDefinitionSegment;
@@ -188,6 +191,8 @@ import org.apache.shardingsphere.sql.parser.sql.dialect.statement.postgresql.ddl
import org.apache.shardingsphere.sql.parser.sql.dialect.statement.postgresql.ddl.PostgreSQLAlterTextSearchStatement;
import org.apache.shardingsphere.sql.parser.sql.dialect.statement.postgresql.ddl.PostgreSQLAlterViewStatement;
import org.apache.shardingsphere.sql.parser.sql.dialect.statement.postgresql.ddl.PostgreSQLCloseStatement;
+import org.apache.shardingsphere.sql.parser.sql.dialect.statement.postgresql.ddl.PostgreSQLFetchStatement;
+import org.apache.shardingsphere.sql.parser.sql.dialect.statement.postgresql.ddl.PostgreSQLMoveStatement;
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;
@@ -1064,6 +1069,26 @@ public final class PostgreSQLDDLStatementSQLVisitor extends PostgreSQLStatementS
return new PostgreSQLDropServerStatement();
}
+ @Override
+ public ASTNode visitFetch(final FetchContext ctx) {
+ PostgreSQLFetchStatement result = new PostgreSQLFetchStatement();
+ result.setCursorName((CursorNameSegment) visit(ctx.cursorName()));
+ if (null != ctx.direction()) {
+ result.setDirection((DirectionSegment) visit(ctx.direction()));
+ }
+ return result;
+ }
+
+ @Override
+ public ASTNode visitMove(final MoveContext ctx) {
+ PostgreSQLMoveStatement result = new PostgreSQLMoveStatement();
+ result.setCursorName((CursorNameSegment) visit(ctx.cursorName()));
+ if (null != ctx.direction()) {
+ result.setDirection((DirectionSegment) visit(ctx.direction()));
+ }
+ return result;
+ }
+
@Override
public ASTNode visitClose(final CloseContext ctx) {
PostgreSQLCloseStatement result = new PostgreSQLCloseStatement();
diff --git a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/postgresql/ddl/PostgreSQLFetchStatement.java b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/postgresql/ddl/PostgreSQLFetchStatement.java
new file mode 100644
index 00000000000..158e55170a5
--- /dev/null
+++ b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/postgresql/ddl/PostgreSQLFetchStatement.java
@@ -0,0 +1,51 @@
+/*
+ * 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.Getter;
+import lombok.Setter;
+import lombok.ToString;
+import org.apache.shardingsphere.sql.parser.sql.common.segment.ddl.cursor.CursorNameSegment;
+import org.apache.shardingsphere.sql.parser.sql.common.segment.ddl.cursor.DirectionSegment;
+import org.apache.shardingsphere.sql.parser.sql.common.statement.AbstractSQLStatement;
+import org.apache.shardingsphere.sql.parser.sql.common.statement.ddl.DDLStatement;
+import org.apache.shardingsphere.sql.parser.sql.dialect.statement.postgresql.PostgreSQLStatement;
+
+import java.util.Optional;
+
+/**
+ * PostgreSQL fetch statement.
+ */
+@Getter
+@Setter
+@ToString
+public final class PostgreSQLFetchStatement extends AbstractSQLStatement implements DDLStatement, PostgreSQLStatement {
+
+ private CursorNameSegment cursorName;
+
+ private DirectionSegment direction;
+
+ /**
+ * Get direction.
+ *
+ * @return direction
+ */
+ public Optional<DirectionSegment> getDirection() {
+ return Optional.ofNullable(direction);
+ }
+}
diff --git a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/postgresql/ddl/PostgreSQLMoveStatement.java b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/postgresql/ddl/PostgreSQLMoveStatement.java
new file mode 100644
index 00000000000..a27764e4f96
--- /dev/null
+++ b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/postgresql/ddl/PostgreSQLMoveStatement.java
@@ -0,0 +1,51 @@
+/*
+ * 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.Getter;
+import lombok.Setter;
+import lombok.ToString;
+import org.apache.shardingsphere.sql.parser.sql.common.segment.ddl.cursor.CursorNameSegment;
+import org.apache.shardingsphere.sql.parser.sql.common.segment.ddl.cursor.DirectionSegment;
+import org.apache.shardingsphere.sql.parser.sql.common.statement.AbstractSQLStatement;
+import org.apache.shardingsphere.sql.parser.sql.common.statement.ddl.DDLStatement;
+import org.apache.shardingsphere.sql.parser.sql.dialect.statement.postgresql.PostgreSQLStatement;
+
+import java.util.Optional;
+
+/**
+ * PostgreSQL move statement.
+ */
+@Getter
+@Setter
+@ToString
+public final class PostgreSQLMoveStatement extends AbstractSQLStatement implements DDLStatement, PostgreSQLStatement {
+
+ private CursorNameSegment cursorName;
+
+ private DirectionSegment direction;
+
+ /**
+ * Get direction.
+ *
+ * @return direction
+ */
+ public Optional<DirectionSegment> getDirection() {
+ return Optional.ofNullable(direction);
+ }
+}
diff --git a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/ddl/fetch.xml b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/ddl/fetch.xml
index c84a48001e4..9e00d6ac7c7 100644
--- a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/ddl/fetch.xml
+++ b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/ddl/fetch.xml
@@ -17,20 +17,20 @@
-->
<sql-cases>
- <sql-case id="fetch_cursor" value="FETCH t_order_cursor;" db-types="openGauss" />
- <sql-case id="fetch_cursor_with_from" value="FETCH FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="fetch_cursor_with_next" value="FETCH NEXT FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="fetch_cursor_with_prior" value="FETCH PRIOR FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="fetch_cursor_with_first" value="FETCH FIRST FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="fetch_cursor_with_last" value="FETCH LAST FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="fetch_cursor_with_absolute_count" value="FETCH ABSOLUTE 10 FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="fetch_cursor_with_relative_count" value="FETCH RELATIVE 10 FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="fetch_cursor_with_count" value="FETCH 10 FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="fetch_cursor_with_all" value="FETCH ALL FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="fetch_cursor_with_forward" value="FETCH FORWARD FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="fetch_cursor_with_forward_count" value="FETCH FORWARD 10 FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="fetch_cursor_with_forward_all" value="FETCH FORWARD ALL FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="fetch_cursor_with_backward" value="FETCH BACKWARD FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="fetch_cursor_with_backward_count" value="FETCH BACKWARD 10 FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="fetch_cursor_with_backward_all" value="FETCH BACKWARD ALL FROM t_order_cursor;" db-types="openGauss" />
+ <sql-case id="fetch_cursor" value="FETCH t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="fetch_cursor_with_from" value="FETCH FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="fetch_cursor_with_next" value="FETCH NEXT FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="fetch_cursor_with_prior" value="FETCH PRIOR FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="fetch_cursor_with_first" value="FETCH FIRST FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="fetch_cursor_with_last" value="FETCH LAST FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="fetch_cursor_with_absolute_count" value="FETCH ABSOLUTE 10 FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="fetch_cursor_with_relative_count" value="FETCH RELATIVE 10 FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="fetch_cursor_with_count" value="FETCH 10 FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="fetch_cursor_with_all" value="FETCH ALL FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="fetch_cursor_with_forward" value="FETCH FORWARD FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="fetch_cursor_with_forward_count" value="FETCH FORWARD 10 FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="fetch_cursor_with_forward_all" value="FETCH FORWARD ALL FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="fetch_cursor_with_backward" value="FETCH BACKWARD FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="fetch_cursor_with_backward_count" value="FETCH BACKWARD 10 FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="fetch_cursor_with_backward_all" value="FETCH BACKWARD ALL FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
</sql-cases>
diff --git a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/ddl/move.xml b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/ddl/move.xml
index 058352eea55..af9384be6c3 100644
--- a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/ddl/move.xml
+++ b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/ddl/move.xml
@@ -17,20 +17,20 @@
-->
<sql-cases>
- <sql-case id="move_cursor" value="MOVE t_order_cursor;" db-types="openGauss" />
- <sql-case id="move_cursor_with_from" value="MOVE FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="move_cursor_with_next" value="MOVE NEXT FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="move_cursor_with_prior" value="MOVE PRIOR FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="move_cursor_with_first" value="MOVE FIRST FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="move_cursor_with_last" value="MOVE LAST FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="move_cursor_with_absolute_count" value="MOVE ABSOLUTE 10 FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="move_cursor_with_relative_count" value="MOVE RELATIVE 10 FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="move_cursor_with_count" value="MOVE 10 FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="move_cursor_with_all" value="MOVE ALL FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="move_cursor_with_forward" value="MOVE FORWARD FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="move_cursor_with_forward_count" value="MOVE FORWARD 10 FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="move_cursor_with_forward_all" value="MOVE FORWARD ALL FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="move_cursor_with_backward" value="MOVE BACKWARD FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="move_cursor_with_backward_count" value="MOVE BACKWARD 10 FROM t_order_cursor;" db-types="openGauss" />
- <sql-case id="move_cursor_with_backward_all" value="MOVE BACKWARD ALL FROM t_order_cursor;" db-types="openGauss" />
+ <sql-case id="move_cursor" value="MOVE t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="move_cursor_with_from" value="MOVE FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="move_cursor_with_next" value="MOVE NEXT FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="move_cursor_with_prior" value="MOVE PRIOR FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="move_cursor_with_first" value="MOVE FIRST FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="move_cursor_with_last" value="MOVE LAST FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="move_cursor_with_absolute_count" value="MOVE ABSOLUTE 10 FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="move_cursor_with_relative_count" value="MOVE RELATIVE 10 FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="move_cursor_with_count" value="MOVE 10 FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="move_cursor_with_all" value="MOVE ALL FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="move_cursor_with_forward" value="MOVE FORWARD FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="move_cursor_with_forward_count" value="MOVE FORWARD 10 FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="move_cursor_with_forward_all" value="MOVE FORWARD ALL FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="move_cursor_with_backward" value="MOVE BACKWARD FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="move_cursor_with_backward_count" value="MOVE BACKWARD 10 FROM t_order_cursor;" db-types="openGauss,PostgreSQL" />
+ <sql-case id="move_cursor_with_backward_all" value="MOVE BACKWARD ALL FROM t_order_cursor;" 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 3077e4d0d15..9df93c5d853 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
@@ -4527,168 +4527,6 @@
<sql-case id="explain_by_postgresql_source_test_case118" value="EXPLAIN (costs off) CREATE MATERIALIZED VIEW mvtest_tm AS SELECT type, sum(amt) AS totamt FROM mvtest_t GROUP BY type WITH NO DATA;" db-types="PostgreSQL" />
<sql-case id="explain_by_postgresql_source_test_case119" value="EXPLAIN (costs off) CREATE MATERIALIZED VIEW mvtest_tvm AS SELECT * FROM mvtest_tv ORDER BY type;" db-types="PostgreSQL" />
<sql-case id="explain_by_postgresql_source_test_case120" value="EXPLAIN (costs off) CREATE MATERIALIZED VIEW mvtest_tvvm AS SELECT * FROM mvtest_tvv;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case1" value="FETCH 1 FROM c1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case2" value="FETCH 1 FROM c1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case3" value="FETCH 1 FROM c1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case4" value="FETCH 1 FROM c1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case5" value="FETCH 1 FROM c1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case6" value="FETCH 1 FROM c1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case7" value="FETCH 1 FROM c1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case8" value="FETCH 1 FROM foo24;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case9" value="FETCH 1 FROM foo24;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case10" value="FETCH 1 FROM foo;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case11" value="FETCH 1 FROM foo;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case12" value="FETCH 1 in foo1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case13" value="FETCH 10 in foo10;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case14" value="FETCH 11 in foo11;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case15" value="FETCH 12 in foo12;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case16" value="FETCH 13 in foo13;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case17" value="FETCH 14 in foo14;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case18" value="FETCH 15 in foo15;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case19" value="FETCH 16 in foo16;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case20" value="FETCH 17 in foo17;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case21" value="FETCH 18 in foo18;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case22" value="FETCH 19 in foo19;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case23" value="FETCH 2 FROM c1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case24" value="FETCH 2 in foo2;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case25" value="FETCH 20 in foo20;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case26" value="FETCH 21 in foo21;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case27" value="FETCH 22 in foo22;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case28" value="FETCH 23 in foo23;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case29" value="FETCH 3 in foo3;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case30" value="FETCH 4 in foo4;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case31" value="FETCH 5 in foo5;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case32" value="FETCH 6 in foo6;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case33" value="FETCH 7 in foo7;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case34" value="FETCH 8 in foo8;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case35" value="FETCH 9 in foo9;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case36" value="FETCH ABSOLUTE -1 FROM foo25;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case37" value="FETCH ABSOLUTE 1 FROM c1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case38" value="FETCH ABSOLUTE 1 FROM current_check_cursor;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case39" value="FETCH ABSOLUTE 1 FROM current_check_cursor;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case40" value="FETCH ABSOLUTE 1 FROM foo24;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case41" value="FETCH ABSOLUTE 12 FROM c1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case42" value="FETCH ABSOLUTE 13 FROM c1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case43" value="FETCH ABSOLUTE 2 FROM foo24;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case44" value="FETCH ABSOLUTE 4 FROM foo25ns;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case45" value="FETCH ABSOLUTE 4 FROM foo25ns;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case46" value="FETCH ABSOLUTE 8 FROM c1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case47" value="FETCH ALL FROM c1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case48" value="FETCH ALL FROM c1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case49" value="FETCH ALL FROM c1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case50" value="FETCH ALL FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case51" value="FETCH ALL FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case52" value="FETCH ALL FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case53" value="FETCH BACKWARD 1 FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case54" value="FETCH BACKWARD 1 FROM foo24;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case55" value="FETCH BACKWARD FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case56" value="FETCH BACKWARD FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case57" value="FETCH BACKWARD FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case58" value="FETCH BACKWARD FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case59" value="FETCH BACKWARD FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case60" value="FETCH BACKWARD FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case61" value="FETCH BACKWARD FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case62" value="FETCH BACKWARD FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case63" value="FETCH BACKWARD FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case64" value="FETCH BACKWARD FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case65" value="FETCH BACKWARD FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case66" value="FETCH BACKWARD FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case67" value="FETCH BACKWARD FROM foo25;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case68" value="FETCH FIRST FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case69" value="FETCH FIRST FROM tablesample_cur;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case70" value="FETCH FIRST FROM tablesample_cur;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case71" value="FETCH FIRST c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case72" value="FETCH FROM c1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case73" value="FETCH FROM c1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case74" value="FETCH FROM foo25;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case75" value="FETCH FROM foo25;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case76" value="FETCH FROM foo25;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case77" value="FETCH FROM foo25ns;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case78" value="FETCH FROM foo25ns;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case79" value="FETCH FROM foo25ns;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case80" value="FETCH FROM foo26;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case81" value="FETCH LAST FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case82" value="FETCH LAST FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case83" value="FETCH LAST c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case84" value="FETCH NEXT FROM c1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case85" value="FETCH NEXT FROM c1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case86" value="FETCH NEXT FROM c1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case87" value="FETCH NEXT FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case88" value="FETCH NEXT FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case89" value="FETCH NEXT FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case90" value="FETCH NEXT FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case91" value="FETCH NEXT FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case92" value="FETCH NEXT FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case93" value="FETCH NEXT FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case94" value="FETCH NEXT FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case95" value="FETCH NEXT FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case96" value="FETCH NEXT FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case97" value="FETCH NEXT FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case98" value="FETCH NEXT FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case99" value="FETCH NEXT FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case100" value="FETCH NEXT FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case101" value="FETCH NEXT FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case102" value="FETCH NEXT FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case103" value="FETCH NEXT FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case104" value="FETCH NEXT FROM c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case105" value="FETCH NEXT FROM tablesample_cur;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case106" value="FETCH NEXT FROM tablesample_cur;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case107" value="FETCH NEXT FROM tablesample_cur;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case108" value="FETCH NEXT FROM tablesample_cur;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case109" value="FETCH NEXT FROM tablesample_cur;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case110" value="FETCH NEXT FROM tablesample_cur;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case111" value="FETCH NEXT FROM tablesample_cur;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case112" value="FETCH NEXT FROM tablesample_cur;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case113" value="FETCH NEXT FROM tablesample_cur;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case114" value="FETCH NEXT FROM tablesample_cur;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case115" value="FETCH NEXT c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case116" value="FETCH NEXT c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case117" value="FETCH PRIOR c;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case118" value="FETCH RELATIVE 0 FROM c1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case119" value="FETCH RELATIVE 0 FROM c1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case120" value="FETCH RELATIVE 0 FROM c1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case121" value="FETCH RELATIVE 1 FROM current_check_cursor;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case122" value="FETCH RELATIVE 1 FROM current_check_cursor;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case123" value="FETCH all in foo13;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case124" value="FETCH all in foo14;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case125" value="FETCH all in foo15;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case126" value="FETCH all in foo16;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case127" value="FETCH all in foo17;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case128" value="FETCH all in foo18;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case129" value="FETCH all in foo19;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case130" value="FETCH all in foo20;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case131" value="FETCH all in foo21;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case132" value="FETCH all in foo22;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case133" value="FETCH all in foo23;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case134" value="FETCH all in foo24;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case135" value="FETCH all in foo25;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case136" value="FETCH backward 1 in foo23;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case137" value="FETCH backward 10 in foo14;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case138" value="FETCH backward 11 in foo13;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case139" value="FETCH backward 12 in foo12;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case140" value="FETCH backward 13 in foo11;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case141" value="FETCH backward 14 in foo10;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case142" value="FETCH backward 15 in foo9;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case143" value="FETCH backward 16 in foo8;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case144" value="FETCH backward 17 in foo7;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case145" value="FETCH backward 18 in foo6;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case146" value="FETCH backward 19 in foo5;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case147" value="FETCH backward 2 in foo22;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case148" value="FETCH backward 20 in foo4;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case149" value="FETCH backward 21 in foo3;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case150" value="FETCH backward 22 in foo2;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case151" value="FETCH backward 23 in foo1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case152" value="FETCH backward 3 in foo21;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case153" value="FETCH backward 4 in foo20;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case154" value="FETCH backward 5 in foo19;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case155" value="FETCH backward 6 in foo18;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case156" value="FETCH backward 7 in foo17;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case157" value="FETCH backward 8 in foo16;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case158" value="FETCH backward 9 in foo15;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case159" value="FETCH c1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case160" value="FETCH c1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case161" value="FETCH c1;" db-types="PostgreSQL" />
- <sql-case id="fetch_by_postgresql_source_test_case162" value="FETCH next from hsc;" db-types="PostgreSQL" />
<sql-case id="import_by_postgresql_source_test_case1" value="IMPORT FOREIGN SCHEMA s1 EXCEPT (t1) FROM SERVER s9 INTO public;" db-types="PostgreSQL" />
<sql-case id="import_by_postgresql_source_test_case2" value="IMPORT FOREIGN SCHEMA s1 EXCEPT (t1, t2) FROM SERVER s9 INTO public OPTIONS (option1 'value1', option2 'value2');" db-types="PostgreSQL" />
<sql-case id="import_by_postgresql_source_test_case3" value="IMPORT FOREIGN SCHEMA s1 FROM SERVER s9 INTO public;" db-types="PostgreSQL" />
@@ -4914,11 +4752,6 @@
<sql-case id="lock_by_postgresql_source_test_case39" value="LOCK hs1;" db-types="PostgreSQL" />
<sql-case id="lock_by_postgresql_source_test_case40" value="LOCK lock_tbl1 IN ROW SHARE MODE;" db-types="PostgreSQL" />
<sql-case id="lock_by_postgresql_source_test_case41" value="LOCK lock_tbl1 IN SHARE ROW EXCLUSIVE MODE;" db-types="PostgreSQL" />
- <sql-case id="move_by_postgresql_source_test_case1" value="MOVE BACKWARD 10000 FROM c;" db-types="PostgreSQL" />
- <sql-case id="move_by_postgresql_source_test_case2" value="MOVE BACKWARD ALL FROM c;" db-types="PostgreSQL" />
- <sql-case id="move_by_postgresql_source_test_case3" value="MOVE BACKWARD ALL IN c1;" db-types="PostgreSQL" />
- <sql-case id="move_by_postgresql_source_test_case4" value="MOVE BACKWARD ALL IN xc;" db-types="PostgreSQL" />
- <sql-case id="move_by_postgresql_source_test_case5" value="MOVE FORWARD ALL FROM c;" db-types="PostgreSQL" />
<sql-case id="notify_by_postgresql_source_test_case1" value="NOTIFY notify_async2;" db-types="PostgreSQL" />
<sql-case id="prepare_by_postgresql_source_test_case1" value="PREPARE TRANSACTION 'foo1';" db-types="PostgreSQL" />
<sql-case id="prepare_by_postgresql_source_test_case2" value="PREPARE TRANSACTION 'foo2';" db-types="PostgreSQL" />
@@ -7116,67 +6949,6 @@
<sql-case id="low_explain_by_postgresql_source_test_case21" value="explain (verbose, costs off) with recursive search_graph(f, t, label) as ( select * from graph g union all select g.* from graph g, search_graph sg where g.f = sg.t ) cycle f, t set is_cycle using path select * from search_graph;" db-types="PostgreSQL" />
<sql-case id="low_explain_by_postgresql_source_test_case22" value="explain (verbose, costs off) with recursive search_graph(f, t, label) as ( select * from graph0 g union all select g.* from graph0 g, search_graph sg where g.f = sg.t ) search breadth first by f, t set seq select * from search_graph order by seq;" db-types="PostgreSQL" />
<sql-case id="low_explain_by_postgresql_source_test_case23" value="explain (verbose, costs off) with recursive search_graph(f, t, label) as ( select * from graph0 g union all select g.* from graph0 g, search_graph sg where g.f = sg.t ) search depth first by f, t set seq select * from search_graph order by seq;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case1" value="fetch 1 from hsc;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case2" value="fetch 1 in c1;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case3" value="fetch 1 in c2;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case4" value="fetch 1 in c3;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case5" value="fetch 1 in c4;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case6" value="fetch 1 in c5;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case7" value="fetch absolute 1 from rf_cur;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case8" value="fetch all from c1;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case9" value="fetch all from c2;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case10" value="fetch all from c;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case11" value="fetch all from c;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case12" value="fetch all from rf_cur;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case13" value="fetch all from rf_cur;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case14" value="fetch all from test2;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case15" value="fetch all in c1;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case16" value="fetch all in c1;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case17" value="fetch all in c1;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case18" value="fetch all in c2;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case19" value="fetch all in c2;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case20" value="fetch all in c2;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case21" value="fetch all in c3;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case22" value="fetch all in c3;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case23" value="fetch all in c4;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case24" value="fetch all in c4;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case25" value="fetch all in c5;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case26" value="fetch all in c5;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case27" value="fetch all in c5;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case28" value="fetch backward 1 in c1;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case29" value="fetch backward 1 in c1;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case30" value="fetch backward 1 in c2;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case31" value="fetch backward 1 in c2;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case32" value="fetch backward 1 in c3;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case33" value="fetch backward 1 in c3;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case34" value="fetch backward 1 in c4;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case35" value="fetch backward 1 in c4;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case36" value="fetch backward 1 in c5;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case37" value="fetch backward 1 in c5;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case38" value="fetch backward all from cur;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case39" value="fetch backward all from rf_cur;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case40" value="fetch backward all in c1;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case41" value="fetch backward all in c1;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case42" value="fetch backward all in c1;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case43" value="fetch backward all in c2;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case44" value="fetch backward all in c2;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case45" value="fetch backward all in c3;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case46" value="fetch backward all in c4;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case47" value="fetch backward all in c5;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case48" value="fetch backward all in c5;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case49" value="fetch first from hsc;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case50" value="fetch last from hsc;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case51" value="fetch next from rf_cur;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case52" value="fetch next from rf_cur;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case53" value="fetch next from rf_cur;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case54" value="fetch next from rf_cur;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case55" value="fetch next from rf_cur;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case56" value="fetch next from test1;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case57" value="fetch next in test1;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case58" value="fetch prior from rf_cur;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case59" value="fetch prior from rf_cur;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case60" value="fetch prior from rf_cur;" db-types="PostgreSQL" />
- <sql-case id="low_fetch_by_postgresql_source_test_case61" value="fetch prior from rf_cur;" db-types="PostgreSQL" />
<sql-case id="low_insert_by_postgresql_source_test_case1" value="insert into arr_pk_tbl values (1, '{3,4,5}') on conflict (pk) do update set f1[1] = excluded.f1[1], f1[3] = excluded.f1[3] returning pk, f1;" db-types="PostgreSQL" />
<sql-case id="low_insert_by_postgresql_source_test_case2" value="insert into arr_pk_tbl(pk, f1[1:2]) values (1, '{6,7,8}') on conflict (pk) do update set f1[1] = excluded.f1[1], f1[2] = excluded.f1[2], f1[3] = excluded.f1[3] returning pk, f1;" db-types="PostgreSQL" />
<sql-case id="low_insert_by_postgresql_source_test_case7" value="insert into capitals values ('Sacramento', 4664.E+5, 30, 'CA') on conflict (name) do update set population = excluded.population;" db-types="PostgreSQL" />
@@ -7245,9 +7017,6 @@
<sql-case id="low_lock_by_postgresql_source_test_case1" value="lock table pxtest3 in access share mode nowait;" db-types="PostgreSQL" />
<sql-case id="low_lock_by_postgresql_source_test_case2" value="lock table pxtest3 in access share mode nowait;" db-types="PostgreSQL" />
<sql-case id="low_lock_by_postgresql_source_test_case3" value="lock twophase_tab in access exclusive mode;" db-types="PostgreSQL" />
- <sql-case id="low_move_by_postgresql_source_test_case1" value="move 3 from cur;" db-types="PostgreSQL" />
- <sql-case id="low_move_by_postgresql_source_test_case2" value="move backward all in c;" db-types="PostgreSQL" />
- <sql-case id="low_move_by_postgresql_source_test_case3" value="move forward all in c1;" db-types="PostgreSQL" />
<sql-case id="low_notify_by_postgresql_source_test_case1" value="notify a;" db-types="PostgreSQL" />
<sql-case id="low_prepare_by_postgresql_source_test_case1" value="prepare q as select 'some"text' as "a&title", E' <foo>\n<bar>' as "junk", ' ' as "empty", n as int from generate_series(1,2) as n;" db-types="PostgreSQL" />
<sql-case id="low_prepare_by_postgresql_source_test_case2" value="prepare q as select 'some\more_text' as "a$title", E' #<foo>%&^~|\n{bar}' as "junk", ' ' as "empty", n as int from generate_series(1,2) as n;" db-types="PostgreSQL" />