← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Monty Taylor
  • Date: 2011-03-09 20:59:40 UTC
  • mfrom: (2226.1.14 build)
  • Revision ID: mordred@inaugust.com-20110309205940-7f5mk6zba2u7bawa
Merged Dave - Filtered Replication docs
Merged Olaf - Refactoring work
Removed archive, blackhole, filesystem_engine, blitzdb, csv and pbxt from
the tree pre-GA as we have no interest in supporting them moving forward.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/filesystem_engine/tests/t/basic_delete.test
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_delete.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 WHERE a>=444;
17
 
DELETE FROM t1 WHERE b="bbb";
18
 
DELETE FROM t1 WHERE a!=111;
19
 
 
20
 
SELECT * FROM t1;
21
 
 
22
 
DROP TABLE t1;