diff options
Diffstat (limited to 'mysql-test/suite/ndb/t/ndb_update.test')
-rw-r--r-- | mysql-test/suite/ndb/t/ndb_update.test | 41 |
1 files changed, 41 insertions, 0 deletions
diff --git a/mysql-test/suite/ndb/t/ndb_update.test b/mysql-test/suite/ndb/t/ndb_update.test new file mode 100644 index 00000000000..73a0ebc69cb --- /dev/null +++ b/mysql-test/suite/ndb/t/ndb_update.test @@ -0,0 +1,41 @@ +-- source include/have_ndb.inc +-- source include/not_embedded.inc + +--disable_warnings +DROP TABLE IF EXISTS t1; +--enable_warnings + +# +# Basic test of INSERT in NDB +# + +# +# Create a normal table with primary key +# +CREATE TABLE t1 ( + pk1 INT NOT NULL PRIMARY KEY, + b INT NOT NULL, + c INT NOT NULL UNIQUE +) ENGINE=ndbcluster; + +INSERT INTO t1 VALUES (0, 1, 0),(1,2,1),(2,3,2); +UPDATE t1 set b = c; +select * from t1 order by pk1; +UPDATE t1 set pk1 = 4 where pk1 = 1; +select * from t1 order by pk1; +--error ER_DUP_ENTRY +UPDATE t1 set pk1 = 4 where pk1 = 2; +UPDATE IGNORE t1 set pk1 = 4 where pk1 = 2; +select * from t1 order by pk1; +--error ER_DUP_ENTRY +UPDATE t1 set pk1 = 1, c = 2 where pk1 = 4; +UPDATE IGNORE t1 set pk1 = 1, c = 2 where pk1 = 4; +select * from t1 order by pk1; +UPDATE t1 set pk1 = pk1 + 10; +select * from t1 order by pk1; + +--disable_warnings +DROP TABLE IF EXISTS t1; +--enable_warnings + +# End of 4.1 tests |