homepage

There appears to be a problem with the handling of integer fields in SQLite in the 32-bit release candidate for 2.7.3.
I'm running the 64-bit version of Windows 7.
I've attached a script which reproduces the issue. The following are the results I get with different versions of Python, with the later two being as expected.
Python - 2.7.3 rc2 - 32-bit:
R:\>c:\python27\python "C:\Temp\sqltest.py"
530428456761032704 <type 'long'>
Python - 2.7.2 - 32-bit:
R:\>c:\python27\python "C:\Temp\sqltest.py"
123499999 <type 'int'>
Python - 2.7.2 rc2 - 64-bit:
R:\>c:\python27_64\python c:\temp\sqltest.py
123499999 <type 'int'>
I wonder if this might be related to the changes in #8033.

Can't reproduce under Linux. Can someone test under Windows?

Can't reproduce on a 2.7 debug build under Windows either.
Some data points:
>>> hex(530428456761032704)
'0x75c75df00000000'
>>> hex(123499999)
'0x75c75df'
Looking at #8033, it seems unlikely to have caused this problem.
Perhaps we shipped the 2.7.3 rc with a buggy SQLite build?
Can you (or someone else) check the 2.6, 3.1 and 3.2 release candidates as well?

I've tried the 32-bit version of 3.2.3rc2 and that works as expected.
There don't seem to be Windows builds of 2.6 and 3.1 available so I haven't been able to try those.

I've done some more checking
2.7.3rc1 32-bit works as expected.
If I replace
sqlite3.dll
_sqlite3.lib
in rc2 32-bit with those from rc1 then that fixes the problem.

I can't reproduce that. Your test script, with the released 2.7.3rc2, on Windows 7, gives 
123499999 <type 'int'>
for me, as it should.

Is that with the 32-bit Python on a 64-bit copy of Windows?
I've tried it on a different machine, again running Windows 7 64-bit and I'm getting the same incorrect results.

> Is that with the 32-bit Python on a 64-bit copy of Windows?
No, it was the 64-bit version.

What steps can we take to further debug/address this?

Given the lack of progress here, I will be releasing 2.7.3.

I've tested the released 2.7.3 and this works fine so there must just have been some oddity with the packaging of sqlite in rc2.

Great!