innodb.temporary_table_optimization 'innodb' w4 [ fail ]
|
Test ended at 2019-09-07 12:42:16
|
|
CURRENT_TEST: innodb.temporary_table_optimization
|
--- /usr/share/mysql-test/suite/innodb/r/temporary_table_optimization.result 2019-09-07 09:08:24.000000000 +0000
|
+++ /dev/shm/var/4/log/temporary_table_optimization.reject 2019-09-07 12:42:15.958074599 +0000
|
@@ -128,11 +128,9 @@
|
alter table t1 add index sec_index(t1_f);
|
explain select * from t1 where t1_f > 2.2;
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE t1 ALL sec_index NULL NULL NULL 4 Using where
|
+1 SIMPLE t1 range sec_index sec_index 5 NULL 1 Using index condition
|
select * from t1 where t1_f > 2.2;
|
t1_i t1_f
|
-2 2.2
|
-3 2.2
|
4 4.4
|
alter table t1 add column (t1_c char(10));
|
select * from t1;
|
|
mysqltest: Result length mismatch
|