diff options
| author | unknown <mskold@mysql.com> | 2005-04-19 11:21:26 +0200 |
|---|---|---|
| committer | unknown <mskold@mysql.com> | 2005-04-19 11:21:26 +0200 |
| commit | fd9d58c413bf9830d9ee23cfdc54784ead768d25 (patch) | |
| tree | 6fab91405563db59e9e31973e23470550e3918ac /mysql-test/t/ndb_update.test | |
| parent | 56ea770272bf6c81873922aa8a0c146f4e9921b0 (diff) | |
| download | mariadb-git-fd9d58c413bf9830d9ee23cfdc54784ead768d25.tar.gz | |
Fix for Bug #9691 UPDATE fails on attempt to update primary key
Diffstat (limited to 'mysql-test/t/ndb_update.test')
| -rw-r--r-- | mysql-test/t/ndb_update.test | 15 |
1 files changed, 13 insertions, 2 deletions
diff --git a/mysql-test/t/ndb_update.test b/mysql-test/t/ndb_update.test index 3b0e84e2344..fc489ec4697 100644 --- a/mysql-test/t/ndb_update.test +++ b/mysql-test/t/ndb_update.test @@ -14,9 +14,20 @@ DROP TABLE IF EXISTS t1; CREATE TABLE t1 ( pk1 INT NOT NULL PRIMARY KEY, b INT NOT NULL, - c INT NOT NULL + c INT NOT NULL UNIQUE ) ENGINE=ndbcluster; -INSERT INTO t1 VALUES (0, 0, 1),(1,1,2),(2,2,3); +INSERT INTO t1 VALUES (0, 1, 0),(1,2,1),(2,3,2); UPDATE t1 set b = c; select * from t1 order by pk1; +UPDATE t1 set pk1 = 4 where pk1 = 1; +select * from t1 order by pk1; +-- error 1062 +UPDATE t1 set pk1 = 1, c = 2 where pk1 = 4; +select * from t1 order by pk1; +UPDATE t1 set pk1 = pk1 + 10; +select * from t1 order by pk1; + +--disable_warnings +DROP TABLE IF EXISTS t1; +--enable_warnings |