Bug #87908 Typo in the documentation of VIEW algorithms
Submitted: 29 Sep 2017 8:44 Modified: 29 Sep 2017 8:46
Reporter: Andrey Hristov Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[29 Sep 2017 8:44] Andrey Hristov
Description:
Here (https://dev.mysql.com/doc/refman/5.7/en/view-algorithms.html) you can find the following statement:

SELECT * FROM v_merge WHERE vc1 < 100;

However, the VIEW is defined as:
CREATE ALGORITHM = MERGE VIEW v_merge (vc1, vc2) AS
SELECT c1, c2 FROM t WHERE c3 > 100;

thus there is no vc1 column but c1. There is erroneous additional "v".

How to repeat:
Check the documentation : https://dev.mysql.com/doc/refman/5.7/en/view-algorithms.html
[29 Sep 2017 8:45] Andrey Hristov
oops, need more coffee :)
[29 Sep 2017 8:46] Andrey Hristov
.