26 lines
605 B
Text
26 lines
605 B
Text
# MyISAM is necessary to check that rollback does not work for it.
|
|
--source include/force_myisam_default.inc
|
|
--source include/have_myisam.inc
|
|
|
|
#
|
|
# This test should fail as MyISAM doesn't have rollback
|
|
#
|
|
|
|
--disable_warnings
|
|
drop table if exists t1;
|
|
--enable_warnings
|
|
# PS doesn't work with BEGIN ... ROLLBACK
|
|
--disable_ps_protocol
|
|
|
|
create table t1 (n int not null primary key) engine=myisam;
|
|
begin work;
|
|
insert into t1 values (4);
|
|
insert into t1 values (5);
|
|
rollback;
|
|
show warnings;
|
|
show errors;
|
|
select @@warning_count,@@error_count;
|
|
select * from t1;
|
|
show warnings;
|
|
select @@warning_count;
|
|
drop table t1;
|