diff options
| author | jimw@rama.(none) <> | 2006-07-18 16:04:18 -0700 |
|---|---|---|
| committer | jimw@rama.(none) <> | 2006-07-18 16:04:18 -0700 |
| commit | d18eacc71d5c869bec9bcf9e7ba450c721ae3e90 (patch) | |
| tree | 7a901fad8e45dd3cfa24659bf23114d4ef56c2ad /mysql-test/r/join_outer.result | |
| parent | bd183d42dcf66432d2e8051e030919a4669eaf8c (diff) | |
| download | mariadb-git-d18eacc71d5c869bec9bcf9e7ba450c721ae3e90.tar.gz | |
Bug #19498: Inconsistent support for DEFAULT in TEXT columns
When a default of '' was specified for TEXT/BLOB columns, the specification
was silently ignored. This is presumably to be nice to applications (or
people) who generate their column definitions in a not-very-clever fashion.
For clarity, doing this now results in a warning, or an error in strict
mode.
Diffstat (limited to 'mysql-test/r/join_outer.result')
| -rw-r--r-- | mysql-test/r/join_outer.result | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/r/join_outer.result b/mysql-test/r/join_outer.result index eae023813b5..a983b32ba46 100644 --- a/mysql-test/r/join_outer.result +++ b/mysql-test/r/join_outer.result @@ -598,6 +598,8 @@ id int(11) DEFAULT '0' NOT NULL, name tinytext DEFAULT '' NOT NULL, UNIQUE id (id) ); +Warnings: +Warning 1101 BLOB/TEXT column 'name' can't have a default value INSERT INTO t1 VALUES (1,'yes'),(2,'no'); CREATE TABLE t2 ( id int(11) DEFAULT '0' NOT NULL, |