xiedeyantu commented on code in PR #4724: URL: https://github.com/apache/calcite/pull/4724#discussion_r2711097407
########## 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: I tried searching, but we found a dataset that matched Jira, even though the `hr` database has an emps table, the dataset is different. So I constructed one according to Jira's description. -- 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]
