Re: Problem with optional to-one deletion

2021-11-30 Thread Lon Varscsak
Hey Michael, thanks for responding..I just saw this. Isn't a one-to-many where the dependent object (order_detail_sales) can't existing without the master object (order_header) the right place to use the "to dep pk" checkbox? I have it like this everywhere. :P On Wed, Nov 17, 2021 at 10:45 AM M

Re: Problem with optional to-one deletion

2021-11-30 Thread Lon Varscsak
You're a superstar! :) On Tue, Nov 23, 2021 at 11:28 AM Nikita Timofeev wrote: > Hi all, > > Thanks, Lon for the report and an excellent example, that really > helped to quickly find the problem [1]. > It should be fixed now. > > Sorry, Michael for not notifying that I dived into this, just grab

Re: Problem with optional to-one deletion

2021-11-23 Thread Nikita Timofeev
Hi all, Thanks, Lon for the report and an excellent example, that really helped to quickly find the problem [1]. It should be fixed now. Sorry, Michael for not notifying that I dived into this, just grabbed the test case and started debugging :) [1] https://issues.apache.org/jira/browse/CAY-2723

Re: Problem with optional to-one deletion

2021-11-17 Thread Michael Gentry
OK, nice to know. I won't dive into it more this evening, then. Thanks! On Wed, Nov 17, 2021 at 1:04 PM Andrus Adamchik wrote: > Hi Mike, > > Nikita mentioned a few hours ago that he was able to reproduce. Appears to > be a bug in the 4.2 stack. > > Andrus > > > On Nov 17, 2021, at 7:44 PM, Mi

Re: Problem with optional to-one deletion

2021-11-17 Thread Andrus Adamchik
Hi Mike, Nikita mentioned a few hours ago that he was able to reproduce. Appears to be a bug in the 4.2 stack. Andrus > On Nov 17, 2021, at 7:44 PM, Michael Gentry wrote: > > Hi Lon, > > I didn't have a lot of time to look into it, but I suspect it may be in > your PK/FK mapping on the DbEnt

Re: Problem with optional to-one deletion

2021-11-17 Thread Michael Gentry
Hi Lon, I didn't have a lot of time to look into it, but I suspect it may be in your PK/FK mapping on the DbEntities. For example, in order_header, you have order_header ->> order_detail_sales, but you've mapped that as To-Many AND To-Dependent PK, which doesn't make sense. On Tue, Nov 16, 2021

Re: Problem with optional to-one deletion

2021-11-16 Thread Lon Varscsak
I forgot to mention that I'm running 4.2.M4-SNAPSHOT (updated from github as of an hour ago). On Tue, Nov 16, 2021 at 4:06 PM Lon Varscsak wrote: > Hey all, > > I have a setup where I have an optional to-one relationship, but when I > try to clear the relationship and commitChanges, I get a low-

Problem with optional to-one deletion

2021-11-16 Thread Lon Varscsak
Hey all, I have a setup where I have an optional to-one relationship, but when I try to clear the relationship and commitChanges, I get a low-level Cayenne error along with some in appropriate sql generated. where it's doing an UPDATE to order_detail_costs should be a no-op, because the object wa