maropu commented on a change in pull request #31613:
URL: https://github.com/apache/spark/pull/31613#discussion_r581473182
##########
File path: sql/core/src/test/resources/sql-tests/results/postgreSQL/join.sql.out
##########
@@ -3225,7 +3225,7 @@ select * from
struct<>
-- !query output
org.apache.spark.sql.AnalysisException
-Reference 'f1' is ambiguous, could be: j.f1, j.f1.; line 2 pos 63
+Reference 'f1' is ambiguous, could be: j.f1#x, j.f1#x.; line 2 pos 63
Review comment:
I have the same feeling with @cloud-fan. I think the other databases
show a message message with the same granularity in the case, e.g.,
```
postgres=# create table t1 (id int);
CREATE TABLE
postgres=# create table t2 (id int);
CREATE TABLE
postgres=# select * from t1, t2 where id = id;
ERROR: column reference "id" is ambiguous
LINE 1: select * from t1, t2 where id = id;
```
----------------------------------------------------------------
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
