Hi Daz, It looks like there are rows missed in the third query, the one with both items selected in the dropdown list.
Can you try to run all the three SQL queries directly against mysql db? This time do it in one sql statement without 'limit' at all. Now compare the above results with what you get through biomart (where single query breaks into multiple sql queries). Let us know what you get. Junjun From: Darren Oakley [mailto:[email protected]] Sent: Thursday, February 03, 2011 08:53 AM To: Junjun Zhang Cc: Syed Haider; [email protected] <[email protected]> Subject: Re: [BioMart Users] Fwd: Weird issue with multi-select filter Hi Junjun, Unfortunately that didn't give me anything to go on... :( [ do2@guest178 ~/projects/personal-scripts/biomart ] sort EUCOMM.txt | uniq -d [ do2@guest178 ~/projects/personal-scripts/biomart ] sort KOMP-CSD.txt | uniq -d [ do2@guest178 ~/projects/personal-scripts/biomart ] sort TWO-FILTERS.txt | uniq -d [ do2@guest178 ~/projects/personal-scripts/biomart ] sort DIFF.txt | uniq -d [ do2@guest178 ~/projects/personal-scripts/biomart ] wc -l *.txt 5760 DIFF.txt 76216 EUCOMM.txt 59486 KOMP-CSD.txt 129942 TWO-FILTERS.txt [ do2@guest178 ~/projects/personal-scripts/biomart ] I've attached the output files I get: EUCOMM.txt - query with only the "EUCOMM" filter KOMP-CSD.txt - query with only the "KOMP-CSD" filter TWO-FILTERS.txt - query with both "EUCOMM" and "KOMP-CSD" selected in the multi-select DIFF.txt - what I have determined is missing from the TWO-FILTERS.txt response (weirdly, these all fall into the KOMP-CSD pipeline - could this mean anything?) Cheers, Daz
_______________________________________________ Users mailing list [email protected] https://lists.biomart.org/mailman/listinfo/users
