testsuite.regression

Class SyntaxRegressionTest

java.lang.Object

testsuite.BaseTestCase

testsuite.regression.SyntaxRegressionTest

public class SyntaxRegressionTest
extends BaseTestCase

Regression tests for syntax

Nested Class Summary

Nested classes/interfaces inherited from class testsuite.BaseTestCase

BaseTestCase.MockConnectionConfiguration

Field Summary

Fields inherited from class testsuite.BaseTestCase

conn, dbClass, dbName, dbUrl, isOpenSSL, mainConnectionUrl, pstmt, rs, serverVersion, stmt, timeZoneFreeDbUrl

Constructor Summary

Constructors

Constructor and Description
SyntaxRegressionTest()

Method Summary

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 }

Methods inherited from class testsuite.BaseTestCase

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

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SyntaxRegressionTest

public SyntaxRegressionTest()

Method Detail

testAlterTableAlgorithmLock

@Test
public void testAlterTableAlgorithmLock()
                                       throws java.sql.SQLException

ALTER TABLE syntax changed in 5.6GA ALTER TABLE ... , algorithm, concurrency algorithm: | ALGORITHM [=] DEFAULT | ALGORITHM [=] INPLACE | ALGORITHM [=] COPY concurrency: | LOCK [=] DEFAULT | LOCK [=] NONE | LOCK [=] SHARED | LOCK [=] EXCLUSIVE

Throws:

java.sql.SQLException

testCreateTableDataDirectory

@Test
public void testCreateTableDataDirectory()
                                        throws java.sql.SQLException

CREATE TABLE syntax changed in 5.6GA InnoDB: Allow the location of file-per-table tablespaces to be chosen CREATE TABLE ... DATA DIRECTORY = 'absolute/path/to/directory/' Notes: - DATA DIRECTORY option can't be used with temporary tables. - DATA DIRECTORY and INDEX DIRECTORY can't be used together for InnoDB. - Using these options result in an 'option ignored' warning for servers below MySQL 5.7.7. This syntax isn't allowed for MySQL 5.7.7 and higher.

Throws:

java.sql.SQLException

testTransportableTablespaces

@Test
public void testTransportableTablespaces()
                                        throws java.lang.Exception

Test case for transportable tablespaces syntax support: FLUSH TABLES ... FOR EXPORT ALTER TABLE ... DISCARD TABLESPACE ALTER TABLE ... IMPORT TABLESPACE Requires a MySQL server running locally.

Throws:

java.lang.Exception

copyFile

private void copyFile(java.io.File source,
                      java.io.File dest)
               throws java.io.IOException

Throws:

java.io.IOException

testExchangePartition

@Test
public void testExchangePartition()
                                 throws java.lang.Exception

Test case for ALTER [IGNORE] TABLE t1 EXCHANGE PARTITION p1 WITH TABLE t2 syntax

Throws:

java.lang.Exception

testExplicitPartitions

@Test
public void testExplicitPartitions()
                                  throws java.lang.Exception

Test for explicit partition selection syntax

Throws:

java.lang.Exception

testIPv6Functions

@Test
public void testIPv6Functions()
                             throws java.lang.Exception

WL#5787 - IPv6-capable INET_ATON and INET_NTOA functions IPv6 functions added in 5.6GA: INET6_ATON(ip) and INET6_NTOA(ip).

Throws:

java.lang.Exception

testFULLTEXTSearchInnoDB

@Test
public void testFULLTEXTSearchInnoDB()
                                    throws java.lang.Exception

WL#5538 - InnoDB Full-Text Search Support CREATE TABLE syntax changed in 5.6GA InnoDB engine accepts FULLTEXT indexes. CREATE TABLE ... FULLTEXT(...) ... ENGINE=InnoDB

Throws:

java.lang.Exception

testRenameIndex

@Test
public void testRenameIndex()
                           throws java.lang.Exception

WL#6555 - Online rename index ALTER TABLE syntax changed in 5.7.1 Alter table allows to rename indexes. ALTER TABLE ... RENAME INDEX x TO y

Throws:

java.lang.Exception

testGetStackedDiagnostics

@Test
public void testGetStackedDiagnostics()
                                     throws java.lang.Exception

WL#6406 - Stacked diagnostic areas "STACKED" in "GET [CURRENT | STACKED] DIAGNOSTICS" syntax was added in 5.7.0. Final behavior was implemented in version 5.7.2, by WL#5928 - Most statements should clear the diagnostic area.

Throws:

java.lang.Exception

testDiscardImportPartitions

@Test
public void testDiscardImportPartitions()
                                       throws java.lang.Exception

WL#6868 - Support transportable tablespaces for single innodb partition. New syntax introduced in MySQL 5.7.4. ALTER TABLE t DISCARD PARTITION {p[[,p1]..]|ALL} TABLESPACE; ALTER TABLE t IMPORT PARTITION {p[[,p1]..]|ALL} TABLESPACE;

Throws:

java.lang.Exception

testJsonType

@Test
public void testJsonType()
                        throws java.lang.Exception

