Hi Junjun, No probs - running the following queries:
1 - select count(`escell_clone`) from `idcc_targ_rep__idcc_targ_rep__main`
where `pipeline` = "EUCOMM"
2 - select count(`escell_clone`) from `idcc_targ_rep__idcc_targ_rep__main`
where `pipeline` = "KOMP-CSD"
3 - select count(`escell_clone`) from `idcc_targ_rep__idcc_targ_rep__main`
where `pipeline` in ("EUCOMM","KOMP-CSD")
gives:
1 - 76216 (same as the martservice call)
2 - 59486 (same as the martservice call)
3 - 135702 (different to the martservice call)
So the data is there... This must be something in the batching causing the
miss?
Cheers,
Daz
On 4 Feb 2011, at 03:27, Junjun Zhang wrote:
> 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
>
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Users mailing list [email protected] https://lists.biomart.org/mailman/listinfo/users
