Invalid SQL produced by CoreData

  • I'm running into a problem where CoreData is producing bogus SQL.
    I have a fairly trivial schema.  I've gotten rid of all inheritance,
    and deleted most of the tables.  I have a few relationships, but none
    are even many-to-many.  When I try to associated one object with
    another, I'm getting bogus SQL, though:

    CoreData: sql: SELECT I.Z_PK FROM ZSOMETABLE I WHERE  = 1

      Logged as Radar #4761260, but I'm wondering if anyone else has hit
    this problem and found a workaround.  I've been able to drop a few
    relationships to get rid of the problem, but also my functionality :)

    -tim
  • On Oct 2, 2006, at 4:47 PM, Timothy J.Wood wrote:
    > I'm running into a problem where CoreData is producing bogus SQL.
    > I have a fairly trivial schema.  I've gotten rid of all inheritance,
    > and deleted most of the tables.  I have a few relationships, but
    > none are even many-to-many.  When I try to associated one object
    > with another, I'm getting bogus SQL, though:
    >
    > CoreData: sql: SELECT I.Z_PK FROM ZSOMETABLE I WHERE  = 1
    >
    > Logged as Radar #4761260, but I'm wondering if anyone else has hit
    > this problem and found a workaround.  I've been able to drop a few
    > relationships to get rid of the problem, but also my functionality :)

      For posterity, if anyone else hits this ....

      A kind person from Apple tells me that the problem is that I'm
    confusing CoreData with my model -- I'd forgotten that one side of a
    relationship is marked transient and its inverse is not.  I'd changed
    my mind about how to model this (one-way transient vs. full two-way
    relationship) and missed double-checking this flag.

    -tim
previous month october 2006 next month
MTWTFSS
            1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31          
Go to today