view's don't have index, SELECT ... FROM <view> USE INDEX (...) should result error

[ramanich1]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

drop table if exists t1;
drop view if exists v1,v2;
CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 INT, INDEX (c2));
INSERT INTO t1 VALUES (1,1), (2,2), (3,3);
CREATE VIEW v1 AS SELECT c1, c2 FROM t1;
SELECT * FROM v1 USE INDEX (PRIMARY) WHERE c1=2;
SHOW INDEX FROM v1;

2. What did you expect to see? (Required)

mysql> SELECT * FROM v1 USE INDEX (PRIMARY) WHERE c1=2;
ERROR 1176 (42000): Key 'PRIMARY' doesn't exist in table 'v1'
mysql> SHOW INDEX FROM v1;
Empty set (0.01 sec)

3. What did you see instead (Required)

mysql> SELECT * FROM v1 USE INDEX (PRIMARY) WHERE c1=2;
+----+------+
| c1 | c2   |
+----+------+
|  2 |    2 |
+----+------+
1 row in set (0.00 sec)

mysql> SHOW INDEX FROM v1;
Empty set (0.00 sec)

4. What is your TiDB version? (Required)

| Release Version: v5.5.0-alpha-182-gad9430039
Edition: Community
Git Commit Hash: ad9430039f54bb9af78d44831c176bc5eafcbba0
Git Branch: master
UTC Build Time: 2022-02-18 17:57:13
GoVersion: go1.17.2
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false |

[winoros]

It's a very simple problem. We downgrade the severity.

[fanrenhoo]

/assign