fixed mustiupdate subselect compatibility

(bug 217)



mysql-test/r/subselect.result:
  test of multi-update & subselect
mysql-test/t/subselect.test:
  test of multi-update & subselect
sql/sql_update.cc:
  added subselect compatibility to query cache
sql/sql_yacc.yy:
  right st_select_lex initialization 
  layout fix

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

into sanja.is.com.ua:/home/bell/mysql/bk/work-qcvar-4.1


mysql-test/r/query_cache.result:
  Auto merged
mysql-test/t/query_cache.test:
  Auto merged
sql/mysql_priv.h:
  Auto merged
sql/mysqld.cc:
  Auto merged
sql/set_var.cc:
  Auto merged
sql/sql_cache.cc:
  Auto merged

  Fix for possible failure reason on big-endian machines
  ,


sql/sql_yacc.yy:
  Fix for possible failure reason on big-endian machines
  ,

sql/item_strfunc.cc:
  uint is better here

into deer.mysql.r18.ru:/home/hf/work/mysql-4.1.rpc


sql/item_strfunc.cc:
  Auto merged

into deer.mysql.r18.ru:/home/hf/work/mysql-4.1.rpc

into mashka.mysql.fi:/home/my/mysql-4.1


BitKeeper/etc/gone:
  auto-union
BitKeeper/etc/logging_ok:
  auto-union
sql/sql_parse.cc:
  Auto merged
sql/sql_yacc.yy:
  Auto merged

mysql-test/r/query_cache.result:
  Updated test for 4.1
mysql-test/t/query_cache.test:
  Updated test for 4.1
sql/sql_parse.cc:
  After merge fix
sql/sql_yacc.yy:
  After merge fix

  GeometryCollectionFromText is now alias for GeomCollFromText


sql/lex.h:
  GeometryCollectionFromText is now alias for GeomCollFromText

Point, MultiLine, Poligom, etc, are now not aliases
for Geometry, but separate field types.

(Truncating of Replace result)


sql/item_strfunc.cc:
  max_length for Replace function was counted in wrong way

BitKeeper/etc/gone:
  auto-union
BitKeeper/etc/logging_ok:
  auto-union
myisam/sort.c:
  Auto merged
mysql-test/r/group_by.result:
  Auto merged
mysql-test/r/join_outer.result:
  Auto merged
mysql-test/r/order_by.result:
  Auto merged
mysql-test/r/query_cache.result:
  Auto merged
mysql-test/r/type_blob.result:
  Auto merged
mysql-test/r/type_ranges.result:
  Auto merged
mysql-test/r/update.result:
  Auto merged
mysql-test/t/bdb-crash.test:
  Auto merged
mysql-test/t/group_by.test:
  Auto merged
mysql-test/t/join_outer.test:
  Auto merged
mysql-test/t/order_by.test:
  Auto merged
mysql-test/t/query_cache.test:
  Auto merged
mysql-test/t/type_blob.test:
  Auto merged
mysql-test/t/type_decimal.test:
  Auto merged
mysql-test/t/type_ranges.test:
  Auto merged
mysql-test/t/update.test:
  Auto merged
sql-bench/crash-me.sh:
  Auto merged
client/mysql.cc:
  Keep old code

sql-bench/limits/mysql.cfg:
  Update to new crash me

  Comments why "greek" is ISO greek


sql/share/charsets/greek.xml:
  Comments why "greek" is ISO greek

Some collation names have been renamed


BitKeeper/deleted/.del-ctype-latin1_de.c~c5d8f9208bceb98e:
  Delete: strings/ctype-latin1_de.c
libmysql/Makefile.shared:
  German Phone book collation is always compiled
mysql-test/r/ctype_collate.result:
  Some collation names have been renamed
mysql-test/t/ctype_collate.test:
  Some collation names have been renamed
mysql-test/t/ctype_latin1_de-master.opt:
  Some collation names have been renamed
mysys/charset.c:
  get_charset_by_name() now will find its default collation if charset name is passed
sql/share/charsets/Index.xml:
  Some collation names have been renamed
sql/share/charsets/cp1251.xml:
  Some collation names have been renamed
sql/share/charsets/cp1257.xml:
  Some collation names have been renamed
sql/share/charsets/latin1.xml:
  Some collation names have been renamed
