--- Begin Message ---
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.
--- End Message ---
