Re: Review of the the DM pre CR version (Re: Final round of Direct Mapping spec changes; please review to prepare for CR)

Juan, Ivan, all --

On Jan 24, 2012, at 11:11 AM, Juan Sequeda wrote:
> On Sun, Jan 22, 2012 at 6:27 AM, Ivan Herman <ivan@w3.org> wrote:
> 
>>  Again my SQL knowledge... at the last telco we decided to put a quote around identifier to get around the character casing problem. Shouldn't ID be in quotes in the argument of PRIMARY KEY(ID) as well (note that the same statement is quoted in the text after the SQL portion where ID is in quotes)? The same question for the INSERT statements.
> 
> 
> Also added missing quotes in another example.
> 
> Not sure about the INSERT statements... somebody?

Generally speaking, if any relational identifiers are wrapped 
in double-quotes, all should be.  

More specifically to a given scenario (such as this document), 
if a given identifier is wrapped (and thus made case-sensitive)
once, it must be so wrapped every time.

So, yes, e.g. from 2.1 --

   CREATE TABLE "Addresses" (
      "ID" INT, PRIMARY KEY("ID"), 
      "city" CHAR(10), 
      "state" CHAR(2)
   )

   CREATE TABLE "People" (
      "ID" INT, PRIMARY KEY("ID"), 
      "fname" CHAR(10), 
      "addr" INT, 
      FOREIGN KEY("addr") REFERENCES "Addresses"("ID")
   )

   INSERT INTO Addresses (ID, city, state) VALUES (18, 
   'Cambridge', 'MA')
   INSERT INTO People (ID, fname, addr) VALUES (7, 'Bob', 18)
   INSERT INTO People (ID, fname, addr) VALUES (8, 'Sue', NULL)

-- the last three lines should become --

   INSERT INTO Addresses ("ID", "city", "state") VALUES (18, 
   'Cambridge', 'MA')
   INSERT INTO People ("ID", "fname", "addr") VALUES (7, 'Bob', 18)
   INSERT INTO People ("ID", "fname", "addr") VALUES (8, 'Sue', NULL)



>>  Also, is it intentional that sometimes single and sometimes double quotes are used? If the two are interchangeable, I would propose to be consistent within the examples

They are not interchangeable in SQL.  Single-quotes wrap string
values.  Double-quotes wrap identifiers (table, column, etc.).

But we must be consistent with use of each.

Regards,

Ted



--
A: Yes.                      http://www.guckes.net/faq/attribution.html
| Q: Are you sure?
| | A: Because it reverses the logical flow of conversation.
| | | Q: Why is top posting frowned upon?

Ted Thibodeau, Jr.           //               voice +1-781-273-0900 x32
Evangelism & Support         //        mailto:tthibodeau@openlinksw.com
                             //              http://twitter.com/TallTed
OpenLink Software, Inc.      //              http://www.openlinksw.com/
         10 Burlington Mall Road, Suite 265, Burlington MA 01803
     Weblog   -- http://www.openlinksw.com/blogs/
     LinkedIn -- http://www.linkedin.com/company/openlink-software/
     Twitter  -- http://twitter.com/OpenLink
     Google+  -- http://plus.google.com/100570109519069333827/
     Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers