This fixed problem with index reads on character fields with BDB tables. (Bug #2509)


BitKeeper/etc/ignore:
  added man/*.1
mysql-test/r/bdb.result:
  New test
mysql-test/r/myisam.result:
  More tests
mysql-test/t/bdb.test:
  Test for idnex only read
mysql-test/t/myisam.test:
  More test to verify pushed bug fix
sql/ha_berkeley.h:
  Mark that strings may change on index only reads
sql/item_strfunc.cc:
  Cleanup
sql/table.cc:
  Allow index only reads on binary strings

into gw.mysql.r18.ru:/usr/home/ram/work/4.0.b2298


myisam/mi_search.c:
  Auto merged

into eagle.mysql.r18.ru:/home/vva/work/BUG_2290/mysql-4.0

into eagle.mysql.r18.ru:/home/vva/work/BUG_2290/mysql-4.0

mysql-test/t/func_str.test:
  add skipped new line
sql/item_strfunc.cc:
  rewrote some comments for Item_func_elt

<monty> ramil, in MySQL/MyISAM we should only strip end space, not 'space-like' characters.
<monty> This is according to SQL;  When doing a comparision end space and only end space are ignored.



myisam/mi_key.c:
  a proper fix for the bug #2298 Trailing whitespace inconsistently handled in WHERE clause.
myisam/mi_search.c:
  a proper fix for the bug #2298 Trailing whitespace inconsistently handled in WHERE clause.
mysql-test/r/select.result:
  test case for the bug #2298 Trailing whitespace inconsistently handled in WHERE clause.
mysql-test/t/select.test:
  test case for the bug #2298 Trailing whitespace inconsistently handled in WHERE clause.
sql/sql_string.cc:
  a proper fix for the bug #2298 Trailing whitespace inconsistently handled in WHERE clause.

into mysql.com:/space/my/mysql-4.0-build

   spec file after the build as RPM has its own option for this


Build-tools/Do-rpm:
   - remove unnecessary code to delete the source tarball and spec file
     after the build as RPM has its own option for this

into mysql.com:/space/my/mysql-4.0

into mysql.com:/space/my/mysql-4.0-build

sql/item_strfunc.cc:
  fixed bug #2290 "output truncated with ELT when using DISTINCT"

into mysql.com:/home/mysql_src/mysql-4.0

do not write the Execute_load_log_event if there was no Create_file_log_event
(empty file).

manpage) turned out as a major overhaul of all man pages:

 - renamed all *.1 files to *.1.in to act as templates which are being
   processed at build time
 - replaced some hard-coded values with place holder that are being
   replaced with the proper values at build time
 - Updated list of available man pages in the SEE ALSO section and added a
   hint to the manual for more details
 - Added a BUGS section to all pages, referring to the bugs DB
 - Updated some obsolete URLs and mail addresses

The actual content of these man pages should probably be cross-checked for
correctness, though...


man/Makefile.am:
   - Replace some hard-coded values in the man pages with the proper values
     at build time instead. Instead of the *.1 files, we now add the *.1.in
     files (the templates) to the source distribution and generate the *.1
     files during make.
man/isamchk.1.in:
   - replaced some hard-coded values (e.g. Version numbers) with variables
     which are replaced with the proper values at build time
   - Updated list of other man pages listed in SEE ALSO
   - Added BUGS section, referring to the bugs database
   - Updated URL and Mail address
man/isamlog.1.in:
   - replaced some hard-coded values (e.g. Version numbers) with variables
     which are replaced with the proper values at build time
   - Updated list of other man pages listed in SEE ALSO
   - Added BUGS section, referring to the bugs database
   - Updated URL and Mail address
man/mysql_fix_privilege_tables.1.in:
   - replaced some hard-coded values (e.g. Version numbers) with variables
     which are replaced with the proper values at build time
   - Updated list of other man pages listed in SEE ALSO
   - Added BUGS section, referring to the bugs database
   - Updated URL and Mail address
man/mysql_zap.1.in:
   - replaced some hard-coded values (e.g. Version numbers) with variables
     which are replaced with the proper values at build time
   - Updated list of other man pages listed in SEE ALSO
   - Added BUGS section, referring to the bugs database
   - Updated URL and Mail address
man/mysqlaccess.1.in:
   - replaced some hard-coded values (e.g. Version numbers) with variables
     which are replaced with the proper values at build time
   - Updated list of other man pages listed in SEE ALSO
   - Added BUGS section, referring to the bugs database
   - Updated URL and Mail address
man/mysqladmin.1.in:
   - replaced some hard-coded values (e.g. Version numbers) with variables
     which are replaced with the proper values at build time
   - Updated list of other man pages listed in SEE ALSO
   - Added BUGS section, referring to the bugs database
   - Updated URL and Mail address
man/mysqld.1.in:
   - replaced some hard-coded values (e.g. Version numbers) with variables
     which are replaced with the proper values at build time
   - Updated list of other man pages listed in SEE ALSO
   - Added BUGS section, referring to the bugs database
   - Updated URL and Mail address
man/mysqld_multi.1.in:
   - replaced some hard-coded values (e.g. Version numbers) with variables
     which are replaced with the proper values at build time
   - Updated list of other man pages listed in SEE ALSO
   - Added BUGS section, referring to the bugs database
   - Updated URL and Mail address
man/mysqld_safe.1.in:
   - replaced some hard-coded values (e.g. Version numbers) with variables
     which are replaced with the proper values at build time
   - Updated list of other man pages listed in SEE ALSO
   - Added BUGS section, referring to the bugs database
   - Updated URL and Mail address
man/mysqldump.1.in:
   - replaced some hard-coded values (e.g. Version numbers) with variables
     which are replaced with the proper values at build time
   - Updated list of other man pages listed in SEE ALSO
   - Added BUGS section, referring to the bugs database
   - Updated URL and Mail address
man/mysqlshow.1.in:
   - replaced some hard-coded values (e.g. Version numbers) with variables
     which are replaced with the proper values at build time
   - Updated list of other man pages listed in SEE ALSO
   - Added BUGS section, referring to the bugs database
   - Updated URL and Mail address
man/perror.1.in:
   - replaced some hard-coded values (e.g. Version numbers) with variables
     which are replaced with the proper values at build time
   - Updated list of other man pages listed in SEE ALSO
   - Added BUGS section, referring to the bugs database
   - Updated URL and Mail address
man/replace.1.in:
   - replaced some hard-coded values (e.g. Version numbers) with variables
     which are replaced with the proper values at build time
   - Updated list of other man pages listed in SEE ALSO
   - Added BUGS section, referring to the bugs database
   - Updated URL and Mail address
man/mysql.1.in:
   - replaced some hard-coded values (e.g. Version numbers, path names) with
     variables which are replaced with the proper values at build time
   - Updated list of other man pages listed in SEE ALSO
   - Added BUGS section, referring to the bugs database
   - Updated URL and Mail address

into serg.mylan:/usr/home/serg/Abk/mysql-4.0


myisam/mi_dynrec.c:
  Auto merged

sql/key.cc:
  Change constant to define

into mysql.com:/home/my/mysql-4.0

I remove the --old-rpl-compat which produces broken binlogs readable
neither by 4.0 nor by 3.23.
This option is a leftover of the early replication of 4.0.0, when
it was still partly compatible with 3.23.
I explained this to the user in the bug report. 


sql/mysqld.cc:
  removing --old-rpl-compat
sql/sql_load.cc:
  removing --old-rpl-compat
sql/sql_repl.h:
  removing --old-rpl-compat

into mysql.com:/home/kostja/mysql/mysql-4.0-root

into sinisa.nasamreza.org:/mnt/work/mysql-4.0

myisam/mi_dynrec.c:
  Fixed table crash bug when updating row > 16M

for re-working project files and enabling remote builds.

into mysql.com:/space/my/mysql-4.0

into serg.mylan:/usr/home/serg/Abk/mysql-4.0

   started via mysqld_safe (BUG#2114) Thanks to Rodrigo Marchant for the
   suggestion


scripts/mysqld_safe.sh:
   - fixed early removing of socket file when multiple instances of mysqld are
     started via the script (BUG#2114) Thanks to Rodrigo Marchant for the
     suggestion

into mysql.com:/space/my/mysql-4.0-build

  Fix bug: FOREIGN KEY ... ON UPDATE/DELETE NO ACTION must check the foreign key constraint, not ignore it. Peter Gulutzan said that NO ACTION should check the constraint as deferred, at the end of the SQL statement, while RESTRICT should check it immediately. Since we do not have defered constraints in InnoDB, this bug fix makes InnoDB to check NO ACTION constraints immediately, like it checks RESTRICT constraints.


innobase/row/row0ins.c:
  Fix bug: FOREIGN KEY ... ON UPDATE/DELETE NO ACTION must check the foreign key constraint, not ignore it. Peter Gulutzan said that NO ACTION should check the constraint as deferred, at the end of the SQL statement, while RESTRICT should check it immediately. Since we do not have defered constraints in InnoDB, this bug fix makes InnoDB to check NO ACTION constraints immediately, like it checks RESTRICT constraints.

into mysql.com:/space/my/mysql-4.0-build

into mysql.com:/space/my/mysql-4.0

   for the MySQL root user (BUG#2375)


scripts/mysql_install_db.sh:
   - improved wording on what to do to set the password for the MySQL root
     user (BUG#2375)

into serg.mylan:/usr/home/serg/Abk/mysql-4.0