This is an automated email from the ASF dual-hosted git repository.
duanzhengqiang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new 498951d2bf7 add SQL parser for MySQL DO statement. (#18378)
498951d2bf7 is described below
commit 498951d2bf76b801299e01660a42c77173def74d
Author: Zonglei Dong <[email protected]>
AuthorDate: Mon Jun 20 08:49:55 2022 +0800
add SQL parser for MySQL DO statement. (#18378)
* add SQL parser for MySQL DO statement.
* fix code import style.
* add test case for MySQL DO statement.
* add test case for MySQL DO statement.
---
.../infra/binder/SQLStatementContextFactory.java | 5 +
.../binder/statement/dml/DoStatementContext.java | 14 +-
.../text/data/DatabaseBackendHandlerFactory.java | 4 +
.../impl/MySQLDMLStatementSQLVisitor.java | 4 +-
.../core/database/visitor/SQLVisitorRule.java | 4 +-
.../statement/mysql/dml/MySQLDoStatement.java | 11 +
.../asserts/statement/dml/DMLStatementAssert.java | 5 +
.../statement/dml/impl/DoStatementAssert.java | 72 +++
.../jaxb/cases/domain/SQLParserTestCases.java | 5 +
.../impl/dostatement/ExpectedDoParameter.java | 44 ++
.../impl/dostatement/ExpectedDoParameters.java | 22 +-
.../domain/statement/dml/DoStatementTestCase.java | 21 +-
.../src/main/resources/case/dml/do.xml | 78 +++
.../src/main/resources/sql/supported/dml/do.xml | 27 ++
.../main/resources/sql/unsupported/unsupported.xml | 537 ---------------------
15 files changed, 294 insertions(+), 559 deletions(-)
diff --git
a/shardingsphere-infra/shardingsphere-infra-binder/src/main/java/org/apache/shardingsphere/infra/binder/SQLStatementContextFactory.java
b/shardingsphere-infra/shardingsphere-infra-binder/src/main/java/org/apache/shardingsphere/infra/binder/SQLStatementContextFactory.java
index a0ee1111de0..bab01186672 100644
---
a/shardingsphere-infra/shardingsphere-infra-binder/src/main/java/org/apache/shardingsphere/infra/binder/SQLStatementContextFactory.java
+++
b/shardingsphere-infra/shardingsphere-infra-binder/src/main/java/org/apache/shardingsphere/infra/binder/SQLStatementContextFactory.java
@@ -56,6 +56,7 @@ import
org.apache.shardingsphere.infra.binder.statement.ddl.TruncateStatementCon
import
org.apache.shardingsphere.infra.binder.statement.dml.CallStatementContext;
import
org.apache.shardingsphere.infra.binder.statement.dml.CopyStatementContext;
import
org.apache.shardingsphere.infra.binder.statement.dml.DeleteStatementContext;
+import org.apache.shardingsphere.infra.binder.statement.dml.DoStatementContext;
import
org.apache.shardingsphere.infra.binder.statement.dml.InsertStatementContext;
import
org.apache.shardingsphere.infra.binder.statement.dml.SelectStatementContext;
import
org.apache.shardingsphere.infra.binder.statement.dml.UpdateStatementContext;
@@ -90,6 +91,7 @@ import
org.apache.shardingsphere.sql.parser.sql.common.statement.dml.CallStateme
import
org.apache.shardingsphere.sql.parser.sql.common.statement.dml.CopyStatement;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.dml.DMLStatement;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.dml.DeleteStatement;
+import
org.apache.shardingsphere.sql.parser.sql.common.statement.dml.DoStatement;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.dml.InsertStatement;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.dml.SelectStatement;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.dml.UpdateStatement;
@@ -172,6 +174,9 @@ public final class SQLStatementContextFactory {
if (sqlStatement instanceof CopyStatement) {
return new CopyStatementContext((CopyStatement) sqlStatement);
}
+ if (sqlStatement instanceof DoStatement) {
+ return new DoStatementContext((DoStatement) sqlStatement);
+ }
throw new UnsupportedOperationException(String.format("Unsupported SQL
statement `%s`", sqlStatement.getClass().getSimpleName()));
}
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dml/MySQLDoStatement.java
b/shardingsphere-infra/shardingsphere-infra-binder/src/main/java/org/apache/shardingsphere/infra/binder/statement/dml/DoStatementContext.java
similarity index 71%
copy from
shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dml/MySQLDoStatement.java
copy to
shardingsphere-infra/shardingsphere-infra-binder/src/main/java/org/apache/shardingsphere/infra/binder/statement/dml/DoStatementContext.java
index 4ed87ae440c..fba06c17bff 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dml/MySQLDoStatement.java
+++
b/shardingsphere-infra/shardingsphere-infra-binder/src/main/java/org/apache/shardingsphere/infra/binder/statement/dml/DoStatementContext.java
@@ -15,15 +15,17 @@
* limitations under the License.
*/
-package org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dml;
+package org.apache.shardingsphere.infra.binder.statement.dml;
-import lombok.ToString;
+import
org.apache.shardingsphere.infra.binder.statement.CommonSQLStatementContext;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.dml.DoStatement;
-import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.MySQLStatement;
/**
- * MySQL do statement.
+ * Do statement context.
*/
-@ToString
-public final class MySQLDoStatement extends DoStatement implements
MySQLStatement {
+public final class DoStatementContext extends
CommonSQLStatementContext<DoStatement> {
+
+ public DoStatementContext(final DoStatement sqlStatement) {
+ super(sqlStatement);
+ }
}
diff --git
a/shardingsphere-proxy/shardingsphere-proxy-backend/src/main/java/org/apache/shardingsphere/proxy/backend/text/data/DatabaseBackendHandlerFactory.java
b/shardingsphere-proxy/shardingsphere-proxy-backend/src/main/java/org/apache/shardingsphere/proxy/backend/text/data/DatabaseBackendHandlerFactory.java
index 0cd3a43f60e..8f63caeb80d 100644
---
a/shardingsphere-proxy/shardingsphere-proxy-backend/src/main/java/org/apache/shardingsphere/proxy/backend/text/data/DatabaseBackendHandlerFactory.java
+++
b/shardingsphere-proxy/shardingsphere-proxy-backend/src/main/java/org/apache/shardingsphere/proxy/backend/text/data/DatabaseBackendHandlerFactory.java
@@ -27,6 +27,7 @@ import
org.apache.shardingsphere.proxy.backend.text.data.impl.UnicastDatabaseBac
import org.apache.shardingsphere.sql.parser.sql.common.statement.SQLStatement;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.dal.DALStatement;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.dal.SetStatement;
+import
org.apache.shardingsphere.sql.parser.sql.common.statement.dml.DoStatement;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.dml.SelectStatement;
/**
@@ -45,6 +46,9 @@ public final class DatabaseBackendHandlerFactory {
*/
public static DatabaseBackendHandler newInstance(final
SQLStatementContext<?> sqlStatementContext, final String sql, final
ConnectionSession connectionSession) {
SQLStatement sqlStatement = sqlStatementContext.getSqlStatement();
+ if (sqlStatement instanceof DoStatement) {
+ return new UnicastDatabaseBackendHandler(sqlStatementContext, sql,
connectionSession);
+ }
if (sqlStatement instanceof SetStatement) {
return new BroadcastDatabaseBackendHandler(sqlStatementContext,
sql, connectionSession);
}
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-mysql/src/main/java/org/apache/shardingsphere/sql/parser/mysql/visitor/statement/impl/MySQLDMLStatementSQLVisitor.java
b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-mysql/src/main/java/org/apache/shardingsphere/sql/parser/mysql/visitor/statement/impl/MySQLDMLStatementSQLVisitor.java
index 1d44635580a..d2ba08ddfa9 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-mysql/src/main/java/org/apache/shardingsphere/sql/parser/mysql/visitor/statement/impl/MySQLDMLStatementSQLVisitor.java
+++
b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-mysql/src/main/java/org/apache/shardingsphere/sql/parser/mysql/visitor/statement/impl/MySQLDMLStatementSQLVisitor.java
@@ -50,6 +50,8 @@ public final class MySQLDMLStatementSQLVisitor extends
MySQLStatementSQLVisitor
@Override
public ASTNode visitDoStatement(final DoStatementContext ctx) {
- return new MySQLDoStatement();
+ List<ExpressionSegment> parameters = new ArrayList<>();
+ ctx.expr().forEach(each -> parameters.add((ExpressionSegment)
visit(each)));
+ return new MySQLDoStatement(parameters);
}
}
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-engine/src/main/java/org/apache/shardingsphere/sql/parser/core/database/visitor/SQLVisitorRule.java
b/shardingsphere-sql-parser/shardingsphere-sql-parser-engine/src/main/java/org/apache/shardingsphere/sql/parser/core/database/visitor/SQLVisitorRule.java
index 92bb3b98a27..8a69e042c18 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-engine/src/main/java/org/apache/shardingsphere/sql/parser/core/database/visitor/SQLVisitorRule.java
+++
b/shardingsphere-sql-parser/shardingsphere-sql-parser-engine/src/main/java/org/apache/shardingsphere/sql/parser/core/database/visitor/SQLVisitorRule.java
@@ -570,7 +570,9 @@ public enum SQLVisitorRule {
CLUSTER("Cluster", SQLStatementType.DDL),
- CREATE_ACCESS_METHOD("CreateAccessMethod", SQLStatementType.DDL);
+ CREATE_ACCESS_METHOD("CreateAccessMethod", SQLStatementType.DDL),
+
+ DO("DoStatement", SQLStatementType.DML);
private final String name;
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dml/MySQLDoStatement.java
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dml/MySQLDoStatement.java
index 4ed87ae440c..12d0f58e25f 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dml/MySQLDoStatement.java
+++
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dml/MySQLDoStatement.java
@@ -17,13 +17,24 @@
package org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dml;
+import lombok.AllArgsConstructor;
+import lombok.Getter;
+import lombok.NoArgsConstructor;
import lombok.ToString;
+import
org.apache.shardingsphere.sql.parser.sql.common.segment.dml.expr.ExpressionSegment;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.dml.DoStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.MySQLStatement;
+import java.util.List;
+
/**
* MySQL do statement.
*/
@ToString
+@AllArgsConstructor
+@NoArgsConstructor
+@Getter
public final class MySQLDoStatement extends DoStatement implements
MySQLStatement {
+
+ private List<ExpressionSegment> parameters;
}
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/asserts/statement/dml/DMLStatementAssert.java
b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/asserts/statement/dml/DMLStatementAssert.java
index 154e904653b..8ee94c5be31 100644
---
a/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/asserts/statement/dml/DMLStatementAssert.java
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/asserts/statement/dml/DMLStatementAssert.java
@@ -23,6 +23,7 @@ import
org.apache.shardingsphere.sql.parser.sql.common.statement.dml.CallStateme
import
org.apache.shardingsphere.sql.parser.sql.common.statement.dml.CopyStatement;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.dml.DMLStatement;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.dml.DeleteStatement;
+import
org.apache.shardingsphere.sql.parser.sql.common.statement.dml.DoStatement;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.dml.InsertStatement;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.dml.MergeStatement;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.dml.SelectStatement;
@@ -31,6 +32,7 @@ import
org.apache.shardingsphere.test.sql.parser.parameterized.asserts.SQLCaseAs
import
org.apache.shardingsphere.test.sql.parser.parameterized.asserts.statement.dml.impl.CallStatementAssert;
import
org.apache.shardingsphere.test.sql.parser.parameterized.asserts.statement.dml.impl.CopyStatementAssert;
import
org.apache.shardingsphere.test.sql.parser.parameterized.asserts.statement.dml.impl.DeleteStatementAssert;
+import
org.apache.shardingsphere.test.sql.parser.parameterized.asserts.statement.dml.impl.DoStatementAssert;
import
org.apache.shardingsphere.test.sql.parser.parameterized.asserts.statement.dml.impl.InsertStatementAssert;
import
org.apache.shardingsphere.test.sql.parser.parameterized.asserts.statement.dml.impl.MergeStatementAssert;
import
org.apache.shardingsphere.test.sql.parser.parameterized.asserts.statement.dml.impl.SelectStatementAssert;
@@ -39,6 +41,7 @@ import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dml.CallStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dml.CopyStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dml.DeleteStatementTestCase;
+import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dml.DoStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dml.InsertStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dml.MergeStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dml.SelectStatementTestCase;
@@ -72,6 +75,8 @@ public final class DMLStatementAssert {
CallStatementAssert.assertIs(assertContext, (CallStatement)
actual, (CallStatementTestCase) expected);
} else if (actual instanceof CopyStatement) {
CopyStatementAssert.assertIs(assertContext, (CopyStatement)
actual, (CopyStatementTestCase) expected);
+ } else if (actual instanceof DoStatement) {
+ DoStatementAssert.assertIs(assertContext, (DoStatement) actual,
(DoStatementTestCase) expected);
}
}
}
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/asserts/statement/dml/impl/DoStatementAssert.java
b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/asserts/statement/dml/impl/DoStatementAssert.java
new file mode 100644
index 00000000000..293cfec0b78
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/asserts/statement/dml/impl/DoStatementAssert.java
@@ -0,0 +1,72 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package
org.apache.shardingsphere.test.sql.parser.parameterized.asserts.statement.dml.impl;
+
+import lombok.AccessLevel;
+import lombok.NoArgsConstructor;
+import
org.apache.shardingsphere.sql.parser.sql.common.segment.dml.expr.ExpressionSegment;
+import
org.apache.shardingsphere.sql.parser.sql.common.segment.dml.expr.complex.CommonExpressionSegment;
+import
org.apache.shardingsphere.sql.parser.sql.common.segment.dml.expr.simple.LiteralExpressionSegment;
+import
org.apache.shardingsphere.sql.parser.sql.common.segment.dml.expr.simple.ParameterMarkerExpressionSegment;
+import
org.apache.shardingsphere.sql.parser.sql.common.statement.dml.DoStatement;
+import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dml.MySQLDoStatement;
+import
org.apache.shardingsphere.test.sql.parser.parameterized.asserts.SQLCaseAssertContext;
+import
org.apache.shardingsphere.test.sql.parser.parameterized.asserts.segment.expression.ExpressionAssert;
+import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.segment.impl.dostatement.ExpectedDoParameter;
+import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dml.DoStatementTestCase;
+
+import static org.hamcrest.CoreMatchers.is;
+import static org.junit.Assert.assertThat;
+
+/**
+ * Do statement assert.
+ */
+@NoArgsConstructor(access = AccessLevel.PRIVATE)
+public final class DoStatementAssert {
+
+ /**
+ * Assert do statement is correct with expected parser result.
+ *
+ * @param assertContext assert context
+ * @param actual actual do statement
+ * @param expected expected do statement test case
+ */
+ public static void assertIs(final SQLCaseAssertContext assertContext,
final DoStatement actual, final DoStatementTestCase expected) {
+ if (actual instanceof MySQLDoStatement) {
+ MySQLDoStatement actualStatement = (MySQLDoStatement) actual;
+ if (null != actualStatement.getParameters() && null !=
expected.getDoParameters()) {
+ assertThat(assertContext.getText("Do parameters assertion
error: "), actualStatement.getParameters().size(),
is(expected.getDoParameters().getParameters().size()));
+ int count = 0;
+ for (ExpressionSegment each : actualStatement.getParameters())
{
+ assertParameter(assertContext, each,
expected.getDoParameters().getParameters().get(count));
+ count++;
+ }
+ }
+ }
+ }
+
+ private static void assertParameter(final SQLCaseAssertContext
assertContext, final ExpressionSegment actual, final ExpectedDoParameter
expected) {
+ if (actual instanceof ParameterMarkerExpressionSegment) {
+ ExpressionAssert.assertParameterMarkerExpression(assertContext,
(ParameterMarkerExpressionSegment) actual,
expected.getParameterMarkerExpression());
+ } else if (actual instanceof LiteralExpressionSegment) {
+ ExpressionAssert.assertLiteralExpression(assertContext,
(LiteralExpressionSegment) actual, expected.getLiteralExpression());
+ } else if (actual instanceof CommonExpressionSegment) {
+ ExpressionAssert.assertCommonExpression(assertContext,
(CommonExpressionSegment) actual, expected.getCommonExpression());
+ }
+ }
+}
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/SQLParserTestCases.java
b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/SQLParserTestCases.java
index 386e9dc1f93..0747d3bb17f 100644
---
a/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/SQLParserTestCases.java
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/SQLParserTestCases.java
@@ -361,6 +361,7 @@ import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dml.CheckpointStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dml.CopyStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dml.DeleteStatementTestCase;
+import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dml.DoStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dml.InsertStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dml.MergeStatementTestCase;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dml.SelectStatementTestCase;
@@ -755,6 +756,9 @@ public final class SQLParserTestCases {
@XmlElement(name = "call")
private final List<CallStatementTestCase> callProcedureTestCases = new
LinkedList<>();
+ @XmlElement(name = "do")
+ private final List<DoStatementTestCase> doTestCases = new LinkedList<>();
+
@XmlElement(name = "copy")
private final List<CopyStatementTestCase> copyTestCases = new
LinkedList<>();
@@ -1575,6 +1579,7 @@ public final class SQLParserTestCases {
putAll(dropGroupTestCases, result);
putAll(dropDatabaseTestCases, result);
putAll(callProcedureTestCases, result);
+ putAll(doTestCases, result);
putAll(copyTestCases, result);
putAll(xaTestCases, result);
putAll(mergeTestCases, result);
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/segment/impl/dostatement/ExpectedDoParameter.java
b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/segment/impl/dostatement/ExpectedDoParameter.java
new file mode 100644
index 00000000000..9be6520a86e
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/segment/impl/dostatement/ExpectedDoParameter.java
@@ -0,0 +1,44 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.segment.impl.dostatement;
+
+import lombok.Getter;
+import lombok.Setter;
+import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.segment.AbstractExpectedSQLSegment;
+import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.segment.impl.expr.complex.ExpectedCommonExpression;
+import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.segment.impl.expr.simple.ExpectedLiteralExpression;
+import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.segment.impl.expr.simple.ExpectedParameterMarkerExpression;
+
+import javax.xml.bind.annotation.XmlElement;
+
+/**
+ * Expected do parameter.
+ */
+@Getter
+@Setter
+public final class ExpectedDoParameter extends AbstractExpectedSQLSegment {
+
+ @XmlElement(name = "parameter-marker-expression")
+ private ExpectedParameterMarkerExpression parameterMarkerExpression;
+
+ @XmlElement(name = "literal-expression")
+ private ExpectedLiteralExpression literalExpression;
+
+ @XmlElement(name = "common-expression")
+ private ExpectedCommonExpression commonExpression;
+}
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dml/MySQLDoStatement.java
b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/segment/impl/dostatement/ExpectedDoParameters.java
similarity index 57%
copy from
shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dml/MySQLDoStatement.java
copy to
shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/segment/impl/dostatement/ExpectedDoParameters.java
index 4ed87ae440c..5d26ccf248d 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dml/MySQLDoStatement.java
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/segment/impl/dostatement/ExpectedDoParameters.java
@@ -15,15 +15,23 @@
* limitations under the License.
*/
-package org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dml;
+package
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.segment.impl.dostatement;
-import lombok.ToString;
-import
org.apache.shardingsphere.sql.parser.sql.common.statement.dml.DoStatement;
-import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.MySQLStatement;
+import lombok.Getter;
+import lombok.Setter;
+import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.segment.AbstractExpectedSQLSegment;
+
+import javax.xml.bind.annotation.XmlElement;
+import java.util.LinkedList;
+import java.util.List;
/**
- * MySQL do statement.
+ * Expected do parameters.
*/
-@ToString
-public final class MySQLDoStatement extends DoStatement implements
MySQLStatement {
+@Getter
+@Setter
+public final class ExpectedDoParameters extends AbstractExpectedSQLSegment {
+
+ @XmlElement(name = "parameter")
+ private List<ExpectedDoParameter> parameters = new LinkedList<>();
}
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dml/MySQLDoStatement.java
b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/statement/dml/DoStatementTestCase.java
similarity index 56%
copy from
shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dml/MySQLDoStatement.java
copy to
shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/statement/dml/DoStatementTestCase.java
index 4ed87ae440c..aed32fbc50a 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dml/MySQLDoStatement.java
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/jaxb/cases/domain/statement/dml/DoStatementTestCase.java
@@ -15,15 +15,22 @@
* limitations under the License.
*/
-package org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dml;
+package
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dml;
-import lombok.ToString;
-import
org.apache.shardingsphere.sql.parser.sql.common.statement.dml.DoStatement;
-import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.MySQLStatement;
+import lombok.Getter;
+import lombok.Setter;
+import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.segment.impl.dostatement.ExpectedDoParameters;
+import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.SQLParserTestCase;
+
+import javax.xml.bind.annotation.XmlElement;
/**
- * MySQL do statement.
+ * Do statement test case.
*/
-@ToString
-public final class MySQLDoStatement extends DoStatement implements
MySQLStatement {
+@Getter
+@Setter
+public final class DoStatementTestCase extends SQLParserTestCase {
+
+ @XmlElement(name = "parameters")
+ private ExpectedDoParameters doParameters;
}
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/dml/do.xml
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/dml/do.xml
new file mode 100644
index 00000000000..a3d9ac06728
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/dml/do.xml
@@ -0,0 +1,78 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<sql-parser-test-cases>
+ <do sql-case-id="do_constant">
+ <parameters>
+ <parameter>
+ <literal-expression value="1" start-index="3" stop-index="3"/>
+ </parameter>
+ </parameters>
+ </do>
+
+ <do sql-case-id="do_sleep">
+ <parameters>
+ <parameter>
+ <literal-expression value="SLEEP(1)" start-index="3"
stop-index="10"/>
+ </parameter>
+ </parameters>
+ </do>
+
+ <do sql-case-id="do_multiple_sleep">
+ <parameters>
+ <parameter>
+ <literal-expression value="SLEEP(1)" start-index="3"
stop-index="10"/>
+ </parameter>
+ <parameter>
+ <literal-expression value="SLEEP(2)" start-index="13"
stop-index="20"/>
+ </parameter>
+ </parameters>
+ </do>
+
+ <do sql-case-id="do_with_function_1">
+ <parameters>
+ <parameter>
+ <literal-expression
value="FROM_BASE64(CAST((MID(UUID(),20,64)) AS BINARY(55)))" start-index="3"
stop-index="54"/>
+ </parameter>
+ </parameters>
+ </do>
+
+ <do sql-case-id="do_with_function_2">
+ <parameters>
+ <parameter>
+ <literal-expression value="FROM_BASE64(CAST(RIGHT(11,1)AS
BINARY(24)))" start-index="3" stop-index="45"/>
+ </parameter>
+ </parameters>
+ </do>
+
+ <do sql-case-id="do_with_function_3">
+ <parameters>
+ <parameter>
+ <literal-expression value="COUNT(DISTINCT ROUND(CAST(SLEEP(0)
AS DECIMAL), NULL))" start-index="3" stop-index="56"/>
+ </parameter>
+ </parameters>
+ </do>
+
+ <do sql-case-id="do_with_crc32_function">
+ <parameters>
+ <parameter>
+ <literal-expression value="CRC32(CHAR(1.134475E+308))"
start-index="3" stop-index="28"/>
+ </parameter>
+ </parameters>
+ </do>
+</sql-parser-test-cases>
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/dml/do.xml
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/dml/do.xml
new file mode 100644
index 00000000000..a1148208e00
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/dml/do.xml
@@ -0,0 +1,27 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ ~ Licensed to the Apache Software Foundation (ASF) under one or more
+ ~ contributor license agreements. See the NOTICE file distributed with
+ ~ this work for additional information regarding copyright ownership.
+ ~ The ASF licenses this file to You under the Apache License, Version 2.0
+ ~ (the "License"); you may not use this file except in compliance with
+ ~ the License. You may obtain a copy of the License at
+ ~
+ ~ http://www.apache.org/licenses/LICENSE-2.0
+ ~
+ ~ Unless required by applicable law or agreed to in writing, software
+ ~ distributed under the License is distributed on an "AS IS" BASIS,
+ ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ ~ See the License for the specific language governing permissions and
+ ~ limitations under the License.
+ -->
+
+<sql-cases>
+ <sql-case id="do_constant" value="DO 1" db-types="MySQL" />
+ <sql-case id="do_sleep" value="DO SLEEP(1)" db-types="MySQL" />
+ <sql-case id="do_multiple_sleep" value="DO SLEEP(1), SLEEP(2)"
db-types="MySQL" />
+ <sql-case id="do_with_function_1" value="DO
FROM_BASE64(CAST((MID(UUID(),20,64)) AS BINARY(55)))" db-types="MySQL" />
+ <sql-case id="do_with_function_2" value="DO FROM_BASE64(CAST(RIGHT(11,1)AS
BINARY(24)))" db-types="MySQL" />
+ <sql-case id="do_with_function_3" value="DO COUNT(DISTINCT
ROUND(CAST(SLEEP(0) AS DECIMAL), NULL))" db-types="MySQL" />
+ <sql-case id="do_with_crc32_function" value="DO
CRC32(CHAR(1.134475E+308))" db-types="MySQL" />
+</sql-cases>
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/unsupported/unsupported.xml
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/unsupported/unsupported.xml
index cb1b1d6fde8..2bb06a73fd3 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
@@ -2270,485 +2270,6 @@
<sql-case id="check_by_mysql_source_test_case2" value="CHECK TABLES t1"
db-types="MySQL" />
<sql-case id="close_by_mysql_source_test_case1" value="CLOSE cur1"
db-types="MySQL" />
<sql-case id="declare_by_mysql_source_test_case1" value="DECLARE cur1
CURSOR FOR SHOW TABLES" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case1" value="DO
STR_TO_DATE((''), FROM_DAYS(@@GLOBAL.SQL_MODE))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case2" value="DO '1'
regexp repeat('$', 50000000)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case3" value="DO ( ('')
rlike (cot ( ' %' )) )" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case4" value="DO ( ('- ')
regexp (cot ( right (':#.', 33) )) )" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case5" value="DO ( (( @f )) rlike
(json_depth ( 'key4' )) )" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case6" value="DO ( (-28277) regexp
(period_add ( -10966, 1381205734 )) )" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case7" value="DO ( (1) regexp (exp (
64826 )) )" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case8" value="DO ( (25091) rlike
(exp ( 14373 )) )" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case9" value="DO ( (@b) regexp (cot
(unhex ( 1 )) ) )" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case10" value="DO ( (@b) regexp (exp
( 0x1fc5574c )) )" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case11" value="DO ( (@c) rlike (cot
( (!( @f )) )) )" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case12" value="DO ( (@g) regexp (cot
( @f )) )" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case13" value="DO
(!(SECOND(0xb16beeb7)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case14" value="DO
(((NOT(1)))^(HOUR(MONTHNAME(LEAD(DATABASE(),89)OVER()))))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case15" value="DO ((@c :=
(_utf32' -'))) SOUNDS LIKE(@c)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case16" value="DO
((CAST((LEAD(NULL,152) OVER()) AS TIME))*(1))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case17" value="DO
((CONVERT((VARIANCE(-18951))USING CP866)) <=
(JSON_ARRAY(LEAD(CAST((35184372088833)AS DATETIME),126)OVER())))"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case18" value="DO
((JSON_TYPE('4:8')) AND (((ROLES_GRAPHML()) LIKE (FIRST_VALUE(31543)
RESPECT NULLS OVER()))))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case19" value="DO
((LAG(LAST_DAY("]<$*_#[DB!^+ : 3"),89) OVER (RANGE UNBOUNDED
PRECEDING)) > (CONVERT(("1985-10-19 03:36:29.304455" -
INTERVAL(0x1446C5A2627FB06D88DC63D66B36DF) DAY_MICROSECOND) USING BIG5)))"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case20" value="DO (SELECT @x:= b
FROM t1 WHERE a = 5 or a = 1 ORDER BY b LIMIT 1)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case21" value="DO (SELECT @x:= b
FROM t1 WHERE a = 5)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case22" value="DO (SELECT COUNT(*)
FROM t1)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case23" value="DO (SELECT DISTINCT
SQL_BIG_RESULT ST_SIMPLIFY(POINT(a,1),1) FROM t)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case24" value="DO (SELECT
ST_ASBINARY(r.p) FROM d INNER JOIN dp ON d.id = dp.d_id INNER JOIN r ON d.r_id
= r.id ORDER BY d.i)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case25" value="DO (SELECT a FROM
t1)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case26" value="DO
(~(SUM(@f)OVER()))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case27" value="DO 1 regexp
(multilinestring(point(1,1)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case28" value="DO 1 rlike
multilinestring(point(1, 1))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case29" value="DO AVG((SELECT
POINT(@x, POINT(115, 219)) IS NULL))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case30" value="DO AVG((SELECT
POINT(@x, POINT(115, 219)) IS NULL)) OVER ()" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case31" value="DO
BIT_LENGTH(AVG(@f)OVER())" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case32" value="DO
CAST((LAG(-16520,156) OVER()) AS TIME)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case33" value="DO CAST((LAG(POLYGON(
LINESTRING( POINT(4099,17421), POINT(22259,-5875.0796), POINT(30179,6542),
POINT(12331,-18840)), LINESTRING( POINT( 8162.2539,-29332),
POINT(24157,-23393), POINT(268435459,-26835), POINT(3.933871E+307,-25808)),
LINESTRING( POINT(30360,-1049), POINT(15405,5.816757E+307), POINT(
3717.3555,1.599730E+308), POINT(-23002,-19077))), 70) OVER()) AS DATETIME )"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case34" value="DO
CAST((LAG(SHA(STDDEV('-0E%_')),224) OVER()) AS TIME)"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case35" value="DO CAST((LAG(_UJIS
'8CA} ',144) OVER()) AS TIME)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case36" value="DO
CAST((LEAD(-197994311,60)OVER())AS DATETIME)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case37" value="DO
CAST((LEAD(-6011,202) OVER()) AS TIME)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case38" value="DO
CAST((LEAD(0x45,104) OVER())AS TIME)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case39" value="DO
COMPRESS(SUM(' >')OVER())" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case40" value="DO CONCAT_WS(
JSON_OBJECTAGG( ROW_COUNT(), BIT_COUNT(-23163)), DEGREES((1.595545e+308)),
REPEAT(FIRST_VALUE('%0') OVER(), 30))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case41" value="DO CONVERT( NULLIF(
@a , 'c' ) USING BINARY)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case42" value="DO COUNT(DISTINCT
ROUND(CAST(SLEEP(0) AS DECIMAL), NULL))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case43" value="DO
DATEDIFF(UUID_TO_BIN(UUID()), 0x32df2ce8)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case44" value="DO
DAYOFYEAR(((MBRDISJOINT(0xbc,1))OR(WEEK(SEC_TO_TIME(419824656)))))"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case45" value="DO
DAYOFYEAR(LAG('] .| /= ',63) OVER())" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case46" value="DO
DAYOFYEAR(LEAD(-6653420797178186265 ,29)OVER())" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case47" value="DO
DAYOFYEAR(LEAD(ROW_COUNT(),177)OVER())" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case48" value="DO
DAYOFYEAR(MAKETIME('1981-06-27 11:16:09.211343',
(((NOT(ST_DISTANCE_SPHERE(POINT(4472,28027),
POINT(28061,-9007199254740996),-644021130))))<=>(@c)),(1)))"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case49" value="DO
DAYOFYEAR(MAKETIME(((0x965a)^((@g :=(1 IS NULL)))),
EXP(39988664861.65638662152600787509), ((STD(@f))LIKE(1))))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case50" value="DO
DAYOFYEAR(MAKETIME(ROUND(-23797,'6588-01-08'),
COERCIBILITY(BIT_COUNT(RTRIM((~( INET6_NTOA(0xa04810f0839d318fa075bd)))))),
((ST_ASWKT(1))OR(1))))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case51" value="DO
DAYOFYEAR(SEC_TO_TIME((~(((RELEASE_ALL_LOCKS())-((1)))))))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case52" value="DO
DAYOFYEAR(SEC_TO_TIME(OCT(BIT_AND(JSON_REPLACE((23533),'key3',NULL)))))"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case53" value="DO
GREATEST(RIGHT(@a,1),1)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case54" value="DO
GROUP_CONCAT(DISTINCT NULLIF(1, PERIOD_ADD(0x6f09c5f8
,'7451-01-27')))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case55" value="DO
GROUP_CONCAT(NULLIF(ELT(1, @e), POINT(250,41)) ORDER BY 1)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case56" value="DO
IFNULL((DAYNAME(LEAD(STDDEV(@F),162) OVER())),(0xD73E))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case57" value="DO IFNULL((NULL
),(UNIX_TIMESTAMP(LEAD(NULL,12)RESPECT NULLS OVER())))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case58" value="DO INSERT(1, 1, 1,
CAST(1 AS DECIMAL(1,3)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case59" value="DO
INSERT(regexp_instr(1, '['), 0, 1, '')" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case60" value="DO
INSERT(regexp_like(1, '['), 0, 1, '')" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case61" value="DO
INSERT(regexp_replace(1, '[', 42), 0, 1, '')"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case62" value="DO
IS_IPV4(TIMESTAMP(LAG(-19131 ,188) OVER(),@F))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case63" value="DO
IS_UUID(SUM(@e)OVER())" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case64" value="DO LAG(1,
18446744073709551615) OVER()" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case65" value="DO LAG(1,
9223372036854775807) OVER()" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case66" value="DO LAG(1, @v) OVER()"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case67" value="DO LAG(1, @v) OVER()"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case68" value="DO LAG(1, @v) OVER()"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case69" value="DO LAG(1, @v) OVER()"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case70" value="DO LAG(1, @v) OVER(),
@v:=20" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case71" value="DO
LAST_DAY(LAG('*',36)RESPECT NULLS OVER())" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case72" value="DO
LAST_DAY(LAG(NULL,113) OVER())" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case73" value="DO LAST_DAY(LEAD(
_CP932 '',241)OVER(RANGE UNBOUNDED PRECEDING))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case74" value="DO
LAST_DAY(LEAD(-2201 ,98)RESPECT NULLS OVER())" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case75" value="DO
LAST_DAY(SQRT(CAST((LAG(REPEAT('B',64),91)OVER())AS DATETIME)))"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case76" value="DO LEAD(1,
18446744073709551615) OVER()" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case77" value="DO LEAD(1,
9223372036854775807) OVER()" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case78" value="DO LEAD(1, @v)
OVER()" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case79" value="DO LEAD(1, @v)
OVER()" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case80" value="DO LEAD(1, @v)
OVER()" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case81" value="DO LEAD(1, @v)
OVER()" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case82" value="DO LEAD(1, @v)
OVER(), @v:=20" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case83" value="DO
LEAST(RIGHT(@a,1),1)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case84" value="DO
LTRIM(AVG(LOG2(@c))OVER())" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case85" value="DO MBRContains(1,
if(0, coalesce(NULL), now()))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case86" value="DO
MBRWITHIN(@centroid_point,
ST_INTERSECTION(ST_GEOMFROMTEXT('MULTILINESTRING((541 -927,-414 316,-429
-444,212 260,-125 104,445 563,-713 -975,-976 514),(-830 882,-377 914,-915
919,-535 -23,-508 979),(806 347,-87 220,226 -22,-12 468,707 598,83 951,-592
701,833 964,270 -932,743 -514,231 469,-575 -122,-99 -245,416 465,801
-587))'), ST_GEOMFROMTEXT('LINESTRING(-96 -182,-373 75,697 687,-881
-463,-557 -959,-493 810)' [...]
- <sql-case id="do_by_mysql_source_test_case87" value="DO
MBRWITHIN(@centroid_point,
ST_INTERSECTION(ST_GEOMFROMTEXT('MULTILINESTRING((541 -927,-414 316,-429
-444,212 260,-125 104,445 563,-713 -975,-976 514),(-830 882,-377 914,-915
919,-535 -23,-508 979),(806 347,-87 220,226 -22,-12 468,707 598,83 951,-592
701,833 964,270 -932,743 -514,231 469,-575 -122,-99 -245,416 465,801
-587))'), ST_GEOMFROMTEXT('LINESTRING(-96 -182,-373 75,697 687,-881
-463,-557 -959,-493 810)' [...]
- <sql-case id="do_by_mysql_source_test_case88" value="DO
MONTHNAME(LAG(' =',74) OVER())" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case89" value="DO
MONTHNAME(LEAD(CHARSET(CONVERT((MOD(CURTIME(4),STDDEV(NULL)))USING CP850)),12)
OVER())" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case90" value="DO NOT CAST(UTC_TIME
AS CHAR(2877246026) CHARACTER SET ujis)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case91" value="DO
NTILE(18446744073709551615) OVER()" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case92" value="DO
NTILE(9223372036854775807) OVER()" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case93" value="DO NTILE(@undefined)
OVER()" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case94" value="DO NTILE(@v) OVER()"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case95" value="DO NTILE(@v) OVER()"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case96" value="DO NTILE(@v) OVER()"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case97" value="DO NTILE(@v) OVER()"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case98" value="DO NTILE(@v) OVER(),
@v:=20" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case99" value="DO
NULLIF((GREATEST(FROM_UNIXTIME(1537024679) , _utf32 "*b!" )),
(FROM_UNIXTIME(1537013301) ) )" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case100" value="DO
NULLIF(CAST(DATABASE() AS DATE), 1)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case101" value="DO
NULLIF(CAST(DATABASE() AS DATETIME), 1)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case102" value="DO
NULLIF(CAST(DATABASE() AS TIME), 1)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case103" value="DO
OCT(-9223372036854775808)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case104" value="DO
OCTET_LENGTH(((LAST_DAY(LEAD(-28178,163)OVER()))OR(COLLATION(@E))))"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case105" value="DO
POW(-8714,REPEAT('1',32)) OR VALIDATE_PASSWORD_STRENGTH(LAST_VALUE(1)
OVER())" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case106" value="DO
REPEAT(LAST_INSERT_ID(''), 0x96e4ed7e70a7fec7f11572c8980a)"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case107" value="DO
REPEAT(LAST_INSERT_ID(''), 4294967295)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case108" value="DO REPLACE(((
RELEASE_LOCK( ACOS(0x41))) OR (1)), LAST_VALUE(9.750062e+306) RESPECT NULLS
OVER(), UUID_SHORT())" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case109" value="DO REPLACE(CONVERT(1
USING utf32),BIT_XOR(1),SHA1(@d))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case110" value="DO ROUND(0xe9b1,
NULL)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case111" value="DO
SHA(BIN(MONTHNAME(LEAD(UNCOMPRESSED_LENGTH(SHA1("")),224)OVER())))"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case112" value="DO
ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((4 -10,-3
0,-5 6,9 9,5 7,9 -6,9 -10,7 9,0 -4,-6 10,0 -3,9 3, 4 -10)),
GEOMETRYCOLLECTION(), GEOMETRYCOLLECTION(MULTIPOLYGON(((-8 0,-2 -6,-10 -9,-9
7,-2 -10,7 -9,3 -6,-5 -8,-10 -7,-6 10,4 -10,-7 -8,6 -1, -8 0)),((-4 -3,7 -10,-4
-1,-10 -3,3 -3,-10 -4,-1 2,-2 -10,6 -7,-9 -8, -4 -3))), POINT(5 0),
MULTIPOINT(-3 0,-4 -8,-3 -4,10 4,0 7,-7 2,4 -8,1 -6), MULTILINESTRIN [...]
- <sql-case id="do_by_mysql_source_test_case113" value="DO
ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT('POLYGON((525000 183300,525400
183300,525400 18370, 525000 183700,525000 183300))'),
ST_GeomFromText('POLYGON((525298.67 183511.53,525296.57
183510.39,525296.42 183510.31,525289.11 183506.62,525283.17 183503.47,525280.98
183502.26,525278.63 183500.97,525278.39 183500.84,525276.79 183500,525260.7
183491.55,525263.95 183484.75,525265.58 183481.95,525278.97 183488.73,525276.5
18349 [...]
- <sql-case id="do_by_mysql_source_test_case114" value="DO
ST_ASTEXT(ST_UNION(ST_INTERSECTION(ST_GEOMFROMTEXT('MULTIPOINT(7 2,-4 -5,6
-9,-7 3,-10 5,8 -6,0 -10,10 -4,8 -10,2 6,8 -4,-8 2,-4 2)'),
ST_GEOMFROMTEXT('MULTIPOLYGON(((6 2,1 1,-4 5,1 4,-3 -4,-7 9,-10 2,-6 1,10
-7,0 1,9 4, 6 2)))')), ST_UNION(ST_GEOMFROMTEXT('LINESTRING(-1 -5,0
-6,4 6,3 3,2 8,-2 6,-4 5,6 -7,-1 -1,-8 6,4 -2)'),
ST_GEOMFROMTEXT('MULTIPOLYGON(((5 -4,-5 -9,-1 -6,-3 0,5 -2, 5 -4)),(( [...]
- <sql-case id="do_by_mysql_source_test_case115" value="DO
ST_ASWKB(JSON_UNQUOTE(JSON_SET('{"a":""}',
'$', '')))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case116" value="DO
ST_AsText(@centroid_point) as centroid" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case117" value="DO
ST_AsText(@centroid_point) as centroid" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case118" value="DO
ST_CROSSES(@g,SUM(SHA(@g))OVER())" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case119" value="DO
ST_EXTERIORRING(x'000000000107000000010000000101000000000000000000')"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case120" value="DO
ST_EXTERIORRING(x'000000000107000000010000000102000000000000000000')"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case121" value="DO
ST_EXTERIORRING(x'000000000107000000010000000103000000000000000000')"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case122" value="DO
ST_EXTERIORRING(x'00000000010700000001000000010400000001000000')"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case123" value="DO
ST_EXTERIORRING(x'00000000010700000001000000010500000001000000')"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case124" value="DO
ST_EXTERIORRING(x'00000000010700000001000000010600000001000000')"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case125" value="DO
ST_GEOMCOLLFROMTEXT(@wkt_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case126" value="DO
ST_GEOMCOLLFROMTEXT(@wkt_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case127" value="DO
ST_GEOMCOLLFROMTEXT(@wkt_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case128" value="DO
ST_GEOMCOLLFROMTEXT(@wkt_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case129" value="DO
ST_GEOMCOLLFROMTEXT(@wkt_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case130" value="DO
ST_GEOMCOLLFROMTEXT(@wkt_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case131" value="DO
ST_GEOMCOLLFROMTEXT(@wkt_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case132" value="DO
ST_GEOMCOLLFROMTXT(@wkt_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case133" value="DO
ST_GEOMCOLLFROMTXT(@wkt_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case134" value="DO
ST_GEOMCOLLFROMTXT(@wkt_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case135" value="DO
ST_GEOMCOLLFROMTXT(@wkt_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case136" value="DO
ST_GEOMCOLLFROMTXT(@wkt_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case137" value="DO
ST_GEOMCOLLFROMTXT(@wkt_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case138" value="DO
ST_GEOMCOLLFROMTXT(@wkt_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case139" value="DO
ST_GEOMCOLLFROMWKB(@wkb_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case140" value="DO
ST_GEOMCOLLFROMWKB(@wkb_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case141" value="DO
ST_GEOMCOLLFROMWKB(@wkb_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case142" value="DO
ST_GEOMCOLLFROMWKB(@wkb_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case143" value="DO
ST_GEOMCOLLFROMWKB(@wkb_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case144" value="DO
ST_GEOMCOLLFROMWKB(@wkb_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case145" value="DO
ST_GEOMCOLLFROMWKB(@wkb_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case146" value="DO
ST_GEOMCOLLFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_gc)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case147" value="DO
ST_GEOMCOLLFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_ls)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case148" value="DO
ST_GEOMCOLLFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mls)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case149" value="DO
ST_GEOMCOLLFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpt)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case150" value="DO
ST_GEOMCOLLFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpy)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case151" value="DO
ST_GEOMCOLLFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_pt)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case152" value="DO
ST_GEOMCOLLFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_py)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case153" value="DO
ST_GEOMETRYCOLLECTIONFROMTEXT(@wkt_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case154" value="DO
ST_GEOMETRYCOLLECTIONFROMTEXT(@wkt_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case155" value="DO
ST_GEOMETRYCOLLECTIONFROMTEXT(@wkt_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case156" value="DO
ST_GEOMETRYCOLLECTIONFROMTEXT(@wkt_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case157" value="DO
ST_GEOMETRYCOLLECTIONFROMTEXT(@wkt_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case158" value="DO
ST_GEOMETRYCOLLECTIONFROMTEXT(@wkt_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case159" value="DO
ST_GEOMETRYCOLLECTIONFROMTEXT(@wkt_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case160" value="DO
ST_GEOMETRYCOLLECTIONFROMWKB(@wkb_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case161" value="DO
ST_GEOMETRYCOLLECTIONFROMWKB(@wkb_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case162" value="DO
ST_GEOMETRYCOLLECTIONFROMWKB(@wkb_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case163" value="DO
ST_GEOMETRYCOLLECTIONFROMWKB(@wkb_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case164" value="DO
ST_GEOMETRYCOLLECTIONFROMWKB(@wkb_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case165" value="DO
ST_GEOMETRYCOLLECTIONFROMWKB(@wkb_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case166" value="DO
ST_GEOMETRYCOLLECTIONFROMWKB(@wkb_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case167" value="DO
ST_GEOMETRYCOLLECTIONFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_gc)))"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case168" value="DO
ST_GEOMETRYCOLLECTIONFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_ls)))"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case169" value="DO
ST_GEOMETRYCOLLECTIONFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mls)))"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case170" value="DO
ST_GEOMETRYCOLLECTIONFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpt)))"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case171" value="DO
ST_GEOMETRYCOLLECTIONFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpy)))"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case172" value="DO
ST_GEOMETRYCOLLECTIONFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_pt)))"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case173" value="DO
ST_GEOMETRYCOLLECTIONFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_py)))"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case174" value="DO
ST_GEOMETRYFROMTEXT(@wkt_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case175" value="DO
ST_GEOMETRYFROMTEXT(@wkt_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case176" value="DO
ST_GEOMETRYFROMTEXT(@wkt_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case177" value="DO
ST_GEOMETRYFROMTEXT(@wkt_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case178" value="DO
ST_GEOMETRYFROMTEXT(@wkt_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case179" value="DO
ST_GEOMETRYFROMTEXT(@wkt_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case180" value="DO
ST_GEOMETRYFROMTEXT(@wkt_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case181" value="DO
ST_GEOMETRYFROMWKB(@wkb_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case182" value="DO
ST_GEOMETRYFROMWKB(@wkb_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case183" value="DO
ST_GEOMETRYFROMWKB(@wkb_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case184" value="DO
ST_GEOMETRYFROMWKB(@wkb_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case185" value="DO
ST_GEOMETRYFROMWKB(@wkb_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case186" value="DO
ST_GEOMETRYFROMWKB(@wkb_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case187" value="DO
ST_GEOMETRYFROMWKB(@wkb_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case188" value="DO
ST_GEOMETRYFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_gc)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case189" value="DO
ST_GEOMETRYFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_ls)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case190" value="DO
ST_GEOMETRYFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mls)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case191" value="DO
ST_GEOMETRYFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpt)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case192" value="DO
ST_GEOMETRYFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpy)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case193" value="DO
ST_GEOMETRYFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_pt)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case194" value="DO
ST_GEOMETRYFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_py)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case195" value="DO
ST_GEOMFROMTEXT('GEOMCOLLECTION(POINT(0 0))')" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case196" value="DO
ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0))')" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case197" value="DO
ST_GEOMFROMTEXT(@wkt_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case198" value="DO
ST_GEOMFROMTEXT(@wkt_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case199" value="DO
ST_GEOMFROMTEXT(@wkt_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case200" value="DO
ST_GEOMFROMTEXT(@wkt_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case201" value="DO
ST_GEOMFROMTEXT(@wkt_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case202" value="DO
ST_GEOMFROMTEXT(@wkt_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case203" value="DO
ST_GEOMFROMTEXT(@wkt_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case204" value="DO
ST_GEOMFROMWKB(@wkb_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case205" value="DO
ST_GEOMFROMWKB(@wkb_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case206" value="DO
ST_GEOMFROMWKB(@wkb_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case207" value="DO
ST_GEOMFROMWKB(@wkb_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case208" value="DO
ST_GEOMFROMWKB(@wkb_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case209" value="DO
ST_GEOMFROMWKB(@wkb_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case210" value="DO
ST_GEOMFROMWKB(@wkb_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case211" value="DO
ST_GEOMFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_gc)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case212" value="DO
ST_GEOMFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_ls)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case213" value="DO
ST_GEOMFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mls)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case214" value="DO
ST_GEOMFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpt)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case215" value="DO
ST_GEOMFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpy)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case216" value="DO
ST_GEOMFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_pt)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case217" value="DO
ST_GEOMFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_py)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case218" value="DO
ST_ISVALID(INSTR(9223372036854775806 ,0x46bc299f))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case219" value="DO
ST_LINEFROMTEXT(@wkt_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case220" value="DO
ST_LINEFROMTEXT(@wkt_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case221" value="DO
ST_LINEFROMTEXT(@wkt_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case222" value="DO
ST_LINEFROMTEXT(@wkt_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case223" value="DO
ST_LINEFROMTEXT(@wkt_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case224" value="DO
ST_LINEFROMTEXT(@wkt_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case225" value="DO
ST_LINEFROMTEXT(@wkt_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case226" value="DO
ST_LINEFROMWKB(@wkb_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case227" value="DO
ST_LINEFROMWKB(@wkb_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case228" value="DO
ST_LINEFROMWKB(@wkb_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case229" value="DO
ST_LINEFROMWKB(@wkb_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case230" value="DO
ST_LINEFROMWKB(@wkb_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case231" value="DO
ST_LINEFROMWKB(@wkb_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case232" value="DO
ST_LINEFROMWKB(@wkb_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case233" value="DO
ST_LINEFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_gc)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case234" value="DO
ST_LINEFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_ls)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case235" value="DO
ST_LINEFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mls)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case236" value="DO
ST_LINEFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpt)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case237" value="DO
ST_LINEFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpy)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case238" value="DO
ST_LINEFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_pt)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case239" value="DO
ST_LINEFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_py)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case240" value="DO
ST_LINESTRINGFROMTEXT(@wkt_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case241" value="DO
ST_LINESTRINGFROMTEXT(@wkt_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case242" value="DO
ST_LINESTRINGFROMTEXT(@wkt_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case243" value="DO
ST_LINESTRINGFROMTEXT(@wkt_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case244" value="DO
ST_LINESTRINGFROMTEXT(@wkt_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case245" value="DO
ST_LINESTRINGFROMTEXT(@wkt_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case246" value="DO
ST_LINESTRINGFROMTEXT(@wkt_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case247" value="DO
ST_LINESTRINGFROMWKB(@wkb_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case248" value="DO
ST_LINESTRINGFROMWKB(@wkb_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case249" value="DO
ST_LINESTRINGFROMWKB(@wkb_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case250" value="DO
ST_LINESTRINGFROMWKB(@wkb_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case251" value="DO
ST_LINESTRINGFROMWKB(@wkb_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case252" value="DO
ST_LINESTRINGFROMWKB(@wkb_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case253" value="DO
ST_LINESTRINGFROMWKB(@wkb_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case254" value="DO
ST_LINESTRINGFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_gc)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case255" value="DO
ST_LINESTRINGFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_ls)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case256" value="DO
ST_LINESTRINGFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mls)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case257" value="DO
ST_LINESTRINGFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpt)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case258" value="DO
ST_LINESTRINGFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpy)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case259" value="DO
ST_LINESTRINGFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_pt)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case260" value="DO
ST_LINESTRINGFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_py)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case261" value="DO
ST_MLINEFROMTEXT(@wkt_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case262" value="DO
ST_MLINEFROMTEXT(@wkt_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case263" value="DO
ST_MLINEFROMTEXT(@wkt_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case264" value="DO
ST_MLINEFROMTEXT(@wkt_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case265" value="DO
ST_MLINEFROMTEXT(@wkt_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case266" value="DO
ST_MLINEFROMTEXT(@wkt_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case267" value="DO
ST_MLINEFROMTEXT(@wkt_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case268" value="DO
ST_MLINEFROMWKB(@wkb_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case269" value="DO
ST_MLINEFROMWKB(@wkb_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case270" value="DO
ST_MLINEFROMWKB(@wkb_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case271" value="DO
ST_MLINEFROMWKB(@wkb_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case272" value="DO
ST_MLINEFROMWKB(@wkb_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case273" value="DO
ST_MLINEFROMWKB(@wkb_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case274" value="DO
ST_MLINEFROMWKB(@wkb_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case275" value="DO
ST_MLINEFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_gc)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case276" value="DO
ST_MLINEFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_ls)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case277" value="DO
ST_MLINEFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mls)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case278" value="DO
ST_MLINEFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpt)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case279" value="DO
ST_MLINEFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpy)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case280" value="DO
ST_MLINEFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_pt)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case281" value="DO
ST_MLINEFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_py)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case282" value="DO
ST_MPOINTFROMTEXT(@wkt_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case283" value="DO
ST_MPOINTFROMTEXT(@wkt_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case284" value="DO
ST_MPOINTFROMTEXT(@wkt_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case285" value="DO
ST_MPOINTFROMTEXT(@wkt_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case286" value="DO
ST_MPOINTFROMTEXT(@wkt_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case287" value="DO
ST_MPOINTFROMTEXT(@wkt_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case288" value="DO
ST_MPOINTFROMTEXT(@wkt_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case289" value="DO
ST_MPOINTFROMWKB(@wkb_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case290" value="DO
ST_MPOINTFROMWKB(@wkb_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case291" value="DO
ST_MPOINTFROMWKB(@wkb_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case292" value="DO
ST_MPOINTFROMWKB(@wkb_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case293" value="DO
ST_MPOINTFROMWKB(@wkb_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case294" value="DO
ST_MPOINTFROMWKB(@wkb_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case295" value="DO
ST_MPOINTFROMWKB(@wkb_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case296" value="DO
ST_MPOINTFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_gc)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case297" value="DO
ST_MPOINTFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_ls)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case298" value="DO
ST_MPOINTFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mls)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case299" value="DO
ST_MPOINTFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpt)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case300" value="DO
ST_MPOINTFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpy)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case301" value="DO
ST_MPOINTFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_pt)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case302" value="DO
ST_MPOINTFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_py)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case303" value="DO
ST_MPOLYFROMTEXT(@wkt_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case304" value="DO
ST_MPOLYFROMTEXT(@wkt_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case305" value="DO
ST_MPOLYFROMTEXT(@wkt_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case306" value="DO
ST_MPOLYFROMTEXT(@wkt_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case307" value="DO
ST_MPOLYFROMTEXT(@wkt_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case308" value="DO
ST_MPOLYFROMTEXT(@wkt_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case309" value="DO
ST_MPOLYFROMTEXT(@wkt_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case310" value="DO
ST_MPOLYFROMWKB(@wkb_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case311" value="DO
ST_MPOLYFROMWKB(@wkb_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case312" value="DO
ST_MPOLYFROMWKB(@wkb_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case313" value="DO
ST_MPOLYFROMWKB(@wkb_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case314" value="DO
ST_MPOLYFROMWKB(@wkb_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case315" value="DO
ST_MPOLYFROMWKB(@wkb_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case316" value="DO
ST_MPOLYFROMWKB(@wkb_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case317" value="DO
ST_MPOLYFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_gc)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case318" value="DO
ST_MPOLYFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_ls)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case319" value="DO
ST_MPOLYFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mls)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case320" value="DO
ST_MPOLYFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpt)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case321" value="DO
ST_MPOLYFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpy)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case322" value="DO
ST_MPOLYFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_pt)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case323" value="DO
ST_MPOLYFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_py)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case324" value="DO
ST_MULTILINESTRINGFROMTEXT(@wkt_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case325" value="DO
ST_MULTILINESTRINGFROMTEXT(@wkt_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case326" value="DO
ST_MULTILINESTRINGFROMTEXT(@wkt_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case327" value="DO
ST_MULTILINESTRINGFROMTEXT(@wkt_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case328" value="DO
ST_MULTILINESTRINGFROMTEXT(@wkt_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case329" value="DO
ST_MULTILINESTRINGFROMTEXT(@wkt_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case330" value="DO
ST_MULTILINESTRINGFROMTEXT(@wkt_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case331" value="DO
ST_MULTILINESTRINGFROMWKB(@wkb_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case332" value="DO
ST_MULTILINESTRINGFROMWKB(@wkb_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case333" value="DO
ST_MULTILINESTRINGFROMWKB(@wkb_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case334" value="DO
ST_MULTILINESTRINGFROMWKB(@wkb_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case335" value="DO
ST_MULTILINESTRINGFROMWKB(@wkb_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case336" value="DO
ST_MULTILINESTRINGFROMWKB(@wkb_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case337" value="DO
ST_MULTILINESTRINGFROMWKB(@wkb_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case338" value="DO
ST_MULTILINESTRINGFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_gc)))" db-types="MySQL"
/>
- <sql-case id="do_by_mysql_source_test_case339" value="DO
ST_MULTILINESTRINGFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_ls)))" db-types="MySQL"
/>
- <sql-case id="do_by_mysql_source_test_case340" value="DO
ST_MULTILINESTRINGFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mls)))"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case341" value="DO
ST_MULTILINESTRINGFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpt)))"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case342" value="DO
ST_MULTILINESTRINGFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpy)))"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case343" value="DO
ST_MULTILINESTRINGFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_pt)))" db-types="MySQL"
/>
- <sql-case id="do_by_mysql_source_test_case344" value="DO
ST_MULTILINESTRINGFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_py)))" db-types="MySQL"
/>
- <sql-case id="do_by_mysql_source_test_case345" value="DO
ST_MULTIPOINTFROMTEXT(@wkt_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case346" value="DO
ST_MULTIPOINTFROMTEXT(@wkt_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case347" value="DO
ST_MULTIPOINTFROMTEXT(@wkt_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case348" value="DO
ST_MULTIPOINTFROMTEXT(@wkt_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case349" value="DO
ST_MULTIPOINTFROMTEXT(@wkt_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case350" value="DO
ST_MULTIPOINTFROMTEXT(@wkt_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case351" value="DO
ST_MULTIPOINTFROMTEXT(@wkt_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case352" value="DO
ST_MULTIPOINTFROMWKB(@wkb_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case353" value="DO
ST_MULTIPOINTFROMWKB(@wkb_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case354" value="DO
ST_MULTIPOINTFROMWKB(@wkb_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case355" value="DO
ST_MULTIPOINTFROMWKB(@wkb_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case356" value="DO
ST_MULTIPOINTFROMWKB(@wkb_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case357" value="DO
ST_MULTIPOINTFROMWKB(@wkb_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case358" value="DO
ST_MULTIPOINTFROMWKB(@wkb_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case359" value="DO
ST_MULTIPOINTFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_gc)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case360" value="DO
ST_MULTIPOINTFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_ls)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case361" value="DO
ST_MULTIPOINTFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mls)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case362" value="DO
ST_MULTIPOINTFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpt)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case363" value="DO
ST_MULTIPOINTFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpy)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case364" value="DO
ST_MULTIPOINTFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_pt)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case365" value="DO
ST_MULTIPOINTFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_py)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case366" value="DO
ST_MULTIPOLYGONFROMTEXT(@wkt_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case367" value="DO
ST_MULTIPOLYGONFROMTEXT(@wkt_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case368" value="DO
ST_MULTIPOLYGONFROMTEXT(@wkt_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case369" value="DO
ST_MULTIPOLYGONFROMTEXT(@wkt_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case370" value="DO
ST_MULTIPOLYGONFROMTEXT(@wkt_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case371" value="DO
ST_MULTIPOLYGONFROMTEXT(@wkt_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case372" value="DO
ST_MULTIPOLYGONFROMTEXT(@wkt_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case373" value="DO
ST_MULTIPOLYGONFROMWKB(@wkb_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case374" value="DO
ST_MULTIPOLYGONFROMWKB(@wkb_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case375" value="DO
ST_MULTIPOLYGONFROMWKB(@wkb_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case376" value="DO
ST_MULTIPOLYGONFROMWKB(@wkb_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case377" value="DO
ST_MULTIPOLYGONFROMWKB(@wkb_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case378" value="DO
ST_MULTIPOLYGONFROMWKB(@wkb_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case379" value="DO
ST_MULTIPOLYGONFROMWKB(@wkb_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case380" value="DO
ST_MULTIPOLYGONFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_gc)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case381" value="DO
ST_MULTIPOLYGONFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_ls)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case382" value="DO
ST_MULTIPOLYGONFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mls)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case383" value="DO
ST_MULTIPOLYGONFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpt)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case384" value="DO
ST_MULTIPOLYGONFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpy)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case385" value="DO
ST_MULTIPOLYGONFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_pt)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case386" value="DO
ST_MULTIPOLYGONFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_py)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case387" value="DO
ST_OVERLAPS(ST_ASWKB(ST_ASBINARY(1,'axis-order=lat-long'),
'axis-order=srid-defined'), ST_ASWKT(LAST_VALUE('*7')
OVER()))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case388" value="DO
ST_POINTFROMTEXT(@wkt_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case389" value="DO
ST_POINTFROMTEXT(@wkt_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case390" value="DO
ST_POINTFROMTEXT(@wkt_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case391" value="DO
ST_POINTFROMTEXT(@wkt_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case392" value="DO
ST_POINTFROMTEXT(@wkt_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case393" value="DO
ST_POINTFROMTEXT(@wkt_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case394" value="DO
ST_POINTFROMTEXT(@wkt_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case395" value="DO
ST_POINTFROMWKB(@wkb_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case396" value="DO
ST_POINTFROMWKB(@wkb_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case397" value="DO
ST_POINTFROMWKB(@wkb_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case398" value="DO
ST_POINTFROMWKB(@wkb_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case399" value="DO
ST_POINTFROMWKB(@wkb_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case400" value="DO
ST_POINTFROMWKB(@wkb_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case401" value="DO
ST_POINTFROMWKB(@wkb_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case402" value="DO
ST_POINTFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_gc)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case403" value="DO
ST_POINTFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_ls)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case404" value="DO
ST_POINTFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mls)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case405" value="DO
ST_POINTFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpt)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case406" value="DO
ST_POINTFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpy)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case407" value="DO
ST_POINTFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_pt)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case408" value="DO
ST_POINTFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_py)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case409" value="DO
ST_POINTN(ST_ASWKT(ST_ASWKT(ST_ASWKB(6565))),
ST_ASBINARY(LAST_VALUE(0xfd8b9af2bedb16c0d7f1cca63b5c9e) OVER()))"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case410" value="DO
ST_POLYFROMTEXT(@wkt_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case411" value="DO
ST_POLYFROMTEXT(@wkt_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case412" value="DO
ST_POLYFROMTEXT(@wkt_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case413" value="DO
ST_POLYFROMTEXT(@wkt_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case414" value="DO
ST_POLYFROMTEXT(@wkt_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case415" value="DO
ST_POLYFROMTEXT(@wkt_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case416" value="DO
ST_POLYFROMTEXT(@wkt_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case417" value="DO
ST_POLYFROMWKB(@wkb_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case418" value="DO
ST_POLYFROMWKB(@wkb_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case419" value="DO
ST_POLYFROMWKB(@wkb_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case420" value="DO
ST_POLYFROMWKB(@wkb_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case421" value="DO
ST_POLYFROMWKB(@wkb_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case422" value="DO
ST_POLYFROMWKB(@wkb_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case423" value="DO
ST_POLYFROMWKB(@wkb_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case424" value="DO
ST_POLYFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_gc)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case425" value="DO
ST_POLYFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_ls)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case426" value="DO
ST_POLYFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mls)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case427" value="DO
ST_POLYFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpt)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case428" value="DO
ST_POLYFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpy)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case429" value="DO
ST_POLYFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_pt)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case430" value="DO
ST_POLYFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_py)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case431" value="DO
ST_POLYGONFROMTEXT(@wkt_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case432" value="DO
ST_POLYGONFROMTEXT(@wkt_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case433" value="DO
ST_POLYGONFROMTEXT(@wkt_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case434" value="DO
ST_POLYGONFROMTEXT(@wkt_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case435" value="DO
ST_POLYGONFROMTEXT(@wkt_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case436" value="DO
ST_POLYGONFROMTEXT(@wkt_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case437" value="DO
ST_POLYGONFROMTEXT(@wkt_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case438" value="DO
ST_POLYGONFROMWKB(@wkb_gc)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case439" value="DO
ST_POLYGONFROMWKB(@wkb_ls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case440" value="DO
ST_POLYGONFROMWKB(@wkb_mls)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case441" value="DO
ST_POLYGONFROMWKB(@wkb_mpt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case442" value="DO
ST_POLYGONFROMWKB(@wkb_mpy)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case443" value="DO
ST_POLYGONFROMWKB(@wkb_pt)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case444" value="DO
ST_POLYGONFROMWKB(@wkb_py)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case445" value="DO
ST_POLYGONFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_gc)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case446" value="DO
ST_POLYGONFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_ls)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case447" value="DO
ST_POLYGONFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mls)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case448" value="DO
ST_POLYGONFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpt)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case449" value="DO
ST_POLYGONFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_mpy)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case450" value="DO
ST_POLYGONFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_pt)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case451" value="DO
ST_POLYGONFROMWKB(St_AsWKB(ST_GEOMFROMTEXT(@wkt_py)))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case452" value="DO
ST_SRID(LOCATE(0x58ed0b8e,8,135))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case453" value="DO
ST_WITHIN(ST_ASWKB(ST_ASBINARY(1,'axis-order=srid-defined')),
ST_ASWKT(
ST_ASBINARY(LAST_VALUE(4732)OVER()),'axis-order=srid-defined'))"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case454" value="DO
SUBSTRING_INDEX(((((RADIANS(0xBD)) && (ST_SRID(1, 4326)))) OR
(COT(UUID_SHORT()))), FIRST_VALUE(ROW_COUNT())RESPECT NULLS OVER(), 171)"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case455" value="DO
TO_BASE64(AVG(@d)OVER())" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case456" value="DO
TO_DAYS(LEAD(((LOCATE(0xA812,0xE8DE))OR(@G)),148)OVER())" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case457" value="DO
TO_SECONDS(LAG(POINT(2.804466E+307,-2032),75) OVER())" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case458" value="DO
TRIM(-9223372036854775808) XOR '.D-'" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case459" value="DO UNHEX(-1)"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case460" value="DO
UNHEX(-182680438)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case461" value="DO
UNHEX(-2251799813685249)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case462" value="DO
UNHEX(SUM(@g)OVER())" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case463" value="DO UNIX_TIMESTAMP(
LAG(ROUND(((UTC_TIME()) OR ((NOT (INET6_ATON(IS_IPV4(((MAKETIME(-10966, 233,
2795.439453)) OR(MAKEDATE(-3030,19)))))))))), 140) OVER())" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case464" value="DO USER() in
(COERCIBILITY(@c), CONVERT(LAST_VALUE(FROM_UNIXTIME(1536999169)) OVER() USING
utf32))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case465" value="DO
WEEK((DATE_ADD((CAST(0 AS DATE)), INTERVAL 1 YEAR_MONTH)), 5)" db-types="MySQL"
/>
- <sql-case id="do_by_mysql_source_test_case466" value="DO
WEEKOFYEAR(LAG(-16726 ,247)RESPECT NULLS OVER())" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case467" value="DO
WEEKOFYEAR(LEAD(('5183-10-18 06:15:35.076079')SOUNDS
LIKE(0x9E335D89),68)OVER())" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case468" value="DO
YEARWEEK(LEAD(FOUND_ROWS(),250)OVER())" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case469" value="DO
is_used_lock(ifnull(now(), CASE 1 WHEN 1 THEN NULL END))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case470" value="DO
ltrim(weight_string(1))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case471" value="DO maketime(~0, 49,
0.123456789)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case472" value="DO round( concat( (
coalesce( ( ST_linefromwkb('2147483648',
-b'1111111111111111111111111111111111111111111')), (
convert('[.DC2.]',decimal(30,30)) ), bit_count('') ) ), (
lpad( ( elt('01','}:K5')), sha1('P'), ( ( select
'-9223372036854775808.1' > all (select ''))) ) ) ) )"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case473" value="DO
rtrim(weight_string(1))" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case474" value="DO
st_centroid(point(1,1)) IN ('1',1,'1')" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case475" value="DO
validate_password_strength(export_set('a','a','a','a','a'))"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case476" value="DO
version_tokens_lock_exclusive('vt3', 'vt5',
'vt1', 0)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case477" value="DO
version_tokens_lock_exclusive('vt3', 'vt5',
'vt1', 4)" db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case478" value="DO
version_tokens_set('vt1=11;vt2=22;vt3=33;vt4=44;vt5=55')"
db-types="MySQL" />
- <sql-case id="do_by_mysql_source_test_case479" value="DO
version_tokens_unlock()" db-types="MySQL" />
<sql-case id="explain_by_mysql_source_test_case1" value="EXPLAIN ANALYZE
FOR CONNECTION 1" db-types="MySQL" />
<sql-case id="explain_by_mysql_source_test_case2" value="EXPLAIN ANALYZE
FORMAT=JSON SELECT 1" db-types="MySQL" />
<sql-case id="explain_by_mysql_source_test_case3" value="EXPLAIN ANALYZE
FORMAT=TRADITIONAL SELECT 1" db-types="MySQL" />
@@ -3554,64 +3075,6 @@
<sql-case id="low_call_by_mysql_source_test_case205" value="call
sys.create_synonym_db("INFORMATION_SCHEMA", "I_S")"
db-types="MySQL" />
<sql-case id="low_call_by_mysql_source_test_case206" value="call
test.longprocedure(@value); select @value" db-types="MySQL" />
<sql-case id="low_default-character-set=koi8r_by_mysql_source_test_case1"
value="default-character-set=koi8r default-collation=koi8r_bin let $MYSQLD_LOG=
$MYSQLTEST_VARDIR/log/save_dd_upgrade_1.log" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case1" value="do
((-9223372036854775808)* ( 3273059463432352943))" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case2" value="do
((3273059463432352943 )* (-9223372036854775808 ))" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case3" value="do
((repeat(1,9223372036854775808))or(convert((0x6d5b5d8d)using dec8)))"
db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case4" value="do
(is_ipv4_mapped(bin_to_uuid(@a:=34))) <=>
(json_objectagg('key2',42 ) and rtrim(""))"
db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case5" value="do 1"
db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case6" value="do 1 div
nullif(min(from_days(1)),_utf8mb4'2000-01-01')" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case7" value="do _cp852
"" <= lcase(trim(leading 1 from 12222)) not between '1'
and '2'" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case8" value="do
char((weight_string(extractvalue((''),('tX')))) using
cp852)" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case9" value="do
concat('111','11111111111111111111111111',
substring_index(uuid(),0,1.111111e+308))" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case10" value="do
concat('111','11111111111111111111111111',
substring_index(uuid(),0,1.111111e+308))" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case11" value="do
concat('a',concat_ws('a', 0x2859, 'a' ,
trim(period_add('a',1) from (1&'')) ) )"
db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case12" value="do
concat(export_set(1,1,repeat('a',31),' $',213))"
db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case13" value="do
concat_ws(',','111','11111111111111111111111111',
substring_index(uuid(),0,1.111111e+308))" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case14" value="do
convert(inet_aton(cast(left(-1,1)as binary(30))) using utf8)" db-types="MySQL"
/>
- <sql-case id="low_do_by_mysql_source_test_case15" value="do
crc32(char(1.134475e+308))" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case16" value="do
date_add(utc_time(), interval(oct(-11779)) microsecond)" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case17" value="do dayofmonth( (
not( trim( trailing( convert((''), binary(4))) from( make_set(
('>>'), ('`')))) )))" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case18" value="do
format(rpad('111111111.1', 1111111,
'999999999999999999999999999999999999999999'),0,'be_BY')"
db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case19" value="do
from_base64(aes_encrypt(right(cast((0x5d44f4d736397d92c8267c12)as decimal),1),
rand(to_days('2028-12-04 15:50:01.284969'))))" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case20" value="do
from_base64(cast((left(collation(4097),((repeat('1',32))or((-18772)))))
as binary(40)))" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case21" value="do
from_base64(cast((mid(17653,row('-688:20:12.162697',(null)) >=
row(('*.)$'),(0xc254b6)),1))as binary(34)))" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case22" value="do
from_base64(cast((mid(uuid(),20,64)) as binary(55)))" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case23" value="do
from_base64(cast(right(11,1)as binary(24)))" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case24" value="do
ifnull((bin_to_uuid(uuid_to_bin(date_format('7088-02-14'
,0xabbd95)))),(maketime('4678-07-20
03:51:44.174847',1,'b')))" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case25" value="do
inet_aton(aes_encrypt(left(@e,1),5))" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case26" value="do
insert(ltrim(from_unixtime(0,' %T ')), 2, 1, 'hi')"
db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case27" value="do
is_ipv4_mapped(bin(maketime(11111,exp(repeat('1',32)),'')))"
db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case28" value="do
lcase(ltrim(from_unixtime(0,' %T ')))" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case29" value="do null not
between 1 and @undefined_var" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case30" value="do null not
between @undefined_var and 1" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case31" value="do nullif( (
rtrim( make_set((cast(('%S') as unsigned)),
(point((0xaf),('')))) ) ), (''))" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case32" value="do
nullif(1,'-' between lcase(right(11111111," 7,]" ))and
'1')" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case33" value="do
quote(make_set((''), (cast(('-2147483649.1') as
binary(513)))))" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case34" value="do
regexp_instr(0, "^{18446744073709551616")" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case35" value="do regexp_like(0,
"^{18446744073709551616")" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case36" value="do
repeat(row_count() ,((-9223372036854775808 )<<('{ }' )) )"
db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case37" value="do
replace(ltrim(from_unixtime(0,' %T ')), '0',
'1')" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case38" value="do
replace(ltrim(from_unixtime(0,' %T ')), '0',
'1')" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case39" value="do
rpad(_utf16"33",1073741826,_latin1"44")" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case40" value="do
soundex(maketime(cast((2530967061762658367) as decimal),
exp(repeat('1',32)),((period_add(579349005,27636))xor
(sha(current_user)))))" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case41" value="do
sqrt(weight_string(_eucjpms "0E+"))" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case42" value="do
st_buffer(point(-5,0),8772,
st_buffer_strategy('point_circle',1024*1024*1024))" db-types="MySQL"
/>
- <sql-case id="low_do_by_mysql_source_test_case43" value="do
st_distance(linestring(point(26,87),point(13,95)),
geometrycollection(point(4.297374e+307,8.433875e+307)))" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case44" value="do
st_mlinefromtext( maketime( now(), instr(1,pow(15270551309908264860,100)), 31 )
)" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case45" value="do
st_union(cast(point(1,1)as char(12)),point(1,1))" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case46" value="do
st_union(cast(point(1,1)as char(13)),point(1,1))" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case47" value="do str_to_date(1,
"%#")" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case48" value="do
timestamp(date_format('2011-11-11', right("12345" + 1,
3)))" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case49" value="do trim(
both(-8388607) from( make_set( ( extract( minute_second from (
str_to_date((rpad(1.0,4,1)), (''))) ) ), ( char((connection_id())
using macce))) ) )" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case50" value="do
ucase(insert(maketime(9.565398e+307 ,'',
st_longfromgeohash(('4358-04-12 03:45:08.727399'))),
0xdc0823,6756,release_all_locks()))" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case51" value="do
upper(right(198039009115594390000000000000000000000.000000,35))"
db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case52" value="do
upper(substring(1.111111111111111111 from '2n'))" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case53" value="do
version_tokens_set("token1 = def;;
token111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111=123;;
;invalid_token; token2= abc;;")" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case54" value="do
version_tokens_set("token1 = def;;;; ;invalid_token; token2=
abc;;")" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case55" value="do
version_tokens_set("token1 = none;;;; ;invalid_token; token2=
123;;")" db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case56" value="do
version_tokens_set("token1=def;token2= abc; ;token3=ghi")"
db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case57" value="do
version_tokens_set("token1=def;token2=
abc;token3=111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111112")"
db-types="MySQL" />
- <sql-case id="low_do_by_mysql_source_test_case58" value="do
weight_string(extractvalue('','/*/a'))" db-types="MySQL" />
<sql-case id="low_drop_by_mysql_source_test_case1" value="drop function
`f``1`" db-types="MySQL" />
<sql-case id="low_drop_by_mysql_source_test_case3" value="drop table
BIT_XOR" db-types="MySQL" />
<sql-case id="low_drop_by_mysql_source_test_case4" value="drop table
```a`" db-types="MySQL" />
