1 -- source include/have_ndb.inc
2 -- source include/not_embedded.inc
5 DROP TABLE IF EXISTS t1;
6 DROP TABLE IF EXISTS t2;
7 DROP TABLE IF EXISTS t3;
11 # Basic test of UPDATE in NDB
15 # Create a normal table with primary key
18 pk1 INT NOT NULL PRIMARY KEY,
23 INSERT INTO t1 VALUES (0, 1, 0),(1,2,1),(2,3,2);
25 select * from t1 order by pk1;
26 UPDATE t1 set pk1 = 4 where pk1 = 1;
27 select * from t1 order by pk1;
29 UPDATE t1 set pk1 = 4 where pk1 = 2;
30 UPDATE IGNORE t1 set pk1 = 4 where pk1 = 2;
31 select * from t1 order by pk1;
33 UPDATE t1 set pk1 = 1, c = 2 where pk1 = 4;
34 UPDATE IGNORE t1 set pk1 = 1, c = 2 where pk1 = 4;
35 select * from t1 order by pk1;
36 UPDATE t1 set pk1 = pk1 + 10;
37 select * from t1 order by pk1;
39 create unique index ib on t1(b);
40 update t1 set c = 4 where pk1 = 12;
41 update ignore t1 set b = 55 where pk1 = 14;
42 select * from t1 order by pk1;
45 DROP TABLE IF EXISTS t1;
51 # Bug#28158: table->read_set is set incorrectly,
52 # causing wrong error message in Falcon
54 CREATE TABLE t1 (a int, b int, KEY (a, b)) ENGINE=ndbcluster;
55 CREATE TABLE t2 (a int, b int, UNIQUE KEY (a, b)) ENGINE=ndbcluster;
56 CREATE TABLE t3 (a int, b int, PRIMARY KEY (a, b)) ENGINE=ndbcluster;
58 INSERT INTO t1 VALUES (1, 2);
59 INSERT INTO t1 VALUES (2, 2);
61 INSERT INTO t2 VALUES (1, 2);
62 INSERT INTO t2 VALUES (2, 2);
64 INSERT INTO t3 VALUES (1, 2);
65 INSERT INTO t3 VALUES (2, 2);
68 UPDATE t1 SET a = 1 ORDER BY a;
73 UPDATE t2 SET a = 1 ORDER BY a;
78 UPDATE t3 SET a = 1 ORDER BY a;
80 SELECT count(*) FROM t1;
81 SELECT count(*) FROM t2;
82 SELECT count(*) FROM t3;
83 SELECT * FROM t1 ORDER by a;
84 SELECT * FROM t2 ORDER by a;
85 SELECT * FROM t3 ORDER by a;
88 DROP TABLE IF EXISTS t1;
89 DROP TABLE IF EXISTS t2;
90 DROP TABLE IF EXISTS t3;
93 --echo End of 5.1 tests