[gdal-dev] sqlite dialect and MySQL spatial input

[Jukka Rahkonen]

Even Rouault <even.rouault <at> mines-paris.org> writes:

> 
> Le mardi 01 octobre 2013 08:58:22, Jukka Rahkonen a écrit :

> > 
> > - The default SQL dialect is "OGR SQL", except for databases when the
> > default is to use the native SQL dialect of the RDBMS
> > - The default dialect can be overridden by the -dialect parameter, which
> > can take values "OGR SQL" or "SQLITE" and after your change this works for
> > all drivers in a similar way.
> 
> Yes. Just to crrect : the string is OGRSQL (no space)

...Snip...


> > It would be good to give the alternatives and a hint about how to give OGR
> > SQL so that the space character will not cause trouble as
> > 
> > -dialect dialect:
> >     SQL dialect. Can take values "OGR SQL" or "SQLITE".
> 
> Adding quote would be indeed good to avoid the confusion with space/nospace. 
> Want to give a crack at it ?

Not really if the string to use is "OGRSQL" and not "OGR SQL" as I thought.
I noticed that ogr2ogr accepts "OGR SQL" but also -dialect "FOO" with
pleasure. Want to give a crack ? 

Alternatively I can try to improve documentation a bit?

-Jukka-