Details
- 
    Bug 
- 
    Status: Closed (View Workflow)
- 
    Major 
- 
    Resolution: Fixed
- 
    10.2.24
Description
| ... | 
| CREATE TEMPORARY TABLE t1 (col1 BIGINT NULL) ENGINE = InnoDB; | 
| INSERT INTO t1 ( k ) SELECT id FROM t1 ; | 
| ERROR 42S22: Unknown column 'id' in 'field list' | 
| TRUNCATE TABLE t1 ; | 
| ALTER TABLE t1 CHANGE COLUMN id col2 BIGINT NULL; | 
| ERROR 42S22: Unknown column 'id' in 't1' | 
| TRUNCATE TABLE t1 ; | 
| main.ml_19 'innodb'                      [ fail ] | 
|         Test ended at 2019-05-13 13:56:45 | 
|  | 
| CURRENT_TEST: main.ml_19 | 
| mysqltest: At line 10: query 'TRUNCATE TABLE t1 ' failed: 1030: Got error 168 "Unknown (generic) error from engine" from storage engine InnoDB | 
|  | 
| 10.2.25 commit 8ce702aa90c174566f4ac950e85cc7570bf9b647 | 
| 10.2.24 commit b30bbb7d9a1c3855c901b74735660e49ab64a2a8 2019-03-25 | 
|  | 
| No issue in | 
| 10.3.15 commit 0c188d5efc452b576c46270e65b9db4746ee9dfe (pull 2019-05-13)
 | 
Attachments
Issue Links
- is caused by
- 
                    MDEV-13564 TRUNCATE TABLE and undo tablespace truncation are not compatible with Mariabackup -         
- Closed
 
-         
- relates to
- 
                    MDEV-17167 InnoDB: Failing assertion: table->get_ref_count() == 0 upon truncating a temporary table -         
- Closed
 
-