Re: MySQL 4.1.7: cast(1-2, unsigned) != cast('18446744073709551615' as unsigned)

2004-12-06 Thread Robin Bryce
Ah, Excelent. Thanks for looking at this. The use context that exposed this was using uuids as primary keys. I was breaking the result of uuid() into two parts, and then storing into a pair of bigint unsigned fields that formed a composite primary key: CREATE TABLE `test`.`uuidkeys` ( `uuidlo`

Re: MySQL 4.1.7: cast(1-2, unsigned) != cast('18446744073709551615' as unsigned)

2004-12-06 Thread Gleb Paharenko
Hello. I've submitted a bug http://bugs.mysql.com/7036. Robin Bryce <[EMAIL PROTECTED]> wrote: > Hi, > > I'm having trouble converting to and from strings that represent > unsigned BIGINT's. > > My server is MySQL 4.1.7-standard and > > the following selects were entered at the