Source: django-cte Version: 1.3.0-1 Severity: serious Justification: FTBFS Tags: trixie sid ftbfs User: [email protected] Usertags: ftbfs-20230925 ftbfs-trixie
Hi, During a rebuild of all packages in sid, your package failed to build on amd64. Relevant part (hopefully): > debian/rules binary > dh binary --buildsystem=pybuild > dh_update_autotools_config -O--buildsystem=pybuild > dh_autoreconf -O--buildsystem=pybuild > dh_auto_configure -O--buildsystem=pybuild > I: pybuild base:291: python3.11 setup.py config > /usr/lib/python3/dist-packages/setuptools/config/setupcfg.py:293: > _DeprecatedConfig: Deprecated config in `setup.cfg` > !! > > > ******************************************************************************** > The license_file parameter is deprecated, use license_files instead. > > By 2023-Oct-30, you need to update your project and remove deprecated > calls > or your builds will no longer be supported. > > See > https://setuptools.pypa.io/en/latest/userguide/declarative_config.html for > details. > > ******************************************************************************** > > !! > parsed = self.parsers.get(option_name, lambda x: x)(value) > running config > dh_auto_build -O--buildsystem=pybuild > I: pybuild base:291: /usr/bin/python3 setup.py build > /usr/lib/python3/dist-packages/setuptools/config/setupcfg.py:293: > _DeprecatedConfig: Deprecated config in `setup.cfg` > !! > > > ******************************************************************************** > The license_file parameter is deprecated, use license_files instead. > > By 2023-Oct-30, you need to update your project and remove deprecated > calls > or your builds will no longer be supported. > > See > https://setuptools.pypa.io/en/latest/userguide/declarative_config.html for > details. > > ******************************************************************************** > > !! > parsed = self.parsers.get(option_name, lambda x: x)(value) > running build > running build_py > creating /<<PKGBUILDDIR>>/.pybuild/cpython3_3.11_django-cte/build/django_cte > copying django_cte/expressions.py -> > /<<PKGBUILDDIR>>/.pybuild/cpython3_3.11_django-cte/build/django_cte > copying django_cte/meta.py -> > /<<PKGBUILDDIR>>/.pybuild/cpython3_3.11_django-cte/build/django_cte > copying django_cte/join.py -> > /<<PKGBUILDDIR>>/.pybuild/cpython3_3.11_django-cte/build/django_cte > copying django_cte/__init__.py -> > /<<PKGBUILDDIR>>/.pybuild/cpython3_3.11_django-cte/build/django_cte > copying django_cte/query.py -> > /<<PKGBUILDDIR>>/.pybuild/cpython3_3.11_django-cte/build/django_cte > copying django_cte/raw.py -> > /<<PKGBUILDDIR>>/.pybuild/cpython3_3.11_django-cte/build/django_cte > copying django_cte/cte.py -> > /<<PKGBUILDDIR>>/.pybuild/cpython3_3.11_django-cte/build/django_cte > running egg_info > creating django_cte.egg-info > writing django_cte.egg-info/PKG-INFO > writing dependency_links to django_cte.egg-info/dependency_links.txt > writing top-level names to django_cte.egg-info/top_level.txt > writing manifest file 'django_cte.egg-info/SOURCES.txt' > reading manifest file 'django_cte.egg-info/SOURCES.txt' > adding license file 'LICENSE' > writing manifest file 'django_cte.egg-info/SOURCES.txt' > dh_auto_test -O--buildsystem=pybuild > I: pybuild base:291: cd > /<<PKGBUILDDIR>>/.pybuild/cpython3_3.11_django-cte/build; python3.11 -m nose > -v tests > test_cte_name_escape (tests.test_cte.TestCTE.test_cte_name_escape) ... ok > test_cte_queryset (tests.test_cte.TestCTE.test_cte_queryset) ... ok > test_cte_queryset_with_join > (tests.test_cte.TestCTE.test_cte_queryset_with_join) ... ok > test_cte_queryset_with_model_result > (tests.test_cte.TestCTE.test_cte_queryset_with_model_result) ... ok > test_cte_queryset_with_values_result > (tests.test_cte.TestCTE.test_cte_queryset_with_values_result) ... ok > test_delete_cte_query (tests.test_cte.TestCTE.test_delete_cte_query) ... > SKIP: this test will not work until `QuerySet.delete` (Django method) calls > `self.query.chain(sql.DeleteQuery)` instead of `sql.DeleteQuery(self.model)` > test_experimental_left_outer_join > (tests.test_cte.TestCTE.test_experimental_left_outer_join) ... ok > Verifies that using .explain() prepends the EXPLAIN clause in the ... ok > test_materialized_option (tests.test_cte.TestCTE.test_materialized_option) > ... ok > test_named_ctes (tests.test_cte.TestCTE.test_named_ctes) ... ERROR > test_named_simple_ctes (tests.test_cte.TestCTE.test_named_simple_ctes) ... ok > Verifies that subquery annotations are handled correctly when the ... ok > test_outerref_in_cte_query > (tests.test_cte.TestCTE.test_outerref_in_cte_query) ... ok > test_simple_cte_query (tests.test_cte.TestCTE.test_simple_cte_query) ... ok > test_update_cte_query (tests.test_cte.TestCTE.test_update_cte_query) ... ok > test_cte_create_manager_from_non_cteQuery > (tests.test_manager.TestCTE.test_cte_create_manager_from_non_cteQuery) ... ok > test_cte_queryset_correct_defaultmanager > (tests.test_manager.TestCTE.test_cte_queryset_correct_defaultmanager) ... ok > test_cte_queryset_correct_from_queryset > (tests.test_manager.TestCTE.test_cte_queryset_correct_from_queryset) ... ok > test_cte_queryset_correct_limitedmanager > (tests.test_manager.TestCTE.test_cte_queryset_correct_limitedmanager) ... ok > test_cte_queryset_correct_manager_n_from_queryset > (tests.test_manager.TestCTE.test_cte_queryset_correct_manager_n_from_queryset) > ... ok > test_cte_queryset_correct_queryset_as_manager > (tests.test_manager.TestCTE.test_cte_queryset_correct_queryset_as_manager) > ... ok > test_cte_queryset_with_custom_queryset > (tests.test_manager.TestCTE.test_cte_queryset_with_custom_queryset) ... ok > test_cte_queryset_with_from_queryset > (tests.test_manager.TestCTE.test_cte_queryset_with_from_queryset) ... ok > test_raw_cte_sql (tests.test_raw.TestRawCTE.test_raw_cte_sql) ... ok > test_raw_cte_sql_name_escape > (tests.test_raw.TestRawCTE.test_raw_cte_sql_name_escape) ... ok > test_alias_as_subquery > (tests.test_recursive.TestRecursiveCTE.test_alias_as_subquery) ... ERROR > test_alias_change_in_annotation > (tests.test_recursive.TestRecursiveCTE.test_alias_change_in_annotation) ... > ERROR > test_attname_should_not_mask_col_name > (tests.test_recursive.TestRecursiveCTE.test_attname_should_not_mask_col_name) > ... ERROR > test_circular_ref_error > (tests.test_recursive.TestRecursiveCTE.test_circular_ref_error) ... ok > test_materialized (tests.test_recursive.TestRecursiveCTE.test_materialized) > ... ok > test_pickle_recursive_cte_queryset > (tests.test_recursive.TestRecursiveCTE.test_pickle_recursive_cte_queryset) > ... ERROR > test_recursive_cte_query > (tests.test_recursive.TestRecursiveCTE.test_recursive_cte_query) ... ERROR > test_recursive_cte_reference_in_condition > (tests.test_recursive.TestRecursiveCTE.test_recursive_cte_reference_in_condition) > ... ERROR > test_recursive_cte_with_empty_union_part > (tests.test_recursive.TestRecursiveCTE.test_recursive_cte_with_empty_union_part) > ... SKIP: Expected failure: QuerySet omits `EmptyQuerySet` from UNION > queries resulting in invalid CTE SQL > > ====================================================================== > ERROR: test_named_ctes (tests.test_cte.TestCTE.test_named_ctes) > ---------------------------------------------------------------------- > Traceback (most recent call last): > File > "/<<PKGBUILDDIR>>/.pybuild/cpython3_3.11_django-cte/build/tests/test_cte.py", > line 290, in test_named_ctes > data = sorted( > ^ > File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 398, > in __iter__ > self._fetch_all() > File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 1881, > in _fetch_all > self._result_cache = list(self._iterable_class(self)) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 91, > in __iter__ > results = compiler.execute_sql( > ^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/models/sql/compiler.py", > line 1562, in execute_sql > cursor.execute(sql, params) > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 67, > in execute > return self._execute_with_wrappers( > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 80, > in _execute_with_wrappers > return executor(sql, params, many, context) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 84, > in _execute > with self.db.wrap_database_errors: > File "/usr/lib/python3/dist-packages/django/db/utils.py", line 91, in > __exit__ > raise dj_exc_value.with_traceback(traceback) from exc_value > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 89, > in _execute > return self.cursor.execute(sql, params) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/backends/sqlite3/base.py", > line 328, in execute > return super().execute(query, params) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > django.db.utils.OperationalError: no such column: rootmap.name > -------------------- >> begin captured stdout << --------------------- > WITH RECURSIVE "rootmap" AS (SELECT "region"."name" AS "col1", > "region"."name" AS "root" FROM "region" WHERE "region"."parent_id" IS NULL > UNION ALL SELECT "region"."name" AS "col1", "rootmap"."root" AS "root" FROM > "region" INNER JOIN "rootmap" ON "region"."parent_id" = ("rootmap"."name")), > "totals" AS (SELECT "rootmap"."root" AS "root", COUNT("orders"."id") AS > "orders_count", SUM("orders"."amount") AS "region_total" FROM "orders" INNER > JOIN "rootmap" ON "orders"."region_id" = ("rootmap"."name") GROUP BY 1) > SELECT "region"."name", "region"."parent_id", "totals"."orders_count" AS > "orders_count", "totals"."region_total" AS "region_total" FROM "region" INNER > JOIN "totals" ON "region"."name" = ("totals"."root") > > --------------------- >> end captured stdout << ---------------------- > > ====================================================================== > ERROR: test_alias_as_subquery > (tests.test_recursive.TestRecursiveCTE.test_alias_as_subquery) > ---------------------------------------------------------------------- > Traceback (most recent call last): > File > "/<<PKGBUILDDIR>>/.pybuild/cpython3_3.11_django-cte/build/tests/test_recursive.py", > line 306, in test_alias_as_subquery > self.assertEqual(query.get().key, 'level 3') > ^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 633, > in get > num = len(clone) > ^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 380, > in __len__ > self._fetch_all() > File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 1881, > in _fetch_all > self._result_cache = list(self._iterable_class(self)) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 91, > in __iter__ > results = compiler.execute_sql( > ^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/models/sql/compiler.py", > line 1562, in execute_sql > cursor.execute(sql, params) > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 67, > in execute > return self._execute_with_wrappers( > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 80, > in _execute_with_wrappers > return executor(sql, params, many, context) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 84, > in _execute > with self.db.wrap_database_errors: > File "/usr/lib/python3/dist-packages/django/db/utils.py", line 91, in > __exit__ > raise dj_exc_value.with_traceback(traceback) from exc_value > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 89, > in _execute > return self.cursor.execute(sql, params) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/backends/sqlite3/base.py", > line 328, in execute > return super().execute(query, params) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > django.db.utils.OperationalError: no such column: cte.id > -------------------- >> begin captured stdout << --------------------- > WITH RECURSIVE "cte" AS (SELECT "keypair"."id" AS "col1", "keypair"."key" AS > "col2", "keypair"."value" AS "col3", "keypair"."parent_id" AS "col4", > "keypair"."value" AS "rank" FROM "keypair" INNER JOIN "keypair" T2 ON > ("keypair"."parent_id" = T2."id") WHERE T2."key" = level 1 UNION ALL SELECT > "keypair"."id" AS "col1", "keypair"."key" AS "col2", "keypair"."value" AS > "col3", "keypair"."parent_id" AS "col4", "keypair"."value" AS "rank" FROM > "keypair" INNER JOIN "cte" ON "keypair"."parent_id" = ("cte"."id")), "xdups" > AS (SELECT "cte"."id", "cte"."value" AS "rank" FROM "cte" INNER JOIN > "keypair" ON ("cte"."parent_id" = "keypair"."id") WHERE "keypair"."key" = > level 1) SELECT "cte"."id", "cte"."key", "cte"."value", "cte"."parent_id", > "cte"."rank" AS "rank", EXISTS(SELECT 1 AS "a" FROM "xdups" U0 WHERE (U0."id" > = ("cte"."id") AND U0."rank" = ("cte"."rank")) LIMIT 1) AS "_exclude" FROM > "cte" WHERE EXISTS(SELECT 1 AS "a" FROM "xdups" U0 WHERE (U0."id" = > ("cte"."id") AND U0."rank" = ("cte"."rank")) LIMIT 1) > SELECT "keypair"."id", "keypair"."key", "keypair"."value", > "keypair"."parent_id" FROM "keypair" WHERE "keypair"."parent_id" IN (WITH > RECURSIVE "cte" AS (SELECT "keypair"."id" AS "col1", "keypair"."key" AS > "col2", "keypair"."value" AS "col3", "keypair"."parent_id" AS "col4", > "keypair"."value" AS "rank" FROM "keypair" INNER JOIN "keypair" T2 ON > ("keypair"."parent_id" = T2."id") WHERE T2."key" = level 1 UNION ALL SELECT > "keypair"."id" AS "col1", "keypair"."key" AS "col2", "keypair"."value" AS > "col3", "keypair"."parent_id" AS "col4", "keypair"."value" AS "rank" FROM > "keypair" INNER JOIN "cte" ON "keypair"."parent_id" = ("cte"."id")), "xdups" > AS (SELECT "cte"."id", "cte"."value" AS "rank" FROM "cte" INNER JOIN > "keypair" ON ("cte"."parent_id" = "keypair"."id") WHERE "keypair"."key" = > level 1) SELECT V0."id" FROM "cte" V0 WHERE EXISTS(SELECT 1 AS "a" FROM > "xdups" U0 WHERE (U0."id" = (V0."id") AND U0."rank" = (V0."rank")) LIMIT 1)) > WITH RECURSIVE "cte" AS (SELECT "keypair"."id" AS "col1", "keypair"."key" AS > "col2", "keypair"."value" AS "col3", "keypair"."parent_id" AS "col4", > "keypair"."value" AS "rank" FROM "keypair" INNER JOIN "keypair" T2 ON > ("keypair"."parent_id" = T2."id") WHERE T2."key" = level 1 UNION ALL SELECT > "keypair"."id" AS "col1", "keypair"."key" AS "col2", "keypair"."value" AS > "col3", "keypair"."parent_id" AS "col4", "keypair"."value" AS "rank" FROM > "keypair" INNER JOIN "cte" ON "keypair"."parent_id" = ("cte"."id")), "xdups" > AS (SELECT "cte"."id", "cte"."value" AS "rank" FROM "cte" INNER JOIN > "keypair" ON ("cte"."parent_id" = "keypair"."id") WHERE "keypair"."key" = > level 1) SELECT "cte"."id", "cte"."key", "cte"."value", "cte"."parent_id", > "cte"."rank" AS "rank", EXISTS(SELECT 1 AS "a" FROM "xdups" U0 WHERE (U0."id" > = ("cte"."id") AND U0."rank" = ("cte"."rank")) LIMIT 1) AS "_exclude" FROM > "cte" WHERE EXISTS(SELECT 1 AS "a" FROM "xdups" U0 WHERE (U0."id" = > ("cte"."id") AND U0."rank" = ("cte"."rank")) LIMIT 1) > > --------------------- >> end captured stdout << ---------------------- > > ====================================================================== > ERROR: test_alias_change_in_annotation > (tests.test_recursive.TestRecursiveCTE.test_alias_change_in_annotation) > ---------------------------------------------------------------------- > Traceback (most recent call last): > File > "/<<PKGBUILDDIR>>/.pybuild/cpython3_3.11_django-cte/build/tests/test_recursive.py", > line 264, in test_alias_change_in_annotation > self.assertFalse(query) > File "/usr/lib/python3.11/unittest/case.py", line 707, in assertFalse > if expr: > File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 412, > in __bool__ > self._fetch_all() > File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 1881, > in _fetch_all > self._result_cache = list(self._iterable_class(self)) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 91, > in __iter__ > results = compiler.execute_sql( > ^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/models/sql/compiler.py", > line 1562, in execute_sql > cursor.execute(sql, params) > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 67, > in execute > return self._execute_with_wrappers( > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 80, > in _execute_with_wrappers > return executor(sql, params, many, context) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 84, > in _execute > with self.db.wrap_database_errors: > File "/usr/lib/python3/dist-packages/django/db/utils.py", line 91, in > __exit__ > raise dj_exc_value.with_traceback(traceback) from exc_value > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 89, > in _execute > return self.cursor.execute(sql, params) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/backends/sqlite3/base.py", > line 328, in execute > return super().execute(query, params) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > django.db.utils.OperationalError: no such column: cte.name > -------------------- >> begin captured stdout << --------------------- > WITH RECURSIVE "cte" AS (SELECT "region"."name" AS "col1", > "region"."parent_id" AS "col2", "region"."name" AS "value" FROM "region" > WHERE "region"."parent_id" = sun UNION ALL SELECT "region"."name" AS "col1", > "region"."parent_id" AS "col2", "region"."name" AS "value" FROM "region" > INNER JOIN "cte" ON "region"."parent_id" = ("cte"."name")), "value_cte" AS > (SELECT "cte"."name", "cte"."parent_id", COALESCE("cte"."name", ) || > COALESCE("cte"."name", ) AS "value" FROM "cte" WHERE "cte"."parent_id" = sun) > SELECT "cte"."name", "cte"."parent_id", "cte"."value" AS "value", > EXISTS(SELECT 1 AS "a" FROM "value_cte" U0 WHERE (U0."name" = ("cte"."name") > AND U0."value" = ("cte"."value")) LIMIT 1) AS "_exclude_leaves" FROM "cte" > WHERE EXISTS(SELECT 1 AS "a" FROM "value_cte" U0 WHERE (U0."name" = > ("cte"."name") AND U0."value" = ("cte"."value")) LIMIT 1) > > --------------------- >> end captured stdout << ---------------------- > > ====================================================================== > ERROR: test_attname_should_not_mask_col_name > (tests.test_recursive.TestRecursiveCTE.test_attname_should_not_mask_col_name) > ---------------------------------------------------------------------- > Traceback (most recent call last): > File > "/<<PKGBUILDDIR>>/.pybuild/cpython3_3.11_django-cte/build/tests/test_recursive.py", > line 205, in test_attname_should_not_mask_col_name > data = [r.name for r in regions] > ^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 398, > in __iter__ > self._fetch_all() > File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 1881, > in _fetch_all > self._result_cache = list(self._iterable_class(self)) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 91, > in __iter__ > results = compiler.execute_sql( > ^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/models/sql/compiler.py", > line 1562, in execute_sql > cursor.execute(sql, params) > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 67, > in execute > return self._execute_with_wrappers( > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 80, > in _execute_with_wrappers > return executor(sql, params, many, context) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 84, > in _execute > with self.db.wrap_database_errors: > File "/usr/lib/python3/dist-packages/django/db/utils.py", line 91, in > __exit__ > raise dj_exc_value.with_traceback(traceback) from exc_value > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 89, > in _execute > return self.cursor.execute(sql, params) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/backends/sqlite3/base.py", > line 328, in execute > return super().execute(query, params) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > django.db.utils.OperationalError: no such column: cte.parent_id > -------------------- >> begin captured stdout << --------------------- > WITH RECURSIVE "cte" AS (SELECT "region"."name" AS "col1", > "region"."parent_id" AS "col2" FROM "region" WHERE "region"."name" = moon > UNION ALL SELECT "region"."name" AS "col1", "region"."parent_id" AS "col2" > FROM "region" INNER JOIN "cte" ON "region"."name" = ("cte"."parent_id")) > SELECT "region"."name", "region"."parent_id", EXISTS(SELECT 1 AS "a" FROM > "cte" U0 WHERE U0."name" = ("region"."name") LIMIT 1) AS "_ex" FROM "region" > WHERE EXISTS(SELECT 1 AS "a" FROM "cte" U0 WHERE U0."name" = > ("region"."name") LIMIT 1) ORDER BY "region"."name" ASC > > --------------------- >> end captured stdout << ---------------------- > > ====================================================================== > ERROR: test_pickle_recursive_cte_queryset > (tests.test_recursive.TestRecursiveCTE.test_pickle_recursive_cte_queryset) > ---------------------------------------------------------------------- > Traceback (most recent call last): > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 89, > in _execute > return self.cursor.execute(sql, params) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/backends/sqlite3/base.py", > line 328, in execute > return super().execute(query, params) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > sqlite3.OperationalError: no such column: cte.name > > The above exception was the direct cause of the following exception: > > Traceback (most recent call last): > File > "/<<PKGBUILDDIR>>/.pybuild/cpython3_3.11_django-cte/build/tests/test_recursive.py", > line 223, in test_pickle_recursive_cte_queryset > pickled_qs = pickle.loads(pickle.dumps(regions)) > ^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 351, > in __getstate__ > self._fetch_all() > File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 1881, > in _fetch_all > self._result_cache = list(self._iterable_class(self)) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 91, > in __iter__ > results = compiler.execute_sql( > ^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/models/sql/compiler.py", > line 1562, in execute_sql > cursor.execute(sql, params) > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 67, > in execute > return self._execute_with_wrappers( > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 80, > in _execute_with_wrappers > return executor(sql, params, many, context) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 84, > in _execute > with self.db.wrap_database_errors: > File "/usr/lib/python3/dist-packages/django/db/utils.py", line 91, in > __exit__ > raise dj_exc_value.with_traceback(traceback) from exc_value > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 89, > in _execute > return self.cursor.execute(sql, params) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/backends/sqlite3/base.py", > line 328, in execute > return super().execute(query, params) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > django.db.utils.OperationalError: no such column: cte.name > > ====================================================================== > ERROR: test_recursive_cte_query > (tests.test_recursive.TestRecursiveCTE.test_recursive_cte_query) > ---------------------------------------------------------------------- > Traceback (most recent call last): > File > "/<<PKGBUILDDIR>>/.pybuild/cpython3_3.11_django-cte/build/tests/test_recursive.py", > line 69, in test_recursive_cte_query > data = [(r.name, r.path, r.depth) for r in regions] > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 398, > in __iter__ > self._fetch_all() > File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 1881, > in _fetch_all > self._result_cache = list(self._iterable_class(self)) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 91, > in __iter__ > results = compiler.execute_sql( > ^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/models/sql/compiler.py", > line 1562, in execute_sql > cursor.execute(sql, params) > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 67, > in execute > return self._execute_with_wrappers( > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 80, > in _execute_with_wrappers > return executor(sql, params, many, context) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 84, > in _execute > with self.db.wrap_database_errors: > File "/usr/lib/python3/dist-packages/django/db/utils.py", line 91, in > __exit__ > raise dj_exc_value.with_traceback(traceback) from exc_value > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 89, > in _execute > return self.cursor.execute(sql, params) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/backends/sqlite3/base.py", > line 328, in execute > return super().execute(query, params) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > django.db.utils.OperationalError: no such column: cte.name > -------------------- >> begin captured stdout << --------------------- > WITH RECURSIVE "cte" AS (SELECT "region"."name" AS "col1", "region"."name" AS > "path", 0 AS "depth" FROM "region" WHERE "region"."parent_id" IS NULL UNION > ALL SELECT "region"."name" AS "col1", COALESCE("cte"."path", ) || > COALESCE(COALESCE( / , ) || COALESCE("region"."name", ), ) AS "path", > ("cte"."depth" + 1) AS "depth" FROM "region" INNER JOIN "cte" ON > "region"."parent_id" = ("cte"."name")) SELECT "region"."name", > "region"."parent_id", "cte"."path" AS "path", "cte"."depth" AS "depth" FROM > "region" INNER JOIN "cte" ON "region"."name" = ("cte"."name") WHERE > "cte"."depth" = 2 ORDER BY 3 ASC > > --------------------- >> end captured stdout << ---------------------- > > ====================================================================== > ERROR: test_recursive_cte_reference_in_condition > (tests.test_recursive.TestRecursiveCTE.test_recursive_cte_reference_in_condition) > ---------------------------------------------------------------------- > Traceback (most recent call last): > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 89, > in _execute > return self.cursor.execute(sql, params) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/backends/sqlite3/base.py", > line 328, in execute > return super().execute(query, params) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > sqlite3.OperationalError: no such column: cte.name > > The above exception was the direct cause of the following exception: > > Traceback (most recent call last): > File > "/<<PKGBUILDDIR>>/.pybuild/cpython3_3.11_django-cte/build/tests/test_recursive.py", > line 122, in test_recursive_cte_reference_in_condition > data = [(r.path.split("\x01"), r.is_planet) for r in regions] > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 398, > in __iter__ > self._fetch_all() > File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 1881, > in _fetch_all > self._result_cache = list(self._iterable_class(self)) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 91, > in __iter__ > results = compiler.execute_sql( > ^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/models/sql/compiler.py", > line 1562, in execute_sql > cursor.execute(sql, params) > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 67, > in execute > return self._execute_with_wrappers( > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 80, > in _execute_with_wrappers > return executor(sql, params, many, context) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 84, > in _execute > with self.db.wrap_database_errors: > File "/usr/lib/python3/dist-packages/django/db/utils.py", line 91, in > __exit__ > raise dj_exc_value.with_traceback(traceback) from exc_value > File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 89, > in _execute > return self.cursor.execute(sql, params) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > File "/usr/lib/python3/dist-packages/django/db/backends/sqlite3/base.py", > line 328, in execute > return super().execute(query, params) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > django.db.utils.OperationalError: no such column: cte.name > > ---------------------------------------------------------------------- > Ran 34 tests in 0.122s > > FAILED (SKIP=2, errors=7) > E: pybuild pybuild:395: test: plugin distutils failed with: exit code=1: cd > /<<PKGBUILDDIR>>/.pybuild/cpython3_3.11_django-cte/build; python3.11 -m nose > -v tests > dh_auto_test: error: pybuild --test -i python{version} -p 3.11 returned exit > code 13 The full build log is available from: http://qa-logs.debian.net/2023/09/25/django-cte_1.3.0-1_unstable.log All bugs filed during this archive rebuild are listed at: https://bugs.debian.org/cgi-bin/pkgreport.cgi?tag=ftbfs-20230925;[email protected] or: https://udd.debian.org/bugs/?release=na&merged=ign&fnewerval=7&flastmodval=7&fusertag=only&fusertagtag=ftbfs-20230925&[email protected]&allbugs=1&cseverity=1&ctags=1&caffected=1#results A list of current common problems and possible solutions is available at http://wiki.debian.org/qa.debian.org/FTBFS . You're welcome to contribute! If you reassign this bug to another package, please mark it as 'affects'-ing this package. See https://www.debian.org/Bugs/server-control#affects If you fail to reproduce this, please provide a build log and diff it with mine so that we can identify if something relevant changed in the meantime.
