Opened 15 years ago

Closed 14 years ago

#504 closed enhancement (fixed)

SQLite Step (I) in implementation of Standard functions

Reported by: romicadascalescu Owned by: romicadascalescu
Priority: major Milestone: 3.5.0
Component: SQLite Provider Version: 3.4.0
Severity: 3 Keywords:
Cc: External ID:

Description

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

Change History (4)

comment:1 by romicadascalescu, 15 years ago

Resolution: fixed
Status: newclosed

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

comment:2 by romicadascalescu, 15 years ago

Resolution: fixed
Status: closedreopened

comment:3 by romicadascalescu, 15 years ago

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

comment:4 by gregboone, 14 years ago

Resolution: fixed
Status: reopenedclosed
Note: See TracTickets for help on using tickets.