bzr commit into mysql-5.1 branch (Sergey.Glukhov:2706) Bug#36035

[Sergey Glukhov]

#At file:///home/gluh/MySQL/mysql-5.1-bugteam/

 2706 Sergey Glukhov	2008-11-13
      Bug#36035 I_S.TABLES.UPDATE_TIME not being set on INSERT for Windows
      added FLUSH TABLES after INSERT because UPDATE_TIME is updated with delay
      on Win.
modified:
  mysql-test/suite/funcs_1/datadict/is_tables.inc
  mysql-test/suite/funcs_1/r/is_tables.result

per-file messages:
  mysql-test/suite/funcs_1/datadict/is_tables.inc
    test fix
  mysql-test/suite/funcs_1/r/is_tables.result
    result fix
=== modified file 'mysql-test/suite/funcs_1/datadict/is_tables.inc'
--- a/mysql-test/suite/funcs_1/datadict/is_tables.inc	2008-06-16 18:39:58 +0000
+++ b/mysql-test/suite/funcs_1/datadict/is_tables.inc	2008-11-13 08:38:30 +0000
@@ -346,6 +346,7 @@ WHERE table_name = 't1_my_tablex';
 #   Enforce a time difference bigger than the smallest unit (1 second).
 --real_sleep 1.1
 INSERT INTO db_datadict.t1_my_tablex SET f1 = 3;
+FLUSH TABLES;
 SELECT UPDATE_TIME > @UPDATE_TIME
     AS "Is current UPDATE_TIME bigger than before last INSERT?"
 FROM information_schema.tables

=== modified file 'mysql-test/suite/funcs_1/r/is_tables.result'
--- a/mysql-test/suite/funcs_1/r/is_tables.result	2008-03-07 19:18:14 +0000
+++ b/mysql-test/suite/funcs_1/r/is_tables.result	2008-11-13 08:38:30 +0000
@@ -310,6 +310,7 @@ SELECT UPDATE_TIME, checksum INTO @UPDAT
 FROM information_schema.tables
 WHERE table_name = 't1_my_tablex';
 INSERT INTO db_datadict.t1_my_tablex SET f1 = 3;
+FLUSH TABLES;
 SELECT UPDATE_TIME > @UPDATE_TIME
 AS "Is current UPDATE_TIME bigger than before last INSERT?"
 FROM information_schema.tables