CallableStatementRegressionTest

java.lang.Object
- testsuite.BaseTestCase
- - testsuite.regression.CallableStatementRegressionTest

public class CallableStatementRegressionTest
extends BaseTestCase

Tests fixes for bugs in CallableStatement code.

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

CallableStatementRegressionTest()

Constructors
Constructor and Description
`CallableStatementRegressionTest()`

Method Summary

All Methods Instance Methods Concrete Methods
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()`

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
  - CallableStatementRegressionTest
```
public CallableStatementRegressionTest()
```
- Method Detail
  - testBug3539
```
@Test
public void testBug3539()
                       throws java.lang.Exception
```
    Tests fix for BUG#3539 getProcedures() does not return any procedures in result set
    
    Throws:
    
    java.lang.Exception
  - testBug3540
```
@Test
public void testBug3540()
                       throws java.lang.Exception
```
    Tests fix for BUG#3540 getProcedureColumns doesn't work with wildcards for procedure name
    
    Throws:
    
    java.lang.Exception
  - testBug7026
```
@Test
public void testBug7026()
                       throws java.lang.Exception
```
    Tests fix for BUG#7026 - DBMD.getProcedures() doesn't respect catalog parameter
    
    Throws:
    
    java.lang.Exception
  - testBug9319
```
@Test
public void testBug9319()
                       throws java.lang.Exception
```
    Tests fix for BUG#9319 -- Stored procedures with same name in different databases confuse the driver when it tries to determine parameter counts/types.
    
    Throws:
    
    java.lang.Exception
  - testBug9682
```
@Test
public void testBug9682()
                       throws java.lang.Exception
```
    Tests fix for BUG#9682 - Stored procedures with DECIMAL parameters with storage specifications that contained "," in them would fail.
    
    Throws:
    
    java.lang.Exception
  - testBug10310
```
@Test
public void testBug10310()
                        throws java.lang.Exception
```
    Tests fix forBUG#10310 - Driver doesn't support {?=CALL(...)} for calling stored functions. This involved adding support for function retrieval to DatabaseMetaData.getProcedures() and getProcedureColumns() as well.
    
    Throws:
    
    java.lang.Exception
  - testBug12417
```
@Test
public void testBug12417()
                        throws java.lang.Exception
```
    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).
    
    Throws:
    
    java.lang.Exception
  - testBug15121
```
@Test
public void testBug15121()
                        throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testBug15464
```
@Test
public void testBug15464()
                        throws java.lang.Exception
```
    Tests fix for BUG#15464 - INOUT parameter does not store IN value.
    
    Throws:
    
    java.lang.Exception
  - testBug17898
```
@Test
public void testBug17898()
                        throws java.lang.Exception
```
    Tests fix for BUG#17898 - registerOutParameter not working when some parameters pre-populated. Still waiting for feedback from JDBC experts group to determine what correct parameter count from getMetaData() should be, however.
    
    Throws:
    
    java.lang.Exception
  - testBug21462
```
@Test
public void testBug21462()
                        throws java.lang.Exception
```
    Tests fix for BUG#21462 - JDBC (and ODBC) specifications allow no-parenthesis CALL statements for procedures with no arguments, MySQL server does not.
    
    Throws:
    
    java.lang.Exception
  - testBug22024
```
@Test
public void testBug22024()
                        throws java.lang.Exception
```
    Tests fix for BUG#22024 - Newlines causing whitespace to span confuse procedure parser when getting parameter metadata for stored procedures.
    
    Throws:
    
    java.lang.Exception
  - testBug22297
```
@Test
public void testBug22297()
                        throws java.lang.Exception
```
    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).
    
    Throws:
    
    java.lang.Exception
  - testHugeNumberOfParameters
```
@Test
public void testHugeNumberOfParameters()
                                      throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testPrepareOfMultiRs
```
@Test
public void testPrepareOfMultiRs()
                                throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testBug25379
```
@Test
public void testBug25379()
                        throws java.lang.Exception
```
    Tests fix for BUG#25379 - INOUT parameters in CallableStatements get doubly-escaped.
    
    Throws:
    
    java.lang.Exception
  - testBug25715
```
@Test
public void testBug25715()
                        throws java.lang.Exception
```
    Tests fix for BUG#25715 - CallableStatements with OUT/INOUT parameters that are "binary" have extra 7 bytes (which happens to be the _binary introducer!)
    
    Throws:
    
    java.lang.Exception
  - testBug26143
```
@Test
public void testBug26143()
                        throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testBug26959
```
@Test
public void testBug26959()
                        throws java.lang.Exception
```
    Tests fix for BUG#26959 - comments confuse procedure parser.
    
    Throws:
    
    java.lang.Exception
  - testBug27400
```
@Test
public void testBug27400()
                        throws java.lang.Exception
