[OPEN-ILS-DEV] branch rel_1_6 950.data.seed-values.sql ordering bug

[Lebbeous Fogle-Weekley]

Thanks Don, you're right.

I committed your patch to the rel_1_6 and rel_1_6_1 branches, but I 
defer to Mike "Release" Rylander on what to do with the more specific tags.

Lebbeous


Don McMorris wrote:
> In the branch rel_1_6 version of 950.data.seed-values.sql [1], lines
> 138-142 create the OU setting
> 'circ.booking_reservation.default_elbow_room' via the query:
> 
> INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES (
>            (SELECT id FROM actor.org_unit WHERE parent_ou IS NULL),
>            'circ.booking_reservation.default_elbow_room',
>            '"1 day"'
>        );
> 
> However, it appears that actor.org_unit does not start to get
> populated until line 853.  As such, the "SELECT id FROM actor.org_unit
> WHERE parent_ou IS NULL" portion of the insert will return NULL, and
> actor.org_unit_setting.org_unit has a 'NOT NULL' contraint - as such,
> the insert fails.
> 
> The attached patch moves this chunk down to after the actor.org_unit
> and actor.org_address work, but before the config.* work.
> 
> This bug also exists in branch rel_1_6_1 and tags rel_1_6_1_0 &
> rel_1_6_1_1.  It does not appear to affect branch rel_1_6_0 or any
> tags of rel_1_6_0_x.  It also does not appear to affect trunk (I
> cannot find the string "booking_reservation" in the
> 950.data.seed-values.sql in trunk).
> 
> I've worked around the issue (in a 1.6.1.1 install I'm attempting) by
> simply running the affected chunk by hand after the rest of the
> seeding completes.
> 
> Thanks!
> --Don
> 
> [1]: http://svn.open-ils.org/trac/ILS/browser/branches/rel_1_6/Open-ILS/src/sql/Pg/950.data.seed-values.sql

Please come by and visit the Equinox team and learn more about 
Evergreen, Koha, and open source options
ALA Annual meeting in Washington, DC
June 24-28, 2010
booth # 1303