From 67c28dbe67209effad83d93b850caba5ee1e20e3 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Wed, 3 May 2023 11:12:28 +0200 Subject: Merging upstream version 11.7.1. Signed-off-by: Daniel Baumann --- sqlglot/optimizer/qualify_tables.py | 3 +++ 1 file changed, 3 insertions(+) (limited to 'sqlglot/optimizer/qualify_tables.py') 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 -- cgit v1.2.3