filter error with GTFS

[ericemc3]

This yields an error:

FROM st_read('https://static.data.gouv.fr/resources/gtfs-tisseo-toulouse/20240614-125818/tisseo-gtfs-v2.zip', layer='routes') 
WHERE route_type = 1 ;

SQL Error: IO Error: GDAL Error (1): Type mismatch or improper type of arguments to = operator.
Although route_type is INTEGER.

This (ugly) workaround works:

FROM st_read('https://static.data.gouv.fr/resources/gtfs-tisseo-toulouse/20240614-125818/tisseo-gtfs-v2.zip', layer='routes') 
WHERE route_type::varchar = '1' ;

[rouault]

GDAL upstream bug that will be fixed per OSGeo/gdal#10454

[ericemc3]

Thanks !