testsuite.regression

Class ResultSetRegressionTest

java.lang.Object

testsuite.BaseTestCase

testsuite.regression.ResultSetRegressionTest

public class ResultSetRegressionTest
extends BaseTestCase

Regression test cases for the ResultSet class.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	ResultSetRegressionTest.TestBug67318ExceptionInterceptor

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

Method Summary

Modifier and Type	Method and Description
private void	checkBug20306()
private void	checkEmptyConvertToZero()
private void	checkEmptyConvertToZeroException()
private void	checkRangeMatrix(java.sql.Connection c)
private void	checkRanges()
private void	checkResult17450()
private void	checkResultsBug19568()
private void	checkTimestampNanos()
private void	checkUpdatabilityMessage(java.sql.SQLException sqlEx, java.lang.String messageToCheck)
private void	exercise35610(java.sql.Statement configuredStmt, boolean force30Behavior)
private void	exerciseUpdatableResultSet(int columnUpdateIndex, java.lang.String messageToCheck)
private void	testAllFieldsForNotNull(java.sql.ResultSet rsToTest, java.util.List<java.lang.Boolean> wasDatetimeTypeList)
private void	testAllFieldsForNull(java.sql.ResultSet rsToTest)
void	testAllTypesForNull()
void	testBogusTimestampAsString()
void	testBooleans()
void	testBug10156() Tests fix for BUG#10156 - Unsigned SMALLINT treated as signed
void	testBug10212()
void	testBug102131() Tests fix for Bug#102131 (32338451), UPDATABLERESULTSET NPE WHEN USING DERIVED QUERIES OR VIEWS.
void	testBug102321() Tests fix for Bug#102321 (32405590), CALLING RESULTSETMETADATA.GETCOLUMNCLASSNAME RETURNS WRONG VALUE FOR DATETIME.
(package private) void	testBug102678() Tests fix for Bug#102678 (Bug#32536384), Connector/J 8 query with explain can not return ResultRow.
void	testBug10485() Tests fix for BUG#10485, SQLException thrown when retrieving YEAR(2) with ResultSet.getString().
void	testBug105197() Tests fix for Bug#105197 (33461744), Statement.executeQuery() may return non-navigable ResultSet.
void	testBug11190() Tests fix for BUG#11190 - ResultSet.moveToCurrentRow() fails to work when preceded with .moveToInsertRow().
void	testBug11552() Tests fix for BUG#11552, wrong values returned from server-side prepared statements if values are unsigned.
void	testBug12104() Tests fix for BUG#12104 - Geometry types not handled with server-side prepared statements.
void	testBug14562() Tests bugfix for BUG#14562 - metadata/type for MEDIUMINT UNSIGNED is incorrect.
void	testBug14609() Tests fix for BUG#14609 - Exception thrown for new decimal type when using updatable result sets.
void	testBug14897()
void	testBug15677() Tests fix for BUG#15677, wrong values returned from getShort() if SQL values are tinyint unsigned.
void	testBug1592() Checks fix for BUG#1592 -- cross-database updatable result sets are not checked for updatability correctly.
void	testBug16169() Tests fix for BUG#16169 - ResultSet.getNativeShort() causes stack overflow error via recurisve calls.
void	testBug16841() Tests fix for BUG#16841 - updatable result set doesn't return AUTO_INCREMENT values for insertRow() when multiple column primary keys are used.
void	testBug17450() Tests fix for BUG#17450 - ResultSet.wasNull() not always reset correctly for booleans when done via conversion for server-side prepared statements.
void	testBug18880() Tests fix for BUG#18880 - ResultSet.getFloatFromString() can't retrieve values near Float.MIN/MAX_VALUE.
void	testBug19282() Tests fix for BUG#19282 - ResultSet.wasNull() returns incorrect value when extracting native string from server-side prepared statement generated result set.
void	testBug19536760() Tests fix for BUG#19536760 - GETSTRING() CALL AFTER RS.RELATIVE() RETURNS NULLPOINTEREXCEPTION
private void	testBug19536760CheckStates(java.sql.ResultSet rset, boolean expectedIsBeforeFirst, boolean expectedIsFirst, boolean expectedIsLast, boolean expectedIsAfterLast)
void	testBug19568() Tests fix for BUG#19568
void	testBug19724()
void	testBug19805370() Tests fix for Bug#19805370, GETBINARYSTREAM() WITH INVALID COLUMN INDEX RETURNS EXCEPTION.
void	testBug2006() Tests fix for BUG#2006, where 2 columns with same name in a result set are returned via findColumn() in the wrong order...The JDBC spec states, that the _first_ matching column should be returned.
void	testBug20306() Tests fix for BUG#20306 - ResultSet.getShort() for UNSIGNED TINYINT returns incorrect values when using server-side prepared statements.
void	testBug20391631() Tests fix for Bug#20391631, GETBOOLEAN() CALL RESULTS IN EXCEPTION WHEN USEUSAGEADVISOR = TRUE.
void	testBug20391659() Tests fix for Bug#20391659, GETBYTE() CALL RESULTS IN EXCEPTION WHEN USEUSAGEADVISOR = TRUE.
void	testBug20479() Tests fix for BUG#20479 - Updatable result set throws ClassCastException when there is row data and moveToInsertRow() is called.
void	testBug20485() Tests fix for BUG#20485 - Updatable result set that contains a BIT column fails when server-side prepared statements are used.
void	testBug20802947() Tests fix for Bug#20802947, RESULTSET UPDATE METHODS FAILS WHEN TABLENAME CONTAINS SPECIAL CHARACTERS.
void	testBug20804635() Tests for fix to BUG#20804635 - GETTIME() AND GETDATE() FUNCTIONS FAILS WHEN FRACTIONAL PART EXISTS
void	testBug20913289() Tests fix for Bug#20913289, PSTMT.EXECUTEUPDATE() FAILS WHEN SQL MODE IS NO_BACKSLASH_ESCAPES.
void	testBug21062() Tests fix for BUG#21062 - ResultSet.getSomeInteger() doesn't work for BIT(>1)
void	testBug21379() Tests fix(es) for BUG#21379 - column names don't match metadata in cases where server doesn't return original column names (functions) thus breaking compatibility with applications that expect 1-1 mappings between findColumn() and rsmd.getColumnName().
void	testBug21814() Tests fix for BUG#21814 - time values outside valid range silently wrap
void	testBug22305979() Tests fix for Bug#22305979, WRONG RECORD UPDATED IF SENDFRACTIONALSECONDS=FALSE AND SMT IS SCROLLABLE.
void	testBug22931433() Tests fix for Bug#22931433, GETTING VALUE OF BIT COLUMN RESULTS IN EXCEPTION.
void	testBug23197238() Tests fix for Bug#23197238 - EXECUTEQUERY() FAILS FOR JSON DATA WHEN RESULTSETCONCURRENCY=CONCUR_UPDATABLE.
private void	testBug23197238AssertDoc(java.lang.String[] expectedDoc)
private void	testBug23197238AssertId(int[] expectedId)
void	testBug2359() Tests fix for BUG#2359 -- Numeric types and server-side prepared statements incorrectly detect nulls.
void	testBug23702040() Tests fix for BUG#23702040 - JDBCDATEVALUEFACTORY FAILS TO PARSE SOME DATES.
void	testBug24525461() Tests fix for Bug#24525461 - UPDATABLE RESULTSET FEATURE FAILS WHEN USESERVERPREPSTMTS=TRUE
void	testBug24527173() Tests fix for Bug#24527173 - QUERY EXECUTION USING PREPARED STMT FAILS WHEN USECURSORFETCH=TRUE
private void	testBug24527173Results(java.sql.PreparedStatement ps, java.lang.Class<?> expectedResultClass)
void	testBug24710() Tests for a server bug - needs to be revisited when the server is fixed.
void	testBug24886()
void	testBug25215008() Tests fix for Bug#84084 (25215008), JAVA.LANG.ARRAYINDEXOUTOFBOUNDSEXCEPTION ON ATTEMPT TO GET VALUE FROM RESULTSET.
void	testBug25328() Tests fix for BUG#25328 - BIT(> 1) is returned as java.lang.String from ResultSet.getObject() rather than byte[].
void	testBug25517() Tests fix for BUG#25517 - Statement.setMaxRows() is not effective on result sets materialized from cursors.
void	testBug25650305() Tests for fix to BUG#25650305 - GETDATE(),GETTIME() AND GETTIMESTAMP() CALL WITH NULL CALENDAR RETURNS NPE
void	testBug25650385() Tests fix for BUG#25650385, GETBYTE() RETURNS ERROR FOR BINARY() FLD.
void	testBug25650482() Tests fix for Bug#25650482, REFRESHROW() CALL AFTER UPDATEROW() API FAILS WHEN USESERVERPREPSTMTS=TRUE.
void	testBug25650514() Tests fix for Bug#25650514, UPDATEROW() CALL FAILS WITH NPE WHEN SSPS=TRUE AND TABLE HAS MULTI-FLD KEY.
void	testBug25787() Tests fix for BUG#25787 - java.util.Date should be serialized for PreparedStatement.setObject().
void	testBug25894()
void	testBug26173() Tests fix for BUG#26173 - fetching rows via cursor retrieves corrupted data.
void	testBug2623() Tests fix for BUG#2643, ClassCastException when using this.rs.absolute() and server-side prepared statements.
void	testBug26266731() Tests for fix to BUG#26266731 - CONCUR_UPDATABLE RESULTSET OPERATIONS FAIL AGAINST 8.0 FOR BOOLEAN COLUMN
void	testBug2654() Tests fix for BUG#2654, "Column 'column.table' not found" when "order by" in query"
void	testBug26750705() Tests for fix to BUG#26750705, UNSUPPORTED CONVERSION FROM TIME TO JAVA.SQL.DATE
void	testBug26789() Tests fix for BUG#26789 - fast date/time parsing doesn't take into account 00:00:00 as a legal value.
void	testBug27317() Tests fix for BUG#27317 - column index < 1 returns misleading error message.
void	testBug27431()
void	testBug27784363() Tests fix for BUG#27784363, MYSQL 8.0 JDBC DRIVER THROWS NUMBERFORMATEXCEPTION FOR TEXT DATA
void	testBug28085() Tests fix for BUG#28085 - Need more useful error messages for diagnostics when the driver thinks a result set isn't updatable.
void	testBug30474158() Tests fix for Bug#30474158, CONNECTOR/J 8 DOES NOT HONOR THE REQUESTED RESULTSETTYPE SCROLL_INSENSITIVE ETC.
void	testBug30664() Tests fix for BUG#30664.
void	testBug30851() Tests fix for BUG#30851, NPE with null column values when "padCharsWithSpace" is set to "true".
void	testBug31747910() Tests fix for Bug#31747910, BUG 30474158 FIX IMPROVES JDBC COMPLIANCE BUT CHANGES DEFAULT RESULTSETTYPE HANDLING.
void	testBug32525()
void	testBug32954396() Tests fix for Bug#32954396, EXECUTEQUERY HANGS WITH USECURSORFETCH=TRUE & SETFETCHSIZE.
void	testBug33162()
void	testBug33185116() Tests fix for Bug#33185116, Have method ResultSet.getBoolean() supporting conversion of 'T' and 'F' in a VARCHAR to True/False (boolean).
void	testBug33678() Tests fix for Bug#33678 - Multiple result sets not supported in "streaming" mode.
void	testBug34762()
void	testBug34913() Deprecated. because we use deprecated methods
void	testBug35610() Tests fix for BUG#35610, BUG#35150.
void	testBug36051() Test Bug#36051.
void	testBug38252() Tests fix for BUG#38252 - ResultSet.absolute(0) is not behaving according to JDBC specification.
void	testBug38387()
void	testBug39911() Tests fix for BUG#39911 - We don't retrieve nanos correctly when -parsing- a string for a TIMESTAMP.
void	testBug41484_2()
void	testBug41484() Bug #41484 Accessing fields by name after the ResultSet is closed throws NullPointerException.
void	testBug43759()
void	testBug4482() Tests fix for BUG#4482, ResultSet.getObject() returns wrong type for strings when using prepared statements.
void	testBug45757() Bug #45757 - ResultSet.updateRow should throw SQLException when cursor is on insert row
void	testBug4689() Test fix for BUG#4689 - WasNull not getting set correctly for binary result sets.
void	testBug48820()
void	testBug49516()
void	testBug49797()
void	testBug5032() Tests fix for BUG#5032 -- ResultSet.getObject() doesn't return type Boolean for pseudo-bit types from prepared statements on 4.1.x.
void	testBug5069() Tests fix for BUG#5069 -- ResultSet.getMetaData() should not return incorrectly-initialized metadata if the result set has been closed, but should instead throw a SQLException.
void	testBug5136() Tests for BUG#5136, GEOMETRY types getting corrupted, turns out to be a server bug.
void	testBug56479() Tests fix for Bug#56479 - getTimestamp throws exception.
void	testBug5664() Tests fix for BUG#5664, ResultSet.updateByte() when on insert row throws ArrayOutOfBoundsException.
void	testBug5717() Tests our ability to reject NaN and +/- INF in PreparedStatement.setDouble();
void	testBug60313() Bug #60313 bug in com.mysql.jdbc.ResultSetRow.getTimestampFast
void	testBug6231() Tests fix for BUG#6231, ResultSet.getTimestamp() on a column with TIME in it fails.
void	testBug64204() Tests fix for BUG#64204 - ResultSet.close hangs if streaming query is killed
void	testBug6537() Tests fix for server issue that drops precision on aggregate operations on DECIMAL types, because they come back as DOUBLEs.
void	testBug65503() Tests fix for BUG#65503 - ResultSets created by PreparedStatement.getGeneratedKeys() are not close()d.
void	testBug6561() Tests for presence of BUG#6561, NPE thrown when dealing with 0 dates and non-unpacked result sets.
void	testBug6619()
void	testBug67318() Tests fix for Bug#67318 - SQLException thrown on already closed ResultSet
void	testBug6743()
void	testBug68608() Tests for Bug#68608 (Bug#16690898), UpdatableResultSet does not properly handle unsigned primary key.
void	testBug70704() Tests fix for Bug#70704 - Deadlock using UpdatableResultSet.
void	testBug72000() Tests fix for BUG#72000 - java.lang.ArrayIndexOutOfBoundsException on java.sql.ResultSet.getInt(String).
void	testBug72023() Tests fix for BUG#72023 - Avoid byte array creation in MysqlIO#unpackBinaryResultSetRow.
void	testBug72609() Tests fix for Bug#72609 (18749544), SETDATE() NOT USING A PROLEPTIC GREGORIAN CALENDAR.
void	testBug75309() Tests fix for BUG#75309 - mysql connector/J driver in streaming mode will in the blocking state.
void	testBug7686()
void	testBug7715() Tests fix for BUG#7715 - Timestamps converted incorrectly to strings with SSPS and Upd.
void	testBug78685() Tests fix for Bug#78685 - Wrong results when retrieving the value of a BIT column as an integer.
private void	testBug78685CheckData(java.lang.String testCase)
void	testBug80441() Tests fix for Bug#80441 (22850444), SYNTAX ERROR ON RESULTSET.UPDATEROW() WITH SQL_MODE NO_BACKSLASH_ESCAPES.
void	testBug80522() Tests fix for Bug#80522 - Using useCursorFetch leads to data corruption in Connector/J for TIME type.
void	testBug80532() Tests fix for Bug#80532 (22847443), ENCODING OF RESULTSET.UPDATEROW IS BROKEN FOR NON ASCII CHARCTERS.
void	testBug80631() Tests fix for Bug#80631 - ResultSet.getString return garbled result with json type data.
void	testBug81202() Tests fix for BUG#81202 - RESULTSETIMPL.GETOBJECT THROWS NULLPOINTEREXCEPTION WHEN FIELD IS NULL.
void	testBug82707() Tests fix for Bug#82707, WRONG MILLI SECOND VALUE RETURNED FROM TIMESTAMP COLUMN.
void	testBug82964() Tests fix for BUG#82964 - JSR-310 DATA TYPES CREATED THROUGH JAVA.SQL TYPES.
void	testBug83368() Tests fix for Bug#83368 - 5.1.40 regression: wasNull not updated when calling getInt for a bit column.
void	testBug83662() Tests fix for Bug#83662 - NullPointerException while reading NULL boolean value from DB.
void	testBug84189() Tests fix for Bug#84189 - Allow null when extracting java.time.* classes from ResultSet.
void	testBug8428() Tests fix for BUG#8428 - getString() doesn't maintain format stored on server.
void	testBug85941() Tests for fix to BUG#85941 (25924324), WASNULL NOT SET AFTER GETBYTES IS CALLED
void	testBug8868() Tests fix for Bug#8868, DATE_FORMAT() queries returned as BLOBs from getObject().
void	testBug9098() Tests fix for BUG#9098 - Server doesn't give us info to distinguish between CURRENT_TIMESTAMP and 'CURRENT_TIMESTAMP' for default values.
void	testBug91065() Tests fix for Bug#91065 (28101003), ZERODATETIMEBEHAVIOR=CONVERT_TO_NULL SHOULD NOT APPLY TO 00:00:00 TIME COLUMNS.
void	testBug9236() Tests fix for BUG#9236, a continuation of BUG#8868, where functions used in queries that should return non-string types when resolved by temporary tables suddenly become opaque binary strings (work-around for server limitation)
void	testBug92536() Tests fix for Bug#92536 (28692243), UPDATEING SERVER SIDE PREPSTMTS RESULTSET FAIL.
void	testBug9437() Tests fix for BUG#9437, IF() returns type of [B or java.lang.String depending on platform.
void	testBug94457() Tests fix for BUG#94457 (29402209), CONNECTOR/J RESULTSET.GETOBJECT( ..., OFFSETDATETIME.CLASS ) THROWS.
void	testBug94533() Tests fix for BUG#94533 (29446100), GETOBJECT FOR BOXED PRIMITIVE TYPES DOESN'T RETURN NULL FOR NULL COLUMNS.
void	testBug94585() Tests fix for BUG#94585 (29452669), GETTABLENAME() RETURNS NULL FOR A QUERY HAVING COUNT(*) WITH JDBC DRIVER V8.0.12
void	testBug96059() Tests fix for Bug#96059 (29999318), ERROR STREAMING MULTI RESULTSETS WITH MYSQL-CONNECTOR-JAVA 8.0.X.
void	testBug96383() Tests fix for Bug#96383 (30119545) RS.GETTIMESTAMP() HAS DIFFERENT RESULTS FOR TIME FIELDS WITH USECURSORFETCH=TRUE.
void	testBug9684()
void	testBug97724() Tests fix for Bug#97724 (30570721), Contribution: Allow \'3.\' formatted numbers.
void	testBug97757() Tests fix for Bug#97757 (30584907), NULLPOINTEREXCEPTION WITH CACHERESULTSETMETADATA=TRUE AND EXECUTEQUERY OF "SET".
void	testBug99013() Tests fix for Bug#99013 (31074051), AN EXTRA HOUR GETS ADDED TO THE TIMESTAMP WHEN SUBTRACTING INTERVAL 'N' DAYS.
void	testClobberStreamingRS() Tests that streaming result sets are registered correctly.
void	testClobTruncate() Tests for fix to BUG#1130
void	testEmptyResultSetGet()
void	testEmptyStringsWithNumericGetters()
void	testGetLongBug() Tests that ResultSet.getLong() does not truncate values.
void	testGetTimestampWithDate()
void	testIsBeforeFirstOnEmpty() Tests a bug where ResultSet.isBefireFirst() would return true when the result set was empty (which is incorrect)
void	testMetaDataIsWritable() Tests a bug where ResultSet.isBefireFirst() would return true when the result set was empty (which is incorrect)
void	testNextAndPrevious() Tests fix for bug # 496
void	testNotUpdatable() Tests fix for BUG#1630 (not updatable exception turning into NPE on second updateFoo() method call.
void	testNPEWithStatementsAndTime()
void	testNPEWithUsageAdvisor()
void	testRanges()
void	testStreamingRegBug() Tests that streaming result sets are registered correctly.
void	testTruncationDisable()
void	testTruncationOfNonSigDigits() Tests correct detection of truncation of non-sig digits.
void	testUpdatability() Tests that result sets can be updated when all parameters are correctly set.
void	testUpdatabilityAndEscaping() Test fixes for BUG#1071
void	testUpdatabilityWithQuotes() Tests the fix for BUG#661 ...
void	testUpdateClob() Checks whether or not ResultSet.updateClob() is implemented
void	testUsageAdvisorOnZeroRowResultSet()
private void	traverseResultSetBug14562()
private void	tstBug24525461assertResults1(boolean testJSON, java.sql.Statement st)
private void	tstBug24525461assertResults2(boolean testJSON, java.sql.Statement st)
private void	tstBug24525461testBytes(java.util.Properties props, boolean testJSON, java.sql.Statement st)

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

