You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@ignite.apache.org by "suyZhong (via GitHub)" <gi...@apache.org> on 2023/10/27 04:28:49 UTC
[I] Unexpected result when using SQL API [ignite]
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: notifications-unsubscribe@ignite.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Unexpected result when using SQL [ignite]
Posted by "suyZhong (via GitHub)" <gi...@apache.org>.
suyZhong commented on issue #11019:
URL: https://github.com/apache/ignite/issues/11019#issuecomment-1785131919
Got it! Thanks a lot for pointing that out with the related documentation. I've reviewed it and now understand that this is the expected behavior.
--
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: notifications-unsubscribe@ignite.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Unexpected result when using SQL [ignite]
Posted by "suyZhong (via GitHub)" <gi...@apache.org>.
suyZhong closed issue #11019: Unexpected result when using SQL
URL: https://github.com/apache/ignite/issues/11019
--
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: notifications-unsubscribe@ignite.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Unexpected result when using SQL [ignite]
Posted by "zstan (via GitHub)" <gi...@apache.org>.
zstan commented on issue #11019:
URL: https://github.com/apache/ignite/issues/11019#issuecomment-1784581979
@suyZhong this is (surprise)) ) non collocated join, thus it works correctly, read appropriate documentation
https://ignite.apache.org/docs/latest/SQL/distributed-joins
--
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: notifications-unsubscribe@ignite.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org