MOON
Server: Apache/2.2.23 (Unix) mod_ssl/2.2.23 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 PHP/5.4.10
System: Linux vps.presagepowered.net 2.6.18-398.el5 #1 SMP Tue Sep 16 20:51:48 EDT 2014 i686
User: mckernan (512)
PHP: 5.4.10
Disabled: NONE
Upload Files
File: //usr/share/mysql-test/t/almost_full.test
#
# Some special cases with empty tables
#

--disable_warnings
drop table if exists t1;
--enable_warnings

set global myisam_data_pointer_size=2;
CREATE TABLE t1 (a int auto_increment primary key not null, b longtext) ENGINE=MyISAM;

--disable_query_log
let $1= 303;
while ($1)
{
  INSERT INTO t1 SET b=repeat('a',200);
  dec $1;
}
--enable_query_log

DELETE FROM t1 WHERE a=1 or a=5;

--error 1114
INSERT INTO t1 SET b=repeat('a',600);
CHECK TABLE t1 EXTENDED;

--error 1114
UPDATE t1 SET b=repeat('a', 800) where a=10;
CHECK TABLE t1 EXTENDED;

INSERT INTO t1 SET b=repeat('a',400);
CHECK TABLE t1 EXTENDED;

DELETE FROM t1 WHERE a=2 or a=6;
UPDATE t1 SET b=repeat('a', 600) where a=11;
CHECK TABLE t1 EXTENDED;
drop table t1;

set global myisam_data_pointer_size=default;

# End of 4.1 tests