ResultSetRegressionTest

public ResultSetRegressionTest()

Method Detail

testBug2359

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

Tests fix for BUG#2359 -- Numeric types and server-side prepared statements incorrectly detect nulls.

Throws:

java.lang.Exception

testBug2623

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

Tests fix for BUG#2643, ClassCastException when using this.rs.absolute() and server-side prepared statements.

Throws:

java.lang.Exception

testBug2654

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

Tests fix for BUG#2654, "Column 'column.table' not found" when "order by" in query"

Throws:

java.lang.Exception

testClobTruncate

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

Tests for fix to BUG#1130

Throws:

java.lang.Exception

testClobberStreamingRS

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

Tests that streaming result sets are registered correctly.

Throws:

java.lang.Exception

testEmptyResultSetGet

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

Throws:

java.lang.Exception

testBug1592

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

Checks fix for BUG#1592 -- cross-database updatable result sets are not checked for updatability correctly.

Throws:

java.lang.Exception

testBug2006

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

Tests fix for BUG#2006, where 2 columns with same name in a result set are returned via findColumn() in the wrong order...The JDBC spec states, that the _first_ matching column should be returned.

Throws:

java.lang.Exception

testGetLongBug

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

Tests that ResultSet.getLong() does not truncate values.

Throws:

java.lang.Exception

