NEW ADQL draft + BNF grammar
Iñaki Ortiz de Landaluce
Inaki.Ortiz at sciops.esa.int
Tue Sep 4 06:52:14 PDT 2007
Dear all
Please find attached an updated version of the ADQL draft specification
(1.5-20070903).
This version includes the following changes in the BNF grammar:
+ SQUARE included in the list of ADQL reserved words.
+ DEC removed from the list of SQL reserved words. (To avoid possible
conflicts with declination references)
+ SQL embedded language characters (left and right bracket) included.
+ Ampersand, question mark, semicolon and vertical bar added to the list
of SQL special characters.
+ Boolean test simplified. UNKNOWN taken out. Boolean test replaced by
boolean factor.
+ First sketch of user defined function construct. Presence of a default
function prefix placeholder.
Added to character primary and numeric value function. Function-like
construct with unlimited number of
numeric value expressions separated with commas. Optional qualification
through default function prefix.
+ Catalog name added to qualify database schema names. Unqualified
schema name added (points to standard identifier).
+ Comparison operator renamed to comp_op (as in SQL92).
+ Delimited identifier and ADQL special character added to delimited
token construct.
+ Delimited identifier correction to allow double quotes and/or
whitespaces.
+ Alias support for joined tables and usage of derived table and
subquery definitions.
+ General literal construct added to hold different literal data types
(string for the time being only, it eases future extensions).
+ Like predicate generalized using match value and pattern constructs.
+ Not equals operators split into two.
+ Null predicate corrected. Column reference added at the beginning of
the construct.
+ Region specification and predicate constructs left empty. To hold
whatever we agree shortly.
Please do not hesitate to send any comment, question and/or suggestion
to the VOQL-TEG mailing list.
Regards
Iñaki
--
Iñaki Ortiz de Landaluce
European Space Agency (ESA)
European Space Astronomy Centre (ESAC)
Science Operations Department (SCI-O)
Science Archives Engineering Unit (SCI-OE)
E-mail: Inaki.Ortiz at sciops.esa.int
Tel: +34 91 813 13 67 Fax: +34 91 813 13 22
European Space Astronomy Centre (ESAC)
28691 Villanueva de la Cañada
P.O. Box 78, Madrid, SPAIN
================================================================================================
This message and any attachments are intended for the use of the addressee or addressees only. The
unauthorised disclosure, use, dissemination or copying (either in whole or in part) of its content
is prohibited. If you received this message in error, please delete it from your system and notify
the sender. E-mails can be altered and their integrity cannot be guaranteed. ESA shall not be liable
for any e-mail if modified.
=================================================================================================
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ADQL-20070903.doc
Type: application/vnd.ms-word
Size: 308224 bytes
Desc: not available
URL: <http://www.ivoa.net/pipermail/voql-teg/attachments/20070904/fcc3599c/attachment-0001.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ADQL-20070903.pdf
Type: application/pdf
Size: 80865 bytes
Desc: not available
URL: <http://www.ivoa.net/pipermail/voql-teg/attachments/20070904/fcc3599c/attachment-0001.pdf>
More information about the voql-teg
mailing list