#37671 [Asn->Csd]: MySQLi extension fails to recognize BIT colums

ID: 37671 Updated by: iliaa@php.net Reported By: squasar at eternalviper dot net -Status: Assigned +Status: Closed Bug Type: MySQLi related Operating System: * PHP Version: 5.2 CVS Assigned To: iliaa New Comment: This bug has been fixed in CVS. Snapshots of the sources are packaged every three hours; this change will be in the next snapshot. You can grab the snapshot at http://snaps.php.net/. Thank you for the report, and for helping us make PHP better. Previous Comments: ------------------------------------------------------------------------ [2006-07-03 06:55:10] judas dot iscariote at gmail dot com long(0) refcount(1) long(0) refcount(1) long(0) refcount(1) long(0) refcount(1) Linux 64 bit, current 5_2 CVS, Mysql 5.0.22... 64 bit problem ? ------------------------------------------------------------------------ [2006-06-25 12:16:56] tony2001@php.net With MySQL 5.0.21 & latest 5_2 CVS I get long(0)'s. ------------------------------------------------------------------------ [2006-06-25 10:25:31] squasar at eternalviper dot net I updated to the latest 5.2 branch on CVS and run the exact test code I submitted again. The result: long(0) refcount(1) long(0) refcount(1) long(0) refcount(1) long(0) refcount(1) I don't know what one of us is doing wrong. Tested on both big-endian and little-endian systems. Could it be a 32-bit vs. 64-bit issue? ------------------------------------------------------------------------ [2006-06-20 20:54:29] iliaa@php.net With latest CVS your code returns the following results: long(1) refcount(1) long(0) refcount(1) long(1) refcount(1) long(0) refcount(1) ------------------------------------------------------------------------ [2006-06-08 06:27:06] squasar at eternalviper dot net That sample from the manual is irrelevant. Re-examine the reproduce code I provided. It FAILS using the patch that was applied to CVS; the result is always zero regardless of the values in the column, even though it's a BIT(1). ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/37671 -- Edit this bug report at http://bugs.php.net/?id=37671&edit=1