CalEventPersistenceImpl.java queries non-existent calEvent.type column instead of calEvent.type_

• Type: Bug
• Status: Closed
• Resolution: Won't Fix
• Affects Version/s: 6.1.1 CE GA2, 6.2.0 CE M3, 6.2.0 CE M4
• Fix Version/s: None
• Component/s: Calendar
• Labels:
  • community-verifier
• Environment: Liferay 6.1.1 GA2; Ubuntu 10.04; Postgres 9 DB
• Fix Priority: 3

Various SQL fragments refer to non-existant column type in CalEvent table.

See following file and search for "calEvent.type ":
./portal-impl/src/com/liferay/portlet/calendar/service/persistence/CalEventPersistenceImpl.java

As can be see in the portal-tables.sql file, the CalEvent table has a column named "type_", not a column named "type".

Attached see error.log for this error in action when calling CalEventServiceUtil.getEvents(). Although I never ran into this issue during Liferay OOB behavior, it did come up while implementing multi-filter functionality. In any case, there should be no hard-coded reference to a non-existent column anyway, correct?