Fixed bug in send in mysqltest

Removed usage of @r/result as this made life hard when testing different
table handlers.
Allow concurrent inserts if no update/binary log.
Don't remove key_cache at flush tables.
Fixed bug in SELECT DISTINCT SUM()...


BitKeeper/deleted/.del-rpl000012.status.result~bbbd650b5beea32f:
  Delete: mysql-test/r/rpl000012.status.result
BitKeeper/deleted/.del-rpl000013.status.result~6bee190c298cc9fd:
  Delete: mysql-test/r/rpl000013.status.result
Docs/manual.texi:
  Changelog
client/mysqltest.c:
  Fixed bug in 'send' that Sasha had introduced.
  Make database, port and socket optional parameters to connect()
mysql-test/r/rpl000005.result:
  Removed usage of @r/result as this made life hard when doing
  test for multiple table handlers.
mysql-test/r/rpl000006.result:
  Removed usage of @r/result as this made life hard when doing
  test for multiple table handlers.
mysql-test/r/rpl000012.result:
  Removed usage of @r/result as this made life hard when doing
  test for multiple table handlers.
mysql-test/r/rpl000013.result:
  Removed usage of @r/result as this made life hard when doing
  test for multiple table handlers.
mysql-test/r/sel000033.result:
  Removed usage of @r/result as this made life hard when doing
  test for multiple table handlers.
mysql-test/t/backup.test:
  Use default port and socket.
mysql-test/t/dirty-close.test:
  Use default port and socket.
mysql-test/t/flush.test:
  Use default port and socket.
mysql-test/t/kill.test:
  Use default port and socket.
mysql-test/t/overflow.test:
  Use default port and socket.
mysql-test/t/rpl000003.test:
  Removed usage of @r/result as this made life hard when doing
  test for multiple table handlers.
mysql-test/t/rpl000005.test:
  Removed usage of @r/result as this made life hard when doing
  test for multiple table handlers.
mysql-test/t/rpl000006.test:
  Removed usage of @r/result as this made life hard when doing
  test for multiple table handlers.
mysql-test/t/rpl000007.test:
  Removed usage of @r/result as this made life hard when doing
  test for multiple table handlers.
mysql-test/t/rpl000008.test:
  Removed usage of @r/result as this made life hard when doing
  test for multiple table handlers.
mysql-test/t/rpl000009.test:
  Removed usage of @r/result as this made life hard when doing
  test for multiple table handlers.
mysql-test/t/rpl000010.test:
  Removed usage of @r/result as this made life hard when doing
  test for multiple table handlers.
mysql-test/t/rpl000011.test:
  Removed usage of @r/result as this made life hard when doing
  test for multiple table handlers.
mysql-test/t/rpl000012.test:
  Removed usage of @r/result as this made life hard when doing
  test for multiple table handlers.
mysql-test/t/rpl000013.test:
  Removed usage of @r/result as this made life hard when doing
  test for multiple table handlers.
mysql-test/t/sel000001.test:
  Removed usage of @r/result as this made life hard when doing
  test for multiple table handlers.
mysql-test/t/sel000002.test:
  Removed usage of @r/result as this made life hard when doing
  test for multiple table handlers.
mysql-test/t/sel000003.test:
  Removed usage of @r/result as this made life hard when doing
  test for multiple table handlers.
mysql-test/t/sel000031.test:
  Removed usage of @r/result as this made life hard when doing
  test for multiple table handlers.
mysql-test/t/sel000032.test:
  Removed usage of @r/result as this made life hard when doing
  test for multiple table handlers.
mysql-test/t/sel000033.test:
  Removed usage of @r/result as this made life hard when doing
  test for multiple table handlers.
mysql-test/t/sel000100.test:
  Removed usage of @r/result as this made life hard when doing
  test for multiple table handlers.
mysql-test/t/shw000001.test:
  Removed usage of @r/result as this made life hard when doing
  test for multiple table handlers.
mysql-test/t/status.test:
  Use default port and socket.
sql/gen_lex_hash.cc:
  Smaller hash table
sql/mysql_priv.h:
  Allow concurrent inserts if no update/binary log
sql/mysqld.cc:
  Allow concurrent inserts if no update/binary log
  Don't remove key_cache at flush tables
sql/sql_base.cc:
  Don't remove key_cache at flush tables
sql/sql_select.cc:
  Fix bug in SELECT DISTINCT SUM().
sql/sql_yacc.yy:
  Allow concurrent inserts if no update/binary log
tests/export.pl:
  C

8 files changed, 15 insertions, 4 deletions

diff --git a/mysql-test/r/join_crash.result b/mysql-test/r/join_crash.result
new file mode 100644
index 00000000000..f7bef8af8ec
--- /dev/null
+++ b/mysql-test/r/join_crash.result
@@ -0,0 +1 @@
+project_id	project_name	client_ptr	comments	total_budget
diff --git a/mysql-test/r/rpl000005.result b/mysql-test/r/rpl000005.result
index 2be354af151..4f1541c75ca 100644
--- a/mysql-test/r/rpl000005.result
+++ b/mysql-test/r/rpl000005.result
@@ -2,3 +2,7 @@ name	age	id
 Andy	31	00000001
 Jacob	2	00000002
 Caleb	1	00000003
+name	age	id
+Andy	31	00000001
+Jacob	2	00000002
+Caleb	1	00000003
diff --git a/mysql-test/r/rpl000006.result b/mysql-test/r/rpl000006.result
index d2a036b9154..31a36f88f39 100644
--- a/mysql-test/r/rpl000006.result
+++ b/mysql-test/r/rpl000006.result
@@ -1,2 +1,4 @@
 unix_timestamp(t)
 200006
+unix_timestamp(t)
+200006
diff --git a/mysql-test/r/rpl000012.result b/mysql-test/r/rpl000012.result
index 414468f0998..ec2bd0684f1 100644
--- a/mysql-test/r/rpl000012.result
+++ b/mysql-test/r/rpl000012.result
@@ -5,3 +5,5 @@ n
 4
 5
 6
+Variable_name	Value
+Slave_open_temp_tables	0
diff --git a/mysql-test/r/rpl000012.status.result b/mysql-test/r/rpl000012.status.result
deleted file mode 100644
index c03e09c99bc..00000000000
--- a/mysql-test/r/rpl000012.status.result
+++ /dev/null
@@ -1,2 +0,0 @@
-Variable_name	Value
-Slave_open_temp_tables	0
diff --git a/mysql-test/r/rpl000013.result b/mysql-test/r/rpl000013.result
index 414468f0998..ec2bd0684f1 100644
--- a/mysql-test/r/rpl000013.result
+++ b/mysql-test/r/rpl000013.result
@@ -5,3 +5,5 @@ n
 4
 5
 6
+Variable_name	Value
+Slave_open_temp_tables	0
diff --git a/mysql-test/r/rpl000013.status.result b/mysql-test/r/rpl000013.status.result
deleted file mode 100644
index c03e09c99bc..00000000000
--- a/mysql-test/r/rpl000013.status.result
+++ /dev/null
@@ -1,2 +0,0 @@
-Variable_name	Value
-Slave_open_temp_tables	0
diff --git a/mysql-test/r/sel000033.result b/mysql-test/r/sel000033.result
index 1a1325d4360..689c94082e7 100644
--- a/mysql-test/r/sel000033.result
+++ b/mysql-test/r/sel000033.result
@@ -2,3 +2,7 @@ id
 2
 5
 9
+id
+2
+5
+9