From: frosty dot z at freesbee dot fr Operating system: Win 2000 PHP version: 4.3.4 PHP Bug Type: ODBC related Bug description: odbc_statistics()
Description: ------------ Good morning, I've tried to use the function odbc_statistics() to get information from tables of a Filemaker Pro database (using ODBC driver). With any value I've tried, odbc_statistics() returns always FALSE (+ SQL Error). Thank you very much for any help or explanation ; I suppose this to be a bug, but it might be a problem from the Filemaker ODBC driver as well. ... And sorry for the english mistakes (I'm french) ========== Similar bugs : bug #25757, bug #18941 Reproduce code: --------------- $id_odbc = odbc_connect(FM_HOST, FM_LOGIN, FM_PASSWORD); $res = odbc_statistics($id_odbc, NULL, NULL, "product_family", 0, 0); // I've tried "" and "%" instead of NULL for the 2nd and 3rd arguments // I've tried many numbers for the last two (too few doc, I don't know what they do) $row = odbc_fetch_array($res); //print $row['CARDINALITY']; //etc. Expected result: ---------------- I expected to be able to get some statistics of a table. Actual result: -------------- Here is the actual result : Warning: odbc_statistics(): SQL error: , SQL state 00000 in SQLStatistics in c:\maxime\prmt\appli\add_product.php on line 47 Warning: odbc_fetch_array(): supplied argument is not a valid ODBC result resource in c:\maxime\prmt\appli\add_product.php on line 51 ---------------- Curiously, SQL state 00000 means "success", and a SQL error is generated. Since similar problems have been reported for other functions such as odbc_columns, I guess this could be a PHP bug... -- Edit bug report at http://bugs.php.net/?id=26348&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=26348&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=26348&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=26348&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=26348&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=26348&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=26348&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=26348&r=support Expected behavior: http://bugs.php.net/fix.php?id=26348&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=26348&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=26348&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=26348&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=26348&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=26348&r=dst IIS Stability: http://bugs.php.net/fix.php?id=26348&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=26348&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=26348&r=float