testGetTimestampWithDate

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

Throws:

java.lang.Exception

testIsBeforeFirstOnEmpty

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

Tests a bug where ResultSet.isBefireFirst() would return true when the result set was empty (which is incorrect)

Throws:

java.lang.Exception

testMetaDataIsWritable

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

Tests a bug where ResultSet.isBefireFirst() would return true when the result set was empty (which is incorrect)

Throws:

java.lang.Exception

testNextAndPrevious

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

Tests fix for bug # 496

Throws:

java.lang.Exception

testNotUpdatable

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

Tests fix for BUG#1630 (not updatable exception turning into NPE on second updateFoo() method call.

Throws:

java.lang.Exception

testStreamingRegBug

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

Tests that streaming result sets are registered correctly.

Throws:

java.lang.Exception

testUpdatability

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

Tests that result sets can be updated when all parameters are correctly set.

Throws:

java.lang.Exception

testUpdatabilityAndEscaping

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

Test fixes for BUG#1071

Throws:

java.lang.Exception

testUpdatabilityWithQuotes

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

Tests the fix for BUG#661 ... refreshRow() fails when primary key values have escaped data in them.

Throws:

java.lang.Exception

testUpdateClob

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

Checks whether or not ResultSet.updateClob() is implemented

Throws:

java.lang.Exception

