We're updating the issue view to help you get more done. 

tokudb.bugs.5733_innodb unstable

Description

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 tokudb.bugs.5733_innodb w4 [ fail ] Test ended at 2017-04-21 12:37:15 CURRENT_TEST: tokudb.bugs.5733_innodb --- /ssd/percona/myrocks/percona-server-install-5.7/mysql-test/suite/tokudb.bugs/r/5733_innodb.result 2017-03-16 20:03:22.000000000 +0300 +++ /ssd/percona/myrocks/percona-server-install-5.7/mysql-test/var/4/log/5733_innodb.reject 2017-04-21 22:37:15.457917652 +0300 @@ -10003,32 +10003,32 @@ insert into t values (9999,0); explain select id from t where id>0 limit 10; id select_type table partitions type possible_keys key key_len ref rows filtered Extra -1 SIMPLE t NULL range PRIMARY PRIMARY 8 # 5000 100.00 Using where; Using index +1 SIMPLE t NULL range PRIMARY PRIMARY 8 # 5036 100.00 Using where; Using index Warnings: Note 1003 /* select#1 */ select `test`.`t`.`id` AS `id` from `test`.`t` where (`test`.`t`.`id` > 0) limit 10 explain select * from t where id>0 limit 10; id select_type table partitions type possible_keys key key_len ref rows filtered Extra -1 SIMPLE t NULL range PRIMARY PRIMARY 8 # 5000 100.00 Using where +1 SIMPLE t NULL range PRIMARY PRIMARY 8 # 5036 100.00 Using where Warnings: Note 1003 /* select#1 */ select `test`.`t`.`id` AS `id`,`test`.`t`.`x` AS `x` from `test`.`t` where (`test`.`t`.`id` > 0) limit 10 explain select id from t where id>1000 limit 10; id select_type table partitions type possible_keys key key_len ref rows filtered Extra -1 SIMPLE t NULL range PRIMARY PRIMARY 8 # 5000 100.00 Using where; Using index +1 SIMPLE t NULL range PRIMARY PRIMARY 8 # 5036 100.00 Using where; Using index Warnings: Note 1003 /* select#1 */ select `test`.`t`.`id` AS `id` from `test`.`t` where (`test`.`t`.`id` > 1000) limit 10 explain select * from t where id>1000 limit 10; id select_type table partitions type possible_keys key key_len ref rows filtered Extra -1 SIMPLE t NULL range PRIMARY PRIMARY 8 # 5000 100.00 Using where +1 SIMPLE t NULL range PRIMARY PRIMARY 8 # 5036 100.00 Using where Warnings: Note 1003 /* select#1 */ select `test`.`t`.`id` AS `id`,`test`.`t`.`x` AS `x` from `test`.`t` where (`test`.`t`.`id` > 1000) limit 10 explain select id from t where id>5000 limit 10; id select_type table partitions type possible_keys key key_len ref rows filtered Extra -1 SIMPLE t NULL range PRIMARY PRIMARY 8 # 5000 100.00 Using where; Using index +1 SIMPLE t NULL range PRIMARY PRIMARY 8 # 5036 100.00 Using where; Using index Warnings: Note 1003 /* select#1 */ select `test`.`t`.`id` AS `id` from `test`.`t` where (`test`.`t`.`id` > 5000) limit 10 explain select * from t where id>5000 limit 10; id select_type table partitions type possible_keys key key_len ref rows filtered Extra -1 SIMPLE t NULL range PRIMARY PRIMARY 8 # 5000 100.00 Using where +1 SIMPLE t NULL range PRIMARY PRIMARY 8 # 5036 100.00 Using where Warnings: Note 1003 /* select#1 */ select `test`.`t`.`id` AS `id`,`test`.`t`.`x` AS `x` from `test`.`t` where (`test`.`t`.`id` > 5000) limit 10 explain select id from t where id>6000 limit 10;

Environment

None

Status

Assignee

Unassigned

Reporter

George Lorch

Labels

None

External issue ID

None

External issue ID

None

External issue ID

None

External issue ID

None

External issue ID

None

External issue ID

None

External issue ID

None

External issue ID

None

External issue ID

None

Freshdesk Tickets

None

Affects versions

Percona-Server-5.7.17-13

Priority

Major