summaryrefslogtreecommitdiff
path: root/storage/tokudb/mysql-test/tokudb_bugs/t/alter_external_lock_assert.test
blob: 176d2c8ded4873ce86f86a8a1e34af95ac031b64 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
# test case for Tokutek/mysql56#54, assert in tokudb::external_lock

source include/have_tokudb.inc;
set default_storage_engine=tokudb;
disable_warnings;
DROP TABLE IF EXISTS p,i,t1_tokudb_tokudb_smallvc_250;
enable_warnings;
BEGIN;
CREATE TABLE t1_tokudb_tokudb_smallvc_250(
c1 BLOB,
c2 DATE,
unique(c2)) ENGINE=tokudb ROW_FORMAT=tokudb_small;
CREATE TEMPORARY TABLE p LIKE t1_tokudb_tokudb_smallvc_250;
ALTER TABLE p RENAME t1_tokudb_tokudb_smallvc_250;
CREATE TEMPORARY TABLE i SELECT 1 t1_tokudb_tokudb_smallvc_250;
show tables;
LOCK TABLE i READ;
ALTER TABLE t1_tokudb_tokudb_smallvc_250 MODIFY c1 DATE;
ALTER TABLE t1_tokudb_tokudb_smallvc_250 MODIFY c1 DATE;
ALTER TABLE t1_tokudb_tokudb_smallvc_250 MODIFY c1 DATE;
UNLOCK TABLES;
COMMIT;
disable_warnings;
DROP TABLE IF EXISTS i,p,t1_tokudb_tokudb_smallvc_250;
enable_warnings;
DROP TABLE t1_tokudb_tokudb_smallvc_250;