Ticket #169 (new defect)
Opened 7 weeks ago
Error on baseline installation - Stored Procedures?
| Reported by: | dbs | Owned by: | ojacobson |
|---|---|---|---|
| Priority: | major | Milestone: | CONGO 2.1.0 |
| Component: | Database Layer | Version: | 2.0 |
| Keywords: | Cc: |
Description
org.springframework.beans.factory.BeanCreationException?: Error creating bean with name 'com.stonekeep.congo.database.OptionalSpringLiquibase?#0' defined in ServletContext? resource /WEB-INF/databaseInstallation.xml: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException?: Migration failed for change set classpath:/com/stonekeep/congo/structs/stored-procedures.changelog.xml::get_person_prop::dbs:
Reason: liquibase.exception.JDBCException: Error executing SQL CREATE FUNCTION get_person_prop (v_rid INT, v_cid INT, v_pname VARCHAR(100))
RETURNS VARCHAR(100)
BEGIN
DECLARE ret_val VARCHAR(100);
SELECT prop_value INTO ret_val
FROM reg_properties
WHERE prop_rid = v_rid
AND prop_cid = v_cid
AND prop_name = v_pname;
IF (ret_val IS NULL) THEN
SELECT prop_value INTO ret_val
FROM reg_properties
WHERE prop_rid = v_rid
AND prop_cid = 0
AND prop_name = v_pname;
END IF;
RETURN ret_val;
END:
Caused By: Error executing SQL CREATE FUNCTION get_person_prop (v_rid INT, v_cid INT, v_pname VARCHAR(100))
RETURNS VARCHAR(100)
BEGIN
DECLARE ret_val VARCHAR(100);
SELECT prop_value INTO ret_val
FROM reg_properties
WHERE prop_rid = v_rid
AND prop_cid = v_cid
AND prop_name = v_pname;
IF (ret_val IS NULL) THEN
SELECT prop_value INTO ret_val
FROM reg_properties
WHERE prop_rid = v_rid
AND prop_cid = 0
AND prop_name = v_pname;
END IF;
RETURN ret_val;
END:
Caused By: 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)
