summaryrefslogtreecommitdiff
path: root/mysql-test/t/replace.test
diff options
context:
space:
mode:
authorMichael Widenius <monty@mariadb.org>2018-03-09 14:05:35 +0200
committerMonty <monty@mariadb.org>2018-03-29 13:59:44 +0300
commita7abddeffa6a760ce948c2dfb007cdf3f1a369d5 (patch)
tree70eb743fa965a17380bbc0ac88ae79ca1075b896 /mysql-test/t/replace.test
parentab1941266c59a19703a74b5593cf3f508a5752d7 (diff)
downloadmariadb-git-a7abddeffa6a760ce948c2dfb007cdf3f1a369d5.tar.gz
Create 'main' test directory and move 't' and 'r' there
Diffstat (limited to 'mysql-test/t/replace.test')
-rw-r--r--mysql-test/t/replace.test47
1 files changed, 0 insertions, 47 deletions
diff --git a/mysql-test/t/replace.test b/mysql-test/t/replace.test
deleted file mode 100644
index 3f2569b0c62..00000000000
--- a/mysql-test/t/replace.test
+++ /dev/null
@@ -1,47 +0,0 @@
-#
-# 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;