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
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
drop table if exists t1;
create table t1(c1 int, c2 int, c3 int as (c1 + c2), key(c1), key(c2), key(c3));
insert into t1(c1, c2) values(1, 1);
select /*+ use_index_merge(t1) */ * from t1 where c1 < -10 or c2 < 10 and reverse(c3) = '2';
2. What did you expect to see? (Required)
mysql> select * from t1 where c1 < -10 or c2 < 10 and reverse(c3) = '2';
+------+------+------+
| c1 | c2 | c3 |
+------+------+------+
| 1 | 1 | 2 |
+------+------+------+
1 row in set (0.01 sec)
3. What did you see instead (Required)
mysql> select /*+ use_index_merge(t1) */ * from t1 where c1 < -10 or c2 < 10 and reverse(c3) = '2';
Empty set (0.01 sec)
Bug Report
Please answer these questions before submitting your issue. Thanks!
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: