SQLite Step (I) in implementation of Standard functions

[romicadascalescu]

Step (I) in implementation of Standard functions

• Exposed supported functions. The exposed functions still need to be changed

and add processing for any extra parameters

• Added remainder function
• Fixed an internal issue which did not allowed functions to be used in

calculations

• build with Soundex function enable at SQLite level

[romicadascalescu]

Changed Files \Providers\SQLite\Src\sqlite-3.6.2\sqlite.vcproj \Providers\SQLite\Src\Provider\SltExprExtensions.cpp \Providers\SQLite\Src\Provider\SltCapabilities.h \Providers\SQLite\Src\Provider\SQLiteProvider.vcproj \Providers\SQLite\Src\Provider\SltReader.cpp

[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