Postgres 10 support: Vandelay Edition
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
Fix Released
|
Medium
|
Unassigned |
Bug Description
While doing some local testing on PG 10 a batch of records was run through the Vandelay importer and we were presented with this lovely log entry:
...ERROR: set-returning functions are not allowed in CASE at character 554
...HINT: You might be able to move the set-returning function into a LATERAL FROM item.
...
...CONTEXT: PL/pgSQL function vandelay.
And if you look at vandelay.
Changed in evergreen: | |
assignee: | nobody → Jason Stephenson (jstephenson) |
Changed in evergreen: | |
assignee: | Jason Stephenson (jstephenson) → nobody |
milestone: | none → 3.3.1 |
importance: | Undecided → Medium |
status: | New → Confirmed |
Changed in evergreen: | |
status: | Fix Committed → Fix Released |
Speaking of: /git.evergreen- ils.org/ ?p=working/ Evergreen. git;a=shortlog; h=refs/ heads/user/ jboyer/ lp1820339_ pg10_vandelay / working/ user/jboyer/ lp1820339_ pg10_vandelay
https:/
To test: install Evergreen on a system running Pg 10, try to import a record using a match set.
Pre-patch: Sadness.
Apply patch and repeat
Post patch: Less sadness as the import process completes successfully depending on selections made.