[ 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)