summaryrefslogtreecommitdiff
path: root/mysql-test/r/alter_table-big.result
diff options
context:
space:
mode:
authorunknown <cmiller@zippy.cornsilk.net>2007-01-31 16:23:05 -0500
committerunknown <cmiller@zippy.cornsilk.net>2007-01-31 16:23:05 -0500
commitffe6fae3bb0961a07a22c1e0fb90a4d123d22690 (patch)
tree310051f9adb743a7d4761e730eb5dc7f6124cf95 /mysql-test/r/alter_table-big.result
parent3d6e5feaf956d86751f3a1774fafd3bbaea3b1bc (diff)
parent92a7c1ed9c6dec1fee17a830fdabe9272d6692bd (diff)
downloadmariadb-git-ffe6fae3bb0961a07a22c1e0fb90a4d123d22690.tar.gz
Merge bk-internal.mysql.com:/home/bk/mysql-5.0
into zippy.cornsilk.net:/home/cmiller/work/mysql/mysql-5.0-maint configure.in: Auto merged mysql-test/mysql-test-run.pl: Auto merged mysql-test/r/range.result: Auto merged mysql-test/r/select.result: Auto merged mysql-test/t/select.test: Auto merged scripts/mysqld_multi.sh: Auto merged sql/item.cc: Auto merged sql/item_cmpfunc.cc: Auto merged sql/item_cmpfunc.h: Auto merged sql/mysql_priv.h: Auto merged sql/mysqld.cc: Auto merged sql/sql_select.cc: Auto merged
Diffstat (limited to 'mysql-test/r/alter_table-big.result')
-rw-r--r--mysql-test/r/alter_table-big.result18
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/r/alter_table-big.result b/mysql-test/r/alter_table-big.result
new file mode 100644
index 00000000000..873978c60de
--- /dev/null
+++ b/mysql-test/r/alter_table-big.result
@@ -0,0 +1,18 @@
+drop table if exists t1, t2;
+create table t1 (n1 int, n2 int, n3 int,
+key (n1, n2, n3),
+key (n2, n3, n1),
+key (n3, n1, n2));
+create table t2 (i int);
+alter table t1 disable keys;
+reset master;
+alter table t1 enable keys;;
+insert into t2 values (1);
+insert into t1 values (1, 1, 1);
+show binlog events in 'master-bin.000001' from 98;
+Log_name Pos Event_type Server_id End_log_pos Info
+master-bin.000001 # Query 1 # use `test`; insert into t2 values (1)
+master-bin.000001 # Query 1 # use `test`; alter table t1 enable keys
+master-bin.000001 # Query 1 # use `test`; insert into t1 values (1, 1, 1)
+drop tables t1, t2;
+End of 5.0 tests