Add support for LIMIT # OFFSET #
Changed lock handling:  Now all locks should be stored in TABLE_LIST instead of passed to functions.
Don't call query_cache_invalidate() twice in some cases
mysql_change_user() now clears states to be equal to close + connect.
Fixed a bug with multi-table-update and multi-table-delete when used with LOCK TABLES
Fixed a bug with replicate-do and UPDATE

Fix for another optimize bug is undone, as the new one handles both cases.
test added

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

  Backport from 4.0 a bug fix: if unique search from a primary key matched a delete-marked record, InnoDB could return the NEXT record

  Fix bug: if a unique search from a primary key matched to a delete-marked row, it could return the NEXT row

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

  Fix wrong sprintf argument
row0sel.c:
  Fix uninitialized variable error found by Miguel

Quote all table names with backticks.  

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

 - fixed typo: mi_rowkorr(T,A) -> mi_rowkorr(T)

 - fixed Typo: BIG_TABLE -> BIG_TABLES

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

unlink socket file if mysqld dies on startup
Some optimization of AND expressions

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

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

This is coded to not cause a speed impact on top level AND expressions where we don't care if an AND expression returns 0 or NULL

   "head/tail -n <num>" instead

 - fixed yet another wrong result after error messages had been changed

 - fixed test results after error messages had been modified

into geopard.(none):/storage/bk/mysql-3.23

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