List:Commits« Previous MessageNext Message »
From:Ole John Aske Date:January 18 2011 12:47pm
Subject:bzr push into mysql-5.1-telco-7.0 branch (ole.john.aske:4134 to 4135)
Bug#59519
View as plain text  
 4135 Ole John Aske	2011-01-18
      Resultfile needed update after commit of fix for bug#59519.
     @ mysql-test/suite/rpl_ndb/r/rpl_ndb_ddl.result
        As 'rec_per_key[]= 1' is no longer set for non-unique index we don't have available 'Cardinality' statistics for ordered indexes. Thus the change of 'Cardinality' from '0' to NULL (unknown) for the above results.

    modified:
      mysql-test/suite/rpl_ndb/r/rpl_ndb_ddl.result
 4134 Ole John Aske	2011-01-18
      Fix for bug##59519 ::set_rec_per_key() assumes ORDER_INDEX to be unique
      
      An ORDERED_INDEX - which is non-unique - should not set rec_per_key[]= 1 which
      is intended for signaling that there will be ~1 row matching each key value.
      
      Leaving it at '0' will force the optimizer to use its own heuristic to estimate
      how mane 'records pr. key' there will be.
      
      NOTE: For some unknown reason the optimizer will not use handler::::records_in_range()
      to estimate this, but will instead really upon its own estimates.
     @ mysql-test/suite/ndb/r/ndb_alter_table3.result
        As rec_pr_key[] will no longer indicate an ordered index to be be unique, 
        the ordered indexes indexes 'b' and 'c' in this test will now 
        have an unknown 'Cardinality'.

    modified:
      mysql-test/suite/ndb/r/ndb_alter_table3.result
      mysql-test/suite/ndb/r/ndb_statistics.result
      mysql-test/suite/ndb/t/ndb_statistics.test
      sql/ha_ndbcluster.cc
=== modified file 'mysql-test/suite/rpl_ndb/r/rpl_ndb_ddl.result'
--- a/mysql-test/suite/rpl_ndb/r/rpl_ndb_ddl.result	2007-12-11 10:51:14 +0000
+++ b/mysql-test/suite/rpl_ndb/r/rpl_ndb_ddl.result	2011-01-18 12:47:01 +0000
@@ -928,12 +928,12 @@ TEST-INFO: SLAVE:  The INSERT is committ
 -------- switch to master -------
 SHOW INDEX FROM mysqltest1.t5;
 Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment
-t5	1	my_idx5	1	f1	A	0	NULL	NULL	YES	BTREE	
+t5	1	my_idx5	1	f1	A	NULL	NULL	NULL	YES	BTREE	
 
 -------- switch to slave --------
 SHOW INDEX FROM mysqltest1.t5;
 Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment
-t5	1	my_idx5	1	f1	A	0	NULL	NULL	YES	BTREE	
+t5	1	my_idx5	1	f1	A	NULL	NULL	NULL	YES	BTREE	
 
 -------- switch to master -------
 

No bundle (reason: useless for push emails).
Thread
bzr push into mysql-5.1-telco-7.0 branch (ole.john.aske:4134 to 4135)Bug#59519Ole John Aske18 Jan