diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2003-12-13 17:20:35 +0200 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2003-12-13 17:20:35 +0200 |
| commit | 85a4e83e9ae38b19f1e3eda9162203ac45b32ee5 (patch) | |
| tree | a8e36d0cbbc258765abf20de6ce0f9b1bdf5e6df /mysql-test | |
| parent | 18ebd6344003dda25b70fc3921e34867179d3c15 (diff) | |
| download | mariadb-git-85a4e83e9ae38b19f1e3eda9162203ac45b32ee5.tar.gz | |
Already approved bug fix for #1561.
Bug happens in INTERVAL function when number of compared arguments
is 8 or more.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/func_set.result | 6 | ||||
| -rw-r--r-- | mysql-test/t/func_set.test | 5 |
2 files changed, 11 insertions, 0 deletions
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); |