[GROOVY-5666] Incorrectly finding "where" in query string

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.1
• Fix Version/s: 1.8.8, 2.0.2, 2.1.0-beta-1
• Component/s: SQL processing
• Assignee: Paul King
• Reporter: Josh Schwartzbeck
• Created: 16/Aug/12 19:25
• Updated: 11/Sep/12 01:15
• Resolved: 19/Aug/12 01:30

Description

groovy.sql.Sql.findWhereKeyword returns the index once all the characters in [w,h,e,r,e] are found but not necessarily adjacently.

This causes invalid sql to be generated - null values become conditions.

example of invalid generated sql:
update tbl set wh=null, ere=null, anotherfield is null where id=1