~clint-fewbar/drizzle/regex-policy-cache-limiter

« back to all changes in this revision

Viewing changes to plugin/filesystem_engine/tests/t/basic_insert.test

  • Committer: Clint Byrum
  • Date: 2012-03-15 18:05:43 UTC
  • mfrom: (2224.1.302 workspace)
  • Revision ID: clint@ubuntu.com-20120315180543-9jxxm4q10k3np2ws
merging with latest trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
 
--disable_warnings
2
 
DROP TABLE IF EXISTS t1;
3
 
--enable_warnings
4
 
 
5
 
--replace_result $DRIZZLETEST_VARDIR VARDIR
6
 
eval CREATE TABLE t1 (a INT, b VARCHAR(20)) ENGINE=FILESYSTEM,FILE="$DRIZZLETEST_VARDIR/filesystem_ln/basic_insert.data";
7
 
 
8
 
INSERT INTO t1 VALUES (222, "bbb");
9
 
INSERT INTO t1 VALUES (333, "ccc");
10
 
INSERT INTO t1 VALUES (444, "ddd");
11
 
INSERT INTO t1 VALUES (555, "eee");
12
 
INSERT INTO t1 VALUES (666, "fff");
13
 
 
14
 
SELECT * FROM t1;
15
 
 
16
 
DELETE FROM t1;
17
 
 
18
 
INSERT INTO t1 VALUES (111, "aaa");
19
 
 
20
 
SELECT * FROM t1;
21
 
 
22
 
DROP TABLE t1;