Re: AQL vs. tags beginning with a digit

Article View: bionet.software.acedb

Article #154

Back to bionet.software.acedb Previous Next

#154

From: Dave Matthews
Date: Tue, 26 Aug 2003 12:07

58 lines
3997 bytes

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@net.bio.net
> From: Keith Bradnam <krb@sanger.ac.uk>
> Subject:  Re: AQL vs. tags beginning with a digit
> To: Dave Matthews <matthews@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).
---

Technical Details

Message-ID: <200308202017.h7KKH02r021385@greengenes.cit.cornell.edu>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!bloom-beacon.mit.edu!hgmp.mrc.ac.uk!net.bio.net

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f6d40,d6a048cb93775a03,start
X-Google-Attributes: gidf6d40,public
X-Google-ArrivalTime: 2003-08-26 05:07:28 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!bloom-beacon.mit.edu!hgmp.mrc.ac.uk!net.bio.net
From: matthews@greengenes.cit.cornell.edu (Dave Matthews)
Newsgroups: bionet.software.acedb
Subject: Re: AQL vs. tags beginning with a digit
Date: 26 Aug 2003 13:07:27 +0100
Organization: BIOSCI/MRC Human Genome Mapping Project Resource Centre
Lines: 59
Sender: mod-ace@hgmp.mrc.ac.uk
Approved: BIOSCI Approval Key <biosci-approval-key@net.bio.net>
Message-ID: <200308202017.h7KKH02r021385@greengenes.cit.cornell.edu>
NNTP-Posting-Host: mercury.hgmp.mrc.ac.uk
X-Trace: niobium.hgmp.mrc.ac.uk 1061899647 6189 193.62.192.80 (26 Aug 2003 12:07:27 GMT)
X-Complaints-To: news@net.bio.net
NNTP-Posting-Date: Tue, 26 Aug 2003 12:07:27 +0000 (UTC)
X-Original-To: bionet-software-acedb@net.bio.net
X-Original-To: acedb@net.bio.net
X-Received: from localhost (localhost [127.0.0.1])
 by mercury.hgmp.mrc.ac.uk (Postfix) with ESMTP id 4197B7D29A
 for <acedb@net.bio.net>; Wed, 20 Aug 2003 21:17:04 +0100 (BST)
X-Received: from greengenes.cit.cornell.edu (greengenes.cit.cornell.edu [128.253.246.43])
 by mercury.hgmp.mrc.ac.uk (Postfix) with ESMTP id 15D107D2A3
 for <acedb@net.bio.net>; Wed, 20 Aug 2003 21:17:03 +0100 (BST)
X-Received: from greengenes.cit.cornell.edu (localhost [127.0.0.1])
 by greengenes.cit.cornell.edu (8.12.9/8.12.9) with ESMTP id h7KKH0RZ021386;
 Wed, 20 Aug 2003 16:17:00 -0400 (EDT)
X-Received: (from matthews@localhost)
 by greengenes.cit.cornell.edu (8.12.9/8.12.9/Submit) id h7KKH02r021385;
 Wed, 20 Aug 2003 16:17:00 -0400 (EDT)
X-To: Keith Bradnam <krb@sanger.ac.uk>
X-Cc: ACEDB newsgroup <acedb@net.bio.net>
X-Auth: PGPMoose V1.1 PGP bionet.software.acedb
 iQCVAwUAP0tNfqCIqsWvyF5FAQGXgQP6Air0LKKm+fEYSHHyJrZwccwbiVGecYPS
 DNrnkVC8gZbeOTXHRJEVmVOYdPf+Y3abEzshsp/fRIJq96tkYyavhzG/1D6MIirg
 nNKHZHxaJAUdQq1YGP9UViwkPGcVUvLA+oxbloLO2xfp0RZAQf/BZhO3wZNPtBye
 Rktsx/pOwko=
 =gbdG