'pysqlite until 2.4.1 did not rebuild the row_cast_map when recompiling
a statement. This test exhibits the problem.'

def CheckTypeMapUsage(self):

    SELECT = 'select    *    from    foo'
    con = sqlite.connect(':memory:', detect_types=sqlite.PARSE_DECLTYPES)
    con.execute('create    table    foo(bar    timestamp)')
    con.execute('insert    into    foo(bar)    values    (?)', (datetime.datetime.now(),))
    con.execute(SELECT)
    con.execute('drop    table    foo')
    con.execute('create    table    foo(bar    integer)')
    con.execute('insert    into    foo(bar)    values    (5)')
    con.execute(SELECT)
