diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2015-02-20 16:37:02 +0100 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2015-02-22 12:54:52 +0100 |
| commit | 22cf2f117a4d48aeab87aa1bdc63ee2e4b96562e (patch) | |
| tree | e08ab2353a24c7feb339fb09fe7b95194218849f /mysql-test/r/view_alias.result | |
| parent | 2a798cef789e33da9e7df092f4b80c5526b8cdc0 (diff) | |
| download | mariadb-git-22cf2f117a4d48aeab87aa1bdc63ee2e4b96562e.tar.gz | |
MDEV-7482 VIEW containing INTERVAL(...)
Item_func::print() prints itself as name + "(" + arguments + ")".
Normally that works, but Item_func_interval internally implements its
arguments as one single Item_row. Item_row prints itself as
"(" + values + ")". As a result, "INTERVAL(1,2)" was being printed
as "INTERVAL((1,2))". Fixed with a custom Item_func_interval::print().
Diffstat (limited to 'mysql-test/r/view_alias.result')
| -rw-r--r-- | mysql-test/r/view_alias.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/view_alias.result b/mysql-test/r/view_alias.result index 72c4bf29f25..e07b40dba13 100644 --- a/mysql-test/r/view_alias.result +++ b/mysql-test/r/view_alias.result @@ -109,3 +109,11 @@ DROP VIEW v1; CREATE VIEW v1 AS select `test`.`t1`.`a` AS `a` from `test`.`t1` where exists(select ' a ' AS `alias` from `test`.`t1` group by ' a '); DROP VIEW v1; DROP TABLE t1, t2; +create view v1 as select interval(55,10) as my_col; +show create view v1; +View Create View character_set_client collation_connection +v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select interval(55,10) AS `my_col` latin1 latin1_swedish_ci +select * from v1; +my_col +1 +drop view v1; |