[New-bugs-announce] [issue14412] Sqlite Integer Fields

Mendez report at bugs.python.org
Mon Mar 26 13:00:01 CEST 2012

New submission from Mendez <goatsofmendez at users.sourceforge.net>:

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.

files: sqltest.py
messages: 156809
nosy: goatsofmendez
priority: normal
severity: normal
status: open
title: Sqlite Integer Fields
type: behavior
versions: Python 2.7
Added file: http://bugs.python.org/file25027/sqltest.py

Python tracker <report at bugs.python.org>

More information about the New-bugs-announce mailing list