TIMESTAMPDIFF MySQL causes TLargeintField

[alamonaca]

Hellow, i'm using UniDAC V 2.70.0.8.

Have a TUniQuery with the following text:

SELECT TIMESTAMPDIFF(DAY, DATE_MEET,NOW()) DELAY
FROM TABLE_1;

When I retrieve the fields, DELAY is a TLargeintField. The MySQL reference manual says than de return value of TIMESTAMPDIFF is an Integer type, so DELAY would be an TIntegerField.

I've set the OptimizedBigInt property to True, but still getting TLargeintField.

here the script to generate the test table:

CREATE TABLE TABLE_1 (DATE_MEET DATETIME);

INSERT TABLE_1 VALUES ('2009-06-01');

INSERT TABLE_1 VALUES ('2009-05-01');

INSERT TABLE_1 VALUES ('2009-04-11');


Thanks!

Alex

[Dimon]

Please do not duplicate topics. We have answered you in other thread.