diff options
Diffstat (limited to 'sqlglot/optimizer/qualify_tables.py')
-rw-r--r-- | sqlglot/optimizer/qualify_tables.py | 3 |
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 |