Bug #109820 | optimizer hints in definition of views seem to be ignored | ||
---|---|---|---|
Submitted: | 27 Jan 2023 8:54 | Modified: | 27 Jan 2023 10:11 |
Reporter: | Brian Yue (OCA) | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Optimizer | Severity: | S3 (Non-critical) |
Version: | 8.0.29, 8.0.32 | OS: | Any (rhel-7.4) |
Assigned to: | CPU Architecture: | Any (x86-64) | |
Tags: | Optimizer hints, VIEW |
[27 Jan 2023 8:54]
Brian Yue
[27 Jan 2023 10:11]
MySQL Verification Team
Hello Brian Yue, Thank you for the report and feedback. regards, Umesh
[28 Jan 2023 12:55]
huahua xu
Hi Brian Yue, This may be helpful for you: mysql> create ALGORITHM = TEMPTABLE view v_1 as select * from (select *from t1) dt; mysql> explain select * from v_1; +----+-------------+------------+------------+------+---------------+------+---------+------+------+----------+-------+ | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra | +----+-------------+------------+------------+------+---------------+------+---------+------+------+----------+-------+ | 1 | PRIMARY | <derived2> | NULL | ALL | NULL | NULL | NULL | NULL | 2 | 100.00 | NULL | | 2 | DERIVED | t1 | NULL | ALL | NULL | NULL | NULL | NULL | 2 | 100.00 | NULL | +----+-------------+------------+------------+------+---------------+------+---------+------+------+----------+-------+