From: drei at porrigt dot se Operating system: Linux mini 2.4.22 PHP version: 4.3.3 PHP Bug Type: MySQL related Bug description: left()
Description: ------------ it could be that php is compiled the wrong way, or this could be a bug. im not sure. the problem is with the left() syntax in mysql, it wont output anything. working fine when i run it in a shell, but not with php! Reproduce code: --------------- select left(blob,5) from table Expected result: ---------------- if blob would contain 'abcdefghijklmnopqrstuvwxyz' it should return 'abcde' Actual result: -------------- nothing. -- Edit bug report at http://bugs.php.net/?id=26091&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=26091&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=26091&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=26091&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=26091&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=26091&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=26091&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=26091&r=support Expected behavior: http://bugs.php.net/fix.php?id=26091&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=26091&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=26091&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=26091&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=26091&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=26091&r=dst IIS Stability: http://bugs.php.net/fix.php?id=26091&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=26091&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=26091&r=float