maria-docs team mailing list archive

[Federico Razzoli <federico_raz@xxxxxxxx>]

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