From 06eaf7232e9a920468c0f8d74dcf2fe8b555501c Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 14:24:36 +0200 Subject: Adding upstream version 1:10.11.6. Signed-off-by: Daniel Baumann --- mysql-test/main/replace.test | 47 ++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 47 insertions(+) create mode 100644 mysql-test/main/replace.test (limited to 'mysql-test/main/replace.test') diff --git a/mysql-test/main/replace.test b/mysql-test/main/replace.test new file mode 100644 index 00000000..3f2569b0 --- /dev/null +++ b/mysql-test/main/replace.test @@ -0,0 +1,47 @@ +# +# Test of REPLACE with MyISAM and HEAP +# + +--disable_warnings +drop table if exists t1; +--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) +); + +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); +alter table t1 engine=heap; +replace into t1 (gesuchnr,benutzer_id) values (1,1); +drop table t1; + +# +# Test when using replace on a key that has used up it's whole range +# + +create table t1 (a tinyint not null auto_increment primary key, b char(20) default "default_value"); +insert into t1 values (126,"first"),(63, "middle"),(0,"last"); +--error HA_ERR_AUTOINC_ERANGE +insert into t1 values (0,"error"); +--error HA_ERR_AUTOINC_ERANGE +replace into t1 values (0,"error"); +replace into t1 values (126,"first updated"); +replace into t1 values (63,default); +select * from t1; +drop table t1; + +# End of 4.1 tests + +# +# Bug#19789: REPLACE was allowed for a VIEW with CHECK OPTION enabled. +# +CREATE TABLE t1 (f1 INT); +CREATE VIEW v1 AS SELECT f1 FROM t1 WHERE f1 = 0 WITH CHECK OPTION; +--error 1369 +REPLACE INTO v1 (f1) VALUES (1); +DROP TABLE t1; +DROP VIEW v1; -- cgit v1.2.3