Hi all, why does Hibernate generate the sql select command with duplicate columns?
I'm using Hibernate 2.1.6 The table I am trying to read has a compound id. Note in the following sql there are 3 columns for ABSENCE_ID:
select prmabsence0_.ABSENCE_ID as ABSENCE_ID__, prmabsence0_.SEQUENCE as SEQUENCE__, prmabsence0_.ABSENCE_ID as ABSENCE_ID0_, prmabsence0_.SEQUENCE as SEQUENCE0_, prmabsence0_.LEAVE_ID as LEAVE_ID0_, prmabsence0_.HOUR_AMT as HOUR_AMT0_, prmabsence0_.OPS_GL as OPS_GL0_, prmabsence0_.FL_ID_NO as FL_ID_NO0_, prmabsence0_.FL_NO as FL_NO0_, prmabsence0_.HRS_OR_FTE as HRS_OR_FTE0_, prmabsence0_.AMENDMENT_STAT as AMENDMEN9_0_, prmabsence0_.UNIT_TYPE as UNIT_TYPE0_, prmabsence0_.LOCATION as LOCATION0_, prmabsence0_.ABSENCE_CODE as ABSENCE12_0_, prmabsence0_.ABSENCE_DATE as ABSENCE13_0_, prmabsence0_.FL_DIST_NO as FL_DIST_NO0_, prmabsence0_.INTERFACE_SEQ as INTERFA15_0_, prmabsence0_.EMPLOYEE_NO as EMPLOYE16_0_, prmabsence0_.STATUS as STATUS0_, prmabsence0_.START_TIME as START_TIME0_, prmabsence0_.AM_OR_PM as AM_OR_PM0_, prmabsence0_.AMENDMENT_RULE as AMENDME20_0_, prmabsence0_.WEEK_END_DATE as WEEK_EN21_0_, prmabsence0_.AMENDMENT_SEQ as AMENDME22_0_, prmabsence0_.REAL_HOURS as REAL_HOURS0_, prmabsence0_.DAY_COUNT as DAY_COUNT0_, prmabsence0_.UNIT_AMT as UNIT_AMT0_, prmabsence0_.OCCUPATION_CODE as OCCUPAT26_0_, prmabsence0_.PAY_RATE as PAY_RATE0_, prmabsence0_.LEAVE_UNITS as LEAVE_U28_0_, prmabsence0_.OPS_HOURS_AMT as OPS_HOU29_0_, prmabsence0_.BATCH_NO as BATCH_NO0_, prmabsence0_.DAY_AMT as DAY_AMT0_, prmabsence0_.HOURS_PER_DAY as HOURS_P32_0_, prmabsence0_.PAY_CODE as PAY_CODE0_, prmabsence0_.STATUS1 as STATUS10_, prmabsence0_.ABSENCE_POSITION as ABSENCE35_0_, prmabsence0_.PAYROLL_ID as PAYROLL_ID0_, prmabsence0_.SHIFT_CODE as SHIFT_CODE0_, prmabsence0_.INTERFACE_SRC as INTERFA38_0_, prmabsence0_.END_TIME as END_TIME0_, prmabsence0_.COST_CENTER as COST_CE40_0_, prmabsence0_.INTERFACE_STAT as INTERFA41_0_, prmabsence0_.FL_ORDER_NO as FL_ORDE42_0_, prmabsence0_.ABSENCE_ID as ABSENCE_ID0_ from ABSENCE_DETAIL prmabsence0_ where prmabsence0_.ABSENCE_ID='20040914000069
|