docstr: pysqlite until 2.4.1 did not rebuild the row_cast_map when recompiling
  a statement. This test exhibits the problem.
code: def test_type_map_usage(self):
      """
      pysqlite until 2.4.1 did not rebuild the row_cast_map when recompiling
      a statement. This test exhibits the problem.
      """
      SELECT = "select * from foo"
      with memory_database(detect_types=sqlite.PARSE_DECLTYPES) as con:
          cur = con.cursor()
          cur.execute("create table foo(bar timestamp)")
          with self.assertWarnsRegex(DeprecationWarning, "adapter"):
              cur.execute(
                  "insert into foo(bar) values (?)",
                  (datetime.datetime.now(),),
              )
          cur.execute(SELECT)
          cur.execute("drop table foo")
          cur.execute("create table foo(bar integer)")
          cur.execute("insert into foo(bar) values (5)")
          cur.execute(SELECT)
  
imports: import datetime
  import unittest
  import sqlite3
  import weakref
  import functools
  from test import support
  from unittest.mock import patch
  from .util import memory_database, cx_limit
  from .util import MemoryDatabaseMixin
label_desc: Use image node_id 9 for calling the RegressionTests obj's underlying member method code with example usage: obj.test_type_map_usage() without return types