MySQL Bugs: #13888: Missing infos in the documentation about CREATE VIEW

Bug #13888	Missing infos in the documentation about CREATE VIEW
Submitted:	10 Oct 2005 7:02	Modified:	21 Nov 2005 19:16
Reporter:	Bugs System	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.0.13	OS:	n/a
Assigned to:	Paul DuBois	CPU Architecture:	Any

Description:
CREATE ALGORITHM=UNDEFINED VIEW `test` AS select 1 AS `1`;

SHOW CREATE VIEW `test?` returns:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `test` AS select 1 AS `1`;

In the documentations I can't locate any note about "DEFINER" and "SQL SECURITY DEFINER".

How to repeat:
CREATE ALGORITHM=UNDEFINED VIEW `test` AS select 1 AS `1`;

SHOW CREATE VIEW `test?`;

Suggested fix:
Write additional informations into the manual.

It looks like a request to the Documentation Team, but let me check.

The developers are not interessed about our bug messages.

What do you mean, "not interested"?

We're tired about a lot of discussions if a bug exists or not. More than 90 % of our bug reports were real existsing bugs.

We're tired that some members of the MySQL thinks it's our job to discribe how to reproduce a bug - each small notice should be welcomed. After we wrote a small notice we expect the MySQL team tries to hunt the bug further more - without additional help from us.

We're tired that some members of the MySQL are unhappy about bug messages - we miss a respect of our work (locating and reporting the bugs).

We're tired not to discuss with really developers.

We're tired about waiting for fixes.

Bug messages are presents. Some of your guys doesn't know and respect our presents...

Because of this we will not longer bother that guys with our bug messages...

Thank you for your bug report. This issue has been addressed in the
documentation. The updated documentation will appear on our website
shortly, and will be included in the next release of the relevant
product(s).