UofS-Pulse-Binfo / rawphenotypes

A Tripal module for storing raw phenotypic data. Specifically meant to help researchers contribute raw data, visualize summaries and download for further analysis.
2 stars 2 forks source link

Make queries more specific; reduce LIMIT 1 #34

Closed laceysanderson closed 6 years ago

laceysanderson commented 6 years ago

While testing the Tripal 3 upgrade, I came across some bugs caused by the use of "LIMIT 1" when pulling out cvterms (#33). Since no ordering is applies, using limit 1 can produce inconsistent results if there are two terms matching the filter criteria. As such, I made these queries more specific and took advantage of database constraints to ensure a unique record is pulled out.

Testing