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
Please answer these questions before submitting your issue. Thanks!
create table t1(a int primary key, b int, c int, key(b), key(c)); explain select /*+ use_index_merge(t1) */ * from t1 where c=10 or (b=10 and a=10);
execute successfully
MySQL root@127.0.0.1:test> explain select /*+ use_index_merge(t1) */ * from t1 where c=10 or (b=10 and a=10); (1105, "Can't find column test.t1.b in schema Column: [test.t1.a] Unique key: []")
MySQL root@127.0.0.1:test> select tidb_version()\G ***************************[ 1. row ]*************************** tidb_version() | Release Version: v5.1.0-alpha-87-g0158f71cd Edition: Community Git Commit Hash: 0158f71cda6ccbbd382c6e8759904234baca259c Git Branch: HEAD UTC Build Time: 2021-06-01 11:51:39 GoVersion: go1.16.4 Race Enabled: false TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306 Check Table Before Drop: false
The text was updated successfully, but these errors were encountered:
/assign
Sorry, something went wrong.
Note: Make Sure that 'component', and 'severity' labels are added Example for how to fill out the template: #20100
@zhuo-zhi ,please check pick 5.0
zhuo-zhi
Successfully merging a pull request may close this issue.
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
2. What did you expect to see? (Required)
execute successfully
3. What did you see instead (Required)
4. What is your TiDB version? (Required)
The text was updated successfully, but these errors were encountered: