Fixed bug #27532: wrong results with ORDER/GROUP BY queries containing
igor@olga.mysql.com authored
IN/BETWEEN predicates in sorting expressions.
Wrong results may occur when the select list contains an expression
with IN/BETWEEN predicate that differs from a sorting expression by
an additional NOT only.
 
Added the method Item_func_opt_neg::eq to compare correctly expressions
containing [NOT] IN/BETWEEN.
The eq method inherited from the Item_func returns TRUE when comparing
'a IN (1,2)' with 'a NOT IN (1,2)' that is not, of course, correct.  
90aa05d2
Name Last commit Last update
BUILD Merge jbruehe@bk-internal.mysql.com:/home/bk/mysql-4.1-build
BitKeeper Test and bug fixes and removed unneccessary files.
Docs .del-fill_func_tables.sh:
SSL Added missing SSL library (Should be in source distribution)
VC++Files mysys_ia64.dsp, mysys.vcproj:
bdb gen_rec.awk:
client Add two more USE_CYGWIN ifdefs to mysqltest
cmd-line-utils Makefile.am, configure.in:
dbug Makefile.am:
extra Bug#25344 Segmentation violation when try to run the perror utility
heap Bug#26996 - Update of a Field in a Memory Table ends with wrong result
include Merge mysql.com:/home/kent/bk/tmp/mysql-4.0
innobase Applied innodb-4.1-ss36 and innodb-4.1-ss38 snapshots
isam Merge a193-229-222-105.elisa-laajakaista.fi:/home/my/bk/mysql-4.0
libmysql Merge bk-internal.mysql.com:/home/bk/mysql-4.1
libmysql_r gen_rec.awk:
libmysqld bug #25492 (Invalid deallocation in mysql_stmt_fetch())
man Makefile.am, configure.in:
merge Makefile.am:
myisam Merge chilla.local:/home/mydev/mysql-4.1-bug26231
myisammrg Merge mysql.com:/home/svoj/devel/bk/mysql-4.1-engines
mysql-test Fixed bug #27532: wrong results with ORDER/GROUP BY queries containing
mysys Merge mysql.com:/home/kent/bk/tmp/mysql-4.0
ndb Merge siva.hindu.god:/home/tsmith/m/bk/41
netware Merge mysql.com:/Users/kent/mysql/bk/mysql-4.0
os2
pstack
regex
scripts
sql-bench
sql-common
sql
strings
support-files
tests
tools
vio
zlib
.bzrignore
.cvsignore
COPYING
EXCEPTIONS-CLIENT
Makefile.am
README
acinclude.m4
config.guess
config.sub
configure.in
configure.in.rej
depcomp
install-sh
ltconfig
ltmain.sh
missing
mkinstalldirs
This is a release of MySQL, a dual-license SQL database server.
MySQL is brought to you by the MySQL team at MySQL AB.

License information can be found in these files:
- For GPL (free) distributions, see the COPYING file and
  the EXCEPTIONS-CLIENT file.
- For commercial distributions, see the LICENSE.mysql file.


For further information about MySQL or additional documentation, see:
- The latest information about MySQL: http://www.mysql.com
- The current MySQL documentation: http://dev.mysql.com/doc

Some manual sections of special interest:

- If you are migrating from an older version of MySQL, please read the
  "Upgrading from..." section first!
- To see what MySQL can do, take a look at the features section.
- For installation instructions, see the Installing and Upgrading chapter.
- For the new features/bugfix history, see the Change History appendix.
- For the currently known bugs/misfeatures (known errors) see the Problems
  and Common Errors appendix.
- For a list of developers and other contributors, see the Credits
  appendix.

A local copy of the MySQL Reference Manual can be found in the Docs
directory in GNU Info format.  You can also browse the manual online or
download it in any of several formats at the URL given earlier in this
file.

************************************************************

IMPORTANT:

Bug or error reports should be sent to http://bugs.mysql.com.