Agree with Hans, I am satisfied with current implementation in Trafodion. Ming
-----Original Message----- From: Hans Zeller [mailto:[email protected]] Sent: Thursday, October 27, 2016 11:45 PM To: [email protected]; Mr Ravisha Neelakanthappa <[email protected]> Subject: RE: Is it good idea to add VARCHAR2 as an alias for VARCHAR? Hi, The properties of Oracle VARCHAR, that it stores an empty string as NULL, is not really a desirable feature, I think, it's somewhere between a bug and a "feature". I hope we won't have to spend effort to simulate this "feature"? Just mapping VARCHAR2 to VARCHAR sounds like a good solution to me. I think many other database systems support the VARCHAR2 syntax as well and do the same. Another note: Trafodion supports the Oracle syntax of expressing varchar length in bytes and characters, e.g. VARCHAR2(20 BYTES) CHARACTER SET UTF8. Thanks, Hans -----Original Message----- From: Anoop Sharma [mailto:[email protected]] Sent: Thursday, October 27, 2016 8:08 AM To: [email protected]; Mr Ravisha Neelakanthappa <[email protected]> Subject: RE: Is it good idea to add VARCHAR2 as an alias for VARCHAR? Current VARCHAR2 support is only at syntax level. It does not support any semantic variations from varchar. For that a new datatype will need to be added and code changes to support semantic diffrences will have to be added. That may not be trivial as it will involve changes in various parts of expression evaluation/generation. anoop -----Original Message----- From: Liu, Ming (Ming) [mailto:[email protected]] Sent: Thursday, October 27, 2016 8: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
