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

tokudb.bugs.5733_tokudb 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 46 47 48 49 tokudb.bugs.5733_tokudb w8 [ fail ] Test ended at 2017-04-21 12:37:10 CURRENT_TEST: tokudb.bugs.5733_tokudb --- /ssd/percona/myrocks/percona-server-install-5.7/mysql-test/suite/tokudb.bugs/r/5733_tokudb.result 2017-03-16 20:03:22.000000000 +0300 +++ /ssd/percona/myrocks/percona-server-install-5.7/mysql-test/var/8/log/5733_tokudb.reject 2017-04-21 22:37:10.537917502 +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 range_or_index range PRIMARY PRIMARY 8 # 9999 100.00 Using where; Using index +1 SIMPLE t range_or_index range PRIMARY PRIMARY 8 # 9488 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 # 9999 100.00 Using where +1 SIMPLE t NULL range PRIMARY PRIMARY 8 # 9488 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 # 8999 100.00 Using where; Using index +1 SIMPLE t NULL range PRIMARY PRIMARY 8 # 8488 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 # 8999 100.00 Using where +1 SIMPLE t NULL range PRIMARY PRIMARY 8 # 8488 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 # 4999 100.00 Using where; Using index +1 SIMPLE t NULL range PRIMARY PRIMARY 8 # 2955 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 # 4999 100.00 Using where +1 SIMPLE t NULL range PRIMARY PRIMARY 8 # 2955 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; mysqltest: Result content mismatch safe_process[13609]: Child process: 13610, exit: 1

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