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 5089c90 Adjust `SHOW` statement (#14798)
5089c90 is described below
commit 5089c90aaf7305f9d1ab96c3cb7bc8ac1123e9aa
Author: Guocheng Tang <[email protected]>
AuthorDate: Mon Jan 17 14:29:13 2022 +0800
Adjust `SHOW` statement (#14798)
* Adjust `SHOW` statement
* remove blank line.
* update test case.
* update test case.
* update test case.
* update test case.
* update test case.
* update test case.
* remove support show statement in unsupported test case.
* remove support show statement in unsupported test case.
* update `SHOW RELAY LOG EVENT` statement
* remove support show statement in unsupported test case.
* update MySQLShowCreateProcedureStatement
* update MySQLShowCreateProcedureStatement
* update MySQLShowCreateProcedureStatement
---
.../mysql/executor/ShowCreateDatabaseExecutor.java | 2 +-
.../executor/ShowCreateDatabaseExecutorTest.java | 2 +-
.../src/main/antlr4/imports/mysql/BaseRule.g4 | 14 +-
.../src/main/antlr4/imports/mysql/DALStatement.g4 | 94 +++---
.../impl/MySQLDALStatementSQLVisitor.java | 117 ++++++--
...atement.java => MySQLShowCharsetStatement.java} | 4 +-
.../dal/MySQLShowCreateDatabaseStatement.java | 2 +-
.../mysql/dal/MySQLShowCreateEventStatement.java | 6 +
.../dal/MySQLShowCreateFunctionStatement.java | 6 +
.../dal/MySQLShowCreateProcedureStatement.java | 6 +
.../mysql/dal/MySQLShowCreateViewStatement.java | 6 +
...tatement.java => MySQLShowEngineStatement.java} | 6 +-
...atement.java => MySQLShowEnginesStatement.java} | 4 +-
.../mysql/dal/MySQLShowErrorsStatement.java | 7 +
...nt.java => MySQLShowFunctionCodeStatement.java} | 6 +-
...tatement.java => MySQLShowGrantsStatement.java} | 4 +-
...nt.java => MySQLShowMasterStatusStatement.java} | 4 +-
...atement.java => MySQLShowPluginsStatement.java} | 4 +-
...ment.java => MySQLShowPrivilegesStatement.java} | 4 +-
...atement.java => MySQLShowProfileStatement.java} | 7 +-
...tement.java => MySQLShowProfilesStatement.java} | 4 +-
.../dal/MySQLShowRelaylogEventsStatement.java | 3 +
.../mysql/dal/MySQLShowWarningsStatement.java | 7 +
.../dal/impl/ShowProcedureCodeStatementAssert.java | 1 -
.../src/main/resources/case/dal/show.xml | 25 ++
.../src/main/resources/sql/supported/dal/show.xml | 27 +-
.../main/resources/sql/unsupported/unsupported.xml | 331 ---------------------
27 files changed, 271 insertions(+), 432 deletions(-)
diff --git
a/shardingsphere-proxy/shardingsphere-proxy-backend/src/main/java/org/apache/shardingsphere/proxy/backend/text/admin/mysql/executor/ShowCreateDatabaseExecutor.java
b/shardingsphere-proxy/shardingsphere-proxy-backend/src/main/java/org/apache/shardingsphere/proxy/backend/text/admin/mysql/executor/ShowCreateDatabaseExecutor.java
index 05ce187..4b5a15e 100644
---
a/shardingsphere-proxy/shardingsphere-proxy-backend/src/main/java/org/apache/shardingsphere/proxy/backend/text/admin/mysql/executor/ShowCreateDatabaseExecutor.java
+++
b/shardingsphere-proxy/shardingsphere-proxy-backend/src/main/java/org/apache/shardingsphere/proxy/backend/text/admin/mysql/executor/ShowCreateDatabaseExecutor.java
@@ -60,7 +60,7 @@ public final class ShowCreateDatabaseExecutor implements
DatabaseAdminQueryExecu
@Override
public void execute(final ConnectionSession connectionSession) {
queryResultMetaData = createQueryResultMetaData();
- mergedResult = new
TransparentMergedResult(getQueryResult(showCreateDatabaseStatement.getSchema()));
+ mergedResult = new
TransparentMergedResult(getQueryResult(showCreateDatabaseStatement.getSchemaName()));
}
private QueryResult getQueryResult(final String schemaName) {
diff --git
a/shardingsphere-proxy/shardingsphere-proxy-backend/src/test/java/org/apache/shardingsphere/proxy/backend/text/admin/mysql/executor/ShowCreateDatabaseExecutorTest.java
b/shardingsphere-proxy/shardingsphere-proxy-backend/src/test/java/org/apache/shardingsphere/proxy/backend/text/admin/mysql/executor/ShowCreateDatabaseExecutorTest.java
index 34003d7..30e13f8 100644
---
a/shardingsphere-proxy/shardingsphere-proxy-backend/src/test/java/org/apache/shardingsphere/proxy/backend/text/admin/mysql/executor/ShowCreateDatabaseExecutorTest.java
+++
b/shardingsphere-proxy/shardingsphere-proxy-backend/src/test/java/org/apache/shardingsphere/proxy/backend/text/admin/mysql/executor/ShowCreateDatabaseExecutorTest.java
@@ -74,7 +74,7 @@ public final class ShowCreateDatabaseExecutorTest {
@Test
public void assertExecute() throws SQLException {
MySQLShowCreateDatabaseStatement statement = new
MySQLShowCreateDatabaseStatement();
- statement.setSchema("schema_0");
+ statement.setSchemaName("schema_0");
ShowCreateDatabaseExecutor showCreateDatabaseExecutor = new
ShowCreateDatabaseExecutor(statement);
showCreateDatabaseExecutor.execute(mockConnectionSession());
assertThat(showCreateDatabaseExecutor.getQueryResultMetaData().getColumnCount(),
is(2));
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-mysql/src/main/antlr4/imports/mysql/BaseRule.g4
b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-mysql/src/main/antlr4/imports/mysql/BaseRule.g4
index 5a6764d..b9ed65b 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-mysql/src/main/antlr4/imports/mysql/BaseRule.g4
+++
b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-mysql/src/main/antlr4/imports/mysql/BaseRule.g4
@@ -655,7 +655,7 @@ username
;
eventName
- : identifier (DOT_ identifier)?
+ : (owner DOT_)? identifier
;
serverName
@@ -667,13 +667,15 @@ wrapperName
;
functionName
- : identifier
- | (owner DOT_)? identifier
+ : (owner DOT_)? identifier
;
-
+
+procedureName
+ : (owner DOT_)? identifier
+ ;
+
viewName
- : identifier
- | (owner DOT_)? identifier
+ : (owner DOT_)? identifier
;
owner
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-mysql/src/main/antlr4/imports/mysql/DALStatement.g4
b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-mysql/src/main/antlr4/imports/mysql/DALStatement.g4
index 71ea726..ca974c7 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-mysql/src/main/antlr4/imports/mysql/DALStatement.g4
+++
b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-mysql/src/main/antlr4/imports/mysql/DALStatement.g4
@@ -33,31 +33,7 @@ explain
| explainType? (explainableStatement | FOR CONNECTION connectionId)
| ANALYZE (FORMAT EQ_ TREE)? select)
;
-
-showDatabases
- : SHOW (DATABASES | SCHEMAS) showFilter?
- ;
-
-showTables
- : SHOW EXTENDED? FULL? TABLES fromSchema? showFilter?
- ;
-
-showTableStatus
- : SHOW TABLE STATUS fromSchema? showFilter?
- ;
-
-showColumns
- : SHOW EXTENDED? FULL? (COLUMNS | FIELDS) fromTable fromSchema? showFilter?
- ;
-
-showIndex
- : SHOW EXTENDED? (INDEX | INDEXES | KEYS) fromTable fromSchema?
showWhereClause?
- ;
-
-showCreateTable
- : SHOW CREATE TABLE tableName
- ;
-
+
fromSchema
: (FROM | IN) schemaName
;
@@ -118,6 +94,10 @@ showCollation
: SHOW COLLATION showFilter?
;
+showColumns
+ : SHOW EXTENDED? FULL? (COLUMNS | FIELDS) fromTable fromSchema? showFilter?
+ ;
+
showCreateDatabase
: SHOW CREATE (DATABASE | SCHEMA) notExistClause? schemaName
;
@@ -131,7 +111,11 @@ showCreateFunction
;
showCreateProcedure
- : SHOW CREATE PROCEDURE functionName
+ : SHOW CREATE PROCEDURE procedureName
+ ;
+
+showCreateTable
+ : SHOW CREATE TABLE tableName
;
showCreateTrigger
@@ -146,6 +130,10 @@ showCreateView
: SHOW CREATE VIEW viewName
;
+showDatabases
+ : SHOW (DATABASES | SCHEMAS) showFilter?
+ ;
+
showEngine
: SHOW ENGINE engineRef (STATUS | MUTEX)
;
@@ -154,12 +142,8 @@ showEngines
: SHOW STORAGE? ENGINES
;
-showCharset
- : SHOW CHARSET
- ;
-
showErrors
- : SHOW (COUNT LP_ ASTERISK_ RP_)? ERRORS (LIMIT (NUMBER_ COMMA_)? NUMBER_)?
+ : SHOW (COUNT LP_ ASTERISK_ RP_)? ERRORS limitClause?
;
showEvents
@@ -174,8 +158,12 @@ showFunctionStatus
: SHOW FUNCTION STATUS showFilter?
;
-showGrant
- : SHOW GRANTS (FOR username (USING username (COMMA_ username)+)?)?
+showGrants
+ : SHOW GRANTS (FOR (username | roleName) (USING roleName (COMMA_
roleName)*)?)?
+ ;
+
+showIndex
+ : SHOW EXTENDED? (INDEX | INDEXES | KEYS) fromTable fromSchema?
showWhereClause?
;
showMasterStatus
@@ -207,7 +195,7 @@ showProcesslist
;
showProfile
- : SHOW PROFILE ( showProfileType (COMMA_ showProfileType)*)? (FOR QUERY
NUMBER_)? (LIMIT NUMBER_ (OFFSET NUMBER_)?)?
+ : SHOW PROFILE (showProfileType (COMMA_ showProfileType)*)? (FOR QUERY
NUMBER_)? limitClause?
;
showProfiles
@@ -215,11 +203,19 @@ showProfiles
;
showRelaylogEvent
- : SHOW RELAYLOG EVENTS (IN logName)? (FROM NUMBER_)? (LIMIT (NUMBER_
COMMA_)? NUMBER_)? FOR CHANNEL channelName
+ : SHOW RELAYLOG EVENTS (IN logName)? (FROM NUMBER_)? limitClause? (FOR
CHANNEL channelName)?
;
-showSlavehost
- : SHOW SLAVE HOST
+showReplicas
+ : SHOW REPLICAS
+ ;
+
+showSlaveHosts
+ : SHOW SLAVE HOSTS
+ ;
+
+showReplicaStatus
+ : SHOW REPLICA STATUS (FOR CHANNEL channelName)?
;
showSlaveStatus
@@ -230,6 +226,14 @@ showStatus
: SHOW (GLOBAL | SESSION)? STATUS showFilter?
;
+showTableStatus
+ : SHOW TABLE STATUS fromSchema? showFilter?
+ ;
+
+showTables
+ : SHOW EXTENDED? FULL? TABLES fromSchema? showFilter?
+ ;
+
showTriggers
: SHOW TRIGGERS fromSchema? showFilter?
;
@@ -239,15 +243,11 @@ showVariables
;
showWarnings
- : SHOW (COUNT LP_ ASTERISK_ RP_)? WARNINGS (LIMIT (NUMBER_ COMMA_)?
NUMBER_)?
+ : SHOW (COUNT LP_ ASTERISK_ RP_)? WARNINGS limitClause?
;
-showReplicas
- : SHOW REPLICAS
- ;
-
-showReplicaStatus
- : SHOW REPLICA STATUS (FOR CHANNEL channelName)?
+showCharset
+ : SHOW CHARSET
;
setCharacter
@@ -420,7 +420,7 @@ formatName
;
delimiter
- : DELIMITER delimiterName
+ : DELIMITER delimiterName
;
show
@@ -448,7 +448,7 @@ show
| showEvents
| showFunctionCode
| showFunctionStatus
- | showGrant
+ | showGrants
| showMasterStatus
| showPlugins
| showOpenTables
@@ -458,7 +458,7 @@ show
| showProfile
| showProcedureStatus
| showProfiles
- | showSlavehost
+ | showSlaveHosts
| showSlaveStatus
| showRelaylogEvent
| showStatus
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/MySQLDALStatementSQLVisitor.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/MySQLDALStatementSQLVisitor.java
index adad557..85cebbf 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/MySQLDALStatementSQLVisitor.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/MySQLDALStatementSQLVisitor.java
@@ -21,6 +21,7 @@ import lombok.NoArgsConstructor;
import org.apache.shardingsphere.sql.parser.api.visitor.ASTNode;
import
org.apache.shardingsphere.sql.parser.api.visitor.operation.SQLStatementVisitor;
import org.apache.shardingsphere.sql.parser.api.visitor.type.DALSQLVisitor;
+import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.ShowProfilesContext;
import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.AlterResourceGroupContext;
import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.AnalyzeTableContext;
import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.BinaryLogFileIndexNumberContext;
@@ -84,18 +85,24 @@ import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.ShowEng
import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.ShowErrorsContext;
import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.ShowEventsContext;
import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.ShowFilterContext;
+import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.ShowFunctionCodeContext;
import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.ShowFunctionStatusContext;
+import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.ShowGrantsContext;
import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.ShowIndexContext;
import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.ShowLikeContext;
+import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.ShowMasterStatusContext;
import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.ShowOpenTablesContext;
+import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.ShowPluginsContext;
+import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.ShowPrivilegesContext;
import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.ShowProcedureCodeContext;
import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.ShowProcedureStatusContext;
import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.ShowProcesslistContext;
+import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.ShowProfileContext;
import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.ShowRelaylogEventContext;
import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.ShowReplicaStatusContext;
import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.ShowReplicasContext;
+import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.ShowSlaveHostsContext;
import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.ShowSlaveStatusContext;
-import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.ShowSlavehostContext;
import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.ShowStatusContext;
import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.ShowTableStatusContext;
import
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.ShowTablesContext;
@@ -170,15 +177,23 @@ import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQ
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLShowCreateUserStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLShowCreateViewStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLShowDatabasesStatement;
+import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLShowEngineStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLShowErrorsStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLShowEventsStatement;
+import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLShowFunctionCodeStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLShowFunctionStatusStatement;
+import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLShowGrantsStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLShowIndexStatement;
+import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLShowMasterStatusStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLShowOpenTablesStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLShowOtherStatement;
+import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLShowPluginsStatement;
+import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLShowPrivilegesStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLShowProcedureCodeStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLShowProcedureStatusStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLShowProcessListStatement;
+import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLShowProfileStatement;
+import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLShowProfilesStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLShowRelaylogEventsStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLShowReplicaStatusStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal.MySQLShowReplicasStatement;
@@ -229,7 +244,7 @@ public final class MySQLDALStatementSQLVisitor extends
MySQLStatementSQLVisitor
@Override
public ASTNode visitShowCreateDatabase(final ShowCreateDatabaseContext
ctx) {
MySQLShowCreateDatabaseStatement result = new
MySQLShowCreateDatabaseStatement();
- result.setSchema(((IdentifierValue)
visit(ctx.schemaName())).getValue());
+ result.setSchemaName(((SchemaSegment)
visit(ctx.schemaName())).getIdentifier().getValue());
return result;
}
@@ -260,8 +275,10 @@ public final class MySQLDALStatementSQLVisitor extends
MySQLStatementSQLVisitor
@Override
public ASTNode visitShowEngine(final ShowEngineContext ctx) {
- return new MySQLShowOtherStatement();
- }
+ MySQLShowEngineStatement result = new MySQLShowEngineStatement();
+ result.setEngineName(ctx.engineRef().getText());
+ return result;
+ }
@Override
public ASTNode visitShowCharset(final ShowCharsetContext ctx) {
@@ -270,17 +287,23 @@ public final class MySQLDALStatementSQLVisitor extends
MySQLStatementSQLVisitor
@Override
public ASTNode visitShowCreateEvent(final ShowCreateEventContext ctx) {
- return new MySQLShowCreateEventStatement();
+ MySQLShowCreateEventStatement result = new
MySQLShowCreateEventStatement();
+ result.setEventName(((IdentifierValue)
visit(ctx.eventName())).getValue());
+ return result;
}
@Override
public ASTNode visitShowCreateFunction(final ShowCreateFunctionContext
ctx) {
- return new MySQLShowCreateFunctionStatement();
+ MySQLShowCreateFunctionStatement result = new
MySQLShowCreateFunctionStatement();
+ result.setFunctionName(((FunctionSegment)
visit(ctx.functionName())).getFunctionName());
+ return result;
}
@Override
public ASTNode visitShowCreateProcedure(final ShowCreateProcedureContext
ctx) {
- return new MySQLShowCreateProcedureStatement();
+ MySQLShowCreateProcedureStatement result = new
MySQLShowCreateProcedureStatement();
+ result.setProcedureName(((IdentifierValue)
visit(ctx.procedureName())).getValue());
+ return result;
}
@Override
@@ -297,12 +320,20 @@ public final class MySQLDALStatementSQLVisitor extends
MySQLStatementSQLVisitor
@Override
public ASTNode visitShowErrors(final ShowErrorsContext ctx) {
- return new MySQLShowErrorsStatement();
+ MySQLShowErrorsStatement result = new MySQLShowErrorsStatement();
+ if (null != ctx.limitClause()) {
+ result.setLimit((LimitSegment) visit(ctx.limitClause()));
+ }
+ return result;
}
@Override
public ASTNode visitShowWarnings(final ShowWarningsContext ctx) {
- return new MySQLShowWarningsStatement();
+ MySQLShowWarningsStatement result = new MySQLShowWarningsStatement();
+ if (null != ctx.limitClause()) {
+ result.setLimit((LimitSegment) visit(ctx.limitClause()));
+ }
+ return result;
}
@Override
@@ -573,7 +604,21 @@ public final class MySQLDALStatementSQLVisitor extends
MySQLStatementSQLVisitor
result.setFunction((FunctionSegment) visit(ctx.functionName()));
return result;
}
-
+
+ @Override
+ public ASTNode visitShowProfile(final ShowProfileContext ctx) {
+ MySQLShowProfileStatement result = new MySQLShowProfileStatement();
+ if (null != ctx.limitClause()) {
+ result.setLimit((LimitSegment) visit(ctx.limitClause()));
+ }
+ return result;
+ }
+
+ @Override
+ public ASTNode visitShowProfiles(final ShowProfilesContext ctx) {
+ return new MySQLShowProfilesStatement();
+ }
+
@Override
public ASTNode visitShowDatabases(final ShowDatabasesContext ctx) {
MySQLShowDatabasesStatement result = new MySQLShowDatabasesStatement();
@@ -694,40 +739,62 @@ public final class MySQLDALStatementSQLVisitor extends
MySQLStatementSQLVisitor
result.setName(((IdentifierValue)
visit(ctx.triggerName())).getValue());
return result;
}
-
+
@Override
public ASTNode visitShowRelaylogEvent(final ShowRelaylogEventContext ctx) {
MySQLShowRelaylogEventsStatement result = new
MySQLShowRelaylogEventsStatement();
- result.setChannel(ctx.channelName().getText());
if (null != ctx.logName()) {
result.setLogName(((StringLiteralValue)
visit(ctx.logName().stringLiterals().string_())).getValue());
}
+ if (null != ctx.limitClause()) {
+ result.setLimit((LimitSegment) visit(ctx.limitClause()));
+ }
+ if (null != ctx.channelName()) {
+ result.setChannel(((IdentifierValue)
visit(ctx.channelName())).getValue());
+ }
return result;
}
-
+
+ @Override
+ public ASTNode visitShowFunctionCode(final ShowFunctionCodeContext ctx) {
+ MySQLShowFunctionCodeStatement result = new
MySQLShowFunctionCodeStatement();
+ result.setFunctionName(((FunctionSegment)
visit(ctx.functionName())).getFunctionName());
+ return result;
+ }
+
+ @Override
+ public ASTNode visitShowGrants(final ShowGrantsContext ctx) {
+ return new MySQLShowGrantsStatement();
+ }
+
+ @Override
+ public ASTNode visitShowMasterStatus(final ShowMasterStatusContext ctx) {
+ return new MySQLShowMasterStatusStatement();
+ }
+
@Override
- public ASTNode visitShowSlavehost(final ShowSlavehostContext ctx) {
+ public ASTNode visitShowSlaveHosts(final ShowSlaveHostsContext ctx) {
return new MySQLShowSlaveHostsStatement();
}
-
+
@Override
public ASTNode visitShowReplicaStatus(final ShowReplicaStatusContext ctx) {
MySQLShowReplicaStatusStatement result = new
MySQLShowReplicaStatusStatement();
if (null != ctx.channelName()) {
- result.setChannel(ctx.channelName().getText());
+ result.setChannel(((IdentifierValue)
visit(ctx.channelName())).getValue());
}
return result;
}
-
+
@Override
public ASTNode visitShowSlaveStatus(final ShowSlaveStatusContext ctx) {
MySQLShowSlaveStatusStatement result = new
MySQLShowSlaveStatusStatement();
if (null != ctx.channelName()) {
- result.setChannel(ctx.channelName().getText());
+ result.setChannel(((IdentifierValue)
visit(ctx.channelName())).getValue());
}
return result;
}
-
+
@Override
public ASTNode visitCreateResourceGroup(final CreateResourceGroupContext
ctx) {
MySQLCreateResourceGroupStatement result = new
MySQLCreateResourceGroupStatement();
@@ -809,7 +876,17 @@ public final class MySQLDALStatementSQLVisitor extends
MySQLStatementSQLVisitor
result.setParameterCount(getCurrentParameterIndex());
return result;
}
-
+
+ @Override
+ public ASTNode visitShowPlugins(final ShowPluginsContext ctx) {
+ return new MySQLShowPluginsStatement();
+ }
+
+ @Override
+ public ASTNode visitShowPrivileges(final ShowPrivilegesContext ctx) {
+ return new MySQLShowPrivilegesStatement();
+ }
+
@Override
public ASTNode visitShutdown(final ShutdownContext ctx) {
return new MySQLShutdownStatement();
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowErrorsStatement.java
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCharsetStatement.java
similarity index 88%
copy from
shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowErrorsStatement.java
copy to
shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCharsetStatement.java
index 100c9d0..71b0977 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowErrorsStatement.java
+++
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCharsetStatement.java
@@ -23,8 +23,8 @@ import
org.apache.shardingsphere.sql.parser.sql.common.statement.dal.DALStatemen
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.MySQLStatement;
/**
- * MySQL show errors statement.
+ * MySQL show charset statement.
*/
@ToString
-public final class MySQLShowErrorsStatement extends AbstractSQLStatement
implements DALStatement, MySQLStatement {
+public final class MySQLShowCharsetStatement extends AbstractSQLStatement
implements DALStatement, MySQLStatement {
}
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateDatabaseStatement.java
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateDatabaseStatement.java
index d655ec4..bcf9207 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateDatabaseStatement.java
+++
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateDatabaseStatement.java
@@ -32,5 +32,5 @@ import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.MySQLSta
@ToString
public final class MySQLShowCreateDatabaseStatement extends
AbstractSQLStatement implements DALStatement, MySQLStatement {
- private String schema;
+ private String schemaName;
}
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateEventStatement.java
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateEventStatement.java
index ab92da1..b4acc15 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateEventStatement.java
+++
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateEventStatement.java
@@ -17,6 +17,8 @@
package org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal;
+import lombok.Getter;
+import lombok.Setter;
import lombok.ToString;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.AbstractSQLStatement;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.dal.DALStatement;
@@ -25,6 +27,10 @@ import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.MySQLSta
/**
* MySQL show create event statement.
*/
+@Getter
+@Setter
@ToString
public final class MySQLShowCreateEventStatement extends AbstractSQLStatement
implements DALStatement, MySQLStatement {
+
+ private String eventName;
}
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateFunctionStatement.java
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateFunctionStatement.java
index 12e172d..78f43d1 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateFunctionStatement.java
+++
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateFunctionStatement.java
@@ -17,6 +17,8 @@
package org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal;
+import lombok.Getter;
+import lombok.Setter;
import lombok.ToString;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.AbstractSQLStatement;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.dal.DALStatement;
@@ -25,6 +27,10 @@ import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.MySQLSta
/**
* MySQL show create function statement.
*/
+@Getter
+@Setter
@ToString
public final class MySQLShowCreateFunctionStatement extends
AbstractSQLStatement implements DALStatement, MySQLStatement {
+
+ private String functionName;
}
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateProcedureStatement.java
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateProcedureStatement.java
index 8b16e30..f6e7268 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateProcedureStatement.java
+++
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateProcedureStatement.java
@@ -17,6 +17,8 @@
package org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal;
+import lombok.Getter;
+import lombok.Setter;
import lombok.ToString;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.AbstractSQLStatement;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.dal.DALStatement;
@@ -25,6 +27,10 @@ import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.MySQLSta
/**
* MySQL show create procedure statement.
*/
+@Getter
+@Setter
@ToString
public final class MySQLShowCreateProcedureStatement extends
AbstractSQLStatement implements DALStatement, MySQLStatement {
+
+ private String procedureName;
}
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateViewStatement.java
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateViewStatement.java
index 351fdd9..fb9a26a 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateViewStatement.java
+++
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateViewStatement.java
@@ -17,6 +17,8 @@
package org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal;
+import lombok.Getter;
+import lombok.Setter;
import lombok.ToString;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.AbstractSQLStatement;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.dal.DALStatement;
@@ -25,6 +27,10 @@ import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.MySQLSta
/**
* MySQL show create view statement.
*/
+@Getter
+@Setter
@ToString
public final class MySQLShowCreateViewStatement extends AbstractSQLStatement
implements DALStatement, MySQLStatement {
+
+ private String viewName;
}
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateDatabaseStatement.java
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowEngineStatement.java
similarity index 86%
copy from
shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateDatabaseStatement.java
copy to
shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowEngineStatement.java
index d655ec4..65c1143 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateDatabaseStatement.java
+++
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowEngineStatement.java
@@ -25,12 +25,12 @@ import
org.apache.shardingsphere.sql.parser.sql.common.statement.dal.DALStatemen
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.MySQLStatement;
/**
- * MySQL show create database statement.
+ * MySQL show engine statement.
*/
@Getter
@Setter
@ToString
-public final class MySQLShowCreateDatabaseStatement extends
AbstractSQLStatement implements DALStatement, MySQLStatement {
+public final class MySQLShowEngineStatement extends AbstractSQLStatement
implements DALStatement, MySQLStatement {
- private String schema;
+ private String engineName;
}
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowErrorsStatement.java
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowEnginesStatement.java
similarity index 88%
copy from
shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowErrorsStatement.java
copy to
shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowEnginesStatement.java
index 100c9d0..c55b327 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowErrorsStatement.java
+++
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowEnginesStatement.java
@@ -23,8 +23,8 @@ import
org.apache.shardingsphere.sql.parser.sql.common.statement.dal.DALStatemen
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.MySQLStatement;
/**
- * MySQL show errors statement.
+ * MySQL show engines statement.
*/
@ToString
-public final class MySQLShowErrorsStatement extends AbstractSQLStatement
implements DALStatement, MySQLStatement {
+public final class MySQLShowEnginesStatement extends AbstractSQLStatement
implements DALStatement, MySQLStatement {
}
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowErrorsStatement.java
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowErrorsStatement.java
index 100c9d0..5296432 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowErrorsStatement.java
+++
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowErrorsStatement.java
@@ -17,7 +17,10 @@
package org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal;
+import lombok.Getter;
+import lombok.Setter;
import lombok.ToString;
+import
org.apache.shardingsphere.sql.parser.sql.common.segment.dml.pagination.limit.LimitSegment;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.AbstractSQLStatement;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.dal.DALStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.MySQLStatement;
@@ -25,6 +28,10 @@ import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.MySQLSta
/**
* MySQL show errors statement.
*/
+@Getter
+@Setter
@ToString
public final class MySQLShowErrorsStatement extends AbstractSQLStatement
implements DALStatement, MySQLStatement {
+
+ private LimitSegment limit;
}
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateDatabaseStatement.java
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowFunctionCodeStatement.java
similarity index 86%
copy from
shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateDatabaseStatement.java
copy to
shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowFunctionCodeStatement.java
index d655ec4..985c647 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateDatabaseStatement.java
+++
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowFunctionCodeStatement.java
@@ -25,12 +25,12 @@ import
org.apache.shardingsphere.sql.parser.sql.common.statement.dal.DALStatemen
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.MySQLStatement;
/**
- * MySQL show create database statement.
+ * MySQL show function code statement.
*/
@Getter
@Setter
@ToString
-public final class MySQLShowCreateDatabaseStatement extends
AbstractSQLStatement implements DALStatement, MySQLStatement {
+public final class MySQLShowFunctionCodeStatement extends AbstractSQLStatement
implements DALStatement, MySQLStatement {
- private String schema;
+ private String functionName;
}
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowErrorsStatement.java
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowGrantsStatement.java
similarity index 92%
copy from
shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowErrorsStatement.java
copy to
shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowGrantsStatement.java
index 100c9d0..4967ef4 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowErrorsStatement.java
+++
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowGrantsStatement.java
@@ -23,8 +23,8 @@ import
org.apache.shardingsphere.sql.parser.sql.common.statement.dal.DALStatemen
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.MySQLStatement;
/**
- * MySQL show errors statement.
+ * MySQL show grants statement.
*/
@ToString
-public final class MySQLShowErrorsStatement extends AbstractSQLStatement
implements DALStatement, MySQLStatement {
+public final class MySQLShowGrantsStatement extends AbstractSQLStatement
implements DALStatement, MySQLStatement {
}
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateViewStatement.java
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowMasterStatusStatement.java
similarity index 88%
copy from
shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateViewStatement.java
copy to
shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowMasterStatusStatement.java
index 351fdd9..551b67c 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateViewStatement.java
+++
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowMasterStatusStatement.java
@@ -23,8 +23,8 @@ import
org.apache.shardingsphere.sql.parser.sql.common.statement.dal.DALStatemen
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.MySQLStatement;
/**
- * MySQL show create view statement.
+ * MySQL show master status statement.
*/
@ToString
-public final class MySQLShowCreateViewStatement extends AbstractSQLStatement
implements DALStatement, MySQLStatement {
+public final class MySQLShowMasterStatusStatement extends AbstractSQLStatement
implements DALStatement, MySQLStatement {
}
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowErrorsStatement.java
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowPluginsStatement.java
similarity index 88%
copy from
shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowErrorsStatement.java
copy to
shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowPluginsStatement.java
index 100c9d0..bb7045a 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowErrorsStatement.java
+++
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowPluginsStatement.java
@@ -23,8 +23,8 @@ import
org.apache.shardingsphere.sql.parser.sql.common.statement.dal.DALStatemen
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.MySQLStatement;
/**
- * MySQL show errors statement.
+ * MySQL show plugins statement.
*/
@ToString
-public final class MySQLShowErrorsStatement extends AbstractSQLStatement
implements DALStatement, MySQLStatement {
+public final class MySQLShowPluginsStatement extends AbstractSQLStatement
implements DALStatement, MySQLStatement {
}
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateViewStatement.java
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowPrivilegesStatement.java
similarity index 92%
copy from
shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateViewStatement.java
copy to
shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowPrivilegesStatement.java
index 351fdd9..35bac87 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateViewStatement.java
+++
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowPrivilegesStatement.java
@@ -23,8 +23,8 @@ import
org.apache.shardingsphere.sql.parser.sql.common.statement.dal.DALStatemen
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.MySQLStatement;
/**
- * MySQL show create view statement.
+ * MySQL show privileges statement.
*/
@ToString
-public final class MySQLShowCreateViewStatement extends AbstractSQLStatement
implements DALStatement, MySQLStatement {
+public final class MySQLShowPrivilegesStatement extends AbstractSQLStatement
implements DALStatement, MySQLStatement {
}
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateDatabaseStatement.java
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowProfileStatement.java
similarity index 81%
copy from
shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateDatabaseStatement.java
copy to
shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowProfileStatement.java
index d655ec4..5a9217d 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowCreateDatabaseStatement.java
+++
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowProfileStatement.java
@@ -20,17 +20,18 @@ package
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal;
import lombok.Getter;
import lombok.Setter;
import lombok.ToString;
+import
org.apache.shardingsphere.sql.parser.sql.common.segment.dml.pagination.limit.LimitSegment;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.AbstractSQLStatement;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.dal.DALStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.MySQLStatement;
/**
- * MySQL show create database statement.
+ * MySQL show profile statement.
*/
@Getter
@Setter
@ToString
-public final class MySQLShowCreateDatabaseStatement extends
AbstractSQLStatement implements DALStatement, MySQLStatement {
+public final class MySQLShowProfileStatement extends AbstractSQLStatement
implements DALStatement, MySQLStatement {
- private String schema;
+ private LimitSegment limit;
}
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowWarningsStatement.java
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowProfilesStatement.java
similarity index 92%
copy from
shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowWarningsStatement.java
copy to
shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowProfilesStatement.java
index 04aa735..93261f6 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowWarningsStatement.java
+++
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowProfilesStatement.java
@@ -23,8 +23,8 @@ import
org.apache.shardingsphere.sql.parser.sql.common.statement.dal.DALStatemen
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.MySQLStatement;
/**
- * MySQL show warnings statement.
+ * MySQL show profiles statement.
*/
@ToString
-public final class MySQLShowWarningsStatement extends AbstractSQLStatement
implements DALStatement, MySQLStatement {
+public final class MySQLShowProfilesStatement extends AbstractSQLStatement
implements DALStatement, MySQLStatement {
}
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowRelaylogEventsStatement.java
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowRelaylogEventsStatement.java
index a6202cd..91f7246 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowRelaylogEventsStatement.java
+++
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowRelaylogEventsStatement.java
@@ -20,6 +20,7 @@ package
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal;
import lombok.Getter;
import lombok.Setter;
import lombok.ToString;
+import
org.apache.shardingsphere.sql.parser.sql.common.segment.dml.pagination.limit.LimitSegment;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.AbstractSQLStatement;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.dal.DALStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.MySQLStatement;
@@ -34,5 +35,7 @@ public final class MySQLShowRelaylogEventsStatement extends
AbstractSQLStatement
private String logName;
+ private LimitSegment limit;
+
private String channel;
}
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowWarningsStatement.java
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowWarningsStatement.java
index 04aa735..2a1ec3d 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowWarningsStatement.java
+++
b/shardingsphere-sql-parser/shardingsphere-sql-parser-statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/mysql/dal/MySQLShowWarningsStatement.java
@@ -17,7 +17,10 @@
package org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.dal;
+import lombok.Getter;
+import lombok.Setter;
import lombok.ToString;
+import
org.apache.shardingsphere.sql.parser.sql.common.segment.dml.pagination.limit.LimitSegment;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.AbstractSQLStatement;
import
org.apache.shardingsphere.sql.parser.sql.common.statement.dal.DALStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.MySQLStatement;
@@ -25,6 +28,10 @@ import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.mysql.MySQLSta
/**
* MySQL show warnings statement.
*/
+@Getter
+@Setter
@ToString
public final class MySQLShowWarningsStatement extends AbstractSQLStatement
implements DALStatement, MySQLStatement {
+
+ private LimitSegment limit;
}
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/asserts/statement/dal/impl/ShowProcedureCodeStatementAssert.java
b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/asserts/statement/dal/impl/ShowProcedureCodeStatementAssert.java
index 0c61c92..45b3c02 100644
---
a/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/asserts/statement/dal/impl/ShowProcedureCodeStatementAssert.java
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/asserts/statement/dal/impl/ShowProcedureCodeStatementAssert.java
@@ -24,7 +24,6 @@ import
org.apache.shardingsphere.test.sql.parser.parameterized.asserts.SQLCaseAs
import
org.apache.shardingsphere.test.sql.parser.parameterized.asserts.segment.expression.ExpressionAssert;
import
org.apache.shardingsphere.test.sql.parser.parameterized.jaxb.cases.domain.statement.dal.ShowProcedureCodeStatementTestCase;
-
/**
* Show procedure code statement assert.
*/
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/dal/show.xml
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/dal/show.xml
index 472e8e2..70dadaf 100644
---
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/dal/show.xml
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/dal/show.xml
@@ -839,4 +839,29 @@
<row-count value="2" literal-start-index="27"
literal-stop-index="27" />
</limit>
</show-binlog-events>
+ <show sql-case-id="show_engine_status" />
+ <show sql-case-id="show_engine_mutex" />
+ <show sql-case-id="show_binary_logs" />
+ <show sql-case-id="show_master_logs" />
+ <show sql-case-id="show_engines" />
+ <show sql-case-id="show_storage_engines" />
+ <show sql-case-id="show_create_database" />
+ <show sql-case-id="show_create_database_if_not_exist" />
+ <show sql-case-id="show_create_schema" />
+ <show sql-case-id="show_create_schema_if_not_exist" />
+ <show sql-case-id="show_create_event" />
+ <show sql-case-id="show_create_function" />
+ <show sql-case-id="show_create_proc" />
+ <show sql-case-id="show_create_view" />
+ <show sql-case-id="show_function_code" />
+ <show sql-case-id="show_grants_for" />
+ <show sql-case-id="show_grants_for_using" />
+ <show sql-case-id="show_master_status" />
+ <show sql-case-id="show_plugins" />
+ <show sql-case-id="show_processlist" />
+ <show sql-case-id="show_profile" />
+ <show sql-case-id="show_profiles" />
+ <show sql-case-id="show_charset" />
+ <show sql-case-id="show_warnings_limit" />
+ <show sql-case-id="show_warnings_count" />
</sql-parser-test-cases>
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/dal/show.xml
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/dal/show.xml
index 393af1c..6005c50 100644
---
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/dal/show.xml
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/dal/show.xml
@@ -57,7 +57,7 @@
<sql-case id="show_procedure_code_owner_func" value="SHOW PROCEDURE CODE
TEST_USER.TEST_FUNC" db-types="MySQL" />
<sql-case id="show_relaylog_events" value="SHOW RELAYLOG EVENTS FOR
CHANNEL TEST_CHANNEL" db-types="MySQL" />
<sql-case id="show_relaylog_events_with_log" value="SHOW RELAYLOG EVENTS
IN 'TEST_LOG' FOR CHANNEL TEST_CHANNEL" db-types="MySQL" />
- <sql-case id="show_slave_hosts" value="SHOW SLAVE HOST" db-types="MySQL" />
+ <sql-case id="show_slave_hosts" value="SHOW SLAVE HOSTS" db-types="MySQL"
/>
<sql-case id="show_replica_status" value="SHOW REPLICA STATUS"
db-types="MySQL" />
<sql-case id="show_replica_status_with_channel" value="SHOW REPLICA STATUS
FOR CHANNEL TEST_CHANNEL" db-types="MySQL" />
<sql-case id="show_slave_status" value="SHOW SLAVE STATUS"
db-types="MySQL" />
@@ -116,4 +116,29 @@
<sql-case id="show_binlog_events_with_log_name" value="SHOW BINLOG EVENTS
IN 'log_name'" db-types="MySQL" />
<sql-case id="show_binlog_events_with_from_pos" value="SHOW BINLOG EVENTS
FROM 1" db-types="MySQL" />
<sql-case id="show_binlog_events_with_limit" value="SHOW BINLOG EVENTS
LIMIT 1,2" db-types="MySQL" />
+ <sql-case id="show_engine_status" value="SHOW ENGINE INNODB STATUS"
db-types="MySQL" />
+ <sql-case id="show_engine_mutex" value="SHOW ENGINE INNODB MUTEX"
db-types="MySQL" />
+ <sql-case id="show_binary_logs" value="SHOW BINARY LOGS" db-types="MySQL"
/>
+ <sql-case id="show_master_logs" value="SHOW MASTER LOGS" db-types="MySQL"
/>
+ <sql-case id="show_engines" value="SHOW ENGINES" db-types="MySQL" />
+ <sql-case id="show_storage_engines" value="SHOW STORAGE ENGINES"
db-types="MySQL" />
+ <sql-case id="show_create_database" value="SHOW CREATE DATABASE
schema_name" db-types="MySQL" />
+ <sql-case id="show_create_database_if_not_exist" value="SHOW CREATE
DATABASE IF NOT EXISTS schema_name" db-types="MySQL" />
+ <sql-case id="show_create_schema" value="SHOW CREATE SCHEMA schema_name"
db-types="MySQL" />
+ <sql-case id="show_create_schema_if_not_exist" value="SHOW CREATE SCHEMA
IF NOT EXISTS schema_name" db-types="MySQL" />
+ <sql-case id="show_create_event" value="SHOW CREATE EVENT event_name"
db-types="MySQL" />
+ <sql-case id="show_create_function" value="SHOW CREATE FUNCTION
function_name" db-types="MySQL" />
+ <sql-case id="show_create_proc" value="SHOW CREATE PROCEDURE proc_name"
db-types="MySQL" />
+ <sql-case id="show_create_view" value="SHOW CREATE VIEW view_name"
db-types="MySQL" />
+ <sql-case id="show_function_code" value="SHOW FUNCTION CODE function_name"
db-types="MySQL" />
+ <sql-case id="show_grants_for" value="SHOW GRANTS FOR
'jeffrey'@'localhost'" db-types="MySQL" />
+ <sql-case id="show_grants_for_using" value="SHOW GRANTS FOR
'u1'@'localhost' USING 'r1'" db-types="MySQL" />
+ <sql-case id="show_master_status" value="SHOW MASTER STATUS"
db-types="MySQL" />
+ <sql-case id="show_plugins" value="SHOW PLUGINS" db-types="MySQL" />
+ <sql-case id="show_processlist" value="SHOW FULL PROCESSLIST"
db-types="MySQL" />
+ <sql-case id="show_profile" value="SHOW PROFILE LIMIT 1, 2"
db-types="MySQL" />
+ <sql-case id="show_profiles" value="SHOW PROFILES" db-types="MySQL" />
+ <sql-case id="show_charset" value="SHOW CHARSET" db-types="MySQL" />
+ <sql-case id="show_warnings_limit" value="SHOW WARNINGS limit 1"
db-types="MySQL" />
+ <sql-case id="show_warnings_count" value="SHOW COUNT(*) WARNINGS"
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 4f30640..95b8ccd 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
@@ -5791,17 +5791,6 @@
<sql-case id="set_by_mysql_source_test_case60" value="SET @start_value=
@@global.syseventlog.tag" db-types="MySQL"/>
<sql-case id="set_by_mysql_source_test_case61" value="SET
@str_ascii=_ASCII'abcxyz'" db-types="MySQL"/>
<sql-case id="set_by_mysql_source_test_case62" value="SET @x:= (SELECT h
FROM t1 WHERE (a,b,c,d,e,f,g)=(1,2,3,4,5,6,7))" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case1" value="SHOW CREATE DATABASE
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa"
db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case2" value="SHOW CREATE DATABASE
db_charset_koi8r" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case3" value="SHOW CREATE DATABASE
mysqltest1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case4" value="SHOW CREATE DATABASE
mysqltest1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case5" value="SHOW CREATE DATABASE
mysqltest2" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case6" value="SHOW CREATE DATABASE
test" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case7" value="SHOW CREATE DATABASE
test1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case8" value="SHOW CREATE SCHEMA
s" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case9" value="SHOW CREATE SCHEMA
s" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case10" value="SHOW CREATE SCHEMA
s" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case11" value="SHOW CREATE SCHEMA
s" db-types="MySQL"/>
<sql-case id="show_by_mysql_source_test_case12" value="SHOW CREATE TABLE
```a`" db-types="MySQL"/>
<sql-case id="show_by_mysql_source_test_case13" value="SHOW CREATE TABLE
```ab````cd```" db-types="MySQL"/>
<sql-case id="show_by_mysql_source_test_case14" value="SHOW CREATE TABLE
```ab``cd```" db-types="MySQL"/>
@@ -5810,272 +5799,6 @@
<sql-case id="show_by_mysql_source_test_case17" value="SHOW CREATE USER
[email protected]" db-types="MySQL"/>
<sql-case id="show_by_mysql_source_test_case18" value="SHOW CREATE USER
[email protected]" db-types="MySQL"/>
<sql-case id="show_by_mysql_source_test_case19" value="SHOW CREATE USER
[email protected]" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case20" value="SHOW CREATE USER
[email protected]" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case21" value="SHOW EVENTS FROM
``" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case22" value="SHOW FUNCTION CODE
TESTF_bug11763507" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case23" value="SHOW FUNCTION CODE
f1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case24" value="SHOW FUNCTION CODE
f2" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case25" value="SHOW FUNCTION CODE
f3" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case26" value="SHOW FUNCTION CODE
f4" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case27" value="SHOW FUNCTION CODE
f5" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case28" value="SHOW FUNCTION CODE
f6" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case29" value="SHOW FUNCTION CODE
testdb.func_definer" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case30" value="SHOW FUNCTION CODE
testdb.func_definer" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case31" value="SHOW FUNCTION CODE
testdb.func_definer" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case32" value="SHOW FUNCTION CODE
testdb.func_definer" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case33" value="SHOW FUNCTION CODE
testdb.func_definer" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case34" value="SHOW FUNCTION CODE
testdb.func_definer" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case35" value="SHOW FUNCTION CODE
testdb.func_definer" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case36" value="SHOW FUNCTION CODE
testdb.func_definer" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case37" value="SHOW FUNCTION CODE
testdb.func_definer" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case38" value="SHOW FUNCTION CODE
testdb.func_definer" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case39" value="SHOW FUNCTION CODE
testdb.func_root" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case40" value="SHOW FUNCTION CODE
testdb.func_root" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case41" value="SHOW FUNCTION CODE
testdb.func_root" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case42" value="SHOW FUNCTION CODE
testdb.func_root" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case43" value="SHOW FUNCTION CODE
testdb.func_root" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case44" value="SHOW FUNCTION CODE
testdb.func_root" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case45" value="SHOW FUNCTION CODE
testdb.func_root" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case46" value="SHOW FUNCTION CODE
testdb.func_root" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case47" value="SHOW FUNCTION CODE
testdb.func_root" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case48" value="SHOW FUNCTION CODE
testdb.func_root" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case49" value="SHOW FUNCTION CODE
testf_bug11763507" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case50" value="SHOW GRANTS FOR
"mysql.session"@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case51" value="SHOW GRANTS FOR
"mysql.session"@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case52" value="SHOW GRANTS FOR
''@''" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case53" value="SHOW GRANTS FOR
'joe_schema_designer'@'localhost' USING
'db_admin'" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case54" value="SHOW GRANTS FOR
'joe_schema_designer'@'localhost' USING
'schema_designer'" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case55" value="SHOW GRANTS FOR
'kristofer'@'localhost'" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case56" value="SHOW GRANTS FOR
'kristofer'@'localhost'" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case57" value="SHOW GRANTS FOR
'kristofer'@'localhost'" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case58" value="SHOW GRANTS FOR
'kristofer'@'localhost'" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case59" value="SHOW GRANTS FOR
'kristofer'@'localhost'" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case60" value="SHOW GRANTS FOR
'kristofer'@'localhost'" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case61" value="SHOW GRANTS FOR
'kristofer'@'localhost'" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case62" value="SHOW GRANTS FOR
'kristofer'@'localhost'" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case63" value="SHOW GRANTS FOR
'kristofer'@'localhost'" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case64" value="SHOW GRANTS FOR
'kristofer'@'localhost'" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case65" value="SHOW GRANTS FOR
'select_only_c1'@'localhost'" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case66" value="SHOW GRANTS FOR
'select_only_c1'@'localhost'" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case67" value="SHOW GRANTS FOR
'show_view_tbl'@'localhost'" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case68" value="SHOW GRANTS FOR
'user2'@'%'" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case69" value="SHOW GRANTS FOR
'user2'@'%'" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case70" value="SHOW GRANTS FOR
'user3'@'%'" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case71" value="SHOW GRANTS FOR
CURRENT_USER() USING `admin-db1`" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case72" value="SHOW GRANTS FOR
CURRENT_USER() USING `db_admin`" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case73" value="SHOW GRANTS FOR
CURRENT_USER() USING db_admin" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case74" value="SHOW GRANTS FOR
CURRENT_USER() USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case75" value="SHOW GRANTS FOR
`TestUserFails`@`localhost`" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case76" value="SHOW GRANTS FOR
`joe`@`localhost`" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case77" value="SHOW GRANTS FOR
`joe`@`localhost`" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case78" value="SHOW GRANTS FOR
`joe`@`localhost` USING `replication`" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case79" value="SHOW GRANTS FOR
`joe`@`localhost` USING engineering" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case80" value="SHOW GRANTS FOR
`joe`@`localhost` USING engineering" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case81" value="SHOW GRANTS FOR
`joe`@`localhost` USING role1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case82" value="SHOW GRANTS FOR
`joe`@`localhost` USING wp_administrators" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case83" value="SHOW GRANTS FOR
`r_verifier`@`localhost`" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case84" value="SHOW GRANTS FOR
`root`@`localhost` USING `replication`" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case85" value="SHOW GRANTS FOR
`u1`@`%`" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case86" value="SHOW GRANTS FOR
`u1`@`%`" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case87" value="SHOW GRANTS FOR
`u1`@`localhost`" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case88" value="SHOW GRANTS FOR
`u1`@`localhost`" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case89" value="SHOW GRANTS FOR
`wp_administrators`" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case90" value="SHOW GRANTS FOR
bug23721446_u1@'%'" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case91" value="SHOW GRANTS FOR
bug23721446_u1@'%'" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case92" value="SHOW GRANTS FOR
bug23721446_u2@'%'" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case93" value="SHOW GRANTS FOR
bug23721446_u2@'%'" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case94" value="SHOW GRANTS FOR
current_user() USING `engineering`@`%`,`role`@`%`" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case95" value="SHOW GRANTS FOR
current_user() USING `replication`" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case96" value="SHOW GRANTS FOR
grant_plug" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case97" value="SHOW GRANTS FOR
grant_plug" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case98" value="SHOW GRANTS FOR
mysqltest_1@'127.0.0.1/255.255.255.255'" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case99" value="SHOW GRANTS FOR
mysqltest_u1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case100" value="SHOW GRANTS FOR
root@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case101" value="SHOW GRANTS FOR
root@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case102" value="SHOW GRANTS FOR
root@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case103" value="SHOW GRANTS FOR
root@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case104" value="SHOW GRANTS FOR
root@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case105" value="SHOW GRANTS FOR
root@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case106" value="SHOW GRANTS FOR
root@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case107" value="SHOW GRANTS FOR
root@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case108" value="SHOW GRANTS FOR
root@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case109" value="SHOW GRANTS FOR
root@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case110" value="SHOW GRANTS FOR
root@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case111" value="SHOW GRANTS FOR
root@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case112" value="SHOW GRANTS FOR
root@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case113" value="SHOW GRANTS FOR
root@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case114" value="SHOW GRANTS FOR
root@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case115" value="SHOW GRANTS FOR
root@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case116" value="SHOW GRANTS FOR
root@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case117" value="SHOW GRANTS FOR
root@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case118" value="SHOW GRANTS FOR
sally USING consultants" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case119" value="SHOW GRANTS FOR
sally USING consultants" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case120" value="SHOW GRANTS FOR
sally USING engineering" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case121" value="SHOW GRANTS FOR
sally USING engineering" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case122" value="SHOW GRANTS FOR
sally USING engineering" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case123" value="SHOW GRANTS FOR
sally USING engineering, consultants" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case124" value="SHOW GRANTS FOR
sally USING engineering, consultants" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case125" value="SHOW GRANTS FOR
sheldon" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case126" value="SHOW GRANTS FOR
sheldon" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case127" value="SHOW GRANTS FOR
some_user_name@host_1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890"
db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case128" value="SHOW GRANTS FOR
some_user_name@host_1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890"
db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case129" value="SHOW GRANTS FOR
some_user_name@host_1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890"
db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case130" value="SHOW GRANTS FOR
some_user_name@host_1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890"
db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case131" value="SHOW GRANTS FOR
some_user_name@host_1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890"
db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case132" value="SHOW GRANTS FOR
some_user_name@host_1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890X"
db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case133" value="SHOW GRANTS FOR
test_drop@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case134" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case135" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case136" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case137" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case138" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case139" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case140" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case141" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case142" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case143" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case144" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case145" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case146" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case147" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case148" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case149" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case150" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case151" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case152" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case153" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case154" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case155" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case156" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case157" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case158" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case159" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case160" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case161" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case162" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case163" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case164" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case165" value="SHOW GRANTS FOR
u1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case166" value="SHOW GRANTS FOR u1
using r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case167" value="SHOW GRANTS FOR u1
using r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case168" value="SHOW GRANTS FOR u1
using r2" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case169" value="SHOW GRANTS FOR
u1@`%`" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case170" value="SHOW GRANTS FOR
u1@`%` USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case171" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case172" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case173" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case174" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case175" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case176" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case177" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case178" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case179" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case180" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case181" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case182" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case183" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case184" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case185" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case186" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case187" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case188" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case189" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case190" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case191" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case192" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case193" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case194" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case195" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case196" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case197" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case198" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case199" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case200" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case201" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case202" value="SHOW GRANTS FOR
u1@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case203" value="SHOW GRANTS FOR
u1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case204" value="SHOW GRANTS FOR
u1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case205" value="SHOW GRANTS FOR
u1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case206" value="SHOW GRANTS FOR
u1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case207" value="SHOW GRANTS FOR
u1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case208" value="SHOW GRANTS FOR
u1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case209" value="SHOW GRANTS FOR
u1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case210" value="SHOW GRANTS FOR
u1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case211" value="SHOW GRANTS FOR
u1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case212" value="SHOW GRANTS FOR
u1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case213" value="SHOW GRANTS FOR
u1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case214" value="SHOW GRANTS FOR
u1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case215" value="SHOW GRANTS FOR
u1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case216" value="SHOW GRANTS FOR
u1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case217" value="SHOW GRANTS FOR
u1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case218" value="SHOW GRANTS FOR
u1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case219" value="SHOW GRANTS FOR
u1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case220" value="SHOW GRANTS FOR
u1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case221" value="SHOW GRANTS FOR
u1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case222" value="SHOW GRANTS FOR
u1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case223" value="SHOW GRANTS FOR
u1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case224" value="SHOW GRANTS FOR
u1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case225" value="SHOW GRANTS FOR
u1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case226" value="SHOW GRANTS FOR
u1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case227" value="SHOW GRANTS FOR
u1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case228" value="SHOW GRANTS FOR
u1@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case229" value="SHOW GRANTS FOR
u1@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case230" value="SHOW GRANTS FOR
u1@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case231" value="SHOW GRANTS FOR
u1@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case232" value="SHOW GRANTS FOR
u1@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case233" value="SHOW GRANTS FOR
u1@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case234" value="SHOW GRANTS FOR
u1@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case235" value="SHOW GRANTS FOR
u1@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case236" value="SHOW GRANTS FOR
u1@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case237" value="SHOW GRANTS FOR
u1@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case238" value="SHOW GRANTS FOR
u1@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case239" value="SHOW GRANTS FOR
u1@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case240" value="SHOW GRANTS FOR
u1@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case241" value="SHOW GRANTS FOR
u1@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case242" value="SHOW GRANTS FOR
u1@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case243" value="SHOW GRANTS FOR
u1@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case244" value="SHOW GRANTS FOR
u1@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case245" value="SHOW GRANTS FOR
u1@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case246" value="SHOW GRANTS FOR
u1@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case247" value="SHOW GRANTS FOR
u1@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case248" value="SHOW GRANTS FOR
u1@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case249" value="SHOW GRANTS FOR
u1@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case250" value="SHOW GRANTS FOR
u1@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case251" value="SHOW GRANTS FOR
u1@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case252" value="SHOW GRANTS FOR
u1@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case253" value="SHOW GRANTS FOR
u1@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case254" value="SHOW GRANTS FOR
u1@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case255" value="SHOW GRANTS FOR
u1@localhost USING r1,r2" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case256" value="SHOW GRANTS FOR
u1@localhost USING r1,r2" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case257" value="SHOW GRANTS FOR
u1@localhost USING r1,r2" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case258" value="SHOW GRANTS FOR
u1@localhost USING r1,r2" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case259" value="SHOW GRANTS FOR
u1@localhost USING r1,r2" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case260" value="SHOW GRANTS FOR
u1@localhost USING r1,r2" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case261" value="SHOW GRANTS FOR
u1@localhost USING r1,r2" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case262" value="SHOW GRANTS FOR
u1@localhost USING r1,r2" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case263" value="SHOW GRANTS FOR
u1@localhost USING u1234567890123456789012345678901" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case264" value="SHOW GRANTS FOR
u2" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case265" value="SHOW GRANTS FOR
u2" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case266" value="SHOW GRANTS FOR
u2" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case267" value="SHOW GRANTS FOR
u2" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case268" value="SHOW GRANTS FOR
u2" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case269" value="SHOW GRANTS FOR
u2@h" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case270" value="SHOW GRANTS FOR
u2@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case271" value="SHOW GRANTS FOR
u2@localhost USING r1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case272" value="SHOW GRANTS FOR
u3@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case273" value="SHOW GRANTS FOR
u_worldrou@localhost USING r_worldrou" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case274" value="SHOW GRANTS FOR
untrusted@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case275" value="SHOW GRANTS FOR
user1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case276" value="SHOW GRANTS FOR
user1" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case277" value="SHOW GRANTS FOR
user1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case278" value="SHOW GRANTS FOR
user1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case279" value="SHOW GRANTS FOR
user1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case280" value="SHOW GRANTS FOR
user1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case281" value="SHOW GRANTS FOR
user1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case282" value="SHOW GRANTS FOR
user1@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case283" value="SHOW GRANTS for
"mysql.session"@localhost" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case284" value="SHOW RELAYLOG
EVENTS" db-types="MySQL"/>
- <sql-case id="show_by_mysql_source_test_case285" value="SHOW SLAVE HOSTS"
db-types="MySQL"/>
<sql-case id="signal_by_mysql_source_test_case1" value="SIGNAL SQLSTATE
'00000'" db-types="MySQL"/>
<sql-case id="signal_by_mysql_source_test_case2" value="SIGNAL SQLSTATE
'00001'" db-types="MySQL"/>
<sql-case id="signal_by_mysql_source_test_case3" value="SIGNAL SQLSTATE
'01000'" db-types="MySQL"/>
@@ -9052,64 +8775,10 @@
<sql-case id="low_set_by_mysql_source_test_case74" value="set global
sql_mode=repeat('a',80)" db-types="MySQL"/>
<sql-case id="low_set_by_mysql_source_test_case75" value="set res:=
(select count(*) from t1)" db-types="MySQL"/>
<sql-case id="low_set_by_mysql_source_test_case76" value="set session
@honk=99" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case1" value="show create
database `#mysql50#mysqltest-1`" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case2" value="show create
database `#mysql50#mysqltest-1`" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case3" value="show create
database `mysqltest-1`" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case4" value="show create
database `mysqltest1`" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case5" value="show create
database `mysqltest1`" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case6" value="show create
database information_schema" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case7" value="show create
database mysql_TEST" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case8" value="show create
database mysqltest" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case9" value="show create
database mysqltest" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case10" value="show create
database mysqltest" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case11" value="show create
database mysqltest" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case12" value="show create
database mysqltest" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case13" value="show create
database mysqltest2" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case14" value="show create
database mysqltest2" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case15" value="show create
database mysqltest2" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case16" value="show create
database mysqltest2" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case17" value="show create
database test" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case18" value="show create
schema foo" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case19" value="show function
code almost_empty" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case20" value="show function
code foo" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case21" value="show function
code signal_func" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case22" value="show grants for
'%@a'@'a'" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case23" value="show grants for
'%@b'@'b'" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case24" value="show grants for
'%@b'@'b'" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case25" value="show grants for
'%@b'@'b'" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case26" value="show grants for
'mysqltest_1'" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case27" value="show grants for
'mysqltest_1'" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case28" value="show grants for
'mysqltest_1'" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case29" value="show grants for
'mysqltest_1'" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case30" value="show grants for
'mysqltest_1'" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case31" value="show grants for
'mysqltest_1'" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case32" value="show grants for
'mysqltest_2'" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case33" value="show grants for
mysqltest_1@localhost" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case34" value="show grants for
mysqltest_1@localhost" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case35" value="show grants for
mysqltest_1@localhost" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case36" value="show grants for
mysqltest_1@localhost" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case37" value="show grants for
mysqltest_2@localhost" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case38" value="show grants for
second_user@localhost" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case39" value="show grants for
second_user@localhost" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case40" value="show grants for
second_user@localhost" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case41" value="show grants for
second_user@localhost" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case42" value="show grants for
second_user@localhost" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case43" value="show grants for
second_user@localhost" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case44" value="show grants for
second_user@localhost" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case45" value="show grants for
second_user@localhost" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case46" value="show grants for
second_user@localhost" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case47" value="show grants for
test@localhost" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case48" value="show grants for
test@localhost" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case49" value="show grants for
usera@localhost" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case50" value="show grants for
userb@localhost" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case51" value="show grants for
userb@localhost" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case52" value="show grants for
userc@localhost" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case53" value="show grants for
userc@localhost" db-types="MySQL"/>
<sql-case id="low_show_by_mysql_source_test_case54" value="show local
variables like 'SQL_MODE'" db-types="MySQL"/>
<sql-case id="low_show_by_mysql_source_test_case55" value="show local
variables like 'SQL_MODE'" db-types="MySQL"/>
<sql-case id="low_show_by_mysql_source_test_case56" value="show local
variables like 'default_storage_engine'" db-types="MySQL"/>
<sql-case id="low_show_by_mysql_source_test_case57" value="show local
variables like 'default_storage_engine'" db-types="MySQL"/>
- <sql-case id="low_show_by_mysql_source_test_case58" value="show slave
hosts" db-types="MySQL"/>
<sql-case id="low_some_by_mysql_source_test_case1" value="some text
remove_file $MYSQLD_LOG" db-types="MySQL"/>
<sql-case id="low_some_by_mysql_source_test_case2" value="some text
remove_file $MYSQLD_LOG" db-types="MySQL"/>
<sql-case id="low_unlock_by_mysql_source_test_case1" value="unlock table"
db-types="MySQL"/>
