Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 1.8.2, 1.8.6, 2.0-beta-3
-
Component/s: SQL processing
-
Labels:None
-
Number of attachments :
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.