Bug fix for NATURAL JOIN, Split manual sections and more statistic variables

Docs/manual.texi:
  Split BDB into different sections
  Added MySQL developers section
  Changed an SQL to a SQL
include/my_sys.h:
  More statistic variables
libmysql/libmysql.c:
  Added option "interactive-timeout"
mysys/mf_tempfile.c:
  More statistic variables
mysys/my_static.c:
  More statistic variables
sql-bench/crash-me.sh:
  Fixed bug in truncate table test
sql-bench/limits/mysql-3.23.cfg:
  Updated to crash-me 1.51
sql-bench/limits/mysql.cfg:
  Updated to crash-me 1.51
sql/filesort.cc:
  More statistics
sql/mysql_priv.h:
  More statistics
sql/mysqld.cc:
  More statistics
sql/sql_base.cc:
  Fix for NATURAL JOIN
sql/sql_delete.cc:
  cleanup + Added logging if one doesn't use index
sql/sql_parse.cc:
  Logging if one doesn't use index
sql/sql_select.cc:
  Logging if one doesn't use index
sql/sql_update.cc:
  cleanup + Added logging if one doesn't use index
sql/structs.h:
  Fix for NATURAL JOIN
support-files/my-huge.cnf.sh:
  Added interactive-timeout to [mysqlhotcopy]
support-files/my-large.cnf.sh:
  Added interactive-timeout to [mysqlhotcopy]
support-files/my-medium.cnf.sh:
  Added interactive-timeout to [mysqlhotcopy]
support-files/my-small.cnf.sh:
  Added interactive-timeout to [mysqlhotcopy]

3 files changed, 23 insertions, 19 deletions

diff --git a/sql-bench/crash-me.sh b/sql-bench/crash-me.sh
index 45bcd2d4a1c..394f64b85ab 100755
--- a/sql-bench/crash-me.sh
+++ b/sql-bench/crash-me.sh
@@ -292,7 +292,7 @@ $dbh->do("drop table crash_q");
 report("truncate","truncate_table",
        "create table crash_q (a integer, b integer,c CHAR(10))",
        "truncate crash_q",
-       "drop table crash_q1");
+       "drop table crash_q");
 
 if ($dbh->do("create table crash_q (a integer, b integer,c CHAR(10))") &&
     $dbh->do("create table crash_q1 (a integer, b integer,c CHAR(10) not null)"))
diff --git a/sql-bench/limits/mysql-3.23.cfg b/sql-bench/limits/mysql-3.23.cfg
index 186d1e740eb..759208ad713 100644
--- a/sql-bench/limits/mysql-3.23.cfg
+++ b/sql-bench/limits/mysql-3.23.cfg
@@ -1,4 +1,4 @@
-#This file is automaticly generated by crash-me 1.50
+#This file is automaticly generated by crash-me 1.51
 
 NEG=yes					# update of column= -column
 Need_cast_for_null=no			# Need to cast NULL for arithmetic
@@ -31,12 +31,12 @@ comment_--=yes				# -- as comment (ANSI)
 comment_/**/=yes			# /* */ as comment
 comment_//=no				# // as comment (ANSI)
 compute=no				# Compute
-connections=30				# Simultaneous connections (installation default)
+connections=101				# Simultaneous connections (installation default)
 constraint_check=no			# Column constraints
 constraint_check_table=no		# Table constraints
 constraint_null=yes			# NULL constraint (SyBase style)
 crash_me_safe=yes			# crash me safe
-crash_me_version=1.50			# crash me version
+crash_me_version=1.51			# crash me version
 create_default=yes			# default value for column
 create_default_func=no			# default value function for column
 create_if_not_exists=yes		# create table if not exists
@@ -315,7 +315,7 @@ intersect=no				# intersect
 intersect_all=no			# intersect all
 intersect_all_incompat=no		# intersect all (incompatible lists)
 intersect_incompat=no			# intersect (incompatible lists)
-join_tables=31				# tables in join
+join_tables=63				# tables in join
 left_outer_join=yes			# left outer join
 left_outer_join_using=yes		# left outer join using
 like_with_column=yes			# column LIKE column
