0872 Upgrade Script Produces Paged Output

[Jason Stephenson]

In Evergreen master, the 0872.functions.metarecord-deleted-constituents.sql upgrade script includes a select statement that will produce several thousand rows of pageable output.

If you are running this script in the console and not redirecting your output to a file or another process, the upgrade process will halt as it waits for human input to scroll through the results.

The above is no big deal if you're running just this script by itself, but if you've fired off a loop to run a bunch of upgrade scripts at once and walked away from it, you may be in for a surprise when you return.

I suggest wrapping the select arguments in a count() function to ameliorate the above.

Branch to follow once I have the bug number.

[Jason Stephenson (jstephenson)]

Branch is user/dyrcona/lp1297435_0872_upgrade_patch on the working repo:

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

[Ben Shum (bshum)]

Agreed that this would be nicer for those who upgrade. Picked to master, thanks Jason.