From 3f619478f796eddbba6e39502fe941b285dd97b1 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 20:00:34 +0200 Subject: Adding upstream version 1:10.11.6. Signed-off-by: Daniel Baumann --- mysql-test/main/replace.result | 32 ++++++++++++++++++++++++++++++++ 1 file changed, 32 insertions(+) create mode 100644 mysql-test/main/replace.result (limited to 'mysql-test/main/replace.result') diff --git a/mysql-test/main/replace.result b/mysql-test/main/replace.result new file mode 100644 index 00000000..9590a97e --- /dev/null +++ b/mysql-test/main/replace.result @@ -0,0 +1,32 @@ +drop table if exists t1; +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; +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"); +insert into t1 values (0,"error"); +ERROR 22003: Out of range value for column 'a' at row 1 +replace into t1 values (0,"error"); +ERROR 22003: Out of range value for column 'a' at row 1 +replace into t1 values (126,"first updated"); +replace into t1 values (63,default); +select * from t1; +a b +126 first updated +63 default_value +127 last +drop table t1; +CREATE TABLE t1 (f1 INT); +CREATE VIEW v1 AS SELECT f1 FROM t1 WHERE f1 = 0 WITH CHECK OPTION; +REPLACE INTO v1 (f1) VALUES (1); +ERROR 44000: CHECK OPTION failed `test`.`v1` +DROP TABLE t1; +DROP VIEW v1; -- cgit v1.2.3