[gdal-dev] OGR SQL CAST and field name alias selects incorrect fields in some cases

[Even Rouault]

Le mercredi 15 février 2012 16:51:28, Eli Adam a écrit :
> Hi all,
> 
> I'm trying to use OGR SQL to CAST and field name aliasing together and
> getting incorrect results (or issuing incorrect commands) when
> combined with two LEFT JOINs on MDB (both ODBC and MDB drivers).  The
> results are incorrect in that the fields are populated with incorrect
> information, specially, filling it with other fields that are not
> selected at all.

The issue was not specific to those drivers, but indeed when multiple JOINs and 
expression based on field names were involved. It should now be fixed by the 
commits referenced in http://trac.osgeo.org/gdal/ticket/4521 .