[
https://issues.apache.org/jira/browse/CALCITE-3648?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ritesh updated CALCITE-3648:
----------------------------
Description:
[https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html#function_uncompress]
e.g.:
{code:java}
SELECT UNCOMPRESS(COMPRESS('any string'));
-> 'any string'
SELECT UNCOMPRESS('any string');
-> NULL
{code}
Uncompresses a string compressed by the
[{{COMPRESS()}}|https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html#function_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|https://docs.oracle.com/javase/8/docs/api/java/util/zip/Inflater.html]).
Otherwise, the return value is always {{NULL}}.
was:
[https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html#function_uncompress]
e.g.:
{code:java}
SELECT UNCOMPRESS(COMPRESS('any string'));
-> 'any string'
SELECT UNCOMPRESS('any string');
-> NULL
{code}
Uncompresses a string compressed by the
[{{COMPRESS()}}|https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html#function_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}}.
> MySQL UNCOMPRESS function support
> ---------------------------------
>
> Key: CALCITE-3648
> URL: https://issues.apache.org/jira/browse/CALCITE-3648
> Project: Calcite
> Issue Type: Sub-task
> Reporter: Ritesh
> Assignee: Ritesh
> Priority: Major
>
> [https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html#function_uncompress]
> e.g.:
> {code:java}
> SELECT UNCOMPRESS(COMPRESS('any string'));
> -> 'any string'
> SELECT UNCOMPRESS('any string');
> -> NULL
> {code}
> Uncompresses a string compressed by the
> [{{COMPRESS()}}|https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html#function_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|https://docs.oracle.com/javase/8/docs/api/java/util/zip/Inflater.html]).
> Otherwise, the return value is always {{NULL}}.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
