diff options
| author | unknown <mskold@mysql.com> | 2006-06-21 09:36:50 +0200 |
|---|---|---|
| committer | unknown <mskold@mysql.com> | 2006-06-21 09:36:50 +0200 |
| commit | aedbb330c8243867cbb95c6cf31096811ba5d8f3 (patch) | |
| tree | 0d04d914a5045446ce185cfc302111c974d1c7c0 /mysql-test/r/ndb_replace.result | |
| parent | 3f19b05bb00366df88d72f9b6507f897f2f9370b (diff) | |
| download | mariadb-git-aedbb330c8243867cbb95c6cf31096811ba5d8f3.tar.gz | |
Fix for Bug #19906 REPLACE doesn't update TEXT fields correctly
Diffstat (limited to 'mysql-test/r/ndb_replace.result')
| -rw-r--r-- | mysql-test/r/ndb_replace.result | 23 |
1 files changed, 22 insertions, 1 deletions
diff --git a/mysql-test/r/ndb_replace.result b/mysql-test/r/ndb_replace.result index 5d772620b2c..cdfcd6a7a43 100644 --- a/mysql-test/r/ndb_replace.result +++ b/mysql-test/r/ndb_replace.result @@ -1,4 +1,4 @@ -drop table if exists t1; +drop table if exists t1,t2; CREATE TABLE t1 ( gesuchnr int(11) DEFAULT '0' NOT NULL, benutzer_id int(11) DEFAULT '0' NOT NULL, @@ -31,3 +31,24 @@ SELECT * from t1 ORDER BY i; i j k 3 1 42 17 2 24 +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; +a b c x y z id i +1 1 1 c c c 3 3 +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; +a b c x y z id i +1 1 1 b b b 5 2 +DROP TABLE t2; |