diff options
| author | evgen@moonbone.local <> | 2005-07-20 06:55:51 +0400 |
|---|---|---|
| committer | evgen@moonbone.local <> | 2005-07-20 06:55:51 +0400 |
| commit | 6b25219feab6fbbf4c03b1f44b04041da5b9b515 (patch) | |
| tree | 0a6e774c5a397c41c20bbea6dc7edf46f843fe1d /mysql-test/r/view.result | |
| parent | ec15dda2bfa246d71a257da2d25c3d398b4d4cc4 (diff) | |
| download | mariadb-git-6b25219feab6fbbf4c03b1f44b04041da5b9b515.tar.gz | |
Fix bug #11760 Typo in Item_func_add_time::print() results in NULLs returned
by subtime() in view
Item_func_add_time::print() were printing arg[0] instead of arg[1] which
results in wrongly created view. Functions addtime() and subtime were
affected by this bug.
Diffstat (limited to 'mysql-test/r/view.result')
| -rw-r--r-- | mysql-test/r/view.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index a132279c6bc..d4b3bfe4ef1 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -2016,3 +2016,11 @@ CALL p1(); DROP PROCEDURE p1; DROP VIEW v1; DROP TABLE t1; +create table t1(f1 datetime); +insert into t1 values('2005.01.01 12:0:0'); +create view v1 as select f1, subtime(f1, '1:1:1') as sb from t1; +select * from v1; +f1 sb +2005-01-01 12:00:00 2005-01-01 10:58:59 +drop view v1; +drop table t1; |