diff options
| author | unknown <hf@deer.mysql.r18.ru> | 2003-01-22 20:08:12 +0400 |
|---|---|---|
| committer | unknown <hf@deer.mysql.r18.ru> | 2003-01-22 20:08:12 +0400 |
| commit | c73e02756f3f08e1c1decd903aa7a1052ba231a3 (patch) | |
| tree | e6c817b6f680cd04d4a4d3cbea3962d434941db7 /mysql-test/r/replace.result | |
| parent | 96b86dcc9a1e87f01f73186308e8c35f6f900452 (diff) | |
| download | mariadb-git-c73e02756f3f08e1c1decd903aa7a1052ba231a3.tar.gz | |
SCRUM
DEFAULT in SELECT & UPDATE corrections
mysql-test/r/replace.result:
test slightly extended
mysql-test/t/replace.test:
test slightly extended with replace(default)
sql/item.cc:
DEFAULT_ITEM replaced
sql/item.h:
some modifications after talking with Sergey
Diffstat (limited to 'mysql-test/r/replace.result')
| -rw-r--r-- | mysql-test/r/replace.result | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/mysql-test/r/replace.result b/mysql-test/r/replace.result index 0aa80e18ccc..4a71428b2f4 100644 --- a/mysql-test/r/replace.result +++ b/mysql-test/r/replace.result @@ -12,15 +12,17 @@ replace into t1 (gesuchnr,benutzer_id) values (1,1); alter table t1 type=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)); -insert into t1 values (126,"first"),(0,"last"); +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"); Duplicate entry '127' for key 1 replace into t1 values (0,"error"); Duplicate entry '127' for key 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; |