summaryrefslogtreecommitdiff
path: root/mysql-test/r/archive.result
diff options
context:
space:
mode:
authorunknown <brian@zim.tangent.org>2006-02-07 22:42:57 -0800
committerunknown <brian@zim.tangent.org>2006-02-07 22:42:57 -0800
commit9f5962ed25c295501a4e4e57688fb809e01e4271 (patch)
tree7770998af161d1eeb1a27e1e53e19e3bd6afa97c /mysql-test/r/archive.result
parent2f3705752a08c561d68e9676d6e9506468fa4bb3 (diff)
downloadmariadb-git-9f5962ed25c295501a4e4e57688fb809e01e4271.tar.gz
The handlerton structures for archive and CSV had not been updated. Nicht so gute. I also fixed CSV to use fast alter table and put in a test in archive in case someone tries to do the same there (hint... it won't work).
mysql-test/r/archive.result: New results mysql-test/r/csv.result: New results mysql-test/t/archive.test: Adding test for new fast alter table mysql-test/t/csv.test: Adding test for new fast alter table sql/ha_archive.cc: Updating handlerton to remove warnings. storage/csv/ha_tina.cc: Updating handlerton to remove warnings, and updated CSV to handle fast alter table. storage/csv/ha_tina.h: New method.
Diffstat (limited to 'mysql-test/r/archive.result')
-rw-r--r--mysql-test/r/archive.result55
1 files changed, 55 insertions, 0 deletions
diff --git a/mysql-test/r/archive.result b/mysql-test/r/archive.result
index 201383b06be..26d95a4dc8d 100644
--- a/mysql-test/r/archive.result
+++ b/mysql-test/r/archive.result
@@ -12537,4 +12537,59 @@ SELECT c FROM t5 WHERE a IN (32, 23, 5);
c
NULL
posterity
+drop table t1;
+create table t1 (v varchar(32));
+insert into t1 values ('def'),('abc'),('hij'),('3r4f');
+select * from t1;
+v
+def
+abc
+hij
+3r4f
+alter table t1 change v v2 varchar(32);
+select * from t1;
+v2
+def
+abc
+hij
+3r4f
+alter table t1 change v2 v varchar(64);
+select * from t1;
+v
+def
+abc
+hij
+3r4f
+update t1 set v = 'lmn' where v = 'hij';
+select * from t1;
+v
+def
+abc
+lmn
+3r4f
+alter table t1 add i int auto_increment not null primary key first;
+select * from t1;
+i v
+1 def
+2 abc
+3 lmn
+4 3r4f
+update t1 set i=5 where i=3;
+select * from t1;
+i v
+1 def
+2 abc
+5 lmn
+4 3r4f
+alter table t1 change i i bigint;
+select * from t1;
+i v
+1 def
+2 abc
+5 lmn
+4 3r4f
+alter table t1 add unique key (i, v);
+select * from t1 where i between 2 and 4 and v in ('def','3r4f','lmn');
+i v
+4 3r4f
drop table t1, t2, t4, t5;