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 | 89e30e836f72e2637536e667840673c621fcf5a3 (patch) | |
| tree | a0d229445eaa6ae09d57d783d579df95695049bf /mysql-test/t/ndb_basic.test | |
| parent | 49c1ed543d126d8243b8638442028e943cdb0cc4 (diff) | |
| download | mariadb-git-89e30e836f72e2637536e667840673c621fcf5a3.tar.gz | |
Added support for update of pk
Diffstat (limited to 'mysql-test/t/ndb_basic.test')
| -rw-r--r-- | mysql-test/t/ndb_basic.test | 11 |
1 files changed, 8 insertions, 3 deletions
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; |