I have a node View, which pulls product through Relationship with referenced product. This works well.
Where it fails - my product (CD) have product reference fields (Tracks) and these would not pull through Relationship. After looking into actual SQL query run on DB, I think there is minor bug with declaration, although I am not too good with Views, so please review attached patch and let me know what do you think.
View I am using also attached.
PASSED: [[SimpleTest]]: [MySQL] 3,557 pass(es).
PASSED: [[SimpleTest]]: [MySQL] 3,567 pass(es).
FAILED: [[SimpleTest]]: [MySQL] Unable to apply patch product_reference_views.patch. Unable to apply patch. See the log in the details link for more information.