@@ -327,7 +327,7 @@ max_char_size=255			# max char() size
 max_column_name=64			# column name length
 max_columns=3398			# Columns in table
 max_conditions=85660			# OR and AND in WHERE
-max_expressions=859			# simple expressions
+max_expressions=1837			# simple expressions
 max_index=32				# max index
 max_index_length=500			# index length
 max_index_name=64			# index name length
@@ -337,7 +337,7 @@ max_index_varchar_part_length=255	# index varchar part length
 max_row_length=65534			# max table row length (without blobs)
 max_row_length_with_null=65502		# table row length with nulls (without blobs)
 max_select_alias_name=+512		# select alias name length
-max_stack_expression=859		# stacked expressions
+max_stack_expression=1837		# stacked expressions
 max_table_alias_name=+512		# table alias name length
 max_table_name=64			# table name length
 max_text_size=1048543			# max text or blob size
@@ -361,7 +361,7 @@ null_in_index=yes			# null in index
 null_in_unique=yes			# null in unique index
 null_num_expr=yes			# Is 1+NULL = NULL
 odbc_left_outer_join=yes		# left outer join odbc style
-operating_system=Linux 2.2.14-my-SMP i686	# crash-me tested on
+operating_system=Linux 2.2.13-SMP alpha	# crash-me tested on
 order_by=yes				# Order by
 order_by_alias=yes			# Order by alias
 order_by_function=yes			# Order by function
@@ -380,7 +380,7 @@ quote_with_"=yes			# Allows ' and " as string markers
 remember_end_space=no			# Remembers end space in char()
 remember_end_space_varchar=no		# Remembers end space in varchar()
 rename_table=yes			# rename table
-repeat_string_size=1048576		# return string size from function
+repeat_string_size=1047552		# return string size from function
 right_outer_join=yes			# right outer join
 rowid=auto_increment			# Type for row id
 select_constants=yes			# Select constants
@@ -389,7 +389,7 @@ select_limit2=yes			# SELECT with LIMIT #,#
 select_string_size=1048565		# constant string size in SELECT
 select_table_update=no			# Update with sub select
 select_without_from=yes			# SELECT without FROM
-server_version=MySQL 3.23.25 beta debug	# server version
+server_version=MySQL 3.23.28 gamma	# server version
 simple_joins=yes			# ANSI SQL simple joins
 storage_of_float=round			# Storage of float values
 subqueries=no				# subqueries
@@ -398,6 +398,7 @@ table_name_case=no			# case independent table names
 table_wildcard=yes			# Select table_name.*
 tempoary_table=yes			# temporary tables
 transactions=no				# transactions
+truncate_table=yes			# truncate
 type_extra_abstime=no			# Type abstime
 type_extra_bfile=no			# Type bfile
 type_extra_blob=yes			# Type blob
@@ -512,5 +513,6 @@ union_all_incompat=no			# union all (incompatible lists)
 union_incompat=no			# union (incompatible lists)
 unique_in_create=yes			# unique in create table
 unique_null_in_create=yes		# unique null in create
+user_comment=Alpha DS20 2x500 MHz, 2G memory, key_buffer=16M; ccc + cxx	# comment
 views=no				# views
 where_string_size=1048540		# constant string size in where
diff --git a/sql-bench/limits/mysql.cfg b/sql-bench/limits/mysql.cfg
index 186d1e740eb..759208ad713 100644
--- a/sql-bench/limits/mysql.cfg
+++ b/sql-bench/limits/mysql.cfg
@@ -1,4 +1,4 @@
-#This file is automaticly generated by crash-me 1.50
+#This file is automaticly generated by crash-me 1.51
 
 NEG=yes					# update of column= -column
 Need_cast_for_null=no			# Need to cast NULL for arithmetic
@@ -31,12 +31,12 @@ comment_--=yes				# -- as comment (ANSI)
 comment_/**/=yes			# /* */ as comment
 comment_//=no				# // as comment (ANSI)
 compute=no				# Compute
