|
1548.4.8
by Zimin
add test case for filesystem storage engine |
1 |
#
|
2 |
# test filesystem plugin |
|
3 |
#
|
|
4 |
||
5 |
--disable_warnings
|
|
6 |
drop table if exists t1; |
|
7 |
--enable_warnings
|
|
8 |
||
9 |
CREATE TABLE t1 (a int, b VARCHAR(20)) ENGINE=FILESYSTEM,FILE="../../../plugin/filesystem/tests/t/fs.txt"; |
|
10 |
||
|
1548.4.10
by Zimin
add more test cases |
11 |
SELECT * FROM t1; |
12 |
||
13 |
# test INSERT |
|
14 |
INSERT INTO t1 VALUES (222, "bbb"); |
|
15 |
INSERT INTO t1 VALUES (333, "ccc"); |
|
16 |
INSERT INTO t1 VALUES (444, "ddd"); |
|
17 |
INSERT INTO t1 VALUES (555, "eee"); |
|
18 |
INSERT INTO t1 VALUES (666, "fff"); |
|
19 |
||
20 |
SELECT * FROM t1; |
|
21 |
||
22 |
# test DELETE |
|
23 |
DELETE FROM t1 WHERE a = 444; |
|
24 |
DELETE FROM t1 WHERE a = 111; |
|
25 |
||
26 |
SELECT * FROM t1; |
|
27 |
||
28 |
# test UPDATE |
|
29 |
UPDATE t1 SET a = 777 WHERE b = "ccc"; |
|
30 |
UPDATE t1 SET b = "zzz" WHERE a = 555; |
|
31 |
||
32 |
SELECT * FROM t1; |
|
33 |
||
34 |
DELETE FROM t1 WHERE b != "zzz"; |
|
35 |
SELECT * FROM t1; |
|
36 |
||
37 |
UPDATE t1 SET a = 111 WHERE b = "zzz"; |
|
38 |
UPDATE t1 SET b = "aaa" WHERE b = "zzz"; |
|
39 |
||
40 |
# back to the original, so we can execute more than once |
|
41 |
SELECT * FROM t1; |