[MOBY-dev] Re: is findService(0 case sensitive?

[Edward Kawas]

Hi Mark,

I spent a while looking around, but the following query is
case sensitive (tested on our db)

select * from service_instance where servicename LIKE binary
'getProteinSequence';

returns 1 instance

select * from service_instance where servicename LIKE binary
'GetProteinSequence';

returns 1 instance

select * from service_instance where servicename LIKE binary
'getproteinsequence';

returns empty

Eddie
> -----Original Message-----
> From: moby-dev-bounces at portal.open-bio.org [mailto:moby-
> dev-bounces at portal.open-bio.org] On Behalf Of mark
> wilkinson
> Sent: Thursday, September 22, 2005 8:21 AM
> To: Martin Senger; Mark Wilkinson
> Cc: mobydev
> Subject: [MOBY-dev] Re: is findService(0 case sensitive?
> 
> 
> MOBY is intended to be case sensitive.  What you are
> seeing is likely a consequence of mySQL not being case
> sensitive, and moby central not double-checking the output
> of the query.
> 
> That's a frustrating bug, since it means I need to post-
> filter every query :-/
> 
> I wonder if there is a flag in mysql that makes the
> searches case sensitive?
> 
> I'll look into it when I get back to Vancouver.  For the
> moment, code on the assumption that it *is* case
sensitive,
> since that's the intention.
> 
> M
> 
> 
> -----Original Message-----
> From: Martin Senger <senger at ebi.ac.uk>
> Date: Thu, 22 Sep 2005 15:49:59
> To:Mark Wilkinson <markw at illuminae.com>
> Cc:mobydev <moby-dev at biomoby.org>
> Subject: is findService(0 case sensitive?
> 
> Mark,
>    You told me once that everything in Biomoby is case
> sensitive (that was
> in time when I played with idea to allow case
> insensitivness but then
> stepped back because of Blast's secondary parameters 'e'
> and 'E').
>    Now I see that findService seems to be case
insensitive.
> When I ask for
> service getProteinSequence I get two services:
> getProteinSequence and
> GetProteinSequence.
>    So what is true? Whatever it is could you tell us and
> add it to the API
> please?
> 
>    Cheers,
>    Martin
> 
> PS. Pending answer about retrieving namespaces... :-)
> M.
> 
> --
> Martin Senger
>    email: martin.senger at gmail.com
>    skype: martinsenger
> consulting for:
>    International Rice Research Institute
>    Biometrics and Bioinformatics Unit
>    DAPO BOX 7777, Metro Manila
>    Philippines, phone: +63-2-580-5600 (ext.2324)
> 
> 
> --
> Mark Wilkinson
> ...on the road!
> _______________________________________________
> MOBY-dev mailing list
> MOBY-dev at biomoby.org
> http://www.biomoby.org/mailman/listinfo/moby-dev