Bug #2758: joined MySQL queries fail

From: admin@i-1.net Operating system: BSD/OS 4.0 / 4.0.1 PHP version: 3.0.12 PHP Bug Type: MySQL related Bug description: joined MySQL queries fail After upgrading PHP from 4.0b2 to 4.02b3, the following MySQL query (which has not changed) no longer works: select x.name, x.place, y.color, y.shade from locations as x, prefs as y The error returned is: Warning: x not found in MySQL result index 7 in mysql.php3 on line 26 Warning: y not found in MySQL result index 7 in mysql.php3 on line 26 Line 26 of mysql.php3 is: $result = mysql_result($qhandle,$row,$field); This has not changed either -- it worked yesterday :-) The problem is reproducible, and is affecting all my php scripts which contain queries structured in the same fashion. Config/Build options have only changed in one respect from 4.0b2 to 4.0b3; I had to compile with --disable-inline to work around a virtual memory exhaustion problem. Here's the config line I used to build PHP: --with-mysql=/usr/local/mysql \ --with-apache=../apache_1.3.9 \ --enable-track-vars \ --disable-inline \ --with-config-file-path=/var/www/conf