summaryrefslogtreecommitdiff
path: root/storage/tokudb/mysql-test/tokudb_alter_table/r/null_bytes_drop_key.result
diff options
context:
space:
mode:
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb_alter_table/r/null_bytes_drop_key.result')
-rw-r--r--storage/tokudb/mysql-test/tokudb_alter_table/r/null_bytes_drop_key.result53
1 files changed, 53 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb_alter_table/r/null_bytes_drop_key.result b/storage/tokudb/mysql-test/tokudb_alter_table/r/null_bytes_drop_key.result
new file mode 100644
index 00000000000..09b0deaf990
--- /dev/null
+++ b/storage/tokudb/mysql-test/tokudb_alter_table/r/null_bytes_drop_key.result
@@ -0,0 +1,53 @@
+set default_storage_engine=tokudb;
+drop table if exists t;
+CREATE TABLE t (
+c25 char(1),
+c277 int,
+c195 int unsigned,
+c129 char(1),
+c196 int unsigned,
+c58 date,
+c7 varchar(1),
+c121 varchar(1),
+c21 char(1),
+c56 date,
+c2 varchar(1),
+c12 varchar(1),
+c13 char(1),
+c14 int,
+c15 date,
+c16 char(1),
+c17 varchar(1),
+c18 int unsigned,
+c120 varchar(1),
+c19 varchar(1),
+c5 varchar(1),
+c22 char(1),
+c9 varchar(1),
+c23 char(1),
+c28 char(1),
+c279 int unsigned,
+c26 char(1),
+c27 varchar(1),
+c24 char(1),
+c193 int,
+c29 date,
+c30 varchar(1),
+c194 int,
+c31 date,
+key(c31)) ENGINE=tokudb;
+INSERT INTO t (c25) VALUES (NULL);
+UPDATE t SET c27=0;
+ALTER TABLE t ADD PRIMARY KEY(c19,c27)USING HASH;
+Warnings:
+Warning 1265 Data truncated for column 'c19' at row 1
+UPDATE t SET c27=0;
+ALTER TABLE t ADD KEY (c25);
+UPDATE t SET c27=0;
+ALTER TABLE t ROW_FORMAT=FIXED KEY_BLOCK_SIZE=1;
+UPDATE t SET c27=0;
+set tokudb_disable_hot_alter=0;
+set tokudb_disable_slow_alter=1;
+ALTER TABLE t DROP KEY c25;
+UPDATE t SET c27=0;
+drop table t;