← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/archive_aio_posix.result

  • Committer: Brian Aker
  • Date: 2009-11-26 18:48:20 UTC
  • mfrom: (1226.1.3 push)
  • Revision ID: brian@gaz-20091126184820-hltr0upee0ahopsj
Bundle Brian + Monty  (been through staging, just collecting it as want
overall patch as seen by staging).

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/archive_aio_posix.result
1412
1412
2       11401   37      breaking        dreaded Steinberg       W
1413
1413
3       11402   37      Romans  scholastics     jarring 
1414
1414
4       11403   37      intercepted     audiology       tinily  
1415
 
OPTIMIZE TABLE t2;
1416
 
Table   Op      Msg_type        Msg_text
1417
 
test.t2 optimize        status  OK
 
1415
ALTER TABLE t2 ENGINE=ARCHIVE;
1418
1416
SELECT * FROM t2;
1419
1417
auto    fld1    companynr       fld3    fld4    fld5    fld6
1420
1418
1       1       0       Omaha   teethe  neat    
2623
2621
INSERT INTO t2 VALUES (2,011401,37,'breaking','dreaded','Steinberg','W');
2624
2622
INSERT INTO t2 VALUES (3,011402,37,'Romans','scholastics','jarring','');
2625
2623
INSERT INTO t2 VALUES (4,011403,37,'intercepted','audiology','tinily','');
2626
 
OPTIMIZE TABLE t2;
2627
 
Table   Op      Msg_type        Msg_text
2628
 
test.t2 optimize        status  OK
 
2624
ALTER TABLE t2 ENGINE=ARCHIVE;
2629
2625
SELECT * FROM t2;
2630
2626
auto    fld1    companynr       fld3    fld4    fld5    fld6
2631
2627
1       1       0       Omaha   teethe  neat    
11202
11198
34      foo
11203
11199
3       foo
11204
11200
35      foo
11205
 
OPTIMIZE TABLE t5;
11206
 
Table   Op      Msg_type        Msg_text
11207
 
test.t5 optimize        status  OK
 
11201
ALTER TABLE t5 ENGINE=ARCHIVE;
11208
11202
SELECT * FROM t5;
11209
11203
a       b
11210
11204
5       foo