[#MDEV-7482] VIEW containing INTERVAL(...)

[root@kc1060 ~]# mysql -u root

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 804

Server version: 10.0.15-MariaDB-log MariaDB Server

Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use test;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

MariaDB [test]> SELECT INTERVAL(55,10) AS my_col;

+--------+

| my_col |

+--------+

|      1 |

+--------+

1 row in set (0.01 sec)

MariaDB [test]> CREATE OR REPLACE VIEW v1 AS SELECT INTERVAL(55,10) AS my_col;

Query OK, 0 rows affected (0.03 sec)

MariaDB [test]> SHOW CREATE VIEW v1;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS `my_col`' at line 1

MariaDB [test]> SELECT * FROM v1;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS `my_col`' at line 1

[MDEV-7482] VIEW containing INTERVAL(...) Created: 2015-01-20 Updated: 2015-02-22 Resolved: 2015-02-20
Status:	Closed
Project:	MariaDB Server
Component/s:	Views
Affects Version/s:	5.1.67, 5.2.14, 5.3.12, 5.5, 10.0
Fix Version/s:	10.0.17

[MDEV-7482] VIEW containing INTERVAL(...) Created: 2015-01-20 Updated: 2015-02-22 Resolved: 2015-02-20