|
HQL QUERY ================= SELECT e.campus, e.agreementNumber, e.agreementTypeAgreementTypes.agreementClassAgreementClasses.classDesc, e.contractNumber, e.effectiveDate, e.expirationDate, e.agreementTypeAgreementTypes.typeDescription, e.agreementComment, e.responsibleOrganization, e.companyNumberCoCompany.companyName, e.agreementStatusAgreementStatuses.statusDesc, e.billingStatusBillingStatuses.statusDesc, e.coOperatingNamesCompositeFK1.operatingName, e.coContactCompositeFK2.lastName, e.coContactCompositeFK2.firstName FROM Agreements e LEFT OUTER JOIN e.coOperatingNamesCompositeFK1 a LEFT OUTER JOIN e.coContactCompositeFK2 b WHERE 1 =1 AND (e.agreementNumber = '004243')
INCORRECT GENERATED SQL WITH HIBERNATE 4.3.5 Final ======================================== SELECT agreements0_.CAMPUS AS col_0_0_, agreements0_.AGREEMENT_NUMBER AS col_1_0_, agreementc4_.CLASS_DESC AS col_2_0_, agreements0_.CONTRACT_NUMBER AS col_3_0_, agreements0_.EFFECTIVE_DATE AS col_4_0_, agreements0_.EXPIRATION_DATE AS col_5_0_, agreementt3_.TYPE_DESCRIPTION AS col_6_0_, agreements0_.AGREEMENT_COMMENT AS col_7_0_, agreements0_.RESPONSIBLE_ORGANIZATION AS col_8_0_, cocompany6_.COMPANY_NAME AS col_9_0_, agreements7_.STATUS_DESC AS col_10_0_, billingsta8_.STATUS_DESC AS col_11_0_, cooperatin9_.OPERATING_NAME AS col_12_0_, cocontact10_.LAST_NAME AS col_13_0_, cocontact10_.FIRST_NAME AS col_14_0_ FROM AGREEMENTS agreements0_ LEFT OUTER JOIN CO_OPERATING_NAMES cooperatin1_ ON agreements0_.COMPANY_NUMBER =cooperatin1_.COMPANY_NUMBER AND agreements0_.OPERATING_NAME_ID=cooperatin1_.OPERATING_NAME_ID LEFT OUTER JOIN CO_CONTACT cocontact2_ ON agreements0_.MANAGE_COMPANY =cocontact2_.COMPANY_NUMBER AND agreements0_.MANAGE_CONTACT=cocontact2_.CONTACT_NUMBER, AGREEMENT_TYPES agreementt3_, AGREEMENT_CLASSES agreementc4_, CO_COMPANY cocompany6_, AGREEMENT_STATUSES agreements7_, BILLING_STATUSES billingsta8_, CO_OPERATING_NAMES cooperatin9_, CO_CONTACT cocontact10_ WHERE agreements0_.AGREEMENT_TYPE =agreementt3_.AGREEMENT_TYPE AND agreementt3_.AGREEMENT_CLASS =agreementc4_.AGREEMENT_CLASS AND agreements0_.COMPANY_NUMBER =cocompany6_.COMPANY_NUMBER AND agreements0_.AGREEMENT_STATUS =agreements7_.AGREEMENT_STATUS AND agreements0_.BILLING_STATUS =billingsta8_.BILLING_STATUS AND agreements0_.COMPANY_NUMBER =cooperatin9_.COMPANY_NUMBER AND agreements0_.OPERATING_NAME_ID=cooperatin9_.OPERATING_NAME_ID AND agreements0_.MANAGE_COMPANY =cocontact10_.COMPANY_NUMBER AND agreements0_.MANAGE_CONTACT =cocontact10_.CONTACT_NUMBER AND 1 =1 AND agreements0_.AGREEMENT_NUMBER ='004243'
EXPECTED GENERATED SQL ======================================= SELECT agreements0_.CAMPUS AS col_0_0_, agreements0_.AGREEMENT_NUMBER AS col_1_0_, agreementc4_.CLASS_DESC AS col_2_0_, agreements0_.CONTRACT_NUMBER AS col_3_0_, agreements0_.EFFECTIVE_DATE AS col_4_0_, agreements0_.EXPIRATION_DATE AS col_5_0_, agreementt3_.TYPE_DESCRIPTION AS col_6_0_, agreements0_.AGREEMENT_COMMENT AS col_7_0_, agreements0_.RESPONSIBLE_ORGANIZATION AS col_8_0_, cocompany6_.COMPANY_NAME AS col_9_0_, agreements7_.STATUS_DESC AS col_10_0_, billingsta8_.STATUS_DESC AS col_11_0_, cooperatin1_.OPERATING_NAME AS col_12_0_, cocontact2_.LAST_NAME AS col_13_0_, cocontact2_.FIRST_NAME AS col_14_0_ FROM AGREEMENTS agreements0_ LEFT OUTER JOIN CO_OPERATING_NAMES cooperatin1_ ON agreements0_.COMPANY_NUMBER =cooperatin1_.COMPANY_NUMBER AND agreements0_.OPERATING_NAME_ID=cooperatin1_.OPERATING_NAME_ID LEFT OUTER JOIN CO_CONTACT cocontact2_ ON agreements0_.MANAGE_COMPANY =cocontact2_.COMPANY_NUMBER AND agreements0_.MANAGE_CONTACT=cocontact2_.CONTACT_NUMBER, AGREEMENT_TYPES agreementt3_, AGREEMENT_CLASSES agreementc4_, CO_COMPANY cocompany6_, AGREEMENT_STATUSES agreements7_, BILLING_STATUSES billingsta8_ WHERE agreements0_.AGREEMENT_TYPE =agreementt3_.AGREEMENT_TYPE AND agreementt3_.AGREEMENT_CLASS =agreementc4_.AGREEMENT_CLASS AND agreements0_.COMPANY_NUMBER =cocompany6_.COMPANY_NUMBER AND agreements0_.AGREEMENT_STATUS =agreements7_.AGREEMENT_STATUS AND agreements0_.BILLING_STATUS =billingsta8_.BILLING_STATUS AND 1 =1 AND agreements0_.AGREEMENT_NUMBER ='004243'
|