Closed zz-jason closed 5 years ago
while I am working on it, I found another bug: PointGet does not check the table name in where clause.
mysql> create table t(k int not null primary key);
Query OK, 0 rows affected (0.01 sec)
mysql> insert into t values(1),(2),(3);
Query OK, 3 rows affected (0.01 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql> select * from t where xxxxxxx.k=1;
+---+
| k |
+---+
| 1 |
+---+
1 row in set (0.00 sec)
Feature Request
Is your feature request related to a problem? Please describe:
If the table has no alias name, it can be executed with
Point_Get
plan:But if we add an alias name for the queried table, it can not be executed by
Point_Get
plan:Describe the feature you'd like:
Be able to use point get plan even when the table has an alias name.
Describe alternatives you've considered:
No
Teachability, Documentation, Adoption, Migration Strategy:
No