[debian-mysql] Bug#500150: mysql-server-5.0: bug in subquery handling not found in most recent upstream

[Mark Nipper]

Package: mysql-server-5.0
Version: 5.0.51a-12
Severity: important

        So I just ran across this bug which is not present in 5.0.67
upstream.  My report on the bug is at:
---
http://bugs.mysql.com/bug.php?id=39639

        Essentially, the subquery form of an identical join statement is
returning data under 5.0.51 as packaged by Debian but is not returning
any data at all, as it should, under the most recent upstream (I
actually built Ubuntu's 5.0.67 on my Debian box to test this).

        Anyway, point being, there shouldn't be any difference in the
results between using the subquery versus using the join, but there are.
Any advice?  It looks like upstream has closed the bug since it's
apparently fixed in 5.0.67 on their end.

-- System Information:
Debian Release: lenny/sid
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: amd64 (x86_64)

Kernel: Linux 2.6.26-1-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages mysql-server-5.0 depends on:
ii  adduser                3.110             add and remove users and groups
ii  debconf [debconf-2.0]  1.5.22            Debian configuration management sy
ii  libc6                  2.7-13            GNU C Library: Shared libraries
ii  libdbi-perl            1.605-1           Perl5 database interface by Tim Bu
ii  libgcc1                1:4.3.1-9         GCC support library
ii  libmysqlclient15off    5.0.51a-12        MySQL database client library
ii  libncurses5            5.6+20080830-1    shared libraries for terminal hand
ii  libreadline5           5.2-3             GNU readline and history libraries
ii  libstdc++6             4.3.1-9           The GNU Standard C++ Library v3
ii  libwrap0               7.6.q-16          Wietse Venema's TCP wrappers libra
ii  lsb-base               3.2-20            Linux Standard Base 3.2 init scrip
ii  mysql-client-5.0       5.0.51a-12        MySQL database client binaries
ii  mysql-common           5.0.51a-12        MySQL database common files
ii  passwd                 1:4.1.1-3         change and administer password and
ii  perl                   5.10.0-13         Larry Wall's Practical Extraction 
ii  psmisc                 22.6-1            Utilities that use the proc filesy
ii  zlib1g                 1:1.2.3.3.dfsg-12 compression library - runtime

Versions of packages mysql-server-5.0 recommends:
ii  bsd-mailx [mailx]  8.1.2-0.20071201cvs-3 A simple mail user agent
ii  libhtml-template-p 2.9-1                 HTML::Template : A module for usin
ii  mailx              1:20071201-3          Transitional package for mailx ren

Versions of packages mysql-server-5.0 suggests:
pn  tinyca                        <none>     (no description available)

-- debconf information excluded