Bug #612 Compress()/Uncompress() functions exists in docs; doesn't work in product

• Submitted: 6 Jun 2003 10:00
• Modified: 6 Jun 2003 11:02
• Reporter: Edward Leafe
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 3.23.53 / 4.1.0-alpha-max-nt
• OS: Linux (Linux / Win2K)
• CPU Architecture: Any

[6 Jun 2003 10:00] Edward Leafe

Description:
In the online docs, there is a page at http://www.mysql.com/doc/en/
Miscellaneous_functions.html#IDX1353. It lists two functions: Compress() and Uncompress(), along 
with examples of their use. I tried the firest example on my Linux server, which is running 3.23.53:

select length(compress(repeat("a",1000)));

but received the error: "You have an error in your SQL syntax near '( repeat(  "a", 1000  )  )  )' at line 
1"

I thought this might be a recent addition, so I tried it on my Windows machine that has 4.0 on it. It 
failed the same way. I then upgraded the Windows machine to the 4.1 alpha, thinking that it must 
be really new, but still got the same error.

Is this a doc error, or do these functions actually exist?

How to repeat:
Run any of the examples for Compress() listed at http://www.mysql.com/doc/en/
Miscellaneous_functions.html#IDX1353

Suggested fix:
Change the docs, or add the functions! (preferably the latter!)

[6 Jun 2003 11:02] Indrek Siitan

Thanks for pointing this out. These functions were just recently 
added and will appear in the upcoming 4.1.1, but looks like the 
version note is missing from the manual. We'll fix the manual 
right now, and with the next 4.1 release, the functionality will 
be fixed as well. :)