Red Hat Bugzilla – Bug 123448
dbchange does not handle triggers and stored procs
Last modified: 2007-10-23 22:13:30 EDT
Description of problem:
The dbchange script parses scripts into individual statements by
semicolons. This does not work for triggers and stored procs which do
contain semicolons within their definition.
# How was this issue addressed?
Function _parse_procs was added to DBChange.pm.
# What level of users are affected? (Such as, All, Mgmt. Satellite
only, Mgmt. Satellite and Proxy, Mon. Satellite only, Mon. Satellite
RHN Dept/DBA who have used the dbchange tools.
# Where specifically can the change be seen?
Not visible in an app.
# If the change cannot be verified visually, how should it be tested?
Use the dbchange tool to insert stored procedures, functions,
triggers, and packages into a test database.
Peter also added some code to support anonymous procedures.
Nick has built an rpm which has been released to
rhn/build/support-rhel3/RPMS. Moving to ON_DEV status.