testsuite.regression

Class DateTimeRegressionTest

java.lang.Object

testsuite.BaseTestCase

testsuite.regression.DateTimeRegressionTest

public class DateTimeRegressionTest
extends BaseTestCase

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

Method Summary

Modifier and Type	Method and Description
private void	subTestBug20391832(java.util.Properties props, MysqlType targetType, java.lang.String val, java.lang.String exp)
void	testBug101413() Tests fix for Bug#101413 (32099505), JAVA.TIME.LOCALDATETIME CANNOT BE CAST TO JAVA.SQL.TIMESTAMP.
void	testBug104559() Tests fix for Bug#104559 (33232419), ResultSet.getObject(i, java.util.Date.class) throws NPE when the value is null.
void	testBug15604() Tests fix for Bug#15604 (11745460), TIMEZONE DISCARDED STORING JAVA.UTIL.CALENDAR INTO DATETIME.
void	testBug20316640() Tests fix for Bug#20316640, GETTIMESTAMP() CALL WITH CALANDER VALUE NULL RESULTS IN NULLPOINTEREXCEPTION.
void	testBug20391832() Tests fix for Bug#20391832, SETOBJECT() FOR TYPES.TIME RESULTS IN EXCEPTION WHEN VALUE HAS FRACTIONAL PART.
void	testBug20818678() Tests fix for Bug#20818678, GETFLOAT() AND GETDOUBLE() CALL ON YEAR COLUMN RESULTS IN EXCEPTION
void	testBug21308907() Tests fix for Bug#21308907, NO WAY TO GET THE FRACTIONAL PART OF A TIME FIELD WHEN USESERVERPREPSTMTS=TRUE.
void	testBug22305930() Tests fix for Bug#22305930, GETTIMESTAMP() CALL ON CLOSED RESULT SET PRODUCES NPE.
void	testBug3620() Tests fix for BUG#3620 -- Timezone not respected correctly.
void	testBug5874() Tests fix for Bug#5874, Timezone conversion goes in the wrong direction (when useTimezone=true and server timezone differs from client timezone).

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

DateTimeRegressionTest

public DateTimeRegressionTest()

Method Detail

testBug3620

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

Tests fix for BUG#3620 -- Timezone not respected correctly.

Throws:

java.sql.SQLException

testBug5874

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

Tests fix for Bug#5874, Timezone conversion goes in the wrong direction (when useTimezone=true and server timezone differs from client timezone).

Throws:

java.lang.Exception

testBug15604

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

Tests fix for Bug#15604 (11745460), TIMEZONE DISCARDED STORING JAVA.UTIL.CALENDAR INTO DATETIME.

Throws:

java.lang.Exception

testBug20391832

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

Tests fix for Bug#20391832, SETOBJECT() FOR TYPES.TIME RESULTS IN EXCEPTION WHEN VALUE HAS FRACTIONAL PART.

Throws:

java.lang.Exception

subTestBug20391832

private void subTestBug20391832(java.util.Properties props,
                                MysqlType targetType,
                                java.lang.String val,
                                java.lang.String exp)
                         throws java.lang.Exception

Throws:

java.lang.Exception

testBug20316640

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

Tests fix for Bug#20316640, GETTIMESTAMP() CALL WITH CALANDER VALUE NULL RESULTS IN NULLPOINTEREXCEPTION.

Throws:

java.lang.Exception

testBug20818678

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

Tests fix for Bug#20818678, GETFLOAT() AND GETDOUBLE() CALL ON YEAR COLUMN RESULTS IN EXCEPTION

Throws:

java.lang.Exception

testBug21308907

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

Tests fix for Bug#21308907, NO WAY TO GET THE FRACTIONAL PART OF A TIME FIELD WHEN USESERVERPREPSTMTS=TRUE.

Throws:

java.lang.Exception

testBug22305930

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

Tests fix for Bug#22305930, GETTIMESTAMP() CALL ON CLOSED RESULT SET PRODUCES NPE.

Throws:

java.lang.Exception

testBug101413

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

Tests fix for Bug#101413 (32099505), JAVA.TIME.LOCALDATETIME CANNOT BE CAST TO JAVA.SQL.TIMESTAMP.

Throws:

java.lang.Exception

testBug104559

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

Tests fix for Bug#104559 (33232419), ResultSet.getObject(i, java.util.Date.class) throws NPE when the value is null.

Throws:

java.lang.Exception