diff options
| author | mskold@mysql.com <> | 2004-07-09 13:18:56 +0200 |
|---|---|---|
| committer | mskold@mysql.com <> | 2004-07-09 13:18:56 +0200 |
| commit | bddd075d7336b8647ca4c6f1286bef452a397e3f (patch) | |
| tree | 0b9b03df5d23044bba237d027b8fd502f64d1dc9 /mysql-test/r/ndb_basic.result | |
| parent | 496ad0c3d7c1e56f5c36fb1bf1d654205f31dccd (diff) | |
| download | mariadb-git-bddd075d7336b8647ca4c6f1286bef452a397e3f.tar.gz | |
Fixed bug #4106 and removed buggy pk update
Diffstat (limited to 'mysql-test/r/ndb_basic.result')
| -rw-r--r-- | mysql-test/r/ndb_basic.result | 16 |
1 files changed, 3 insertions, 13 deletions
diff --git a/mysql-test/r/ndb_basic.result b/mysql-test/r/ndb_basic.result index 56b2d2fb0f7..0e7b039a5f9 100644 --- a/mysql-test/r/ndb_basic.result +++ b/mysql-test/r/ndb_basic.result @@ -3,35 +3,25 @@ CREATE TABLE t1 ( pk1 INT NOT NULL PRIMARY KEY, attr1 INT NOT NULL ) ENGINE=ndbcluster; -INSERT INTO t1 VALUES (9410,9412),(9411,9413); +INSERT INTO t1 VALUES (9410,9412); 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 -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 +9410 1 DELETE FROM t1; SELECT * FROM t1; pk1 attr1 |