Something strange is going on.

I just built pysql 2.6.3 from source, and now my unit test gives the expected "IntegrityError: foreign key constraint failed" message.

poq, what do you get when you run this script:

import sqlite3
print "sqlite3.version_info =", sqlite3.version_info
print "sqlite3.sqlite_version_info =", sqlite3.sqlite_version_info
from pysqlite2 import dbapi2 as sqlite3
print "pysqlite2.version_info =", sqlite3.version_info
print "pysqlite2.sqlite_version_info =", sqlite3.sqlite_version_info

I get the following:

sqlite3.version_info = (2, 6, 0)
sqlite3.sqlite_version_info = (3, 6, 12)
pysqlite2.version_info = (2, 6, 3)
pysqlite2.sqlite_version_info = (3, 7, 8)