← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/archive.result

  • Committer: Padraig O'Sullivan
  • Date: 2009-09-13 01:03:01 UTC
  • mto: (1126.9.2 captain-20090915-01)
  • mto: This revision was merged to the branch mainline in revision 1133.
  • Revision ID: osullivan.padraig@gmail.com-20090913010301-tcvvezipx1124acy
Added calls to the dtrace delete begin/end probes.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/archive.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
 
ALTER TABLE t2 ENGINE=ARCHIVE;
 
1415
OPTIMIZE TABLE t2;
 
1416
Table   Op      Msg_type        Msg_text
 
1417
test.t2 optimize        status  OK
1416
1418
SELECT * FROM t2;
1417
1419
auto    fld1    companynr       fld3    fld4    fld5    fld6
1418
1420
1       1       0       Omaha   teethe  neat    
2621
2623
INSERT INTO t2 VALUES (2,011401,37,'breaking','dreaded','Steinberg','W');
2622
2624
INSERT INTO t2 VALUES (3,011402,37,'Romans','scholastics','jarring','');
2623
2625
INSERT INTO t2 VALUES (4,011403,37,'intercepted','audiology','tinily','');
2624
 
ALTER TABLE t2 ENGINE=ARCHIVE;
 
2626
OPTIMIZE TABLE t2;
 
2627
Table   Op      Msg_type        Msg_text
 
2628
test.t2 optimize        status  OK
2625
2629
SELECT * FROM t2;
2626
2630
auto    fld1    companynr       fld3    fld4    fld5    fld6
2627
2631
1       1       0       Omaha   teethe  neat    
11198
11202
34      foo
11199
11203
3       foo
11200
11204
35      foo
11201
 
ALTER TABLE t5 ENGINE=ARCHIVE;
 
11205
OPTIMIZE TABLE t5;
 
11206
Table   Op      Msg_type        Msg_text
 
11207
test.t5 optimize        status  OK
11202
11208
SELECT * FROM t5;
11203
11209
a       b
11204
11210
5       foo
11446
11452
create table t1(a blob) engine=archive;
11447
11453
insert into t1 set a='';
11448
11454
insert into t1 set a='a';
11449
 
check table t1;
 
11455
check table t1 extended;
11450
11456
Table   Op      Msg_type        Msg_text
11451
11457
test.t1 check   status  OK
11452
11458
drop table t1;