id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
32627	QuerySet.values()/values_list() crash on combined querysets ordered by unannotated columns.	Iuri de Silvio	Iuri de Silvio	"Django 3.2 fails with this query:

{{{#!python
qs1 = Celebrity.objects.all()
qs2 = ReservedName.objects.all()
qs1.union(qs2).values_list('name').first()
}}}

It worked until Django 3.1.8. This commit[1] to be exactly. https://github.com/django/django/commit/464a4c0c59277056b5d3c1132ac1b4c6085aee08

This is the broken generated query. In the second query, it fetches from the first table.

{{{#!sql
SQL
SELECT
    ""queries_celebrity"".""name"",
    ""queries_celebrity"".""id"" AS ""__orderbycol2""
FROM
    ""queries_celebrity""
UNION
SELECT
    ""queries_reservedname"".""name"",
    ""queries_celebrity"".""id"" AS ""__orderbycol2""  -- HERE IS THE PROBLEM
FROM
    ""queries_reservedname""
ORDER BY
    (2) ASC
LIMIT
    1
}}}

Before, it was:

{{{#!sql
SQL
SELECT
    ""queries_celebrity"".""name"",
    ""queries_celebrity"".""id""
FROM
    ""queries_celebrity""
UNION
SELECT
    ""queries_reservedname"".""name"",
    ""queries_reservedname"".""id""
FROM
    ""queries_reservedname""
ORDER BY
    (2) ASC
LIMIT
    1
}}}"	Bug	closed	Database layer (models, ORM)	3.2	Release blocker	fixed		David Wobrock	Ready for checkin	1	0	0	0	0	0