← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/filesystem_engine/tests/r/basic_insert.result

  • 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/r/basic_insert.result
1
 
DROP TABLE IF EXISTS t1;
2
 
CREATE TABLE t1 (a INT, b VARCHAR(20)) ENGINE=FILESYSTEM,FILE="VARDIR/filesystem_ln/basic_insert.data";
3
 
INSERT INTO t1 VALUES (222, "bbb");
4
 
INSERT INTO t1 VALUES (333, "ccc");
5
 
INSERT INTO t1 VALUES (444, "ddd");
6
 
INSERT INTO t1 VALUES (555, "eee");
7
 
INSERT INTO t1 VALUES (666, "fff");
8
 
SELECT * FROM t1;
9
 
a       b
10
 
111     aaa
11
 
222     bbb
12
 
333     ccc
13
 
444     ddd
14
 
555     eee
15
 
666     fff
16
 
DELETE FROM t1;
17
 
INSERT INTO t1 VALUES (111, "aaa");
18
 
SELECT * FROM t1;
19
 
a       b
20
 
111     aaa
21
 
DROP TABLE t1;