testsuite.simple

Class MetadataTest

java.lang.Object

testsuite.BaseTestCase

testsuite.simple.MetadataTest

public class MetadataTest
extends BaseTestCase

Tests DatabaseMetaData methods.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	MetadataTest.TestGetSqlKeywordsDynamicQueryInterceptor

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
MetadataTest()

Method Summary

Modifier and Type	Method and Description
private void	checkBitOrBooleanType(boolean usingBit)
void	testBitType()
void	testForeignKeys()
void	testGeneratedColumns() WL#411 - Generated columns.
private void	testGetBestRowIdentifier_checkResult(java.sql.ResultSet rs1)
void	testGetBestRowIdentifier()
void	testGetCatalogVsGetSchemas()
void	testGetColumnPrivileges() Tests the implementation of column privileges metadata.
void	testGetColumns() Tests the implementation of getColumns.
void	testGetCrossReferenceUsingInfoSchema() Tests the implementation of Information Schema for foreign key.
private void	testGetExportedKeys_checkResult(boolean useIS, boolean dbMapsToSchema)
void	testGetExportedKeys()
private void	testGetFunctionColumns_checkResult(boolean dbMapsToSchema)
void	testGetFunctionColumns()
private void	testGetFunctions_checkResult(boolean dbMapsToSchema)
void	testGetFunctions()
private void	testGetImportedKeys_checkResult(boolean useIS, boolean dbMapsToSchema)
void	testGetImportedKeys()
void	testGetIndexInfo()
void	testGetPrimaryKeys()
void	testGetPrimaryKeysUsingInfoShcema() Tests the implementation of Information Schema for primary keys.
private void	testGetProcedureColumns_checkResult(boolean dbMapsToSchema)
void	testGetProcedureColumns()
private void	testGetProcedures_checkResult(boolean dbMapsToSchema)
void	testGetProcedures()
void	testGetSqlKeywordsDynamic() Tests DatabaseMetaData.getSQLKeywords().
void	testGetSqlKeywordsStatic() Tests DatabaseMetaData.getSQLKeywords().
private void	testGetTablePrivileges_checkResult(boolean dbMapsToSchema, java.lang.String tableName)
void	testGetTablePrivileges()
private void	testGetTables_checkResult(boolean useIS, boolean dbMapsToSchema)
void	testGetTables()
void	testGetTablesUsingInfoSchema() Tests the implementation of Information Schema for tables.
void	testResultSetMetaDataMethods()
void	testRSMDIsReadOnly() Tests detection of read-only fields.
void	testSupports()
void	testSupportsSelectForUpdate()
void	testTinyint1IsBit()
void	testViewMetaData() Tests the implementation of metadata for views.

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

MetadataTest

public MetadataTest()

Method Detail

testSupports

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

Throws:

java.sql.SQLException

testGetCatalogVsGetSchemas

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

Throws:

java.sql.SQLException

testForeignKeys

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

Throws:

java.sql.SQLException

testGetPrimaryKeys

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

Throws:

java.sql.SQLException

testViewMetaData

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

Tests the implementation of metadata for views. This test automatically detects whether or not the server it is running against supports the creation of views.

Throws:

java.sql.SQLException

testRSMDIsReadOnly

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

Tests detection of read-only fields.

Throws:

java.lang.Exception

testBitType

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

Throws:

java.lang.Exception

testSupportsSelectForUpdate

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

Throws:

java.lang.Exception

testTinyint1IsBit

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

Throws:

java.lang.Exception

checkBitOrBooleanType

@Test
private void checkBitOrBooleanType(boolean usingBit)
                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

testResultSetMetaDataMethods

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

Throws:

java.lang.Exception

testGetPrimaryKeysUsingInfoShcema

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

Tests the implementation of Information Schema for primary keys.

Throws:

java.lang.Exception

testGetIndexInfo

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

Throws:

java.lang.Exception

testGetColumns

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

Tests the implementation of getColumns.

Throws:

java.lang.Exception

testGetTablesUsingInfoSchema

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

Tests the implementation of Information Schema for tables.

Throws:

java.lang.Exception

testGetTables

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

Throws:

java.lang.Exception

testGetTables_checkResult

@Test
private void testGetTables_checkResult(boolean useIS,
                                             boolean dbMapsToSchema)
                                      throws java.lang.Exception

Throws:

java.lang.Exception

testGetColumnPrivileges

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

Tests the implementation of column privileges metadata.

Throws:

java.lang.Exception

testGetProcedures

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

Throws:

java.lang.Exception

testGetProcedures_checkResult

private void testGetProcedures_checkResult(boolean dbMapsToSchema)
                                    throws java.lang.Exception

Throws:

java.lang.Exception

testGetFunctions

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

Throws:

java.lang.Exception

testGetFunctions_checkResult

private void testGetFunctions_checkResult(boolean dbMapsToSchema)
                                   throws java.lang.Exception

Throws:

java.lang.Exception

testGetProcedureColumns

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

Throws:

java.lang.Exception

testGetProcedureColumns_checkResult

private void testGetProcedureColumns_checkResult(boolean dbMapsToSchema)
                                          throws java.lang.Exception

Throws:

java.lang.Exception

testGetFunctionColumns

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

Throws:

java.lang.Exception

testGetFunctionColumns_checkResult

private void testGetFunctionColumns_checkResult(boolean dbMapsToSchema)
                                         throws java.lang.Exception

Throws:

java.lang.Exception

testGetCrossReferenceUsingInfoSchema

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

Tests the implementation of Information Schema for foreign key.

Throws:

java.lang.Exception

testGetExportedKeys

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

Throws:

java.lang.Exception

testGetExportedKeys_checkResult

private void testGetExportedKeys_checkResult(boolean useIS,
                                             boolean dbMapsToSchema)
                                      throws java.lang.Exception

Throws:

java.lang.Exception

testGetImportedKeys

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

Throws:

java.lang.Exception

testGetImportedKeys_checkResult

private void testGetImportedKeys_checkResult(boolean useIS,
                                             boolean dbMapsToSchema)
                                      throws java.lang.Exception

Throws:

java.lang.Exception

testGeneratedColumns

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

WL#411 - Generated columns. Test for new syntax and support in DatabaseMetaData.getColumns(). New syntax for CREATE TABLE, introduced in MySQL 5.7.6: - col_name data_type [GENERATED ALWAYS] AS (expression) [VIRTUAL | STORED] [UNIQUE [KEY]] [COMMENT comment] [[NOT] NULL] [[PRIMARY] KEY]

Throws:

java.lang.Exception

testGetSqlKeywordsStatic

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

Tests DatabaseMetaData.getSQLKeywords(). (Related to BUG#70701 - DatabaseMetaData.getSQLKeywords() doesn't match MySQL 5.6 reserved words) This test checks the statically maintained keywords list.

Throws:

java.lang.Exception

testGetSqlKeywordsDynamic

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

Tests DatabaseMetaData.getSQLKeywords(). WL#10544, Update MySQL 8.0 keywords list. This test checks the dynamically maintained keywords lists.

Throws:

java.lang.Exception

testGetTablePrivileges

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

Throws:

java.lang.Exception

testGetTablePrivileges_checkResult

private void testGetTablePrivileges_checkResult(boolean dbMapsToSchema,
                                                java.lang.String tableName)
                                         throws java.lang.Exception

Throws:

java.lang.Exception

testGetBestRowIdentifier

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

Throws:

java.lang.Exception

testGetBestRowIdentifier_checkResult

@Test
private void testGetBestRowIdentifier_checkResult(java.sql.ResultSet rs1)
                                                 throws java.lang.Exception

Throws:

java.lang.Exception