testBug4482

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

Tests fix for BUG#4482, ResultSet.getObject() returns wrong type for strings when using prepared statements.

Throws:

java.lang.Exception

testBug4689

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

Test fix for BUG#4689 - WasNull not getting set correctly for binary result sets.

Throws:

java.lang.Exception

testBug5032

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

Tests fix for BUG#5032 -- ResultSet.getObject() doesn't return type Boolean for pseudo-bit types from prepared statements on 4.1.x.

Throws:

java.lang.Exception

testBug5069

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

Tests fix for BUG#5069 -- ResultSet.getMetaData() should not return incorrectly-initialized metadata if the result set has been closed, but should instead throw a SQLException. Also tests fix for getRow() and getWarnings() and traversal methods.

Throws:

java.lang.Exception

testBug5136

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

Tests for BUG#5136, GEOMETRY types getting corrupted, turns out to be a server bug.

Throws:

java.lang.Exception

testBug5664

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

Tests fix for BUG#5664, ResultSet.updateByte() when on insert row throws ArrayOutOfBoundsException.

Throws:

java.lang.Exception

testBogusTimestampAsString

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

Throws:

java.lang.Exception

testBug5717

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

Tests our ability to reject NaN and +/- INF in PreparedStatement.setDouble();

Throws:

java.lang.Exception

testBug6537

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

Tests fix for server issue that drops precision on aggregate operations on DECIMAL types, because they come back as DOUBLEs.

Throws:

java.lang.Exception

testBug6231

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

Tests fix for BUG#6231, ResultSet.getTimestamp() on a column with TIME in it fails.

Throws:

java.lang.Exception

testBug6619

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

Throws:

java.lang.Exception

testBug6743

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

Throws:

java.lang.Exception

testBug6561

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

Tests for presence of BUG#6561, NPE thrown when dealing with 0 dates and non-unpacked result sets.

Throws:

java.lang.Exception

testBug7686

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

Throws:

java.sql.SQLException

testBug7715

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

Tests fix for BUG#7715 - Timestamps converted incorrectly to strings with SSPS and Upd. Result Sets.

Throws:

java.lang.Exception

