maria-docs team mailing list archive

[Ian Gilfillan <launchpad@xxxxxxxxxxxxxx>]

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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-docs
> More help   : https://help.launchpad.net/ListHelp