[
https://issues.apache.org/jira/browse/RANGER-3581?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
kirby zhou updated RANGER-3581:
-------------------------------
Attachment: 0001-add-FUNCTION-description-for-mysql-master-slave.patch
> setup.sh can not "CREATE FUNCTION" on MySQL with Master/Slave profile.
> ----------------------------------------------------------------------
>
> Key: RANGER-3581
> URL: https://issues.apache.org/jira/browse/RANGER-3581
> Project: Ranger
> Issue Type: Bug
> Components: kms
> Affects Versions: 3.0.0, 2.2.0, 2.3.0
> Reporter: kirby zhou
> Priority: Major
> Attachments:
> 0001-add-FUNCTION-description-for-mysql-master-slave.patch
>
>
> "CREATE FUNCTION" in MySQL requires extra characteristics informaion.
> Otherwise, it refused to create it with Master/Slave profile.
> * {{CONTAINS SQL}} indicates that the routine does not contain statements
> that read or write data. This is the default if none of these characteristics
> is given explicitly. Examples of such statements are {{SET @x = 1}} or {{{}DO
> RELEASE_LOCK('abc'){}}}, which execute but neither read nor write data.
> * {{NO SQL}} indicates that the routine contains no SQL statements.
> * {{READS SQL DATA}} indicates that the routine contains statements that
> read data (for example,
> [{{SELECT}}|https://dev.mysql.com/doc/refman/8.0/en/select.html]), but not
> statements that write data.
> * {{MODIFIES SQL DATA}} indicates that the routine contains statements that
> may write data (for example,
> [{{INSERT}}|https://dev.mysql.com/doc/refman/8.0/en/insert.html] or
> [{{DELETE}}|https://dev.mysql.com/doc/refman/8.0/en/delete.html]).
> Our "getXportalUIdByLoginId" and "getModulesIdByName" is type of "{{{}READS
> SQL DATA{}}}".
>
>
>
>
>
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
