Bug #104880 Documentation mistake
Submitted: 9 Sep 2021 8:08 Modified: 9 Sep 2021 16:50
Reporter: Hamid Nazari Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:8 OS:Any
Assigned to: CPU Architecture:Any

[9 Sep 2021 8:08] Hamid Nazari
Description:
The execution time for the sample code is limited to one thousand milliseconds (1s) while the documentation mistakenly specifies "one thousand seconds"

How to repeat:
Refer to this documentation of CTEs:
https://dev.mysql.com/doc/refman/8.0/en/with.html#common-table-expressions-recursion-limit...

The last example in this sub-section is limited to "one thousand milliseconds" of execution time (based on the optimizer hint "MAX_EXECUTION_TIME(1000)"), but the documentation says "Thus, the following CTE terminates after returning ten thousand rows or running for one thousand seconds, whichever occurs first" which is wrong.

Suggested fix:
Change "one thousand seconds" to "one thousand milliseconds" or even simpler to "one second"
[9 Sep 2021 8:17] MySQL Verification Team
Hello Hamid Nazari,

Thank you for the report and feedback.

regards,
Umesh
[9 Sep 2021 16:50] Christine Cole
Posted by developer:
 
Fixed in the MySQL 8.0 Reference Manual.

-   thousand rows or running for one thousand seconds, whichever
-   occurs first:
+   thousand rows or running for one second (1000 milliseconds),
+   whichever occurs first:

Thank you for the bug report!