On Wed, Oct 21, 2015 at 2:55 PM, Tishan Dahanayakage <tis...@wso2.com> wrote:
> Hi, > > As explained in this JIRA[1] a query where we check whether certain item > exists and then insert(more like initializing table) fails if query > receives burst events. Reason is multiple events will evaluate condition > 'not((itemNo==avgQty.itemNo) in avgQty)' to be true before the first insert > is committed. > For this exact scenario Seshika pointed out that we can get rid of this by > making that field the primary key. But for some scenarios that can also > generate false results because there can be situations where this > initialization insert may overwrite a calculated result put into table by > another query. > In summary we should state that we do not support atomic execution of a > query hence users will not be misled. > > Also since this type of requirement is practical and will be useful, I > think we should consider adding this functionality for next minor release > after comparing between implementation cost and added value. > > WDYT? > +1, we thought of adding this improvement even in CEP 4.0.0 but our priorities are got changed :) .. Let's add this for next immediate release.. > [1] https://wso2.org/jira/browse/CEP-1415 > > Thanks > Tishan > > -- > Tishan Dahanayakage > Software Engineer > WSO2, Inc. > Mobile:+94 716481328 > > Disclaimer: This communication may contain privileged or other > confidential information and is intended exclusively for the addressee/s. > If you are not the intended recipient/s, or believe that you may have > received this communication in error, please reply to the sender indicating > that fact and delete the copy you received and in addition, you should not > print, copy, re-transmit, disseminate, or otherwise use the information > contained in this communication. Internet communications cannot be > guaranteed to be timely, secure, error or virus-free. The sender does not > accept liability for any errors or omissions. > -- *V. Mohanadarshan* *Senior Software Engineer,* *Data Technologies Team,* *WSO2, Inc. http://wso2.com <http://wso2.com> * *lean.enterprise.middleware.* email: mo...@wso2.com phone:(+94) 771117673
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev