summaryrefslogtreecommitdiff
path: root/mysql-test/r/func_date_add.result
diff options
context:
space:
mode:
authorunknown <lars/lthalmann@dl145h.mysql.com>2007-06-05 01:15:07 +0200
committerunknown <lars/lthalmann@dl145h.mysql.com>2007-06-05 01:15:07 +0200
commit20e331961b2ec797ce8a4acd9c0724bb118f20c4 (patch)
treef59ef1650029ff1634fb8e8539ee2dd41dcb8872 /mysql-test/r/func_date_add.result
parentc5558be0e3d5fe8be0f5a63551a5215511a265e0 (diff)
parent15d18a98e4e2917ac98ffbc807afd09c934dc6fb (diff)
downloadmariadb-git-20e331961b2ec797ce8a4acd9c0724bb118f20c4.tar.gz
Merge mysql.com:/nfsdisk1/lars/bkroot/mysql-5.1-new-rpl
into mysql.com:/nfsdisk1/lars/MERGE/mysql-5.1-merge mysql-test/t/func_misc.test: Auto merged sql/field.cc: Auto merged sql/item_create.cc: Auto merged sql/log_event.cc: Auto merged sql/log_event.h: Auto merged sql/mysqld.cc: Auto merged sql/sp_head.cc: Auto merged sql/sp_head.h: Auto merged sql/sql_base.cc: Auto merged sql/sql_class.cc: Auto merged sql/sql_class.h: Auto merged sql/sql_insert.cc: Auto merged sql/sql_lex.cc: Auto merged sql/sql_lex.h: Auto merged sql/sql_update.cc: Auto merged sql/sql_view.cc: Auto merged strings/ctype-ujis.c: Auto merged
Diffstat (limited to 'mysql-test/r/func_date_add.result')
-rw-r--r--mysql-test/r/func_date_add.result11
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/func_date_add.result b/mysql-test/r/func_date_add.result
index ac5709260fd..a7f2383848d 100644
--- a/mysql-test/r/func_date_add.result
+++ b/mysql-test/r/func_date_add.result
@@ -84,4 +84,15 @@ CAST('2006-09-26' AS DATE) + INTERVAL 1 YEAR
SELECT CAST('2006-09-26' AS DATE) + INTERVAL 1 WEEK;
CAST('2006-09-26' AS DATE) + INTERVAL 1 WEEK
2006-10-03
+create table t1 (a int, b varchar(10));
+insert into t1 values (1, '2001-01-01'),(2, '2002-02-02');
+select '2007-01-01' + interval a day from t1;
+'2007-01-01' + interval a day
+2007-01-02
+2007-01-03
+select b + interval a day from t1;
+b + interval a day
+2001-01-02
+2002-02-04
+drop table t1;
End of 5.0 tests