outdated version of authority.normalize_heading can be present in certain upgraded databases

[Galen Charlton]

The schema upgrade script 0848.function.authority-sf-file-order-again.sql, which was backported through rel_2_3, can in rel_2_5, rel_2_6, and rel_2_7 effectively rollback a change in that function introduced by 0837.schema.browse-auth-linking.plus-joiner.sql.

Consequently, if applying updates in sequence, if 0837 is applied first, then 0848, a slightly broken version of normalize_heading() will be in place. This will manifest itself by the heading and simple_heading columns in authority.record_entry having "NOHEADING" values regardless of the control set:

-[ RECORD 1 ]--+---------------------------------------------
heading | NOHEADING_a ff0ed9fcd13e8944d9a718650840787a
simple_heading | NOHEADING_a ff0ed9fcd13e8944d9a718650840787a

Evergreen master
Evergreen 2.7.x
Evergreen 2.6.x

[Galen Charlton (gmc)]

A patch to fix this is available in the user/gmcharlt/lp1415572_use_current_normalize_heading branch in the working/Evergreen repository:

http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/gmcharlt/lp1415572_use_current_normalize_heading

I can confirm that as of master commit 609db84, this patch will apply correctly to master, rel_2_7, and rel_2_6. It should NOT be applied without changed if another commit that alters authority.normalize_heading makes it in first.

[Chris Sharp (chrissharp123)]

This fixes an issue I stumbled upon last month: http://irc.evergreen-ils.org/evergreen/2014-12-12#i_144668

Signoff branch at http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/csharp/lp1415572_use_current_normalize_heading_signoff.

Thanks, Galen!

[Ben Shum (bshum)]

Pushed to master, rel_2_7 and rel_2_6.