[ https://issues.apache.org/jira/browse/RANGER-3587?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pradeep Agrawal resolved RANGER-3587. ------------------------------------- Assignee: Pradeep Agrawal Resolution: Cannot Reproduce > Failed to apply 046*.sql patch > ------------------------------ > > Key: RANGER-3587 > URL: https://issues.apache.org/jira/browse/RANGER-3587 > Project: Ranger > Issue Type: Bug > Components: admin > Affects Versions: 2.1.0 > Reporter: Bhavik Patel > Assignee: Pradeep Agrawal > Priority: Blocker > > [JISQL] /usr/java/latest/bin/java -cp > /opt/tusker/ranger-admin/ranger-2.1.0-1-admin/ews/lib/mysql-connector-java-5.1.25.jar:/opt/tusker/ranger-admin/ranger-2.1.0-1-admin/jisql/lib/* > org.apache.util.sql.Jisql -driver mysqlconj -cstring > jdbc:mysql://localhost.visa.com/ranger_admin -u 'rangeradmin' -p '********' > -noheader -trim -c \; -input > /opt/tusker/ranger-admin/ranger-2.1.0-1-admin/db/mysql/patches/046-insert-statename-in-x-ranger-global-state.sql > Error executing: CREATE FUNCTION `getXportalUIdByLoginId`(input_val > VARCHAR(100)) RETURNS int(11) BEGIN DECLARE myid INT; SELECT x_portal_user.id > into myid FROM x_portal_user WHERE x_portal_user.login_id = input_val; RETURN > myid; END > java.sql.SQLException: This function has none of DETERMINISTIC, NO SQL, or > READS SQL DATA in its declaration and binary logging is enabled (you *might* > want to use the less safe log_bin_trust_function_creators variable) > SQLException : SQL state: HY000 java.sql.SQLException: This function has none > of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary > logging is enabled (you *might* want to use the less safe > log_bin_trust_function_creators variable) ErrorCode: 1418 > > Note: mysql version is 5.7.35 -- This message was sent by Atlassian Jira (v8.20.1#820001)