mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-10-31 02:46:29 +01:00
Code Issues Projects Releases Packages Wiki Activity
mariadb/mysql-test/main/implicit_commit.result
Rinat Ibragimov 709ba7dcae MDEV-20945: BACKUP UNLOCK + FTWRL assertion failure 
MDEV-20945: BACKUP UNLOCK + FTWRL assertion failure | SIGSEGV in I_P_List
from MDL_context::release_lock on INSERT w/ BACKUP LOCK (on optimized
builds) | Assertion `ticket->m_duration == MDL_EXPLICIT' failed

BACKUP LOCK behavior is modified so it won't be used wrong:
- BACKUP LOCK should commit any active transactions.
- BACKUP LOCK should not be allowed in stored procedures.
- When BACKUP LOCK is active, don't allow any DDL's for that connection.
- FTWRL is forbidden on the same connection while BACKUP LOCK is active.

Reviewed-by: monty@mariadb.com
2020-10-22 00:18:33 +03:00

1077 lines
18 KiB
Text
Raw Permalink Blame History

SET SQL_MODE="";
SET GLOBAL EVENT_SCHEDULER = OFF;
SET BINLOG_FORMAT = STATEMENT;
CREATE DATABASE db1;
USE db1;
CREATE TABLE t1 (a INT, KEY a(a)) ENGINE=INNODB;
INSERT INTO t1 VALUES (1),(2),(3),(4),(5);
CREATE TABLE t3 (a INT) ENGINE=MyISAM;
INSERT INTO t3 SELECT * FROM t1;
CREATE TABLE trans (a INT) ENGINE=INNODB;
CREATE PROCEDURE test_if_commit()
BEGIN
ROLLBACK;
SELECT IF (COUNT(*) > 0, "YES", "NO") AS "IMPLICIT COMMIT" FROM trans;
DELETE FROM trans;
COMMIT;
END|
SET AUTOCOMMIT = FALSE;
#
# SQLCOM_SELECT
#
INSERT INTO db1.trans (a) VALUES (1);
select 1 as res from t1 where (1) in (select * from t1);
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_CREATE_TABLE LIKE
#
INSERT INTO db1.trans (a) VALUES (1);
create table t2 like t1;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_SHOW_CREATE
#
INSERT INTO db1.trans (a) VALUES (1);
show create table t2;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_DROP_TABLE
#
INSERT INTO db1.trans (a) VALUES (1);
drop table t2;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_CREATE_TABLE TEMPORARY
#
INSERT INTO db1.trans (a) VALUES (1);
create temporary table t2 as select * from t1;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_DROP_TABLE TEMPORARY
#
INSERT INTO db1.trans (a) VALUES (1);
drop temporary table t2;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_CREATE_TABLE
#
INSERT INTO db1.trans (a) VALUES (1);
create table t2 as select * from t1;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_UPDATE
#
INSERT INTO db1.trans (a) VALUES (1);
update t2 set a=a+1 where (1) in (select * from t1);
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_INSERT
#
INSERT INTO db1.trans (a) VALUES (1);
insert into t2 set a=((1) in (select * from t1));
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_INSERT_SELECT
#
INSERT INTO db1.trans (a) VALUES (1);
insert into t2 select * from t1;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_REPLACE
#
INSERT INTO db1.trans (a) VALUES (1);
replace t2 set a=((1) in (select * from t1));
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_REPLACE_SELECT
#
INSERT INTO db1.trans (a) VALUES (1);
replace t2 select * from t1;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_DELETE
#
INSERT INTO db1.trans (a) VALUES (1);
delete from t2 where (1) in (select * from t1);
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_DELETE_MULTI
#
INSERT INTO db1.trans (a) VALUES (1);
delete t2, t3 from t2, t3 where (1) in (select * from t1);
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_UPDATE_MULTI
#
select * from t2;
a
INSERT INTO db1.trans (a) VALUES (1);
update t2, t3 set t3.a=t2.a, t2.a=null where (1) in (select * from t1);
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_LOAD
#
create table t4 (a varchar(100));
INSERT INTO db1.trans (a) VALUES (1);
load data infile '../../std_data/words.dat' into table t4;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
drop table t4;
#
# SQLCOM_SHOW_DATABASES
#
INSERT INTO db1.trans (a) VALUES (1);
show databases where (1) in (select * from t1);
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_TABLES
#
INSERT INTO db1.trans (a) VALUES (1);
show tables where (1) in (select * from t1);
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_FIELDS
#
INSERT INTO db1.trans (a) VALUES (1);
show fields from t1 where (1) in (select * from t1);
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_KEYS
#
INSERT INTO db1.trans (a) VALUES (1);
show keys from t1 where (1) in (select * from t1);
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_VARIABLES
#
INSERT INTO db1.trans (a) VALUES (1);
show variables where (1) in (select * from t1);
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_STATUS
#
INSERT INTO db1.trans (a) VALUES (1);
show status where (1) in (select * from t1);
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_ENGINE_MUTEX
#
INSERT INTO db1.trans (a) VALUES (1);
show engine all mutex;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_PROCESSLIST
#
INSERT INTO db1.trans (a) VALUES (1);
show processlist;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_ENGINE_LOGS
#
INSERT INTO db1.trans (a) VALUES (1);
show engine all logs;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_ENGINE_STATUS
#
INSERT INTO db1.trans (a) VALUES (1);
show engine all status;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_CHARSETS
#
INSERT INTO db1.trans (a) VALUES (1);
show charset where (1) in (select * from t1);
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_COLLATIONS
#
INSERT INTO db1.trans (a) VALUES (1);
show collation where (1) in (select * from t1);
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_TABLE_STATUS
#
INSERT INTO db1.trans (a) VALUES (1);
show table status where (1) in (select * from t1);
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_TRIGGERS
#
INSERT INTO db1.trans (a) VALUES (1);
show triggers where (1) in (select * from t1);
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_OPEN_TABLES
#
INSERT INTO db1.trans (a) VALUES (1);
show open tables where (1) in (select * from t1);
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_STATUS_PROC
#
INSERT INTO db1.trans (a) VALUES (1);
show procedure status where (1) in (select * from t1);
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_STATUS_FUNC
#
INSERT INTO db1.trans (a) VALUES (1);
show function status where (1) in (select * from t1);
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SET_OPTION
#
INSERT INTO db1.trans (a) VALUES (1);
set @a=((1) in (select * from t1));
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_DO
#
INSERT INTO db1.trans (a) VALUES (1);
do ((1) in (select * from t1));
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_CALL
#
create procedure p1(a int) begin end;
INSERT INTO db1.trans (a) VALUES (1);
call p1((1) in (select * from t1));
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
drop procedure p1;
#
# SQLCOM_CREATE_VIEW
#
INSERT INTO db1.trans (a) VALUES (1);
create view v1 as select * from t1;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_ALTER_VIEW
#
INSERT INTO db1.trans (a) VALUES (1);
alter view v1 as select 2;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_DROP_VIEW
#
INSERT INTO db1.trans (a) VALUES (1);
drop view v1;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_CREATE_INDEX
#
INSERT INTO db1.trans (a) VALUES (1);
create index idx1 on t1(a);
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_DROP_INDEX
#
INSERT INTO db1.trans (a) VALUES (1);
drop index idx1 on t1;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_ALTER_TABLE
#
INSERT INTO db1.trans (a) VALUES (1);
alter table t1 add column b int;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
INSERT INTO db1.trans (a) VALUES (1);
alter table t1 change b c int;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
INSERT INTO db1.trans (a) VALUES (1);
alter table t1 drop column c;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_ALTER_TABLE TEMPORARY
#
create temporary table t4 (a int);
INSERT INTO db1.trans (a) VALUES (1);
alter table t1 add column b int;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
INSERT INTO db1.trans (a) VALUES (1);
alter table t1 change b c int;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
INSERT INTO db1.trans (a) VALUES (1);
alter table t1 drop column c;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
drop table t4;
#
# SQLCOM_TRUNCATE
#
insert into t2 select * from t1;
INSERT INTO db1.trans (a) VALUES (1);
truncate table t2;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
insert into t2 select * from t1;
#
# SQLCOM_TRUNCATE TEMPORARY
#
create temporary table t4 as select * from t1;
INSERT INTO db1.trans (a) VALUES (1);
truncate table t4;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
drop temporary table t4;
#
# SQLCOM_SHOW_MASTER_STAT
#
INSERT INTO db1.trans (a) VALUES (1);
show master status;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_SLAVE_STAT
#
INSERT INTO db1.trans (a) VALUES (1);
show slave status;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_GRANT
#
INSERT INTO db1.trans (a) VALUES (1);
grant all on test.t1 to mysqltest_2@localhost with grant option;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_REVOKE
#
INSERT INTO db1.trans (a) VALUES (1);
revoke select on test.t1 from mysqltest_2@localhost;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_REVOKE_ALL
#
INSERT INTO db1.trans (a) VALUES (1);
revoke all on test.t1 from mysqltest_2@localhost;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
drop user mysqltest_2@localhost;
#
# SQLCOM_SHOW_GRANTS
#
INSERT INTO db1.trans (a) VALUES (1);
show grants;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
INSERT INTO db1.trans (a) VALUES (1);
show grants for current_user();
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_LOCK_TABLES
#
INSERT INTO db1.trans (a) VALUES (1);
lock tables t1 write, trans write;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_UNLOCK_TABLES
#
INSERT INTO db1.trans (a) VALUES (1);
unlock tables;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_CREATE_DB
#
INSERT INTO db1.trans (a) VALUES (1);
create database db2;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_CHANGE_DB
#
create table db2.t1 (a int);
insert into db2.t1 values (1);
commit;
INSERT INTO db1.trans (a) VALUES (1);
use db2;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_CREATE_DB
#
INSERT INTO db1.trans (a) VALUES (1);
show create database db2;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_ALTER_DB
#
#
# SQLCOM_ALTER_DB_UPGRADE
#
#
# SQLCOM_DROP_DB
#
use db1;
INSERT INTO db1.trans (a) VALUES (1);
drop database db2;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_REPAIR
#
INSERT INTO db1.trans (a) VALUES (1);
repair table t2;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
INSERT INTO db1.trans (a) VALUES (1);
repair table t2 use_frm;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_OPTIMIZE
#
INSERT INTO db1.trans (a) VALUES (1);
optimize table t1;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_CHECK
#
INSERT INTO db1.trans (a) VALUES (1);
check table t1;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
INSERT INTO db1.trans (a) VALUES (1);
check table t1 extended;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_ASSIGN_TO_KEYCACHE
#
set global keycache.key_buffer_size=128*1024;
INSERT INTO db1.trans (a) VALUES (1);
cache index t3 in keycache;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
set global keycache.key_buffer_size=0;
#
# SQLCOM_PRELOAD_KEYS
#
INSERT INTO db1.trans (a) VALUES (1);
load index into cache t3;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_FLUSH
#
INSERT INTO db1.trans (a) VALUES (1);
flush local privileges;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
INSERT INTO db1.trans (a) VALUES (1);
flush privileges;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_KILL
#
#
# SQLCOM_ANALYZE
#
INSERT INTO db1.trans (a) VALUES (1);
analyze table t1;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_ROLLBACK
#
INSERT INTO db1.trans (a) VALUES (1);
rollback;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_ROLLBACK_TO_SAVEPOINT
#
#
# SQLCOM_COMMIT
#
INSERT INTO db1.trans (a) VALUES (1);
commit;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_SAVEPOINT
#
INSERT INTO db1.trans (a) VALUES (1);
savepoint sp1;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_RELEASE_SAVEPOINT
#
#
# SQLCOM_SLAVE_START
#
#
# SQLCOM_SLAVE_STOP
#
#
# SQLCOM_BEGIN
#
INSERT INTO db1.trans (a) VALUES (1);
begin;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_CHANGE_MASTER
#
#
# SQLCOM_RENAME_TABLE
#
INSERT INTO db1.trans (a) VALUES (1);
rename table t3 to t4;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
INSERT INTO db1.trans (a) VALUES (1);
rename table t4 to t3;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_RESET
#
INSERT INTO db1.trans (a) VALUES (1);
reset query cache;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_PURGE
#
#
# SQLCOM_PURGE_BEFORE
#
#
# SQLCOM_SHOW_BINLOGS
#
#
# SQLCOM_HA_OPEN
#
INSERT INTO db1.trans (a) VALUES (1);
handler t1 open as ha1;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_HA_READ
#
INSERT INTO db1.trans (a) VALUES (1);
handler ha1 read a first;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_HA_CLOSE
#
INSERT INTO db1.trans (a) VALUES (1);
handler ha1 close;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_SLAVE_HOSTS
#
INSERT INTO db1.trans (a) VALUES (1);
show slave hosts;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_BINLOG_EVENTS
#
INSERT INTO db1.trans (a) VALUES (1);
show binlog events;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_NEW_MASTER
#
#
# SQLCOM_SHOW_WARNS
#
INSERT INTO db1.trans (a) VALUES (1);
show warnings;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_EMPTY_QUERY
#
#
# SQLCOM_SHOW_ERRORS
#
INSERT INTO db1.trans (a) VALUES (1);
show errors;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_STORAGE_ENGINES
#
INSERT INTO db1.trans (a) VALUES (1);
show engines;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_PRIVILEGES
#
INSERT INTO db1.trans (a) VALUES (1);
show privileges;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_HELP
#
INSERT INTO db1.trans (a) VALUES (1);
help 'foo';
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_CREATE_USER
#
INSERT INTO db1.trans (a) VALUES (1);
create user trxusr1;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_RENAME_USER
#
INSERT INTO db1.trans (a) VALUES (1);
rename user 'trxusr1' to 'trxusr2';
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_DROP_USER
#
INSERT INTO db1.trans (a) VALUES (1);
drop user trxusr2;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_CHECKSUM
#
INSERT INTO db1.trans (a) VALUES (1);
checksum table t1;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_CREATE_PROCEDURE
#
INSERT INTO db1.trans (a) VALUES (1);
create procedure p1(a int) begin end;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_ALTER_PROCEDURE
#
INSERT INTO db1.trans (a) VALUES (1);
alter procedure p1 comment 'foobar';
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_SHOW_CREATE_PROC
#
INSERT INTO db1.trans (a) VALUES (1);
show create procedure p1;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_STATUS_PROC
#
INSERT INTO db1.trans (a) VALUES (1);
show procedure status;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_PROC_CODE
#
INSERT INTO db1.trans (a) VALUES (1);
show procedure code p1;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_DROP_PROCEDURE
#
INSERT INTO db1.trans (a) VALUES (1);
drop procedure p1;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_CREATE_FUNCTION
#
#
# SQLCOM_DROP_FUNCTION
#
#
# SQLCOM_CREATE_SPFUNCTION
#
INSERT INTO db1.trans (a) VALUES (1);
create function f1() returns int return 69;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_ALTER_FUNCTION
#
INSERT INTO db1.trans (a) VALUES (1);
alter function f1 comment 'comment';
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_SHOW_CREATE_FUNC
#
INSERT INTO db1.trans (a) VALUES (1);
show create function f1;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_STATUS_FUNC
#
INSERT INTO db1.trans (a) VALUES (1);
show function status like '%f%';
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_FUNC_CODE
#
INSERT INTO db1.trans (a) VALUES (1);
show function code f1;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_PREPARE
#
INSERT INTO db1.trans (a) VALUES (1);
prepare stmt1 from "insert into t1 values (5)";
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_EXECUTE
#
INSERT INTO db1.trans (a) VALUES (1);
execute stmt1;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_DEALLOCATE_PREPARE
#
INSERT INTO db1.trans (a) VALUES (1);
deallocate prepare stmt1;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_CREATE_TRIGGER
#
INSERT INTO db1.trans (a) VALUES (1);
create trigger trg1 before insert on t1 for each row set @a:=1;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_SHOW_CREATE_TRIGGER
#
INSERT INTO db1.trans (a) VALUES (1);
show create trigger trg1;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_DROP_TRIGGER
#
INSERT INTO db1.trans (a) VALUES (1);
drop trigger trg1;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_XA_START
#
#
# SQLCOM_XA_END
#
#
# SQLCOM_XA_PREPARE
#
#
# SQLCOM_XA_COMMIT
#
#
# SQLCOM_XA_ROLLBACK
#
#
# SQLCOM_XA_RECOVER
#
#
# SQLCOM_ALTER_TABLESPACE
#
#
# SQLCOM_INSTALL_PLUGIN
#
#
# SQLCOM_SHOW_PLUGINS
#
#
# SQLCOM_UNINSTALL_PLUGIN
#
#
# SQLCOM_SHOW_AUTHORS
#
INSERT INTO db1.trans (a) VALUES (1);
show authors;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_BINLOG_BASE64_EVENT
#
#
# SQLCOM_SHOW_CONTRIBUTORS
#
INSERT INTO db1.trans (a) VALUES (1);
show contributors;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_CREATE_SERVER
#
#
# SQLCOM_ALTER_SERVER
#
#
# SQLCOM_DROP_SERVER
#
#
# SQLCOM_CREATE_EVENT
#
INSERT INTO db1.trans (a) VALUES (1);
create event ev1 on schedule every 1 second do insert into t1 values (6);
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_ALTER_EVENT
#
INSERT INTO db1.trans (a) VALUES (1);
alter event ev1 rename to ev2 disable;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_SHOW_CREATE_EVENT
#
INSERT INTO db1.trans (a) VALUES (1);
show create event ev2;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_EVENTS
#
INSERT INTO db1.trans (a) VALUES (1);
show events;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_DROP_EVENT
#
INSERT INTO db1.trans (a) VALUES (1);
drop event ev2;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_BACKUP
#
#
# SQLCOM_BACKUP_LOCK
#
INSERT INTO db1.trans VALUES (1);
BACKUP LOCK t1;
ROLLBACK;
BACKUP UNLOCK;
CALL db1.test_if_commit();
IMPLICIT COMMIT
YES
#
# SQLCOM_SHOW_ARCHIVE
#
#
# SQLCOM_RESTORE
#
#
# SQLCOM_BACKUP_TEST
#
#
# SQLCOM_SHOW_PROFILE
#
INSERT INTO db1.trans (a) VALUES (1);
show profile memory;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
#
# SQLCOM_SHOW_PROFILES
#
INSERT INTO db1.trans (a) VALUES (1);
show profiles;
CALL db1.test_if_commit();
IMPLICIT COMMIT
NO
DROP TABLE t1;
DROP TABLE t2;
DROP TABLE t3;
USE test;
DROP DATABASE db1;
End of tests
Reference in a new issue View git blame Copy permalink