I pushed a branch with changes made by Mike Rylander, and added a release note and my signoff.
As mentioned in comment #2 I have not found any other instances of CTEs that require addressing in PostgreSQL 12+.
collab/dyrcona/lp1999274-optimization-fence-for-pg-12-CTEs-in-search
https://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/collab/dyrcona/lp1999274-optimization-fence-for-pg-12-CTEs-in-search
I pushed a branch with changes made by Mike Rylander, and added a release note and my signoff.
As mentioned in comment #2 I have not found any other instances of CTEs that require addressing in PostgreSQL 12+.
collab/ dyrcona/ lp1999274- optimization- fence-for- pg-12-CTEs- in-search
https:/ /git.evergreen- ils.org/ ?p=working/ Evergreen. git;a=shortlog; h=refs/ heads/collab/ dyrcona/ lp1999274- optimization- fence-for- pg-12-CTEs- in-search