trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eric Owhadi <eric.owh...@esgyn.com>
Subject RE: [DISCUSS] Change the default setting of ALLOW_NULLABLE_UNIQUE_KEY_CONSTRAINT to ON
Date Tue, 02 Feb 2016 21:53:13 GMT
Do you happen to know if STORE BY is part of the ANSI standard, and if ANSI
mandate that anything in STORE BY must be part of the PK?
Eric

-----Original Message-----
From: Dave Birdsall [mailto:dave.birdsall@esgyn.com]
Sent: Tuesday, February 2, 2016 3:45 PM
To: dev@trafodion.incubator.apache.org
Subject: RE: [DISCUSS] Change the default setting of
ALLOW_NULLABLE_UNIQUE_KEY_CONSTRAINT to ON

Our default behavior would not be ANSI standard if this is changed. I don’t
know if that is a compelling reason not to do this though.

Dave

-----Original Message-----
From: Suresh Subbiah [mailto:suresh.subbiah60@gmail.com]
Sent: Tuesday, February 2, 2016 1:37 PM
To: dev@trafodion.incubator.apache.org
Subject: [DISCUSS] Change the default setting of
ALLOW_NULLABLE_UNIQUE_KEY_CONSTRAINT to ON

Hi,

Do you foresee potential problems if  we change the default setting for
ALLOW_NULLABLE_UNIQUE_KEY_CONSTRAINT to ON. ?
It does seem that users are asking for using and setting this CQD in their
individual applications.
Other than JIRA 1801, there are no known issues when this attribute is set
to ON.
Having the default set to ON could make Trafodion easier to use.

I can file a JIRA if there is agreement or if we think the discussion should
be moved to a JIRA.

Thank you
Suresh

Mime
View raw message