ndb_replace.test 1.81 KB
Newer Older
1
-- source include/have_ndb.inc
2
-- source include/not_embedded.inc
3 4 5 6 7 8

#
# Test of REPLACE with NDB
#

--disable_warnings
9
drop table if exists t1,t2;
10 11 12 13 14 15 16 17 18 19 20 21 22 23
--enable_warnings

CREATE TABLE t1 (
  gesuchnr int(11) DEFAULT '0' NOT NULL,
  benutzer_id int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (gesuchnr,benutzer_id)
) engine=ndbcluster;

replace into t1 (gesuchnr,benutzer_id) values (2,1);
replace into t1 (gesuchnr,benutzer_id) values (1,1);
replace into t1 (gesuchnr,benutzer_id) values (1,1);
insert into t1 (gesuchnr, benutzer_id) value (3,2);
replace into t1 (gesuchnr,benutzer_id) values (1,1);
replace into t1 (gesuchnr,benutzer_id) values (1,1);
24
--error 1062
25 26 27 28
insert into t1 (gesuchnr,benutzer_id) values (1,1);
replace into t1 (gesuchnr,benutzer_id) values (1,1);
select * from t1 order by gesuchnr;
drop table t1;
29

30 31
# End of 4.1 tests

32 33 34 35 36 37 38 39 40 41 42
# bug#17431
CREATE TABLE t1(i INT PRIMARY KEY AUTO_INCREMENT, 
                j INT, 
                k INT, 
                UNIQUE INDEX(j)
               ) ENGINE = ndb;
INSERT  INTO t1 VALUES (1,1,23),(2,2,24);
REPLACE INTO t1 (j,k) VALUES (1,42);
REPLACE INTO t1 (i,j) VALUES (17,2);
SELECT * from t1 ORDER BY i;

43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67
# bug#19906
CREATE TABLE t2 (a INT(11) NOT NULL,
	         b INT(11) NOT NULL,
                 c INT(11) NOT NULL,
                 x TEXT,
                 y TEXT,
                 z TEXT,
                 id INT(10) unsigned NOT NULL AUTO_INCREMENT,
                 i INT(11) DEFAULT NULL,
                 PRIMARY KEY (id),
                 UNIQUE KEY a (a,b,c)
) ENGINE=ndbcluster;

REPLACE INTO t2 (a,b,c,x,y,z,i) VALUES (1,1,1,'a','a','a',1),(1,1,1,'b','b','b',2), (1,1,1,'c','c','c',3);

SELECT * FROM t2 ORDER BY id;

REPLACE INTO t2(a,b,c,x,y,z,i) values (1,1,1,'a','a','a',1);
REPLACE INTO t2(a,b,c,x,y,z,i) values (1,1,1,'b','b','b',2);

SELECT * FROM t2 ORDER BY id;

DROP TABLE t2;