Bug #14436 Updated: odbc_fetch_row crashes PHP with aliased table

ID: 14436 Updated by: nick@advalue.com Reported By: nick@advalue.com -Status: Open +Status: Closed Bug Type: ODBC related Operating System: WinNT -PHP Version: 4.1.0 +PHP Version: 4.2.0 New Comment: Bug is fixed in 4.2.0. Previous Comments: ------------------------------------------------------------------------ [2001-12-13 15:04:22] nick@advalue.com Bug has been reproduced in PHP 4.1.0, so I've updated the PHP Version number. ------------------------------------------------------------------------ [2001-12-11 16:37:50] nick@advalue.com When using odbc_fetch_row() with specific queries, the PHP module attempts to write to a NULL pointer, which crashes Apache. A query must do the following to cause the problem: 1) The query must use only one table (i.e., no joins). 2) The table's name must be aliased (e.g., "FROM MyTable MyAlias"). 3) The SELECT clause must use the table's alias with at least one column (e.g., "SELECT MyAlias.ID"). The following script can be used to reproduce the bug. <?php $Connection = odbc_pconnect('db','user','pass'); $Result = odbc_exec($Connection,'SELECT MyAlias.ID FROM MyTable MyAlias'); while (odbc_fetch_row($Result)) { echo 'Row<BR>'; } ?> If I expand the query to do a join with another table, it will work fine. It also works fine if I remove the table alias from the SELECT clause. However, the queries I need to use are dynamically generated and it is much simpler if I can alias the table names without worrying about how many tables are being referenced. I'm using PHP 4.0.6 (binary download from PHP.net) on Windows NT 4.0 Workstation with Apache 1.3.22. I'm connecting via ODBC to a remote Oracle 9i database. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=14436&edit=1