Your message dated Sun, 3 Jul 2016 11:46:27 +0200 with message-id <[email protected]> and subject line closing bugs reported against ancient mysql-5.1 has caused the Debian Bug report #468288, regarding correlated subqueries in from (nested) to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact [email protected] immediately.) -- 468288: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=468288 Debian Bug Tracking System Contact [email protected] with problems
--- Begin Message ---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
--- End Message ---
--- Begin Message ---This bug has been reported against an ancient version of mysql (5.1), that was last released with Debian 6.0 (squeeze). But even squeeze-lts has now reached end-of-life and is no longer supported. The bug is assumed to be fixed (or no longer relevant) in newer mysql (or mariadb) releases and therefore I'm closing this report now. If the problem is still reproducible in the currently supported versions (mysql-5.6/mysql-5.7), feel free to provide more information, reopen and reassign this bug report. Andreas
--- End Message ---
