← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/suite/transaction_log/t/create_select.inc

  • Committer: Jay Pipes
  • Date: 2009-11-11 19:59:46 UTC
  • mfrom: (1193.2.6 transaction_log)
  • mto: This revision was merged to the branch mainline in revision 1215.
  • Revision ID: jpipes@serialcoder-20091111195946-i393y7s8m1l2dwyh
Merge Joe's new test cases for transaction log

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/transaction_log/t/create_select.inc
 
1
#
 
2
# Test that create with select works 
 
3
#
 
4
 
 
5
--disable_warnings
 
6
DROP TABLE IF EXISTS t1;
 
7
DROP TABLE IF EXISTS t2;
 
8
--enable_warnings
 
9
 
 
10
CREATE TABLE t1 (
 
11
  id INT NOT NULL PRIMARY KEY
 
12
, padding VARCHAR(200) NOT NULL
 
13
);
 
14
 
 
15
INSERT INTO t1 VALUES (1, "I love testing.");
 
16
INSERT INTO t1 VALUES (2, "I hate testing.");
 
17
 
 
18
CREATE TABLE t2 (
 
19
  id INT NOT NULL PRIMARY KEY
 
20
, padding VARCHAR(200) NOT NULL
 
21
) SELECT * FROM t1;
 
22
 
 
23
DROP TABLE t1, t2;