suyZhong opened a new issue, #11019: URL: https://github.com/apache/ignite/issues/11019
The second `SELECT` returns an empty result, which is surprising, given that the first query, which has the same `WHERE` clause, returns `2` as a result. The only difference between them is that the second query also references `t1`, which should not cause any rows to be omitted. ```sql CREATE TABLE t0(c0 INT, c1 INT, PRIMARY KEY(c0)); CREATE TABLE t1(c0 INT, c1 INT, PRIMARY KEY(c0)); INSERT INTO t0(c0, c1) VALUES (2, NULL); INSERT INTO t1(c0, c1) VALUES (1, 2); SELECT t0.c0 FROM t0 WHERE t0.c0=2; -- 2 SELECT t0.c0 FROM t0,t1 WHERE t0.c0=2; -- empty ``` Environment: Version: 2.15.0 docker image: 43c9273e8568 Client: sqlline in docker. -- 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]
