Fix crash when InnoDB temp table is truncated + fix bug: do not X-lock rows under LOCK TABLES except if the table is temp

into genie.(none):/home/vva/work/mysqldump_xml/4.0

into geopard.(none):/storage/bk/my-new-4.0

Redo of changeset I commited, but failed to push

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

 - bumped up version number in configure.in
 - fixed a typo in test-create.sh

into sanja.is.com.ua:/home/bell/mysql/mysql-4.0

 - "make distcheck" needs to be fixed

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

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

  Print an error message if someone tries to call InnoDB startip more than once during process lifetime

  Remove unintentionally pushed printf

  Fix another bug introduced in 4.0.4 in AUTO_INCREMENT and deadlock or lock wait timeout

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

  Fix bug intoduced in 4.0.4 in REPLACE and AUTO_INCREMENT: if replace did an update, then auto-inc counter was left 1 too low

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

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