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

ID: 37671 Updated by: sniper@php.net Reported By: squasar at eternalviper dot net -Status: Open +Status: Assigned Bug Type: MySQLi related Operating System: * PHP Version: 5.2 CVS Assigned To: iliaa 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