You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Hans Zeller (JIRA)" <ji...@apache.org> on 2016/04/19 01:48:25 UTC

[jira] [Created] (TRAFODION-1939) Remove OID from the list of reserved words

Hans Zeller created TRAFODION-1939:
--------------------------------------

             Summary: Remove OID from the list of reserved words
                 Key: TRAFODION-1939
                 URL: https://issues.apache.org/jira/browse/TRAFODION-1939
             Project: Apache Trafodion
          Issue Type: Improvement
          Components: sql-cmp
    Affects Versions: 1.3-incubating
            Reporter: Hans Zeller
            Priority: Minor


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


yujie.yuan@microinsight.com.cn yujie.yuan@microinsight.com.cn 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’;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)