Re: [gdal-dev] OGR SQL Parser/Evaluator Overhaul

2010-08-03 Thread Tamas Szekeres
Frank, I've compiled and tested the code and it works reasonably well. The only issue is the missing strcasecmp with the MSVC builds. I would support this addition as it's pretty much extensible comparing to the previous code. Best regards, Tamas 2010/8/2 Frank Warmerdam > Tamas Szekeres

Re: [gdal-dev] OGR SQL Parser/Evaluator Overhaul

2010-08-02 Thread Frank Warmerdam
Tamas Szekeres wrote: > Frank, Where can I find the current implementation? Is that publicly available? Tamas, I have created a branch at: http://svn.osgeo.org/gdal/sandbox/warmerdam/gdal-rfc28 The swq.c file has been split into several swq files, and the code is now C++ instead of flat C

Re: [gdal-dev] OGR SQL Parser/Evaluator Overhaul

2010-08-02 Thread Frank Warmerdam
Tamas Szekeres wrote: Frank, Where can I find the current implementation? Is that publicly available? Tamas, It is unpublished currently, in my local dev tree. I was thinking I might make a branch in the sandbox if that would be helpful to you. I'll try and do that today. Best regards, --

Re: [gdal-dev] OGR SQL Parser/Evaluator Overhaul

2010-08-02 Thread Daniel Morissette
Frank Warmerdam wrote: > > I have written up a preliminary RFC for review at: > > http://trac.osgeo.org/gdal/wiki/rfc28_sqlfunc > > I am seeking feedback before I polish it off and call for a vote this > week. > All sounds good to me (with the little knowledge I have of the SQL engine implem

Re: [gdal-dev] OGR SQL Parser/Evaluator Overhaul

2010-08-02 Thread Tamas Szekeres
2010/8/2 Frank Warmerdam > Folks, > > With the support of Camp To Camp I have been working on an overhaul for the > OGR SQL parsing engine. The minimum goal was to support functions in the > column definitions for the output record set of a SELECT, but in order to > achieve this in a reasonable

Re: [gdal-dev] OGR SQL Parser/Evaluator Overhaul

2010-08-02 Thread Frank Warmerdam
Chaitanya kumar CH wrote: Frank, Can you list the statements supported by the WHERE clauses, like LIKE, IN and BETWEEN? Chaitanya, The comparison operators supported in WHERE clauses are =, <, >, <=, >=, LIKE, IN. BETWEEN is not supported. This is unchanged from the existing implementatio

Re: [gdal-dev] OGR SQL Parser/Evaluator Overhaul

2010-08-01 Thread Chaitanya kumar CH
Frank, Can you list the statements supported by the WHERE clauses, like LIKE, IN and BETWEEN? Is there a way to force through the SQL statement to the underlying database driver if required? On Mon, Aug 2, 2010 at 5:33 AM, Frank Warmerdam wrote: > Folks, > > With the support of Camp To Camp I

[gdal-dev] OGR SQL Parser/Evaluator Overhaul

2010-08-01 Thread Frank Warmerdam
Folks, With the support of Camp To Camp I have been working on an overhaul for the OGR SQL parsing engine. The minimum goal was to support functions in the column definitions for the output record set of a SELECT, but in order to achieve this in a reasonable way I have worked towards a substanti