sql/share/charsets/latin2.xml:
  Some collation names have been renamed
sql/share/charsets/latin7.xml:
  Some collation names have been renamed
sql/share/charsets/macce.xml:
  Some collation names have been renamed
sql/share/charsets/macroman.xml:
  Some collation names have been renamed
sql/sql_show.cc:
  Nicer output from SHOW COLLATION
strings/Makefile.am:
  German Phone book collation is always compiled
strings/ctype-czech.c:
  Some collation names have been renamed
strings/ctype-extra.c:
  Don't compile dynamic charset. We should decide names convension before 
  making this available.
strings/ctype-latin1.c:
  German Phone book collation is always compiled

   (there is a Makefile in readline_topdir that already lists
   readline_dir in SUBDIRS)

into mysql.com:/suse80/my/mysql-4.1

sql/sql_error.cc:
   - fixed comment so mysql_copyright does not eat the whole file
sql/sql_prepare.cc:
   - fixed comment so mysql_copyright does not eat the whole file

Low case letters are used in charset names


BitKeeper/deleted/.del-MacRoman.xml~f890bce37d31d382:
  Delete: sql/share/charsets/MacRoman.xml
BitKeeper/deleted/.del-MacCE.xml~fca413f3126f6189:
  Delete: sql/share/charsets/MacCE.xml
mysys/charset.c:
  SHOW CHARACTER SET now can display comments
sql/share/charsets/Index.xml:
  SHOW CHARACTER SET now can display comments
sql/sql_show.cc:
  SHOW CHARACTER SET now can display comments
strings/ctype.c:
  SHOW CHARACTER SET now can display comments

into mysql.com:/suse80/my/mysql-4.1

into narttu.mysql.fi:/my/mysql-4.0


mysql-test/r/group_by.result:
  Auto merged
mysql-test/t/group_by.test:
  Auto merged

mysql-test/r/group_by.result:
  Test for group by + alias bug
mysql-test/t/group_by.test:
  Test for group by + alias bug

  NATIONAL CHARACTER() has latin1 charset now.
  Reasons are (by Monty):
  I think we should keepy having latin1 (default configure option)
  as the national character set.  The reason for this is simple that:

- This is ok for a large part of the world.
- It's faster and takes less space than utf8.


sql/sql_string.cc:
  NATIONAL CHARACTER() has latin1 charset now.
  Reasons are (by Monty):
  I think we should keepy having latin1 (default configure option)
  as the national character set.  The reason for this is simple that:

  LIKE was used against wrong name


sql/sql_show.cc:
  LIKE was used against wrong name

into mysql.com:/suse80/my/mysql-4.1

into narttu.mysql.fi:/my/mysql-4.1

Fixed bug in allocation memory in key cache. (Memory was not properly aligned which cased core dumps on sparc CPU's)
Changed keycache variables to start with my_ instead of _my_


include/my_sys.h:
  Changed keycache variables to start with my_ instead of _my_
myisam/mi_test2.c:
  Changed keycache variables to start with my_ instead of _my_
  Removed compiler warnings
myisam/sp_test.c:
  Removed compiler warning
mysys/mf_keycache.c:
  Fixed bug in allocation memory (Memory was not properly aligned which cased core dumps on sparc CPU's)
  Changed keycache variables to start with my_ instead of _my_
  Fixed indentation and comment syntax.
  Removed end space.
sql/mysqld.cc:
  Changed keycache variables to start with my_ instead of _my_
sql/sql_test.cc:
  Changed keycache variables to start with my_ instead of _my_

into mysql.com:/suse80/my/mysql-4.1

  Fixed that concat() didn't set character set in val_str
  concat_ws() now honors coercibility


sql/item_strfunc.cc:
  Fixed that concat() didn't set character set in val_str
  concat_ws() now honors coercibility

  The result didn't return proper collation


sql/item_strfunc.cc:
  The result didn't return proper collation

  A bug has been fixed. ELT() didn't honor the second argument.
  Coercibility support has been added.


sql/item_strfunc.cc:
  A bug has been fixed. ELT() didn't honor the second argument.
  Coercibility support has been added.

   (Thanks to Marc Liyanage for spotting this)

into mysql.com:/suse80/my/mysql-4.1


BitKeeper/etc/logging_ok:
  auto-union