[jira] [Updated] (DERBY-6783) WHEN clause in CREATE TRIGGER for UPDATE is not working for the sql script below

2015-06-02 Thread Abhinav Gupta (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhinav Gupta updated DERBY-6783: - Attachment: (was: sortFunction.diff) WHEN clause in CREATE TRIGGER for UPDATE is not working

Re: [jira] [Commented] (DERBY-6783) WHEN clause in CREATE TRIGGER for UPDATE is not working for the sql script below

2015-06-02 Thread Abhinav Gupta
Hi Bryan, I spent quite some time on this bug today and there was a slight problem with my sort function which I corrected, but from what I infer from the print statements, I have restructured the triggerColsAndTriggerActionCols such that ID has a value 2 for the case when both ID and STATUS are

[jira] [Updated] (DERBY-6783) WHEN clause in CREATE TRIGGER for UPDATE is not working for the sql script below

2015-06-02 Thread Abhinav Gupta (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhinav Gupta updated DERBY-6783: - Attachment: sortFunction.diff WHEN clause in CREATE TRIGGER for UPDATE is not working for the

Re: [jira] [Commented] (DERBY-6783) WHEN clause in CREATE TRIGGER for UPDATE is not working for the sql script below

2015-06-02 Thread Bryan Pendleton
I spent quite some time on this bug today and there was a slight problem with my sort function which I corrected, Wonderful! Thank you for the updates. I see that you have attached the new version to DERBY-6783, and I will try to download that to my sandbox and see what behavior I see.

Re: [jira] [Commented] (DERBY-6783) WHEN clause in CREATE TRIGGER for UPDATE is not working for the sql script below

2015-06-02 Thread Bryan Pendleton
Hi Abhinav, I was able to build and run your sort code, and it seemed to be behaving as you expected it to, but the test case still seemed to be generating the wrong code, such that the when clause was accessing the value of the ID column instead of accessing the value of the STATUS column.) I