Skip to content
New issue

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

Hint to read from tiflash doesn't work when the query is a PointGet #16909

Open
lidezhu opened this issue Apr 28, 2020 · 1 comment
Open

Hint to read from tiflash doesn't work when the query is a PointGet #16909

lidezhu opened this issue Apr 28, 2020 · 1 comment
Assignees
Labels
severity/moderate sig/planner SIG: Planner type/bug The issue is confirmed as a bug.

Comments

@lidezhu
Copy link
Contributor

lidezhu commented Apr 28, 2020

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. What did you do?

create table if not exists test.t(col_1 varchar(256), col_2 int not null primary key);
insert into test.t(col_1, col_2) values('test1', 555), ('test2', 666), ('test3', 777);
analyze table test.t;
explain select /*+ read_from_storage(tiflash[test.t]) */ * from t where col_2=555;

2. What did you expect to see?

The query is send to tiflash.

3. What did you see instead?

+-------------+---------+------+-------------------------------+---------------+
| id          | estRows | task | access object                 | operator info |
+-------------+---------+------+-------------------------------+---------------+
| Point_Get_1 | 1.00    | root | table:t, index:PRIMARY(col_2) |               |
+-------------+---------+------+-------------------------------+---------------+

4. What version of TiDB are you using? (tidb-server -V or run select tidb_version(); on TiDB)

Release Version: v4.0.0-beta.2-352-g5ede18f10
Git Commit Hash: 5ede18f
Git Branch: master
UTC Build Time: 2020-04-24 03:45:17
GoVersion: go1.13
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false

@lidezhu lidezhu added the type/bug The issue is confirmed as a bug. label Apr 28, 2020
@lidezhu lidezhu changed the title Hint to read from tiflash doesn't work when the query is a point get Hint to read from tiflash doesn't work when the query is a PointGet Apr 28, 2020
@lzmhhh123 lzmhhh123 added the sig/planner SIG: Planner label Apr 28, 2020
@lzmhhh123 lzmhhh123 self-assigned this Apr 28, 2020
@yudongusa
Copy link

@lzmhhh123 any update on this issue?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
severity/moderate sig/planner SIG: Planner type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants