bzr push into mysql-trunk-cluster branch (magnus.blaudd:3417 to 3419)

[magnus.blaudd]

 3419 magnus.blaudd@stripped	2011-11-21
      main.information_schema
       - output from unordered query differs from trunk -> record  new .result file

    modified:
      mysql-test/r/information_schema.result
 3418 magnus.blaudd@stripped	2011-11-21
      rpl_ndb
       - add result for newly added testcase by copying from
       rpl_insert_ignore.result

    modified:
      mysql-test/suite/rpl_ndb/r/rpl_ndb_insert_ignore.result
 3417 magnus.blaudd@stripped	2011-11-21
      ndb
       - fix .result file for ndb_cursor, wheter or not it returns a warning
         is not interetsing. Besides that warning seems to be random from version to
         version

    modified:
      mysql-test/suite/ndb/r/ndb_cursor.result
=== modified file 'mysql-test/r/information_schema.result'
--- a/mysql-test/r/information_schema.result	2011-10-27 12:19:57 +0000
+++ b/mysql-test/r/information_schema.result	2011-11-21 20:03:02 +0000
@@ -879,8 +879,8 @@ TABLES	TABLE_NAME	select
 TABLE_CONSTRAINTS	TABLE_NAME	select
 TABLE_PRIVILEGES	TABLE_NAME	select
 VIEWS	TABLE_NAME	select
-INNODB_BUFFER_PAGE	TABLE_NAME	select
 INNODB_BUFFER_PAGE_LRU	TABLE_NAME	select
+INNODB_BUFFER_PAGE	TABLE_NAME	select
 delete from mysql.user where user='mysqltest_4';
 delete from mysql.db where user='mysqltest_4';
 flush privileges;

=== modified file 'mysql-test/suite/rpl_ndb/r/rpl_ndb_insert_ignore.result'
--- a/mysql-test/suite/rpl_ndb/r/rpl_ndb_insert_ignore.result	2011-04-08 12:48:50 +0000
+++ b/mysql-test/suite/rpl_ndb/r/rpl_ndb_insert_ignore.result	2011-11-21 19:40:46 +0000
@@ -25,5 +25,18 @@ include/diff_tables.inc [master:test.t1 
 INSERT IGNORE INTO t1 SELECT NULL, t2.b FROM t2 ORDER BY t2.a;
 include/assert.inc [Count of elements in t1 should be 6.]
 include/assert.inc [In SBR or MIXED modes, the event in the binlog should be the same that was executed. In RBR mode, binlog position should stay unchanged.]
+DROP TABLE t1;
+DROP TABLE t2;
+CREATE TABLE t1 (
+a INT UNSIGNED NOT NULL PRIMARY KEY
+) ENGINE=NDB;
+CREATE TABLE t2 (
+a INT UNSIGNED
+) ENGINE=NDB;
+INSERT INTO t1 VALUES (1);
+INSERT INTO t2 VALUES (1);
+INSERT INTO t1 SELECT t2.a FROM t2 ORDER BY t2.a ON DUPLICATE KEY UPDATE t1.a= t1.a;
+include/assert.inc [Sum of elements in t1 should be 1.]
+include/assert.inc [In SBR or MIXED modes, the event in the binlog should be the same that was executed. In RBR mode, binlog position should stay unchanged.]
 drop table t1, t2;
 include/rpl_end.inc

No bundle (reason: useless for push emails).