diff options
| author | Georgi Kodinov <Georgi.Kodinov@Oracle.com> | 2010-08-13 16:05:46 +0300 |
|---|---|---|
| committer | Georgi Kodinov <Georgi.Kodinov@Oracle.com> | 2010-08-13 16:05:46 +0300 |
| commit | 8b25c0e4dc6cb18de7ce4be25eb49c44eeab35cf (patch) | |
| tree | cee46d5fbf50847d147c9723e7461a8f9cd4eab3 /mysql-test/r/func_sapdb.result | |
| parent | 41cfa3e76966b55b8a5354f0d0b57ce624a8c95c (diff) | |
| download | mariadb-git-8b25c0e4dc6cb18de7ce4be25eb49c44eeab35cf.tar.gz | |
Bug #55565: debug assertion when ordering by expressions with user
variable assignments
The assert() that is firing is checking if expressions that can't be
null return a NULL when evaluated.
MAKEDATE() function can return NULL if the second argument is
less then or equal to 0. Thus its nullability depends not only on
the nullability of its arguments but also on their values.
Fixed by (overoptimistically) setting MAKEDATE() to be nullable
despite the nullability of its arguments.
Test added.
Had to update one test result to reflect the metadata change.
Diffstat (limited to 'mysql-test/r/func_sapdb.result')
| -rw-r--r-- | mysql-test/r/func_sapdb.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/func_sapdb.result b/mysql-test/r/func_sapdb.result index bbc5390895b..87b88692a34 100644 --- a/mysql-test/r/func_sapdb.result +++ b/mysql-test/r/func_sapdb.result @@ -194,7 +194,7 @@ date("1997-12-31 23:59:59.000001") as f8, time("1997-12-31 23:59:59.000001") as f9; describe t1; Field Type Null Key Default Extra -f1 date NO 0000-00-00 +f1 date YES NULL f2 datetime YES NULL f3 time YES NULL f4 time YES NULL |