This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
LightSpeed 5.0.2695.0, MySql. I have an entity hierarchy (class table inheritance) — base entity BaseProduct with inherited ProductA, ProductB and ProductC. Another entity CustomProperty has a one-to-one association with ProductA (source: CustomProperty, target: ProductA). When I enable "Eager Load Target" on this association and try to retrieve the entities
the exception is thrown:
The underlying generated SQL:
|
|
|
If you are able to send us through a repro project which triggers this we can have a look into this for you. You can either mail this through to support at mindscape.co.nz or attach it to the forum post if you would prefer.
|
|
|
Test solution is attached |
|
|
Thanks for sending this through, Im having a look into this now - Ill update the thread again once Ive tracked down whats occuring here.
|
|
|
Quick update on this and thanks again for the repro project - Ive tracked down the cause of the original issue and added in a fix however this has uncovered a second issue so Im currently looking into that. Ill update you again once we have made more progress on this.
|
|
|
Hi Jeremy, any news? |
|
|
Sorry nothing new to report, we are still looking into a fix for the second issue.
|
|
|
Could you suggest a workaround for this problem? |
|
|
The workaround here is to disable eager loading on the association. Unfortunately we are no closer to a fix but are continuing to look into this.
|
|