Evergreen

Concerto survey data fails to bump sequences

Bug #1863929 reported by Bill Erickson
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Evergreen
Fix Released
Low
Unassigned
Evergreen 3.4.3

Bug Description

Evergreen 3.4

The sample SQL dataset for Evergreen includes a file at Open-ILS/tests/datasets/sql/survey.sql which adds surveys, questions, and answers to the database for testing. During insert, hard-coded ID values are used, but with the exception of survey answers, the sequences for those IDs are not manually raised to accommodate the slots taken by the manual inserts.

This leads to failures inserting survey data in databases containing concerto / sample SQL data.

Revision history for this message
Chris Sharp (chrissharp123) wrote :

Pushed a fix for this at https://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/csharp/lp1863929_setval_survey_tables.

tags: added: pullrequest
Bill Erickson (berick)
Changed in evergreen:
assignee: nobody → Bill Erickson (berick)
Revision history for this message
Bill Erickson (berick) wrote :

Thanks, Chris. As discussed in IRC, I bumped the sequence values up to 100 to create some extra space for future sample data.

Merged to 3.4 and up.

Changed in evergreen:
milestone: none → 3.4.3
status: New → Fix Committed
assignee: Bill Erickson (berick) → nobody
Evergreen Bug Maintenance (bugmaster)
Changed in evergreen:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.