diff options
| author | mskold@mysql.com <> | 2005-04-19 11:21:26 +0200 |
|---|---|---|
| committer | mskold@mysql.com <> | 2005-04-19 11:21:26 +0200 |
| commit | 4193a314fb264f257b15d2d0d36eddae0c5e4d5b (patch) | |
| tree | 6fab91405563db59e9e31973e23470550e3918ac /mysql-test/t/ndb_update.test | |
| parent | 384efc449398925cca78d5fe98d3ac53e3b6aa6d (diff) | |
| download | mariadb-git-4193a314fb264f257b15d2d0d36eddae0c5e4d5b.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 |