summaryrefslogtreecommitdiff
path: root/mysql-test/t/merge.test
diff options
context:
space:
mode:
authorunknown <acurtis@xiphis.org>2006-05-30 17:10:53 -0700
committerunknown <acurtis@xiphis.org>2006-05-30 17:10:53 -0700
commit11dbc1c48f6344cda00bae8e939d33f0ff215cd7 (patch)
tree9989e1d6775fca6aedd8e17a1bbefc81923b2ff6 /mysql-test/t/merge.test
parent4f8407b6315736ab52b49e1e248e7585614c3f20 (diff)
downloadmariadb-git-11dbc1c48f6344cda00bae8e939d33f0ff215cd7.tar.gz
Bug#19648
"Merge table does not work with bit types" MERGE should have HA_CAN_BIT_FIELD feature bit set or else table row is formatted incorrectly. mysql-test/r/merge.result: Bug#19648 Test for fix mysql-test/t/merge.test: Bug#19648 Test for fix sql/ha_myisammrg.h: Bug#19648 Must have HA_CAN_BIT_FIELD for BIT type support
Diffstat (limited to 'mysql-test/t/merge.test')
-rw-r--r--mysql-test/t/merge.test9
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/merge.test b/mysql-test/t/merge.test
index 7ea14a811ed..400279a826b 100644
--- a/mysql-test/t/merge.test
+++ b/mysql-test/t/merge.test
@@ -390,4 +390,13 @@ insert into t1 values ("Monty"),("WAX"),("Walrus");
alter table t1 engine=MERGE;
drop table t1;
+#
+# BUG#19648 - Merge table does not work with bit types
+#
+create table t1 (b bit(1));
+create table t2 (b bit(1));
+create table tm (b bit(1)) engine = merge union = (t1,t2);
+select * from tm;
+drop table tm, t1, t2;
+
# End of 5.0 tests