~drizzle-trunk/drizzle/development

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
#
# test filesystem plugin
#

--disable_warnings
drop table if exists t1;
--enable_warnings

CREATE TABLE t1 (a int, b VARCHAR(20)) ENGINE=FILESYSTEM,FILE="../../../plugin/filesystem/tests/t/fs.txt";

SELECT * FROM t1;

# test INSERT
INSERT INTO t1 VALUES (222, "bbb");
INSERT INTO t1 VALUES (333, "ccc");
INSERT INTO t1 VALUES (444, "ddd");
INSERT INTO t1 VALUES (555, "eee");
INSERT INTO t1 VALUES (666, "fff");

SELECT * FROM t1;

# test DELETE
DELETE FROM t1 WHERE a = 444;
DELETE FROM t1 WHERE a = 111;

SELECT * FROM t1;

# test UPDATE
UPDATE t1 SET a = 777 WHERE b = "ccc";
UPDATE t1 SET b = "zzz" WHERE a = 555;

SELECT * FROM t1;

DELETE FROM t1 WHERE b != "zzz";
SELECT * FROM t1;

UPDATE t1 SET a = 111 WHERE b = "zzz";
UPDATE t1 SET b = "aaa" WHERE b = "zzz";

# back to the original, so we can execute more than once
SELECT * FROM t1;