[gdal-dev] Call for discusson on RFC 52 Strict OGR SQL quoting

[Jukka Rahkonen]

Even Rouault <even.rouault <at> spatialys.com> writes:

> 
> Hi,
> 
> This is a call for discussion on the new "RFC 52 - Strict OGR SQL quoting", 
> based on an older ticket.
> 
> http://trac.osgeo.org/gdal/wiki/rfc52_strict_sql_quoting
> 
> Summary :
> 
> This RFC proposes that OGR SQL enforces strict quoting rules for SQL literals 
> and identifiers.

Hi,

Could there be a need to think about the "schema"."table" structure? I have
some memories about (silly) users having table names with dots like
"MY.TABLE". If I remember right, with some database the SQL query 

SELECT "field" FROM "MY.TABLE"

was being interpreted wrongly as "select field named 'field' from table
named 'table' from schema named 'my'".

I do not really know if this trouble belongs to GDAL at all but I share my
weigh memories anyhow.

-Jukka Rahkonen-