Message Title

Brett Meyer commented on

HHH-8290

 
                                                        select
        distinct supplier1_.SUPPLIER_ID as SUPPLIER1_1_,
        supplier1_.SUPPLIER_NAME as SUPPLIER2_1_,
        supplier1_.CONTACT_NAME as CONTACT_3_1_ 
    from
        TMP_PRODUCTS products0_ 
    inner join
        TMP_SUPPLIER supplier1_ 
            on products0_.SUPPLIER_ID=supplier1_.SUPPLIER_ID
    cross join
        TMP_SUPPLIER supplier2_ 
    where
        products0_.SUPPLIER_ID=supplier2_.SUPPLIER_ID 
    order by
        supplier2_.SUPPLIER_NAMEUPPLIER_NAME
 
                                                

The main issue is that the "prod.supplier" path is being used twice in the query, but order-by handling is incorrectly generating a second join (rather than using the first). So, this should look like:

 
                                                        select
        distinct supplier1_.SUPPLIER_ID as SUPPLIER1_1_,
        supplier1_.SUPPLIER_NAME as SUPPLIER2_1_,
        supplier1_.CONTACT_NAME as CONTACT_3_1_ 
    from
        TMP_PRODUCTS products0_ 
    inner join
        TMP_SUPPLIER supplier1_ 
            on products0_.SUPPLIER_ID=supplier1_.SUPPLIER_ID
    where
        products0_.SUPPLIER_ID=supplier2_.SUPPLIER_ID 
    order by
        supplier1_.SUPPLIER_NAMEUPPLIER_NAME
 
                                                

Add Comment

This message was sent by Atlassian JIRA