Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.1.67, 5.2.14, 5.3.12, 5.5(EOL), 10.0(EOL)
Description
This bug is the same as below and was fixed in MySQL 5.7.0
http://bugs.mysql.com/bug.php?id=45346
http://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-0.html
It still occurs in Maria though.
[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
|