public class CallableStatementRegressionTest extends BaseTestCase
BaseTestCase.MockConnectionConfigurationconn, dbClass, dbName, dbUrl, isOpenSSL, mainConnectionUrl, pstmt, rs, serverVersion, stmt, timeZoneFreeDbUrl| Constructor and Description |
|---|
CallableStatementRegressionTest() |
| Modifier and Type | Method and Description |
|---|---|
private void |
execProcBug49831(java.sql.Connection c) |
void |
testBitSp() |
void |
testBug10310()
Tests fix forBUG#10310 - Driver doesn't support {?=CALL(...)} for calling stored functions.
|
void |
testBug12417()
Tests fix for Bug#12417 - stored procedure catalog name is case-sensitive on Windows
(this is actually a server bug, but we have a workaround in place for it now).
|
void |
testBug15121() |
void |
testBug15464()
Tests fix for BUG#15464 - INOUT parameter does not store IN value.
|
void |
testBug17898()
Tests fix for BUG#17898 - registerOutParameter not working when some parameters pre-populated.
|
void |
testBug19857166()
Tests fix for Bug#19857166, SET FUNCTIONS ON CALLABLESTATEMENT RETURNS EXCEPTION WHEN CALLED WITH PARAM NAME.
|
void |
testBug20279641()
Tests fix for Bug#20279641, CANNOT CALL A PROCEDURE USING `DATABASE`.PROCNAME FORMAT.
|
void |
testBug21462()
Tests fix for BUG#21462 - JDBC (and ODBC) specifications allow no-parenthesis CALL statements for procedures with no arguments, MySQL server does not.
|
void |
testBug22024()
Tests fix for BUG#22024 - Newlines causing whitespace to span confuse procedure parser when getting parameter metadata for stored procedures.
|
void |
testBug22297()
Tests workaround for server crash when calling stored procedures via a server-side prepared statement
(driver now detects prepare(stored procedure) and substitutes client-side prepared statement).
|
void |
testBug25379()
Tests fix for BUG#25379 - INOUT parameters in CallableStatements get doubly-escaped.
|
void |
testBug25715()
Tests fix for BUG#25715 - CallableStatements with OUT/INOUT parameters that are "binary" have extra 7 bytes (which happens to be the _binary introducer!)
|
void |
testBug26143() |
void |
testBug26259384()
Tests fix for BUG#26259384 - CALLABLE STATEMENT GIVES ERROR IN C/JAVA WHEN RUN AGAINST MYSQL 8.0
|
void |
testBug26959()
Tests fix for BUG#26959 - comments confuse procedure parser.
|
void |
testBug27400()
Tests fix for BUG#27400 - CALL [comment] some_proc() doesn't work
|
void |
testBug28689()
Tests fix for BUG#28689 - CallableStatement.executeBatch() doesn't work when connection property "noAccessToProcedureBodies" has been set to "true".
|
void |
testBug31823()
Tests fix for Bug#31823 - CallableStatement.setNull() on a stored function would throw an ArrayIndexOutOfBounds when setting the last parameter to null
when calling setNull().
|
void |
testBug35199() |
void |
testBug3539()
Tests fix for BUG#3539 getProcedures() does not return any procedures in result set
|
void |
testBug3540()
Tests fix for BUG#3540 getProcedureColumns doesn't work with wildcards for procedure name
|
void |
testBug38954()
Tests fix for Bug#38954 (11749415), DATA TRUNCATION WHILE USING BIT(1) IN STORED PROCEDURE WITH INOUT TYPE.
|
void |
testBug43576() |
void |
testBug49831() |
void |
testBug57022()
Tests fix for Bug#57022 - cannot execute a store procedure with output parameters
Problem was in CallableStatement.java,
private void determineParameterTypes() throws SQLException
if (procName.indexOf(".") == -1) {
useCatalog = true;
}
The fix will be to "sanitize" db.sp call just like in noAccessToProcedureBodies. |
void |
testBug60816()
Tests fix for BUG#60816 - Cannot pass NULL to an INOUT procedure parameter
|
void |
testBug7026()
Tests fix for BUG#7026 - DBMD.getProcedures() doesn't respect catalog parameter
|
void |
testBug79561()
Tests fix for Bug#79561 - NullPointerException when calling a fully qualified stored procedure
|
void |
testBug84324()
Tests fix for Bug#84324 - CallableStatement.extractProcedureName() not work when catalog name with dash.
|
void |
testBug87704()
Tests fix for BUG#87704 (26771560) - THE STREAM GETS THE RESULT SET ?THE DRIVER SIDE GET WRONG ABOUT GETLONG().
|
void |
testBug9319()
Tests fix for BUG#9319 -- Stored procedures with same name in different databases confuse the driver when it tries to determine parameter counts/types.
|
void |
testBug9682()
Tests fix for BUG#9682 - Stored procedures with DECIMAL parameters with storage specifications that contained "," in them would fail.
|
void |
testHugeNumberOfParameters() |
void |
testNotReallyCallableStatement() |
void |
testPrepareOfMultiRs() |
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 testBug3539()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug3540()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug7026()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug9319()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug9682()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug10310()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug12417()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug15121()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug15464()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug17898()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug21462()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug22024()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug22297()
throws java.lang.Exception
java.lang.Exception@Test
public void testHugeNumberOfParameters()
throws java.lang.Exception
java.lang.Exception@Test
public void testPrepareOfMultiRs()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug25379()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug25715()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug26143()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug26959()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug27400()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug28689()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug31823()
throws java.lang.Exception
java.lang.Exception@Test
public void testBitSp()
throws java.lang.Exception
java.lang.Exception@Test
public void testNotReallyCallableStatement()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug35199()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug49831()
throws java.lang.Exception
java.lang.Exceptionprivate void execProcBug49831(java.sql.Connection c)
throws java.lang.Exception
java.lang.Exception@Test
public void testBug43576()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug57022()
throws java.lang.Exception
private void determineParameterTypes() throws SQLException
if (procName.indexOf(".") == -1) {
useCatalog = true;
}
The fix will be to "sanitize" db.sp call just like in noAccessToProcedureBodies.java.lang.Exception@Test
public void testBug60816()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug79561()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug84324()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug26259384()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug87704()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug20279641()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug19857166()
throws java.lang.Exception
java.lang.Exception@Test
public void testBug38954()
throws java.lang.Exception
java.lang.Exception