zzwqqq commented on code in PR #4748:
URL: https://github.com/apache/calcite/pull/4748#discussion_r2702474483
##########
core/src/test/resources/sql/sub-query.iq:
##########
@@ -7649,4 +7649,90 @@ EnumerableCalc(expr#0..7=[{inputs}], EMPNO=[$t0])
!ok
+# [CALCITE-7378] Potential incorrect column attribution in RelToSqlConverter
due to implicit table alias handling
+!use blank
+CREATE TABLE a (
+ deptno INTEGER NOT NULL,
+ ename VARCHAR(10)
+);
+(0 rows modified)
+
+!update
+
+CREATE TABLE b (
+ deptno INTEGER NOT NULL,
+ ename VARCHAR(10)
+);
+(0 rows modified)
+
+!update
+
+INSERT INTO a VALUES
+ (10, 'ALLEN'),
+ (20, 'WARD'),
+ (30, 'WARD'),
+ (40, 'SMITH');
+(4 rows modified)
+
+!update
+
+INSERT INTO b VALUES
+ (20, 'WARD'),
+ (30, 'WARD'),
+ (30, 'ALLEN'),
+ (10, 'KING');
+(4 rows modified)
+
+!update
+
+SELECT deptno
+FROM b as b1
+WHERE deptno NOT IN (
+ SELECT deptno
+ FROM a
+ WHERE deptno = b1.deptno AND ename = 'WARD' AND b1.ename = 'WARD'
+);
++--------+
+| DEPTNO |
++--------+
+| 10 |
+| 30 |
++--------+
+(2 rows)
+
+!ok
+
+SELECT deptno
+FROM b as a
+WHERE deptno NOT IN (
+ SELECT deptno
+ FROM a
+ WHERE deptno = a.deptno AND ename = 'WARD' AND a.ename = 'WARD'
+);
++--------+
+| DEPTNO |
++--------+
+| 10 |
++--------+
+(1 row)
+
+!ok
+
+SELECT deptno
+FROM b as a
+WHERE deptno NOT IN (
+ SELECT deptno
+ FROM a as a2
+ WHERE deptno = a.deptno AND ename = 'WARD' AND a.ename = 'WARD'
+);
++--------+
+| DEPTNO |
++--------+
+| 10 |
+| 30 |
++--------+g
Review Comment:
I have deleted it. Thanks.
--
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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
