[
https://issues.apache.org/jira/browse/SPARK-34636?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kousuke Saruta updated SPARK-34636:
-----------------------------------
Description:
UnresolvedReference, AttributeReference and Alias which take qualifier don't
quote qualified names properly.
One instance is reported in SPARK-34626.
Other instances are like as follows.
{code}
UnresolvedAttribute("a`b"::"c.d"::Nil).sql
a`b.`c.d` // should be `a``b`.`c.d`
AttributeReference("a.b", IntegerType)(qualifier = "c.d"::Nil)
c.d.`a.b` // should be `c.d`.`a.b`
Alias(AttributeReference("a", IntegerType)(), "b.c")(qualifier = "d.e"::Nil).sql
`a` AS d.e.`b.c` // should be `a` AS `d.e`.`b.c`
{code}
was:
UnresolvedReference, AttributeReference and Alias which take qualifier don't
quote qualified names properly.
One instance is reported in SPARK-34626.
Other instances are like as follows.
{code}
UnresolvedAttribute("a`b"::"c.d"::Nil).sql
a`b.`c.d` // should be `a``b`.`c.d`
AttributeReference("a.b", IntegerType)(qualifier = "c.d"::Nil)
c.d.`a.b` // should be `c.d`.`a.b`
Alias(AttributeReference("a", IntegerType)(), "b.c")(qualifier = "d.e"::Nil).sql
`a` AS d.e.`b.c` // should be `a` AS `d.e`.`b.c`
> sql method in UnresolvedAttribute, AttributeReference and Alias don't quote
> qualified names properly.
> -----------------------------------------------------------------------------------------------------
>
> Key: SPARK-34636
> URL: https://issues.apache.org/jira/browse/SPARK-34636
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 3.0.2, 3.2.0, 3.1.1
> Reporter: Kousuke Saruta
> Assignee: Kousuke Saruta
> Priority: Major
>
> UnresolvedReference, AttributeReference and Alias which take qualifier don't
> quote qualified names properly.
> One instance is reported in SPARK-34626.
> Other instances are like as follows.
> {code}
> UnresolvedAttribute("a`b"::"c.d"::Nil).sql
> a`b.`c.d` // should be `a``b`.`c.d`
> AttributeReference("a.b", IntegerType)(qualifier = "c.d"::Nil)
> c.d.`a.b` // should be `c.d`.`a.b`
> Alias(AttributeReference("a", IntegerType)(), "b.c")(qualifier =
> "d.e"::Nil).sql
> `a` AS d.e.`b.c` // should be `a` AS `d.e`.`b.c`
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
