diff options
| author | unknown <mskold@mysql.com> | 2004-07-09 13:18:56 +0200 |
|---|---|---|
| committer | unknown <mskold@mysql.com> | 2004-07-09 13:18:56 +0200 |
| commit | db9d4730f77dceb9adc5d57db9375450e0efd30d (patch) | |
| tree | 0b9b03df5d23044bba237d027b8fd502f64d1dc9 /mysql-test/t/ndb_basic.test | |
| parent | 768c6df57f81f5341cbb6874723d93db411e839a (diff) | |
| download | mariadb-git-db9d4730f77dceb9adc5d57db9375450e0efd30d.tar.gz | |
Fixed bug #4106 and removed buggy pk update
Diffstat (limited to 'mysql-test/t/ndb_basic.test')
| -rw-r--r-- | mysql-test/t/ndb_basic.test | 11 |
1 files changed, 3 insertions, 8 deletions
diff --git a/mysql-test/t/ndb_basic.test b/mysql-test/t/ndb_basic.test index ed13b36bf16..271357ed561 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),(9411,9413); +INSERT INTO t1 VALUES (9410,9412); SELECT pk1 FROM t1; SELECT * FROM t1; @@ -27,16 +27,11 @@ SELECT t1.* FROM t1; UPDATE t1 SET attr1=1 WHERE pk1=9410; SELECT * FROM t1; -# Update pk +# Can't UPDATE PK! Test that correct error is returned +-- error 1112 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; |