summaryrefslogtreecommitdiff
path: root/mysql-test/r/innodb_table_locks_func.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/innodb_table_locks_func.result')
-rw-r--r--mysql-test/r/innodb_table_locks_func.result40
1 files changed, 0 insertions, 40 deletions
diff --git a/mysql-test/r/innodb_table_locks_func.result b/mysql-test/r/innodb_table_locks_func.result
deleted file mode 100644
index 824d196d295..00000000000
--- a/mysql-test/r/innodb_table_locks_func.result
+++ /dev/null
@@ -1,40 +0,0 @@
-'#--------------------FN_DYNVARS_048_01-------------------------#'
-SET @start_value= @@global.innodb_table_locks;
-SELECT @start_value;
-@start_value
-1
-SET @@global.innodb_table_locks = OFF;
-'connect (con1,localhost,root,,,,)'
-'connection con1'
-SELECT @@global.innodb_table_locks;
-@@global.innodb_table_locks
-0
-SELECT @@session.innodb_table_locks;
-@@session.innodb_table_locks
-0
-'#--------------------FN_DYNVARS_048_02-------------------------#'
-'----check when innodb_table_locks = ON and autocommit = OFF---'
-'connect (con2,localhost,root,,,,)'
-'connection default'
-DROP TABLE IF EXISTS t1;
-CREATE TABLE t1 (a INT) ENGINE=INNODB;
-SET @@autocommit = OFF;
-SET @@innodb_table_locks = ON;
-BEGIN;
-INSERT INTO t1 VALUES(1);
-SELECT * FROM t1 FOR UPDATE;
-a
-1
-'CONNECTION con2'
-SET @@innodb_table_locks = ON;
-SET @@autocommit = OFF;
-LOCK TABLES t1 WRITE;
-'CONNECTION default'
-COMMIT;
-'CONNECTION con2'
-UNLOCK tables;
-DROP TABLE t1;
-SET @@global.innodb_table_locks= @start_value;
-SELECT @@global.innodb_table_locks;
-@@global.innodb_table_locks
-1