Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0(EOL), 10.1(EOL)
-
None
Description
set use_stat_tables='preferably';
|
set optimizer_use_condition_selectivity=3;
|
|
|
create table t1(col1 text);
|
|
|
insert into t1 values ('a'),('b'),('c'),('d');
|
analyze table t1;
|
|
|
select * from t1 where col1 > 'b' and col1 < 'd';
|
|
|
drop table t1;
|
|
Actual result |
MariaDB [test]> select * from t1 where col1 > 'b' and col1 < 'd';
|
Empty set (0.90 sec)
|
|
Plan |
MariaDB [test]> explain extended select * from t1 where col1 > 'b' and col1 < 'd';
|
+------+-------------+-------+------+---------------+------+---------+------+------+----------+-----------------------------------------------------+
|
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|
+------+-------------+-------+------+---------------+------+---------+------+------+----------+-----------------------------------------------------+
|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
|
+------+-------------+-------+------+---------------+------+---------+------+------+----------+-----------------------------------------------------+
|
1 row in set, 1 warning (1.29 sec)
|
|
|
MariaDB [test]> show warnings;
|
+-------+------+--------------------------------------------------------------+
|
| Level | Code | Message |
|
+-------+------+--------------------------------------------------------------+
|
| Note | 1003 | select `test`.`t1`.`col1` AS `col1` from `test`.`t1` where 0 |
|
+-------+------+--------------------------------------------------------------+
|
1 row in set (0.00 sec)
|
|
Expected result |
MariaDB [test]> select * from t1 where col1 > 'b' and col1 < 'd';
|
+------+
|
| col1 |
|
+------+
|
| c |
|
+------+
|
1 row in set (4.71 sec)
|