We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Consider the following test case. It is unexpected that the second query return 0, since the first query without WHERE condition has a result NULL.
0
WHERE
NULL
No response
CREATE TABLE t0(c0 INT, c1 INT, c2 INT, PRIMARY KEY(c0)); CREATE TABLE t1(c0 INT, c1 INT, PRIMARY KEY(c0)); INSERT INTO t0(c0, c1, c2) VALUES (1, 1, 1); INSERT INTO t1(c0) VALUES (2); SELECT c2 FROM t1 NATURAL LEFT JOIN t0; -- NULL SELECT c2 FROM t1 NATURAL LEFT JOIN t0 WHERE (c1 IS NULL); -- 0
I expected the second query to also return the same as the first one.
via Docker image and online playground
dev=> SELECT version(); version ---------------------------------------------------------------------------------- PostgreSQL 9.5-RisingWave-1.3.0-alpha (4313a5a8fe3a11a0edaa3ff8f4fdb639123be618)
The text was updated successfully, but these errors were encountered:
chenzl25
Successfully merging a pull request may close this issue.
Describe the bug
Consider the following test case. It is unexpected that the second query return
0
, since the first query withoutWHERE
condition has a resultNULL
.Error message/log
No response
To Reproduce
Expected behavior
I expected the second query to also return the same as the first one.
How did you deploy RisingWave?
via Docker image and online playground
The version of RisingWave
Additional context
No response
The text was updated successfully, but these errors were encountered: