testsuite.regression

Class NumbersRegressionTest

java.lang.Object

testsuite.BaseTestCase

testsuite.regression.NumbersRegressionTest

public class NumbersRegressionTest
extends BaseTestCase

Tests various number-handling issues that have arisen in the JDBC driver at one time or another.

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

Method Summary

Modifier and Type	Method and Description
void	testBigInt() Tests that BIGINT retrieval works correctly
void	testBug105915() Tests fix for Bug#105915 (33678490), Connector/J 8 server prepared statement precision loss in execute batch.
void	testBug5729() Tests fix for BUG#5729, UNSIGNED BIGINT returned incorrectly
void	testBug8484() Deprecated.
void	testFloatsAndReals() Tests correct type assignment for MySQL FLOAT and REAL datatypes.
void	testIntShouldReturnLong()
void	testPrecisionAndScale() Tests that ResultSetMetaData precision and scale methods work correctly for all numeric types.
private void	testPrecisionForType(java.lang.String typeName, int m, int d, boolean unsigned)

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

NumbersRegressionTest

public NumbersRegressionTest()

Method Detail

testBigInt

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

Tests that BIGINT retrieval works correctly

Throws:

java.lang.Exception

testFloatsAndReals

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

Tests correct type assignment for MySQL FLOAT and REAL datatypes.

Throws:

java.lang.Exception

testPrecisionAndScale

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

Tests that ResultSetMetaData precision and scale methods work correctly for all numeric types.

Throws:

java.lang.Exception

testPrecisionForType

private void testPrecisionForType(java.lang.String typeName,
                                  int m,
                                  int d,
                                  boolean unsigned)
                           throws java.lang.Exception

Throws:

java.lang.Exception

testIntShouldReturnLong

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

Throws:

java.lang.Exception

testBug5729

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

Tests fix for BUG#5729, UNSIGNED BIGINT returned incorrectly

Throws:

java.lang.Exception

testBug8484

@Deprecated
 @Test
public void testBug8484()
                                    throws java.lang.Exception

Deprecated.

Tests fix for BUG#8484 - ResultSet.getBigDecimal() throws exception when rounding would need to occur to set scale.

Throws:

java.lang.Exception

testBug105915

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

Tests fix for Bug#105915 (33678490), Connector/J 8 server prepared statement precision loss in execute batch.

Throws:

java.lang.Exception