-connections=30				# Simultaneous connections (installation default)
+connections=101				# Simultaneous connections (installation default)
 constraint_check=no			# Column constraints
 constraint_check_table=no		# Table constraints
 constraint_null=yes			# NULL constraint (SyBase style)
 crash_me_safe=yes			# crash me safe
-crash_me_version=1.50			# crash me version
+crash_me_version=1.51			# crash me version
 create_default=yes			# default value for column
 create_default_func=no			# default value function for column
 create_if_not_exists=yes		# create table if not exists
@@ -315,7 +315,7 @@ intersect=no				# intersect
 intersect_all=no			# intersect all
 intersect_all_incompat=no		# intersect all (incompatible lists)
 intersect_incompat=no			# intersect (incompatible lists)
-join_tables=31				# tables in join
+join_tables=63				# tables in join
 left_outer_join=yes			# left outer join
 left_outer_join_using=yes		# left outer join using
 like_with_column=yes			# column LIKE column
@@ -327,7 +327,7 @@ max_char_size=255			# max char() size
 max_column_name=64			# column name length
 max_columns=3398			# Columns in table
 max_conditions=85660			# OR and AND in WHERE
-max_expressions=859			# simple expressions
+max_expressions=1837			# simple expressions
 max_index=32				# max index
 max_index_length=500			# index length
 max_index_name=64			# index name length
@@ -337,7 +337,7 @@ max_index_varchar_part_length=255	# index varchar part length
 max_row_length=65534			# max table row length (without blobs)
 max_row_length_with_null=65502		# table row length with nulls (without blobs)
 max_select_alias_name=+512		# select alias name length
-max_stack_expression=859		# stacked expressions
+max_stack_expression=1837		# stacked expressions
 max_table_alias_name=+512		# table alias name length
 max_table_name=64			# table name length
 max_text_size=1048543			# max text or blob size
@@ -361,7 +361,7 @@ null_in_index=yes			# null in index
 null_in_unique=yes			# null in unique index
 null_num_expr=yes			# Is 1+NULL = NULL
 odbc_left_outer_join=yes		# left outer join odbc style
-operating_system=Linux 2.2.14-my-SMP i686	# crash-me tested on
+operating_system=Linux 2.2.13-SMP alpha	# crash-me tested on
 order_by=yes				# Order by
 order_by_alias=yes			# Order by alias
 order_by_function=yes			# Order by function
@@ -380,7 +380,7 @@ quote_with_"=yes			# Allows ' and " as string markers
 remember_end_space=no			# Remembers end space in char()
 remember_end_space_varchar=no		# Remembers end space in varchar()
 rename_table=yes			# rename table
-repeat_string_size=1048576		# return string size from function
+repeat_string_size=1047552		# return string size from function
 right_outer_join=yes			# right outer join
 rowid=auto_increment			# Type for row id
 select_constants=yes			# Select constants
@@ -389,7 +389,7 @@ select_limit2=yes			# SELECT with LIMIT #,#
 select_string_size=1048565		# constant string size in SELECT
 select_table_update=no			# Update with sub select
 select_without_from=yes			# SELECT without FROM
-server_version=MySQL 3.23.25 beta debug	# server version
+server_version=MySQL 3.23.28 gamma	# server version
 simple_joins=yes			# ANSI SQL simple joins
 storage_of_float=round			# Storage of float values
 subqueries=no				# subqueries
@@ -398,6 +398,7 @@ table_name_case=no			# case independent table names
 table_wildcard=yes			# Select table_name.*
 tempoary_table=yes			# temporary tables
 transactions=no				# transactions
+truncate_table=yes			# truncate
 type_extra_abstime=no			# Type abstime
 type_extra_bfile=no			# Type bfile
 type_extra_blob=yes			# Type blob
@@ -512,5 +513,6 @@ union_all_incompat=no			# union all (incompatible lists)
 union_incompat=no			# union (incompatible lists)
 unique_in_create=yes			# unique in create table
 unique_null_in_create=yes		# unique null in create
+user_comment=Alpha DS20 2x500 MHz, 2G memory, key_buffer=16M; ccc + cxx	# comment
 views=no				# views
 where_string_size=1048540		# constant string size in where