Remove check for shortnames/fullnames in probeset metadata query

genenetwork / genenetwork2

GeneNetwork (2nd generation)

http://gn2.genenetwork.org/

GNU Affero General Public License v3.0

34 stars 24 forks source link

Remove check for shortnames/fullnames in probeset metadata query #755

Closed BonfaceKilz closed 1 year ago

BonfaceKilz commented 1 year ago

The InfoFiles tables has 2 unique constraints:

SELECT DISTINCT CONSTRAINT_NAME FROM information_schema.TABLE_CONSTRAINTS WHERE table_name = 'InfoFiles' and constraint_type = 'UNIQUE';

which results in:

InfoPageName
GN_AccesionId

However, shortname/fullname can have NULL values thereby producing errors in some pages that display the probeset data.

BonfaceKilz commented 1 year ago

@zsloan could you merge this as soon as you can?

zsloan commented 1 year ago

Thanks for this change; I was actually just about to look at this myself, since someone had reported an issue with it.

On Wed, Nov 30, 2022 at 7:46 AM BonfaceKilz @.***> wrote:

@zsloan https://github.com/zsloan could you merge this as soon as you can?

— Reply to this email directly, view it on GitHub https://github.com/genenetwork/genenetwork2/pull/755#issuecomment-1332174589, or unsubscribe https://github.com/notifications/unsubscribe-auth/AANQJGC5UAJVODPCI6CK2BDWK5LBPANCNFSM6AAAAAASPUYOKU . You are receiving this because you were mentioned.Message ID: @.***>