LP1937294: Fix Sample Data Load Predictability Issue
authorJason Stephenson <jason@sigio.com>
Mon, 15 Nov 2021 19:21:17 +0000 (14:21 -0500)
committerMike Rylander <mrylander@gmail.com>
Mon, 10 Jan 2022 14:54:45 +0000 (09:54 -0500)
commit83aa058f6dcf5dfe946cf5a5ddd6dbfc7ae1aae5
tree63de83ceb4f9af123c851e017021d7535b8fe7a2
parent24ad912e86aa920534d469c3615c56615cd68af7
LP1937294: Fix Sample Data Load Predictability Issue

Add "ORDER BY id" to the main queries in the functions used to create
call numbers and copies when loading the sample data.  This change
allows the call numbers and copies to be created in a predictable
manner.

The necessity of this change was revealed by the failure of the
20-hold-targeter.t Perl live test on PostgreSQL 11+.  After this
change, that test passes on newer PostgreSQL versions and continues to
pass on PostgreSQL 10.

Signed-off-by: Jason Stephenson <jason@sigio.com>
Signed-off-by: Mike Rylander <mrylander@gmail.com>
Open-ILS/tests/datasets/sql/env_create.sql