You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@trafodion.apache.org by "Liu, Ming (Ming)" <mi...@esgyn.cn> on 2016/10/27 14:41:19 UTC
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
RE: Is it good idea to add VARCHAR2 as an alias for VARCHAR?
Posted by Rohit Jain <ro...@esgyn.com>.
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:ming.liu@esgyn.cn]
Sent: Thursday, October 27, 2016 10:03 AM
To: dev@trafodion.incubator.apache.org; Mr Ravisha Neelakanthappa <nr...@yahoo.com>
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:nravisha@yahoo.com.INVALID]
Sent: Thursday, October 27, 2016 10:58 PM
To: dev@trafodion.incubator.apache.org
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 <er...@esgyn.com> wrote:
+1 on this,
Eric
-----Original Message-----
From: Liu, Ming (Ming) [mailto:ming.liu@esgyn.cn]
Sent: Thursday, October 27, 2016 9:41 AM
To: dev@trafodion.incubator.apache.org
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
RE: Is it good idea to add VARCHAR2 as an alias for VARCHAR?
Posted by "Liu, Ming (Ming)" <mi...@esgyn.cn>.
Agree with Hans, I am satisfied with current implementation in Trafodion.
Ming
-----Original Message-----
From: Hans Zeller [mailto:hans.zeller@esgyn.com]
Sent: Thursday, October 27, 2016 11:45 PM
To: dev@trafodion.incubator.apache.org; Mr Ravisha Neelakanthappa <nr...@yahoo.com>
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:anoop.sharma@esgyn.com]
Sent: Thursday, October 27, 2016 8:08 AM
To: dev@trafodion.incubator.apache.org; Mr Ravisha Neelakanthappa <nr...@yahoo.com>
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:ming.liu@esgyn.cn]
Sent: Thursday, October 27, 2016 8:03 AM
To: dev@trafodion.incubator.apache.org; Mr Ravisha Neelakanthappa <nr...@yahoo.com>
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:nravisha@yahoo.com.INVALID]
Sent: Thursday, October 27, 2016 10:58 PM
To: dev@trafodion.incubator.apache.org
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 <er...@esgyn.com> wrote:
+1 on this,
Eric
-----Original Message-----
From: Liu, Ming (Ming) [mailto:ming.liu@esgyn.cn]
Sent: Thursday, October 27, 2016 9:41 AM
To: dev@trafodion.incubator.apache.org
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
RE: Is it good idea to add VARCHAR2 as an alias for VARCHAR?
Posted by Hans Zeller <ha...@esgyn.com>.
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:anoop.sharma@esgyn.com]
Sent: Thursday, October 27, 2016 8:08 AM
To: dev@trafodion.incubator.apache.org; Mr Ravisha Neelakanthappa <nr...@yahoo.com>
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:ming.liu@esgyn.cn]
Sent: Thursday, October 27, 2016 8:03 AM
To: dev@trafodion.incubator.apache.org; Mr Ravisha Neelakanthappa <nr...@yahoo.com>
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:nravisha@yahoo.com.INVALID]
Sent: Thursday, October 27, 2016 10:58 PM
To: dev@trafodion.incubator.apache.org
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 <er...@esgyn.com> wrote:
+1 on this,
Eric
-----Original Message-----
From: Liu, Ming (Ming) [mailto:ming.liu@esgyn.cn]
Sent: Thursday, October 27, 2016 9:41 AM
To: dev@trafodion.incubator.apache.org
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
RE: Is it good idea to add VARCHAR2 as an alias for VARCHAR?
Posted by Anoop Sharma <an...@esgyn.com>.
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:ming.liu@esgyn.cn]
Sent: Thursday, October 27, 2016 8:03 AM
To: dev@trafodion.incubator.apache.org; Mr Ravisha Neelakanthappa <nr...@yahoo.com>
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:nravisha@yahoo.com.INVALID]
Sent: Thursday, October 27, 2016 10:58 PM
To: dev@trafodion.incubator.apache.org
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 <er...@esgyn.com> wrote:
+1 on this,
Eric
-----Original Message-----
From: Liu, Ming (Ming) [mailto:ming.liu@esgyn.cn]
Sent: Thursday, October 27, 2016 9:41 AM
To: dev@trafodion.incubator.apache.org
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
RE: Is it good idea to add VARCHAR2 as an alias for VARCHAR?
Posted by "Liu, Ming (Ming)" <mi...@esgyn.cn>.
Thanks Ravisha and Anoop,
It is very happy to know this is already supported!
Ming
-----Original Message-----
From: Mr Ravisha Neelakanthappa [mailto:nravisha@yahoo.com.INVALID]
Sent: Thursday, October 27, 2016 10:58 PM
To: dev@trafodion.incubator.apache.org
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 <er...@esgyn.com> wrote:
+1 on this,
Eric
-----Original Message-----
From: Liu, Ming (Ming) [mailto:ming.liu@esgyn.cn]
Sent: Thursday, October 27, 2016 9:41 AM
To: dev@trafodion.incubator.apache.org
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
Re: Is it good idea to add VARCHAR2 as an alias for VARCHAR?
Posted by Mr Ravisha Neelakanthappa <nr...@yahoo.com.INVALID>.
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 <er...@esgyn.com> wrote:
+1 on this,
Eric
-----Original Message-----
From: Liu, Ming (Ming) [mailto:ming.liu@esgyn.cn]
Sent: Thursday, October 27, 2016 9:41 AM
To: dev@trafodion.incubator.apache.org
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
RE: Is it good idea to add VARCHAR2 as an alias for VARCHAR?
Posted by Anoop Sharma <an...@esgyn.com>.
varchar2 as a datatype in create stmts is supported in trafodion.
Apache Trafodion Conversational Interface 2.1.0
Copyright (c) 2015-2016 Apache Software Foundation
>>create table tvc2 (a varchar2(10));
--- SQL operation complete.
>>
-----Original Message-----
From: Eric Owhadi [mailto:eric.owhadi@esgyn.com]
Sent: Thursday, October 27, 2016 7:49 AM
To: dev@trafodion.incubator.apache.org
Subject: RE: Is it good idea to add VARCHAR2 as an alias for VARCHAR?
This sender failed our fraud detection checks and may not be who they appear to be. Learn about spoofing at http://aka.ms/LearnAboutSpoofing
+1 on this,
Eric
-----Original Message-----
From: Liu, Ming (Ming) [mailto:ming.liu@esgyn.cn]
Sent: Thursday, October 27, 2016 9:41 AM
To: dev@trafodion.incubator.apache.org
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
RE: Is it good idea to add VARCHAR2 as an alias for VARCHAR?
Posted by Eric Owhadi <er...@esgyn.com>.
+1 on this,
Eric
-----Original Message-----
From: Liu, Ming (Ming) [mailto:ming.liu@esgyn.cn]
Sent: Thursday, October 27, 2016 9:41 AM
To: dev@trafodion.incubator.apache.org
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