diff options
author | unknown <mskold@mysql.com> | 2005-04-07 19:48:00 +0200 |
---|---|---|
committer | unknown <mskold@mysql.com> | 2005-04-07 19:48:00 +0200 |
commit | db2f49d35d582b4156b8221523a868a22b8753b5 (patch) | |
tree | 43a3181d0cd70fb563b7c1b3fb9168946795d70d /mysql-test/r/ndb_basic.result | |
parent | 00d32c6a03cd672c7057ce3ef5a3707512502ec9 (diff) | |
download | mariadb-git-db2f49d35d582b4156b8221523a868a22b8753b5.tar.gz |
Merge
Diffstat (limited to 'mysql-test/r/ndb_basic.result')
-rw-r--r-- | mysql-test/r/ndb_basic.result | 30 |
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; |