summaryrefslogtreecommitdiff
path: root/mysql-test/r/ndb_basic.result
diff options
context:
space:
mode:
authorunknown <mskold@mysql.com>2005-04-07 19:48:00 +0200
committerunknown <mskold@mysql.com>2005-04-07 19:48:00 +0200
commitdb2f49d35d582b4156b8221523a868a22b8753b5 (patch)
tree43a3181d0cd70fb563b7c1b3fb9168946795d70d /mysql-test/r/ndb_basic.result
parent00d32c6a03cd672c7057ce3ef5a3707512502ec9 (diff)
downloadmariadb-git-db2f49d35d582b4156b8221523a868a22b8753b5.tar.gz
Merge
Diffstat (limited to 'mysql-test/r/ndb_basic.result')
-rw-r--r--mysql-test/r/ndb_basic.result30
1 files changed, 30 insertions, 0 deletions
diff --git a/mysql-test/r/ndb_basic.result b/mysql-test/r/ndb_basic.result
index e1aa045d16e..e10d7e5a095 100644
--- a/mysql-test/r/ndb_basic.result
+++ b/mysql-test/r/ndb_basic.result
@@ -607,3 +607,33 @@ primary key (a))
engine=ndb
max_rows=1;
drop table t1;
+create table t1
+(counter int(64) NOT NULL auto_increment,
+datavalue char(40) default 'XXXX',
+primary key (counter)
+) ENGINE=ndbcluster;
+insert into t1 (datavalue) values ('newval');
+insert into t1 (datavalue) values ('newval');
+select * from t1 order by counter;
+counter datavalue
+1 newval
+2 newval
+insert into t1 (datavalue) select datavalue from t1 where counter < 100;
+select * from t1 order by counter;
+counter datavalue
+1 newval
+2 newval
+3 newval
+4 newval
+insert into t1 (datavalue) select datavalue from t1 where counter < 100;
+select * from t1 order by counter;
+counter datavalue
+1 newval
+2 newval
+3 newval
+4 newval
+35 newval
+36 newval
+37 newval
+38 newval
+drop table t1;