|
1085.2.1
by Stewart Smith
Fix BUG lp:387627: UPDATE can be TRUNCATE on TEMPORARY TABLE. Some special case code in MyISAM for 'if temporary table' was making (the included) test case fail. Root cause of what we've messed up in MyISAM was not found (after much investigation). |
1 |
create temporary table t1 (col1 int not null, col2 char(4) not null, primary key(col1)) engine=memory;
|
2 |
alter table t1 engine=myisam;
|
|
3 |
insert into t1 values (1,1),(5,2),(2,3),(3,4),(4,4);
|
|
4 |
select * from t1;
|
|
5 |
col1 col2
|
|
6 |
1 1
|
|
7 |
5 2
|
|
8 |
2 3
|
|
9 |
3 4
|
|
10 |
4 4
|
|
11 |
update t1 set col2='7' where col1='4';
|
|
12 |
select * from t1;
|
|
13 |
col1 col2
|
|
14 |
1 1
|
|
15 |
5 2
|
|
16 |
2 3
|
|
17 |
3 4
|
|
18 |
4 7
|
|
19 |
DROP TABLE t1;
|