[fdo-internals] Ticket #20 Generic RDBMS: fix various SelectAggregates defects

[Romica Dascalescu]

Ticket #20 Generic RDBMS: fix various SelectAggregates defects merged
form branch:

 

In select aggregates execute is check if functions are supported with
provided parameters (by looking in the extended capabilities). If the
function is not supported an exception is thrown.

 

Fixed Concat issue on ODBC SQL Server.

 

Fixed:

796236

MySQL: Select Aggregate function on a DateTime does not return a valid
value.

800672

MySQL: Datatype returned by MySQL Ceil function (Int64) doesn't match
Double returned by SQLServer or Oracle

812702

SqlServer: Select aggregate functions not returning proper return types

796226

MySQL: Select Aggregate Functions on boolean returns 1 or 0

673851.01

ODBC Provider: If one of functions, Lower, Upper and Concat is used in
computed properties of FdoISelectAggragates command for SQL Server, an
exception is thrown. linked 

 

------------------------------------------------------------------------

r2610 | romicadascalescu | 2007-02-23 12:39:54 -0500 (Fri, 23 Feb 2007)
| 1 line

Changed paths:

   M
/trunk/Providers/GenericRdbms/Src/Fdo/FeatureCommands/FdoRdbmsSelectComm
and.cpp

   M /trunk/Providers/GenericRdbms/Src/Gdbi/GdbiQueryResult.cpp

   M
/trunk/Providers/GenericRdbms/Src/ODBC/Fdo/FdoRdbmsOdbcFilterProcessor.c
pp

   M
/trunk/Providers/GenericRdbms/Src/ODBC/Fdo/FdoRdbmsOdbcFilterProcessor.h

   M
/trunk/Providers/GenericRdbms/Src/UnitTest/Common/FdoAdvancedSelectTest.
cpp

   M
/trunk/Providers/GenericRdbms/Src/UnitTest/Common/FdoAdvancedSelectTest.
h

   M /trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcBaseSetup.cpp

   M
/trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcFdoAdvancedSelectTes
t.cpp

   M
/trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcFdoAdvancedSelectTes
t.h

   M /trunk/Providers/GenericRdbms/Src/UnitTest/Odbc/OdbcFdoSelectTest.h

   M /trunk/Utilities/Common/FdoCommon.vcproj

   A /trunk/Utilities/Common/Inc/FdoCommonExpressionExecutor.h

 

Ticket #20 Generic RDBMS: fix various SelectAggregates defects

------------------------------------------------------------------------

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-internals/attachments/20070223/52426ccc/attachment.html