~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/archive.result

  • Committer: Brian Aker
  • Date: 2009-05-13 02:07:22 UTC
  • mfrom: (1008.1.5 merge)
  • Revision ID: brian@gaz-20090513020722-9nqehweityhn6ab0
Merge in refactoring around lock system

Show diffs side-by-side

added added

removed removed

Lines of Context:
11125
11125
2       11401   37      breaking        dreaded Steinberg       W
11126
11126
3       11402   37      Romans  scholastics     jarring 
11127
11127
4       11403   37      intercepted     audiology       tinily  
11128
 
SELECT COUNT(auto) FROM t2;
11129
 
COUNT(auto)
11130
 
1213
11131
 
INSERT DELAYED INTO t2 VALUES (99999,011403,37,'the','delayed','insert','');
11132
 
INSERT INTO t2 VALUES (100000,000001,00,'after','delayed','insert','');
11133
 
SELECT COUNT(auto) FROM t2;
11134
 
COUNT(auto)
11135
 
1215
11136
11128
ALTER TABLE t2 DROP COLUMN fld6;
11137
11129
SHOW CREATE TABLE t2;
11138
11130
Table   Create Table
12359
12351
2       11401   37      breaking        dreaded Steinberg
12360
12352
3       11402   37      Romans  scholastics     jarring
12361
12353
4       11403   37      intercepted     audiology       tinily
12362
 
99999   11403   37      the     delayed insert
12363
12354
CREATE TABLE `t5` (
12364
12355
`a` int NOT NULL auto_increment,
12365
12356
b char(12),