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? ;)
Subject
Views
Written By
Posted
MySQL 4.0 => 5.0 - strange...
4273
January 25, 2006 04:49AM
2592
January 26, 2006 09:05AM
2704
January 26, 2006 08:20PM
2605
January 31, 2006 01:25PM
2966
February 03, 2006 06:00PM
2378
February 04, 2006 02:21PM
2470
February 05, 2006 04:30PM
2526
February 02, 2006 01:23PM
3017
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.