CREATE TABLE a SELECT strfunc(non_default_charset_expr)

Fixed that MyISAM were not working properly with non-8bit charsets in some cases
CONVERT() function now works properly


myisam/mi_unique.c:
  Fix for non-8bit charsets
sql/field.cc:
  Initialize blobs with charset
sql/field.h:
  Initialize blobs with charset
sql/field_conv.cc:
  Initialize blobs with charset
sql/item_strfunc.cc:
  CONVERT() function now has working fix_lenght_and_dec(), and it's own 
  fix_fields()
sql/item_strfunc.h:
  CONVERT() function now has working fix_lenght_and_dec(), and it's own 
  fix_fields()
sql/sql_select.cc:
  Fixes for BLOBs
  Fixed that wrong charset was used in some cases

CREATE DATABASE dbname DEFAULT CHARACTERSET=latin1


sql/sql_class.cc:
  Database default charset
sql/sql_class.h:
  Database default charset
sql/sql_db.cc:
  Database default charset
sql/sql_table.cc:
  Database default charset
BitKeeper/etc/ignore:
  Added tests/client_test to the ignore list

now works more correctly. Still needs fixes.

Remove dupicated code


sql/sql_lex.cc:
  new UNDERSCORE_CHARSET language item

into gw.udmsearch.izhnet.ru:/usr/home/bar/mysql-4.1


sql/sql_yacc.yy:
  Auto merged

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


sql/sql_yacc.yy:
  Auto merged

ALTER TABLE a CHARSET=DEFAULT

CREATE TABLE a (field,...) TYPE=type CHARSET=cset;


sql/handler.h:
  New flag to remember whether new table default charset 
  has been passed in ALTER TABLE
sql/lex.h:
  New language symbol
sql/sql_show.cc:
  Display default table charset if exists
sql/sql_table.cc:
  Check table charset before default server charset
sql/sql_yacc.yy:
  New create table option: default table character set
sql/table.cc:
  Table charset
sql/unireg.cc:
  field->charset must be initialized before. So assumes it is not NULL

sql/sql_class.cc:
  Auto merged
sql/sql_class.h:
  Auto merged

more correct parameters in result creation script


mysql-test/create-test-result:
  more correct parameters in result creation script
mysql-test/r/subselect.result:
  test of EXISTS
mysql-test/t/subselect.test:
  test of EXISTS
sql/item_subselect.cc:
  EXISTS type of subselect
sql/item_subselect.h:
  EXISTS type of subselect
sql/sql_class.cc:
  EXISTS type of subselect
sql/sql_class.h:
  EXISTS type of subselect
sql/sql_yacc.yy:
  EXISTS type of subselect

Failed to compile at least on freebsd.

  corrected the symlink


libmysqld/sql_prepare.cc:
  corrected the symlink

  Added missing sql_prepare.cc & sql_error.cc to libmysqld
sql_error.cc, sql_prepare.cc:
  new file


libmysqld/Makefile.am:
  Added missing sql_prepare.cc & sql_error.cc to libmysqld

  Forgot to include the portable changes from previous commit


tests/client_test.c:
  Forgot to include the portable changes from previous commit

  new file

'C' Test case for all prototype changes - Assert based which covers all most all scenarios

  One more missed fix from Windows


sql/sql_list.h:
  One more missed fix from Windows

  Missed change from previous resolve


sql/mysql_priv.h:
  Missed change from previous resolve

  new file

  Client-server protocol 4.1 changes - Server side:

 * Enhanced metadata information:
    - SHOW [COUNT(*)] ERRORS [LIMIT [offset,] rows]
    - SHOW [COUNT(*)] WARNING [LIMIT [offset,] rows]
    - SHOW TABLE TYPES
    - SHOW PRIVILEGES
    - SHOW COLUMN TYPES (Not fully implemented)

 * Prepared execution
 * Long data handling in pieces
 * And other misc changes

  - Support of prepared execution
  - Support of Original Table and Column names
  - Support of direct transactional API
  - And lot of misc handling

  (Note that, the pull will not work, unless you have the Server side changes also which will be followed by this commit)
  


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

  fix: use my_free() instead of free()


mysys/test_charset.c:
  fix: use my_free() instead of free()

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

BitKeeper/deleted/.del-sql_select.cc.rej~b567fd439ef37cc8:
  Delete: sql/sql_select.cc.rej

  Fix for typos in system_charset_info


strings/strto.c:
  Fix for typos in system_charset_info

  Rename: BitKeeper/deleted/.del-makefile.w32 -> BitKeeper/deleted/.del-makefile2.w32


BitKeeper/deleted/.del-makefile2.w32:
  Rename: BitKeeper/deleted/.del-makefile.w32 -> BitKeeper/deleted/.del-makefile2.w32

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


sql/mysql_priv.h:
  Auto merged
sql/sql_parse.cc:
  Auto merged
sql/sql_yacc.yy:
  Auto merged

into gw.udmsearch.izhnet.ru:/usr/home/ram/mysql-4.1

mysql-test/r/alter_table.result:
  Fix test result according to new SHOW CREATE TABLE and SHOW FIELDS
mysql-test/r/create.result:
  Fix test result according to new SHOW CREATE TABLE and SHOW FIELDS
mysql-test/r/fulltext.result:
  Fix test result according to new SHOW CREATE TABLE and SHOW FIELDS
mysql-test/r/innodb.result:
  Fix test result according to new SHOW CREATE TABLE and SHOW FIELDS
mysql-test/r/merge.result:
  Fix test result according to new SHOW CREATE TABLE and SHOW FIELDS
mysql-test/r/select.result:
  Fix test result according to new SHOW CREATE TABLE and SHOW FIELDS
mysql-test/r/show_check.result:
  Fix test result according to new SHOW CREATE TABLE and SHOW FIELDS
mysql-test/r/symlink.result:
  Fix test result according to new SHOW CREATE TABLE and SHOW FIELDS
mysql-test/r/type_blob.result:
  Fix test result according to new SHOW CREATE TABLE and SHOW FIELDS
mysql-test/r/type_ranges.result:
  Fix test result according to new SHOW CREATE TABLE and SHOW FIELDS
sql/field.cc:
  New format for string fields in SHOW CREATE TABLE and SHOW FIELDS
sql/mysql_priv.h:
  pass charset
sql/sql_parse.cc:
  QQ is now fixed :)
sql/sql_yacc.yy:
  New format for string fields in SHOW CREATE TABLE and SHOW FIELDS