Bug #41404 [Opn->Fbk]: ODBC makes memory leaks

Edit report at https://bugs.php.net/bug.php?id=41404&edit=1 ID: 41404 Updated by: cmb@php.net Reported by: geniuz at geniuz dot cz Summary: ODBC makes memory leaks -Status: Open +Status: Feedback Type: Bug Package: ODBC related Operating System: XP PHP Version: 5.2.2 -Assigned To: +Assigned To: cmb Block user comment: N Private report: N New Comment: > SQL error: Failed to fetch error message, SQL state HY000 This is likely due to bug #80150 which has recently been fixed. So please try with a recent Git snapshot of PHP-7.3 or PHP-7.4, or with PHP 7.3.24 or 7.4.12 (which are scheduled to be released end of October). Previous Comments: ------------------------------------------------------------------------ [2008-09-27 05:55:50] bmeekhof at umich dot edu I am able to reproduce this bug using PHP 5.2.6 and Microsoft-IIS/6.0 running on Windows NT (phpinfo says only windows NT, whether it might really be W200X Server I couldn't say). I am using ADODB with the odbc_oracle driver. In my case it is triggered by querying for any CLOB column from an Oracle database. I get no results and the driver says it cannot retrieve the error message and also gives an error HY000 (same as reported in bug). The same query is fine if I do not include the only CLOB field in this particular table. Querying for that field by itself or in combination with the others will produce the error. I have not seen the memory error also reported in the bug. ------------------------------------------------------------------------ [2007-05-15 21:34:24] geniuz at geniuz dot cz Description: ------------ When I select over ODBC from table with any column data type defined as TEXT (detected over odbc_columns function), and I fetch rows, I receive one of following messages or php freeze. I selected more than 100000 rows. When I replaced selected TEXT data type column for any other column ie. STRING data type column (and with more saved datas), all is ok without errors. Well, problem must be with TEXT datatype (LONG columns). Warning: odbc_exec() [function.odbc-exec]: SQL error: Failed to fetch error message, SQL state HY000 in SQLExecDirect in M:\4D\.WebRoot\ctp\eshop\index.php on line 65 Warning: odbc_exec() [function.odbc-exec]: SQL error: [Simba][Simba ODBC Driver]Memory allocation error., SQL state S1001 in SQLExecDirect in M:\4D\.WebRoot\ctp\eshop\index.php on line 65 Reproduce code: --------------- $sql = "SELECT Col1, Col2, Col3 FROM MYTABLE"; $rs=odbc_exec($conn,$sql); while( odbc_fetch_row($rs) ) { $data1 = odbc_result($rs,'Col1'); $data2 = odbc_result($rs,'Col2'); $data3 = odbc_result($rs,'Col3'); } Expected result: ---------------- no sql error Actual result: -------------- sql error ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=41404&edit=1