OGR SQL limits table name character set

[theroggy]

When executing an sql statement on a shapefile that has '-' in the filename you get an error. It seems the sql parser doesn't support this.

Can be reproduced like this:

ogrinfo Perc_2017-06-11_ANTW.shp -sql "select * from Perc_2017-06-11_ANTW"
INFO: Open of `Perc_2017-06-11_ANTW.shp' using driver `ESRI Shapefile' successful.
ERROR 1: SQL Expression Parsing Error: syntax error, unexpected '-', expecting end of string. 
Occurred around : select * from Perc_2017-06-11_ANTW
                                         ^

[Even Rouault]

You need to double quote columns or tables identifiers that have special characters like '-' (and as you use shell commands escape them with \

ogrinfo Perc_2017-06-11_ANTW.shp -sql "select * from \"Perc_2017-06-11_ANTW\""

This is conformant with the SQL92 standard

[theroggy]

Ok, thanks!