[fdo-trac] #504: SQLite Step (I) in implementation of Standard functions

[FDO]

#504: SQLite Step (I) in implementation of Standard functions
------------------------------+---------------------------------------------
 Reporter:  romicadascalescu  |         Owner:  romicadascalescu
     Type:  enhancement       |        Status:  reopened        
 Priority:  major             |     Milestone:  3.5.0           
Component:  SQLite Provider   |       Version:  3.4.0           
 Severity:  3                 |    Resolution:                  
 Keywords:                    |   External_id:                  
------------------------------+---------------------------------------------
Comment (by romicadascalescu):

 Step (II) in implementation of Standard functions

  - Exposed all math, numeric, string functions and date time functions.
 Implemented for those functions the extra parameters where was the case.
  Notes:
                 - Trim had to be reimplemented since it had different
 parameters,               - Implemented truncate for dates
                 - Implemented pad, translate

  - Fixed the cache query mechanism allowing to have more cached parsed
 statement
 at one moment in case is needed.

  - Fixed date function conversion, the function when was used it corrupted
 the
 stack.

  - Fixed an describe schema when FDO meta data was not enabled since
 returned
 for string properties length = 0.

  - Fixed the the reader when calculation are used since SQLite returns for
 calculations SQLITE_NULL and we need to parse the expression and try to
 detect
 on the fly the type of the calculation field.

 Changed Files:
  - extended trim function to support LEADING, TRAILING, BOTH as parameter
 \\FDO\Providers\SQLite\Src\sqlite-3.6.2\func.c

  - exposed the new implemented functions
 \\FDO\Providers\SQLite\Src\Provider\SltCapabilities.h

  - fixed date to string and string to date functions
 \\FDO\Providers\SQLite\Src\Provider\SltConversionUtils.cpp
 \\FDO\Providers\SQLite\Src\Provider\SltConversionUtils.h

  - implement all math, numeric, string and date-time functions
 \\FDO\Providers\SQLite\Src\Provider\SltExprExtensions.cpp

  - fixed the length at describe schema when FDO meta data = false
 \\FDO\Providers\SQLite\Src\Provider\SltMetadata.cpp

  - fixed cache parsed statements to allow multiple identical statements be
 executed in the same time
 \\FDO\Providers\SQLite\Src\Provider\SltProvider.cpp
 \\FDO\Providers\SQLite\Src\Provider\SltProvider.h

  - fixed create feature class when calculations are used.
 \\FDO\Providers\SQLite\Src\Provider\SltReader.cpp
 \\FDO\Providers\SQLite\Src\Provider\SltReader.h

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/504#comment:3>
FDO <http://fdo.osgeo.org/>
Feature Data Objects