Ticket #4259 (closed defect: fixed)
OGR SQL implicit conversion from string to numeric
|Reported by:||tamas||Owned by:||tamas|
Most SQL query implementations support implicit conversions between various types in the SQL expressions. For example we can safely use the following syntax:
select * from rivers where ogr_fid in ('1100','1101','1102')
If the data type of ogr_fid is an integer or float then the expression evaluator would convert the string constants to numeric values implicitly.
This conversion has been working until the new expression parser have was introduced in gdal 1.8. As of 1.8 the parser reports an error due to the incompatible types in the expression.