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_replace.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_replace.result')
-rw-r--r-- | mysql-test/r/ndb_replace.result | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/r/ndb_replace.result b/mysql-test/r/ndb_replace.result new file mode 100644 index 00000000000..7c10101ff2e --- /dev/null +++ b/mysql-test/r/ndb_replace.result @@ -0,0 +1,21 @@ +drop table if exists t1; +CREATE TABLE t1 ( +gesuchnr int(11) DEFAULT '0' NOT NULL, +benutzer_id int(11) DEFAULT '0' NOT NULL, +PRIMARY KEY (gesuchnr,benutzer_id) +) engine=ndbcluster; +replace into t1 (gesuchnr,benutzer_id) values (2,1); +replace into t1 (gesuchnr,benutzer_id) values (1,1); +replace into t1 (gesuchnr,benutzer_id) values (1,1); +insert into t1 (gesuchnr, benutzer_id) value (3,2); +replace into t1 (gesuchnr,benutzer_id) values (1,1); +replace into t1 (gesuchnr,benutzer_id) values (1,1); +insert into t1 (gesuchnr,benutzer_id) values (1,1); +ERROR 23000: Can't write, duplicate key in table 't1' +replace into t1 (gesuchnr,benutzer_id) values (1,1); +select * from t1 order by gesuchnr; +gesuchnr benutzer_id +1 1 +2 1 +3 2 +drop table t1; |