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)