Zeoslib Portal

EgonHugeist,

I think you are right this is a MySQL bug ...

So in this case is better to close the ticket and hope that other user don't have this problem


Pedro Miguel Martins

EgonHugeist,

I will try this weekend with mysql version 5.5.3 and give the results

Thanks again


Pedro Miguel Martins

EgonHugeist, I can assure that are everything equal except the zeos version I rename the folder that I have with alpha and beta and with alpha folder works and with beta doesn't (I inclusive delete all dcu's and bpl's to assure) I know that this isn't the solution but I change this code and works f...

EgonHugeist,

I think the problem is caused because a field in the concat is of type integer

If my create a concat with all fields of type char works just fine


Pedro Miguel Martins

I deleted all zeos and reinstall from the beginning
create again my table

and the problem persist

If I change the sql code to

cast ( ..... as char ) ......


works well

Pedro Martins

Just sent the ticket

Thanks

Pedro Martins

I have this sql : select concat(e.cpost_codigo, if(e.cpost_rua=0,"", concat('-',e.cpost_rua)), " ", e.cpost_nome) as cp from entidades e where e.firmsid = 2 in version 7.0 alpha the field cp was a string in version 7.0.1 beta the field cp is byte Is this a permanent change ou a b...