main.range 'innodb' w4 [ fail ]
|
Test ended at 2018-08-21 20:32:18
|
|
CURRENT_TEST: main.range
|
mysqltest: At line 873: query 'set in_predicate_conversion_threshold= 2000' failed: 1193: Unknown system variable 'in_predicate_conversion_threshold'
|
|
The result from queries just before the failure was:
|
< snip >
|
1 SIMPLE t1 range a a 13 NULL # Using index condition; Using where
|
explain select * from t2 where a between 'a' and 'a ';
|
id select_type table type possible_keys key key_len ref rows Extra
|
1 SIMPLE t2 ref a a 13 const # Using index condition
|
explain select * from t2 where a = 'a' or a='a ';
|
id select_type table type possible_keys key key_len ref rows Extra
|
1 SIMPLE t2 ref a a 13 const # Using index condition; Using where
|
update t1 set a='b' where a<>'a';
|
explain select * from t1 where a not between 'b' and 'b';
|
id select_type table type possible_keys key key_len ref rows Extra
|
1 SIMPLE t1 range a a 13 NULL # Using index condition
|
select a, hex(filler) from t1 where a not between 'b' and 'b';
|
a hex(filler)
|
a 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
|
drop table t1,t2,t3;
|
create table t1 (a int);
|
insert into t1 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
|
create table t2 (a int, key(a));
|
insert into t2 select 2*(A.a + 10*(B.a + 10*C.a)) from t1 A, t1 B, t1 C;
|
set in_predicate_conversion_threshold= 2000;
|
|
More results from queries before failure can be found in /home/travis/build/MariaDB/server/mysql-test/var/4/log/range.log
|
|
- saving '/home/travis/build/MariaDB/server/mysql-test/var/4/log/main.range-innodb/' to '/home/travis/build/MariaDB/server/mysql-test/var/log/main.range-innodb/'
|
main.join_outer_jcl6 w1 [ pass ] 9035
|
main.1st w1 [ pass ] 1
|
main.multi_update2 w2 [ pass ] 24053
|
main.aborted_clients w1 [ pass ] 107
|
main.range_innodb 'innodb' w4 [ pass ] 351
|
main.adddate_454 w1 [ pass ] 5
|
main.flush w3 [ pass ] 2929
|
main.alias w1 [ pass ] 27
|
main.almost_full w1 [ pass ] 42
|
main.range_mrr_icp 'innodb' w4 [ fail ]
|
Test ended at 2018-08-21 20:32:19
|
|
CURRENT_TEST: main.range_mrr_icp
|
mysqltest: In included file "/home/travis/build/MariaDB/server/mysql-test/main/range.test":
|
included from /home/travis/build/MariaDB/server/mysql-test/main/range_mrr_icp.test at line 5:
|
At line 873: query 'set in_predicate_conversion_threshold= 2000' failed: 1193: Unknown system variable 'in_predicate_conversion_threshold'
|
|
The result from queries just before the failure was:
|
< snip >
|
1 SIMPLE t1 range a a 13 NULL # Using index condition; Using where; Rowid-ordered scan
|
explain select * from t2 where a between 'a' and 'a ';
|
id select_type table type possible_keys key key_len ref rows Extra
|
1 SIMPLE t2 ref a a 13 const # Using index condition
|
explain select * from t2 where a = 'a' or a='a ';
|
id select_type table type possible_keys key key_len ref rows Extra
|
1 SIMPLE t2 ref a a 13 const # Using index condition; Using where
|
update t1 set a='b' where a<>'a';
|
explain select * from t1 where a not between 'b' and 'b';
|
id select_type table type possible_keys key key_len ref rows Extra
|
1 SIMPLE t1 range a a 13 NULL # Using index condition; Rowid-ordered scan
|
select a, hex(filler) from t1 where a not between 'b' and 'b';
|
a hex(filler)
|
a 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
|
drop table t1,t2,t3;
|
create table t1 (a int);
|
insert into t1 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
|
create table t2 (a int, key(a));
|
insert into t2 select 2*(A.a + 10*(B.a + 10*C.a)) from t1 A, t1 B, t1 C;
|
set in_predicate_conversion_threshold= 2000;
|
|
More results from queries before failure can be found in /home/travis/build/MariaDB/server/mysql-test/var/4/log/range_mrr_icp.log
|
|
- saving '/home/travis/build/MariaDB/server/mysql-test/var/4/log/main.range_mrr_icp-innodb/' to '/home/travis/build/MariaDB/server/mysql-test/var/log/main.range_mrr_icp-innodb/'
|