Optimize some queries when using LIMIT


merge/open.c:
  Only mark MERGE readonly if all tables are readonly
myisammrg/myrg_open.c:
  Only mark MERGE readonly if all tables are readonly
sql/sql_select.cc:
  Optimize some queries when using LIMIT

Some limit optimization


BitKeeper/deleted/.del-ib_config.h.in~9e57db8504e55b7:
  Delete: innobase/ib_config.h.in
BitKeeper/deleted/.del-ib_config.h~7539e26ffc614439:
  Delete: innobase/ib_config.h
client/errmsg.c:
  Moved error messages from libmysqld/
client/mysql.cc:
  Removed warnings
include/errmsg.h:
  New info for embedded versions
include/mysql_com.h:
  Fixes for embedded MySQL
libmysql/errmsg.c:
  Fixes for embedded MySQL
libmysqld/Makefile.am:
  Added HANDLER code
libmysqld/lib_sql.cc:
  Fixes for embedded MySQL
libmysqld/lib_vio.c:
  Fixes for embedded MySQL
BitKeeper/etc/ignore:
  Added libmysqld/sql_handler.cc to the ignore list
libmysqld/libmysqld.c:
  Fixes for embedded MySQL
mysql-test/r/null_key.result:
  Fixed result for 4.0
sql/net_serv.cc:
  Fixes for embedded MySQL
sql/sql_parse.cc:
  Fixes for embedded MySQL where the query could be a const char*
sql/sql_select.cc:
  Added limit optimization
sql/sql_select.h:
  Added limit optimization

BitKeeper/etc/logging_ok:
  auto-union
configure.in:
  Auto merged
client/mysql.cc:
  Auto merged
client/mysqltest.c:
  Auto merged
mysql-test/mysql-test-run.sh:
  Auto merged
sql/sql_select.cc:
  Auto merged
Docs/manual.texi:
  SCCS merged
sql/Makefile.am:
  SCCS merged

BitKeeper/etc/logging_ok:
  Logging to logging@openlogging.org accepted

univ.i  	Change pthread_yield to sched_yield
configure.in	Change pthread_yield to sched_yield


innobase/configure.in:
  Change pthread_yield to sched_yield
innobase/include/univ.i:
  Change pthread_yield to sched_yield
innobase/os/os0thread.c:
  Change pthread_yield to sched_yield
BitKeeper/etc/logging_ok:
  Logging to logging@openlogging.org accepted

    fixed typo


client/mysqltest.c:
  fixed typo

    added support for alphanumeric variables - import MASTER_MYPORT and
    SLAVE_MYPORT from the environment
mysql-test/mysql-test-run.sh
    export MASTER_MYPORT and SLAVE_MYPORT for mysqltest
mysql-test/t/rpl000015.test
    use MASTER_MYPORT
mysql-test/t/rpl000016.test
    use MASTER_MYPORT


client/mysqltest.c:
  added support for alphanumeric variables - import MASTER_MYPORT and
  SLAVE_MYPORT from the environment
mysql-test/mysql-test-run.sh:
  export MASTER_MYPORT and SLAVE_MYPORT for mysqltest
mysql-test/t/rpl000015.test:
  use MASTER_MYPORT
mysql-test/t/rpl000016.test:
  use MASTER_MYPORT

client/mysqltest.c:
  Cleanup and bug fixes
mysql-test/t/rpl000001.test:
  Fixed typo
mysql-test/t/rpl000015.test:
  Changed to use table t1

Docs/manual.texi:
  Auto merged

Removed unpredictable test from rpl000001.test


Docs/manual.texi:
  Added some information about table locks
libmysql/Makefile.shared:
  Don't force conf_to_src to be static an all systems
mysql-test/r/rpl000001.result:
  Removed unpredictable test
mysql-test/t/rpl000001.test:
  Removed unpredictable test
scripts/mysql_zap.sh:
  Added --help
strings/ctype-ujis.c:
  Removed warnings

Docs/manual.texi:
  Small fixes.
BitKeeper/etc/logging_ok:
  Logging to logging@openlogging.org accepted

scripts/mysql_install_db.sh:
  Fixed typo

BitKeeper/etc/logging_ok:
  Logging to logging@openlogging.org accepted

Fixed rpl000001 to handle the most common mysql-test-run ports.


configure.in:
  Fixed that -ldl is not used for clients
  (The old version breaked when client was compiled staticly)
mysql-test/r/rpl000001.result:
  Fix to handle the most common mysql-test-run ports.
mysql-test/t/rpl000001.test:
  Fix to handle the most common mysql-test-run ports.
mysys/my_alloc.c:
  Extended min block a little to get faster mallocs
scripts/mysql_install_db.sh:
  Fixed bug when using RPM and one had --basedir in my.cnf
sql/Makefile.am:
  Add -ldl to mysqld link line
strings/ctype-ujis.c:
  Remove warnings

Don't reconnect client on close


libmysql/libmysql.c:
  Don't reconnect on close
mysql-test/r/heap.result:
  Fixed heap table test
sql/field.cc:
  Backed out wrong HEAP table bug fix
sql/ha_heap.h:
  cleanup
sql/mini_client.cc:
  Don't reconnect on close
sql/opt_range.cc:
  Don't use ranges on HEAP tables with LIKE

Docs/manual.texi:
  Did a minor addition to the OS recommendation section.
BitKeeper/etc/logging_ok:
  Logging to logging@openlogging.org accepted

Fixed bug with float columns



Docs/manual.texi:
  Added new link
