René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Test suite fails against libSQL server","articleBody":"I am running latest `sqld` locally and when I run `poetry run pytest`, I get the following set of test failures:\r\n\r\n```console\r\n========================================================================================= sqlalchemy installation ==========================================================================================\r\nSQLAlchemy 2.0.20 (user site loaded)\r\nPath: /Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/sqlalchemy/__init__.py\r\ncompiled extension enabled, e.g. /Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/sqlalchemy/cyextension/util.cpython-311-darwin.so\r\n/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/sqlalchemy/testing/config.py:280: PytestUnknownMarkWarning: Unknown pytest.mark.mypy - is this a typo?  You can register custom marks to avoid this warning - for details, see https://docs.pytest.org/en/stable/how-to/mark.html\r\n  return getattr(_fixture_functions.add_to_marker, attr)\r\n=========================================================================================== test session starts ============================================================================================\r\nplatform darwin -- Python 3.11.4, pytest-7.4.0, pluggy-1.2.0 -- /Users/penberg/src/libsql/sqlalchemy-libsql/.env/bin/python3.11\r\ncachedir: .pytest_cache\r\nrootdir: /Users/penberg/src/libsql/sqlalchemy-libsql\r\nconfigfile: pyproject.toml\r\ncollecting ... /Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/_pytest/nodes.py:355: PytestUnknownMarkWarning: Unknown pytest.mark.backend - is this a typo?  You can register custom marks to avoid this warning - for details, see https://docs.pytest.org/en/stable/how-to/mark.html\r\n  marker_ = getattr(MARK_GEN, marker)\r\ncollected 193 items\r\n\r\ntest/test_suite.py::AttachedDBTest::test_col_targeting SKIPPED ('test.test_suite.AttachedDBTest' unsupported on any DB implementation 'sqlite(3.42.0)+libsql'custom function)                        [  0%]\r\ntest/test_suite.py::AttachedDBTest::test_col_targeting_union SKIPPED ('test.test_suite.AttachedDBTest' unsupported on any DB implementation 'sqlite(3.42.0)+libsql'custom function)                  [  1%]\r\ntest/test_suite.py::AttachedDBTest::test_column_names SKIPPED ('test.test_suite.AttachedDBTest' unsupported on any DB implementation 'sqlite(3.42.0)+libsql'custom function)                         [  1%]\r\ntest/test_suite.py::AttachedDBTest::test_crud SKIPPED ('test.test_suite.AttachedDBTest' unsupported on any DB implementation 'sqlite(3.42.0)+libsql'custom function)                                 [  2%]\r\ntest/test_suite.py::AttachedDBTest::test_no_tables SKIPPED ('test.test_suite.AttachedDBTest' unsupported on any DB implementation 'sqlite(3.42.0)+libsql'custom function)                            [  2%]\r\ntest/test_suite.py::AttachedDBTest::test_reflect_system_table SKIPPED ('test.test_suite.AttachedDBTest' unsupported on any DB implementation 'sqlite(3.42.0)+libsql'custom function)                 [  3%]\r\ntest/test_suite.py::AttachedDBTest::test_reflect_user_table SKIPPED ('test.test_suite.AttachedDBTest' unsupported on any DB implementation 'sqlite(3.42.0)+libsql'custom function)                   [  3%]\r\ntest/test_suite.py::AttachedDBTest::test_schema_names SKIPPED ('test.test_suite.AttachedDBTest' unsupported on any DB implementation 'sqlite(3.42.0)+libsql'custom function)                         [  4%]\r\ntest/test_suite.py::AttachedDBTest::test_table_names_present SKIPPED ('test.test_suite.AttachedDBTest' unsupported on any DB implementation 'sqlite(3.42.0)+libsql'custom function)                  [  4%]\r\ntest/test_suite.py::AttachedDBTest::test_table_names_system SKIPPED ('test.test_suite.AttachedDBTest' unsupported on any DB implementation 'sqlite(3.42.0)+libsql'custom function)                   [  5%]\r\ntest/test_suite.py::AutoIncrementTest::test_sqlite_autoincrement PASSED                                                                                                                              [  5%]\r\ntest/test_suite.py::AutoIncrementTest::test_sqlite_autoincrement_constraint PASSED                                                                                                                   [  6%]\r\ntest/test_suite.py::AutoIncrementTest::test_sqlite_autoincrement_int_affinity PASSED                                                                                                                 [  6%]\r\ntest/test_suite.py::AutoIncrementTest::test_sqlite_no_autoincrement PASSED                                                                                                                           [  7%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_check_constraint PASSED                                                                                                      [  7%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_constraint_cols[ix-[Code]-Code] FAILED                                                                                       [  8%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_constraint_cols[ix-[Code]-[Code]] FAILED                                                                                     [  8%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_constraint_cols[ix-name with spaces-name with spaces] FAILED                                                                 [  9%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_constraint_cols[ix-plain_name-plain_name] FAILED                                                                             [  9%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_constraint_cols[ix-plainname-plainname] FAILED                                                                               [ 10%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_constraint_cols[pk-[Code]-Code] PASSED                                                                                       [ 10%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_constraint_cols[pk-[Code]-[Code]] PASSED                                                                                     [ 11%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_constraint_cols[pk-name with spaces-name with spaces] PASSED                                                                 [ 11%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_constraint_cols[pk-plain_name-plain_name] PASSED                                                                             [ 12%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_constraint_cols[pk-plainname-plainname] PASSED                                                                               [ 12%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_constraint_cols[uq-[Code]-Code] FAILED                                                                                       [ 13%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_constraint_cols[uq-[Code]-[Code]] FAILED                                                                                     [ 13%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_constraint_cols[uq-name with spaces-name with spaces] FAILED                                                                 [ 14%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_constraint_cols[uq-plain_name-plain_name] FAILED                                                                             [ 15%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_constraint_cols[uq-plainname-plainname] FAILED                                                                               [ 15%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_constraint_cols[uq_inline-[Code]-Code] FAILED                                                                                [ 16%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_constraint_cols[uq_inline-[Code]-[Code]] FAILED                                                                              [ 16%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_constraint_cols[uq_inline-name with spaces-name with spaces] FAILED                                                          [ 17%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_constraint_cols[uq_inline-plain_name-plain_name] FAILED                                                                      [ 17%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_constraint_cols[uq_inline-plainname-plainname] FAILED                                                                        [ 18%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_create_index_with_schema FAILED                                                                                              [ 18%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_dont_reflect_autoindex FAILED                                                                                                [ 19%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_foreign_key_composite_broken_casing PASSED                                                                                   [ 19%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_foreign_key_composite_implicit_parent PASSED                                                                                 [ 20%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_foreign_key_deferrable_initially PASSED                                                                                      [ 20%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_foreign_key_implicit_missing_parent PASSED                                                                                   [ 21%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_foreign_key_implicit_missing_parent_reflection PASSED                                                                        [ 21%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_foreign_key_implicit_parent PASSED                                                                                           [ 22%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_foreign_key_name_is_none PASSED                                                                                              [ 22%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_foreign_key_name_is_not_none PASSED                                                                                          [ 23%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_foreign_key_ondelete_onupdate PASSED                                                                                         [ 23%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_foreign_key_options_unnamed_inline PASSED                                                                                    [ 24%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_legacy_quoted_identifiers_unit PASSED                                                                                        [ 24%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_primary_key_constraint_named PASSED                                                                                          [ 25%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_primary_key_constraint_no_pk PASSED                                                                                          [ 25%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_primary_key_constraint_unnamed PASSED                                                                                        [ 26%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_reflect_partial_indexes FAILED                                                                                               [ 26%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_unique_constraint_named FAILED                                                                                               [ 27%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_unique_constraint_named_broken_casing FAILED                                                                                 [ 27%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_unique_constraint_named_broken_temp ERROR                                                                                    [ 28%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_unique_constraint_unnamed_inline FAILED                                                                                      [ 29%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_unique_constraint_unnamed_inline_quoted FAILED                                                                               [ 29%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_unique_constraint_unnamed_normal FAILED                                                                                      [ 30%]\r\ntest/test_suite.py::ConstraintReflectionTest_sqlite+libsql_3_42_0::test_unique_constraint_unnamed_normal_temporary ERROR                                                                             [ 30%]Traceback (most recent call last):\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/libsql_client/dbapi2/hrana.py\", line 366, in _raw_execute_one\r\n    result = self.connection._raw_execute(stmt)\r\n             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/libsql_client/dbapi2/hrana.py\", line 214, in wrapper\r\n    return future.result(timeout=self._timeout)\r\n           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\r\n  File \"/opt/homebrew/Cellar/python@3.11/3.11.4_1/Frameworks/Python.framework/Versions/3.11/lib/python3.11/concurrent/futures/_base.py\", line 456, in result\r\n    return self.__get_result()\r\n           ^^^^^^^^^^^^^^^^^^^\r\n  File \"/opt/homebrew/Cellar/python@3.11/3.11.4_1/Frameworks/Python.framework/Versions/3.11/lib/python3.11/concurrent/futures/_base.py\", line 401, in __get_result\r\n    raise self._exception\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/libsql_client/dbapi2/_async_executor.py\", line 210, in run_in_main_loop\r\n    r = await r\r\n        ^^^^^^^\r\nlibsql_client.client.LibsqlError: SQLITE_UNKNOWN: SQLite error: no such table: main.a1\r\n\r\nThe above exception was the direct cause of the following exception:\r\n\r\nTraceback (most recent call last):\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/sqlalchemy/engine/base.py\", line 1965, in _exec_single_context\r\n    self.dialect.do_execute(\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/sqlalchemy/engine/default.py\", line 921, in do_execute\r\n    cursor.execute(statement, parameters)\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/libsql_client/dbapi2/types.py\", line 1333, in execute\r\n    self._query_execute(sql, (parameters,), multiple=False, want_rows=True)\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/libsql_client/dbapi2/types.py\", line 907, in wrapper\r\n    return fn(*args, **kwargs)\r\n           ^^^^^^^^^^^^^^^^^^^\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/libsql_client/dbapi2/types.py\", line 1314, in _query_execute\r\n    _raise_converted_exception(error)\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/libsql_client/dbapi2/types.py\", line 972, in _raise_converted_exception\r\n    raise dbapi2_exc from exc\r\nsqlite3.OperationalError: SQLITE_UNKNOWN: SQLite error: no such table: main.a1\r\n\r\nThe above exception was the direct cause of the following exception:\r\n\r\nTraceback (most recent call last):\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/bin/pytest\", line 8, in \u003cmodule\u003e\r\n    sys.exit(console_main())\r\n             ^^^^^^^^^^^^^^\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/_pytest/config/__init__.py\", line 189, in console_main\r\n    code = main()\r\n           ^^^^^^\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/_pytest/config/__init__.py\", line 166, in main\r\n    ret: Union[ExitCode, int] = config.hook.pytest_cmdline_main(\r\n                                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/pluggy/_hooks.py\", line 433, in __call__\r\n    return self._hookexec(self.name, self._hookimpls, kwargs, firstresult)\r\n           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/pluggy/_manager.py\", line 112, in _hookexec\r\n    return self._inner_hookexec(hook_name, methods, kwargs, firstresult)\r\n           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/pluggy/_callers.py\", line 116, in _multicall\r\n    raise exception.with_traceback(exception.__traceback__)\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/pluggy/_callers.py\", line 80, in _multicall\r\n    res = hook_impl.function(*args)\r\n          ^^^^^^^^^^^^^^^^^^^^^^^^^\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/_pytest/main.py\", line 317, in pytest_cmdline_main\r\n    return wrap_session(config, _main)\r\n           ^^^^^^^^^^^^^^^^^^^^^^^^^^^\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/_pytest/main.py\", line 305, in wrap_session\r\n    config.hook.pytest_sessionfinish(\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/pluggy/_hooks.py\", line 433, in __call__\r\n    return self._hookexec(self.name, self._hookimpls, kwargs, firstresult)\r\n           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/pluggy/_manager.py\", line 112, in _hookexec\r\n    return self._inner_hookexec(hook_name, methods, kwargs, firstresult)\r\n           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/pluggy/_callers.py\", line 133, in _multicall\r\n    teardown[0].send(outcome)\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/_pytest/terminal.py\", line 857, in pytest_sessionfinish\r\n    outcome.get_result()\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/pluggy/_result.py\", line 108, in get_result\r\n    raise exc.with_traceback(exc.__traceback__)\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/pluggy/_callers.py\", line 80, in _multicall\r\n    res = hook_impl.function(*args)\r\n          ^^^^^^^^^^^^^^^^^^^^^^^^^\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/_pytest/runner.py\", line 108, in pytest_sessionfinish\r\n    session._setupstate.teardown_exact(None)\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/_pytest/runner.py\", line 537, in teardown_exact\r\n    raise exceptions[0]\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/_pytest/runner.py\", line 526, in teardown_exact\r\n    fin()\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/_pytest/fixtures.py\", line 701, in \u003clambda\u003e\r\n    subrequest.node.addfinalizer(lambda: fixturedef.finish(request=subrequest))\r\n                                         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/_pytest/fixtures.py\", line 1031, in finish\r\n    raise exc\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/_pytest/fixtures.py\", line 1024, in finish\r\n    func()\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/_pytest/fixtures.py\", line 911, in _teardown_yield_fixture\r\n    next(it)\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/sqlalchemy/testing/plugin/pytestplugin.py\", line 531, in setup_class_methods\r\n    asyncio._maybe_async(cls.teardown_test_class)\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/sqlalchemy/testing/asyncio.py\", line 94, in _maybe_async\r\n    return fn(*args, **kwargs)\r\n           ^^^^^^^^^^^^^^^^^^^\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/test/test_suite.py\", line 1971, in teardown_test_class\r\n    conn.exec_driver_sql(\"drop table %s\" % name)\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/sqlalchemy/engine/base.py\", line 1774, in exec_driver_sql\r\n    ret = self._execute_context(\r\n          ^^^^^^^^^^^^^^^^^^^^^^\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/sqlalchemy/engine/base.py\", line 1844, in _execute_context\r\n    return self._exec_single_context(\r\n           ^^^^^^^^^^^^^^^^^^^^^^^^^^\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/sqlalchemy/engine/base.py\", line 1984, in _exec_single_context\r\n    self._handle_dbapi_exception(\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/sqlalchemy/engine/base.py\", line 2339, in _handle_dbapi_exception\r\n    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/sqlalchemy/engine/base.py\", line 1965, in _exec_single_context\r\n    self.dialect.do_execute(\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/sqlalchemy/engine/default.py\", line 921, in do_execute\r\n    cursor.execute(statement, parameters)\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/libsql_client/dbapi2/types.py\", line 1333, in execute\r\n    self._query_execute(sql, (parameters,), multiple=False, want_rows=True)\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/libsql_client/dbapi2/types.py\", line 907, in wrapper\r\n    return fn(*args, **kwargs)\r\n           ^^^^^^^^^^^^^^^^^^^\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/libsql_client/dbapi2/types.py\", line 1314, in _query_execute\r\n    _raise_converted_exception(error)\r\n  File \"/Users/penberg/src/libsql/sqlalchemy-libsql/.env/lib/python3.11/site-packages/libsql_client/dbapi2/types.py\", line 972, in _raise_converted_exception\r\n    raise dbapi2_exc from exc\r\nsqlalchemy.exc.OperationalError: (sqlite3.OperationalError) SQLITE_UNKNOWN: SQLite error: no such table: main.a1\r\n[SQL: drop table a2]\r\n(Background on this error at: https://sqlalche.me/e/20/e3q8)\r\n```","author":{"url":"https://github.com/penberg","@type":"Person","name":"penberg"},"datePublished":"2023-08-22T08:40:10.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":3},"url":"https://github.com/3/sqlalchemy-libsql/issues/3"}