testBug8428

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

Tests fix for BUG#8428 - getString() doesn't maintain format stored on server.

Throws:

java.lang.Exception

testBug8868

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

Tests fix for Bug#8868, DATE_FORMAT() queries returned as BLOBs from getObject().

Throws:

java.lang.Exception

testBug9098

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

Tests fix for BUG#9098 - Server doesn't give us info to distinguish between CURRENT_TIMESTAMP and 'CURRENT_TIMESTAMP' for default values.

Throws:

java.lang.Exception

testBug9236

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

Tests fix for BUG#9236, a continuation of BUG#8868, where functions used in queries that should return non-string types when resolved by temporary tables suddenly become opaque binary strings (work-around for server limitation)

Throws:

java.lang.Exception

testBug9437

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

Tests fix for BUG#9437, IF() returns type of [B or java.lang.String depending on platform. Fixed earlier, but in here to catch if it ever regresses.

Throws:

java.lang.Exception

testBug9684

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

Throws:

java.lang.Exception

testBug10156

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

Tests fix for BUG#10156 - Unsigned SMALLINT treated as signed

Throws:

java.lang.Exception

testBug10212

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

Throws:

java.lang.Exception

testBug11190

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

Tests fix for BUG#11190 - ResultSet.moveToCurrentRow() fails to work when preceded with .moveToInsertRow().

Throws:

java.lang.Exception

testBug12104

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

Tests fix for BUG#12104 - Geometry types not handled with server-side prepared statements.

Throws:

java.lang.Exception

testBug14562

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

Tests bugfix for BUG#14562 - metadata/type for MEDIUMINT UNSIGNED is incorrect.

Throws:

java.lang.Exception

testBug14897

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

Throws:

java.lang.Exception

testBug14609

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

Tests fix for BUG#14609 - Exception thrown for new decimal type when using updatable result sets.

Throws:

java.lang.Exception

testBug16169

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

Tests fix for BUG#16169 - ResultSet.getNativeShort() causes stack overflow error via recurisve calls.

Throws:

java.lang.Exception

testBug16841

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

Tests fix for BUG#16841 - updatable result set doesn't return AUTO_INCREMENT values for insertRow() when multiple column primary keys are used.

Throws:

java.lang.Exception

testBug17450

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

Tests fix for BUG#17450 - ResultSet.wasNull() not always reset correctly for booleans when done via conversion for server-side prepared statements.

Throws:

java.lang.Exception

testBug19282

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

Tests fix for BUG#19282 - ResultSet.wasNull() returns incorrect value when extracting native string from server-side prepared statement generated result set.

Throws:

java.lang.Exception

checkResult17450

private void checkResult17450()
                       throws java.lang.Exception

Throws:

java.lang.Exception

testBug19568

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

Tests fix for BUG#19568

Throws:

java.lang.Exception

checkResultsBug19568

private void checkResultsBug19568()
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

testBug19724

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

Throws:

java.lang.Exception

traverseResultSetBug14562

private void traverseResultSetBug14562()
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

testNPEWithUsageAdvisor

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

Throws:

java.lang.Exception

testAllTypesForNull

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

Throws:

java.lang.Exception

testAllFieldsForNull

private void testAllFieldsForNull(java.sql.ResultSet rsToTest)
                           throws java.lang.Exception

Throws:

java.lang.Exception

testAllFieldsForNotNull

private void testAllFieldsForNotNull(java.sql.ResultSet rsToTest,
                                     java.util.List<java.lang.Boolean> wasDatetimeTypeList)
                              throws java.lang.Exception

Throws:

java.lang.Exception

testNPEWithStatementsAndTime

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

Throws:

java.lang.Exception

testEmptyStringsWithNumericGetters

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

Throws:

java.lang.Exception

checkEmptyConvertToZero

private void checkEmptyConvertToZero()
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

checkEmptyConvertToZeroException

private void checkEmptyConvertToZeroException()

testBug10485

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

Tests fix for BUG#10485, SQLException thrown when retrieving YEAR(2) with ResultSet.getString().

Throws:

java.lang.Exception

testBug11552

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

Tests fix for BUG#11552, wrong values returned from server-side prepared statements if values are unsigned.

Throws:

java.lang.Exception

testTruncationOfNonSigDigits

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

Tests correct detection of truncation of non-sig digits.

Throws:

java.lang.Exception

testBug20479

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

Tests fix for BUG#20479 - Updatable result set throws ClassCastException when there is row data and moveToInsertRow() is called.

Throws:

java.lang.Exception

testBug20485

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

Tests fix for BUG#20485 - Updatable result set that contains a BIT column fails when server-side prepared statements are used.

Throws:

java.lang.Exception

testBug20306

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

Tests fix for BUG#20306 - ResultSet.getShort() for UNSIGNED TINYINT returns incorrect values when using server-side prepared statements.

Throws:

java.lang.Exception

checkBug20306

private void checkBug20306()
                    throws java.lang.Exception

Throws:

java.lang.Exception

testBug21062

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

Tests fix for BUG#21062 - ResultSet.getSomeInteger() doesn't work for BIT(>1)

Throws:

java.lang.Exception

testBug18880

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

Tests fix for BUG#18880 - ResultSet.getFloatFromString() can't retrieve values near Float.MIN/MAX_VALUE.

Throws:

java.lang.Exception

testBug15677

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

Tests fix for BUG#15677, wrong values returned from getShort() if SQL values are tinyint unsigned.

Throws:

java.lang.Exception

testBooleans

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

Throws:

java.lang.Exception

testBug21379

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

Tests fix(es) for BUG#21379 - column names don't match metadata in cases where server doesn't return original column names (functions) thus breaking compatibility with applications that expect 1-1 mappings between findColumn() and rsmd.getColumnName().

Throws:

java.lang.Exception

testBug21814

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

Tests fix for BUG#21814 - time values outside valid range silently wrap

Throws:

java.lang.Exception

testBug24710

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

Tests for a server bug - needs to be revisited when the server is fixed. Exists in server versions prior to 5.0.37 and 5.1.16

Throws:

java.lang.Exception

testBug25328

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

Tests fix for BUG#25328 - BIT(> 1) is returned as java.lang.String from ResultSet.getObject() rather than byte[].

Throws:

java.lang.Exception

testBug25517

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

Tests fix for BUG#25517 - Statement.setMaxRows() is not effective on result sets materialized from cursors.

Throws:

java.lang.Exception

testBug25787

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

