MySQL Forums
Forum List  »  Other Migration

MySQL 4.0 => 5.0 - strange...
Posted by: Alex Smith
Date: January 25, 2006 04:49AM

I've began migration from 4 to 5 MySQL. Since I dont use some specific features which are in INCOMPATIBLE list thought migration would be easy.
Strange thing: a simple SQL query

select purchase.unit,purchase.product,store.date,unit.type,retail_store.date as retail_date
from purchase,unit
left outer join store on unit.type<>2 and store.date=... and store.unit=purchase.unit and store.product=purchase.product
left outer join retail_store on unit.type=2 and retail_store.date=... and retail_store.unit=purchase.unit and retail_store.product=purchase.product
where purchase.unit=unit.code

generates an error: "ERROR 1054 (42S22): Unknown column 'purchase.unit' in 'on clause'".
Note that column `unit` in table `purchase` EXISTS! And it exists in query too!

Maybe there is a conflict between column name and table name `unit`? Maybe conflicts with reserved words (but `unit` is not mentioned there)? Maybe SQL implementation changed? Maybe may SQL mode be set more compatible with 4.0? But setting sql-mode=MYSQL40 (seems most reasonable) does not solve the problem! Does anyone have any idea? ;)

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL 4.0 => 5.0 - strange...
4037
January 25, 2006 04:49AM
2473
January 26, 2006 09:05AM
2607
January 26, 2006 08:20PM
2505
January 31, 2006 01:25PM
2864
February 03, 2006 06:00PM
2279
February 04, 2006 02:21PM
2344
February 05, 2006 04:30PM
2430
February 02, 2006 01:23PM
2849
February 03, 2006 06:13PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.