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

[Edward Kawas]

Sure, the only query is for getting service instance names
right?

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:53 AM
> To: Core developer announcements
> Subject: Re: [MOBY-dev] Re: is findService(0 case
> sensitive?
> 
> Excellent!  Can you look into the adaptor layer (mysql.pm)
> and add the "binary" tag to that query?
> 
> Thanks!
> 
> M
> 
> -----Original Message-----
> From: "Edward Kawas" <edward.kawas at gmail.com>
> Date: Thu, 22 Sep 2005 08:53:13
> To:<markw at illuminae.com>,       "'Core developer
> announcements'" <moby-dev at portal.open-bio.org>
> Subject: RE: [MOBY-dev] Re: is findService(0 case
> sensitive?
> 
> 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
> 
> _______________________________________________
> MOBY-dev mailing list
> MOBY-dev at biomoby.org
> http://www.biomoby.org/mailman/listinfo/moby-dev
> 
> --
> Mark Wilkinson
> ...on the road!
> _______________________________________________
> MOBY-dev mailing list
> MOBY-dev at biomoby.org
> http://www.biomoby.org/mailman/listinfo/moby-dev