ID: 34067 User updated by: syre at citiz dot net Reported By: syre at citiz dot net -Status: Bogus +Status: Open Bug Type: MySQL related Operating System: win2000 PHP Version: 5.0.3 New Comment:
see bug #31044 even phpmyadmin can not get the correct result Previous Comments: ------------------------------------------------------------------------ [2005-08-10 13:59:36] [EMAIL PROTECTED] Sorry, but your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not the appropriate forum for asking support questions. Due to the volume of reports we can not explain in detail here why your report is not a bug. The support channels will be able to provide an explanation for you. Thank you for your interest in PHP. . ------------------------------------------------------------------------ [2005-08-10 13:57:54] syre at citiz dot net Description: ------------ mysql extension can not get correct result in some cases Reproduce code: --------------- ( SELECT '' AS Code FROM test1£¬type as Type WHERE 1 ) UNION ALL ( SELECT code AS Code,'' as Type FROM test2 WHERE 1 ) Expected result: ---------------- just as the result in mysql console Actual result: -------------- field Code will always be empty. if uses ( SELECT code AS Code,'' as Type FROM test2 WHERE 1 ) UNION ALL ( SELECT '' AS Code FROM test1£¬type as Type WHERE 1 ) that will ok. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=34067&edit=1
