Subject | Re: [firebird-php] PHP 5.3 compilation VC6 |
---|---|

Author | Umberto Masotti |

Post date | 2009-06-02T19:06:14Z |

Pierre Joye ha scritto:

Two test fails: 003.phpt and 006.phpt.

003 is a false negative, because Fb2.1 has changed default field naming

in a more consistent way. They are no more called "FIELD_nn" but

"CONSTANT", "COSTANT_01", ... "COSTANT_nn" or "SUM", "SUM_01" ecc. ecc.

In 006 last query return one more row in last "select... from.. between

? and ?" where table data are integers between 0 and 9.

Parameters tested are "5.0" and 7.5. The resulting query then is similar to

select id from table1 where id between "5.0" and 7.5

Result expected is three ids: 5, 6 and 7. Result obtained is four: 5,

6, 7 and 8.

Suspecting that 7.5 is converted as integer when assigned to parameter

(or something equivalent) so 7.5 becomes 8. I remember something has

changed in recent past about float to integer conversion but not for sure.

I feel this is another false negative.

Can anybody confirm?

Ciao.

Mimmo.

> did you load the extension?Ooops! :)

Two test fails: 003.phpt and 006.phpt.

003 is a false negative, because Fb2.1 has changed default field naming

in a more consistent way. They are no more called "FIELD_nn" but

"CONSTANT", "COSTANT_01", ... "COSTANT_nn" or "SUM", "SUM_01" ecc. ecc.

In 006 last query return one more row in last "select... from.. between

? and ?" where table data are integers between 0 and 9.

Parameters tested are "5.0" and 7.5. The resulting query then is similar to

select id from table1 where id between "5.0" and 7.5

Result expected is three ids: 5, 6 and 7. Result obtained is four: 5,

6, 7 and 8.

Suspecting that 7.5 is converted as integer when assigned to parameter

(or something equivalent) so 7.5 becomes 8. I remember something has

changed in recent past about float to integer conversion but not for sure.

I feel this is another false negative.

Can anybody confirm?

Ciao.

Mimmo.