yaooqinn commented on a change in pull request #24947: [SPARK-28143][SQL]IN
expression missing attribute should throw analysis exception
URL: https://github.com/apache/spark/pull/24947#discussion_r296982229
##########
File path: sql/core/src/test/scala/org/apache/spark/sql/SQLQuerySuite.scala
##########
@@ -106,6 +106,12 @@ class SQLQuerySuite extends QueryTest with
SharedSQLContext {
checkKeywordsExist(sql("describe functioN abcadf"), "Function: abcadf not
found.")
}
+ test("SPARK-28143: IN expression missing attribute should throw analysis
exception") {
+ val query = "select 1 from where in ()"
Review comment:
It is kinda weird, I use this query just because it is simple.
a real world wrong query maybe like this
```sql
select dt, os, userid, usertype
from tbl1
where dt=date_sub('2019-06-30',1)
and source='client'
and in ('iphone','android') --- here
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
