[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: Re: [office-comment] RE: 18.51 db:enable-sql92-check (ODF1.2)
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:patrick@durusau.net] >> Sent: 27 September 2009 15:52 >> To: Alex Brown >> Cc: office-comment@lists.oasis-open.org >> 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:patrick@durusau.net] >>>> Sent: 27 September 2009 00:59 >>>> To: Alex Brown >>>> Cc: office-comment@lists.oasis-open.org >>>> 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: office-comment-subscribe@lists.oasis-open.org >>>>>> Unsubscribe: office-comment-unsubscribe@lists.oasis-open.org >>>>>> List help: office-comment-help@lists.oasis-open.org >>>>>> 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 >>>> patrick@durusau.net >>>> 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 >> patrick@durusau.net >> 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 patrick@durusau.net 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)
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]