[CALCITE-3648] MySQL UNCOMPRESS function support

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: pull-request-available
• Assignee: Ritesh
• Reporter: Ritesh
• Created: 30/Dec/19 06:16
• Updated: 14/Apr/20 10:03

Description

https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html#function_uncompress

e.g.:

SELECT UNCOMPRESS(COMPRESS('any string'));
        -> 'any string'
SELECT UNCOMPRESS('any string');
        -> NULL

Uncompresses a string compressed by the COMPRESS() function. If the argument is not a compressed value, the result is NULL. This function uses zlib library for decompression (https://docs.oracle.com/javase/8/docs/api/java/util/zip/Inflater.html). Otherwise, the return value is always NULL.

Issue Links

• links to: GitHub Pull Request #1865