summaryrefslogtreecommitdiff
path: root/mysql-test/r/ndb_basic.result
diff options
context:
space:
mode:
authorunknown <jonas@perch.ndb.mysql.com>2005-12-14 11:34:08 +0100
committerunknown <jonas@perch.ndb.mysql.com>2005-12-14 11:34:08 +0100
commited5f4d69bc2d51ad8c99caa1b677a050c536e55c (patch)
tree1b77cc958af0e450485e739522a12fce15740152 /mysql-test/r/ndb_basic.result
parent700e6cbd5ac5436039f4e7969bc97d5fb28cd11d (diff)
parent2c808bed240141a6d35fe4cf49bbf899210d6a77 (diff)
downloadmariadb-git-ed5f4d69bc2d51ad8c99caa1b677a050c536e55c.tar.gz
Merge perch.ndb.mysql.com:/home/jonas/src/mysql-5.0
into perch.ndb.mysql.com:/home/jonas/src/mysql-5.0-push mysql-test/r/ndb_basic.result: Auto merged mysql-test/t/ndb_basic.test: Auto merged ndb/src/kernel/blocks/dbtc/DbtcMain.cpp: Auto merged sql/ha_ndbcluster.cc: Auto merged ndb/src/kernel/vm/SimulatedBlock.cpp: merge
Diffstat (limited to 'mysql-test/r/ndb_basic.result')
-rw-r--r--mysql-test/r/ndb_basic.result16
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/ndb_basic.result b/mysql-test/r/ndb_basic.result
index 55cbbd89b3c..9dd75f1390c 100644
--- a/mysql-test/r/ndb_basic.result
+++ b/mysql-test/r/ndb_basic.result
@@ -677,3 +677,19 @@ select * from atablewithareallylongandirritatingname;
a
2
drop table atablewithareallylongandirritatingname;
+create table t1 (f1 varchar(50), f2 text,f3 int, primary key(f1)) engine=NDB;
+insert into t1 (f1,f2,f3)VALUES("111111","aaaaaa",1);
+insert into t1 (f1,f2,f3)VALUES("222222","bbbbbb",2);
+select * from t1 order by f1;
+f1 f2 f3
+111111 aaaaaa 1
+222222 bbbbbb 2
+select * from t1 order by f2;
+f1 f2 f3
+111111 aaaaaa 1
+222222 bbbbbb 2
+select * from t1 order by f3;
+f1 f2 f3
+111111 aaaaaa 1
+222222 bbbbbb 2
+drop table t1;