diff options
Diffstat (limited to 'mysql-test/suite/maria/icp.result')
| -rw-r--r-- | mysql-test/suite/maria/icp.result | 18 |
1 files changed, 17 insertions, 1 deletions
diff --git a/mysql-test/suite/maria/icp.result b/mysql-test/suite/maria/icp.result index feca63402a4..a8756a4a6f1 100644 --- a/mysql-test/suite/maria/icp.result +++ b/mysql-test/suite/maria/icp.result @@ -167,7 +167,7 @@ WHERE ts BETWEEN '0000-00-00' AND '2010-00-01 00:00:00' ORDER BY ts DESC LIMIT 2; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range PRIMARY PRIMARY 4 NULL 4 Using index condition +1 SIMPLE t1 range PRIMARY PRIMARY 4 NULL 4 Using where DROP TABLE t1; # @@ -841,5 +841,21 @@ Variable_name Value Handler_icp_attempts 2 Handler_icp_match 1 DROP TABLE t1; +create table t1 (a int,b char(5),primary key (a), key (b(1))); +insert into t1 values ('a','b'); +Warnings: +Warning 1366 Incorrect integer value: 'a' for column 'a' at row 1 +select 1 from t1 where a and b >= 'aa'; +1 +drop table t1; +# +# Bug#58015 "Assert in row_sel_field_store_in_mysql_format +# when running innodb_mrr_icp test" +# +create table t1 (a char(2) charset utf8,b double, primary key (a(1)),key (b)); +insert into t1 values ('',1); +select 1 from t1 where b <= 1 and a <> ''; +1 +drop table t1; set storage_engine= @save_storage_engine; set optimizer_switch=@maria_icp_tmp; |