diff options
| author | mskold@mysql.com <> | 2004-07-02 11:50:28 +0200 |
|---|---|---|
| committer | mskold@mysql.com <> | 2004-07-02 11:50:28 +0200 |
| commit | c708619d0b4a3faa58504c3509c69d6390a80361 (patch) | |
| tree | a0d229445eaa6ae09d57d783d579df95695049bf /mysql-test | |
| parent | 5e6a1a89ef679a241616d28413fa09808577db11 (diff) | |
| download | mariadb-git-c708619d0b4a3faa58504c3509c69d6390a80361.tar.gz | |
Added support for update of pk
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/ndb_basic.result | 16 | ||||
| -rw-r--r-- | mysql-test/t/ndb_basic.test | 11 |
2 files changed, 21 insertions, 6 deletions
diff --git a/mysql-test/r/ndb_basic.result b/mysql-test/r/ndb_basic.result index 0e7b039a5f9..56b2d2fb0f7 100644 --- a/mysql-test/r/ndb_basic.result +++ b/mysql-test/r/ndb_basic.result @@ -3,25 +3,35 @@ CREATE TABLE t1 ( pk1 INT NOT NULL PRIMARY KEY, attr1 INT NOT NULL ) ENGINE=ndbcluster; -INSERT INTO t1 VALUES (9410,9412); +INSERT INTO t1 VALUES (9410,9412),(9411,9413); SELECT pk1 FROM t1; pk1 9410 +9411 SELECT * FROM t1; pk1 attr1 9410 9412 +9411 9413 SELECT t1.* FROM t1; pk1 attr1 9410 9412 +9411 9413 UPDATE t1 SET attr1=1 WHERE pk1=9410; SELECT * FROM t1; pk1 attr1 9410 1 +9411 9413 UPDATE t1 SET pk1=2 WHERE attr1=1; -ERROR 42000: Table 't1' uses an extension that doesn't exist in this MySQL version SELECT * FROM t1; pk1 attr1 -9410 1 +2 1 +9411 9413 +UPDATE t1 SET pk1=2 WHERE attr1=9413; +ERROR 23000: Can't write; duplicate key in table 't1' +SELECT * FROM t1; +pk1 attr1 +2 1 +9411 9413 DELETE FROM t1; SELECT * FROM t1; pk1 attr1 diff --git a/mysql-test/t/ndb_basic.test b/mysql-test/t/ndb_basic.test index 271357ed561..ed13b36bf16 100644 --- a/mysql-test/t/ndb_basic.test +++ b/mysql-test/t/ndb_basic.test @@ -17,7 +17,7 @@ CREATE TABLE t1 ( attr1 INT NOT NULL ) ENGINE=ndbcluster; -INSERT INTO t1 VALUES (9410,9412); +INSERT INTO t1 VALUES (9410,9412),(9411,9413); SELECT pk1 FROM t1; SELECT * FROM t1; @@ -27,11 +27,16 @@ SELECT t1.* FROM t1; UPDATE t1 SET attr1=1 WHERE pk1=9410; SELECT * FROM t1; -# Can't UPDATE PK! Test that correct error is returned --- error 1112 +# Update pk UPDATE t1 SET pk1=2 WHERE attr1=1; SELECT * FROM t1; +# Try to set same pk +# 1022: Can't write; duplicate key in table 't1' +-- error 1022 +UPDATE t1 SET pk1=2 WHERE attr1=9413; +SELECT * FROM t1; + # Delete the record DELETE FROM t1; SELECT * FROM t1; |