AQL vs. tags beginning with a digit

Dave Matthews matthews at greengenes.cit.cornell.edu
Tue Aug 26 07:07:28 EST 2003


Hi Keith,

> If it is a number-related problem, you could maybe check by
> writing an AQL query against the '2_point' tag in the ?Rearrangement
> class.

Good test.  Yes that fails too. 
"select R from R in class Rearrangement where exists_tag R->2_point" gives 
"AQL error 700 around: '_tag R->2_point"

Positive controls:

1.
"select R from R in class Rearrangement where exists_tag R->pos_neg_data"
works fine.

2.
In the Wormbase Query Language Search, 
http://www.wormbase.org/db/searches/wb_query, "find rearrangement 2_point"
works fine.

> If you still get a bug, then this should be enough info for the
> acedb guys to track it down 

Hope so!

cheers,
- Dave


> To: bionet-software-acedb at net.bio.net
> From: Keith Bradnam <krb at sanger.ac.uk>
> Subject:  Re: AQL vs. tags beginning with a digit
> To: Dave Matthews <matthews at greengenes.cit.cornell.edu>
> Date: Wed, 20 Aug 2003 16:57:32 +0100 (BST)
> 
> On 13 Aug 2003, Dave Matthews wrote:
> 
> > It's legal for tag names to begin with a number, right?  It works fine
> > in all other respects but in AQL it gives a syntax error.
> >
> > E.g. at WormBase, http://www.wormbase.org/db/searches/aql_query,
> > "select U from U in class UTR where exists_tag U->5_UTR" gives
> > "AQL error 700 around: '_tag U->5_UTR"
> 
> 
> Hi Dave,
> 
> It's legal as far as I know, and we have often used numbers as part of
> tag names in WormBase (as your example shows with the '5_UTR' tag).
> 
> Never been aware of any querying problems though, but then I hardly ever
> use AQL.  If it is a number-related problem, you could maybe check by
> writing an AQL query against the '2_point' tag in the ?Rearrangement
> class.  If you still get a bug, then this should be enough info for the
> acedb guys to track it down (note though that Ed is on holiday at the
> moment).
---





More information about the Acedb mailing list