← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/archive.test

  • 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/t/archive.test
2
2
# Simple test for archive example
3
3
# Taken FROM the select test
4
4
#
 
5
-- source include/have_archive.inc
5
6
 
6
7
--disable_warnings
7
8
DROP TABLE if exists t1,t2,t3,t4,t5,t6;
1317
1318
INSERT INTO t2 VALUES (3,011402,37,'Romans','scholastics','jarring','');
1318
1319
INSERT INTO t2 VALUES (4,011403,37,'intercepted','audiology','tinily','');
1319
1320
SELECT * FROM t2;
1320
 
ALTER TABLE t2 ENGINE=ARCHIVE;
 
1321
OPTIMIZE TABLE t2;
1321
1322
SELECT * FROM t2;
1322
1323
INSERT INTO t2 VALUES (2,011401,37,'breaking','dreaded','Steinberg','W');
1323
1324
INSERT INTO t2 VALUES (3,011402,37,'Romans','scholastics','jarring','');
1324
1325
INSERT INTO t2 VALUES (4,011403,37,'intercepted','audiology','tinily','');
1325
 
ALTER TABLE t2 ENGINE=ARCHIVE;
 
1326
OPTIMIZE TABLE t2;
1326
1327
SELECT * FROM t2;
1327
1328
 
1328
1329
#
1401
1402
INSERT INTO t5 VALUES (3, "foo");
1402
1403
INSERT INTO t5 VALUES (NULL, "foo");
1403
1404
SELECT * FROM t5;
1404
 
ALTER TABLE t5 ENGINE=ARCHIVE;
 
1405
OPTIMIZE TABLE t5;
1405
1406
SELECT * FROM t5;
1406
1407
 
1407
1408
SELECT * FROM t5 WHERE a=32;
1538
1539
create table t1(a blob) engine=archive;
1539
1540
insert into t1 set a='';
1540
1541
insert into t1 set a='a';
1541
 
check table t1;
 
1542
check table t1 extended;
1542
1543
drop table t1;
1543
1544
 
1544
1545
#