summaryrefslogtreecommitdiff
path: root/mysql-test/t/archive.test
diff options
context:
space:
mode:
authorunknown <brian@zim.(none)>2005-10-26 13:55:08 -0700
committerunknown <brian@zim.(none)>2005-10-26 13:55:08 -0700
commita39cb4fa2a501cdc08f5a8e4e71f2e53044560cf (patch)
tree45dfd3af1cc2ee6fb67e07d68a6a79f77381de9d /mysql-test/t/archive.test
parent4aaa655c7608b7d93fc1af8362e2f60f277aaa1b (diff)
downloadmariadb-git-a39cb4fa2a501cdc08f5a8e4e71f2e53044560cf.tar.gz
Change in gis test to allow NDB to be able to call generic tests. Fix for Archive so that ALTER TABLE doesn't issue a warning. Also added test case for alter table.
mysql-test/include/gis_generic.inc: Change in test for NDB (needs order by) mysql-test/r/archive.result: Change for gis_generic mysql-test/r/archive_gis.result: Change in test gis_generic mysql-test/r/bdb_gis.result: Change in gis test means new results mysql-test/r/innodb_gis.result: Change in gis test means change in results. mysql-test/r/ndb_gis.result: Change in gis means result change mysql-test/t/archive.test: Added alter table test to fix bug in alter table mysql-test/t/archive_gis.test: Change in syntax mysql-test/t/ndb_gis.test: Change to test both with and not with pushdown conditions sql/ha_archive.cc: Removed ARN temp file from exts[] to solve warning messages in alter table.
Diffstat (limited to 'mysql-test/t/archive.test')
-rw-r--r--mysql-test/t/archive.test5
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/t/archive.test b/mysql-test/t/archive.test
index ac2061eeb0b..ba2ad3ed8aa 100644
--- a/mysql-test/t/archive.test
+++ b/mysql-test/t/archive.test
@@ -1347,6 +1347,11 @@ SELECT * FROM t2;
# Just test syntax, we will never know if the output is right or wrong
# Must be the last test
INSERT DELAYED INTO t2 VALUES (4,011403,37,'intercepted','audiology','tinily','');
+
+# Adding test for alter table
+ALTER TABLE t2 DROP COLUMN fld6;
+SHOW CREATE TABLE t2;
+SELECT * from t2;
#
# Cleanup, test is over
#