kirby zhou created RANGER-3581:
----------------------------------
Summary: 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: 2.2.0, 3.0.0, 2.3.0
Reporter: kirby zhou
"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)
