Grails

hasOne results in eager fetching of association

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Won't Fix
  • Affects Version/s: 1.3.3
  • Fix Version/s: None
  • Component/s: None
  • Labels:
    None

Description

If I have the following domain model:

class Author {
    String name
    
    static hasOne = [ location: Location ]
}

class Location {
    String city
}

then when I execute this code:

Author.list().each { a ->
    println a.location.city
}

I find that the location instances are all loaded up front with separate SELECTs. In other words, they're loaded eagerly. Explicitly specifying the relationship as lazy: true has no effect.

Perhaps this behaviour is expected, but it seems strange to me.

Issue Links

duplicates

Bug - A problem which impairs or prevents the functions of the product. GRAILS-5077 hasOne mapping is by default eager and cannot be changed to lazy

  • Blocker - Blocks development and/or testing work, production could not run.
  • In Progress - This issue is being actively worked on at the moment by the assignee.
is related to

Bug - A problem which impairs or prevents the functions of the product. GRAILS-6538 Bidirectional 'one-to-one' mapping results in extra unnecessary query on relationship

  • Major - Major loss of function.
  • Open - The issue is open and ready for the assignee to start work on it.

Activity

People

  • Assignee:
    Jeff Brown
    Reporter:
    Peter Ledbrook
Vote (3)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved: