Hi all In this KB page: https://mariadb.com/kb/en/create-view
, I just changed this statement: "This same principle applies to options such as ALL, DISTINCT, or SQL_SMALL_RESULT that follow the SELECT keyword, and to clauses such as INTO, FOR UPDATE, LOCK IN SHARE MODE, and PROCEDURE." to: "This same principle applies to options such as ALL, DISTINCT, or SQL_SMALL_RESULT that follow the SELECT keyword, and to clauses such as INTO, FOR UPDATE, and LOCK IN SHARE MODE. The PROCEDURE clause cannot be used in a view definition, and it cannot be used if a view is referenced in the FROM clause." I verified this on 5.5: MariaDB [test]> CREATE OR REPLACE VIEW v AS SELECT * FROM t PROCEDURE analyse(); ERROR 1350 (HY000): View's SELECT contains a 'PROCEDURE' clause MariaDB [test]> CREATE OR REPLACE VIEW v AS SELECT * FROM t; Query OK, 0 rows affected (0.72 sec) MariaDB [test]> SELECT * FROM v PROCEDURE analyse(); ERROR 1221 (HY000): Incorrect usage of PROCEDURE and view However, the error is also in the HELP tables. Should I file a bug in JIRA, or is a mail in "maria-docs" enough? Regards Federico _______________________________________________ Mailing list: https://launchpad.net/~maria-docs Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-docs More help : https://help.launchpad.net/ListHelp