WL#7909 - Server side JSON functions Test support for data type JSON. New JSON functions added in MySQL 5.7.8: - JSON_APPEND(), Append data to JSON document (only in 5.7.8) - JSON_ARRAY_APPEND(), Append data to JSON document (added in 5.7.9+) - JSON_ARRAY_INSERT(), Insert into JSON array - JSON_ARRAY(), Create JSON array - JSON_CONTAINS_PATH(), Whether JSON document contains any data at path - JSON_CONTAINS(), Whether JSON document contains specific object at path - JSON_DEPTH(), Maximum depth of JSON document - JSON_EXTRACT(), Return data from JSON document - JSON_INSERT(), Insert data into JSON document - JSON_KEYS(), Array of keys from JSON document - JSON_LENGTH(), Number of elements in JSON document - JSON_MERGE(), Merge JSON documents (up to 8.0.2) - JSON_MERGE_PRESERVE(), Merge JSON documents (since to 8.0.3) - JSON_OBJECT(), Create JSON object - JSON_QUOTE(), Quote JSON document - JSON_REMOVE(), Remove data from JSON document - JSON_REPLACE(), Replace values in JSON document - JSON_SEARCH(), Path to value within JSON document - JSON_SET(), Insert data into JSON document - JSON_TYPE(), Type of JSON value - JSON_UNQUOTE(), Unquote JSON value - JSON_VALID(), Whether JSON value is valid

Throws:

java.lang.Exception

testJsonTypeCheckFunction

@Test
private void testJsonTypeCheckFunction(java.lang.String sql,
                                             java.lang.String expectedResult)
                                      throws java.lang.Exception

Throws:

java.lang.Exception

testHints

@Test
public void testHints()
                     throws java.lang.Exception

WL#8016 - Parser for optimizer hints. Test syntax for optimizer hints. New optimizer hints feature added in MySQL 5.7.7. Hints are permitted in these contexts: At the beginning of DML statements - SELECT /*+ ... */ ... - INSERT /*+ ... */ ... - REPLACE /*+ ... */ ... - UPDATE /*+ ... */ ... - DELETE /*+ ... */ ... At the beginning of query blocks: - (SELECT /*+ ... */ ... ) - (SELECT ... ) UNION (SELECT /*+ ... */ ... ) - (SELECT /*+ ... */ ... ) UNION (SELECT /*+ ... */ ... ) - UPDATE ... WHERE x IN (SELECT /*+ ... */ ...) - INSERT ... SELECT /*+ ... */ ... In hintable statements prefaced by EXPLAIN. For example: - EXPLAIN SELECT /*+ ... */ ... - EXPLAIN UPDATE ... WHERE x IN (SELECT /*+ ... */ ...)

Throws:

java.lang.Exception

testHintsSyntax

private void testHintsSyntax(java.lang.String query,
                             boolean processesHint,
                             boolean warningExpected)
                      throws java.lang.Exception

Throws:

java.lang.Exception

testCreateTablespace

@Test
public void testCreateTablespace()
                                throws java.lang.Exception

WL#6205 - InnoDB: Implement CREATE TABLESPACE for general use. Tests support for new CREATE TABLESPACE syntax that extends this feature to InnoDB. CREATE TABLESPACE tablespace_name ADD DATAFILE 'file_name' [FILE_BLOCK_SIZE = value] [ENGINE [=] engine_name]

Throws:

java.lang.Exception

testCreateTablespaceCheckTablespaces

@Test
private void testCreateTablespaceCheckTablespaces(int expectedTsCount)
                                                 throws java.lang.Exception

Throws:

java.lang.Exception

testCreateTablespaceCheckTables

@Test
private void testCreateTablespaceCheckTables(java.lang.String tablespace,
                                                   int expectedTblCount)
                                            throws java.lang.Exception

Throws:

java.lang.Exception

testSetMergeThreshold

@Test
public void testSetMergeThreshold()
                                 throws java.lang.Exception

WL#6747 - InnoDB: make fill factor settable. Tests support for new syntax for setting indices MERGE_THRESHOLD on CREATE TABLE. index_option: COMMENT 'MERGE_THRESHOLD=n'

Throws:

java.lang.Exception

testSetMergeThresholdIndices

@Test
private void testSetMergeThresholdIndices(int defaultMergeThreshold,
                                                java.util.Map<java.lang.String,java.lang.Integer> keyMergeThresholds)
                                         throws java.lang.Exception

Throws:

java.lang.Exception

testTableCompression

@Test
public void testTableCompression()
                                throws java.lang.Exception

WL#7696 - InnoDB: Transparent page compression. Tests COMPRESSION clause in CREATE|ALTER TABLE syntax. table_option: (...) | COMPRESSION [=] {'ZLIB'|'LZ4'|'NONE'}

Throws:

java.lang.Exception

testGisFunctions

@Test
public void testGisFunctions()
                            throws java.lang.Exception

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.

Throws:

java.lang.Exception

testGcsReplicationCmds

@Test
public void testGcsReplicationCmds()
                                  throws java.lang.Exception

WL#8252 - GCS Replication: Plugin [SERVER CHANGES] Test syntax for GCS Replication commands: - START GROUP_REPLICATION - STOP GROUP_REPLICATION

Throws:

java.lang.Exception

testUserAccountLocking

@Test
public void testUserAccountLocking()
                                  throws java.lang.Exception

WL#6054 - Temporarily disablement of users Test user account locking syntax: CREATE|ALTER USER (...) - lock_option: { ACCOUNT LOCK | ACCOUNT UNLOCK }

Throws:

java.lang.Exception

testUserAccountPwdExpiration

@Test
public void testUserAccountPwdExpiration()
                                        throws java.lang.Exception

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 }

Throws:

java.lang.Exception

testInnodbTablespaceEncryption

@Test
public void testInnodbTablespaceEncryption()
                                          throws java.lang.Exception

WL#8548 - InnoDB: Transparent data encryption. WL#8821 - Innodb tablespace encryption key rotation SQL commands. Test new syntax: - CREATE|ALTER TABLE (...) ENCRYPTION [=] {'Y' | 'N'} - ALTER INSTANCE ROTATE INNODB MASTER KEY

Throws:

java.lang.Exception