But is it supported with the semantics that Ravisha identified or we just make it a varchar where the semantics are in fact not the same as they are in Oracle?
-----Original Message----- From: Liu, Ming (Ming) [mailto:[email protected]] Sent: Thursday, October 27, 2016 10:03 AM To: [email protected]; Mr Ravisha Neelakanthappa <[email protected]> Subject: RE: Is it good idea to add VARCHAR2 as an alias for VARCHAR? Thanks Ravisha and Anoop, It is very happy to know this is already supported! Ming -----Original Message----- From: Mr Ravisha Neelakanthappa [mailto:[email protected]] Sent: Thursday, October 27, 2016 10:58 PM To: [email protected] Subject: Re: Is it good idea to add VARCHAR2 as an alias for VARCHAR? Semantics of varchar2 and Trafodion varchar data type are not same. Varchar2 stores NULL value for empty input string where as Trafodion stores empty string. I think handling trailing spaces is also different. A new FSData type has be added to support VARCHAR2 in Trafodion for seamless migration of Oracle application than making it an alias to Trafodion. Regards,-Ravisha On Thursday, October 27, 2016 8:19 PM, Eric Owhadi <[email protected]> wrote: +1 on this, Eric -----Original Message----- From: Liu, Ming (Ming) [mailto:[email protected]] Sent: Thursday, October 27, 2016 9:41 AM To: [email protected] Subject: Is it good idea to add VARCHAR2 as an alias for VARCHAR? Hi, all, As fa as I know, today, Oracle users use VARCHAR2 heavily, it seems VARCHAR is not ever used in Oracle DDL. So there is a task to rewrite Oracle DDL to replace VARCHAR2 into VARCHAR when migrating from Oracle to Trafodion. So I feel Oracle users will be happy to have VARCHAR2 supported in Trafodion if we can. IMHO, it will be very simple to add VARCHAR2 keyword as an alias for VARCHAR, the effort seems minimal. So I want to ask the community about more input, is there any considerations that I overlook , that, this alias will bring some issues? Some users I talked show the desire that Trafodion should support more Oracle syntax, because it helps adoption, people are used to one of the major RDMBS already, so happy to see something familiar. I would like to see if community has desire to support some popular Oracle syntax/functions in Trafodion? And I am happy to get more ideas about Trafodion to be more easy to play with. Thanks, Ming
