diff options
author | Michael Widenius <monty@mariadb.org> | 2018-03-09 14:05:35 +0200 |
---|---|---|
committer | Monty <monty@mariadb.org> | 2018-03-29 13:59:44 +0300 |
commit | a7abddeffa6a760ce948c2dfb007cdf3f1a369d5 (patch) | |
tree | 70eb743fa965a17380bbc0ac88ae79ca1075b896 /mysql-test/t/replace.test | |
parent | ab1941266c59a19703a74b5593cf3f508a5752d7 (diff) | |
download | mariadb-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.test | 47 |
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; |