|
1548.4.67
by Zimin
add test case 'basic update' for filesystem storage engine |
1 |
--disable_warnings
|
2 |
DROP TABLE IF EXISTS t1; |
|
3 |
--enable_warnings
|
|
4 |
||
|
1786.3.2
by Monty Taylor
Cleaned up the initial pass at this. It's not perfect, but it does work. |
5 |
CREATE TABLE t1 (a INT, b VARCHAR(20)) ENGINE=FILESYSTEM,FILE="../../filesystem_ln/basic_update.data"; |
|
1548.4.67
by Zimin
add test case 'basic update' for filesystem storage engine |
6 |
|
7 |
INSERT INTO t1 VALUES (222, "bbb"); |
|
8 |
INSERT INTO t1 VALUES (333, "ccc"); |
|
9 |
INSERT INTO t1 VALUES (444, "ddd"); |
|
10 |
||
11 |
UPDATE t1 SET a=999 WHERE a=444; |
|
12 |
UPDATE t1 SET b="zzz" WHERE a=222; |
|
13 |
||
14 |
SELECT * FROM t1; |
|
15 |
||
16 |
DELETE FROM t1 WHERE a!=111; |
|
17 |
||
18 |
DROP TABLE t1; |