diff options
author | unknown <joreland@mysql.com> | 2004-08-24 13:29:11 +0200 |
---|---|---|
committer | unknown <joreland@mysql.com> | 2004-08-24 13:29:11 +0200 |
commit | f7e31ee94c822b1d2be6d479d4fade6304243754 (patch) | |
tree | 0edda70a93b5a42405a81fe6df1341e40e3bc37f /mysql-test/t/ndb_blob.test | |
parent | c62a26f777d5972f892b4b39a2e7036b5974f7e6 (diff) | |
parent | d7dd19aa07c3ba439c2b97d50949f2142cefb203 (diff) | |
download | mariadb-git-f7e31ee94c822b1d2be6d479d4fade6304243754.tar.gz |
merge
configure.in:
Auto merged
mysql-test/t/ndb_blob.test:
Auto merged
ndb/src/mgmsrv/Services.cpp:
Auto merged
Diffstat (limited to 'mysql-test/t/ndb_blob.test')
-rw-r--r-- | mysql-test/t/ndb_blob.test | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/t/ndb_blob.test b/mysql-test/t/ndb_blob.test index 391d2a2ec23..3671c7fd07a 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 # @@ -211,6 +212,31 @@ 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; + +# 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; + # range scan delete delete from t1 where c >= 100; commit; |