diff options
| author | unknown <evgen@moonbone.local> | 2005-07-20 06:59:31 +0400 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2005-07-20 06:59:31 +0400 |
| commit | 038631da3b8cb818f363ae5ee26f9a5822f55949 (patch) | |
| tree | b87fd3070d6bdad70d1db71a1d4a6c083346c4cb /mysql-test/r/view.result | |
| parent | 9142113cea3c4366074ed9fca69416270e03d586 (diff) | |
| parent | c816f2971322803bbdbbe5b92a17c892ddd51ced (diff) | |
| download | mariadb-git-038631da3b8cb818f363ae5ee26f9a5822f55949.tar.gz | |
Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-5.0
into moonbone.local:/work/mysql-5.0-bug-11760
mysql-test/r/view.result:
Auto merged
mysql-test/t/view.test:
Auto merged
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 624fae4d728..c8078a0604e 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; |