search

duckdb / duckdb_spatial

MIT License
492 stars 41 forks source link

filter error with GTFS #343

Closed ericemc3 closed 4 months ago

ericemc3 commented 5 months ago

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 commented 4 months ago

GDAL upstream bug that will be fixed per https://github.com/OSGeo/gdal/pull/10454

ericemc3 commented 4 months ago

Thanks !