[debian-mysql] Bug#468288: mysql-server-5.0: Can't refer to outer table in SELECT FROM .. SELECT FROM subquery

[Frédéric Brière]

Package: mysql-server-5.0
Version: 5.0.51a-3
Severity: normal

Here's a (simplified to the point of uselessness) example that should
intuitively be allowed, but is not:

  mysql> CREATE TABLE foo (i INT);

  mysql> CREATE TABLE bar (j INT);

  mysql> SELECT count(*) FROM foo WHERE EXISTS
  	(SELECT * FROM (SELECT * FROM bar WHERE foo.i = bar.j)) AS baz;

  ERROR 1054 (42S22): Unknown column 'foo.i' in 'where clause'


-- System Information:
Debian Release: lenny/sid
  APT prefers unstable
  APT policy: (1001, 'unstable')
Architecture: i386 (i686)

Kernel: Linux 2.6.18 (SMP w/1 CPU core)
Locale: LANG=en_CA.UTF-8, LC_CTYPE=en_CA.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages mysql-server-5.0 depends on:
ii  adduser                3.105             add and remove users and groups
ii  debconf [debconf-2.0]  1.5.19            Debian configuration management sy
ii  libc6                  2.7-8             GNU C Library: Shared libraries
ii  libdbi-perl            1.602-1           Perl5 database interface by Tim Bu
ii  libgcc1                1:4.3-20080219-1  GCC support library
ii  libmysqlclient15off    5.0.51a-3         MySQL database client library
ii  libncurses5            5.6+20080203-1    Shared libraries for terminal hand
ii  libreadline5           5.2-3             GNU readline and history libraries
ii  libstdc++6             4.3-20080219-1    The GNU Standard C++ Library v3
ii  libwrap0               7.6.dbs-14        Wietse Venema's TCP wrappers libra
ii  lsb-base               3.1-24            Linux Standard Base 3.1 init scrip
ii  mysql-client-5.0       5.0.51a-3         MySQL database client binaries
ii  mysql-common           5.0.51a-3         MySQL database common files
ii  passwd                 1:4.1.0-2         change and administer password and
ii  perl                   5.8.8-12          Larry Wall's Practical Extraction 
ii  psmisc                 22.6-1            Utilities that use the proc filesy
ii  zlib1g                 1:1.2.3.3.dfsg-11 compression library - runtime

Versions of packages mysql-server-5.0 recommends:
ii  bsd-mailx [mailx]  8.1.2-0.20071201cvs-2 A simple mail user agent
pn  libhtml-template-p <none>                (no description available)
ii  mailx              1:20071201-2          Transitional package for mailx ren

-- debconf information excluded