diff options
| author | unknown <mskold@mysql.com> | 2005-04-21 10:59:21 +0200 |
|---|---|---|
| committer | unknown <mskold@mysql.com> | 2005-04-21 10:59:21 +0200 |
| commit | a070bb3f855c95c6b528515a87d073a61625a697 (patch) | |
| tree | b16ce65aa6835c4fdaade4753ca171b759befde7 | |
| parent | 98ddcc6fc24a1544d7eb3c8d7d8263292df2a603 (diff) | |
| download | mariadb-git-a070bb3f855c95c6b528515a87d073a61625a697.tar.gz | |
Re-generated
| -rw-r--r-- | mysql-test/r/ndb_update.result | 31 |
1 files changed, 25 insertions, 6 deletions
diff --git a/mysql-test/r/ndb_update.result b/mysql-test/r/ndb_update.result index 121931d79e3..c2247564e65 100644 --- a/mysql-test/r/ndb_update.result +++ b/mysql-test/r/ndb_update.result @@ -2,13 +2,32 @@ 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; pk1 b c -0 1 1 -1 2 2 -2 3 3 -drop table t1; +0 0 0 +1 1 1 +2 2 2 +UPDATE t1 set pk1 = 4 where pk1 = 1; +select * from t1 order by pk1; +pk1 b c +0 0 0 +2 2 2 +4 1 1 +UPDATE t1 set pk1 = 1, c = 2 where pk1 = 4; +ERROR 23000: Duplicate entry '1' for key 1 +select * from t1 order by pk1; +pk1 b c +0 0 0 +2 2 2 +4 1 1 +UPDATE t1 set pk1 = pk1 + 10; +select * from t1 order by pk1; +pk1 b c +10 0 0 +12 2 2 +14 1 1 +DROP TABLE IF EXISTS t1; |