← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/almost_full.test

  • Committer: Monty Taylor
  • Date: 2008-11-16 06:29:53 UTC
  • mto: (584.1.9 devel)
  • mto: This revision was merged to the branch mainline in revision 589.
  • Revision ID: monty@inaugust.com-20081116062953-ivdltjmfe009b5fr
Moved stuff into item/

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/almost_full.test
1
 
#
2
 
# Some special cases with empty tables
3
 
#
4
 
 
5
 
--disable_warnings
6
 
drop table if exists t1;
7
 
--enable_warnings
8
 
 
9
 
CREATE TEMPORARY TABLE t1 (a int auto_increment primary key not null, b longtext) ENGINE=MyISAM;
10
 
 
11
 
--disable_query_log
12
 
begin;
13
 
let $1= 303;
14
 
while ($1)
15
 
{
16
 
  INSERT INTO t1 SET b=repeat('a',200);
17
 
  dec $1;
18
 
}
19
 
commit;
20
 
--enable_query_log
21
 
 
22
 
#DELETE FROM t1 WHERE a=1 or a=5;
23
 
 
24
 
#--error ER_RECORD_FILE_FULL
25
 
#INSERT INTO t1 SET b=repeat('a',600);
26
 
#CHECK TABLE t1 EXTENDED;
27
 
 
28
 
#--error ER_RECORD_FILE_FULL
29
 
#UPDATE t1 SET b=repeat('a', 800) where a=10;
30
 
#CHECK TABLE t1 EXTENDED;
31
 
 
32
 
#INSERT INTO t1 SET b=repeat('a',400);
33
 
#CHECK TABLE t1 EXTENDED;
34
 
 
35
 
#DELETE FROM t1 WHERE a=2 or a=6;
36
 
#UPDATE t1 SET b=repeat('a', 600) where a=11;
37
 
#CHECK TABLE t1 EXTENDED;
38
 
drop table t1;
39
 
 
40
 
# End of 4.1 tests