From 8de4ca74ba49b3f97a252e2b9d385cb2e70c442c Mon Sep 17 00:00:00 2001 From: Hasan Ramezani Date: Fri, 30 Apr 2021 13:37:19 +0200 Subject: Fixed #32693 -- Quoted and lowercased generated column aliases. --- django/db/models/sql/compiler.py | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'django/db/models/sql') diff --git a/django/db/models/sql/compiler.py b/django/db/models/sql/compiler.py index 5fd37423de..7264929da8 100644 --- a/django/db/models/sql/compiler.py +++ b/django/db/models/sql/compiler.py @@ -554,7 +554,10 @@ class SQLCompiler: if alias: s_sql = '%s AS %s' % (s_sql, self.connection.ops.quote_name(alias)) elif with_col_aliases: - s_sql = '%s AS %s' % (s_sql, 'Col%d' % col_idx) + s_sql = '%s AS %s' % ( + s_sql, + self.connection.ops.quote_name('col%d' % col_idx), + ) col_idx += 1 params.extend(s_params) out_cols.append(s_sql) -- cgit v1.3