Hello, Currently I'm testing my app using MySQL 4.1.0 version, and I have a strange error during execution a union query.
(SELECT IF(_DAT.pri <=> null, null, ROUND(_DAT.pri/1.22)) AS pri_net,
IF(_DAT.pri <=> null, null, ROUND(_DAT.price*1)) AS pri_gross,
_DAT.cuid, _CUR.code FROM tab1 _DAT, tab2 _CUR WHERE _DAT.eid = '6925'
AND _DAT.did = '3' AND _CUR.cuid = _DAT.cuid ) UNION (SELECT IF(pri <=> null, null, ROUND(pri/1.22)) AS prinet, IF(pri <=>
null, null, ROUND(pri*1)) AS pri_gross, null AS cuid, null AS code FROM
tab3 WHERE eid = '6925' AND did = '3' AND (enid = '1358' OR boid =
'1004' OR trid = '779' OR coid = '9773') ORDER BY coid DESC, veid DESC,
yeid DESC, trid DESC, boid DESC, enid DESC LIMIT 1 )
In version 4.0.14 all was working fine, but there is an error in 4.1.0: "Column 'code' cannot be null"
Any ideas ??
it is a bug in 4.1.0
Fixed a bug in UNION which prohibited that NULL values are inserted in result set where first SELECT contains NOT NULL columns
http://www.mysql.com/doc/en/News-4.1.1.html
-- Sebastian Mendel
www.sebastianmendel.de www.tekkno4u.de www.nofetish.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
