Database org_top() function upgrade script errors

Bug #1810802 reported by Bill Erickson
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Evergreen
Fix Released
High
Unassigned

Bug Description

Related to bug #1730726 (PG 10 support)

PSQL complains when running 1140.function.non-set-returning-evergreen.org_top.sql:

ERROR: cannot change return type of existing function
HINT: Use DROP FUNCTION org_top() first.
ERROR: syntax error at or near ":"
LINE 1: COMMIT:
              ^
ERROR: current transaction is aborted, commands ignored until end of transaction block

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

To test:

1. Check out an older Evergreen revision (e.g. 64607a86) and build a new database.
2. Upgrade the database using the SQL upgrade scripts.
3. Before patching, the upgrade should fail with the errors noted above.

Changed in evergreen:
assignee: Bill Erickson (berick) → nobody
Changed in evergreen:
assignee: nobody → Jason Stephenson (jstephenson)
Revision history for this message
Jason Stephenson (jstephenson) wrote :

Good catch, Bill!

I swear I tested that upgrade script, but I guess not.

I have verified the upgrade script is broken in the manner described, and tested that Bill's fix actually resolves the two issues.

I have signed off and pushed the fix to master.

Changed in evergreen:
status: New → Fix Committed
assignee: Jason Stephenson (jstephenson) → nobody
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.

Other bug subscribers

Remote bug watches

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