summaryrefslogtreecommitdiffstats
path: root/sqlglot/optimizer/qualify_tables.py
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2023-05-03 09:12:24 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2023-05-03 09:12:24 +0000
commit98d5537435b2951b36c45f1fda667fa27c165794 (patch)
treed26b4dfa6cf91847100fe10a94a04dcc2ad36a86 /sqlglot/optimizer/qualify_tables.py
parentAdding upstream version 11.5.2. (diff)
downloadsqlglot-091f07175e8b976fcf301fe4832c1b7e0bc4eef0.tar.xz
sqlglot-091f07175e8b976fcf301fe4832c1b7e0bc4eef0.zip
Adding upstream version 11.7.1.upstream/11.7.1
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'sqlglot/optimizer/qualify_tables.py')
-rw-r--r--sqlglot/optimizer/qualify_tables.py3
1 files changed, 3 insertions, 0 deletions
diff --git a/sqlglot/optimizer/qualify_tables.py b/sqlglot/optimizer/qualify_tables.py
index 93e1179..a719ebe 100644
--- a/sqlglot/optimizer/qualify_tables.py
+++ b/sqlglot/optimizer/qualify_tables.py
@@ -65,5 +65,8 @@ def qualify_tables(expression, db=None, catalog=None, schema=None):
if not table_alias.name:
table_alias.set("this", next_name())
+ if isinstance(udtf, exp.Values) and not table_alias.columns:
+ for i, e in enumerate(udtf.expressions[0].expressions):
+ table_alias.append("columns", exp.to_identifier(f"_col_{i}"))
return expression