Repository navigation
Error compiling Python 3.13.0 when Sqlite compiled with foreign-key enabled by default. #125203
Closed as not planned
Description
Bug report
Bug description:
My system sqlite is compiled with support for foreign keys:
sqlite> pragma compile_options; ... DEFAULT_FOREIGN_KEYS ...
This causes a test failure when attempting to compile Python 3.13.0:
======================================================================
ERROR: test_table_dump (test.test_sqlite3.test_dump.DumpTests.test_table_dump)
----------------------------------------------------------------------
Traceback (most recent call last):
File "/home/charles/code/python-3.13.0/Lib/test/test_sqlite3/test_dump.py", line 45, in test_table_dump
[self.cu.execute(s) for s in expected_sqls]
~~~~~~~~~~~~~~~^^^
sqlite3.IntegrityError: FOREIGN KEY constraint failed
----------------------------------------------------------------------The test-case should likely disable foreign-key pragma before beginning in order to be correct in all cases.
CPython versions tested on:
3.13
Operating systems tested on:
Linux
Activity
tomasr8 commented on Oct 9, 2024
Seems to be related to this issue #123849
Though it looks like the 3.13 backport which fixes the test failure has not been merged yet: #125163
coleifer commented on Oct 9, 2024
Yes, feel free to close as duplicate, thanks for triaging this @tomasr8.