```
    Tests fix for BUG#27400 - CALL [comment] some_proc() doesn't work
    
    Throws:
    
    java.lang.Exception
  - testBug28689
```
@Test
public void testBug28689()
                        throws java.lang.Exception
```
    Tests fix for BUG#28689 - CallableStatement.executeBatch() doesn't work when connection property "noAccessToProcedureBodies" has been set to "true". The fix involves changing the behavior of "noAccessToProcedureBodies", in that the driver will now report all paramters as "IN" paramters but allow callers to call registerOutParameter() on them.
    
    Throws:
    
    java.lang.Exception
  - testBug31823
```
@Test
public void testBug31823()
                        throws java.lang.Exception
```
    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().
    
    Throws:
    
    java.lang.Exception
  - testBitSp
```
@Test
public void testBitSp()
                     throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testNotReallyCallableStatement
```
@Test
public void testNotReallyCallableStatement()
                                          throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testBug35199
```
@Test
public void testBug35199()
                        throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testBug49831
```
@Test
public void testBug49831()
                        throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - execProcBug49831
```
private void execProcBug49831(java.sql.Connection c)
                       throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testBug43576
```
@Test
public void testBug43576()
                        throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testBug57022
```
@Test
public void testBug57022()
                        throws java.lang.Exception
```
    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.
    
    Throws:
    
    java.lang.Exception
  - testBug60816
```
@Test
public void testBug60816()
                        throws java.lang.Exception
```
    Tests fix for BUG#60816 - Cannot pass NULL to an INOUT procedure parameter
    
    Throws:
    
    java.lang.Exception
  - testBug79561
```
@Test
public void testBug79561()
                        throws java.lang.Exception
```
    Tests fix for Bug#79561 - NullPointerException when calling a fully qualified stored procedure
    
    Throws:
    
    java.lang.Exception
  - testBug84324
```
@Test
public void testBug84324()
                        throws java.lang.Exception
```
    Tests fix for Bug#84324 - CallableStatement.extractProcedureName() not work when catalog name with dash.
    
    Throws:
    
    java.lang.Exception
  - testBug26259384
```
@Test
public void testBug26259384()
                           throws java.lang.Exception
```
    Tests fix for BUG#26259384 - CALLABLE STATEMENT GIVES ERROR IN C/JAVA WHEN RUN AGAINST MYSQL 8.0
    
    Throws:
    
    java.lang.Exception
  - testBug87704
```
@Test
public void testBug87704()
                        throws java.lang.Exception
```
    Tests fix for BUG#87704 (26771560) - THE STREAM GETS THE RESULT SET ?THE DRIVER SIDE GET WRONG ABOUT GETLONG().
    
    Throws:
    
    java.lang.Exception
  - testBug20279641
```
@Test
public void testBug20279641()
                           throws java.lang.Exception
```
    Tests fix for Bug#20279641, CANNOT CALL A PROCEDURE USING `DATABASE`.PROCNAME FORMAT.
    
    Throws:
    
    java.lang.Exception
  - testBug19857166
```
@Test
public void testBug19857166()
                           throws java.lang.Exception
```
    Tests fix for Bug#19857166, SET FUNCTIONS ON CALLABLESTATEMENT RETURNS EXCEPTION WHEN CALLED WITH PARAM NAME.
    
    Throws:
    
    java.lang.Exception
  - testBug38954
```
@Test
public void testBug38954()
                        throws java.lang.Exception
```
    Tests fix for Bug#38954 (11749415), DATA TRUNCATION WHILE USING BIT(1) IN STORED PROCEDURE WITH INOUT TYPE.
    
    Throws:
    
    java.lang.Exception

Class CallableStatementRegressionTest

Nested Class Summary

Nested classes/interfaces inherited from class testsuite.BaseTestCase

Field Summary

Fields inherited from class testsuite.BaseTestCase

Constructor Summary

Method Summary

Methods inherited from class testsuite.BaseTestCase

Methods inherited from class java.lang.Object

Constructor Detail

CallableStatementRegressionTest

Method Detail

testBug3539

testBug3540

testBug7026

testBug9319

testBug9682

testBug10310

testBug12417

testBug15121

testBug15464

testBug17898

testBug21462

testBug22024

testBug22297

testHugeNumberOfParameters

testPrepareOfMultiRs

testBug25379

testBug25715

testBug26143

testBug26959

testBug27400

testBug28689

testBug31823

testBitSp

testNotReallyCallableStatement

testBug35199

testBug49831

execProcBug49831

testBug43576

testBug57022

testBug60816

testBug79561

testBug84324

testBug26259384

testBug87704

testBug20279641

testBug19857166

testBug38954