client/mysql.cc:
  The environment variable PAGER is now used as the default pager
sql/field.cc:
  Fixed bug with float columns.

    Added a stern warning in a visible (in my opinion) place to make sure
    to compile with -fno-exceptions when using gcc
    Wrote a new paragraphs on OS comparison/choice in the Which OS section



Docs/manual.texi:
  Added a stern warning in a visible (in my opinion) place to make sure
  to compile with -fno-exceptions when using gcc
  Wrote a new paragraphs on OS comparison/choice in the Which OS section
BitKeeper/etc/logging_ok:
  Logging to logging@openlogging.org accepted

Docs/manual.texi:
  Added InnoDB manual in manual.texi

Docs/manual.texi:
  Updated information about BDB tables.
mysql-test/r/heap.result:
  Added test for HEAP bug
mysql-test/t/heap.test:
  Added test for HEAP bug
sql/field.cc:
  Fixed bug with HEAP tables
sql/gen_lex_hash.cc:
  Smallare array

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


BitKeeper/triggers/post-commit:
  Auto merged
mysql-test/mysql-test-run.sh:
  Auto merged
sql-bench/server-cfg.sh:
  Auto merged

BitKeeper/etc/logging_ok:
  auto-union
Docs/manual.texi:
  Auto merged

typo/bad merge fixed
chmod a-x for man/*.1 files


man/isamchk.1:
  Change mode to -rw-rw-r--
man/mysqlaccess.1:
  Change mode to -rw-rw-r--
man/mysqladmin.1:
  Change mode to -rw-rw-r--
man/mysqld.1:
  Change mode to -rw-rw-r--
man/mysqldump.1:
  Change mode to -rw-rw-r--
man/mysqlshow.1:
  Change mode to -rw-rw-r--
man/perror.1:
  Change mode to -rw-rw-r--
man/safe_mysqld.1:
  Change mode to -rw-rw-r--
mysql-test/r/handler.result:
  new tests added
client/mysqltest.c:
  bug fixed: errors from handler.test (that is send_error()
  after send_fields) weren't catched by expected_errno
mysql-test/t/handler.test:
  typo fixed
sql/Makefile.am:
  bad merge fixed
sql/sql_yacc.yy:
  bad merge (?) fixed

Docs/manual.texi:
  Auto merged
support-files/mysql.spec.sh:
  SCCS merged

Docs/manual.texi:
  Moved things in example section.
  Added some links from user comments.

Docs/manual.texi:
  minor wording changes to sections 6.1 - 6.3.

Bug fix for Dec OSF on Alpha.

Minor bug fix for server RPM.
Tweak RPM support for mysqld-max.


configure.in:
  Try to identify FIND_PROC for Cygwin.  Thanks to Pete French
  <pfrench@firstcallgroup.co.uk> for the initial patch.
  
  Add -mieee to C(XX)FLAGS on Dec OSF for alpha, to fix bug w/ floating
  point arithmetic.  Thanks to nick@netability.ie for the heads up.
  
  Don't make mysql-test depend on --with-bench; always build it.  Thanks
  to smurf@play.smurf.noris.de for the patch.
include/global.h:
  Fix #defines if we are using __CYGWIN__.  Thanks to Pete French
  <pfrench@firstcallgroup.co.uk> for the initial patch.
support-files/mysql.spec.sh:
  Change %preun script so that it doesn't shut down mysqld after an
  upgrade.  Thanks to Andy Dustman for the patch.
  
  Add a %post Max script to restart mysqld after upgrading to mysqld-max.

BitKeeper/etc/logging_ok:
  auto-union
mysql-test/mysql-test-run.sh:
  SCCS merged

mysql-test/mysql-test-run.sh:
  use IFS=: instead of tr : " "
BitKeeper/etc/logging_ok:
  Logging to logging@openlogging.org accepted

Docs/manual.texi:
  Added information about mysqld-max
sql/gen_lex_hash.cc:
  Smaller table
support-files/mysql.spec.sh:
  Fix RPM

bdb/Makefile.in:
  Added clean and distclean to the makefile

BitKeeper/etc/logging_ok:
  auto-union
BitKeeper/triggers/post-commit:
  Auto merged
acinclude.m4:
  Auto merged
configure.in:
  Auto merged
mysql-test/mysql-test-run.sh:
  Auto merged
sql/sql_delete.cc:
  Auto merged

Portability fix for Innodb


BUILD/compile-pentium-max:
  Change mode to -rwxrwxr-x
BUILD/SETUP.sh:
  Changed -O6 to -O3
Docs/manual.texi:
  Changed -O6 to -O3
configure.in:
  Changed -O6 to -O3
  Added test of pthread_yield (For Innodb)
innobase/os/os0thread.c:
  Fix portability problem with RedHat 6.1
scripts/safe_mysqld.sh:
  Fix option --mysqld-version
sql/gen_lex_hash.cc:
  Smaller array
support-files/mysql.spec.sh:
  Changed -O6 to -O3

    added --bench option
sql-bench/Makefile.am
    added bench-count-distinct.sh test
sql-bench/bench-init.pl.sh
    added --socket option


mysql-test/mysql-test-run.sh:
  added --bench option
sql-bench/Makefile.am:
  added bench-count-distinct.sh test
sql-bench/bench-init.pl.sh:
  added --socket option
sql-bench/server-cfg.sh:
  --socket
BitKeeper/etc/ignore:
  Added sql-bench/bench-count-distinct to the ignore list

BitKeeper/etc/logging_ok:
  Logging to logging@openlogging.org accepted