[ 
https://issues.apache.org/jira/browse/CALCITE-2460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16851178#comment-16851178
 ] 

Julian Hyde commented on CALCITE-2460:
--------------------------------------

Per my reading of 
https://dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_from-base64,
 FROM_BASE64 may return NULL even if its argument is NOT NULL. (If the argument 
is not a valid base64 string.) This is a little unusual, so be sure to test.

TO_BASE64 is more usual: its return is NOT NULL if and only if its argument is 
NOT NULL.

> Add implementation of To_Base64 to SqlFunctions
> -----------------------------------------------
>
>                 Key: CALCITE-2460
>                 URL: https://issues.apache.org/jira/browse/CALCITE-2460
>             Project: Calcite
>          Issue Type: Improvement
>            Reporter: vinoyang
>            Priority: Minor
>              Labels: pull-request-available
>          Time Spent: 2h
>  Remaining Estimate: 0h
>
> refer to mysql TO_BASE64 function : 
> [https://dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_to-base64]



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to