Tests fix for BUG#25787 - java.util.Date should be serialized for PreparedStatement.setObject(). We add a new configuration option "treatUtilDateAsTimestamp", which is false by default, as (1) We already had specific behavior to treat java.util.Date as a java.sql.Timestamp because it's useful to many folks, and (2) that behavior will very likely be in JDBC-post-4.0 as a requirement.

Throws:

java.lang.Exception

testTruncationDisable

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

Throws:

java.lang.Exception

testUsageAdvisorOnZeroRowResultSet

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

Throws:

java.lang.Exception

testBug25894

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

Throws:

java.lang.Exception

testBug26173

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

Tests fix for BUG#26173 - fetching rows via cursor retrieves corrupted data.

Throws:

java.lang.Exception

testBug26789

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

Tests fix for BUG#26789 - fast date/time parsing doesn't take into account 00:00:00 as a legal value.

Throws:

java.lang.Exception

testBug27317

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

Tests fix for BUG#27317 - column index < 1 returns misleading error message.

Throws:

java.lang.Exception

testBug28085

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

Tests fix for BUG#28085 - Need more useful error messages for diagnostics when the driver thinks a result set isn't updatable.

Throws:

java.lang.Exception

exerciseUpdatableResultSet

private void exerciseUpdatableResultSet(int columnUpdateIndex,
                                        java.lang.String messageToCheck)
                                 throws java.lang.Exception

Throws:

java.lang.Exception

checkUpdatabilityMessage

private void checkUpdatabilityMessage(java.sql.SQLException sqlEx,
                                      java.lang.String messageToCheck)
                               throws java.lang.Exception

Throws:

java.lang.Exception

testBug24886

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

Throws:

java.lang.Exception

testBug30664

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

Tests fix for BUG#30664. Note that this fix only works for MySQL server 5.0.25 and newer, since earlier versions didn't consistently return correct metadata for functions, and thus results from subqueries an functions were indistinguishable from each other, leading to type-related bugs.

Throws:

java.lang.Exception

testBug30851

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

Tests fix for BUG#30851, NPE with null column values when "padCharsWithSpace" is set to "true".

Throws:

java.lang.Exception

testBug33678

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

Tests fix for Bug#33678 - Multiple result sets not supported in "streaming" mode. This fix covers both normal statements, and stored procedures, with the exception of stored procedures with registered OUTPUT parameters, which can't be used at all with "streaming" result sets.

Throws:

java.lang.Exception

testBug33162

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

Throws:

java.lang.Exception

testBug34762

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

Throws:

java.lang.Exception

testBug34913

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

Deprecated. because we use deprecated methods

Throws:

java.lang.Exception

testBug36051

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

Test Bug#36051. NOTE: This behavior changed in Connector/J 6.0. Rollover is no longer supported for java.sql.Time.

Throws:

java.lang.Exception

testBug35610

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

Tests fix for BUG#35610, BUG#35150. We follow the JDBC Spec here, in that the 4.0 behavior is correct, the JDBC-3.0 (and earlier) spec has a bug, but you can get the buggy behavior (allowing column names *and* labels to be used) by setting "useColumnNamesInFindColumn" to "true".

Throws:

java.lang.Exception

exercise35610

private void exercise35610(java.sql.Statement configuredStmt,
                           boolean force30Behavior)
                    throws java.lang.Exception

Throws:

java.lang.Exception

testBug39911

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

Tests fix for BUG#39911 - We don't retrieve nanos correctly when -parsing- a string for a TIMESTAMP.

Throws:

java.lang.Exception

checkTimestampNanos

private void checkTimestampNanos()
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

testBug38387

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

Throws:

java.lang.Exception

testRanges

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

Throws:

java.lang.Exception

checkRangeMatrix

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

Throws:

java.lang.Exception

checkRanges

private void checkRanges()
                  throws java.sql.SQLException

Throws:

java.sql.SQLException

testBug41484

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

Bug #41484 Accessing fields by name after the ResultSet is closed throws NullPointerException.

Throws:

java.lang.Exception

testBug41484_2

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

Throws:

java.lang.Exception

testBug27431

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

Throws:

java.lang.Exception

testBug43759

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

Throws:

java.lang.Exception

testBug32525

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

Throws:

java.lang.Exception

testBug49797

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

Throws:

java.lang.Exception

testBug49516

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

Throws:

java.lang.Exception

testBug48820

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

Throws:

java.lang.Exception

testBug60313

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

Bug #60313 bug in com.mysql.jdbc.ResultSetRow.getTimestampFast

Throws:

java.lang.Exception

testBug65503

@Test
 @Disabled(value="It\'s a very long test")
public void testBug65503()
                                                                   throws java.lang.Exception

Tests fix for BUG#65503 - ResultSets created by PreparedStatement.getGeneratedKeys() are not close()d. To get results quicker add option -Xmx10M, with this option I got an out of memory failure after about 6500 passes.

Throws:

java.lang.Exception

testBug64204

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

Tests fix for BUG#64204 - ResultSet.close hangs if streaming query is killed

Throws:

java.lang.Exception

testBug45757

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

Bug #45757 - ResultSet.updateRow should throw SQLException when cursor is on insert row

Throws:

java.sql.SQLException

testBug38252

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

Tests fix for BUG#38252 - ResultSet.absolute(0) is not behaving according to JDBC specification.

Throws:

java.lang.Exception

testBug67318

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

Tests fix for Bug#67318 - SQLException thrown on already closed ResultSet

Throws:

java.lang.Exception

testBug72000

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

Tests fix for BUG#72000 - java.lang.ArrayIndexOutOfBoundsException on java.sql.ResultSet.getInt(String).

Throws:

java.lang.Exception

testBug72023

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

Tests fix for BUG#72023 - Avoid byte array creation in MysqlIO#unpackBinaryResultSetRow.

Throws:

java.lang.Exception

testBug75309

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

Tests fix for BUG#75309 - mysql connector/J driver in streaming mode will in the blocking state.

Throws:

java.lang.Exception

testBug19536760

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

Tests fix for BUG#19536760 - GETSTRING() CALL AFTER RS.RELATIVE() RETURNS NULLPOINTEREXCEPTION

Throws:

java.lang.Exception

testBug19536760CheckStates

private void testBug19536760CheckStates(java.sql.ResultSet rset,
                                        boolean expectedIsBeforeFirst,
                                        boolean expectedIsFirst,
                                        boolean expectedIsLast,
                                        boolean expectedIsAfterLast)
                                 throws java.lang.Exception

Throws:

java.lang.Exception

testBug20804635

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

