search

fedspendingtransparency / usaspending-api

Server application to serve U.S. federal spending data via a RESTful API
https://www.usaspending.gov
Creative Commons Zero v1.0 Universal
310 stars 113 forks source link

[DEV-10453] Fix table names in new pre FY2008 SQL #4038

Closed aguest-kc closed 8 months ago

aguest-kc commented 8 months ago

Description: Add the schema to the award_search and transaction_search table names in the new SQL.

Technical details: Add the schema to the award_search and transaction_search table names in the new SQL.

Requirements for PR merge:

  1. [ ] Necessary PR reviewers:
    • [ ] Backend
  2. [x] Data validation completed
  3. [x] Jira Ticket DEV-10453:
    • [x] Link to this Pull-Request
    • [x] Performance evaluation of affected (API | Script | Download)
    • [x] Before / After data comparison

Area for explaining above N/A when needed:

1. Unit & integration tests updated
No tests need to be updated for this fix.

2. API documentation updated
No API documentation is affected by this change.

4. Matview impact assessment completed
Matviews are not affected by this change.

5. Frontend impact assessment completed
The frontend is not impacted by this change.

7. Appropriate Operations ticket(s) created
No operations tickets are needed for this fix.