Fix of LEFT JOIN optimizer bug, problem with key cache on Windows and

a lot of portability issues.


Docs/manual.texi:
  Changed FOREIGN KEY to FOREIGN KEY constraint
client/mysqladmin.c:
  Don't flush MASTER or SLAVE on refresh
configure.in:
  Fix for hpux 11.0
extra/perror.c:
  New error message
include/my_pthread.h:
  Portability fix for windows
myisam/mi_locking.c:
  Ensure that locking doesn't interfere with pread/pwrite on windows
myisam/sort.c:
  checked with purecover
mysys/mf_tempfile.c:
  Fix for windows
mysys/my_lock.c:
  Ensure that locking doesn't interfere with pread/pwrite on windows
mysys/my_winthread.c:
  Portability fix
sql-bench/Results/ATIS-mysql-NT_4.0:
  New benchmark runs
sql-bench/Results/RUN-mysql-NT_4.0:
  New benchmark runs
sql-bench/Results/alter-table-mysql-NT_4.0:
  New benchmark runs
sql-bench/Results/big-tables-mysql-NT_4.0:
  New benchmark runs
sql-bench/Results/connect-mysql-NT_4.0:
  New benchmark runs
sql-bench/Results/create-mysql-NT_4.0:
  New benchmark runs
sql-bench/Results/insert-mysql-NT_4.0:
  New benchmark runs
sql-bench/Results/select-mysql-NT_4.0:
  New benchmark runs
sql-bench/Results/wisconsin-mysql-NT_4.0:
  New benchmark runs
sql-bench/crash-me.sh:
  Fixed things for PostgreSQL
sql-bench/limits/mysql-3.23.cfg:
  Update for new crash-me
sql-bench/limits/mysql.cfg:
  Update for new crash-me
sql-bench/print-limit-table:
  Fixed position for alter table rename
sql-bench/test-insert.sh:
  Fix for PostgreSQL
sql/field.cc:
  Fix for default values in CREATE ... SELECT
sql/field.h:
  Fix for default values in CREATE ... SELECT
sql/log.cc:
  Fixed typo
sql/log_event.cc:
  Portability fix
sql/mysqlbinlog.cc:
  Portability fix
sql/mysqld.cc:
  Don't turn of concurrent insert with --skip-new or --safe
sql/sql_base.cc:
  Portability fix
sql/sql_class.cc:
  Portability fix
sql/sql_class.h:
  Portability fix
sql/sql_parse.cc:
  Fix for --log-slow-queries
sql/sql_repl.cc:
  Portability fixes
sql/sql_select.cc:
  Fixed optimizer bug for LEFT JOIN
sql/sql_select.h:
  Fixed optimizer bug for LEFT JOIN
sql/sql_table.cc:
  Fix for default values in CREATE ... SELECT
sql/sql_yacc.yy:
  Added optional AS to: CREATE TABLE foo [ AS ] SELECT ...

1 files changed, 16 insertions, 10 deletions

diff --git a/sql-bench/crash-me.sh b/sql-bench/crash-me.sh
index 6357ffc17b1..6bb3eab63f9 100755
--- a/sql-bench/crash-me.sh
+++ b/sql-bench/crash-me.sh
@@ -39,7 +39,7 @@
 # "3-byte int" or "same as xxx".
 
 
-$version="1.49";
+$version="1.50";
 
 use DBI;
 use Getopt::Long;
@@ -271,8 +271,9 @@ if ($dbh->do("create table crash_q (a integer, b integer,c CHAR(10))"))
   report("Alter table alter column default",'alter_alter_col',
 	 "alter table crash_q alter b set default 10",
 	 "alter table crash_q alter b set default NULL");
-  report("Alter table drop column",'alter_drop_col',
-	 "alter table crash_q drop column b");
+  report_one("Alter table drop column",'alter_drop_col',
+	     [["alter table crash_q drop column b","yes"],
+	      ["alter table crash_q drop column b restrict","with restrict/cascade"]]);
   report("Alter table rename table",'alter_rename_table',
 	 "alter table crash_q rename to crash_q1");
 }
@@ -757,7 +758,7 @@ try_and_report("Automatic rowid", "automatic_rowid",
    ["COS","cos","cos(0)","1.00000",0],
    ["COT","cot","cot(1)","0.64209262",0],
    ["DEGREES","degrees","degrees(6.283185)","360",0],
-   ["EXP","exp","exp(1)","2.718282",0],
+   ["EXP","exp","exp(1.0)","2.718282",0],
    ["FLOOR","floor","floor(2.5)","2",0],
    ["LOG","log","log(2)","0.693147",0],
    ["LOG10","log10","log10(10)","1",0],
@@ -1047,7 +1048,11 @@ if ($limits{'functions'} eq 'yes')
   print "\n";
   report("mixing of integer and float in expression","float_int_expr",
 	 "select 1+1.0 $end_query");
-
+  if ($limits{'func_odbc_exp'} eq 'yes')
+  {
+    report("No need to cast from integer to float",
+	   "dont_require_cast_to_float", "select exp(1) $end_query");
+  }
   check_and_report("Is 1+NULL = NULL","null_num_expr",
 		   [],"select 1+$numeric_null $end_query",[],undef(),4);
   $tmp=sql_concat("'a'",$char_null);
@@ -1269,9 +1274,10 @@ report("temporary tables",'tempoary_table',
        "create temporary table crash_q (q integer not null)",
        "drop table crash_q");
 
-report("create table from select",'create_table_select',
-       "create table crash_q SELECT * from crash_me",
-       "drop table crash_q");
+report_one("create table from select",'create_table_select',
+	   [["create table crash_q SELECT * from crash_me","yes"],
+	    ["create table crash_q AS SELECT * from crash_me","with AS"]]);
+$dbh->do("drop table crash_q");
 
 report("index in create table",'index_in_create',
        "create table crash_q (q integer not null,index (q))",
@@ -1628,9 +1634,9 @@ if (!report("many tables to drop table","multi_drop",
 }
 
 
-report("-- as comment","comment_--",
+report("-- as comment (ANSI)","comment_--",
        "select * from crash_me -- Testing of comments");
-report("// as comment","comment_//",
+report("// as comment (ANSI)","comment_//",
        "select * from crash_me // Testing of comments");
 report("# as comment","comment_#",
        "select * from crash_me # Testing of comments");