maria-docs team mailing list archive
Mailing list archive
Re: mistake in kb & help tables
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
On 09/10/2013 23:45, Federico Razzoli wrote:
In this KB page:
, 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."
"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?
Mailing list: https://launchpad.net/~maria-docs
Post to : maria-docs@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~maria-docs
More help : https://help.launchpad.net/ListHelp