[SOLVED] CoreData fetchRequest with predicate incorrectly skips NULL values

CoreData fetchRequest with predicate incorrectly skips NULL values

I have objects stored in my CoreData that look something like this:

id  name  type
1   cat   aaa
2   dog   bbb
3   ape   NULL

I'm fetching these objects based on the "type" property like this:

NSFetchRequest *fetchRequest = [[NSFetchRequest alloc] initWithEntityName:self.entityName];

fetchRequest.predicate = [NSPredicate predicateWithFormat:@"type != %@", @"aaa"];
fetchRequest.fetchBatchSize = 100;
fetchRequest.sortDescriptors = @[[NSSortDescriptor sortDescriptorWithKey:@"type" ascending:YES]];

NSFetchedResultsController *fetchedResultsController = [[NSFetchedResultsController alloc] initWithFetchRequest:fetchRequest managedObjectContext:self.managedObjectContext sectionNameKeyPath:@"section" cacheName:nil];
fetchedResultsController.delegate = self;

NSError *error = nil;
[fetchedResultsController performFetch:&error];

So, I'm simply trying to fetch all objects where type is not like "aaa".

The fetch request unexpectedly omits not only the objects with "aaa" types as specified in the predicate, but also the objects where the type is not set (null), resulting in the following:

id  name  type
2   bar   bbb

Instead of what I'd expect:

id  name  type
2   dog   bbb
3   ape   NULL

The same problem happens when I use predicate format: NOT (type IN {"aaa", "bbb"}). Which is the actual way I'll be needing this. This predicate results in no records getting fetched.

I fail to see why this could happen, because if I don't specify a predicate all objects get fetched properly. Objects with NULL types do get fetched correctly if I'd change the predicate to:

[NSPredicate predicateWithFormat:@"type = null"];

Please note; all of the above just illustrates what the problem boils down to. My actual code is more complicated and simply using the predicate format: type != "aaa" OR type = null is something I'd like to avoid if possible.

Any help greatly appreciated!

Solution