Bug #78321 ResultSet.getRow() returns 1 before first, instead of 0, if useCursorFetch=true

• Submitted: 4 Sep 2015 5:53
• Modified: 1 Oct 2015 15:08
• Reporter: Atsushi Nakagawa
• Status: Verified
• Category: Connector / J
• Severity: S3 (Non-critical)
• Version: 5.1.36
• OS: Any
• Assigned to: Filipe Silva
• CPU Architecture: Any

[4 Sep 2015 5:53] Atsushi Nakagawa

Description:
When ResultSet.isBeforeFirst() = true:

- ResultSet.getRow() returns 0 if useCursorFetch=false
- but 1 if useCursorFetch=true

How to repeat:
This is possibly caused by:

When ResultSet.isBeforeFirst() = true:

- com.mysql.jdbc.RowDataStatic.getCurrentRowNumber() returns -1
- com.mysql.jdbc.RowDataCursor.getCurrentRowNumber() returns 0

[1 Oct 2015 15:08] Filipe Silva

Hi Atsushi,

Thank you for this bug report. Verified as described.