MyQuery works on MySQL 3.23 but not on MySQL 5

bluenose1970 · Post by **bluenose1970** » Wed 28 Mar 2007 14:19

Hi

I am currently evaluating the MySQL components with a view of purchasing but have the following problem.

I've got a rather large query that works fine on a MySQL 3.23 database, but when i try and run the query on a MySQL 5 database i get the following error :

EMyError

Exception message : #42S22 unknown column xxxx in on 'clause'

Any ideas/suggestions/comments welcome.

TIA
bluenose

bluenose1970 · Post by **bluenose1970** » Wed 28 Mar 2007 14:29

Seems to be a pattern to it :

All queries that use LEFT JOIN seem to be failing with the above message.

Antaeus · Post by **Antaeus** » Thu 29 Mar 2007 09:34

Please supply us with the exact MyDAC version you are using and the exact steps to reproduce the problem.
Check the text of the query that is sent to the server. You can do this using the TMySQLMonitor component (the tfMisc trace flag should be enabled) or using MySQL logs (run your MySQL server with the --log=log_file_name.log option).

bluenose1970 · Post by **bluenose1970** » Thu 29 Mar 2007 12:15

It seems to be problem with MySQL and the way join are interpreted!