[teiid-issues] [JBoss JIRA] (TEIID-4674) Add encrypt/decrypt functions to pushdown

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4674?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13344202#comment-13344202 ] 

Steven Hawkins commented on TEIID-4674:
---------------------------------------

This will be a low priority.  Our proposed default implementation using an explicit initialization vector will not match the mysql,mariadb, or postgresql behavior.  It probably doesn't match h2 either, but I haven't confirmed that.  We'd either have to support just ECB or allow an initialization vector to be passed - but the later behavior is not supported by h2 and mariadb.  

> Add encrypt/decrypt functions to pushdown
> -----------------------------------------
>
>                 Key: TEIID-4674
>                 URL: https://issues.jboss.org/browse/TEIID-4674
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: JDBC Connector
>    Affects Versions: 9.2
>            Reporter: Kylin Soong
>            Assignee: Kylin Soong
>
> Most RDBMS support encrypt/decrypt functions a key, and the supported algorithm is AES. the block size is 16 bytes, with TEIID-4643,  encrypt/decrypt functions should be pushdown. Below are some links of DB vendor's encrypt/decrypt functions.
> [1] https://dev.mysql.com/doc/refman/5.5/en/encryption-functions.html
> [2] http://www.h2database.com/html/functions.html#encrypt
> [3] https://mariadb.com/kb/en/mariadb/encryption-hashing-and-compression-functions/



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)