[gdal-dev] OGR SQL problems

[Gauthier,Jean-Philippe [CMC]]

Hi all,

I think there might be a bug with the OGR_DS_ExecuteSQL call in gdal 1.8, this worked fine with 1.7 and I see you`ve rebuilt the SQL part.

I've tried a select on a CANVEC layer which looks something like this:

	ogrinfo CanVec/031/h/031h05/031h05_6_0_BS_2010009_2.shp -sql  "SELECT * FROM 031h05_6_0_BS_2010009_2"

And I get

	ERROR 1: SQL Expression Parsing Error: syntax error

I've tried many other layers and it woks fine for all of them but not for any CANVEC layer.

I'm beginning to think the underscores in the layer name might cause a problem cause it`s the only differrence I can see

Has anybody seen this behavior has well ?

Note the it does the same thing with the C API where I first stumbled on the problem

 Thanks.

================================================================
Jean-Philippe Gauthier Bilodeau		Direction des opérations
Spécialiste principal,				Centre Météorologique Canadien
programmation scientifique et infographie	2121 Route Transcanadienne
Tel : (514) 421-4642				Dorval,Québec
Fax: (514) 421-4679				H9P 1J3
Email: Jean-Philippe.Gauthier at ec.gc.ca	



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20110225/0b61bd0f/attachment.html