Bug #100767 Wrong sintaxe for CASE in the manual
Submitted: 8 Sep 2020 10:47 Modified: 8 Sep 2020 22:08
Reporter: Leite Leonardo Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.6, 5.7, 8.0 OS:Any
Assigned to: Jon Stephens CPU Architecture:Any

[8 Sep 2020 10:47] Leite Leonardo
At https://dev.mysql.com/doc/refman/8.0/en/control-flow-functions.html#operator_case, the syntaxe for CASE are:

1 - CASE value WHEN [compare_value] THEN result [WHEN [compare_value] THEN result ...] [ELSE result] END

2 - CASE WHEN [condition] THEN result [WHEN [condition] THEN result ...] [ELSE result] END

Bot both the compare values from 1 and the conditions from 2 are not optional.

As stated in https://dev.mysql.com/doc/refman/8.0/en/manual-info.html:

In syntax descriptions, square brackets (“[” and “]”) indicate optional words or clauses.

Obs: I couldn't find proper instructions about how to contribute to the documentation.

How to repeat:
It does not apply
[8 Sep 2020 19:19] MySQL Verification Team

Thanks for the report, we'll get the documentation team to better this description.

[8 Sep 2020 22:02] Jon Stephens
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly.
[8 Sep 2020 22:08] Leite Leonardo
Great, thank you!