diff options
| author | unknown <jani@rhols221.adsl.netsonic.fi> | 2004-01-28 19:02:58 +0200 |
|---|---|---|
| committer | unknown <jani@rhols221.adsl.netsonic.fi> | 2004-01-28 19:02:58 +0200 |
| commit | 7d9cb93730a4798635c797c090a439c2709ceae7 (patch) | |
| tree | 810f9d3e1a3840ae3e385e969f92345c45bb916d /mysql-test/r/func_test.result | |
| parent | b025e53584e087c8cb60aa0c0d56aa0feb8a7e72 (diff) | |
| download | mariadb-git-7d9cb93730a4798635c797c090a439c2709ceae7.tar.gz | |
Fixed a bug in GREATES() and LEAST() function, that caused a core
dump when result was NULL.
mysql-test/r/func_test.result:
Added a test for GREATEST() and LEAST() core dump bug.
mysql-test/t/func_test.test:
Added a test for GREATEST() and LEAST() core dump bug.
Diffstat (limited to 'mysql-test/r/func_test.result')
| -rw-r--r-- | mysql-test/r/func_test.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/func_test.result b/mysql-test/r/func_test.result index 4bb2e067f9c..7d0a76424fe 100644 --- a/mysql-test/r/func_test.result +++ b/mysql-test/r/func_test.result @@ -165,3 +165,9 @@ SELECT f_acc.rank, a1.rank, a2.rank FROM t1 LEFT JOIN t1 f1 ON (f1.access_id=1 rank rank rank 2 2 NULL DROP TABLE t1,t2; +CREATE TABLE t1 (d varchar(6), k int); +INSERT INTO t1 VALUES (NULL, 2); +SELECT GREATEST(d,d) FROM t1 WHERE k=2; +GREATEST(d,d) +NULL +DROP TABLE t1; |