Alex,
I am posting a follow up question on the citation and the restriction
and hope to have a definitive answer fairly quickly.
Thanks!
Patrick
Alex Brown wrote:
> Patrick hi
>
> The cited text still doesn't exist, I think:
>
> "[SQL] ISO/IEC 9075-1:2008 Information Technology -- Database
> Language
> -- SQL -- Part 2: Foundation (SQL/Foundation), , 2008"
>
> It should either be 9075-1:2008 or 9075-2:2008 (but not 9075-1 Part 2).
>
> I can't find any mention of naming restrictions in 9075-1:2008. I don't
> have access to 9075-2:2008, but the 2003 edition appears already to
> allow fully internationalised and/or locale-specific naming (see clause
> 5.4).
>
> I assumed this attribute would be set "true" to invoke the archaic rules
> of SQL 92, and if false the rules of modern SQL would apply. But maybe
> this is totally wrong.
>
> Also, what are the "additional database driver dependent characters"
> mentioned in the note? Are characters permitted that are non-conformant
> to SQL?
>
> - Alex.
>
>
>> -----Original Message-----
>> From: Patrick Durusau [mailto:]
>> Sent: 27 September 2009 15:52
>> To: Alex Brown
>> Cc:
>> Subject: Re: 18.51 db:enable-sql92-check (ODF1.2)
>>
>> 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)
>>
>
>
>
--
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)
