public class SyntaxRegressionTest extends BaseTestCase
BaseTestCase.MockConnectionConfigurationconn, dbClass, dbName, dbUrl, isOpenSSL, mainConnectionUrl, pstmt, rs, serverVersion, stmt, timeZoneFreeDbUrl| Constructor and Description |
|---|
SyntaxRegressionTest() |
| Modifier and Type | Method and Description |
|---|---|
private void |
copyFile(java.io.File source,
java.io.File dest) |
void |
testAlterTableAlgorithmLock()
ALTER TABLE syntax changed in 5.6GA
ALTER TABLE ...
|
void |
testCreateTableDataDirectory()
CREATE TABLE syntax changed in 5.6GA
InnoDB: Allow the location of file-per-table tablespaces to be chosen
CREATE TABLE ...
|
void |
testCreateTablespace()
WL#6205 - InnoDB: Implement CREATE TABLESPACE for general use.
|
private void |
testCreateTablespaceCheckTables(java.lang.String tablespace,
int expectedTblCount) |
private void |
testCreateTablespaceCheckTablespaces(int expectedTsCount) |
void |
testDiscardImportPartitions()
WL#6868 - Support transportable tablespaces for single innodb partition.
|
void |
testExchangePartition()
Test case for ALTER [IGNORE] TABLE t1 EXCHANGE PARTITION p1 WITH TABLE t2 syntax
|
void |
testExplicitPartitions()
Test for explicit partition selection syntax
|
void |
testFULLTEXTSearchInnoDB()
WL#5538 - InnoDB Full-Text Search Support
CREATE TABLE syntax changed in 5.6GA
InnoDB engine accepts FULLTEXT indexes.
|
void |
testGcsReplicationCmds()
WL#8252 - GCS Replication: Plugin [SERVER CHANGES]
Test syntax for GCS Replication commands:
- START GROUP_REPLICATION
- STOP GROUP_REPLICATION
|
void |
testGetStackedDiagnostics()
WL#6406 - Stacked diagnostic areas
"STACKED" in "GET [CURRENT | STACKED] DIAGNOSTICS" syntax was added in 5.7.0.
|
void |
testGisFunctions()
WL#1326 - GIS: Precise spatial operations
WL#8055 - Consistent naming scheme for GIS functions - Deprecation
WL#8034 - More user friendly GIS functions
WL#7541 - GIS MBR spatial operations enhancement
WL#8157 - Remove deprecated GIS functions
WL#8055 - Consistent naming scheme for GIS functions - Deprecation
WL#9435 - Axis order in WKB parsing functions
(...)
Test syntax for all GIS functions.
|
void |
testHints()
WL#8016 - Parser for optimizer hints.
|
private void |
testHintsSyntax(java.lang.String query,
boolean processesHint,
boolean warningExpected) |
void |
testInnodbTablespaceEncryption()
WL#8548 - InnoDB: Transparent data encryption.
|
void |
testIPv6Functions()
WL#5787 - IPv6-capable INET_ATON and INET_NTOA functions
IPv6 functions added in 5.6GA: INET6_ATON(ip) and INET6_NTOA(ip).
|
void |
testJsonType()
WL#7909 - Server side JSON functions
Test support for data type JSON.
|
private void |
testJsonTypeCheckFunction(java.lang.String sql,
java.lang.String expectedResult) |
void |
testRenameIndex()
WL#6555 - Online rename index
ALTER TABLE syntax changed in 5.7.1
Alter table allows to rename indexes.
|
void |
testSetMergeThreshold()
WL#6747 - InnoDB: make fill factor settable.
|
private void |
testSetMergeThresholdIndices(int defaultMergeThreshold,
java.util.Map<java.lang.String,java.lang.Integer> keyMergeThresholds) |
void |
testTableCompression()
WL#7696 - InnoDB: Transparent page compression.
|
void |
testTransportableTablespaces()
Test case for transportable tablespaces syntax support:
FLUSH TABLES ...
|
void |
testUserAccountLocking()
WL#6054 - Temporarily disablement of users
Test user account locking syntax:
CREATE|ALTER USER (...)
- lock_option: { ACCOUNT LOCK | ACCOUNT UNLOCK }
|
void |
testUserAccountPwdExpiration()
WL#7131 - Add timestamp in mysql.user on the last time the password was changed
Test user account password expiration syntax:
CREATE|ALTER USER (...)
- password_option: { PASSWORD EXPIRE | PASSWORD EXPIRE DEFAULT | PASSWORD EXPIRE NEVER | PASSWORD EXPIRE INTERVAL N DAY }
|
appendRequiredProperties, assertByteArrayEquals, assertConnectionsHistory, assertEqualsFSAware, assertNonSecureConnection, assertResultSetLength, assertResultSetsEqual, assertSecureConnection, assertSecureConnection, assertSessionStatusEquals, assertThrows, assertThrows, assertThrows, assertThrows, cleanupTempFiles, createDatabase, createDatabase, createFunction, createFunction, createProcedure, createProcedure, createSchemaObject, createSchemaObject, createTable, createTable, createTable, createTable, createUser, createUser, createView, createView, currentTimeMillis, dropDatabase, dropDatabase, dropFunction, dropFunction, dropProcedure, dropProcedure, dropSchemaObject, dropSchemaObject, dropTable, dropTable, dropUser, dropUser, dropView, dropView, fillPrimitiveDefaults, getConnectionWithProps, getConnectionWithProps, getConnectionWithProps, getConnectionWithProps, getEncodedHostFromTestsuiteUrl, getEncodedHostPortPairFromTestsuiteUrl, getFailoverConnection, getFailoverConnection, getHostFreePropertiesFromTestsuiteUrl, getHostFreePropertiesFromTestsuiteUrl, getHostFromTestsuiteUrl, getInstanceNumber, getLoadBalancedConnection, getLoadBalancedConnection, getLoadBalancedConnection, getMysqlVariable, getMysqlVariable, getNewConnection, getNoDbUrl, getPort, getPortFreeHostname, getPortFromTestsuiteUrl, getPropertiesFromTestsuiteUrl, getPropertiesFromUrl, getRowCount, getSingleIndexedValueWithQuery, getSingleIndexedValueWithQuery, getSingleValue, getSingleValueWithQuery, getSourceReplicaReplicationConnection, getSourceReplicaReplicationConnection, getSourceReplicaUrl, getSourceReplicaUrl, getUnreliableFailoverConnection, getUnreliableFailoverConnection, getUnreliableLoadBalancedConnection, getUnreliableLoadBalancedConnection, getUnreliableMultiHostConnection, getUnreliableReplicationConnection, getUnreliableReplicationConnection, getUnreliableReplicationConnection, isClassAvailable, isCommunityEdition, isEnterpriseEdition, isMysqlRunningLocally, isRunningOnJRockit, isServerRunningOnWindows, isSysPropDefined, logDebug, newTempBinaryFile, randomString, removeHostRelatedProps, removeSqlMode, runLongTests, setUpBase, supportsLoadLocalInfile, supportsTestCachingSha2PasswordKeys, supportsTestCertificates, supportsTestSha256PasswordKeys, supportsTimeZoneNames, supportsTLSv1_2, tearDownBase, versionMeetsMinimum, versionMeetsMinimum@Test
public void testAlterTableAlgorithmLock()
throws java.sql.SQLException
java.sql.SQLException@Test
public void testCreateTableDataDirectory()
throws java.sql.SQLException
java.sql.SQLException@Test
public void testTransportableTablespaces()
throws java.lang.Exception
java.lang.Exceptionprivate void copyFile(java.io.File source,
java.io.File dest)
throws java.io.IOException
java.io.IOException@Test
public void testExchangePartition()
throws java.lang.Exception
java.lang.Exception@Test
public void testExplicitPartitions()
throws java.lang.Exception
java.lang.Exception@Test
public void testIPv6Functions()
throws java.lang.Exception
java.lang.Exception@Test
public void testFULLTEXTSearchInnoDB()
throws java.lang.Exception
java.lang.Exception@Test
public void testRenameIndex()
throws java.lang.Exception
java.lang.Exception@Test
public void testGetStackedDiagnostics()
throws java.lang.Exception
java.lang.Exception@Test
public void testDiscardImportPartitions()
throws java.lang.Exception
java.lang.Exception@Test
public void testJsonType()
throws java.lang.Exception
java.lang.Exception@Test
private void testJsonTypeCheckFunction(java.lang.String sql,
java.lang.String expectedResult)
throws java.lang.Exception
java.lang.Exception@Test
public void testHints()
throws java.lang.Exception
java.lang.Exceptionprivate void testHintsSyntax(java.lang.String query,
boolean processesHint,
boolean warningExpected)
throws java.lang.Exception
java.lang.Exception@Test
public void testCreateTablespace()
throws java.lang.Exception
java.lang.Exception@Test
private void testCreateTablespaceCheckTablespaces(int expectedTsCount)
throws java.lang.Exception
java.lang.Exception@Test
private void testCreateTablespaceCheckTables(java.lang.String tablespace,
int expectedTblCount)
throws java.lang.Exception
java.lang.Exception@Test
public void testSetMergeThreshold()
throws java.lang.Exception
java.lang.Exception@Test
private void testSetMergeThresholdIndices(int defaultMergeThreshold,
java.util.Map<java.lang.String,java.lang.Integer> keyMergeThresholds)
throws java.lang.Exception
java.lang.Exception@Test
public void testTableCompression()
throws java.lang.Exception
java.lang.Exception@Test
public void testGisFunctions()
throws java.lang.Exception
java.lang.Exception@Test
public void testGcsReplicationCmds()
throws java.lang.Exception
java.lang.Exception@Test
public void testUserAccountLocking()
throws java.lang.Exception
java.lang.Exception@Test
public void testUserAccountPwdExpiration()
throws java.lang.Exception
java.lang.Exception@Test
public void testInnodbTablespaceEncryption()
throws java.lang.Exception
java.lang.Exception