Bug #100764 | Rename Table causes other SQL execution plans to change. | ||
---|---|---|---|
Submitted: | 8 Sep 2020 8:50 | Modified: | 15 Oct 2020 13:08 |
Reporter: | kfpanda kf | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server: Optimizer | Severity: | S1 (Critical) |
Version: | 8.0 | OS: | Any |
Assigned to: | MySQL Verification Team | CPU Architecture: | Any |
[8 Sep 2020 8:50]
kfpanda kf
[8 Sep 2020 9:13]
kfpanda kf
Version: 8.0.18
[15 Sep 2020 13:08]
MySQL Verification Team
Hello kfpanda kf, Thank you for the report and mtr test case. I'm not seeing the reported issue with provided instruction i.e ran provided mtr test case with --record option with below line commented out: #alter table t1 rename to db1.t17; #alter table t2 rename to db1.t18; In the second run, uncommented above statements and commented: #drop table t1,t2; But seeing no issues: ./mtr distinct1 Logging: ./mtr distinct1 MySQL Version 8.0.18 Checking supported features Using 'all' suites Collecting tests Checking leftover processes Removing old var directory - WARNING: Using the 'mysql-test/var' symlink Creating var directory '/export/umesh/server/binaries/GABuilds/mysql-8.0.18/mysql-test/var' Installing system database Using parallel: 1 ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ [100%] main.distinct1 [ fail ] Test ended at 2020-09-15 14:54:35 CURRENT_TEST: main.distinct1 --- /export/umesh/server/binaries/GABuilds/mysql-8.0.18/mysql-test/r/distinct1.result 2020-09-15 15:54:01.549452461 +0300 +++ /export/umesh/server/binaries/GABuilds/mysql-8.0.18/mysql-test/var/log/distinct1.reject 2020-09-15 15:54:35.402235177 +0300 @@ -27,7 +27,8 @@ test2@testdomain.com Z001 test2@testdomain.com R002 test3@testdomain.com Z001 -drop table t1,t2; +alter table t1 rename to db1.t17; +alter table t2 rename to db1.t18; SET sql_mode = default; CREATE TABLE t1(a INT PRIMARY KEY, b INT); INSERT INTO t1 VALUES (1,1), (2,1), (3,1); mysqltest: Result content mismatch safe_process[23251]: Child process: 23252, exit: 1 In both the cases I'm seeing: EXPLAIN SELECT a FROM t1 GROUP BY a; id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t1 NULL index PRIMARY PRIMARY 4 NULL 3 100.00 Using index Could you please confirm if anything I'm missing here? Thank you! regards, Umesh
[16 Oct 2020 1:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".