diff options
author | unknown <magnus@neptunus.(none)> | 2004-05-11 10:40:48 +0200 |
---|---|---|
committer | unknown <magnus@neptunus.(none)> | 2004-05-11 10:40:48 +0200 |
commit | cc7353f58b257e9b499212947d9f24b5484dcbaf (patch) | |
tree | 71248616c5d0727c46bb959a55fbb4df21eb202c /mysql-test/r/ndb_index_unique.result | |
parent | 5b92b23bbf77f8984c9e1309f516bb6820b9cbce (diff) | |
download | mariadb-git-cc7353f58b257e9b499212947d9f24b5484dcbaf.tar.gz |
Updated ndb_* test cases
Added two new, ndb_replace and ndb_minmax
mysql-test/r/ndb_index.result:
Disable query, since index used is case sensitive
mysql-test/r/ndb_index_ordered.result:
Correct faulty CREATE TABLE statement
mysql-test/r/ndb_index_unique.result:
Correct faulty CREATE TABLE statement
mysql-test/t/ndb_index.test:
Disable query, since index used is case sensitive
mysql-test/t/ndb_index_ordered.test:
Correct faulty CREATE TABLE statement
mysql-test/t/ndb_index_unique.test:
Correct faulty CREATE TABLE statement
Diffstat (limited to 'mysql-test/r/ndb_index_unique.result')
-rw-r--r-- | mysql-test/r/ndb_index_unique.result | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/r/ndb_index_unique.result b/mysql-test/r/ndb_index_unique.result index 59ff07fffda..71e0f414d52 100644 --- a/mysql-test/r/ndb_index_unique.result +++ b/mysql-test/r/ndb_index_unique.result @@ -32,13 +32,13 @@ INSERT INTO t1 VALUES (8,'dummy'); CREATE TABLE t2 ( cid bigint(20) unsigned NOT NULL auto_increment, cap varchar(255) NOT NULL default '', -PRIMARY KEY (cid), +PRIMARY KEY (cid) ) engine=ndbcluster; CREATE TABLE t3 ( gid bigint(20) unsigned NOT NULL auto_increment, gn varchar(255) NOT NULL default '', must tinyint(4) default NULL, -PRIMARY KEY (gid), +PRIMARY KEY (gid) ) engine=ndbcluster; INSERT INTO t3 VALUES (1,'V1',NULL); CREATE TABLE t4 ( @@ -46,7 +46,7 @@ uid bigint(20) unsigned NOT NULL default '0', gid bigint(20) unsigned NOT NULL, rid bigint(20) unsigned NOT NULL default '-1', cid bigint(20) unsigned NOT NULL default '-1', -UNIQUE KEY m (uid,gid,rid,cid), +UNIQUE KEY m (uid,gid,rid,cid) ) engine=ndbcluster; INSERT INTO t4 VALUES (1,1,2,4); INSERT INTO t4 VALUES (1,1,2,3); @@ -55,14 +55,14 @@ INSERT INTO t4 VALUES (1,1,10,8); CREATE TABLE t5 ( rid bigint(20) unsigned NOT NULL auto_increment, rl varchar(255) NOT NULL default '', -PRIMARY KEY (rid), +PRIMARY KEY (rid) ) engine=ndbcluster; CREATE TABLE t6 ( uid bigint(20) unsigned NOT NULL auto_increment, un varchar(250) NOT NULL default '', uc smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (uid), -UNIQUE KEY nc (un,uc), +UNIQUE KEY nc (un,uc) ) engine=ndbcluster; INSERT INTO t6 VALUES (1,'test',8); INSERT INTO t6 VALUES (2,'test2',9); @@ -73,7 +73,7 @@ uid bigint(20) unsigned NOT NULL default '0', gid bigint(20) unsigned NOT NULL, rid bigint(20) unsigned NOT NULL default '-1', cid bigint(20) unsigned NOT NULL default '-1', -UNIQUE KEY m (uid,gid,rid,cid), +UNIQUE KEY m (uid,gid,rid,cid) ) engine=ndbcluster; INSERT INTO t7 VALUES(1, 1, 1, 1, 1); INSERT INTO t7 VALUES(2, 2, 1, 1, 1); |