Bug #109070 Nonsensical sentence in "Restrictions on Views": "MySQL as quickly as possible."
Submitted: 12 Nov 2022 17:10 Modified: 16 Nov 2022 15:08
Reporter: Jan Piotrowski Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.7 / 5.6 / 8.0 OS:Any
Assigned to: CPU Architecture:Any

[12 Nov 2022 17:10] Jan Piotrowski
Description:
https://dev.mysql.com/doc/refman/8.0/en/view-restrictions.html, "25.9 Restrictions on Views" 

A paragraph in the middle of this page has the nonsensical sentence "MySQL as quickly as possible." in between 2 useful sentences: https://dev.mysql.com/doc/refman/8.0/en/view-restrictions.html#:~:text=With%20regard%20to,....

Here is the full paragraph:

> With regard to view updatability, the overall goal for views is that if any view is theoretically updatable, it should be updatable in practice. _MySQL as quickly as possible._ Many theoretically updatable views can be updated now, but limitations still exist. For details, see Section 25.5.3, “Updatable and Insertable Views”.

This also applies to the older versions of the page for 5.7 and 5.6: https://dev.mysql.com/doc/refman/5.6/en/view-restrictions.html + https://dev.mysql.com/doc/refman/5.7/en/view-restrictions.html

How to repeat:
Go to page, scroll to paragraph, observe sentence in middle of paragraph that makes no sense.

Suggested fix:
Remove that sentence completely.
[14 Nov 2022 13:13] MySQL Verification Team
Hi Mr. Piotrowski,

Thank you for your documentation bug report.

However, we think that "as quickly as possible" is the right wording .... The only possible improvement could be to change it to "as soon as possible", but that is not sufficiently different.

It actually corresponds to the truth .... Namely, MySQL attends to that task without waiting for any other event. I hope you see that it is sufficiently correct .......

Hence, what would be your proposal , your new wording and your justification for the change.
[14 Nov 2022 21:31] Jan Piotrowski
I don't know what the sentence should express, as it is missing a verb. There is also nothing from the context of the two sentences before and after that imply that anything should happy in any way fast or quickly - so to me it seems like the sentence carries no information at all and can just be removed.

J
[15 Nov 2022 13:01] MySQL Verification Team
Hi Mr. Piotrowski,

If we are understanding you correctly, you are here only reporting a grammatical error. 

Is that correct ??????
[15 Nov 2022 13:51] MySQL Verification Team
Hi Mr. Piotrowski,

Your findings were true and totally correct.

Our documentation is already updated and on-line Manual will be updated in couple of weeks.

Thank you for your contribution.
[15 Nov 2022 16:01] Jan Piotrowski
That is for you to decide.

I am reporting that the sentence is grammatically incorrect, and does not make sense in the context it is used. I do not know what it was/is supposed to mean and express. You potentially can find out via looking at the history of the document or ask the person that introduced this sentence.
[15 Nov 2022 17:03] Jan Piotrowski
Ah only saw your second reply now - thanks!
[15 Nov 2022 17:09] Jan Piotrowski
Just saw that the bug ticket here was created for 5.7 only - not that this also is present in the 5.6 and 8.0 documentation.
[16 Nov 2022 12:02] MySQL Verification Team
Hi,

5.6 is not maintained any more, and 5.7 means that it affects that version and all higher versions.
[16 Nov 2022 15:08] Jan Piotrowski
Ah thanks, I did not know that.

"not maintained any more" means that grammatical fixes like these are also not applied to the docs? Ok.

J