RE: question on nullable column in primary key and impact on upsert

2016-02-03 Thread Eric Owhadi
JIRA 1811 created, thanks Suresh J. I don’t know if the 2 other issues are cascade from the error you will fix, we will see. The JIRA mention the 3… *From:* Suresh Subbiah [mailto:suresh.subbia...@gmail.com] *Sent:* Wednesday, February 3, 2016 2:33 PM *To:* user@trafodion.incubator.apache.org

Re: question on nullable column in primary key and impact on upsert

2016-02-03 Thread Suresh Subbiah
Hi Eric, A JIRA will be nice for this failure. These predicates are generated and I have made a mistake in not considering ISNULL predicates here. A fix will be straightforward. >>upsert into t values(null,2); *** ERROR[4099] A NULL operand is not allowed in predicate