#42794 [NEW]: nested ingres_fetch_object dont work

From: V dot Bulov at VAZ dot ru Operating system: FC6 PHP version: 5.2.4 PHP Bug Type: Ingres II related Bug description: nested ingres_fetch_object dont work Description: ------------ Why nested ingres_fetch_object dotn work? for examle $link1 = ingres_connect (getenv("Z_NEW"),"kpl","kpl"); $link2 = ingres_connect (getenv("Z_NEW"),"kpl","kpl"); $S1 = ingres_query ( "select * from table1 " ,$link1); while ( $R1 = ingres_fetch_object(INGRES_ASSOC,link1) ) { $S2 = ingres_query ( "select * from table2 where xx = " . $R1->xx" ,$link2); $R2 = ingres_fetch_object(INGRES_ASSOC,link2); } In this case fetch only 1 records from table1. If comments // $R2 = ingres_fetch_object(INGRES_ASSOC,link2); All work true. Why? Where my mistake? Reproduce code: --------------- Why nested ingres_fetch_object dotn work? for examle $link1 = ingres_connect (getenv("Z_NEW"),"kpl","kpl"); $link2 = ingres_connect (getenv("Z_NEW"),"kpl","kpl"); $S1 = ingres_query ( "select * from table1 " ,$link1); while ( $R1 = ingres_fetch_object(INGRES_ASSOC,link1) ) { $S2 = ingres_query ( "select * from table2 where xx = " . $R1->xx" ,$link2); $R2 = ingres_fetch_object(INGRES_ASSOC,link2); } In this case fetch only 1 records from table1. If comments // $R2 = ingres_fetch_object(INGRES_ASSOC,link2); All work true. Why? Where my mistake? -- Edit bug report at http://bugs.php.net/?id=42794&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=42794&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=42794&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=42794&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=42794&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=42794&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=42794&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=42794&r=needscript Try newer version: http://bugs.php.net/fix.php?id=42794&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=42794&r=support Expected behavior: http://bugs.php.net/fix.php?id=42794&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=42794&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=42794&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=42794&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=42794&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=42794&r=dst IIS Stability: http://bugs.php.net/fix.php?id=42794&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=42794&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=42794&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=42794&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=42794&r=mysqlcfg