Bug #27981 Typo in the INSERT() function documentation
Submitted: 20 Apr 2007 13:43 Modified: 20 Apr 2007 13:49
Reporter: David Medina Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S4 (Feature request)
Version:5.0 OS:Any
Assigned to: Paul DuBois CPU Architecture:Any

[20 Apr 2007 13:43] David Medina
Description:
I think there's a typo in the INSERT() function documentation (In the MySQL 5.0 Reference Manual which documents MySQL 5.0 to 5.0.34).
[QUOTE]
Replaces the rest of the string from position pos is len is not within the length of the rest of the string.
[/QUOTE]
I really think the "is" after "position pos" is actually "if". I do think so based on an english grammar analysis and based on the INSERT function behaviuor.

How to repeat:
Here's how I analyzed the INSERT() function behaviour.
mysql> SELECT INSERT("peludo",1,4,"pelo");
+-----------------------------+
| INSERT("peludo",1,4,"pelo") |
+-----------------------------+
| pelodo                      |
+-----------------------------+

mysql> SELECT INSERT("peludo",1,40,"pelo");
+------------------------------+
| INSERT("peludo",1,40,"pelo") |
+------------------------------+
| pelo                         |
+------------------------------+

Suggested fix:
Change "is" for "if", just one char.
[20 Apr 2007 13:49] 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.