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 | 96abffd4a4d6562a2cf3e0b55eb2c478739e3083 (patch) | |
| tree | 810f9d3e1a3840ae3e385e969f92345c45bb916d /mysql-test/t/func_test.test | |
| parent | d01e81012876416b3691a513a13af26d13d2f307 (diff) | |
| download | mariadb-git-96abffd4a4d6562a2cf3e0b55eb2c478739e3083.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/t/func_test.test')
| -rw-r--r-- | mysql-test/t/func_test.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/func_test.test b/mysql-test/t/func_test.test index 1559fef7e6e..0d055549866 100644 --- a/mysql-test/t/func_test.test +++ b/mysql-test/t/func_test.test @@ -85,3 +85,11 @@ CREATE TABLE t2 ( access_id smallint(6) NOT NULL default '0', name varchar(20 INSERT INTO t2 VALUES (1,'Everyone',2),(2,'Help',3),(3,'Customer Support',1); SELECT f_acc.rank, a1.rank, a2.rank FROM t1 LEFT JOIN t1 f1 ON (f1.access_id=1 AND f1.faq_group_id = t1.faq_group_id) LEFT JOIN t2 a1 ON (a1.access_id = f1.access_id) LEFT JOIN t1 f2 ON (f2.access_id=3 AND f2.faq_group_id = t1.faq_group_id) LEFT JOIN t2 a2 ON (a2.access_id = f2.access_id), t2 f_acc WHERE LEAST(a1.rank,a2.rank) = f_acc.rank; DROP TABLE t1,t2; + +# +# Test for GREATEST() and LEAST() bug, which segfaulted 4.1.1 server +# +CREATE TABLE t1 (d varchar(6), k int); +INSERT INTO t1 VALUES (NULL, 2); +SELECT GREATEST(d,d) FROM t1 WHERE k=2; +DROP TABLE t1; |