summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorElena Stepanova <elenst@montyprogram.com>2018-04-25 19:19:44 +0300
committerElena Stepanova <elenst@montyprogram.com>2018-04-25 19:19:44 +0300
commit4a3dd18a48e2eb026f16627a909ab18a0fe90a4e (patch)
treead020c4e8ea7089755b26983e4badc9aa8d39e95
parentebd8e6807f2b11788b6a743cf88dcb715bec3af9 (diff)
downloadmariadb-git-bb-10.2-mtr.tar.gz
Add a test case which is known to fail, to check failure handlingbb-10.2-mtr
Not to be merged to the main tree!
-rw-r--r--mysql-test/r/mdev14864.result8
-rw-r--r--mysql-test/t/mdev14864.test10
2 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/r/mdev14864.result b/mysql-test/r/mdev14864.result
new file mode 100644
index 00000000000..045902043a6
--- /dev/null
+++ b/mysql-test/r/mdev14864.result
@@ -0,0 +1,8 @@
+CREATE TABLE t1 (t TEXT DEFAULT '') CHARSET=latin1;
+Warnings:
+Warning 1101 BLOB/TEXT column 't' can't have a default value
+ALTER TABLE t1 COLLATE utf8_bin;
+ALTER TABLE t1 PARTITION BY HASH(f);
+ERROR 42S22: Unknown column 'f' in 'partition function'
+ALTER TABLE t1 ADD COLUMN i INT;
+DROP TABLE t1;
diff --git a/mysql-test/t/mdev14864.test b/mysql-test/t/mdev14864.test
new file mode 100644
index 00000000000..59963cdfc39
--- /dev/null
+++ b/mysql-test/t/mdev14864.test
@@ -0,0 +1,10 @@
+--source include/have_partition.inc
+
+CREATE TABLE t1 (t TEXT DEFAULT '') CHARSET=latin1;
+ALTER TABLE t1 COLLATE utf8_bin;
+--error ER_BAD_FIELD_ERROR
+ALTER TABLE t1 PARTITION BY HASH(f);
+ALTER TABLE t1 ADD COLUMN i INT;
+
+# Cleanup
+DROP TABLE t1;