+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
