From: rudy dot metzger at xs4all dot nl Operating system: Linux RH ES 3 PHP version: 5.0.0 PHP Bug Type: MySQL related Bug description: mysql_file_type returns bogus data
Description: ------------ mysql_file_type() returns bogus data. PHP 5.0.0 mysql> desc zpm_auth; +----------+-------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------------------+-------+ | userid | varchar(20) | | PRI | | | | username | varchar(50) | YES | | NULL | | | password | varchar(32) | YES | | NULL | | | creusr | varchar(32) | | | | | | credat | datetime | | | 0000-00-00 00:00:00 | | | modusr | varchar(32) | | | | | | moddat | datetime | | | 0000-00-00 00:00:00 | | +----------+-------------+------+-----+---------------------+-------+ 7 rows in set (0.00 sec) mysql> select version(); +--------------------------+ | version() | +--------------------------+ | 4.1.2-alpha-standard-log | +--------------------------+ 1 row in set (0.00 sec) mysql> $sql = "SELECT userid FROM zpm_auth LIMIT 1"; $res = mysql_query( $sql, $this->DBH() ); $this->EvaluateCommand( $res, false, true, $sql ); $colType = mysql_field_type( $res, 0 ); die( $colType ); Works in PHP5 RC3 -- Edit bug report at http://bugs.php.net/?id=29215&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=29215&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=29215&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=29215&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=29215&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=29215&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=29215&r=needscript Try newer version: http://bugs.php.net/fix.php?id=29215&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=29215&r=support Expected behavior: http://bugs.php.net/fix.php?id=29215&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=29215&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=29215&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=29215&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=29215&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=29215&r=dst IIS Stability: http://bugs.php.net/fix.php?id=29215&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=29215&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=29215&r=float