#!/usr/bin/python

import os
import sqlite3
import sys

DBFILE = '/tmp/bug.sqlite3'

if __name__ == "__main__":
    if os.path.exists(DBFILE):
        os.unlink(DBFILE)
        pass
    conn = sqlite3.connect(DBFILE)
    cursor = conn.cursor()
    cursor.execute('create table t(k primary key);')
    for i in range(3):
        cursor.execute('insert or replace into t(k) values(?);', (i,))
        pass
    c =  cursor.execute(' select k from t where k == ?;', (1,))
    conn.commit()
    r = c.fetchone()
    c =  cursor.execute(' select k from t where k == ?;', (2,))