Incorrectly finding "where" in query string

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

Hide

Permalink

Paul King added a comment - 19/Aug/12 1:30 AM

thanks for spotting that, fix added

Show

Paul King added a comment - 19/Aug/12 1:30 AM thanks for spotting that, fix added

Vote (0)

Watch (2)