summaryrefslogtreecommitdiff
path: root/mysql-test/r/ndb_index_unique.result
diff options
context:
space:
mode:
authorunknown <magnus@neptunus.(none)>2004-05-11 10:40:48 +0200
committerunknown <magnus@neptunus.(none)>2004-05-11 10:40:48 +0200
commitcc7353f58b257e9b499212947d9f24b5484dcbaf (patch)
tree71248616c5d0727c46bb959a55fbb4df21eb202c /mysql-test/r/ndb_index_unique.result
parent5b92b23bbf77f8984c9e1309f516bb6820b9cbce (diff)
downloadmariadb-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.result12
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);