diff options
| author | unknown <hf@deer.(none)> | 2005-06-14 17:50:24 +0500 |
|---|---|---|
| committer | unknown <hf@deer.(none)> | 2005-06-14 17:50:24 +0500 |
| commit | 02b1eb988d917d08a94d5e55b7846d6c9d97549e (patch) | |
| tree | fe38792f367e8c74ceff81ffa512e9d66abf8ee8 /mysql-test/r/func_default.result | |
| parent | 0473ce99fa1f9ed6ab2f37a3b043013dcd38c53e (diff) | |
| download | mariadb-git-02b1eb988d917d08a94d5e55b7846d6c9d97549e.tar.gz | |
Addition to fix for bug #11314 (test case wasn't complete)
mysql-test/r/func_default.result:
test result fixed
mysql-test/t/func_default.test:
test case fixed
Diffstat (limited to 'mysql-test/r/func_default.result')
| -rw-r--r-- | mysql-test/r/func_default.result | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/func_default.result b/mysql-test/r/func_default.result index c7483027322..5742ddd102b 100644 --- a/mysql-test/r/func_default.result +++ b/mysql-test/r/func_default.result @@ -16,3 +16,8 @@ explain select * from t1 where str <> default(str); id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 system NULL NULL NULL NULL 1 drop table t1; +CREATE TABLE t1 (id int(11), s varchar(20)); +INSERT INTO t1 VALUES (1, 'one'), (2, 'two'), (3, 'three'); +SELECT s, 32 AS mi FROM t1 GROUP BY s HAVING DEFAULT(mi) IS NULL; +ERROR HY000: Field 'mi' doesn't have a default value +DROP TABLE t1; |