[GROOVY-1482] Sql#firstRow throws IndexOutOfBoundsException if no rows are found (Patch included)

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.0-JSR-6
• Fix Version/s: 1.0-RC-1
• Component/s: groovy-jdk
• Environment: All Operating Systems and databases. JSR-06
• Flags: Patch
• Assignee: Guillaume Sauthier
• Reporter: joncrlsn
• Created: 25/Aug/06 10:19
• Updated: 05/Apr/15 14:25
• Resolved: 20/Sep/06 12:27

Description

Sql#firstRow throws IndexOutOfBoundsException if no rows are found (Patch included)

One of the big reasons I use Groovy is to avoid having to mess with catching exceptions. And I think it is counterproductive to have to make sure a row exists before selecting it. A simple return value of null would be better and that is what this patch provides.