diff options
| author | unknown <mskold@mysql.com> | 2004-07-02 11:50:28 +0200 |
|---|---|---|
| committer | unknown <mskold@mysql.com> | 2004-07-02 11:50:28 +0200 |
| commit | 8ad0e2a2b5998dde6b8b518334aa0e850c41d507 (patch) | |
| tree | a0d229445eaa6ae09d57d783d579df95695049bf /mysql-test/r/ndb_basic.result | |
| parent | 1ed75f56798fcd13137c92809fea04b949535de4 (diff) | |
| download | mariadb-git-8ad0e2a2b5998dde6b8b518334aa0e850c41d507.tar.gz | |
Added support for update of pk
Diffstat (limited to 'mysql-test/r/ndb_basic.result')
| -rw-r--r-- | mysql-test/r/ndb_basic.result | 16 |
1 files changed, 13 insertions, 3 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 |