jhu-bids / TermHub

Web app and CLI tools for working with biomedical terminologies. https://github.com/orgs/jhu-bids/projects/9/views/7
https://bit.ly/termhub
GNU General Public License v3.0
11 stars 10 forks source link

cset_members_items messed up #946

Closed Sigfried closed 1 week ago

Sigfried commented 1 week ago

Commit fb97061 joined code_sets so it would leave out version_item rows where there's no associated code_set, but it seems to have now left out all codeset_id, concept_id pairs that don't appear in concept_set_members -- that is all exclude expression items (except for one row, which shouldn't actually exist.)

Sigfried commented 1 week ago

I "fixed" it (on granular-caching branch accidentally), but the fix is causing the query to run out of space before completing.

@joeflack4: I'm going to move stuff from cset_members_items_plus to cset_members_items so cset_members_items_plus won't be needed anymore.