Resio sam da posle dugog vremena predjem sa verzije 4 MySQL servera na verziju 5.
Koliko sam mogao da primetim, prilikom INSERT, CREATE i prostih SELECT upita nema problema sa kompatibilnoscu.
Medjutim, kod kompleksnijih upita sa LEFT JOIN komandom imam problema:
SELECT
events.importance,
events.color,
events.id,
events.event_type_id,
events.date_time,
event_types.name,
events.description,
events.document_info,
employees.display,
records.name,
users.name
FROM events, changes, objects
LEFT JOIN records on events.record_id = records.id
LEFT JOIN event_types on events.event_type_id = event_types.id
LEFT JOIN employees on events.employee_id = employees.id
LEFT JOIN users on events.user_id = users.id
WHERE events.id = changes.event_id
AND events.record_id = 1
AND objects.locked = "false"
GROUP BY events.id
ORDER BY events.date_time DESC
Ovaj upit koji lepo radi u 4.x verziji, daje gresku Unknown column 'events.record_id' in 'on clausule' u verziji 5.x servera.
Da li sam nesto propustio, ili da li treba da na nesto obratim paznju prilikom koriscenja LEFT JOIN u v5.x servera?
Hvala najlepse