Databases
StackOverflow2013
Postsdbo
PONSPredicate not executed
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PONSPredicate not executed
    primarykey
    data
    text
    <p>This is quite funny. In my application I create thousands of entry in the database (in another thread, I'm using MagicalRecord). Everything seems working fine (from a background/foreground/context point of view).</p> <p>When, in the main thread, I try to fetch the "just inserted" data, I discovered the following behaviour:</p> <pre><code>- (NSArray *) familiesInCompany:(Company *) company { NSPredicate *predicate1 = [NSPredicate predicateWithFormat:@"company == %@", company]; NSPredicate *predicate2 = [NSPredicate predicateWithFormat:@"company.name == %@", company.name]; NSArray *first = [Family MR_findAllSortedBy:@"name" ascending:YES withPredicate:predicate1]; NSArray *second = [Family MR_findAllSortedBy:@"name" ascending:YES withPredicate:predicate2]; NSArray *third = [Family MR_findByAttribute:@"company" withValue:company andOrderBy:@"name" ascending:YES]; return second; } </code></pre> <p>Now what I get is:</p> <ul> <li>first: is an empty array</li> <li>second: contains all the <code>Family</code> objects, as expected</li> <li>third: is an empty array.</li> </ul> <p>By debugging the SQL statement I get the following:</p> <p>The "first" statement:</p> <blockquote> <p>CoreData: annotation: total fetch execution time: 0.0000s for 0 rows.</p> </blockquote> <p>The "second" statement":</p> <blockquote> <p>CoreData: sql: SELECT 0, t0.Z_PK, t0.Z_OPT, t0.ZNAME, t0.ZCOMPANY FROM ZFAMILY t0 JOIN ZCOMPANY t1 ON t0.ZCOMPANY = t1.Z_PK WHERE t1.ZNAME = ? ORDER BY t0.ZNAME</p> <p>CoreData: annotation: sql connection fetch time: 0.0005s</p> <p>CoreData: annotation: total fetch execution time: 0.0007s for 2 rows.</p> </blockquote> <p>The "third" statement:</p> <blockquote> <p>CoreData: annotation: total fetch execution time: 0.0000s for 0 rows.</p> </blockquote> <p>The hilarious thing is that I close the application (I mean really manually terminate it) and and I open it back, all the three "fetching" statements work.</p> <p>Why the first and the third fetch statements seem to never being executed? How to dig into the problem?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USFabiano Francesconi
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PONSPredicate not executed
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PONSPredicate not executed
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PONSPredicate not executed
      1. USOtto
      1. VTFavorite
    1. COHaving essentially the same problem I think, with an NSFetchedResultsController implementation. Recently created records do not show up in the fetch result, but have been written to the persistent store when I check directly - the correct count even shows up in the relationship NSSet, but the NSPredicate doesn't see them. Weird. Using MagicalRecord 2 - used a 1.x version for a previous project and had no trouble, so I may just change course and use an older version.
      singulars
      1. PONSPredicate not executed
      1. USRob Reuss
    2. CONaive (and kind of off-topic) question: how are you logging the sql statements? I am really curious on how to do that in my app for better understanding predicates
      singulars
      1. PONSPredicate not executed
      1. USFelipe Sabino
    3. CO@FelipeSabino check http://stackoverflow.com/questions/6428630/xcode4-and-core-data-how-to-enable-sql-debugging and http://d.pr/i/Lszs
      singulars
      1. PONSPredicate not executed
      1. USFabiano Francesconi
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload