[RANGER-3581] setup.sh can not "CREATE FUNCTION" on MySQL with Master/Slave profile.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 3.0.0, 2.2.0, 2.3.0
• Component/s: admin
• Assignee: Pradeep Agrawal
• Reporter: kirby zhou
• Created: 11/Jan/22 10:05
• Updated: 26/Jan/22 04:03
• Resolved: 26/Jan/22 04:03

Description

"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), but not statements that write data.

• MODIFIES SQL DATA indicates that the routine contains statements that may write data (for example, INSERT or DELETE).

Our "getXportalUIdByLoginId"  and "getModulesIdByName" is type of "READS SQL DATA".

 

 

 

 

 

Issue Links

• duplicates: RANGER-3594 mysql setup scripts failed with binlog-enabled mysql