You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The expression t0.c0 = (t1.c0 NOT LIKE FALSE) is evaluated to NULL for the first query, but returns non-empty result for the second query.
1. Minimal reproduce step (Required)
CREATETABLEt0(c0 INT);
CREATETABLEt1(c0 FLOAT);
INSERT IGNORE INTO t0(c0) VALUES (1);
INSERT INTO t1 VALUES (2);
CREATEVIEWv1(c0) ASSELECT'a'FROM t1;
SELECTt0.c0= (t1.c0 NOT LIKE FALSE) FROM t1, t0 NATURAL RIGHT JOIN v1; -- {NULL}SELECT*FROM t1, t0 NATURAL RIGHT JOIN v1 WHEREt0.c0= (t1.c0 NOT LIKE FALSE); -- {NULL|a}
Bug Report
The expression
t0.c0 = (t1.c0 NOT LIKE FALSE)
is evaluated toNULL
for the first query, but returns non-empty result for the second query.1. Minimal reproduce step (Required)
2. What did you expect to see? (Required)
3. What did you see instead (Required)
4. What is your TiDB version? (Required)
The text was updated successfully, but these errors were encountered: