Details
Description
The test case is
create temporary table t1(a int);
|
insert into t1 values (1),(2),(3);
|
|
set use_stat_tables=preferably;
|
set optimizer_use_condition_selectivity=4;
|
|
select * from t1 where a >= 2;
|
drop table t1;
|
For temporary table we do not allocate statistics and should not read it
Attachments
Issue Links
- relates to
-
MDEV-17605 Statistics for InnoDB table is wrong if persistent statistics is used
-
- Closed
-
-
MDEV-19407 Assertion `field->table->stats_is_read' failed in is_eits_usable
-
- Closed
-
Activity
Transition | Time In Source Status | Execution Times |
---|
|
1h 7m | 1 |
|
3h 12m | 1 |
|
17h 17m | 1 |
|
22h 50m | 1 |