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/fulltext_distinct.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/fulltext_distinct.result')
| -rw-r--r-- | mysql-test/r/fulltext_distinct.result | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/r/fulltext_distinct.result b/mysql-test/r/fulltext_distinct.result index de0668ff28c..7fd42fab646 100644 --- a/mysql-test/r/fulltext_distinct.result +++ b/mysql-test/r/fulltext_distinct.result @@ -8,6 +8,8 @@ KEY kt(tag), KEY kv(value(15)), FULLTEXT KEY kvf(value) ) ENGINE=MyISAM; +Warnings: +Warning 1101 BLOB/TEXT column 'value' can't have a default value CREATE TABLE t2 ( id_t2 mediumint unsigned NOT NULL default '0', id_t1 mediumint unsigned NOT NULL default '0', |