Alex,
Alex Brown wrote:
> Patrick hi
>
> This raises a problem specific to ODF 1.2.
>
> How does referencing the SQL 2008 version invoke restrictions that were
> apparently only in force for SQL 92?
>
>
Not sure the restrictions changed between the two but will consult the
texts of both to discover the answer to that question.
> What is different about the behaviour if this attribute is set "true"
> rather than "false"?
>
> In other words, isn't this citation (and the note) here, wrong?
>
>
From ODF 1.2 (draft, subject to change):
> The |db:enable-sql92-check| attribute specifies whether the names of
> tables, views, columns, and queries shall conform to [SQL].
>
> Note: This limitation restricts the character set to “a”-”z”,”A”-”Z”,
> “0”-”9” and “_” and additional database driver dependent characters.
>
> The defined values for the db|:enable-sql92-check| attribute are:
>
> *
>
> false: names of tables, views, columns and queries may not
> conform to [SQL].
>
> *
>
> true: names of tables, views, columns and queries shall conform
> to [SQL].
>
My understanding is that the citation was meant as a short hand for a
set of naming restrictions.
Leaving aside the citation question, is there anything unclear about the
definition of the attribute?
Thanks!
Hope you are at the start of a great week!
Patrick
> - Alex.
>
>
>
>> -----Original Message-----
>> From: Patrick Durusau [mailto:]
>> Sent: 27 September 2009 00:59
>> To: Alex Brown
>> Cc:
>> Subject: Re: [office-comment] 18.51 db:enable-sql92-check (ODF all
>>
> versions)
>
>> Alex,
>>
>> I should read all of my incoming mail before responding. ;-)
>>
>> The correct citation is:
>>
>> [SQL] ISO/IEC 9075-1:2008 Information Technology -- Database
>>
> Language
>
>> -- SQL -- Part 2: Foundation (SQL/Foundation), , 2008 Hope you are
>>
> having a
>
>> great weekend!
>>
>> Patrick
>>
>> Alex Brown wrote:
>>
>>> Dear all,
>>>
>>> Sorry that comment is not for "ODF all version", but only "ODF
>>>
> 1.0/1.1".
>
>>>
>>>> Dear all,
>>>>
>>>> ----
>>>> The db:enable-sql92-check attribute specifies that the names of
>>>>
>>>>
>>> tables,
>>>
>>>
>>>> views, columns, and queries must be conform to ISO/IEC 9075
>>>>
>>>>
>>> Information
>>>
>>>
>>>> Technology - Database Language SQL: 2002.
>>>> ----
>>>>
>>>> * I can find no reference to a 2002 version of this Standard, but
>>>>
> can
>
>>>> find this 2003 version:
>>>> http://www.iso.org/iso/catalogue_detail.htm?csnumber=34133 . Note
>>>>
>> the
>>
>>>> title is different, and this Standard has since been revised
>>>>
> (2008).
>
>>>> * "must be conform" -> "shall conform to the naming conventions
>>>>
> of".
>
>>>> * I cannot find the naming prohibition described in the following
>>>> note (in the ODF spec). For convenience, please cite the clause
>>>>
> where
>
>>>> this is defined.
>>>>
>>>> * Or ... is the 1992 version of 9075 meant (
>>>> http://www.iso.org/iso/catalogue_detail.htm?csnumber=16663 )? This
>>>> has been withdrawn and so should not be cited; instead the relevant
>>>> provisions need to be stated in full in the ODF spec itself
>>>>
> (perhaps
>
>>>> beef-up the note).
>>>>
>>>> - Alex.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> This publicly archived list offers a means to provide input to the
>>>> OASIS Open Document Format for Office Applications (OpenDocument)
>>>>
>> TC.
>>
>>>> In order to verify user consent to the Feedback License terms and
>>>>
> to
>
>>>> minimize spam in the list archive, subscription is required before
>>>> posting.
>>>>
>>>> Subscribe:
>>>> Unsubscribe:
>>>> List help:
>>>> List archive: http://lists.oasis-open.org/archives/office-comment/
>>>> Feedback License: http://www.oasis-
>>>> open.org/who/ipr/feedback_license.pdf
>>>> List Guidelines: http://www.oasis-open.org/maillists/guidelines.php
>>>> Committee: http://www.oasis-
>>>> open.org/committees/tc_home.php?wg_abbrev=office
>>>>
>>>>
>>>
>>>
>> --
>> Patrick Durusau
>>
>> Chair, V1 - US TAG to JTC 1/SC 34
>> Convener, JTC 1/SC 34/WG 3 (Topic Maps)
>> Editor, OpenDocument Format TC (OASIS), Project Editor ISO/IEC 26300
>>
> Co-
>
>> Editor, ISO/IEC 13250-1, 13250-5 (Topic Maps)
>>
>
>
>
--
Patrick Durusau
Chair, V1 - US TAG to JTC 1/SC 34
Convener, JTC 1/SC 34/WG 3 (Topic Maps)
Editor, OpenDocument Format TC (OASIS), Project Editor ISO/IEC 26300
Co-Editor, ISO/IEC 13250-1, 13250-5 (Topic Maps)
