testsuite.regression

Class MetaDataRegressionTest

java.lang.Object

testsuite.BaseTestCase

testsuite.regression.MetaDataRegressionTest

public class MetaDataRegressionTest
extends BaseTestCase

Regression tests for DatabaseMetaData

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	MetaDataRegressionTest.QueryInterceptorBug61332
private class	MetaDataRegressionTest.TestBug97413Columns

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

Method Summary

Modifier and Type	Method and Description
private void	callFunction(java.sql.CallableStatement cStmt, java.sql.Connection c)
private void	callProcedure(java.sql.CallableStatement cStmt, java.sql.Connection c)
private void	checkABunchOfReturnTypesForConnection(java.sql.Connection mdConn)
private void	checkBug27915()
private void	checkFunctionColumnTypeForBug68307(java.lang.String testAgainst, java.sql.DatabaseMetaData testDbMetaData)
private void	checkGetFunctionColumnsForBug69298(java.lang.String stepDescription, java.sql.Connection testConn)
private void	checkGetFunctionsForBug69298(java.lang.String stepDescription, java.sql.Connection testConn)
private void	checkGetProcedureColumnsForBug69298(java.lang.String stepDescription, java.sql.Connection testConn)
private void	checkGetProceduresForBug69298(java.lang.String stepDescription, java.sql.Connection testConn)
private void	checkMetadataForBug22613(java.sql.Connection c)
private void	checkMetaDataInfoForBug17248345(java.sql.Connection testConn)
private void	checkProcedureColumnTypeForBug68307(java.lang.String testAgainst, java.sql.DatabaseMetaData testDbMetaData)
private void	checkReturnedColumnsForBug44451(java.lang.String stepDescription, java.lang.String methodName, java.util.List<java.lang.String> expectedFields, java.sql.ResultSet resultSetToCheck)
private void	checkRsmdForBug13277(java.sql.ResultSetMetaData rsmd)
private void	checkTypes(java.sql.ResultSet rsToCheck, int[] types, java.util.Map<java.lang.Integer,java.lang.String> sqlTypesMap)
private void	compareResultSets(java.sql.ResultSet expected, java.sql.ResultSet actual)
private void	testAbsenceOfMetadataForQuery(java.lang.String query)
void	testABunchOfReturnTypes()
void	testBug102076() Tests fix for Bug#102076 (32329915), CONTRIBUTION: MYSQL JDBC DRIVER RESULTSET.GETLONG() THROWS NUMBEROUTOFRANGE.
void	testBug104641() Tests fix for Bug#104641 (33237255), DatabaseMetaData.getImportedKeys can return duplicated foreign keys.
void	testBug106758() Tests fix for Bug#106758 (33973048), DatabaseMetaData.getTypeInfo returns AUTO_INCREMENT = false for all datatypes.
(package private) void	testBug109807() Tests fix for Bug#109807 (Bug#35021014), DatabaseMetaData#getTypeInfo should ordered by DATA_TYPE.
(package private) void	testBug109808() Tests fix for Bug#109808 (Bug#35021038), DatabaseMetaData#getPrimaryKeys should ordered by COLUMN_NAME.
void	testBug11575() Tests fix for BUG#11575 -- DBMD.storesLower/Mixed/UpperIdentifiers() reports incorrect values for servers deployed on Windows.
void	testBug11781() Tests fix for BUG#11781, foreign key information that is quoted is parsed incorrectly.
void	testBug12970() Tests fix for BUG#12970 - java.sql.Types.OTHER returned for binary and varbinary columns.
void	testBug12975() Tests fix for BUG#12975 - OpenOffice expects DBMD.supportsIEF() to return "true" if foreign keys are supported by the datasource, even though this method also covers support for check constraints, which MySQL _doesn't_ have.
void	testBug13277() Tests fix for BUG#13277 - RSMD for generated keys has NPEs when a connection is referenced.
void	testBug13601() Tests BUG13601 (which doesn't seem to be present in 3.1.11, but we'll leave it in here for regression's-sake).
void	testBug14815() Tests fix for BUG#14815 - DBMD.getColumns() doesn't return TABLE_NAME correctly.
void	testBug15854() Tests fix for BUG#15854 - DBMD.getColumns() returns wrong type for BIT.
void	testBug16277() Tests fix for BUG#16277 - Invalid classname returned for RSMD.getColumnClassName() for BIGINT type.
void	testBug16436511() Tests fix for BUG#16436511 - getDriverName() returns a string with company name "MySQL-AB"
void	testBug17248345() Tests fix for BUG#17248345 - GETFUNCTIONCOLUMNS() METHOD RETURNS COLUMNS OF PROCEDURE.
void	testBug18258() Tests fix for BUG#18258 - Nonexistent catalog/database causes SQLException to be raised, rather than returning empty result set.
void	testBug18554() Tests fix for BUG#18554 - Aliased column names where length of name > 251 are corrupted.
private void	testBug18554(int columnNameLength)
void	testBug19803348() Tests fix for BUG#19803348 - GETPROCEDURES() RETURNS INCORRECT O/P WHEN USEINFORMATIONSCHEMA=FALSE.
void	testBug20491()
void	testBug20504139() Tests fix for BUG#20504139 - GETFUNCTIONCOLUMNS() AND GETPROCEDURECOLUMNS() RETURNS ERROR FOR VALID INPUTS.
void	testBug20727196() Tests fix for BUG#20727196 - GETPROCEDURECOLUMNS() RETURNS EXCEPTION FOR FUNCTION WHICH RETURNS ENUM/SET TYPE.
void	testBug21215151() Tests fix for BUG#21215151 - DATABASEMETADATA.GETCATALOGS() FAILS TO SORT RESULTS.
void	testBug21267() Tests fix for BUG#21267, ParameterMetaData throws NullPointerException when prepared SQL actually has a syntax error
void	testBug21544() Tests fix for BUG#21544 - When using information_schema for metadata, COLUMN_SIZE for getColumns() is not clamped to range of java.lang.Integer as is the case when not using information_schema, thus leading to a truncation exception that isn't present when not using information_schema.
void	testBug21978216() Tests fix for BUG#21978216, GETTYPEINFO REPORT MAXIMUM PRECISION OF 255 FOR VARBINARY
void	testBug22613() Tests fix for BUG#22613 - DBMD.getColumns() does not return expected COLUMN_SIZE for the SET type (fixed to be consistent with the ODBC driver)
void	testBug22628() Fix for BUG#22628 - Driver.getPropertyInfo() throws NullPointerException for URL that only specifies host and/or port.
void	testBug23212347() Tests fix for Bug#23212347, ALL API CALLS ON RESULTSET METADATA RESULTS IN NPE WHEN USESERVERPREPSTMTS=TRUE.
void	testBug23303() Tests fix for BUG#23303 - DBMD.getSchemas() doesn't return a TABLE_CATALOG column.
void	testBug23304() Tests fix for BUG#23304 - DBMD using "show" and DBMD using information_schema do not return results consistent with each other.
void	testBug25624() Tests fix for BUG#25624 - Whitespace surrounding storage/size specifiers in stored procedure declaration causes NumberFormatException to be thrown when calling stored procedure.
void	testBug2607()
void	testBug27867() Tests fix for BUG#27867 - Schema objects with identifiers other than the connection character aren't retrieved correctly in ResultSetMetadata.
void	testBug27915() Fixed BUG#27915 - DatabaseMetaData.getColumns() doesn't contain SCOPE_* or IS_AUTOINCREMENT columns.
void	testBug27916() Tests fix for BUG#27916 - UNSIGNED types not reported via DBMD.getTypeInfo(), and capitalization of types is not consistent between DBMD.getColumns(), RSMD.getColumnTypeName() and DBMD.getTypeInfo().
void	testBug2852() Tests fix for BUG#2852, where RSMD is not returning correct (or matching) types for TINYINT and SMALLINT.
void	testBug2855() Tests fix for BUG#2855, where RSMD is not returning correct (or matching) types for FLOAT.
void	testBug29186870() Tests fix for BUG#29186870, CONNECTOR/J REGRESSION: NOT RETURNING PRECISION GETPROCEDURECOLUMNS.
void	testBug31187()
void	testBug33594() Tests fix for Bug#33594 - When cursor fetch is enabled, wrong metadata is returned from DBMD.
void	testBug33723611() Tests fix for Bug#33723611, getDefaultTransactionIsolation must return repeatable read.
void	testBug34194()
void	testBug35115() Tests fix for BUG#35115 - yearIsDateType=false has no effect on result's column type and class.
void	testBug3570() Tests fix for BUG#3570 -- inconsistent reporting of column type
void	testBug38367() Tests fix for BUG#38367 - DatabaseMetaData dbMeta = this.conn.getMetaData(); this.rs = dbMeta.getProcedureColumns("test", null, "nullableParameterTest", null); ...
void	testBug41269() Bug #41269 - DatabaseMetadata.getProcedureColumns() returns wrong value for column length
void	testBug4138() Tests fix for BUG#4138, getColumns() returns incorrect JDBC type for unsigned columns.
void	testBug43714() Bug #43714 - useInformationSchema with DatabaseMetaData.getExportedKeys() throws exception
void	testBug44451() Tests fix for BUG#44451 - getTables does not return resultset with expected columns.
void	testBug44508()
void	testBug4742() Tests fix for BUG#4742, 'DOUBLE' mapped twice in getTypeInfo().
void	testBug4860() Here for housekeeping only, the test is actually in testBug4138().
void	testBug4880() Tests fix for BUG#4880 - RSMD.getPrecision() returns '0' for non-numeric types.
void	testBug51912() Tests fix for BUG#51912 - Passing NULL as cat.
void	testBug52167() Tests fix for BUG#52167 - Can't parse parameter list with special characters inside
void	testBug57808() Tests fix for BUG#57808 - wasNull not set for DATE field with value 0000-00-00 in getDate() although zeroDateTimeBehavior is CONVERT_TO_NULL.
void	testBug61150() Tests fix for BUG#61150 - First call to SP fails with "No Database Selected" The workaround introduced in DatabaseMetaData.getCallStmtParameterTypes to fix the bug in server where SHOW CREATE PROCEDURE was not respecting lower-case table names is misbehaving when connection is not attached to database and on non-casesensitive OS.
void	testBug61203() Tests fix for BUG#61203 - noAccessToProcedureBodies does not work anymore.
private void	testBug61203checks(java.sql.Connection rootConn, java.sql.Connection userConn)
void	testBug61332() Tests fix for BUG#61332 - Check if "LIKE" or "=" is sent to server in I__S query when no wildcards are supplied for schema parameter.
void	testBug63456() Tests fix for BUG#63456 - MetaData precision is different when using UTF8 or Latin1 tables
void	testBug63800() Tests fix for BUG#63800 - getVersionColumns() does not return timestamp fields; always empty.
void	testBug6399() Tests fix for BUG#6399, ResultSetMetaData.getDisplaySize() is wrong for multi-byte charsets.
private void	testBug65871_testCatalog(java.lang.String unquotedDbName, java.lang.String quotedDbName, java.sql.Connection conn1)
private void	testBug65871_testCatalogs(java.sql.Connection conn1)
private void	testBug65871_testTable(java.lang.String unquotedDbName, java.lang.String quotedDbName, java.lang.String unquotedTableName, java.lang.String quotedTableName, java.sql.Connection conn1, java.sql.Statement st1)
void	testBug65871() Tests fix for BUG#65871 - DatabaseMetaData.getColumns() throws an MySQLSyntaxErrorException.
void	testBug68098() Test fix for BUG#68098 - DatabaseMetaData.getIndexInfo sorts results incorrectly.
void	testBug68307() Tests fix for BUG#68307 - getFunctionColumns() returns incorrect "COLUMN_TYPE" information.
void	testBug69290() Tests fix for BUG#69290 - JDBC Table type "SYSTEM TABLE" is used inconsistently.
void	testBug69298() Tests fix for BUG#69298 - Different outcome from DatabaseMetaData.getFunctions() when using I__S.
void	testBug7033() Tests fix for BUG#7033 - PreparedStatements don't encode Big5 (and other multibyte) character sets correctly in static SQL strings.
void	testBug7081() Tests fix for BUG#7081, DatabaseMetaData.getIndexInfo() ignoring 'unique' parameters.
void	testBug73775() Tests fix for Bug#73775 - DBMD.getProcedureColumns()/.getFunctionColumns() fail to filter by columnPattern
void	testBug76187() Tests fix for BUG#76187 (20675539), getTypeInfo report maximum precision of 255 for varchar.
void	testBug82084() Tests fix for Bug#82084 (23743938), YEAR DATA TYPE RETURNS INCORRECT VALUE FOR JDBC GETCOLUMNTYPE().
void	testBug87826() Tests fix for BUG#87826 (26846249), MYSQL JDBC CONNECTOR/J DATABASEMETADATA NULL PATTERN HANDLING IS NON-COMPLIANT.
void	testBug8792() Tests fix for BUG#8792 - DBMD.supportsResultSetConcurrency() not returning true for forward-only/read-only result sets (we obviously support this).
void	testBug8800() Tests fix for BUG#8800 - supportsMixedCase*Identifiers() returns wrong value on servers running on case-sensitive filesystems.
void	testBug8803() Tests fix for BUG#8803, 'DATA_TYPE' column from DBMD.getBestRowIdentifier() causes ArrayIndexOutOfBoundsException when accessed (and in fact, didn't return any value).
void	testBug8812() Tests fix for Bug#8812, DBMD.getIndexInfo() returning inverted values for 'NON_UNIQUE' column.
void	testBug90887() Tests fix for BUG#90887 (28034570), DATABASEMETADATAUSINGINFOSCHEMA#GETTABLES FAILS IF METHOD ARGUMENTS ARE NULL.
void	testBug9320() Tests fix for BUG#9320 - PreparedStatement.getMetaData() inserts blank row in database under certain conditions when not using server-side prepared statements.
void	testBug95280() Tests fix for Bug#95280 (29757140), DATABASEMETADATA.GETIMPORTEDKEYS RETURNS DOUBLE THE ROWS.
void	testBug97413() Tests fix for Bug#97413 (30477722), DATABASEMETADATA IS BROKEN AFTER SERVER WL#13528.
void	testBug9769() Tests fix for BUG#9769 - Should accept null for procedureNamePattern, even though it isn't JDBC compliant, for legacy's sake.
void	testBug9778() Tests fix for BUG#9778, DBMD.getTables() shouldn't return tables if views are asked for, even if the database version doesn't support views.
void	testBug9917() Tests fix for BUG#9917 - Should accept null for catalog in DBMD methods, even though it's not JDBC-compliant for legacy's sake.
void	testCharacterSetForDBMD()
void	testCharVarchar() Tests char/varchar bug
private void	testDatetime(java.sql.Connection con, java.sql.Statement st, java.lang.String dbname)
void	testFixForBug1673() Tests fix for BUG#1673, where DatabaseMetaData.getColumns() is not returning correct column ordinal info for non '%' column name patterns.
void	testGetColumns() Tests bug reported by OpenOffice team with getColumns and LONGBLOB
void	testGetColumnsBug1099() Tests fix for Bug#1099
void	testGetColumnsUnsigned() Tests whether or not unsigned columns are reported correctly in DBMD.getColumns
void	testGetPropertyInfo() Tests whether bogus parameters break Driver.getPropertyInfo().
void	testIsCaseSensitive() Tests whether ResultSetMetaData returns correct info for CHAR/VARCHAR columns.
void	testLongText() Tests whether or not DatabaseMetaData.getColumns() returns the correct java.sql.Types info.
void	testNoSystemTablesReturned()
void	testQuotedGunk()
void	testRSMDToStringFromDBMD()
void	testSupportesGroupByUnrelated()
void	testSupportsCorrelatedSubqueries()
private void	testTimestamp(java.sql.Connection con, java.sql.Statement st, java.lang.String dbname)
void	testTypes() Tests for types being returned correctly

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

MetaDataRegressionTest

public MetaDataRegressionTest()

Method Detail

testBug2607

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

Throws:

java.lang.Exception

testBug2852

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

Tests fix for BUG#2852, where RSMD is not returning correct (or matching) types for TINYINT and SMALLINT.

Throws:

java.lang.Exception

testBug2855

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

Tests fix for BUG#2855, where RSMD is not returning correct (or matching) types for FLOAT.

Throws:

java.lang.Exception

testBug3570

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

Tests fix for BUG#3570 -- inconsistent reporting of column type

Throws:

java.lang.Exception

testCharVarchar

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

Tests char/varchar bug

Throws:

java.lang.Exception

testFixForBug1673

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

Tests fix for BUG#1673, where DatabaseMetaData.getColumns() is not returning correct column ordinal info for non '%' column name patterns.

Throws:

java.lang.Exception

testGetColumns

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

Tests bug reported by OpenOffice team with getColumns and LONGBLOB

Throws:

java.lang.Exception

testGetColumnsBug1099

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

Tests fix for Bug#1099

Throws:

java.lang.Exception

testGetColumnsUnsigned

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

Tests whether or not unsigned columns are reported correctly in DBMD.getColumns

Throws:

java.lang.Exception

testGetPropertyInfo

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

Tests whether bogus parameters break Driver.getPropertyInfo().

Throws:

java.lang.Exception

testIsCaseSensitive

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

Tests whether ResultSetMetaData returns correct info for CHAR/VARCHAR columns.

Throws:

java.lang.Exception

testLongText

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

Tests whether or not DatabaseMetaData.getColumns() returns the correct java.sql.Types info.

Throws:

java.lang.Exception

testTypes

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

Tests for types being returned correctly

Throws:

java.lang.Exception

testBug4742

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

Tests fix for BUG#4742, 'DOUBLE' mapped twice in getTypeInfo().

Throws:

java.lang.Exception

testBug4138

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

Tests fix for BUG#4138, getColumns() returns incorrect JDBC type for unsigned columns.

Throws:

java.lang.Exception

testBug4860

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

Here for housekeeping only, the test is actually in testBug4138().

Throws:

java.lang.Exception

testBug4880

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

Tests fix for BUG#4880 - RSMD.getPrecision() returns '0' for non-numeric types. Why-oh-why is this not in the spec, nor the api-docs, but in some 'optional' book, _and_ it is a variance from both ODBC and the ANSI SQL standard :p (from the CTS testsuite).... The getPrecision(int colindex) method returns an integer value representing the number of decimal digits for number types,maximum length in characters for character types,maximum length in bytes for JDBC binary datatypes. (See Section 27.3 of JDBC 2.0 API Reference & Tutorial 2nd edition)

Throws:

java.lang.Exception

testBug6399

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

Tests fix for BUG#6399, ResultSetMetaData.getDisplaySize() is wrong for multi-byte charsets.

Throws:

java.lang.Exception

testBug7081

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

Tests fix for BUG#7081, DatabaseMetaData.getIndexInfo() ignoring 'unique' parameters.

Throws:

java.lang.Exception

testBug7033

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

Tests fix for BUG#7033 - PreparedStatements don't encode Big5 (and other multibyte) character sets correctly in static SQL strings.

Throws:

java.lang.Exception

testBug8812

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

Tests fix for Bug#8812, DBMD.getIndexInfo() returning inverted values for 'NON_UNIQUE' column.

Throws:

java.lang.Exception

testBug8800

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

Tests fix for BUG#8800 - supportsMixedCase*Identifiers() returns wrong value on servers running on case-sensitive filesystems.

Throws:

java.lang.Exception

testBug8792

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

Tests fix for BUG#8792 - DBMD.supportsResultSetConcurrency() not returning true for forward-only/read-only result sets (we obviously support this).

Throws:

java.lang.Exception

testBug8803

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

Tests fix for BUG#8803, 'DATA_TYPE' column from DBMD.getBestRowIdentifier() causes ArrayIndexOutOfBoundsException when accessed (and in fact, didn't return any value).

Throws:

java.lang.Exception

testBug9320

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

Tests fix for BUG#9320 - PreparedStatement.getMetaData() inserts blank row in database under certain conditions when not using server-side prepared statements.

Throws:

java.lang.Exception

testBug9778

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

Tests fix for BUG#9778, DBMD.getTables() shouldn't return tables if views are asked for, even if the database version doesn't support views.

Throws:

java.lang.Exception

testBug9769

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

Tests fix for BUG#9769 - Should accept null for procedureNamePattern, even though it isn't JDBC compliant, for legacy's sake.

Throws:

java.lang.Exception

testBug9917

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

Tests fix for BUG#9917 - Should accept null for catalog in DBMD methods, even though it's not JDBC-compliant for legacy's sake.

Throws:

java.lang.Exception

testBug11575

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

Tests fix for BUG#11575 -- DBMD.storesLower/Mixed/UpperIdentifiers() reports incorrect values for servers deployed on Windows.

Throws:

java.lang.Exception

testBug11781

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

Tests fix for BUG#11781, foreign key information that is quoted is parsed incorrectly.

Throws:

java.lang.Exception

testBug12970

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

Tests fix for BUG#12970 - java.sql.Types.OTHER returned for binary and varbinary columns.

Throws:

java.lang.Exception

testBug12975

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

Tests fix for BUG#12975 - OpenOffice expects DBMD.supportsIEF() to return "true" if foreign keys are supported by the datasource, even though this method also covers support for check constraints, which MySQL _doesn't_ have.

Throws:

java.lang.Exception

testBug13277

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

Tests fix for BUG#13277 - RSMD for generated keys has NPEs when a connection is referenced.

Throws:

java.lang.Exception

testBug13601

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

Tests BUG13601 (which doesn't seem to be present in 3.1.11, but we'll leave it in here for regression's-sake).

Throws:

java.lang.Exception

testBug14815

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

Tests fix for BUG#14815 - DBMD.getColumns() doesn't return TABLE_NAME correctly.

Throws:

java.lang.Exception

testBug15854

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

Tests fix for BUG#15854 - DBMD.getColumns() returns wrong type for BIT.

Throws:

java.lang.Exception

testBug16277

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

Tests fix for BUG#16277 - Invalid classname returned for RSMD.getColumnClassName() for BIGINT type.

Throws:

java.lang.Exception

testBug18554

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

Tests fix for BUG#18554 - Aliased column names where length of name > 251 are corrupted.

Throws:

java.lang.Exception

testBug18554

private void testBug18554(int columnNameLength)
                   throws java.lang.Exception

Throws:

java.lang.Exception

checkRsmdForBug13277

private void checkRsmdForBug13277(java.sql.ResultSetMetaData rsmd)
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

testSupportsCorrelatedSubqueries

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

Throws:

java.lang.Exception

testSupportesGroupByUnrelated

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

Throws:

java.lang.Exception

testBug21267

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

Tests fix for BUG#21267, ParameterMetaData throws NullPointerException when prepared SQL actually has a syntax error

Throws:

java.lang.Exception

testBug21544

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

Tests fix for BUG#21544 - When using information_schema for metadata, COLUMN_SIZE for getColumns() is not clamped to range of java.lang.Integer as is the case when not using information_schema, thus leading to a truncation exception that isn't present when not using information_schema.

Throws:

java.lang.Exception

testBug22613

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

Tests fix for BUG#22613 - DBMD.getColumns() does not return expected COLUMN_SIZE for the SET type (fixed to be consistent with the ODBC driver)

Throws:

java.lang.Exception

checkMetadataForBug22613

private void checkMetadataForBug22613(java.sql.Connection c)
                               throws java.lang.Exception

Throws:

java.lang.Exception

testBug22628

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

Fix for BUG#22628 - Driver.getPropertyInfo() throws NullPointerException for URL that only specifies host and/or port.

Throws:

java.lang.Exception

testAbsenceOfMetadataForQuery

private void testAbsenceOfMetadataForQuery(java.lang.String query)
                                    throws java.lang.Exception

Throws:

java.lang.Exception

testRSMDToStringFromDBMD

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

Throws:

java.lang.Exception

testCharacterSetForDBMD

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

Throws:

java.lang.Exception

testBug18258

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

Tests fix for BUG#18258 - Nonexistent catalog/database causes SQLException to be raised, rather than returning empty result set.

Throws:

java.lang.Exception

testBug23303

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

Tests fix for BUG#23303 - DBMD.getSchemas() doesn't return a TABLE_CATALOG column.

Throws:

java.lang.Exception

testBug23304

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

Tests fix for BUG#23304 - DBMD using "show" and DBMD using information_schema do not return results consistent with each other. (note this fix only addresses the inconsistencies, not the issue that the driver is treating schemas differently than some users expect. We will revisit this behavior when there is full support for schemas in MySQL).

Throws:

java.lang.Exception

compareResultSets

private void compareResultSets(java.sql.ResultSet expected,
                               java.sql.ResultSet actual)
                        throws java.lang.Exception

Throws:

java.lang.Exception

testBug25624

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

Tests fix for BUG#25624 - Whitespace surrounding storage/size specifiers in stored procedure declaration causes NumberFormatException to be thrown when calling stored procedure.

Throws:

java.lang.Exception

testBug27867

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

Tests fix for BUG#27867 - Schema objects with identifiers other than the connection character aren't retrieved correctly in ResultSetMetadata.

Throws:

java.lang.Exception

testBug27915

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

Fixed BUG#27915 - DatabaseMetaData.getColumns() doesn't contain SCOPE_* or IS_AUTOINCREMENT columns.

Throws:

java.lang.Exception

checkBug27915

private void checkBug27915()
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

testBug27916

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

Tests fix for BUG#27916 - UNSIGNED types not reported via DBMD.getTypeInfo(), and capitalization of types is not consistent between DBMD.getColumns(), RSMD.getColumnTypeName() and DBMD.getTypeInfo(). This fix also ensures that the precision of UNSIGNED MEDIUMINT and UNSIGNED BIGINT is reported correctly via DBMD.getColumns(). Second fix ensures that list values of ENUM and SET types containing 'unsigned' are not taken in account.

Throws:

java.lang.Exception

testBug20491

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

Throws:

java.lang.Exception

testBug33594

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

Tests fix for Bug#33594 - When cursor fetch is enabled, wrong metadata is returned from DBMD. The fix is two parts. First, when asking for the first column value twice from a cursor-fetched row, the driver didn't re-position, and thus the "next" column was returned. Second, metadata statements and internal statements the driver uses shouldn't use cursor-based fetching at all, so we've ensured that internal statements have their fetch size set to "0".

Throws:

java.lang.Exception

testBug34194

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

Throws:

java.lang.Exception

testNoSystemTablesReturned

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

Throws:

java.lang.Exception

testABunchOfReturnTypes

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

Throws:

java.lang.Exception

checkABunchOfReturnTypesForConnection

private void checkABunchOfReturnTypesForConnection(java.sql.Connection mdConn)
                                            throws java.lang.Exception

Throws:

java.lang.Exception

checkTypes

private void checkTypes(java.sql.ResultSet rsToCheck,
                        int[] types,
                        java.util.Map<java.lang.Integer,java.lang.String> sqlTypesMap)
                 throws java.lang.Exception

Throws:

java.lang.Exception

testBug43714

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

Bug #43714 - useInformationSchema with DatabaseMetaData.getExportedKeys() throws exception

Throws:

java.lang.Exception

testBug41269

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

Bug #41269 - DatabaseMetadata.getProcedureColumns() returns wrong value for column length

Throws:

java.lang.Exception

testBug31187

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

Throws:

java.lang.Exception

testBug44508

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

Throws:

java.lang.Exception

testBug52167

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

Tests fix for BUG#52167 - Can't parse parameter list with special characters inside

Throws:

java.lang.Exception

testBug51912

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

Tests fix for BUG#51912 - Passing NULL as cat. param to getProcedureColumns with nullCatalogMeansCurrent = false

Throws:

java.lang.Exception

testBug38367

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

Tests fix for BUG#38367 - DatabaseMetaData dbMeta = this.conn.getMetaData(); this.rs = dbMeta.getProcedureColumns("test", null, "nullableParameterTest", null); ... Short columnNullable = new Short(this.rs.getShort(12)); assertTrue("Parameter " + columnName + " do not allow null arguments", columnNullable.intValue() == java.sql.DatabaseMetaData.procedureNullable); was failing for no good reason.

Throws:

java.lang.Exception

testBug57808

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

Tests fix for BUG#57808 - wasNull not set for DATE field with value 0000-00-00 in getDate() although zeroDateTimeBehavior is CONVERT_TO_NULL.

Throws:

java.lang.Exception

testBug61150

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

Tests fix for BUG#61150 - First call to SP fails with "No Database Selected" The workaround introduced in DatabaseMetaData.getCallStmtParameterTypes to fix the bug in server where SHOW CREATE PROCEDURE was not respecting lower-case table names is misbehaving when connection is not attached to database and on non-casesensitive OS.

Throws:

java.lang.Exception

testBug61332

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

Tests fix for BUG#61332 - Check if "LIKE" or "=" is sent to server in I__S query when no wildcards are supplied for schema parameter.

Throws:

java.lang.Exception

testQuotedGunk

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

Throws:

java.lang.Exception

testBug61203

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

Tests fix for BUG#61203 - noAccessToProcedureBodies does not work anymore.

Throws:

java.lang.Exception

testBug61203checks

private void testBug61203checks(java.sql.Connection rootConn,
                                java.sql.Connection userConn)
                         throws java.sql.SQLException

Throws:

java.sql.SQLException

callFunction

private void callFunction(java.sql.CallableStatement cStmt,
                          java.sql.Connection c)
                   throws java.sql.SQLException

Throws:

java.sql.SQLException

callProcedure

private void callProcedure(java.sql.CallableStatement cStmt,
                           java.sql.Connection c)
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

testBug63456

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

Tests fix for BUG#63456 - MetaData precision is different when using UTF8 or Latin1 tables

Throws:

java.lang.Exception

testBug63800

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

Tests fix for BUG#63800 - getVersionColumns() does not return timestamp fields; always empty.

Throws:

java.lang.Exception

testTimestamp

private void testTimestamp(java.sql.Connection con,
                           java.sql.Statement st,
                           java.lang.String dbname)
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

testDatetime

private void testDatetime(java.sql.Connection con,
                          java.sql.Statement st,
                          java.lang.String dbname)
                   throws java.sql.SQLException

Throws:

java.sql.SQLException

testBug16436511

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

Tests fix for BUG#16436511 - getDriverName() returns a string with company name "MySQL-AB"

Throws:

java.lang.Exception

testBug68098

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

Test fix for BUG#68098 - DatabaseMetaData.getIndexInfo sorts results incorrectly.

Throws:

java.lang.Exception

testBug65871

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

Tests fix for BUG#65871 - DatabaseMetaData.getColumns() throws an MySQLSyntaxErrorException. Delimited names of databases and tables are handled correctly now. The edge case is ANSI quoted identifiers with leading and trailing "`" symbols, for example CREATE DATABASE "`dbname`". Methods like DatabaseMetaData.getColumns() allow parameters passed both in unquoted and quoted form, quoted form is not JDBC-compliant but used by third party tools. So when you pass the identifier "`dbname`" in unquoted form (`dbname`) driver handles it as quoted by "`" symbol. To handle such identifiers correctly a new behavior was added to pedantic mode (connection property pedantic=true), now if it set to true methods like DatabaseMetaData.getColumns() treat all parameters as unquoted.

Throws:

java.lang.Exception

testBug65871_testCatalogs

private void testBug65871_testCatalogs(java.sql.Connection conn1)
                                throws java.lang.Exception

Throws:

java.lang.Exception

testBug65871_testCatalog

private void testBug65871_testCatalog(java.lang.String unquotedDbName,
                                      java.lang.String quotedDbName,
                                      java.sql.Connection conn1)
                               throws java.lang.Exception

Throws:

java.lang.Exception

testBug65871_testTable

private void testBug65871_testTable(java.lang.String unquotedDbName,
                                    java.lang.String quotedDbName,
                                    java.lang.String unquotedTableName,
                                    java.lang.String quotedTableName,
                                    java.sql.Connection conn1,
                                    java.sql.Statement st1)
                             throws java.lang.Exception

Throws:

java.lang.Exception

testBug69298

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

Tests fix for BUG#69298 - Different outcome from DatabaseMetaData.getFunctions() when using I__S.

Throws:

java.lang.Exception

checkGetFunctionsForBug69298

private void checkGetFunctionsForBug69298(java.lang.String stepDescription,
                                          java.sql.Connection testConn)
                                   throws java.lang.Exception

Throws:

java.lang.Exception

checkGetFunctionColumnsForBug69298

private void checkGetFunctionColumnsForBug69298(java.lang.String stepDescription,
                                                java.sql.Connection testConn)
                                         throws java.lang.Exception

Throws:

java.lang.Exception

checkGetProceduresForBug69298

private void checkGetProceduresForBug69298(java.lang.String stepDescription,
                                           java.sql.Connection testConn)
                                    throws java.lang.Exception

Throws:

java.lang.Exception

checkGetProcedureColumnsForBug69298

private void checkGetProcedureColumnsForBug69298(java.lang.String stepDescription,
                                                 java.sql.Connection testConn)
                                          throws java.lang.Exception

Throws:

java.lang.Exception

testBug17248345

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

Tests fix for BUG#17248345 - GETFUNCTIONCOLUMNS() METHOD RETURNS COLUMNS OF PROCEDURE. (this happens when functions and procedures have a common name)

Throws:

java.lang.Exception

checkMetaDataInfoForBug17248345

private void checkMetaDataInfoForBug17248345(java.sql.Connection testConn)
                                      throws java.lang.Exception

Throws:

java.lang.Exception

testBug69290

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

Tests fix for BUG#69290 - JDBC Table type "SYSTEM TABLE" is used inconsistently. Tests DatabaseMetaData.getTableTypes() and DatabaseMetaData.getTables() against schemas: mysql, information_schema, performance_schema, test.

Throws:

java.lang.Exception

testBug35115

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

Tests fix for BUG#35115 - yearIsDateType=false has no effect on result's column type and class.

Throws:

java.lang.Exception

testBug68307

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

Tests fix for BUG#68307 - getFunctionColumns() returns incorrect "COLUMN_TYPE" information. This is a JDBC4 feature.

Throws:

java.lang.Exception

checkFunctionColumnTypeForBug68307

private void checkFunctionColumnTypeForBug68307(java.lang.String testAgainst,
                                                java.sql.DatabaseMetaData testDbMetaData)
                                         throws java.lang.Exception

Throws:

java.lang.Exception

checkProcedureColumnTypeForBug68307

private void checkProcedureColumnTypeForBug68307(java.lang.String testAgainst,
                                                 java.sql.DatabaseMetaData testDbMetaData)
                                          throws java.lang.Exception

Throws:

java.lang.Exception

testBug44451

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

Tests fix for BUG#44451 - getTables does not return resultset with expected columns.

Throws:

java.lang.Exception

checkReturnedColumnsForBug44451

private void checkReturnedColumnsForBug44451(java.lang.String stepDescription,
                                             java.lang.String methodName,
                                             java.util.List<java.lang.String> expectedFields,
                                             java.sql.ResultSet resultSetToCheck)
                                      throws java.lang.Exception

Throws:

java.lang.Exception

testBug20504139

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

Tests fix for BUG#20504139 - GETFUNCTIONCOLUMNS() AND GETPROCEDURECOLUMNS() RETURNS ERROR FOR VALID INPUTS.

Throws:

java.lang.Exception

testBug21215151

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

Tests fix for BUG#21215151 - DATABASEMETADATA.GETCATALOGS() FAILS TO SORT RESULTS. DatabaseMetaData.GetCatalogs() relies on the results of 'SHOW DATABASES' which deliver a sorted list of databases except for 'information_schema' which is always returned in the first position. This test creates set of databases around the relative position of 'information_schema' and checks the ordering of the final ResultSet.

Throws:

java.lang.Exception

testBug19803348

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

Tests fix for BUG#19803348 - GETPROCEDURES() RETURNS INCORRECT O/P WHEN USEINFORMATIONSCHEMA=FALSE. Composed by two parts: 1. Confirm that getProcedures() and getProcedureColumns() aren't returning more results than expected (as per reported bug). 2. Confirm that the results from getProcedures() and getProcedureColumns() are in the right order (secondary bug).

Throws:

java.lang.Exception

testBug20727196

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

Tests fix for BUG#20727196 - GETPROCEDURECOLUMNS() RETURNS EXCEPTION FOR FUNCTION WHICH RETURNS ENUM/SET TYPE.

Throws:

java.lang.Exception

testBug76187

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

Tests fix for BUG#76187 (20675539), getTypeInfo report maximum precision of 255 for varchar.

Throws:

java.lang.Exception

testBug21978216

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

Tests fix for BUG#21978216, GETTYPEINFO REPORT MAXIMUM PRECISION OF 255 FOR VARBINARY

Throws:

java.lang.Exception

testBug23212347

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

Tests fix for Bug#23212347, ALL API CALLS ON RESULTSET METADATA RESULTS IN NPE WHEN USESERVERPREPSTMTS=TRUE.

Throws:

java.lang.Exception

testBug73775

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

Tests fix for Bug#73775 - DBMD.getProcedureColumns()/.getFunctionColumns() fail to filter by columnPattern

Throws:

java.lang.Exception

testBug87826

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

Tests fix for BUG#87826 (26846249), MYSQL JDBC CONNECTOR/J DATABASEMETADATA NULL PATTERN HANDLING IS NON-COMPLIANT.

Throws:

java.lang.Exception

testBug90887

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

Tests fix for BUG#90887 (28034570), DATABASEMETADATAUSINGINFOSCHEMA#GETTABLES FAILS IF METHOD ARGUMENTS ARE NULL.

Throws:

java.lang.Exception

testBug29186870

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

Tests fix for BUG#29186870, CONNECTOR/J REGRESSION: NOT RETURNING PRECISION GETPROCEDURECOLUMNS.

Throws:

java.lang.Exception

testBug97413

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

Tests fix for Bug#97413 (30477722), DATABASEMETADATA IS BROKEN AFTER SERVER WL#13528.

Throws:

java.lang.Exception

testBug102076

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

Tests fix for Bug#102076 (32329915), CONTRIBUTION: MYSQL JDBC DRIVER RESULTSET.GETLONG() THROWS NUMBEROUTOFRANGE.

Throws:

java.lang.Exception

testBug95280

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

Tests fix for Bug#95280 (29757140), DATABASEMETADATA.GETIMPORTEDKEYS RETURNS DOUBLE THE ROWS.

Throws:

java.lang.Exception

testBug104641

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

Tests fix for Bug#104641 (33237255), DatabaseMetaData.getImportedKeys can return duplicated foreign keys.

Throws:

java.lang.Exception

testBug33723611

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

Tests fix for Bug#33723611, getDefaultTransactionIsolation must return repeatable read.

Throws:

java.lang.Exception

testBug82084

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

Tests fix for Bug#82084 (23743938), YEAR DATA TYPE RETURNS INCORRECT VALUE FOR JDBC GETCOLUMNTYPE().

Throws:

java.lang.Exception

testBug106758

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

Tests fix for Bug#106758 (33973048), DatabaseMetaData.getTypeInfo returns AUTO_INCREMENT = false for all datatypes.

Throws:

java.lang.Exception

testBug109807

@Test
void testBug109807()
                  throws java.lang.Exception

Tests fix for Bug#109807 (Bug#35021014), DatabaseMetaData#getTypeInfo should ordered by DATA_TYPE.

Throws:

java.lang.Exception

testBug109808

@Test
void testBug109808()
                  throws java.lang.Exception

Tests fix for Bug#109808 (Bug#35021038), DatabaseMetaData#getPrimaryKeys should ordered by COLUMN_NAME.

Throws:

java.lang.Exception