Bug #37058 "help is" in mysql missing select statement
Submitted: 29 May 2008 9:19 Modified: 29 May 2008 16:04
Reporter: Janek Bogucki Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:008-05-23 10:25 fill_help_tables-5.0.sql OS:Linux (Kubuntu 8.04)
Assigned to: Paul DuBois CPU Architecture:Any

[29 May 2008 9:19] Janek Bogucki 
Description:
In the mysql monitor there is a select statement missing in the examples section.

mysql> help is
Name: 'IS'
Description:
Syntax:
IS boolean_value

Tests a value against a boolean value, where boolean_value can be TRUE,
FALSE, or UNKNOWN.

URL: http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html

Examples:
mysql> SELECT 1 IS TRUE, 0 IS FALSE, NULL IS UNKNOWN;
        -> 1, 1, 1
        -> 1, 1, 0

How to repeat:
Type "help is". Compare the number of example statements to the number of results sets.
[29 May 2008 13:16] MySQL Verification Team 
Thank you for the bug report. Verified as described.
[29 May 2008 16:04] Paul DuBois 
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.

The problem actually was not a missing SELECT, it was an extraneous output line. The second output line goes with the IS NOT operator. (The two used to be described together; when they were separated, I forgot to delete the line from the IS description.)