- status: open --> accepted
Database list in search submission differentiates between sdb_username = NULL and sdb_username = "", so that the list of Public Databases is not displayed alphabetically if this value is inconsistent in seq_databases table. Either enforce one of them in seq_databases table, or fix DBIx query to treat these values equally.
Minor issue as can be fixed by admin with a single query for all existing dbs.
DBIx value insert behaviour seems inconsistent (may just not have understood correctly, but a perl undef should yield MySQL null, while a perl "" should yield MySQL ""; this does not appear to be the case when running /script/add_public_database.pl)
Anonymous