From a3e0b69bfb736367fa840465766dc266bcc361fb Mon Sep 17 00:00:00 2001 From: unknown Date: Mon, 23 Aug 2004 17:24:03 +0200 Subject: Fix for bug#5171 --- mysql-test/t/ndb_blob.test | 26 ++++++++++++++++++++++++++ 1 file changed, 26 insertions(+) (limited to 'mysql-test/t/ndb_blob.test') diff --git a/mysql-test/t/ndb_blob.test b/mysql-test/t/ndb_blob.test index c1166a7a90c..d33168d9da6 100644 --- a/mysql-test/t/ndb_blob.test +++ b/mysql-test/t/ndb_blob.test @@ -2,6 +2,7 @@ --disable_warnings drop table if exists t1; +drop database if exists test2; --enable_warnings # @@ -203,6 +204,31 @@ where c >= 100; commit; select * from t1 where c >= 100 order by a; +# alter table + +select * from t1 order by a; +alter table t1 add x int; +select * from t1 order by a; +alter table t1 drop x; +select * from t1 order by a; + +# multi db + +create database test2; +use test2; + +CREATE TABLE t2 ( + a bigint unsigned NOT NULL PRIMARY KEY, + b int unsigned not null, + c int unsigned +) engine=ndbcluster; + +insert into t2 values (1,1,1),(2,2,2); +select * from test.t1,t2 where test.t1.a = t2.a order by test.t1.a; + +drop table t2; +use test; + # range scan delete delete from t1 where c >= 100; commit; -- cgit v1.2.1