xiedeyantu commented on code in PR #4724: URL: https://github.com/apache/calcite/pull/4724#discussion_r2714892205
########## core/src/test/resources/sql/blank.iq: ########## @@ -233,4 +233,106 @@ from complex_t; !ok +# [CALCITE-4765] Complex correlated EXISTS sub-queries used as scalar subqueries can return wrong results +CREATE TABLE emps ( + empid INTEGER NOT NULL, + deptno INTEGER NOT NULL, + name VARCHAR(10) NOT NULL, + salary DECIMAL(10, 2) NOT NULL, + commission INTEGER); +(0 rows modified) + +!update +INSERT INTO emps (empid, deptno, name, salary, commission) VALUES Review Comment: It's very likely that this will work in JdbcTest, but I'm not sure if adding test cases in JdbcTest is still recommended. So I haven't checked this. -- 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]