Tests for fix to BUG#20804635 - GETTIME() AND GETDATE() FUNCTIONS FAILS WHEN FRACTIONAL PART EXISTS

Throws:

java.lang.Exception

testBug80522

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

Tests fix for Bug#80522 - Using useCursorFetch leads to data corruption in Connector/J for TIME type.

Throws:

java.lang.Exception

testBug56479

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

Tests fix for Bug#56479 - getTimestamp throws exception. This bug occurs exclusively on UpdatableResultSets when retrieving previously set timestamp values.

Throws:

java.lang.Exception

testBug22931433

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

Tests fix for Bug#22931433, GETTING VALUE OF BIT COLUMN RESULTS IN EXCEPTION.

Throws:

java.lang.Exception

testBug78685

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

Tests fix for Bug#78685 - Wrong results when retrieving the value of a BIT column as an integer.

Throws:

java.lang.Exception

testBug78685CheckData

private void testBug78685CheckData(java.lang.String testCase)
                            throws java.lang.Exception

Throws:

java.lang.Exception

testBug80631

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

Tests fix for Bug#80631 - ResultSet.getString return garbled result with json type data.

Throws:

java.lang.Exception

testBug23197238

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

Tests fix for Bug#23197238 - EXECUTEQUERY() FAILS FOR JSON DATA WHEN RESULTSETCONCURRENCY=CONCUR_UPDATABLE.

Throws:

java.lang.Exception

testBug23197238AssertId

private void testBug23197238AssertId(int[] expectedId)
                              throws java.lang.Exception

Throws:

java.lang.Exception

testBug23197238AssertDoc

private void testBug23197238AssertDoc(java.lang.String[] expectedDoc)
                               throws java.lang.Exception

Throws:

java.lang.Exception

testBug81202

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

Tests fix for BUG#81202 - RESULTSETIMPL.GETOBJECT THROWS NULLPOINTEREXCEPTION WHEN FIELD IS NULL.

Throws:

java.lang.Exception

testBug82964

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

Tests fix for BUG#82964 - JSR-310 DATA TYPES CREATED THROUGH JAVA.SQL TYPES.

Throws:

java.lang.Exception

testBug24525461

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

Tests fix for Bug#24525461 - UPDATABLE RESULTSET FEATURE FAILS WHEN USESERVERPREPSTMTS=TRUE

Throws:

java.lang.Exception

tstBug24525461testBytes

private void tstBug24525461testBytes(java.util.Properties props,
                                     boolean testJSON,
                                     java.sql.Statement st)
                              throws java.lang.Exception

Throws:

java.lang.Exception

tstBug24525461assertResults1

private void tstBug24525461assertResults1(boolean testJSON,
                                          java.sql.Statement st)
                                   throws java.lang.Exception

Throws:

java.lang.Exception

tstBug24525461assertResults2

private void tstBug24525461assertResults2(boolean testJSON,
                                          java.sql.Statement st)
                                   throws java.lang.Exception

Throws:

java.lang.Exception

testBug24527173

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

Tests fix for Bug#24527173 - QUERY EXECUTION USING PREPARED STMT FAILS WHEN USECURSORFETCH=TRUE

Throws:

java.lang.Exception

testBug24527173Results

private void testBug24527173Results(java.sql.PreparedStatement ps,
                                    java.lang.Class<?> expectedResultClass)
                             throws java.lang.Exception

Throws:

java.lang.Exception

testBug23702040

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

Tests fix for BUG#23702040 - JDBCDATEVALUEFACTORY FAILS TO PARSE SOME DATES.

Throws:

java.lang.Exception

testBug82707

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

Tests fix for Bug#82707, WRONG MILLI SECOND VALUE RETURNED FROM TIMESTAMP COLUMN.

Throws:

java.lang.Exception

testBug25215008

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

Tests fix for Bug#84084 (25215008), JAVA.LANG.ARRAYINDEXOUTOFBOUNDSEXCEPTION ON ATTEMPT TO GET VALUE FROM RESULTSET.

Throws:

java.lang.Exception

testBug84189

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

Tests fix for Bug#84189 - Allow null when extracting java.time.* classes from ResultSet.

Throws:

java.lang.Exception

testBug83368

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

Tests fix for Bug#83368 - 5.1.40 regression: wasNull not updated when calling getInt for a bit column.

Throws:

java.lang.Exception

testBug83662

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

Tests fix for Bug#83662 - NullPointerException while reading NULL boolean value from DB. This fix was actually done in the patch for Bug#83368, as both are fixed in the same way.

Throws:

java.lang.Exception

testBug70704

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

Tests fix for Bug#70704 - Deadlock using UpdatableResultSet. Doesn't actually test the buggy behavior since it is not verifiable since the fix for Bug#59462 (revision 385a151). However, the patch for this fix is needed because the synchronization in UpdatableResultSet was dated. This test makes sure there is no regression. WARNING! If this test fails there is no guarantee that the JVM will remain stable and won't affect any other tests. It is imperative that this test passes to ensure other tests results.

Throws:

java.lang.Exception

testBug25650305

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

Tests for fix to BUG#25650305 - GETDATE(),GETTIME() AND GETTIMESTAMP() CALL WITH NULL CALENDAR RETURNS NPE

Throws:

java.lang.Exception

testBug26750705

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

Tests for fix to BUG#26750705, UNSUPPORTED CONVERSION FROM TIME TO JAVA.SQL.DATE

Throws:

java.lang.Exception

testBug26266731

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

Tests for fix to BUG#26266731 - CONCUR_UPDATABLE RESULTSET OPERATIONS FAIL AGAINST 8.0 FOR BOOLEAN COLUMN

Throws:

java.lang.Exception

testBug85941

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

Tests for fix to BUG#85941 (25924324), WASNULL NOT SET AFTER GETBYTES IS CALLED

Throws:

java.lang.Exception

testBug22305979

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

Tests fix for Bug#22305979, WRONG RECORD UPDATED IF SENDFRACTIONALSECONDS=FALSE AND SMT IS SCROLLABLE.

Throws:

java.lang.Exception

testBug80532

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

Tests fix for Bug#80532 (22847443), ENCODING OF RESULTSET.UPDATEROW IS BROKEN FOR NON ASCII CHARCTERS.

Throws:

java.lang.Exception

testBug72609

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

Tests fix for Bug#72609 (18749544), SETDATE() NOT USING A PROLEPTIC GREGORIAN CALENDAR.

Throws:

java.lang.Exception

testBug91065

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

