[GROOVY-5111] Named parameter support breaks with postgres casting syntax

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.8.2, 1.8.6, 2.0-beta-3
• Fix Version/s: 2.0-rc-1, 1.8.7
• Component/s: SQL processing
• Assignee: Paul King
• Reporter: Lucian Holland
• Created: 01/Nov/11 11:58
• Updated: 15/Jun/12 22:56
• Resolved: 12/May/12 06:10

Description

Postgres supports a casting syntax like "SELECT '2011-01-01'::date". I recently wrote a query like: "SELECT * FROM table WHERE my_date BETWEEN ?-'1 week'::interval AND ?" and was surprised to receive strange errors about java.sql.Date not supporting the "interval" property. It would appear that the regex parsing that identifies named parameters is a bit broken in this instance.