Bug #4797 32 bit and 64 bit overflow difference
Submitted: 28 Jul 2004 21:32 Modified: 11 Aug 2004 23:08
Reporter: Matthew Lord Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.20 sparc-64bit OS:
Assigned to: Sergei Golubchik CPU Architecture:Any

[28 Jul 2004 21:32] Matthew Lord 
Description:
We should make it clear the overrun difference between our 32 and 64 bit versions.

How to repeat:
with 32 bit mysql:

create table tst ( id int unsigned );

insert into tst values ( '5000000000');

select * from tst;

try the same with 64 bit mysql

Suggested fix:
I think we should just document the difference.
[28 Jul 2004 21:36] Matthew Lord 
This behavior does not exhibit itself on 4.1 but it does on 4.0.20.
[4 Aug 2004 9:19] Brian Aker 
Paul, once you document this, can you update it to mention that the docs have been updated but 
leave it as a bug? Longterm I would like to see this fixed.
[11 Aug 2004 23:08] Sergei Golubchik 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

fixed in 4.0.21