Thanks for explaining this. The long-term plan looks interesting. May I help somehow? Federico ----- Messaggio originale ----- Da: Ian Gilfillan <launchpad@greenman.co.za> A: maria-docs@lists.launchpad.net Cc: Inviato: Lunedì 14 Ottobre 2013 18:06 Oggetto: Re: [Maria-docs] mistake in kb & help tables Hi Federico Thanks for the KB fix. The HELP content comes from fill_help_tables.sql, which is generated by MySQL from their documentation, so you should file a bug on their side. I've already adapted the file to replace the MySQL URL's in the HELP with links to our own knowlegebase, but I'm not sure when this will be included in a MariaDB release. A longer-term plan with the HELP is to generate it all from MariaDB's knowledgebase. ian On 09/10/2013 23:45, Federico Razzoli wrote:
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 : maria-docs@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-docs More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-docs Post to : maria-docs@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-docs More help : https://help.launchpad.net/ListHelp