[fdo-internals] MySQL Defect with Count(1)
bscott at geomapgis.com
Tue Apr 29 02:36:54 EDT 2008
By the way i have found the same piece of code in the sqlserver provider
Bruno Scott wrote:
> I just found and enter a ticket about this one.
> I've been a little further.
> Select Count(1) failes with "Unsupported FDO type in expression"
> It was working ok in release 3.2
> I think i have found were the problem is.
> ProcessAggregateFunction has been overridden in release 3.3 ( to handle
> ALL and distinct i guess)
> extract of ProcessAggregateFunction function
> if (dataValue->GetDataType() == FdoDataType_String)
> // Omit ALL if specified as this keyword is not supported
> // MySQL.
> throw FdoFilterException::Create(NlsMsgGet(FDORDBMS_29,
> "Unsupported FDO type in expression"));
> As 1 is not a string -> boom
> I have tried with
> Select Count('1') and it works fine
View this message in context: http://www.nabble.com/MySQL-Defect-with-Count%281%29-tp16939555p16953704.html
Sent from the FDO Internals mailing list archive at Nabble.com.
More information about the fdo-internals