Tests fix for Bug#91065 (28101003), ZERODATETIMEBEHAVIOR=CONVERT_TO_NULL SHOULD NOT APPLY TO 00:00:00 TIME COLUMNS.

Throws:

java.lang.Exception

testBug92536

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

Tests fix for Bug#92536 (28692243), UPDATEING SERVER SIDE PREPSTMTS RESULTSET FAIL.

Throws:

java.lang.Exception

testBug25650482

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

Tests fix for Bug#25650482, REFRESHROW() CALL AFTER UPDATEROW() API FAILS WHEN USESERVERPREPSTMTS=TRUE.

Throws:

java.lang.Exception

testBug25650514

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

Tests fix for Bug#25650514, UPDATEROW() CALL FAILS WITH NPE WHEN SSPS=TRUE AND TABLE HAS MULTI-FLD KEY.

Throws:

java.lang.Exception

testBug25650385

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

Tests fix for BUG#25650385, GETBYTE() RETURNS ERROR FOR BINARY() FLD.

Throws:

java.lang.Exception

testBug27784363

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

Tests fix for BUG#27784363, MYSQL 8.0 JDBC DRIVER THROWS NUMBERFORMATEXCEPTION FOR TEXT DATA

Throws:

java.lang.Exception

testBug94533

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

Tests fix for BUG#94533 (29446100), GETOBJECT FOR BOXED PRIMITIVE TYPES DOESN'T RETURN NULL FOR NULL COLUMNS.

Throws:

java.lang.Exception

testBug94585

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

Tests fix for BUG#94585 (29452669), GETTABLENAME() RETURNS NULL FOR A QUERY HAVING COUNT(*) WITH JDBC DRIVER V8.0.12

Throws:

java.lang.Exception

testBug80441

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

Tests fix for Bug#80441 (22850444), SYNTAX ERROR ON RESULTSET.UPDATEROW() WITH SQL_MODE NO_BACKSLASH_ESCAPES.

Throws:

java.lang.Exception

testBug20913289

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

Tests fix for Bug#20913289, PSTMT.EXECUTEUPDATE() FAILS WHEN SQL MODE IS NO_BACKSLASH_ESCAPES.

Throws:

java.lang.Exception

testBug96059

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

Tests fix for Bug#96059 (29999318), ERROR STREAMING MULTI RESULTSETS WITH MYSQL-CONNECTOR-JAVA 8.0.X.

Throws:

java.lang.Exception

testBug96383

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

Tests fix for Bug#96383 (30119545) RS.GETTIMESTAMP() HAS DIFFERENT RESULTS FOR TIME FIELDS WITH USECURSORFETCH=TRUE.

Throws:

java.lang.Exception

testBug97757

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

Tests fix for Bug#97757 (30584907), NULLPOINTEREXCEPTION WITH CACHERESULTSETMETADATA=TRUE AND EXECUTEQUERY OF "SET".

Throws:

java.lang.Exception

testBug30474158

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

Tests fix for Bug#30474158, CONNECTOR/J 8 DOES NOT HONOR THE REQUESTED RESULTSETTYPE SCROLL_INSENSITIVE ETC.

Throws:

java.lang.Exception

testBug97724

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

Tests fix for Bug#97724 (30570721), Contribution: Allow \'3.\' formatted numbers.

Throws:

java.lang.Exception

testBug94457

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

Tests fix for BUG#94457 (29402209), CONNECTOR/J RESULTSET.GETOBJECT( ..., OFFSETDATETIME.CLASS ) THROWS.

Throws:

java.lang.Exception

testBug99013

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

Tests fix for Bug#99013 (31074051), AN EXTRA HOUR GETS ADDED TO THE TIMESTAMP WHEN SUBTRACTING INTERVAL 'N' DAYS.

Throws:

java.lang.Exception

testBug31747910

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

Tests fix for Bug#31747910, BUG 30474158 FIX IMPROVES JDBC COMPLIANCE BUT CHANGES DEFAULT RESULTSETTYPE HANDLING.

Throws:

java.lang.Exception

testBug102321

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

Tests fix for Bug#102321 (32405590), CALLING RESULTSETMETADATA.GETCOLUMNCLASSNAME RETURNS WRONG VALUE FOR DATETIME.

Throws:

java.lang.Exception

testBug102131

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

Tests fix for Bug#102131 (32338451), UPDATABLERESULTSET NPE WHEN USING DERIVED QUERIES OR VIEWS.

Throws:

java.lang.Exception

testBug20391659

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

Tests fix for Bug#20391659, GETBYTE() CALL RESULTS IN EXCEPTION WHEN USEUSAGEADVISOR = TRUE.

Throws:

java.lang.Exception

testBug20391631

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

Tests fix for Bug#20391631, GETBOOLEAN() CALL RESULTS IN EXCEPTION WHEN USEUSAGEADVISOR = TRUE.

Throws:

java.lang.Exception

testBug19805370

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

Tests fix for Bug#19805370, GETBINARYSTREAM() WITH INVALID COLUMN INDEX RETURNS EXCEPTION.

Throws:

java.lang.Exception

testBug20802947

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

Tests fix for Bug#20802947, RESULTSET UPDATE METHODS FAILS WHEN TABLENAME CONTAINS SPECIAL CHARACTERS.

Throws:

java.lang.Exception

testBug32954396

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

Tests fix for Bug#32954396, EXECUTEQUERY HANGS WITH USECURSORFETCH=TRUE & SETFETCHSIZE.

Throws:

java.lang.Exception

testBug33185116

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

Tests fix for Bug#33185116, Have method ResultSet.getBoolean() supporting conversion of 'T' and 'F' in a VARCHAR to True/False (boolean). Extended the test for BUG#92574 (28706219), WHEN CONVERTING FROM VARCHAR TO JAVA BOOLEAN, 'N' IS NOT SUPPORTED.

Throws:

java.lang.Exception

testBug105197

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

Tests fix for Bug#105197 (33461744), Statement.executeQuery() may return non-navigable ResultSet.

Throws:

java.lang.Exception

testBug102678

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

Tests fix for Bug#102678 (Bug#32536384), Connector/J 8 query with explain can not return ResultRow. Resolved by fix for Bug#103878 (32954449), CONNECTOR/J 8 : QUERY WITH 'SHOW XXX' WILL GET EXCEPTION WHEN USE CURSOR.

Throws:

java.lang.Exception

testBug68608

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

Tests for Bug#68608 (Bug#16690898), UpdatableResultSet does not properly handle unsigned primary key.

Throws:

java.lang.Exception