[gdal-dev] ogr2ogr: strange results joininig non-spatial CSV to spatial data using SQLite dialect

[Even Rouault]

> Why do I not have three rows of result using simply join?

You just hit a long-standing bug. Restricted when the joint layer is in a 
format like CSV that has no fast feature count capability.
Just fixed in master and backported to 3.0 and 2.4 branches

Even

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com