From 35689c09170fbda13140f59e1df56a62455a3977 Mon Sep 17 00:00:00 2001 From: unknown Date: Sat, 13 Dec 2003 17:20:35 +0200 Subject: Already approved bug fix for #1561. Bug happens in INTERVAL function when number of compared arguments is 8 or more. --- mysql-test/r/func_set.result | 6 ++++++ mysql-test/t/func_set.test | 5 +++++ 2 files changed, 11 insertions(+) (limited to 'mysql-test') diff --git a/mysql-test/r/func_set.result b/mysql-test/r/func_set.result index 2a3631140b0..d51bc24112a 100644 --- a/mysql-test/r/func_set.result +++ b/mysql-test/r/func_set.result @@ -50,3 +50,9 @@ id elt(two.val,'one','two') 2 one 4 two drop table t1,t2; +SELECT INTERVAL(13, 7, 14, 21, 28, 35, 42, 49, 56); +INTERVAL(13, 7, 14, 21, 28, 35, 42, 49, 56) +1 +SELECT INTERVAL(13, 7, 14, 21, 28, 35, 42, 49, 56, 77); +INTERVAL(13, 7, 14, 21, 28, 35, 42, 49, 56, 77) +1 diff --git a/mysql-test/t/func_set.test b/mysql-test/t/func_set.test index 7d24140c75d..7a7ad25f9c4 100644 --- a/mysql-test/t/func_set.test +++ b/mysql-test/t/func_set.test @@ -35,3 +35,8 @@ insert into t2 values (1,1),(2,1),(3,1),(4,2); select one.id, elt(two.val,'one','two') from t1 one, t2 two where two.id=one.id; select one.id, elt(two.val,'one','two') from t1 one, t2 two where two.id=one.id order by one.id; drop table t1,t2; + +# some more INTERVAL tests + +SELECT INTERVAL(13, 7, 14, 21, 28, 35, 42, 49, 56); +SELECT INTERVAL(13, 7, 14, 21, 28, 35, 42, 49, 56, 77); -- cgit v1.2.1