[TRAFODION-1939] Remove OID from the list of reserved words

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.3-incubating
• Fix Version/s: 2.0-incubating
• Component/s: sql-cmp
• Assignee: Hans Zeller
• Reporter: Hans Zeller
• Created: 18/Apr/16 23:47
• Updated: 26/Mar/18 17:15
• Resolved: 20/Apr/16 15:49

Description

Here is an email to the user list that suggested this improvement:

[e-mail] [e-mail] via trafodion.incubator.apache.org
Apr 13 (5 days ago)

to user
hi,all
‘OID’ is a keyword in Trafodion, so it will cause errors like this:
>>select a1 as oid, c1 from t116t3;

• • • ERROR[3128] OID is a reserved word. It must be delimited by double-quotes to be used as an identifier.
      ---------------------------------------------------------------------------------------------------------------------------------
      So I have a few questions:
      1. Is there a special way we can use oid without double quote it?, we need it as an alias of a column? Current application use this heavily, it will be a big effort to change all OID into “OID”.
      2. If answer of 1 is ‘No way’, then is it possible to not define OID as a keyword? We don’t see anywhere OID is used, maybe this is a latency keyword which Trafodion can get rid of?
      3. More generally, Is it possible to allow some keyword if one can tell from context of its real meaning? Following query can be running in Oracle, for example , ‘count’ is keyword in Oracle as well:
      SELECT count count FROM A_TBL T WHERE T.col1='foo’;