Unexpected Result by NATURAL RIGHT JOIN #49108
Labels
fuzz/sqlancer
may-affects-5.4
This bug maybe affects 5.4.x versions.
may-affects-6.1
may-affects-6.5
may-affects-7.1
may-affects-7.5
may-affects-8.1
severity/major
sig/execution
SIG execution
type/bug
The issue is confirmed as a bug.
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: