You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by tu...@apache.org on 2022/08/18 09:47:26 UTC
[shardingsphere] branch master updated: Optimize postgresql/opengauss geometric operator sql parse logic (#20268)
This is an automated email from the ASF dual-hosted git repository.
tuichenchuxin 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 e1a6a3db903 Optimize postgresql/opengauss geometric operator sql parse logic (#20268)
e1a6a3db903 is described below
commit e1a6a3db903713fc47a6c5da7536f217c8b66547
Author: Zhengqiang Duan <du...@apache.org>
AuthorDate: Thu Aug 18 17:47:18 2022 +0800
Optimize postgresql/opengauss geometric operator sql parse logic (#20268)
* Optimize postgresql/opengauss geometric operator sql parse logic
* remove support sql parse in unsupported.xml
---
.../impl/BinaryOperationExpressionConverter.java | 15 +-
.../expression/impl/ListExpressionConverter.java | 19 +-
.../datasource/PrepareTargetTablesParameter.java | 2 +-
.../src/main/antlr4/imports/opengauss/BaseRule.g4 | 59 +++-
.../src/main/antlr4/imports/opengauss/Symbol.g4 | 26 +-
.../impl/OpenGaussStatementSQLVisitor.java | 14 +-
.../src/main/antlr4/imports/postgresql/BaseRule.g4 | 56 +++-
.../src/main/antlr4/imports/postgresql/Symbol.g4 | 13 +
.../impl/PostgreSQLStatementSQLVisitor.java | 14 +-
.../SQLNodeConvertEngineParameterizedTest.java | 1 +
.../sql/supported/dml/select-geometric.xml | 60 ++--
.../main/resources/sql/supported/dml/select.xml | 2 +-
.../main/resources/sql/unsupported/unsupported.xml | 340 ---------------------
13 files changed, 191 insertions(+), 430 deletions(-)
diff --git a/shardingsphere-infra/shardingsphere-infra-federation/shardingsphere-infra-federation-optimizer/src/main/java/org/apache/shardingsphere/infra/federation/optimizer/converter/segment/expression/impl/BinaryOperationExpressionConverter.java b/shardingsphere-infra/shardingsphere-infra-federation/shardingsphere-infra-federation-optimizer/src/main/java/org/apache/shardingsphere/infra/federation/optimizer/converter/segment/expression/impl/BinaryOperationExpressionConverter.java
index 8d646f9acf4..1f17fc4c3f6 100644
--- a/shardingsphere-infra/shardingsphere-infra-federation/shardingsphere-infra-federation-optimizer/src/main/java/org/apache/shardingsphere/infra/federation/optimizer/converter/segment/expression/impl/BinaryOperationExpressionConverter.java
+++ b/shardingsphere-infra/shardingsphere-infra-federation/shardingsphere-infra-federation-optimizer/src/main/java/org/apache/shardingsphere/infra/federation/optimizer/converter/segment/expression/impl/BinaryOperationExpressionConverter.java
@@ -20,6 +20,7 @@ package org.apache.shardingsphere.infra.federation.optimizer.converter.segment.e
import com.google.common.base.Preconditions;
import org.apache.calcite.sql.SqlBasicCall;
import org.apache.calcite.sql.SqlNode;
+import org.apache.calcite.sql.SqlNodeList;
import org.apache.calcite.sql.SqlOperator;
import org.apache.calcite.sql.fun.SqlStdOperatorTable;
import org.apache.calcite.sql.parser.SqlParserPos;
@@ -27,7 +28,9 @@ import org.apache.shardingsphere.infra.federation.optimizer.converter.segment.SQ
import org.apache.shardingsphere.infra.federation.optimizer.converter.segment.expression.ExpressionConverter;
import org.apache.shardingsphere.sql.parser.sql.common.segment.dml.expr.BinaryOperationExpression;
-import java.util.Arrays;
+import java.util.Collections;
+import java.util.LinkedList;
+import java.util.List;
import java.util.Map;
import java.util.Optional;
import java.util.TreeMap;
@@ -71,9 +74,17 @@ public final class BinaryOperationExpressionConverter implements SQLSegmentConve
@Override
public Optional<SqlBasicCall> convert(final BinaryOperationExpression segment) {
SqlOperator operator = convertOperator(segment.getOperator());
+ List<SqlNode> sqlNodes = convertSqlNodes(segment);
+ return Optional.of(new SqlBasicCall(operator, sqlNodes, SqlParserPos.ZERO));
+ }
+
+ private List<SqlNode> convertSqlNodes(final BinaryOperationExpression segment) {
SqlNode left = new ExpressionConverter().convert(segment.getLeft()).orElseThrow(IllegalStateException::new);
SqlNode right = new ExpressionConverter().convert(segment.getRight()).orElseThrow(IllegalStateException::new);
- return Optional.of(new SqlBasicCall(operator, Arrays.asList(left, right), SqlParserPos.ZERO));
+ List<SqlNode> result = new LinkedList<>();
+ result.add(left);
+ result.addAll(right instanceof SqlNodeList ? ((SqlNodeList) right).getList() : Collections.singletonList(right));
+ return result;
}
private SqlOperator convertOperator(final String operator) {
diff --git a/shardingsphere-infra/shardingsphere-infra-federation/shardingsphere-infra-federation-optimizer/src/main/java/org/apache/shardingsphere/infra/federation/optimizer/converter/segment/expression/impl/ListExpressionConverter.java b/shardingsphere-infra/shardingsphere-infra-federation/shardingsphere-infra-federation-optimizer/src/main/java/org/apache/shardingsphere/infra/federation/optimizer/converter/segment/expression/impl/ListExpressionConverter.java
index c597d6fd271..276483f9f48 100644
--- a/shardingsphere-infra/shardingsphere-infra-federation/shardingsphere-infra-federation-optimizer/src/main/java/org/apache/shardingsphere/infra/federation/optimizer/converter/segment/expression/impl/ListExpressionConverter.java
+++ b/shardingsphere-infra/shardingsphere-infra-federation/shardingsphere-infra-federation-optimizer/src/main/java/org/apache/shardingsphere/infra/federation/optimizer/converter/segment/expression/impl/ListExpressionConverter.java
@@ -17,16 +17,16 @@
package org.apache.shardingsphere.infra.federation.optimizer.converter.segment.expression.impl;
-import org.apache.calcite.sql.SqlBasicCall;
import org.apache.calcite.sql.SqlNode;
-import org.apache.calcite.sql.fun.SqlStdOperatorTable;
+import org.apache.calcite.sql.SqlNodeList;
import org.apache.calcite.sql.parser.SqlParserPos;
import org.apache.shardingsphere.infra.federation.optimizer.converter.segment.SQLSegmentConverter;
import org.apache.shardingsphere.infra.federation.optimizer.converter.segment.expression.ExpressionConverter;
import org.apache.shardingsphere.sql.parser.sql.common.segment.dml.expr.ExpressionSegment;
import org.apache.shardingsphere.sql.parser.sql.common.segment.dml.expr.ListExpression;
-import java.util.Arrays;
+import java.util.Collection;
+import java.util.LinkedList;
import java.util.Optional;
/**
@@ -36,18 +36,11 @@ public final class ListExpressionConverter implements SQLSegmentConverter<ListEx
@Override
public Optional<SqlNode> convert(final ListExpression segment) {
- SqlNode left = null;
+ Collection<SqlNode> sqlNodes = new LinkedList<>();
for (ExpressionSegment each : segment.getItems()) {
Optional<SqlNode> sqlNode = new ExpressionConverter().convert(each);
- if (!sqlNode.isPresent()) {
- continue;
- }
- if (null == left) {
- left = sqlNode.get();
- continue;
- }
- left = new SqlBasicCall(SqlStdOperatorTable.OR, Arrays.asList(left, sqlNode.get()), SqlParserPos.ZERO);
+ sqlNode.ifPresent(sqlNodes::add);
}
- return Optional.ofNullable(left);
+ return sqlNodes.isEmpty() ? Optional.empty() : Optional.of(new SqlNodeList(sqlNodes, SqlParserPos.ZERO));
}
}
diff --git a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-core/src/main/java/org/apache/shardingsphere/data/pipeline/core/prepare/datasource/PrepareTargetTablesParameter.java b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-core/src/main/java/org/apache/shardingsphere/data/pipeline/core/prepare/datasource/PrepareTargetTablesParameter.java
index ffda71fcb52..76e70af4979 100644
--- a/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-core/src/main/java/org/apache/shardingsphere/data/pipeline/core/prepare/datasource/PrepareTargetTablesParameter.java
+++ b/shardingsphere-kernel/shardingsphere-data-pipeline/shardingsphere-data-pipeline-core/src/main/java/org/apache/shardingsphere/data/pipeline/core/prepare/datasource/PrepareTargetTablesParameter.java
@@ -49,7 +49,7 @@ public final class PrepareTargetTablesParameter {
private final TableNameSchemaNameMapping tableNameSchemaNameMapping;
private final ShardingSphereSQLParserEngine sqlParserEngine;
-
+
public PrepareTargetTablesParameter(@NonNull final String databaseName, @NonNull final PipelineDataSourceConfiguration targetDataSourceConfig,
@NonNull final Map<String, DataSource> sourceDataSourceMap, @NonNull final PipelineDataSourceManager dataSourceManager,
@NonNull final JobDataNodeLine tablesFirstDataNodes, final Map<String, String> tableNameMap, final TableNameSchemaNameMapping tableNameSchemaNameMapping,
diff --git a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-opengauss/src/main/antlr4/imports/opengauss/BaseRule.g4 b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-opengauss/src/main/antlr4/imports/opengauss/BaseRule.g4
index d8345984ac0..40964442fee 100644
--- a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-opengauss/src/main/antlr4/imports/opengauss/BaseRule.g4
+++ b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-opengauss/src/main/antlr4/imports/opengauss/BaseRule.g4
@@ -573,8 +573,8 @@ aExpr
| aExpr qualOp
| aExpr comparisonOperator aExpr
| NOT aExpr
- | aExpr patternMatchingOperator aExpr
| aExpr patternMatchingOperator aExpr ESCAPE aExpr
+ | aExpr patternMatchingOperator aExpr
| aExpr IS NULL
| aExpr ISNULL
| aExpr IS NOT NULL
@@ -752,11 +752,38 @@ op
| SQ_
| BQ_
| QUESTION_
+ | DOLLAR_
| AT_
| SEMI_
| TILDE_TILDE_
| NOT_TILDE_TILDE_
- | TYPE_CAST_ )+
+ | TYPE_CAST_
+ | ILIKE_
+ | NOT_ILIKE_
+ | UNICODE_ESCAPE
+ | JSON_EXTRACT_
+ | JSON_EXTRACT_TEXT_
+ | JSON_PATH_EXTRACT_
+ | JSON_PATH_EXTRACT_TEXT_
+ | JSONB_CONTAIN_RIGHT_
+ | JSONB_CONTAIN_LEFT_
+ | JSONB_CONTAIN_ALL_TOP_KEY_
+ | JSONB_PATH_DELETE_
+ | JSONB_PATH_CONTAIN_ANY_VALUE_
+ | JSONB_PATH_PREDICATE_CHECK_
+ | GEOMETRIC_LENGTH_
+ | GEOMETRIC_DISTANCE_
+ | GEOMETRIC_EXTEND_RIGHT_
+ | GEOMETRIC_EXTEND_LEFT_
+ | GEOMETRIC_STRICT_BELOW_
+ | GEOMETRIC_STRICT_ABOVE_
+ | GEOMETRIC_EXTEND_ABOVE_
+ | GEOMETRIC_EXTEND_BELOW_
+ | GEOMETRIC_BELOW_
+ | GEOMETRIC_ABOVE_
+ | GEOMETRIC_INTERSECT_
+ | GEOMETRIC_PERPENDICULAR_
+ | GEOMETRIC_SAME_AS_ )+
;
mathOperator
@@ -792,19 +819,21 @@ jsonOperator
;
geometricOperator
- : GEOMETRIC_LENGTH
- | GEOMETRIC_DISTANCE
- | GEOMETRIC_EXTEND_RIGHT
- | GEOMETRIC_EXTEND_LEFT
- | GEOMETRIC_STRICT_BELOW
- | GEOMETRIC_STRICT_ABOVE
- | GEOMETRIC_EXTEND_ABOVE
- | GEOMETRIC_EXTEND_BELOW
- | GEOMETRIC_BELOW
- | GEOMETRIC_ABOVE
- | GEOMETRIC_INTERSECT
- | GEOMETRIC_PERPENDICULAR
- | GEOMETRIC_SAME_AS
+ : GEOMETRIC_LENGTH_
+ | GEOMETRIC_DISTANCE_
+ | GEOMETRIC_EXTEND_RIGHT_
+ | GEOMETRIC_EXTEND_LEFT_
+ | GEOMETRIC_STRICT_BELOW_
+ | GEOMETRIC_STRICT_ABOVE_
+ | GEOMETRIC_EXTEND_ABOVE_
+ | GEOMETRIC_EXTEND_BELOW_
+ | GEOMETRIC_BELOW_
+ | GEOMETRIC_ABOVE_
+ | GEOMETRIC_INTERSECT_
+ | GEOMETRIC_PERPENDICULAR_
+ | GEOMETRIC_SAME_AS_
+ | QUESTION_ MINUS_
+ | QUESTION_ OR_
| POUND_
| SIGNED_LEFT_SHIFT_
| SIGNED_RIGHT_SHIFT_
diff --git a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-opengauss/src/main/antlr4/imports/opengauss/Symbol.g4 b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-opengauss/src/main/antlr4/imports/opengauss/Symbol.g4
index 92d79c513b6..a509bbbaef3 100644
--- a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-opengauss/src/main/antlr4/imports/opengauss/Symbol.g4
+++ b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-opengauss/src/main/antlr4/imports/opengauss/Symbol.g4
@@ -75,16 +75,16 @@ JSONB_CONTAIN_ALL_TOP_KEY_: '?&';
JSONB_PATH_DELETE_: '#-';
JSONB_PATH_CONTAIN_ANY_VALUE_: '@?';
JSONB_PATH_PREDICATE_CHECK_: '@@';
-GEOMETRIC_LENGTH: '@-@';
-GEOMETRIC_DISTANCE: '<->';
-GEOMETRIC_EXTEND_RIGHT: '&<';
-GEOMETRIC_EXTEND_LEFT: '&>';
-GEOMETRIC_STRICT_BELOW: '<<|';
-GEOMETRIC_STRICT_ABOVE: '|>>';
-GEOMETRIC_EXTEND_ABOVE: '&<|';
-GEOMETRIC_EXTEND_BELOW: '|&>';
-GEOMETRIC_BELOW: '<^';
-GEOMETRIC_ABOVE: '>^';
-GEOMETRIC_INTERSECT: '?#';
-GEOMETRIC_PERPENDICULAR: '?-|';
-GEOMETRIC_SAME_AS: '~=';
+GEOMETRIC_LENGTH_: '@-@';
+GEOMETRIC_DISTANCE_: '<->';
+GEOMETRIC_EXTEND_RIGHT_: '&<';
+GEOMETRIC_EXTEND_LEFT_: '&>';
+GEOMETRIC_STRICT_BELOW_: '<<|';
+GEOMETRIC_STRICT_ABOVE_: '|>>';
+GEOMETRIC_EXTEND_ABOVE_: '&<|';
+GEOMETRIC_EXTEND_BELOW_: '|&>';
+GEOMETRIC_BELOW_: '<^';
+GEOMETRIC_ABOVE_: '>^';
+GEOMETRIC_INTERSECT_: '?#';
+GEOMETRIC_PERPENDICULAR_: '?-|';
+GEOMETRIC_SAME_AS_: '~=';
diff --git a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-opengauss/src/main/java/org/apache/shardingsphere/sql/parser/opengauss/visitor/statement/impl/OpenGaussStatementSQLVisitor.java b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-opengauss/src/main/java/org/apache/shardingsphere/sql/parser/opengauss/visitor/statement/impl/OpenGaussStatementSQLVisitor.java
index 5a3e2665503..b3b621d743d 100644
--- a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-opengauss/src/main/java/org/apache/shardingsphere/sql/parser/opengauss/visitor/statement/impl/OpenGaussStatementSQLVisitor.java
+++ b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-opengauss/src/main/java/org/apache/shardingsphere/sql/parser/opengauss/visitor/statement/impl/OpenGaussStatementSQLVisitor.java
@@ -357,16 +357,16 @@ public abstract class OpenGaussStatementSQLVisitor extends OpenGaussStatementBas
}
if (null != ctx.parameterMarker()) {
ParameterMarkerValue parameterMarker = (ParameterMarkerValue) visit(ctx.parameterMarker());
- ParameterMarkerExpressionSegment segment = new ParameterMarkerExpressionSegment(ctx.start.getStartIndex(), ctx.stop.getStopIndex(), parameterMarker.getValue(), parameterMarker.getType());
- parameterMarkerSegments.add(segment);
- return segment;
+ ParameterMarkerExpressionSegment result = new ParameterMarkerExpressionSegment(ctx.start.getStartIndex(), ctx.stop.getStopIndex(), parameterMarker.getValue(), parameterMarker.getType());
+ parameterMarkerSegments.add(result);
+ return result;
}
if (null != ctx.aexprConst()) {
- ASTNode astNode = visit(ctx.aexprConst());
- if (astNode instanceof StringLiteralValue || astNode instanceof BooleanLiteralValue || astNode instanceof NumberLiteralValue) {
- return new LiteralExpressionSegment(ctx.aexprConst().start.getStartIndex(), ctx.aexprConst().stop.getStopIndex(), ((LiteralValue) astNode).getValue());
+ ASTNode result = visit(ctx.aexprConst());
+ if (result instanceof StringLiteralValue || result instanceof BooleanLiteralValue || result instanceof NumberLiteralValue) {
+ return new LiteralExpressionSegment(ctx.aexprConst().start.getStartIndex(), ctx.aexprConst().stop.getStopIndex(), ((LiteralValue) result).getValue());
}
- return astNode;
+ return result;
}
if (null != ctx.aExpr()) {
return visit(ctx.aExpr());
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 e425b891592..18f30e3f9b3 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
@@ -143,6 +143,7 @@ unreservedWord
| BEFORE
| BEGIN
| BY
+ | BOX
| CACHE
| CALL
| CALLED
@@ -174,6 +175,7 @@ unreservedWord
| CURRENT
| CURSOR
| CYCLE
+ | CIRCLE
| DATA
| DATABASE
| DAY
@@ -261,6 +263,7 @@ unreservedWord
| LOCK
| LOCKED
| LOGGED
+ | LSEG
| MAIN
| MAPPING
| MATCH
@@ -312,6 +315,8 @@ unreservedWord
| PLAIN
| PLANS
| POLICY
+ | POINT
+ | POLYGON
| PRECEDING
| PREPARE
| PREPARED
@@ -685,6 +690,7 @@ columnref
qualOp
: jsonOperator
+ | geometricOperator
| OPERATOR LP_ anyOperator RP_
;
@@ -741,11 +747,38 @@ op
| SQ_
| BQ_
| QUESTION_
+ | DOLLAR_
| AT_
| SEMI_
| TILDE_TILDE_
| NOT_TILDE_TILDE_
- | TYPE_CAST_ )+
+ | TYPE_CAST_
+ | ILIKE_
+ | NOT_ILIKE_
+ | UNICODE_ESCAPE
+ | JSON_EXTRACT_
+ | JSON_EXTRACT_TEXT_
+ | JSON_PATH_EXTRACT_
+ | JSON_PATH_EXTRACT_TEXT_
+ | JSONB_CONTAIN_RIGHT_
+ | JSONB_CONTAIN_LEFT_
+ | JSONB_CONTAIN_ALL_TOP_KEY_
+ | JSONB_PATH_DELETE_
+ | JSONB_PATH_CONTAIN_ANY_VALUE_
+ | JSONB_PATH_PREDICATE_CHECK_
+ | GEOMETRIC_LENGTH_
+ | GEOMETRIC_DISTANCE_
+ | GEOMETRIC_EXTEND_RIGHT_
+ | GEOMETRIC_EXTEND_LEFT_
+ | GEOMETRIC_STRICT_BELOW_
+ | GEOMETRIC_STRICT_ABOVE_
+ | GEOMETRIC_EXTEND_ABOVE_
+ | GEOMETRIC_EXTEND_BELOW_
+ | GEOMETRIC_BELOW_
+ | GEOMETRIC_ABOVE_
+ | GEOMETRIC_INTERSECT_
+ | GEOMETRIC_PERPENDICULAR_
+ | GEOMETRIC_SAME_AS_ )+
;
mathOperator
@@ -779,6 +812,27 @@ jsonOperator
| JSONB_PATH_CONTAIN_ANY_VALUE_ # jsonbPathContainAnyValue
| JSONB_PATH_PREDICATE_CHECK_ # jsonbPathPredicateCheck
;
+
+geometricOperator
+ : GEOMETRIC_LENGTH_
+ | GEOMETRIC_DISTANCE_
+ | GEOMETRIC_EXTEND_RIGHT_
+ | GEOMETRIC_EXTEND_LEFT_
+ | GEOMETRIC_STRICT_BELOW_
+ | GEOMETRIC_STRICT_ABOVE_
+ | GEOMETRIC_EXTEND_ABOVE_
+ | GEOMETRIC_EXTEND_BELOW_
+ | GEOMETRIC_BELOW_
+ | GEOMETRIC_ABOVE_
+ | GEOMETRIC_INTERSECT_
+ | GEOMETRIC_PERPENDICULAR_
+ | GEOMETRIC_SAME_AS_
+ | QUESTION_ MINUS_
+ | QUESTION_ OR_
+ | POUND_
+ | SIGNED_LEFT_SHIFT_
+ | SIGNED_RIGHT_SHIFT_
+ ;
qualAllOp
: allOp
diff --git a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/imports/postgresql/Symbol.g4 b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/imports/postgresql/Symbol.g4
index 532b252b8c3..a509bbbaef3 100644
--- a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/imports/postgresql/Symbol.g4
+++ b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/imports/postgresql/Symbol.g4
@@ -75,3 +75,16 @@ JSONB_CONTAIN_ALL_TOP_KEY_: '?&';
JSONB_PATH_DELETE_: '#-';
JSONB_PATH_CONTAIN_ANY_VALUE_: '@?';
JSONB_PATH_PREDICATE_CHECK_: '@@';
+GEOMETRIC_LENGTH_: '@-@';
+GEOMETRIC_DISTANCE_: '<->';
+GEOMETRIC_EXTEND_RIGHT_: '&<';
+GEOMETRIC_EXTEND_LEFT_: '&>';
+GEOMETRIC_STRICT_BELOW_: '<<|';
+GEOMETRIC_STRICT_ABOVE_: '|>>';
+GEOMETRIC_EXTEND_ABOVE_: '&<|';
+GEOMETRIC_EXTEND_BELOW_: '|&>';
+GEOMETRIC_BELOW_: '<^';
+GEOMETRIC_ABOVE_: '>^';
+GEOMETRIC_INTERSECT_: '?#';
+GEOMETRIC_PERPENDICULAR_: '?-|';
+GEOMETRIC_SAME_AS_: '~=';
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/PostgreSQLStatementSQLVisitor.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/PostgreSQLStatementSQLVisitor.java
index 623f1b9cc6e..45adf0448d1 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/PostgreSQLStatementSQLVisitor.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/PostgreSQLStatementSQLVisitor.java
@@ -355,16 +355,16 @@ public abstract class PostgreSQLStatementSQLVisitor extends PostgreSQLStatementP
}
if (null != ctx.parameterMarker()) {
ParameterMarkerValue parameterMarker = (ParameterMarkerValue) visit(ctx.parameterMarker());
- ParameterMarkerExpressionSegment segment = new ParameterMarkerExpressionSegment(ctx.start.getStartIndex(), ctx.stop.getStopIndex(), parameterMarker.getValue(), parameterMarker.getType());
- parameterMarkerSegments.add(segment);
- return segment;
+ ParameterMarkerExpressionSegment result = new ParameterMarkerExpressionSegment(ctx.start.getStartIndex(), ctx.stop.getStopIndex(), parameterMarker.getValue(), parameterMarker.getType());
+ parameterMarkerSegments.add(result);
+ return result;
}
if (null != ctx.aexprConst()) {
- ASTNode astNode = visit(ctx.aexprConst());
- if (astNode instanceof StringLiteralValue || astNode instanceof BooleanLiteralValue || astNode instanceof NumberLiteralValue) {
- return new LiteralExpressionSegment(ctx.aexprConst().start.getStartIndex(), ctx.aexprConst().stop.getStopIndex(), ((LiteralValue) astNode).getValue());
+ ASTNode result = visit(ctx.aexprConst());
+ if (result instanceof StringLiteralValue || result instanceof BooleanLiteralValue || result instanceof NumberLiteralValue) {
+ return new LiteralExpressionSegment(ctx.aexprConst().start.getStartIndex(), ctx.aexprConst().stop.getStopIndex(), ((LiteralValue) result).getValue());
}
- return astNode;
+ return result;
}
if (null != ctx.aExpr()) {
return visit(ctx.aExpr());
diff --git a/shardingsphere-test/shardingsphere-optimize-test/src/test/java/org/apache/shardingsphere/infra/federation/converter/parameterized/engine/SQLNodeConvertEngineParameterizedTest.java b/shardingsphere-test/shardingsphere-optimize-test/src/test/java/org/apache/shardingsphere/infra/federation/converter/parameterized/engine/SQLNodeConvertEngineParameterizedTest.java
index fd26d31174a..278f253c075 100644
--- a/shardingsphere-test/shardingsphere-optimize-test/src/test/java/org/apache/shardingsphere/infra/federation/converter/parameterized/engine/SQLNodeConvertEngineParameterizedTest.java
+++ b/shardingsphere-test/shardingsphere-optimize-test/src/test/java/org/apache/shardingsphere/infra/federation/converter/parameterized/engine/SQLNodeConvertEngineParameterizedTest.java
@@ -104,6 +104,7 @@ public final class SQLNodeConvertEngineParameterizedTest {
SUPPORTED_SQL_CASE_IDS.add("select_current_user");
SUPPORTED_SQL_CASE_IDS.add("select_database");
SUPPORTED_SQL_CASE_IDS.add("select_distinct_with_count_calculation");
+ SUPPORTED_SQL_CASE_IDS.add("select_count_like_escape");
}
private final String sqlCaseId;
diff --git a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/dml/select-geometric.xml b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/dml/select-geometric.xml
index 087e3b01554..568624e1210 100644
--- a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/dml/select-geometric.xml
+++ b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/dml/select-geometric.xml
@@ -17,34 +17,34 @@
-->
<sql-cases>
- <sql-case id="select_with_geometric_translation_plus" value="SELECT box '((0,0),(1,1))' + point '(2.0,0)' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_translation_minus" value="SELECT box '((0,0),(1,1))' - point '(2.0,0)' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_rotation_multiply" value="SELECT box '((0,0),(1,1))' * point '(2.0,0)' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_rotation_divide" value="SELECT box '((0,0),(2,2))' / point '(2.0,0)' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_intersection" value="SELECT box '((1,-1),(-1,1))' # box '((1,1),(-2,-2))' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_number_of_path" value="SELECT # path'((1,0),(0,1),(-1,0))' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_length" value="SELECT @-@ path '((0,0),(1,0))' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_center_of_box" value="SELECT @@ circle '((0,0),10)' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_distance" value="SELECT circle '((0,0),1)' <-> circle '((5,0),1)' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_overlaps" value="SELECT box '((0,0),(1,1))' && box '((0,0),(2,2))' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_strict_left" value="SELECT circle '((0,0),1)' << circle '((5,0),1)' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_strict_right" value="SELECT circle '((5,0),1)' >> circle '((0,0),1)' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_extend_to_right" value="SELECT box '((0,0),(1,1))' &< box '((0,0),(2,2))' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_extend_to_left" value="SELECT box '((0,0),(3,3))' &> box '((0,0),(2,2))' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_strict_below" value="SELECT box '((0,0),(3,3))' <<| box '((3,4),(5,5))' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_strict_above" value="SELECT box '((3,4),(5,5))' |>> box '((0,0),(3,3))' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_extend_above" value="SELECT box '((0,0),(1,1))' &<| box '((0,0),(2,2))' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_extend_below" value="SELECT box '((0,0),(3,3))' |&> box '((0,0),(2,2))' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_below" value="SELECT box '((0,0),(-3,-3))' <^ box '((0,0),(2,2))' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_above" value="SELECT box '((0,0),(2,2))' >^ box '((0,0),(-3,-3))' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_intersect" value="SELECT lseg '((-1,0),(1,0))' ?# box '((-2,-2),(2,2))' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_horizontal" value="SELECT ?- lseg '((-1,0),(1,0))' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_horizontal_aligned" value="SELECT point '(1,0)' ?- point '(0,0)' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_vertical" value="SELECT ?| lseg '((-1,0),(1,0))' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_vertical_aligned" value="SELECT point '(0,1)' ?| point '(0,0)' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_perpendicular" value="SELECT lseg '((0,0),(0,1))' ?-| lseg '((0,0),(1,0))' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_parallel" value="SELECT lseg '((-1,0),(1,0))' ?|| lseg '((-1,2),(1,2))' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_contains" value="SELECT circle '((0,0),2)' @> point '(1,1)' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_contains_in" value="SELECT point '(1,1)' <@ circle '((0,0),2)' AS RESULT;" db-types="openGauss" />
- <sql-case id="select_with_geometric_same_as" value="SELECT polygon '((0,0),(1,1))' ~= polygon '((1,1),(0,0))' AS RESULT;" db-types="openGauss" />
+ <sql-case id="select_with_geometric_translation_plus" value="SELECT box '((0,0),(1,1))' + point '(2.0,0)' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_translation_minus" value="SELECT box '((0,0),(1,1))' - point '(2.0,0)' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_rotation_multiply" value="SELECT box '((0,0),(1,1))' * point '(2.0,0)' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_rotation_divide" value="SELECT box '((0,0),(2,2))' / point '(2.0,0)' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_intersection" value="SELECT box '((1,-1),(-1,1))' # box '((1,1),(-2,-2))' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_number_of_path" value="SELECT # path'((1,0),(0,1),(-1,0))' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_length" value="SELECT @-@ path '((0,0),(1,0))' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_center_of_box" value="SELECT @@ circle '((0,0),10)' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_distance" value="SELECT circle '((0,0),1)' <-> circle '((5,0),1)' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_overlaps" value="SELECT box '((0,0),(1,1))' && box '((0,0),(2,2))' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_strict_left" value="SELECT circle '((0,0),1)' << circle '((5,0),1)' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_strict_right" value="SELECT circle '((5,0),1)' >> circle '((0,0),1)' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_extend_to_right" value="SELECT box '((0,0),(1,1))' &< box '((0,0),(2,2))' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_extend_to_left" value="SELECT box '((0,0),(3,3))' &> box '((0,0),(2,2))' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_strict_below" value="SELECT box '((0,0),(3,3))' <<| box '((3,4),(5,5))' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_strict_above" value="SELECT box '((3,4),(5,5))' |>> box '((0,0),(3,3))' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_extend_above" value="SELECT box '((0,0),(1,1))' &<| box '((0,0),(2,2))' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_extend_below" value="SELECT box '((0,0),(3,3))' |&> box '((0,0),(2,2))' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_below" value="SELECT box '((0,0),(-3,-3))' <^ box '((0,0),(2,2))' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_above" value="SELECT box '((0,0),(2,2))' >^ box '((0,0),(-3,-3))' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_intersect" value="SELECT lseg '((-1,0),(1,0))' ?# box '((-2,-2),(2,2))' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_horizontal" value="SELECT ?- lseg '((-1,0),(1,0))' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_horizontal_aligned" value="SELECT point '(1,0)' ?- point '(0,0)' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_vertical" value="SELECT ?| lseg '((-1,0),(1,0))' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_vertical_aligned" value="SELECT point '(0,1)' ?| point '(0,0)' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_perpendicular" value="SELECT lseg '((0,0),(0,1))' ?-| lseg '((0,0),(1,0))' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_parallel" value="SELECT lseg '((-1,0),(1,0))' ?|| lseg '((-1,2),(1,2))' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_contains" value="SELECT circle '((0,0),2)' @> point '(1,1)' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_contains_in" value="SELECT point '(1,1)' <@ circle '((0,0),2)' AS RESULT;" db-types="PostgreSQL,openGauss" />
+ <sql-case id="select_with_geometric_same_as" value="SELECT polygon '((0,0),(1,1))' ~= polygon '((1,1),(0,0))' AS RESULT;" db-types="PostgreSQL,openGauss" />
</sql-cases>
diff --git a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/dml/select.xml b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/dml/select.xml
index 22b19d93b5a..2d7660c2824 100644
--- a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/dml/select.xml
+++ b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/dml/select.xml
@@ -38,7 +38,7 @@
<sql-case id="select_in_with_same_sharding_column" value="SELECT * FROM t_order WHERE order_id IN (?, ?) AND order_id IN (?, ?) ORDER BY order_id" />
<sql-case id="select_with_N_string_in_expression" value="SELECT * FROM t_order WHERE is_deleted = 'N'" />
<sql-case id="select_count_like" value="SELECT COUNT(*) FROM t_order WHERE (user_id = ? AND status LIKE ?)" />
- <sql-case id="select_count_like_escape" value="SELECT COUNT(*) FROM t_order WHERE status LIKE ? escape '!' limit ? offset ?" db-types="PostgreSQL"/>
+ <sql-case id="select_count_like_escape" value="SELECT COUNT(*) FROM t_order WHERE status LIKE ? escape '!' limit ? offset ?" db-types="PostgreSQL,openGauss"/>
<sql-case id="select_count_like_concat" value="SELECT count(0) AS orders_count FROM t_order o WHERE o.status LIKE CONCAT('%%', ?, '%%') AND o.user_id IN (?, ?) AND o.order_id BETWEEN ? AND ?" db-types="MySQL,SQLServer,Oracle,SQL92" />
<!--TODO combine into select_count_like_concat-->
<sql-case id="select_count_like_concat_postgres" value="SELECT count(0) AS orders_count FROM t_order o WHERE o.status LIKE CONCAT('%%', ?, '%%') AND o.user_id IN (?, ?) AND o.order_id BETWEEN ? AND ?" db-types="PostgreSQL,openGauss" />
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 654ebbc7152..46245920954 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
@@ -3963,13 +3963,9 @@
<sql-case id="create_by_postgresql_source_test_case866" value="CREATE TYPE city_budget ( internallength = 16, input = int44in, output = int44out, element = int4, category = 'x' preferred = tr );" db-types="PostgreSQL" />
<sql-case id="create_by_postgresql_source_test_case867" value="CREATE TYPE hash_test_t2 AS (a money, b text);" db-types="PostgreSQL" />
<sql-case id="create_by_postgresql_source_test_case869" value="CREATE TYPE tt_t0 AS (z inet, x int, y numeric(8,2));" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case870" value="CREATE VIEW atest12sbv WITH (security_barrier=true) AS SELECT * FROM atest12 WHERE b <<< 5;" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case871" value="CREATE VIEW atest12v AS SELECT * FROM atest12 WHERE b <<< 5;" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case872" value="CREATE VIEW iexit AS SELECT ih.name, ih.thepath, interpt_pp(ih.thepath, r.thepath) AS exit FROM ihighway ih, ramp r WHERE ih.thepath ## r.thepath;" db-types="PostgreSQL" />
<sql-case id="create_by_postgresql_source_test_case873" value="CREATE VIEW mysecview5 WITH (security_barrier=100) -- Error AS SELECT * FROM tbl1 WHERE a > 100;" db-types="PostgreSQL" />
<sql-case id="create_by_postgresql_source_test_case874" value="CREATE VIEW mysecview6 WITH (invalid_option) -- Error AS SELECT * FROM tbl1 WHERE a < 100;" db-types="PostgreSQL" />
<sql-case id="create_by_postgresql_source_test_case875" value="CREATE VIEW rw_view2 AS SELECT * FROM rw_view1 WHERE a < 10 WITH CHECK OPTIO SELECT * FROM information_schema.views WHERE table_name = 'rw_view2';" db-types="PostgreSQL" />
- <sql-case id="create_by_postgresql_source_test_case876" value="CREATE VIEW street AS SELECT r.name, r.thepath, c.cname AS cname FROM ONLY road r, real_city c WHERE c.outline ## r.thepath;" db-types="PostgreSQL" />
<sql-case id="create_by_postgresql_source_test_case877" value="CREATE VIEW tableam_view_heap2 USING heap2 AS SELECT * FROM tableam_tbl_heap2;" db-types="PostgreSQL" />
<sql-case id="create_by_postgresql_source_test_case878" value="CREATE foo;" db-types="PostgreSQL" />
<sql-case id="ddd 42_by_postgresql_source_test_case1" value="DDD 42 drop trigger child1_insert_trig on child1;" db-types="PostgreSQL" />
@@ -4056,76 +4052,13 @@
<sql-case id="explain_by_postgresql_source_test_case27" value="EXPLAIN (COSTS OFF) EXECUTE role_inval;" db-types="PostgreSQL" />
<sql-case id="explain_by_postgresql_source_test_case28" value="EXPLAIN (COSTS OFF) EXECUTE role_inval;" db-types="PostgreSQL" />
<sql-case id="explain_by_postgresql_source_test_case29" value="EXPLAIN (COSTS OFF) INSERT INTO t2 (SELECT * FROM t1);" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case30" value="EXPLAIN (COSTS OFF) SELECT * FROM atest12 WHERE a >>> 0;" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case31" value="EXPLAIN (COSTS OFF) SELECT * FROM atest12 x, atest12 y WHERE x.a = y.b and abs(y.a) <<< 5;" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case32" value="EXPLAIN (COSTS OFF) SELECT * FROM atest12 x, atest12 y WHERE x.a = y.b and abs(y.a) <<< 5;" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case33" value="EXPLAIN (COSTS OFF) SELECT * FROM atest12sbv x, atest12sbv y WHERE x.a = y.b and abs(y.a) <<< 5;" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case34" value="EXPLAIN (COSTS OFF) SELECT * FROM atest12v x, atest12v y WHERE x.a = y.b and abs(y.a) <<< 5;" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case35" value="EXPLAIN (COSTS OFF) SELECT * FROM box_temp WHERE f1 &< '(10,4.333334),(5,100)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case36" value="EXPLAIN (COSTS OFF) SELECT * FROM box_temp WHERE f1 &<| '(10,4.3333334),(5,1)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case37" value="EXPLAIN (COSTS OFF) SELECT * FROM box_temp WHERE f1 &> '(40,30),(45,50)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case38" value="EXPLAIN (COSTS OFF) SELECT * FROM box_temp WHERE f1 << '(10,20),(30,40)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case39" value="EXPLAIN (COSTS OFF) SELECT * FROM box_temp WHERE f1 <<| '(10,4.33334),(5,100)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case40" value="EXPLAIN (COSTS OFF) SELECT * FROM box_temp WHERE f1 >> '(30,40),(40,30)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case41" value="EXPLAIN (COSTS OFF) SELECT * FROM box_temp WHERE f1 |&> '(49.99,49.99),(49.99,49.99)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case42" value="EXPLAIN (COSTS OFF) SELECT * FROM box_temp WHERE f1 |>> '(37,38),(39,40)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case43" value="EXPLAIN (COSTS OFF) SELECT * FROM box_temp WHERE f1 ~= '(20,20),(40,40)';" db-types="PostgreSQL" />
<sql-case id="explain_by_postgresql_source_test_case44" value="EXPLAIN (COSTS OFF) SELECT * FROM circle_tbl WHERE f1 && circle(point(1,-2), 1) ORDER BY area(f1);" db-types="PostgreSQL" />
<sql-case id="explain_by_postgresql_source_test_case45" value="EXPLAIN (COSTS OFF) SELECT * FROM fast_emp4000 WHERE home_base <@ '(200,200),(2000,1000)'::box ORDER BY (home_base[0])[0];" db-types="PostgreSQL" />
<sql-case id="explain_by_postgresql_source_test_case46" value="EXPLAIN (COSTS OFF) SELECT * FROM fast_emp4000 WHERE home_base <@ '(200,200),(2000,1000)'::box ORDER BY (home_base[0])[0];" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case47" value="EXPLAIN (COSTS OFF) SELECT * FROM gpolygon_tbl ORDER BY f1 <-> '(0,0)'::point LIMIT 10;" db-types="PostgreSQL" />
<sql-case id="explain_by_postgresql_source_test_case48" value="EXPLAIN (COSTS OFF) SELECT * FROM inet_tbl WHERE '192.168.1.0/24'::cidr >> i;" db-types="PostgreSQL" />
<sql-case id="explain_by_postgresql_source_test_case49" value="EXPLAIN (COSTS OFF) SELECT * FROM inet_tbl WHERE '192.168.1.0/24'::cidr >>= i;" db-types="PostgreSQL" />
<sql-case id="explain_by_postgresql_source_test_case50" value="EXPLAIN (COSTS OFF) SELECT * FROM inet_tbl WHERE i<<'192.168.1.0/24'::cidr;" db-types="PostgreSQL" />
<sql-case id="explain_by_postgresql_source_test_case51" value="EXPLAIN (COSTS OFF) SELECT * FROM inet_tbl WHERE i<<='192.168.1.0/24'::cidr;" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case52" value="EXPLAIN (COSTS OFF) SELECT * FROM point_tbl WHERE f1 <@ '(-10,-10),(10,10)':: box ORDER BY f1 <-> '0,1';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case53" value="EXPLAIN (COSTS OFF) SELECT * FROM point_tbl WHERE f1 <@ '(-10,-10),(10,10)':: box ORDER BY f1 <-> '0,1';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case54" value="EXPLAIN (COSTS OFF) SELECT * FROM polygon_tbl WHERE f1 @> '((1,1),(2,2),(2,1))'::polygon ORDER BY (poly_center(f1))[0];" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case55" value="EXPLAIN (COSTS OFF) SELECT circle_center(f1), round(radius(f1)) as radius FROM gcircle_tbl ORDER BY f1 <-> '(200,300)'::point LIMIT 10;" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case56" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM fast_emp4000 WHERE home_base && '(1000,1000,0,0)'::box;" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case57" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM fast_emp4000 WHERE home_base && '(1000,1000,0,0)'::box;" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case58" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM gcircle_tbl WHERE f1 && '<(500,500),500>'::circle;" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case59" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM gpolygon_tbl WHERE f1 && '(1000,1000,0,0)'::polygon;" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case60" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM kd_point_tbl WHERE box '(200,200,1000,1000)' @> p;" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case61" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM kd_point_tbl WHERE box '(200,200,1000,1000)' @> p;" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case62" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM kd_point_tbl WHERE p << '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case63" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM kd_point_tbl WHERE p << '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case64" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM kd_point_tbl WHERE p <<| '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case65" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM kd_point_tbl WHERE p <<| '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case66" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM kd_point_tbl WHERE p >> '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case67" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM kd_point_tbl WHERE p >> '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case68" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM kd_point_tbl WHERE p |>> '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case69" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM kd_point_tbl WHERE p |>> '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case70" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM kd_point_tbl WHERE p ~= '(4585, 365)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case71" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM kd_point_tbl WHERE p ~= '(4585, 365)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case72" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM point_tbl WHERE box '(0,0,100,100)' @> f1;" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case73" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM point_tbl p WHERE p.f1 << '(0.0, 0.0)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case74" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM point_tbl p WHERE p.f1 <<| '(0.0, 0.0)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case75" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM point_tbl p WHERE p.f1 >> '(0.0, 0.0)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case76" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM point_tbl p WHERE p.f1 |>> '(0.0, 0.0)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case77" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM point_tbl p WHERE p.f1 ~= '(-5, -12)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case78" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM quad_point_tbl WHERE box '(200,200,1000,1000)' @> p;" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case79" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM quad_point_tbl WHERE box '(200,200,1000,1000)' @> p;" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case80" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM quad_point_tbl WHERE p << '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case81" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM quad_point_tbl WHERE p << '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case82" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM quad_point_tbl WHERE p <<| '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case83" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM quad_point_tbl WHERE p <<| '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case84" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM quad_point_tbl WHERE p >> '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case85" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM quad_point_tbl WHERE p >> '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case86" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM quad_point_tbl WHERE p |>> '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case87" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM quad_point_tbl WHERE p |>> '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case88" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM quad_point_tbl WHERE p ~= '(4585, 365)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case89" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM quad_point_tbl WHERE p ~= '(4585, 365)';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case90" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM quad_poly_tbl WHERE p && polygon '((300,300),(400,600),(600,500),(700,200))';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case91" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM quad_poly_tbl WHERE p &< polygon '((300,300),(400,600),(600,500),(700,200))';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case92" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM quad_poly_tbl WHERE p &<| polygon '((300,300),(400,600),(600,500),(700,200))';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case93" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM quad_poly_tbl WHERE p &> polygon '((300,300),(400,600),(600,500),(700,200))';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case94" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM quad_poly_tbl WHERE p << polygon '((300,300),(400,600),(600,500),(700,200))';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case95" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM quad_poly_tbl WHERE p <<| polygon '((300,300),(400,600),(600,500),(700,200))';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case96" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM quad_poly_tbl WHERE p >> polygon '((300,300),(400,600),(600,500),(700,200))';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case97" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM quad_poly_tbl WHERE p |&> polygon '((300,300),(400,600),(600,500),(700,200))';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case98" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM quad_poly_tbl WHERE p |>> polygon '((300,300),(400,600),(600,500),(700,200))';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case99" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM quad_poly_tbl WHERE p ~= polygon '((200, 300),(210, 310),(230, 290))';" db-types="PostgreSQL" />
<sql-case id="explain_by_postgresql_source_test_case100" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM radix_text_tbl WHERE t ^@ 'Worth';" db-types="PostgreSQL" />
<sql-case id="explain_by_postgresql_source_test_case101" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM radix_text_tbl WHERE t ^@ 'Worth';" db-types="PostgreSQL" />
<sql-case id="explain_by_postgresql_source_test_case102" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM radix_text_tbl WHERE t ~<=~ 'Aztec Ct ';" db-types="PostgreSQL" />
@@ -4138,9 +4071,6 @@
<sql-case id="explain_by_postgresql_source_test_case109" value="EXPLAIN (COSTS OFF) SELECT count(*) FROM radix_text_tbl WHERE t ~>~ 'Worth St ';" db-types="PostgreSQL" />
<sql-case id="explain_by_postgresql_source_test_case110" value="EXPLAIN (COSTS OFF) SELECT i FROM inet_tbl WHERE i << '192.168.1.0/24'::cidr ORDER BY i;" db-types="PostgreSQL" />
<sql-case id="explain_by_postgresql_source_test_case111" value="EXPLAIN (COSTS OFF) SELECT i FROM inet_tbl WHERE i << '192.168.1.0/24'::cidr ORDER BY i;" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case112" value="EXPLAIN (COSTS OFF) SELECT rank() OVER (ORDER BY b <-> point '123,456') n, b <-> point '123,456' dist, id FROM quad_box_tbl WHERE b <@ box '((200,300),(500,600))';" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case113" value="EXPLAIN (COSTS OFF) SELECT rank() OVER (ORDER BY b <-> point '123,456') n, b <-> point '123,456' dist, id FROM quad_box_tbl;" db-types="PostgreSQL" />
- <sql-case id="explain_by_postgresql_source_test_case114" value="EXPLAIN (COSTS OFF) SELECT rank() OVER (ORDER BY p <-> point '123,456') n, p <-> point '123,456' dist, id FROM quad_poly_tbl WHERE p <@ polygon '((300,300),(400,600),(600,500),(700,200))';" db-types="PostgreSQL" />
<sql-case id="explain_by_postgresql_source_test_case115" value="EXPLAIN (COSTS OFF) UPDATE current_check SET payload = payload WHERE CURRENT OF current_check_cursor;" db-types="PostgreSQL" />
<sql-case id="explain_by_postgresql_source_test_case117" value="EXPLAIN (VERBOSE, COSTS OFF) UPDATE update_test t SET (a, b) = (SELECT b, a FROM update_test s WHERE s.a = t.a) WHERE CURRENT_USER = SESSION_USER;" 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" />
@@ -4148,10 +4078,6 @@
<sql-case id="import_by_postgresql_source_test_case3" value="IMPORT FOREIGN SCHEMA s1 FROM SERVER s9 INTO public;" db-types="PostgreSQL" />
<sql-case id="import_by_postgresql_source_test_case4" value="IMPORT FOREIGN SCHEMA s1 LIMIT TO (t1) FROM SERVER s9 INTO public;" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case1" value="INSERT INTO 123 VALUES(123);" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case2" value="INSERT INTO BIT_SHIFT_TABLE SELECT b>>1 FROM BIT_SHIFT_TABLE;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case3" value="INSERT INTO BIT_SHIFT_TABLE SELECT b>>2 FROM BIT_SHIFT_TABLE;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case4" value="INSERT INTO BIT_SHIFT_TABLE SELECT b>>4 FROM BIT_SHIFT_TABLE;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case5" value="INSERT INTO BIT_SHIFT_TABLE SELECT b>>8 FROM BIT_SHIFT_TABLE;" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case6" value="INSERT INTO BIT_SHIFT_TABLE VALUES (B'1101100000000000');" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case7" value="INSERT INTO BIT_TABLE VALUES (B'00000000000');" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case8" value="INSERT INTO BIT_TABLE VALUES (B'01010101010');" db-types="PostgreSQL" />
@@ -4162,7 +4088,6 @@
<sql-case id="insert_by_postgresql_source_test_case13" value="INSERT INTO INET_TBL (c, i) VALUES (cidr('ffff:ffff:ffff:ffff::/24'), '::192.168.1.226');" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case14" value="INSERT INTO LINE_TBL VALUES (line(point '(1,0)', point '(1,0)'));" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case15" value="INSERT INTO LINE_TBL VALUES (line(point '(3,1)', point '(3,2)'));" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case16" value="INSERT INTO LSEG_TBL VALUES (lseg(point(11, 22), point(33,44)));" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case31" value="INSERT INTO VARBIT_SHIFT_TABLE SELECT CAST(v || B'0' AS BIT VARYING(6)) >>1 FROM VARBIT_SHIFT_TABLE;" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case32" value="INSERT INTO VARBIT_SHIFT_TABLE SELECT CAST(v || B'00' AS BIT VARYING(8)) >>2 FROM VARBIT_SHIFT_TABLE;" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case33" value="INSERT INTO VARBIT_SHIFT_TABLE SELECT CAST(v || B'0000' AS BIT VARYING(12)) >>4 FROM VARBIT_SHIFT_TABLE;" db-types="PostgreSQL" />
@@ -4191,21 +4116,11 @@
<sql-case id="insert_by_postgresql_source_test_case124" value="INSERT INTO copy_t (SELECT x, md5(x::text) FROM generate_series(0,10) x);" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case129" value="INSERT INTO default_test DEFAULT VALUES;" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case132" value="INSERT INTO domarrtest (testint4arr[1], testint4arr[3]) values (11,22);" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case136" value="INSERT INTO f_star (class, a, c, e, f) VALUES ('f', 19, 'hi claire'::name, '-5'::int2, '(1,3),(2,4)'::polygon);" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case137" value="INSERT INTO f_star (class, a, c, f) VALUES ('f', 21, 'hi marcel'::name, '(11,44),(22,55),(33,66)'::polygon);" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case138" value="INSERT INTO f_star (class, a, e, f) VALUES ('f', 22, '-7'::int2, '(111,555),(222,666),(333,777),(444,888)'::polygon);" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case139" value="INSERT INTO f_star (class, a, f) VALUES ('f', 26, '(11111,33333),(22222,44444)'::polygon);" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case140" value="INSERT INTO f_star (class, c, e, f) VALUES ('f', 'hi keith'::name, '-8'::int2, '(1111,3333),(2222,4444)'::polygon);" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case141" value="INSERT INTO f_star (class, c, f) VALUES ('f', 'hi jeff'::name, '(111111,333333),(222222,444444)'::polygon);" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case142" value="INSERT INTO f_star (class, e, f) VALUES ('f', '-11'::int2, '(1111111,3333333),(2222222,4444444)'::polygon);" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case143" value="INSERT INTO f_star (class, f) VALUES ('f', '(11111111,33333333),(22222222,44444444)'::polygon);" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case145" value="INSERT INTO foo AS bar DEFAULT VALUES RETURNING *;" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case146" value="INSERT INTO foo AS bar DEFAULT VALUES RETURNING bar.*;" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case147" value="INSERT INTO foo AS bar DEFAULT VALUES RETURNING bar.f3;" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case148" value="INSERT INTO foo AS bar DEFAULT VALUES RETURNING foo.*;" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case161" value="INSERT INTO inhf DEFAULT VALUES;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case162" value="INSERT INTO iportaltest (i, d, p) VALUES (1, 3.567, '(3.0,1.0),(4.0,2.0)'::polygon);" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case163" value="INSERT INTO iportaltest (i, d, p) VALUES (2, 89.05, '(4.0,2.0),(3.0,1.0)'::polygon);" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case164" value="INSERT INTO itest1 DEFAULT VALUES;" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case165" value="INSERT INTO itest1 DEFAULT VALUES;" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case166" value="INSERT INTO itest2 DEFAULT VALUES;" db-types="PostgreSQL" />
@@ -4249,40 +4164,11 @@
<sql-case id="insert_by_postgresql_source_test_case243" value="INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case244" value="INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2,'()'));" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case271" value="INSERT INTO point_tbl(f1[0]) VALUES(0) RETURNING *;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case293" value="INSERT INTO pvactst SELECT i, array[1,2,3], point(i, i+1) FROM generate_series(1,1000) i;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case294" value="INSERT INTO quad_box_tbl SELECT (x - 1) * 100 + y, box(point(x * 10, y * 10), point(x * 10 + 5, y * 10 + 5)) FROM generate_series(1, 100) x, generate_series(1, 100) y;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case296" value="INSERT INTO quad_point_tbl SELECT '(333.0,400.0)'::point FROM generate_series(1,1000);" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case297" value="INSERT INTO quad_poly_tbl SELECT (x - 1) * 100 + y, polygon(circle(point(x * 10, y * 10), 1 + (x + y) % 10)) FROM generate_series(1, 100) x, generate_series(1, 100) y;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case298" value="INSERT INTO quad_poly_tbl SELECT i, polygon '((200, 300),(210, 310),(230, 290))' FROM generate_series(10001, 11000) AS i;" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case307" value="INSERT INTO s1 (SELECT x, md5(x::text) FROM generate_series(-10,10) x);" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case308" value="INSERT INTO s2 (SELECT x, md5(x::text) FROM generate_series(-6,6) x);" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case311" value="INSERT INTO t DEFAULT VALUES;" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case312" value="INSERT INTO t1 (SELECT x, md5(x::text) FROM generate_series(0,20) x);" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case317" value="INSERT INTO t2 (SELECT * FROM t1);" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case320" value="INSERT INTO tbl SELECT 1, 2, 3*x, box('4,4,4,4') FROM generate_series(1,10) AS x;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case321" value="INSERT INTO tbl SELECT 1, 2, 3*x, box('4,4,4,4') FROM generate_series(1,10) AS x;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case322" value="INSERT INTO tbl SELECT 1, 2, 3*x, box('4,4,4,4') FROM generate_series(1,10) AS x;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case323" value="INSERT INTO tbl SELECT 1, 2, 3*x, box('4,4,4,4') FROM generate_series(1,10) AS x;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case324" value="INSERT INTO tbl SELECT 1, 2, 3*x, box('4,4,4,4') FROM generate_series(1,10) AS x;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case325" value="INSERT INTO tbl SELECT 1, NULL, 3*x, box('4,4,4,4') FROM generate_series(1,10) AS x;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case326" value="INSERT INTO tbl SELECT 1, NULL, 3*x, box('4,4,4,4') FROM generate_series(1,10) AS x;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case327" value="INSERT INTO tbl SELECT x, 2*x, 3*x, box('4,4,4,4') FROM generate_series(1,10) AS x;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case328" value="INSERT INTO tbl SELECT x, 2*x, 3*x, box('4,4,4,4') FROM generate_series(1,10) AS x;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case329" value="INSERT INTO tbl SELECT x, 2*x, 3*x, box('4,4,4,4') FROM generate_series(1,1000) AS x;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case333" value="INSERT INTO tbl_gist SELECT x, 2*x, 3*x, box(point(3*x,2*x),point(3*x+1,2*x+1)) FROM generate_series(1,10) AS x;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case334" value="INSERT INTO tbl_gist SELECT x, 2*x, 3*x, box(point(x,x+1),point(2*x,2*x+1)) FROM generate_series(1,10) AS x;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case335" value="INSERT INTO tbl_gist SELECT x, 2*x, 3*x, box(point(x,x+1),point(2*x,2*x+1)) FROM generate_series(1,10) AS x;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case336" value="INSERT INTO tbl_gist SELECT x, 2*x, 3*x, box(point(x,x+1),point(2*x,2*x+1)) FROM generate_series(1,10) AS x;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case337" value="INSERT INTO tbl_gist SELECT x, 2*x, 3*x, box(point(x,x+1),point(2*x,2*x+1)) FROM generate_series(1,10) AS x;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case338" value="INSERT INTO tbl_gist SELECT x, 2*x, 3*x, box(point(x,x+1),point(2*x,2*x+1)) FROM generate_series(1,10) AS x;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case339" value="INSERT INTO tbl_gist SELECT x, 2*x, 3*x, box(point(x,x+1),point(2*x,2*x+1)) FROM generate_series(1,8000) AS x;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case340" value="INSERT INTO tbl_gist SELECT x, 2*x, 3*x, box(point(x,x+1),point(2*x,2*x+1)) FROM generate_series(1,8000) AS x;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case341" value="INSERT INTO tbl_include_box SELECT 1, 2*x, 3*x, box('4,4,4,4') FROM generate_series(1,10) AS x;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case342" value="INSERT INTO tbl_include_box_pk SELECT 1, 2, 3*x, box('4,4,4,4') FROM generate_series(1,10) AS x;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case343" value="INSERT INTO tbl_include_pk SELECT 1, 2*x, 3*x, box('4,4,4,4') FROM generate_series(1,10) AS x;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case344" value="INSERT INTO tbl_include_reg SELECT x, 2*x, 3*x, box('4,4,4,4') FROM generate_series(1,10) AS x;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case345" value="INSERT INTO tbl_include_unique1 SELECT x, 2*x, 3*x, box('4,4,4,4') FROM generate_series(1,10) AS x;" db-types="PostgreSQL" />
- <sql-case id="insert_by_postgresql_source_test_case346" value="INSERT INTO tbl_include_unique2 SELECT 1, 2, 3*x, box('4,4,4,4') FROM generate_series(1,10) AS x;" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case348" value="INSERT INTO test6 VALUES (1, U&'\00E4bc');" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case349" value="INSERT INTO test6 VALUES (2, U&'\0061\0308bc');" db-types="PostgreSQL" />
<sql-case id="insert_by_postgresql_source_test_case350" value="INSERT INTO test6a VALUES (1, ARRAY[U&'\00E4bc']);" db-types="PostgreSQL" />
@@ -4525,22 +4411,14 @@
<sql-case id="select_by_postgresql_source_test_case202" value="SELECT 'wa:1D wb:2A'::tsvector @@ 'w:*D <-> w:*A'::tsquery as "true";" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case203" value="SELECT ('127.0.0.1'::inet + 257) - 257;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case204" value="SELECT ('127::1'::inet + 257) - 257;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case205" value="SELECT ((-1::int2<<15)+1::int2)::text;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case206" value="SELECT ((-1::int4<<31)+1)::text;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case207" value="SELECT ((-1::int8<<63)+1)::text;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case208" value="SELECT (-12345)::money;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case209" value="SELECT (-1234567890)::int4::money;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case210" value="SELECT (-1234567890)::money;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case211" value="SELECT (-12345678901234567)::int8::money;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case212" value="SELECT (-12345678901234567)::money;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case213" value="SELECT (-12345678901234567)::numeric::money;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case214" value="SELECT (-1::int2<<15)::text;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case215" value="SELECT (-1::int4<<31)::text;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case216" value="SELECT (-1::int8<<63)::text;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case217" value="SELECT (@@ f1) AS center FROM POLYGON_TBL WHERE (# f1) > 2;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case218" value="SELECT (SELECT generate_series(1,3) LIMIT 1 OFFSET few.id) FROM few;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case219" value="SELECT (SELECT generate_series(1,3) LIMIT 1 OFFSET g.i) FROM generate_series(0,3) g(i);" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case220" value="SELECT (SELECT p FROM kd_point_tbl ORDER BY p <-> pt, p <-> '0,0' LIMIT 1) FROM (VALUES (point '1,2'), (NULL), ('1234,5678')) pts(pt);" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case221" value="SELECT * FROM arrtest WHERE a[1] < 5 and c = '{"foobar"}'::_name;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case222" value="SELECT * FROM (J1_TBL JOIN J2_TBL USING (i) AS x) AS xx WHERE x.i = 1;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case223" value="SELECT * FROM (VALUES (1),(2),(3)) v(r) LEFT JOIN ROWS FROM( rngfunc_sql(11,13), rngfunc_mat(11,13) ) WITH ORDINALITY AS f(i1,s1,i2,s2,o) ON (r+i1+i2)<100;" db-types="PostgreSQL" />
@@ -4549,23 +4427,12 @@
<sql-case id="select_by_postgresql_source_test_case226" value="SELECT * FROM (VALUES (1),(2),(3)) v(r), ROWS FROM( rngfunc_sql(11,11), rngfunc_mat(10+r,13) );" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case233" value="SELECT * FROM ROWS FROM(generate_series(10,11), get_users()) WITH ORDINALITY;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case234" value="SELECT * FROM ROWS FROM(get_users(), generate_series(10,11)) WITH ORDINALITY;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case235" value="SELECT * FROM box_temp WHERE f1 &< '(10,4.333334),(5,100)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case236" value="SELECT * FROM box_temp WHERE f1 &<| '(10,4.3333334),(5,1)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case237" value="SELECT * FROM box_temp WHERE f1 &> '(40,30),(45,50)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case238" value="SELECT * FROM box_temp WHERE f1 << '(10,20),(30,40)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case239" value="SELECT * FROM box_temp WHERE f1 <<| '(10,4.33334),(5,100)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case240" value="SELECT * FROM box_temp WHERE f1 >> '(30,40),(40,30)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case241" value="SELECT * FROM box_temp WHERE f1 |&> '(49.99,49.99),(49.99,49.99)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case242" value="SELECT * FROM box_temp WHERE f1 |>> '(37,38),(39,40)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case243" value="SELECT * FROM box_temp WHERE f1 ~= '(20,20),(40,40)';" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case244" value="SELECT * FROM circle_tbl WHERE f1 && circle(point(1,-2), 1) ORDER BY area(f1);" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case245" value="SELECT * FROM circle_tbl WHERE f1 && circle(point(1,-2), 1) ORDER BY area(f1);" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case246" value="SELECT * FROM fast_emp4000 WHERE home_base <@ '(200,200),(2000,1000)'::box ORDER BY (home_base[0])[0];" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case247" value="SELECT * FROM fast_emp4000 WHERE home_base <@ '(200,200),(2000,1000)'::box ORDER BY (home_base[0])[0];" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case248" value="SELECT * FROM fast_emp4000 WHERE home_base <@ '(200,200),(2000,1000)'::box ORDER BY (home_base[0])[0];" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case249" value="SELECT * FROM generate_series(1,2) r1, generate_series(r1,3) r2, ROWS FROM( rngfunc_sql(10+r1,13), rngfunc_mat(10+r2,13) );" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case250" value="SELECT * FROM gpolygon_tbl ORDER BY f1 <-> '(0,0)'::point LIMIT 10;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case251" value="SELECT * FROM gpolygon_tbl ORDER BY f1 <-> '(0,0)'::point LIMIT 10;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case252" value="SELECT * FROM inet_tbl WHERE '192.168.1.0/24'::cidr >> i;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case253" value="SELECT * FROM inet_tbl WHERE '192.168.1.0/24'::cidr >>= i;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case254" value="SELECT * FROM inet_tbl WHERE i && '192.168.1.0/24'::cidr ORDER BY i;" db-types="PostgreSQL" />
@@ -4605,16 +4472,7 @@
<sql-case id="select_by_postgresql_source_test_case288" value="SELECT * FROM nummultirange_test WHERE range_overlaps_multirange(numrange(4.0, 4.2), nmr);" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case289" value="SELECT * FROM numrange_test WHERE range_contained_by(numrange(-1e7,-10000.1), nr);" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case290" value="SELECT * FROM numrange_test WHERE range_contains(nr, numrange(1.9,1.91));" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case291" value="SELECT * FROM point_tbl WHERE f1 <@ '(-10,-10),(10,10)':: box ORDER BY f1 <-> '0,1';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case292" value="SELECT * FROM point_tbl WHERE f1 <@ '(-10,-10),(10,10)':: box ORDER BY f1 <-> '0,1';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case293" value="SELECT * FROM point_tbl WHERE f1 <@ '(-10,-10),(10,10)':: box ORDER BY f1 <-> '0,1';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case294" value="SELECT * FROM polygon_tbl WHERE f1 @> '((1,1),(2,2),(2,1))'::polygon ORDER BY (poly_center(f1))[0];" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case295" value="SELECT * FROM polygon_tbl WHERE f1 @> '((1,1),(2,2),(2,1))'::polygon ORDER BY (poly_center(f1))[0];" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case296" value="SELECT * FROM rank() OVER (ORDER BY random());" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case297" value="SELECT * FROM rls_tbl WHERE a <<< 1000;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case298" value="SELECT * FROM tststats.priv_test_tbl WHERE a <<< 0 AND b <<< 0;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case299" value="SELECT * FROM tststats.priv_test_tbl WHERE a <<< 0 AND b <<< 0;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case300" value="SELECT * FROM tststats.priv_test_view WHERE a <<< 0 AND b <<< 0;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case301" value="SELECT * FROM unnest('base hidden rebel spaceship strike'::tsvector);" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case302" value="SELECT * FROM unnest('base:7 hidden:6 rebel:1 spaceship:2,33A,34B,35C,36D strike:3'::tsvector);" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case303" value="SELECT 1 LIMIT generate_series(1,3);" db-types="PostgreSQL" />
@@ -4629,12 +4487,6 @@
<sql-case id="select_by_postgresql_source_test_case312" value="SELECT 2 !=-- comment to be removed by psql 1;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case313" value="SELECT 2 \r SELECT 3 \p UNION SELECT 4 \p UNION SELECT 5 ORDER BY 1;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case314" value="SELECT CAST('42' AS text COLLATE "C");" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case315" value="SELECT COUNT(*) FROM point_gist_tbl WHERE f1 <@ '(0.0000009,0.0000009),(0.0000009,0.0000009)'::box;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case316" value="SELECT COUNT(*) FROM point_gist_tbl WHERE f1 <@ '(0.0000009,0.0000009),(0.0000009,0.0000009)'::box;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case317" value="SELECT COUNT(*) FROM point_gist_tbl WHERE f1 ~= '(0.0000009,0.0000009)'::point;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case318" value="SELECT COUNT(*) FROM point_gist_tbl WHERE f1 ~= '(0.0000009,0.0000009)'::point;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case319" value="SELECT COUNT(*) FROM point_gist_tbl WHERE f1 ~= '(0.0000018,0.0000018)'::point;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case320" value="SELECT COUNT(*) FROM point_gist_tbl WHERE f1 ~= '(0.0000018,0.0000018)'::point;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case321" value="SELECT DATE_TRUNC('CENTURY', DATE '0002-02-04');" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case322" value="SELECT DATE_TRUNC('CENTURY', DATE '0055-08-10 BC');" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case323" value="SELECT DATE_TRUNC('CENTURY', DATE '1970-03-20');" db-types="PostgreSQL" />
@@ -4841,8 +4693,6 @@
<sql-case id="select_by_postgresql_source_test_case544" value="SELECT a FROM (VALUES ('0.0.0.0/0'::inet), ('0.0.0.0/1'::inet), ('0.0.0.0/32'::inet), ('0.0.0.1/0'::inet), ('0.0.0.1/1'::inet), ('127.126.127.127/0'::inet), ('127.127.127.127/0'::inet), ('127.128.127.127/0'::inet), ('192.168.1.0/24'::inet), ('192.168.1.0/25'::inet), ('192.168.1.1/23'::inet), [...]
<sql-case id="select_by_postgresql_source_test_case545" value="SELECT a FROM arrtest WHERE a[2] IS NULL;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case546" value="SELECT a, b, gcd(a, b), gcd(a, -b), gcd(-b, a), gcd(-b, -a) FROM (VALUES (0::numeric, 0::numeric), (0::numeric, numeric 'NaN'), (0::numeric, 46375::numeric), (433125::numeric, 46375::numeric), (43312.5::numeric, 4637.5::numeric), (4331.250::numeric, 463.75000::numeric), ('inf', '0'), ('inf', & [...]
- <sql-case id="select_by_postgresql_source_test_case547" value="SELECT a,a<<4 AS "a<<4",b,b>>2 AS "b>>2" FROM bit_table;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case548" value="SELECT a,a<<4 AS "a<<4",b,b>>2 AS "b>>2" FROM varbit_table;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case549" value="SELECT a,b, lcm(a, b), lcm(a, -b), lcm(-b, a), lcm(-b, -a) FROM (VALUES (0::numeric, 0::numeric), (0::numeric, numeric 'NaN'), (0::numeric, 13272::numeric), (13272::numeric, 13272::numeric), (423282::numeric, 13272::numeric), (42328.2::numeric, 1327.2::numeric), (4232.820::numeric, 132.72000::numeric), ('inf', &a [...]
<sql-case id="select_by_postgresql_source_test_case550" value="SELECT a.aggfnoid, p.proname FROM pg_aggregate as a, pg_proc as p WHERE a.aggcombinefn = p.oid AND (p.pronargs != 2 OR p.prorettype != p.proargtypes[0] OR p.prorettype != p.proargtypes[1] OR NOT binary_coercible(a.aggtranstype, p.proargtypes[0]));" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case551" value="SELECT a.aggfnoid, p.proname FROM pg_aggregate as a, pg_proc as p WHERE a.aggdeserialfn = p.oid AND (p.prorettype != 'internal'::regtype OR p.pronargs != 2 OR p.proargtypes[0] != 'bytea'::regtype OR p.proargtypes[1] != 'internal'::regtype OR NOT p.proisstrict);" db-types="PostgreSQL" />
@@ -4875,27 +4725,9 @@
<sql-case id="select_by_postgresql_source_test_case578" value="SELECT atanh(float8 '0.5');" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case579" value="SELECT atanh(float8 'infinity');" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case580" value="SELECT atanh(float8 'nan');" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case581" value="SELECT b, b >> 1 AS bsr, b << 1 AS bsl FROM BIT_SHIFT_TABLE ;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case582" value="SELECT b, b >> 8 AS bsr8, b << 8 AS bsl8 FROM BIT_SHIFT_TABLE ;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case583" value="SELECT b.f1 FROM BOX_TBL b WHERE b.f1 && box '(2.5,2.5,1.0,1.0)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case584" value="SELECT b.f1 FROM BOX_TBL b WHERE b.f1 < box '(3.0,3.0,5.0,5.0)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case585" value="SELECT b.f1 FROM BOX_TBL b WHERE b.f1 << box '(3.0,3.0,5.0,5.0)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case586" value="SELECT b.f1 FROM BOX_TBL b WHERE b.f1 <= box '(3.0,3.0,5.0,5.0)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case587" value="SELECT b.f1 FROM BOX_TBL b WHERE b.f1 = box '(3.0,3.0,5.0,5.0)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case588" value="SELECT b.f1 FROM BOX_TBL b WHERE box '(0,0,3,3)' @> b.f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case589" value="SELECT b.f1 FROM BOX_TBL b WHERE box '(1,1,3,3)' ~= b.f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case590" value="SELECT b.f1 FROM BOX_TBL b WHERE box '(3.0,3.0,5.0,5.0)' >> b.f1;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case591" value="SELECT b.f1, p.f1, b.f1 * p.f1 FROM BOX_TBL b, POINT_TBL p WHERE p.f1[0] > 1000;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case592" value="SELECT b.f1, p.f1, b.f1 * p.f1 FROM BOX_TBL b, POINT_TBL p WHERE p.f1[0] BETWEEN 1 AND 1000;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case593" value="SELECT b.f1, p.f1, b.f1 / p.f1 FROM BOX_TBL b, POINT_TBL p WHERE p.f1[0] BETWEEN 1 AND 1000;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case594" value="SELECT b1.* FROM BOX_TBL b1 WHERE b1.f1 &< box '(2.0,2.0,2.5,2.5)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case595" value="SELECT b1.* FROM BOX_TBL b1 WHERE b1.f1 &> box '(2.0,2.0,2.5,2.5)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case596" value="SELECT b1.*, b2.* FROM BOX_TBL b1, BOX_TBL b2 WHERE b1.f1 @> b2.f1 and not b1.f1 ~= b2.f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case597" value="SELECT b1.f1, b2.f1, b1.f1 # b2.f1 FROM BOX_TBL b1, BOX_TBL b2;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case598" value="SELECT b1.f1, b2.f1, b1.f1 <^ b2.f1 FROM BOX_TBL b1, BOX_TBL b2;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case599" value="SELECT b1.f1, b2.f1, b1.f1 >^ b2.f1 FROM BOX_TBL b1, BOX_TBL b2;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case600" value="SELECT b::bit(15), b::bit(15) >> 1 AS bsr, b::bit(15) << 1 AS bsl FROM BIT_SHIFT_TABLE ;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case601" value="SELECT b::bit(15), b::bit(15) >> 8 AS bsr8, b::bit(15) << 8 AS bsl8 FROM BIT_SHIFT_TABLE ;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case602" value="SELECT b::macaddr <= '08:00:2b:01:02:04' FROM macaddr8_data WHERE a = 1;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case603" value="SELECT b::macaddr <> '08:00:2b:01:02:03'::macaddr FROM macaddr8_data WHERE a = 1;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case604" value="SELECT b::macaddr <> '08:00:2b:01:02:04'::macaddr FROM macaddr8_data WHERE a = 1;" db-types="PostgreSQL" />
@@ -4937,22 +4769,10 @@
<sql-case id="select_by_postgresql_source_test_case640" value="SELECT c AS cidr, network(c) AS "network(cidr)", i AS inet, network(i) AS "network(inet)" FROM INET_TBL;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case641" value="SELECT c.* FROM pg_cast c, pg_proc p WHERE c.castfunc = p.oid AND ((p.pronargs > 1 AND p.proargtypes[1] != 'int4'::regtype) OR (p.pronargs > 2 AND p.proargtypes[2] != 'bool'::regtype));" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case642" value="SELECT c.* FROM pg_cast c, pg_proc p WHERE c.castfunc = p.oid AND (p.pronargs < 1 OR p.pronargs > 3 OR NOT (binary_coercible(c.castsource, p.proargtypes[0]) OR (c.castsource = 'character'::regtype AND p.proargtypes[0] = 'text'::regtype)) OR NOT binary_coercible(p.prorettype, c.casttarget));" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case643" value="SELECT c.f1, p.f1, c.f1 / p.f1 FROM CIRCLE_TBL c, POINT_TBL p WHERE p.f1 ~= '(0,0)'::point;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case644" value="SELECT c.f1, p.f1, c.f1 / p.f1 FROM CIRCLE_TBL c, POINT_TBL p WHERE p.f1[0] > 1000;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case645" value="SELECT c.f1, p.f1, c.f1 / p.f1 FROM CIRCLE_TBL c, POINT_TBL p WHERE p.f1[0] BETWEEN 1 AND 1000;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case646" value="SELECT c0 FROM ONLY expr_stats_incompatible_test WHERE ( upper('x') LIKE ('x'||('[0,1]'::int4range)) AND (c0 IN (0, 1) OR c1) );" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case647" value="SELECT c1.f1 AS circle, p1.f1 AS point, (p1.f1 <-> c1.f1) AS distance FROM CIRCLE_TBL c1, POINT_TBL p1 WHERE (p1.f1 <-> c1.f1) > 0 ORDER BY distance, area(c1.f1), p1.f1[0];" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case648" value="SELECT c1.f1, c2.f1 FROM CIRCLE_TBL c1, CIRCLE_TBL c2 WHERE c1.f1 &< c2.f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case649" value="SELECT c1.f1, c2.f1 FROM CIRCLE_TBL c1, CIRCLE_TBL c2 WHERE c1.f1 &<| c2.f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case650" value="SELECT c1.f1, c2.f1 FROM CIRCLE_TBL c1, CIRCLE_TBL c2 WHERE c1.f1 &> c2.f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case651" value="SELECT c1.f1, c2.f1 FROM CIRCLE_TBL c1, CIRCLE_TBL c2 WHERE c1.f1 << c2.f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case652" value="SELECT c1.f1, c2.f1 FROM CIRCLE_TBL c1, CIRCLE_TBL c2 WHERE c1.f1 <<| c2.f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case653" value="SELECT c1.f1, c2.f1 FROM CIRCLE_TBL c1, CIRCLE_TBL c2 WHERE c1.f1 >> c2.f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case654" value="SELECT c1.f1, c2.f1 FROM CIRCLE_TBL c1, CIRCLE_TBL c2 WHERE c1.f1 |&> c2.f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case655" value="SELECT c1.f1, c2.f1 FROM CIRCLE_TBL c1, CIRCLE_TBL c2 WHERE c1.f1 |>> c2.f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case656" value="SELECT c1.f1, c2.f1 FROM CIRCLE_TBL c1, CIRCLE_TBL c2 WHERE c1.f1 ~= c2.f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case663" value="SELECT circle_center(f1), round(radius(f1)) as radius FROM gcircle_tbl ORDER BY f1 <-> '(200,300)'::point LIMIT 10;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case664" value="SELECT circle_center(f1), round(radius(f1)) as radius FROM gcircle_tbl ORDER BY f1 <-> '(200,300)'::point LIMIT 10;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case665" value="SELECT cosh(float8 '-infinity');" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case666" value="SELECT cosh(float8 '1');" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case667" value="SELECT cosh(float8 'infinity');" db-types="PostgreSQL" />
@@ -4968,76 +4788,6 @@
<sql-case id="select_by_postgresql_source_test_case677" value="SELECT count(*) AS two FROM TIMESTAMPTZ_TBL WHERE d1 = timestamp(2) with time zone 'now';" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case678" value="SELECT count(*) AS two FROM TIMESTAMP_TBL WHERE d1 = timestamp(2) without time zone 'now';" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case679" value="SELECT count(*) FROM dupindexcols WHERE f1 BETWEEN 'WA' AND 'ZZZ' and id < 1000 and f1 ~<~ 'YX';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case680" value="SELECT count(*) FROM fast_emp4000 WHERE home_base && '(1000,1000,0,0)'::box;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case681" value="SELECT count(*) FROM fast_emp4000 WHERE home_base && '(1000,1000,0,0)'::box;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case682" value="SELECT count(*) FROM fast_emp4000 WHERE home_base && '(1000,1000,0,0)'::box;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case683" value="SELECT count(*) FROM gcircle_tbl WHERE f1 && '<(500,500),500>'::circle;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case684" value="SELECT count(*) FROM gcircle_tbl WHERE f1 && '<(500,500),500>'::circle;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case685" value="SELECT count(*) FROM gpolygon_tbl WHERE f1 && '(1000,1000,0,0)'::polygon;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case686" value="SELECT count(*) FROM gpolygon_tbl WHERE f1 && '(1000,1000,0,0)'::polygon;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case687" value="SELECT count(*) FROM kd_point_tbl WHERE box '(200,200,1000,1000)' @> p;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case688" value="SELECT count(*) FROM kd_point_tbl WHERE box '(200,200,1000,1000)' @> p;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case689" value="SELECT count(*) FROM kd_point_tbl WHERE p << '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case690" value="SELECT count(*) FROM kd_point_tbl WHERE p << '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case691" value="SELECT count(*) FROM kd_point_tbl WHERE p <<| '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case692" value="SELECT count(*) FROM kd_point_tbl WHERE p <<| '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case693" value="SELECT count(*) FROM kd_point_tbl WHERE p >> '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case694" value="SELECT count(*) FROM kd_point_tbl WHERE p >> '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case695" value="SELECT count(*) FROM kd_point_tbl WHERE p |>> '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case696" value="SELECT count(*) FROM kd_point_tbl WHERE p |>> '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case697" value="SELECT count(*) FROM kd_point_tbl WHERE p ~= '(4585, 365)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case698" value="SELECT count(*) FROM kd_point_tbl WHERE p ~= '(4585, 365)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case699" value="SELECT count(*) FROM point_tbl WHERE box '(0,0,100,100)' @> f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case700" value="SELECT count(*) FROM point_tbl WHERE box '(0,0,100,100)' @> f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case701" value="SELECT count(*) FROM point_tbl p WHERE p.f1 << '(0.0, 0.0)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case702" value="SELECT count(*) FROM point_tbl p WHERE p.f1 << '(0.0, 0.0)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case703" value="SELECT count(*) FROM point_tbl p WHERE p.f1 <<| '(0.0, 0.0)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case704" value="SELECT count(*) FROM point_tbl p WHERE p.f1 <<| '(0.0, 0.0)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case705" value="SELECT count(*) FROM point_tbl p WHERE p.f1 >> '(0.0, 0.0)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case706" value="SELECT count(*) FROM point_tbl p WHERE p.f1 >> '(0.0, 0.0)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case707" value="SELECT count(*) FROM point_tbl p WHERE p.f1 |>> '(0.0, 0.0)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case708" value="SELECT count(*) FROM point_tbl p WHERE p.f1 |>> '(0.0, 0.0)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case709" value="SELECT count(*) FROM point_tbl p WHERE p.f1 ~= '(-5, -12)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case710" value="SELECT count(*) FROM point_tbl p WHERE p.f1 ~= '(-5, -12)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case711" value="SELECT count(*) FROM quad_box_tbl WHERE b && box '((100,200),(300,500))';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case712" value="SELECT count(*) FROM quad_box_tbl WHERE b &< box '((100,200),(300,500))';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case713" value="SELECT count(*) FROM quad_box_tbl WHERE b &<| box '((100,200),(300,500))';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case714" value="SELECT count(*) FROM quad_box_tbl WHERE b &> box '((100,200),(300,500))';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case715" value="SELECT count(*) FROM quad_box_tbl WHERE b << box '((100,200),(300,500))';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case716" value="SELECT count(*) FROM quad_box_tbl WHERE b <<| box '((100,200),(300,500))';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case717" value="SELECT count(*) FROM quad_box_tbl WHERE b >> box '((100,200),(300,500))';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case718" value="SELECT count(*) FROM quad_box_tbl WHERE b >> box '((100,200),(300,500))';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case719" value="SELECT count(*) FROM quad_box_tbl WHERE b |&> box '((100,200),(300,500))';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case720" value="SELECT count(*) FROM quad_box_tbl WHERE b |>> box '((100,200),(300,500))';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case721" value="SELECT count(*) FROM quad_box_tbl WHERE b ~= box '((200,300),(205,305))';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case722" value="SELECT count(*) FROM quad_point_tbl WHERE box '(200,200,1000,1000)' @> p;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case723" value="SELECT count(*) FROM quad_point_tbl WHERE box '(200,200,1000,1000)' @> p;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case724" value="SELECT count(*) FROM quad_point_tbl WHERE box '(200,200,1000,1000)' @> p;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case725" value="SELECT count(*) FROM quad_point_tbl WHERE p << '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case726" value="SELECT count(*) FROM quad_point_tbl WHERE p << '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case727" value="SELECT count(*) FROM quad_point_tbl WHERE p << '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case728" value="SELECT count(*) FROM quad_point_tbl WHERE p <<| '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case729" value="SELECT count(*) FROM quad_point_tbl WHERE p <<| '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case730" value="SELECT count(*) FROM quad_point_tbl WHERE p <<| '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case731" value="SELECT count(*) FROM quad_point_tbl WHERE p >> '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case732" value="SELECT count(*) FROM quad_point_tbl WHERE p >> '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case733" value="SELECT count(*) FROM quad_point_tbl WHERE p >> '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case734" value="SELECT count(*) FROM quad_point_tbl WHERE p |>> '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case735" value="SELECT count(*) FROM quad_point_tbl WHERE p |>> '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case736" value="SELECT count(*) FROM quad_point_tbl WHERE p |>> '(5000, 4000)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case737" value="SELECT count(*) FROM quad_point_tbl WHERE p ~= '(4585, 365)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case738" value="SELECT count(*) FROM quad_point_tbl WHERE p ~= '(4585, 365)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case739" value="SELECT count(*) FROM quad_point_tbl WHERE p ~= '(4585, 365)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case740" value="SELECT count(*) FROM quad_poly_tbl WHERE p && polygon '((300,300),(400,600),(600,500),(700,200))';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case741" value="SELECT count(*) FROM quad_poly_tbl WHERE p &< polygon '((300,300),(400,600),(600,500),(700,200))';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case742" value="SELECT count(*) FROM quad_poly_tbl WHERE p &<| polygon '((300,300),(400,600),(600,500),(700,200))';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case743" value="SELECT count(*) FROM quad_poly_tbl WHERE p &> polygon '((300,300),(400,600),(600,500),(700,200))';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case744" value="SELECT count(*) FROM quad_poly_tbl WHERE p << polygon '((300,300),(400,600),(600,500),(700,200))';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case745" value="SELECT count(*) FROM quad_poly_tbl WHERE p <<| polygon '((300,300),(400,600),(600,500),(700,200))';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case746" value="SELECT count(*) FROM quad_poly_tbl WHERE p >> polygon '((300,300),(400,600),(600,500),(700,200))';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case747" value="SELECT count(*) FROM quad_poly_tbl WHERE p |&> polygon '((300,300),(400,600),(600,500),(700,200))';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case748" value="SELECT count(*) FROM quad_poly_tbl WHERE p |>> polygon '((300,300),(400,600),(600,500),(700,200))';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case749" value="SELECT count(*) FROM quad_poly_tbl WHERE p ~= polygon '((200, 300),(210, 310),(230, 290))';" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case750" value="SELECT count(*) FROM radix_text_tbl WHERE t ^@ 'Worth';" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case751" value="SELECT count(*) FROM radix_text_tbl WHERE t ^@ 'Worth';" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case752" value="SELECT count(*) FROM radix_text_tbl WHERE t ^@ 'Worth';" db-types="PostgreSQL" />
@@ -5093,19 +4843,9 @@
<sql-case id="select_by_postgresql_source_test_case813" value="SELECT f.f1, |/f.f1 AS sqrt_f1 FROM FLOAT8_TBL f WHERE f.f1 > '0.0';" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case814" value="SELECT f.f1, ||/f.f1 AS cbrt_f1 FROM FLOAT8_TBL f;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case816" value="SELECT f1 + time with time zone '00:01' AS "Illegal" FROM TIMETZ_TBL;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case817" value="SELECT f1 AS open_path, polygon( pclose(f1)) AS polygon FROM PATH_TBL WHERE isopen(f1);" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case818" value="SELECT f1 as "date", date_part('year', f1) AS year, date_part('month', f1) AS month, date_part('day', f1) AS day, date_part('quarter', f1) AS quarter, date_part('decade', f1) AS decade, date_part('century', f1) AS century, date_part('millennium', f1) AS millennium, date_part('isoyear', f1) AS isoyear, [...]
<sql-case id="select_by_postgresql_source_test_case819" value="SELECT f1, EXTRACT(MICROSECOND FROM f1) AS MICROSECOND, EXTRACT(MILLISECOND FROM f1) AS MILLISECOND, EXTRACT(SECOND FROM f1) AS SECOND, EXTRACT(MINUTE FROM f1) AS MINUTE, EXTRACT(HOUR FROM f1) AS HOUR, EXTRACT(DAY FROM f1) AS DAY, EXTRACT(MONTH FROM f1) AS MONTH, EXTRACT(QUARTER FROM f1) AS QUARTER, EXTRACT(YEAR FROM f1) AS YEAR, EXTRACT(DECADE FROM f1) AS DECADE, EXTRACT(CENTUR [...]
<sql-case id="select_by_postgresql_source_test_case820" value="SELECT f1, date_part('microsecond', f1) AS microsecond, date_part('millisecond', f1) AS millisecond, date_part('second', f1) AS second, date_part('epoch', f1) AS epoch FROM INTERVAL_TBL;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case821" value="SELECT f1, @-@ f1 FROM PATH_TBL;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case823" value="SELECT f1, f1::box FROM POLYGON_TBL;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case825" value="SELECT f1, f1::polygon FROM CIRCLE_TBL WHERE f1 >= '<(0,0),1>';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case826" value="SELECT f1, f1::polygon FROM PATH_TBL WHERE isclosed(f1);" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case827" value="SELECT f1, f1::polygon FROM PATH_TBL WHERE isopen(f1);" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case828" value="SELECT f1, polygon(1, f1) FROM CIRCLE_TBL WHERE f1 >= '<(0,0),1>';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case829" value="SELECT f1, polygon(10, f1) FROM CIRCLE_TBL WHERE f1 < '<(0,0),1>';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case830" value="SELECT f1, polygon(8, f1) FROM CIRCLE_TBL WHERE f1 >= '<(0,0),1>';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case831" value="SELECT f1::box FROM POINT_TBL;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case832" value="SELECT f1[0:1] FROM POINT_TBL;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case833" value="SELECT f1[0:] FROM POINT_TBL;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case834" value="SELECT f1[:1] FROM POINT_TBL;" db-types="PostgreSQL" />
@@ -5121,7 +4861,6 @@
<sql-case id="select_by_postgresql_source_test_case846" value="SELECT i AS inet, host(i), text(i), family(i) FROM INET_TBL;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case847" value="SELECT i FROM inet_tbl WHERE i << '192.168.1.0/24'::cidr ORDER BY i;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case848" value="SELECT i FROM inet_tbl WHERE i << '192.168.1.0/24'::cidr ORDER BY i;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case850" value="SELECT i, c, i < c AS lt, i <= c AS le, i = c AS eq, i >= c AS ge, i > c AS gt, i <> c AS ne, i << c AS sb, i <<= c AS sbe, i >> c AS sup, i >>= c AS spe, i && c AS ovr FROM INET_TBL;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case851" value="SELECT i, ~i AS "~i" FROM inet_tbl;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case852" value="SELECT i,SUM(v::money) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) FROM (VALUES(1,'1.10'),(2,'2.20'),(3,NULL),(4,NULL)) t(i,v);" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case853" value="SELECT i.* FROM INT2_TBL i WHERE (i.f1 % int2 '2') = int2 '1';" db-types="PostgreSQL" />
@@ -5189,22 +4928,10 @@
<sql-case id="select_by_postgresql_source_test_case915" value="SELECT jsonb_path_query_first('[{"a": 1}, {"a": 2}, {"a": 3}, {"a": 5}]', '$[*].a ? (@ > $min && @ < $max)', vars => '{"min": 1, "max": 4}');" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case916" value="SELECT jsonb_path_query_first('[{"a": 1}, {"a": 2}, {"a": 3}, {"a": 5}]', '$[*].a ? (@ > $min && @ < $max)', vars => '{"min": 3, "max": 4}');" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case917" value="SELECT jsonb_path_query_first('[{"a": 1}, {"a": 2}, {}]', 'strict $[*].a', silent => true);" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case921" value="SELECT l.s, b.f1 FROM LINE_TBL l, BOX_TBL b WHERE l.s ?# b.f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case922" value="SELECT l.s, b.f1 FROM LSEG_TBL l, BOX_TBL b WHERE l.s ?# b.f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case923" value="SELECT l.s, b.f1, l.s ## b.f1 FROM LINE_TBL l, BOX_TBL b;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case924" value="SELECT l.s, b.f1, l.s ## b.f1 FROM LSEG_TBL l, BOX_TBL b;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case925" value="SELECT l.s, l1.s FROM LSEG_TBL l, LINE_TBL l1 WHERE l.s ?# l1.s;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case926" value="SELECT l.s, l1.s, l.s ## l1.s FROM LINE_TBL l, LSEG_TBL l1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case927" value="SELECT l.s, l1.s, l.s ## l1.s FROM LSEG_TBL l, LINE_TBL l1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case928" value="SELECT l1.s, l2.s FROM LINE_TBL l1, LINE_TBL l2 WHERE l1.s ?# l2.s;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case929" value="SELECT l1.s, l2.s, l1.s # l2.s FROM LINE_TBL l1, LINE_TBL l2;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case930" value="SELECT l1.s, l2.s, l1.s # l2.s FROM LSEG_TBL l1, LSEG_TBL l2;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case931" value="SELECT l1.s, l2.s, l1.s ## l2.s FROM LSEG_TBL l1, LSEG_TBL l2;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case932" value="SELECT length(a[1]), length(a[2]) from parse_ident('"xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx [...]
<sql-case id="select_by_postgresql_source_test_case933" value="SELECT lexeme, positions[1] from unnest('base:7 hidden:6 rebel:1 spaceship:2,33A,34B,35C,36D strike:3'::tsvector);" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case934" value="SELECT m / '2'::money FROM money_data;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case935" value="SELECT macaddr8_set7bit('00:08:2b:01:02:03'::macaddr8);" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case936" value="SELECT name, #thepath FROM iexit ORDER BY name COLLATE "C", 2;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case937" value="SELECT noabort_increasing, noabort_decreasing FROM abbrev_abort_uuids ORDER BY noabort_decreasing NULLS FIRST OFFSET 20000 - 4;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case938" value="SELECT noabort_increasing, noabort_decreasing FROM abbrev_abort_uuids ORDER BY noabort_increasing OFFSET 20000 - 4;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case939" value="SELECT normalize(U&'\0061\0308\24D1c') = U&'\00E4\24D1c' COLLATE "C" AS test_default;" db-types="PostgreSQL" />
@@ -5214,17 +4941,14 @@
<sql-case id="select_by_postgresql_source_test_case943" value="SELECT normalize(U&'\00E4\24D1c', NFKD) = U&'\0061\0308bc' COLLATE "C" AS test_nfkd;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case944" value="SELECT normalize(U&'\00E4bc', NFC) = U&'\00E4bc' COLLATE "C" AS test_nfc_idem;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case945" value="SELECT not bool 'f' AS true;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case946" value="SELECT npoints(f1) AS npoints, f1 AS polygon FROM POLYGON_TBL;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case947" value="SELECT num, val, val IS NFC NORMALIZED AS NFC, val IS NFD NORMALIZED AS NFD, val IS NFKC NORMALIZED AS NFKC, val IS NFKD NORMALIZED AS NFKD FROM (VALUES (1, U&'\00E4bc'), (2, U&'\0061\0308bc'), (3, U&'\00E4\24D1c'), (4, U&'\0061\0308\24D1c'), (5, '')) vals (num, val) ORDER BY num;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case948" value="SELECT num_nonnulls(1, 2, NULL::text, NULL::point, '', int8 '9', 1.0 / NULL);" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case949" value="SELECT num_nulls(1, 2, NULL::text, NULL::point, '', int8 '9', 1.0 / NULL);" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case950" value="SELECT nummultirange() && 'empty'::numrange;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case951" value="SELECT nummultirange() && nummultirange(numrange(1,2));" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case952" value="SELECT nummultirange() &< 'empty'::numrange;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case953" value="SELECT nummultirange() &< nummultirange();" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case954" value="SELECT nummultirange() &< nummultirange(numrange(1,2));" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case955" value="SELECT nummultirange() &> 'empty'::numrange;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case956" value="SELECT nummultirange() &> nummultirange();" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case957" value="SELECT nummultirange() &> nummultirange(numrange(1,2));" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case958" value="SELECT nummultirange() * nummultirange(numrange(1,2));" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case959" value="SELECT nummultirange() + nummultirange(numrange(1,2));" db-types="PostgreSQL" />
@@ -5336,39 +5060,13 @@
<sql-case id="select_by_postgresql_source_test_case1065" value="SELECT overlay(B'0101011100' placing '001' from 11);" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case1066" value="SELECT overlay(B'0101011100' placing '001' from 20);" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case1067" value="SELECT overlay(B'0101011100' placing '101' from 6);" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1068" value="SELECT p.* FROM POINT_TBL p WHERE box '(0,0,100,100)' @> p.f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1069" value="SELECT p.* FROM POINT_TBL p WHERE not box '(0,0,100,100)' @> p.f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1070" value="SELECT p.* FROM POINT_TBL p WHERE '(0.0,0.0)' >> p.f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1071" value="SELECT p.* FROM POINT_TBL p WHERE '(0.0,0.0)' |>> p.f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1072" value="SELECT p.* FROM POINT_TBL p WHERE p.f1 << '(0.0, 0.0)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1073" value="SELECT p.* FROM POINT_TBL p WHERE p.f1 <<| '(0.0, 0.0)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1074" value="SELECT p.* FROM POINT_TBL p WHERE p.f1 ~= '(5.1, 34.5)';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1075" value="SELECT p.f1, b.f1, p.f1 ## b.f1 FROM POINT_TBL p, BOX_TBL b;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1076" value="SELECT p.f1, l.s, l.s # p.f1 AS intersection FROM LSEG_TBL l, POINT_TBL p;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1077" value="SELECT p.f1, l.s, p.f1 ## l.s FROM POINT_TBL p, LINE_TBL l;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1078" value="SELECT p.f1, l.s, p.f1 ## l.s FROM POINT_TBL p, LSEG_TBL l;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1079" value="SELECT p.f1, p.f1 <-> point '(0,0)' AS dist FROM POINT_TBL p ORDER BY dist;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1080" value="SELECT p.f1, p1.f1, p.f1 / p1.f1 FROM PATH_TBL p, POINT_TBL p1 WHERE p1.f1 ~= '(0,0)'::point;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case1081" value="SELECT p.f1, p1.f1, p.f1 / p1.f1 FROM PATH_TBL p, POINT_TBL p1 WHERE p1.f1[0] BETWEEN 1 AND 1000;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case1082" value="SELECT p.oid, p.proname, c.oid, c.conname FROM pg_proc p, pg_conversion c WHERE p.oid = c.conproc AND (p.prorettype != 'int4'::regtype OR p.proretset OR p.pronargs != 6 OR p.proargtypes[0] != 'int4'::regtype OR p.proargtypes[1] != 'int4'::regtype OR p.proargtypes[2] != 'cstring'::regtype OR p.proargtypes[3] != 'internal'::regtype OR p.pro [...]
- <sql-case id="select_by_postgresql_source_test_case1083" value="SELECT p1.f1 FROM POINT_TBL p1 WHERE ishorizontal(p1.f1, point '(0,0)');" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1084" value="SELECT p1.f1 FROM POINT_TBL p1 WHERE isvertical(p1.f1, point '(5.1,34.5)');" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case1085" value="SELECT p1.f1 AS point1, p2.f1 AS point2, (p1.f1 <-> p2.f1) AS distance FROM POINT_TBL p1, POINT_TBL p2 WHERE (p1.f1 <-> p2.f1) > 3 and p1.f1 << p2.f1 ORDER BY distance, p1.f1[0], p2.f1[0];" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1086" value="SELECT p1.f1 AS point1, p2.f1 AS point2, (p1.f1 <-> p2.f1) AS distance FROM POINT_TBL p1, POINT_TBL p2 WHERE (p1.f1 <-> p2.f1) > 3 and p1.f1 << p2.f1 and p1.f1 |>> p2.f1 ORDER BY distance;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case1087" value="SELECT p1.f1 AS point1, p2.f1 AS point2, p1.f1 <-> p2.f1 AS dist FROM POINT_TBL p1, POINT_TBL p2 ORDER BY dist, p1.f1[0], p2.f1[0];" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1088" value="SELECT p1.f1, p2.f1 FROM POLYGON_TBL p1, POLYGON_TBL p2 WHERE p1.f1 &< p2.f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1089" value="SELECT p1.f1, p2.f1 FROM POLYGON_TBL p1, POLYGON_TBL p2 WHERE p1.f1 &<| p2.f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1090" value="SELECT p1.f1, p2.f1 FROM POLYGON_TBL p1, POLYGON_TBL p2 WHERE p1.f1 &> p2.f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1091" value="SELECT p1.f1, p2.f1 FROM POLYGON_TBL p1, POLYGON_TBL p2 WHERE p1.f1 << p2.f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1092" value="SELECT p1.f1, p2.f1 FROM POLYGON_TBL p1, POLYGON_TBL p2 WHERE p1.f1 <<| p2.f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1093" value="SELECT p1.f1, p2.f1 FROM POLYGON_TBL p1, POLYGON_TBL p2 WHERE p1.f1 >> p2.f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1094" value="SELECT p1.f1, p2.f1 FROM POLYGON_TBL p1, POLYGON_TBL p2 WHERE p1.f1 |&> p2.f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1095" value="SELECT p1.f1, p2.f1 FROM POLYGON_TBL p1, POLYGON_TBL p2 WHERE p1.f1 |>> p2.f1;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1096" value="SELECT p1.f1, p2.f1 FROM POLYGON_TBL p1, POLYGON_TBL p2 WHERE p1.f1 ~= p2.f1;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case1097" value="SELECT p1.f1, p2.f1, line(p1.f1, p2.f1) FROM POINT_TBL p1, POINT_TBL p2 WHERE p1.f1 <> p2.f1;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case1098" value="SELECT p1.f1, p2.f1, p1.f1 * p2.f1 FROM POINT_TBL p1, POINT_TBL p2 WHERE p1.f1[0] < 1;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case1099" value="SELECT p1.f1, p2.f1, p1.f1 * p2.f1 FROM POINT_TBL p1, POINT_TBL p2 WHERE p1.f1[0] BETWEEN 1 AND 1000;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1100" value="SELECT p1.f1, p2.f1, p1.f1 / p2.f1 FROM POINT_TBL p1, POINT_TBL p2 WHERE p2.f1 ~= '(0,0)'::point;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case1101" value="SELECT p1.f1, p2.f1, p1.f1 / p2.f1 FROM POINT_TBL p1, POINT_TBL p2 WHERE p2.f1[0] > 1000;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case1102" value="SELECT p1.f1, p2.f1, p1.f1 / p2.f1 FROM POINT_TBL p1, POINT_TBL p2 WHERE p2.f1[0] BETWEEN 1 AND 1000;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case1103" value="SELECT p1.oid, p1.amname, p2.oid, p2.proname FROM pg_am AS p1, pg_proc AS p2 WHERE p2.oid = p1.amhandler AND p1.amtype = 'i' AND (p2.prorettype != 'index_am_handler'::regtype OR p2.proretset OR p2.pronargs != 1 OR p2.proargtypes[0] != 'internal'::regtype);" db-types="PostgreSQL" />
@@ -5429,7 +5127,6 @@
<sql-case id="select_by_postgresql_source_test_case1158" value="SELECT power(float8 'inf', float8 '2');" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case1159" value="SELECT power(float8 'inf', float8 'inf');" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case1160" value="SELECT q1, float8(q1) FROM INT8_TBL;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1161" value="SELECT q1, q1 << 2 AS "shl", q1 >> 3 AS "shr" FROM INT8_TBL;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case1162" value="SELECT q1, q2, q1 & q2 AS "and", q1 | q2 AS "or", q1 # q2 AS "xor", ~q1 AS "not" FROM INT8_TBL;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case1164" value="SELECT q2, float8(q2) FROM INT8_TBL;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case1165" value="SELECT range_merge(nummultirange(numrange(1,2)));" db-types="PostgreSQL" />
@@ -5440,8 +5137,6 @@
<sql-case id="select_by_postgresql_source_test_case1182" value="SELECT reloptions FROM pg_class WHERE oid = :toast_oid;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case1183" value="SELECT reltoastrelid as toast_oid FROM pg_class WHERE oid = 'reloptions_test'::regclass \gset SELECT reloptions FROM pg_class WHERE oid = :toast_oid;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case1184" value="SELECT row_to_json(x.*) FROM J1_TBL JOIN J2_TBL USING (i) AS x WHERE J1_TBL.t = 'one';" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1185" value="SELECT s, @-@ s FROM LSEG_TBL;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1186" value="SELECT s, s::point FROM LSEG_TBL;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case1187" value="SELECT set_bit('\x1234567890abcdef00'::bytea, 43, 0);" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case1188" value="SELECT set_bit('\x1234567890abcdef00'::bytea, 99, 0);" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case1189" value="SELECT set_bit(B'0101011000100100', 15, 1);" db-types="PostgreSQL" />
@@ -5541,8 +5236,6 @@
<sql-case id="select_by_postgresql_source_test_case1283" value="SELECT v as value, hashinet(v)::bit(32) as standard, hashinetextended(v, 0)::bit(32) as extended0, hashinetextended(v, 1)::bit(32) as extended1 FROM (VALUES (NULL::inet), ('192.168.100.128/25'), ('192.168.100.0/8'), ('172.168.10.126/16'), ('172.18.103.126/24'), ('192.188.13.16/32')) x(v) WHERE hashinet(v)::bit(32) != hashinetextended(v, 0)::bit(32 [...]
<sql-case id="select_by_postgresql_source_test_case1284" value="SELECT v as value, hashmacaddr(v)::bit(32) as standard, hashmacaddrextended(v, 0)::bit(32) as extended0, hashmacaddrextended(v, 1)::bit(32) as extended1 FROM (VALUES (NULL::macaddr), ('08:00:2b:01:02:04'), ('08:00:2b:01:02:04'), ('e2:7f:51:3e:70:49'), ('d6:a9:4a:78:1c:d5'), ('ea:29:b1:5e:1f:a5')) x(v) WHERE hashmacaddr(v)::bit(32) != hashm [...]
<sql-case id="select_by_postgresql_source_test_case1285" value="SELECT v as value, hashmacaddr8(v)::bit(32) as standard, hashmacaddr8extended(v, 0)::bit(32) as extended0, hashmacaddr8extended(v, 1)::bit(32) as extended1 FROM (VALUES (NULL::macaddr8), ('08:00:2b:01:02:04:36:49'), ('08:00:2b:01:02:04:f0:e8'), ('e2:7f:51:3e:70:49:16:29'), ('d6:a9:4a:78:1c:d5:47:32'), ('ea:29:b1:5e:1f:a5')) x(v) WHERE hash [...]
- <sql-case id="select_by_postgresql_source_test_case1286" value="SELECT v, v >> 1 AS vsr, v << 1 AS vsl FROM VARBIT_SHIFT_TABLE ;" db-types="PostgreSQL" />
- <sql-case id="select_by_postgresql_source_test_case1287" value="SELECT v, v >> 8 AS vsr8, v << 8 AS vsl8 FROM VARBIT_SHIFT_TABLE ;" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case1288" value="SELECT xmlelement(name foo, bytea 'bar');" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case1289" value="SELECT xmlelement(name foo, bytea 'bar');" db-types="PostgreSQL" />
<sql-case id="select_by_postgresql_source_test_case1290" value="SELECT ||/ float8 '27' AS three;" db-types="PostgreSQL" />
@@ -6151,15 +5844,10 @@
<sql-case id="low_create_by_postgresql_source_test_case548" value="create temporary view vw_ord as select * from rows from(unnest(array[10,20],array['foo','bar']), generate_series(1,2)) as z(a,b,c);" db-types="PostgreSQL" />
<sql-case id="low_create_by_postgresql_source_test_case549" value="create temporary view vw_ord as select * from rows from(unnest(array[10,20],array['foo','bar'],array[1.0])) as z(a,b,c);" db-types="PostgreSQL" />
<sql-case id="low_create_by_postgresql_source_test_case550" value="create temporary view vw_rngfunc as select * from rows from(getrngfunc9(1), getrngfunc7(1) AS (rngfuncid int, rngfuncsubid int, rngfuncname text), getrngfunc1(1)) with ordinality as t1(a,b,c,d,e,f,g,n);" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case551" value="create type cantcompare as (p point, r float8);" db-types="PostgreSQL" />
<sql-case id="low_create_by_postgresql_source_test_case552" value="create type cashrange as range (subtype = money);" db-types="PostgreSQL" />
<sql-case id="low_create_by_postgresql_source_test_case553" value="create type ct1 as (f1 money);" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case554" value="create type testtype4 as (a int, b point);" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case555" value="create type testtype6 as (a int, b point);" db-types="PostgreSQL" />
- <sql-case id="low_create_by_postgresql_source_test_case556" value="create type testtype6 as (a int, b point);" db-types="PostgreSQL" />
<sql-case id="low_create_by_postgresql_source_test_case558" value="create view insertconflictv as select * from insertconflict with cascaded check option;" db-types="PostgreSQL" />
<sql-case id="low_create_by_postgresql_source_test_case559" value="create view tt201v as select extract(day from now()) as extr, (now(), '1 day'::interval) overlaps (current_timestamp(2), '1 day'::interval) as o, 'foo' is normalized isn, 'foo' is nfkc normalized isnn, normalize('foo') as n, normalize('foo', nfkd) as nfkd, overlay('foo' placing 'bar' from 2) as ovl, overlay('foo&ap [...]
- <sql-case id="low_create_by_postgresql_source_test_case560" value="create view tt26v as select x + y + z as c1, (x * y) + z as c2, x + (y * z) as c3, (x + y) * z as c4, x * (y + z) as c5, x + (y + z) as c6, x + (y # z) as c7, (x > y) AND (y > z OR x > z) as c8, (x > y) OR (y > z AND NOT (x > z)) as c9, (x,y) <> ALL (values(1,2),(3,4)) as c10, (x,y) <= ANY (values(1,2),(3,4)) as c11 from ( [...]
<sql-case id="low_create_by_postgresql_source_test_case561" value="create view view_of_joins_2d as select * from (tbl1 join tbl1a using (a) as x) as y;" db-types="PostgreSQL" />
<sql-case id="low_delete_by_postgresql_source_test_case1" value="delete from;" db-types="PostgreSQL" />
<sql-case id="low_do_by_postgresql_source_test_case1" value="do $$ declare r integer; begin select dfunc(a=>-- comment 1) into r; raise info 'r = %', r; end; $$;" db-types="PostgreSQL" />
@@ -6365,8 +6053,6 @@
<sql-case id="low_insert_by_postgresql_source_test_case21" value="insert into domdeftest default values;" db-types="PostgreSQL" />
<sql-case id="low_insert_by_postgresql_source_test_case22" value="insert into domdeftest default values;" db-types="PostgreSQL" />
<sql-case id="low_insert_by_postgresql_source_test_case23" value="insert into domnotnull default values;" db-types="PostgreSQL" />
- <sql-case id="low_insert_by_postgresql_source_test_case35" value="insert into gist_point_tbl (id, p) select g+100000, point(g*10+1, g*10+1) from generate_series(1, 10000) g;" db-types="PostgreSQL" />
- <sql-case id="low_insert_by_postgresql_source_test_case36" value="insert into gist_point_tbl (id, p) select g, point(g*10, g*10) from generate_series(1, 10000) g;" db-types="PostgreSQL" />
<sql-case id="low_insert_by_postgresql_source_test_case38" value="insert into gstest4 values (1,1,b'0000','1'), (2,2,b'0001','1'), (3,4,b'0010','2'), (4,8,b'0011','2'), (5,16,b'0000','2'), (6,32,b'0001','2'), (7,64,b'0010','1'), (8,128,b'0011','1');" db-types="PostgreSQL" />
<sql-case id="low_insert_by_postgresql_source_test_case39" value="insert into i8mr_array values (42, array[int8multirange(int8range(1,10)), int8multirange(int8range(2,20))]);" db-types="PostgreSQL" />
<sql-case id="low_insert_by_postgresql_source_test_case40" value="insert into i8r_array values (42, array[int8range(1,10), int8range(2,20)]);" db-types="PostgreSQL" />
@@ -6386,9 +6072,6 @@
<sql-case id="low_insert_by_postgresql_source_test_case68" value="insert into public.brintest_multi (float4col) values (real 'nan');" db-types="PostgreSQL" />
<sql-case id="low_insert_by_postgresql_source_test_case69" value="insert into public.brintest_multi (float8col) values (real 'nan');" db-types="PostgreSQL" />
<sql-case id="low_insert_by_postgresql_source_test_case70" value="insert into reservations values (1, daterange('2018-07-01', '2018-07-07')), (1, daterange('2018-07-07', '2018-07-14')), (1, daterange('2018-07-20', '2018-07-22')), (2, daterange('2018-07-01', '2018-07-03')), (3, NULL), (4, NULL), (4, NULL), (5, NULL), (5, daterange('2018-07-01', '2018-07-03')), (6, daterange('2018-0 [...]
- <sql-case id="low_insert_by_postgresql_source_test_case90" value="insert into spgist_point_tbl (id, p) select g+100000, point(g*10+1, g*10+1) from generate_series(1, 10000) g;" db-types="PostgreSQL" />
- <sql-case id="low_insert_by_postgresql_source_test_case91" value="insert into spgist_point_tbl (id, p) select g, point(g*10, g*10) from generate_series(1, 10000) g;" db-types="PostgreSQL" />
- <sql-case id="low_insert_by_postgresql_source_test_case92" value="insert into spgist_point_tbl (id, p) select g, point(g*10, g*10) from generate_series(1, 10) g;" db-types="PostgreSQL" />
<sql-case id="low_insert_by_postgresql_source_test_case94" value="insert into spgist_text_tbl (id, t) select g, 'f' || repeat('o', 100) || g from generate_series(1, 10000) g union all select g, 'baaaaaaaaaaaaaar' || g from generate_series(1, 1000) g;" db-types="PostgreSQL" />
<sql-case id="low_insert_by_postgresql_source_test_case105" value="insert into test_mode select 1 from generate_series(1,1000) union all select 2;" db-types="PostgreSQL" />
<sql-case id="low_insert_by_postgresql_source_test_case107" value="insert into test_multirange_gist select int4multirange(int4range(NULL, g*10, '(]'), int4range(g*10, g*20, '(]')) from generate_series(1,100) g;" db-types="PostgreSQL" />
@@ -6437,8 +6120,6 @@
<sql-case id="low_select_by_postgresql_source_test_case20" value="select (row(1, 2.0)).*;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case21" value="select (select (a.*)::text) from view_a a;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case22" value="select (w).size = :segsize as ok from (select pg_ls_waldir() w) ss where length((w).name) = 24 limit 1;" db-types="PostgreSQL" />
- <sql-case id="low_select_by_postgresql_source_test_case23" value="select * from array_to_set(array['one', 'two']) as t(f1 point,f2 text);" db-types="PostgreSQL" />
- <sql-case id="low_select_by_postgresql_source_test_case24" value="select * from array_to_set(array['one', 'two']) as t(f1 point,f2 text);" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case25" value="select * from duplic(int4range(42,49));" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case30" value="select * from inoutparam_succeed(int4range(1,2));" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case31" value="select * from int8_tbl i where i.* in (values(i.*::int8_tbl));" db-types="PostgreSQL" />
@@ -6510,23 +6191,18 @@
<sql-case id="low_select_by_postgresql_source_test_case97" value="select array(select row(v.a,s1.*) from (select two,four, count(*) from onek group by grouping sets(two,four) order by two,four) s1) from (values (1),(2)) v(a);" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case98" value="select conname, obj_description(oid, 'pg_constraint') as desc from pg_constraint where conname like 'at_partitioned%' order by conname;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case99" value="select conname, obj_description(oid, 'pg_constraint') as desc from pg_constraint where conname like 'at_partitioned%' order by conname;" db-types="PostgreSQL" />
- <sql-case id="low_select_by_postgresql_source_test_case100" value="select count(*) from (values (point(5,5)),(point(8,8)),(point(12,12))) v(p) where exists(select * from spgist_box_tbl b where b.b && box(v.p,v.p));" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case101" value="select count(*) from test_multirange_gist where mr && 'empty'::int4range;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case102" value="select count(*) from test_multirange_gist where mr && 'empty'::int4range;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case103" value="select count(*) from test_multirange_gist where mr && int4range(10,20);" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case104" value="select count(*) from test_multirange_gist where mr && int4range(10,20);" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case105" value="select count(*) from test_multirange_gist where mr &< 'empty'::int4range;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case106" value="select count(*) from test_multirange_gist where mr &< 'empty'::int4range;" db-types="PostgreSQL" />
- <sql-case id="low_select_by_postgresql_source_test_case107" value="select count(*) from test_multirange_gist where mr &< '{}'::int4multirange;" db-types="PostgreSQL" />
- <sql-case id="low_select_by_postgresql_source_test_case108" value="select count(*) from test_multirange_gist where mr &< '{}'::int4multirange;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case109" value="select count(*) from test_multirange_gist where mr &< int4multirange(int4range(100,200), int4range(400,500));" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case110" value="select count(*) from test_multirange_gist where mr &< int4multirange(int4range(100,200), int4range(400,500));" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case111" value="select count(*) from test_multirange_gist where mr &< int4range(100,500);" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case112" value="select count(*) from test_multirange_gist where mr &< int4range(100,500);" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case113" value="select count(*) from test_multirange_gist where mr &> 'empty'::int4range;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case114" value="select count(*) from test_multirange_gist where mr &> 'empty'::int4range;" db-types="PostgreSQL" />
- <sql-case id="low_select_by_postgresql_source_test_case115" value="select count(*) from test_multirange_gist where mr &> '{}'::int4multirange;" db-types="PostgreSQL" />
- <sql-case id="low_select_by_postgresql_source_test_case116" value="select count(*) from test_multirange_gist where mr &> '{}'::int4multirange;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case117" value="select count(*) from test_multirange_gist where mr &> int4multirange(int4range(100,200), int4range(400,500));" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case118" value="select count(*) from test_multirange_gist where mr &> int4multirange(int4range(100,200), int4range(400,500));" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case119" value="select count(*) from test_multirange_gist where mr &> int4range(100,500);" db-types="PostgreSQL" />
@@ -6539,8 +6215,6 @@
<sql-case id="low_select_by_postgresql_source_test_case126" value="select count(*) from test_multirange_gist where mr -|- int4range(100,500);" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case127" value="select count(*) from test_multirange_gist where mr << 'empty'::int4range;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case128" value="select count(*) from test_multirange_gist where mr << 'empty'::int4range;" db-types="PostgreSQL" />
- <sql-case id="low_select_by_postgresql_source_test_case129" value="select count(*) from test_multirange_gist where mr << '{}'::int4multirange;" db-types="PostgreSQL" />
- <sql-case id="low_select_by_postgresql_source_test_case130" value="select count(*) from test_multirange_gist where mr << '{}'::int4multirange;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case131" value="select count(*) from test_multirange_gist where mr << int4multirange(int4range(100,200), int4range(400,500));" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case132" value="select count(*) from test_multirange_gist where mr << int4multirange(int4range(100,200), int4range(400,500));" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case133" value="select count(*) from test_multirange_gist where mr << int4range(100,500);" db-types="PostgreSQL" />
@@ -6551,8 +6225,6 @@
<sql-case id="low_select_by_postgresql_source_test_case138" value="select count(*) from test_multirange_gist where mr = int4multirange(int4range(10,20), int4range(30,40), int4range(50,60));" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case139" value="select count(*) from test_multirange_gist where mr >> 'empty'::int4range;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case140" value="select count(*) from test_multirange_gist where mr >> 'empty'::int4range;" db-types="PostgreSQL" />
- <sql-case id="low_select_by_postgresql_source_test_case141" value="select count(*) from test_multirange_gist where mr >> '{}'::int4multirange;" db-types="PostgreSQL" />
- <sql-case id="low_select_by_postgresql_source_test_case142" value="select count(*) from test_multirange_gist where mr >> '{}'::int4multirange;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case143" value="select count(*) from test_multirange_gist where mr >> int4multirange(int4range(100,200), int4range(400,500));" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case144" value="select count(*) from test_multirange_gist where mr >> int4multirange(int4range(100,200), int4range(400,500));" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case145" value="select count(*) from test_multirange_gist where mr >> int4range(100,500);" db-types="PostgreSQL" />
@@ -6680,7 +6352,6 @@
<sql-case id="low_select_by_postgresql_source_test_case268" value="select f1(int4range(42, 49), 11, 2::smallint) as int, f1(float8range(4.5, 7.8), 7.8, 11::real) as num;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case269" value="select f1(int4range(42, 49), 11, 4.5) as fail;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case270" value="select f1(int4range(42, 49), array[11]) as int, f1(float8range(4.5, 7.8), array[7]) as num;" db-types="PostgreSQL" />
- <sql-case id="low_select_by_postgresql_source_test_case271" value="select f1(point(3,4));" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case272" value="select f1, f1[1], (f1[1])[1] from dposintatable;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case273" value="select f1, f1[1], (f1[2])[1] from dposintatable;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case279" value="select format('create index on gexec_test(%I)', attname) from pg_attribute where attrelid = 'gexec_test'::regclass and attnum > 0 order by attnum \gexec select 'select 1 as ones', 'select x.y, x.y*2 as double from generate_series(1,4) as x(y)' union all select 'drop table gexec_test', NULL union all select 'drop table gexec_test', 'select '' [...]
@@ -6739,11 +6410,9 @@
<sql-case id="low_select_by_postgresql_source_test_case334" value="select multirangetypes_sql(int4multirange(int4range(1,10)), ARRAY[2,20]);" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case335" value="select multirangetypes_sql(nummultirange(numrange(1,10)), ARRAY[2,20]);" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case336" value="select nummultirange() << 'empty'::numrange;" db-types="PostgreSQL" />
- <sql-case id="low_select_by_postgresql_source_test_case337" value="select nummultirange() << nummultirange();" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case338" value="select nummultirange() << nummultirange(numrange(1,2));" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case339" value="select nummultirange() << numrange(1,2);" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case340" value="select nummultirange() >> 'empty'::numrange;" db-types="PostgreSQL" />
- <sql-case id="low_select_by_postgresql_source_test_case341" value="select nummultirange() >> nummultirange();" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case342" value="select nummultirange() >> nummultirange(numrange(1,2));" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case343" value="select nummultirange() >> numrange(1,2);" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case344" value="select nummultirange(numrange(-4,-2), numrange(0,2)) << numrange(3,6);" db-types="PostgreSQL" />
@@ -6788,7 +6457,6 @@
<sql-case id="low_select_by_postgresql_source_test_case392" value="select polyf(multirange(int4range(42, 49)), 11, 2::smallint) as int, polyf(multirange(float8range(4.5, 7.8)), 7.8, 11::real) as num;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case393" value="select polyf(multirange(int4range(42, 49)), 11, 4.5) as fail;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case394" value="select polyf(multirange(int4range(42, 49)), array[11]) as int, polyf(multirange(float8range(4.5, 7.8)), array[7]) as num;" db-types="PostgreSQL" />
- <sql-case id="low_select_by_postgresql_source_test_case395" value="select polyf(point(3,4));" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case396" value="select q1, float8(count(*)) / (select count(*) from int8_tbl) from int8_tbl group by q1 order by q1;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case397" value="select r, r is null as isnull, r is not null as isnotnull from (values (1,row(1,2)), (1,row(null,null)), (1,null), (null,row(1,2)), (null,row(null,null)), (null,null) ) r(a,b);" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case398" value="select range_add_bounds(int4multirange(int4range(1, 17)));" db-types="PostgreSQL" />
@@ -6853,24 +6521,16 @@
<sql-case id="low_select_by_postgresql_source_test_case457" value="select x from (values (array[100::money]), (array[200::money])) _(x) union select x from (values (array[100::money]), (array[300::money])) _(x);" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case458" value="select x from (values (row(100::money)), (row(200::money))) _(x) union select x from (values (row(100::money)), (row(300::money))) _(x);" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case459" value="select x from (values (row(100::money)::ct1), (row(200::money)::ct1)) _(x) union select x from (values (row(100::money)::ct1), (row(300::money)::ct1)) _(x);" db-types="PostgreSQL" />
- <sql-case id="low_select_by_postgresql_source_test_case460" value="select x, pg_typeof(x) from anyctest(11, '{1,2}', point(1,2), '(3,4)') x;" db-types="PostgreSQL" />
- <sql-case id="low_select_by_postgresql_source_test_case461" value="select x, pg_typeof(x) from anyctest(11, array[1, 2], point(1,2), point(3,4)) x;" db-types="PostgreSQL" />
- <sql-case id="low_select_by_postgresql_source_test_case462" value="select x, pg_typeof(x) from anyctest(11, array[point(1,2)]) x;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case463" value="select x, pg_typeof(x) from anyctest(11, int4range(4,7)) x;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case464" value="select x, pg_typeof(x) from anyctest(11, multirange(int4range(4,7))) x;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case465" value="select x, pg_typeof(x) from anyctest(11, multirange(numrange(4,7))) x;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case466" value="select x, pg_typeof(x) from anyctest(11, numrange(4,7)) x;" db-types="PostgreSQL" />
- <sql-case id="low_select_by_postgresql_source_test_case467" value="select x, pg_typeof(x) from anyctest(11, point(1,2)) x;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case468" value="select x, pg_typeof(x) from anyctest(11.2, int4range(4,7)) x;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case469" value="select x, pg_typeof(x) from anyctest(11.2, multirange(int4range(4,7))) x;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case470" value="select x, pg_typeof(x) from anyctest(int4range(11,12), int4range(4,7)) x;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case471" value="select x, pg_typeof(x) from anyctest(int4range(11,12), numrange(4,7)) x;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case472" value="select x, pg_typeof(x) from anyctest(multirange(int4range(11,12)), multirange(int4range(4,7))) x;" db-types="PostgreSQL" />
<sql-case id="low_select_by_postgresql_source_test_case473" value="select x, pg_typeof(x) from anyctest(multirange(int4range(11,12)), multirange(numrange(4,7))) x;" db-types="PostgreSQL" />
- <sql-case id="low_select_by_postgresql_source_test_case474" value="select x, pg_typeof(x), y, pg_typeof(y) from f1(11, '{1,2}', point(1,2), '(3,4)');" db-types="PostgreSQL" />
- <sql-case id="low_select_by_postgresql_source_test_case475" value="select x, pg_typeof(x), y, pg_typeof(y) from f1(11, array[1, 2], point(1,2), point(3,4));" db-types="PostgreSQL" />
- <sql-case id="low_select_by_postgresql_source_test_case476" value="select x, pg_typeof(x), y, pg_typeof(y) from polyf(11, '{1,2}', point(1,2), '(3,4)');" db-types="PostgreSQL" />
- <sql-case id="low_select_by_postgresql_source_test_case477" value="select x, pg_typeof(x), y, pg_typeof(y) from polyf(11, array[1, 2], point(1,2), point(3,4));" db-types="PostgreSQL" />
<sql-case id="low_short_by_postgresql_source_test_case1" value="short select * from basictest;" db-types="PostgreSQL" />
<sql-case id="low_still_by_postgresql_source_test_case1" value="still not okay \g select 42 (bogus forty_two;" db-types="PostgreSQL" />
<sql-case id="low_test1_by_postgresql_source_test_case1" value="test1 CREATE FUNCTION fun_instead_of_insert_tbl() RETURNS trigger AS $$ BEGIN INSERT INTO instead_of_insert_tbl (name) VALUES (NEW.str); RETURN NULL; END; $$ LANGUAGE plpgsql;" db-types="PostgreSQL" />