#20294 [Bgs]: dba_firstkey doesn't work at all with Berkeley DB3 files

ID: 20294 Updated by: rasmus@php.net Reported By: JArmistead@mail.com Status: Bogus Bug Type: DBM/DBA related Operating System: Solaris 2.5.1 PHP Version: 4.2.2 New Comment: Not indistinguishable. False and 0 are distinct values easily distinguished by using the === operator. Previous Comments: ------------------------------------------------------------------------ [2002-11-06 22:10:29] JArmistead@mail.com Silly me, fancy using an initial key of zero (0). This is indistinguishable from the FALSE value (a real TRAP for new players like me !!!). Changing the bounds of the variable "X" ensured that it read back the key / value pairs correctly. Bogus !!! ------------------------------------------------------------------------ [2002-11-06 22:04:10] JArmistead@mail.com Here is some sample source: <? // ** Write to database ** $dbh = dba_open("/tmp/test.db3","c","db3"); for($x=0;$x<500;$x++) { $key = strval($x); $value = "test" . $key; $res = dba_insert($key,$value,$dbh); // Debug if(!$res) echo "Failed to add rec $x<br>"; } dba_close($dbh); echo "Done adding<br>"; // ** Read back ** echo "Read back<br>"; $dbh = dba_open("/tmp/test.db3","r","db3"); if ($dbh == false) { echo "Database failed to open<BR>"; } $key = dba_firstkey($dbh); if ($key == false) { echo "Unable to use dba_firstkey to find initial key<BR>"; } echo "First key is $key<BR>"; $x=0; while($key != false) { $value = dba_fetch($key,$dbh); echo "$key,$value<br>"; $key = dba_nextkey($dbh); $x++; } dba_close($dbh); echo "Finished ! ($x records read back)<br>"; ?> Berkeley-DB is version 3.3.11 C Compiler is GNU C 2.95.3 Apache HTTPD is V2.0.40 PHP configured by './configure' '--with-apxs2=/usr/local/apache2/bin/apxs' '--with-db3=/usr/local/BerkeleyDB.3.3' Basically, it's writing 500 records to the DB3 file (I can cat it and see the resultant output) and then trying to read them back. Not one record is read back because db_firstkey returns FALSE. Help appreciated Jason ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=20294&edit=1