summaryrefslogtreecommitdiff
path: root/mysql-test/r/ndb_replace.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_replace.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_replace.result')
-rw-r--r--mysql-test/r/ndb_replace.result21
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;