~drizzle-trunk/drizzle/development

#

# Some special cases with empty tables

#

--disable_warnings

drop table if exists t1;

--enable_warnings

#Drizzle does not support global myisam_data_pointer_size system variable

#set global myisam_data_pointer_size=2;

CREATE TEMPORARY TABLE t1 (a int auto_increment primary key not null, b longtext) ENGINE=MyISAM;

--disable_query_log

begin;

let $1= 303;

while ($1)

{

  INSERT INTO t1 SET b=repeat('a',200);

  dec $1;

}

commit;

--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