No way to limit temporary table size when maria tables are in use
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Confirmed
|
Wishlist
|
Sergey Petrunia |
Bug Description
I've hit this while merging this testcase from mysql-5.
CREATE TABLE t1(a INT);
# To force MyISAM temp. table in the following INSERT ... SELECT.
SET max_heap_table_size = 16384;
# To overflow the temp. table.
SET @old_myisam_
SET GLOBAL myisam_
INSERT INTO t1 VALUES (1), (2), (3), (4), (5);
--error ER_RECORD_
INSERT IGNORE INTO t1 SELECT t1.a FROM t1,t1 t2,t1 t3,t1 t4,t1 t5,t1 t6,t1 t7;
The problems are that
- Maria engine doesn't have an analog of myisam_
- Albeit there is a #define USE_MARIA_
tags: | added: 5.1 |
Changed in maria: | |
importance: | Undecided → High |
Changed in maria: | |
milestone: | none → 5.3 |
Changed in maria: | |
status: | In Progress → Confirmed |
Changed in maria: | |
importance: | Low → Wishlist |
Will add a server variable.