Bug #87908 Typo in the documentation of VIEW algorithms

• Submitted: 29 Sep 2017 8:44
• Modified: 29 Sep 2017 8:46
• Reporter: Andrey Hristov
• Status: Not a Bug
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• OS: Any
• 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

.