From: Jorgen Loland
Date: June 22 2011 9:07am
Subject: bzr commit into mysql-trunk branch (jorgen.loland:3387) Bug#12616131
List-Archive: http://lists.mysql.com/commits/139675
X-Bug: 12616131
Message-Id: <20110622090711.337E7C26@atum21.norway.sun.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============4623601374052273300=="

--===============4623601374052273300==
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

#At file:///export/home/jl208045/mysql/mysql-next-mr-opt-backporting/ based on revid:roy.lyseng@stripped

 3387 Jorgen Loland	2011-06-22
      Bug#12616131 - JCL: NULL VS DATE + TWICE AS MANY ROWS RETURNED WHEN JCL>=7
      
      Consider a query of the form
      
      SELECT * FROM t1 LEFT JOIN t2 on t1_col = t2_col
      
      If the BKA UNIQUE algorithm is used on table t2, rows from t1 are read
      into the join buffer and each row's "key" (i.e., the columns used in
      the join) are then inserted into a hash table. When the buffer is
      either full or there are no more rows in t1, join matches are found in
      t2 using the key values in the hash table.
      
      The key value that is inserted into the hash table is created by
      calling cp_buffer_from_ref(). This effectively formats the key
      as a t2_col and copies the necessary info from JOIN_REF.
      
      The problem in this bug was that in the case where t1_col is nullable
      but t2_col is not, the information about NULL-values in t1_col was
      lost in cp_buffer_from_ref(). Thus, if t1_col had a value NULL, key
      would not be NULL but 0 (not necessarily reliably). The result was
      that t1 rows with a t1_col value of NULL would be joined with rows in
      t2 with t2_col=0.
      
      The fix is to not add NULL-valued keys into the hash table if the join
      condition is '='. This also saves work since these keys cannot result
      in join matches anyway.
      
      Note 1: The information about NULL values in t1_col is not lost as
      long as t2_col is also nullable.
      
      Note 2: If the join condition is <=>, the join correctness is handled
      by a triggered condition added in pushdown_on_conditions()
     @ mysql-test/include/join_cache.inc
        Test case for BUG#52636 no longer functioned as a regression test due to changed execution plan. Fixed
        Added test for BUG#12616131
     @ mysql-test/r/join_cache_jcl0.result
        Test case for BUG#52636 no longer functioned as a regression test due to changed execution plan. Fixed
        Added test for BUG#12616131
     @ mysql-test/r/join_cache_jcl1.result
        Test case for BUG#52636 no longer functioned as a regression test due to changed execution plan. Fixed
        Added test for BUG#12616131
     @ mysql-test/r/join_cache_jcl2.result
        Test case for BUG#52636 no longer functioned as a regression test due to changed execution plan. Fixed
        Added test for BUG#12616131
     @ mysql-test/r/join_cache_jcl3.result
        Test case for BUG#52636 no longer functioned as a regression test due to changed execution plan. Fixed
        Added test for BUG#12616131
     @ mysql-test/r/join_cache_jcl4.result
        Test case for BUG#52636 no longer functioned as a regression test due to changed execution plan. Fixed
        Added test for BUG#12616131
     @ mysql-test/r/join_cache_jcl5.result
        Test case for BUG#52636 no longer functioned as a regression test due to changed execution plan. Fixed
        Added test for BUG#12616131
     @ mysql-test/r/join_cache_jcl6.result
        Test case for BUG#52636 no longer functioned as a regression test due to changed execution plan. Fixed
        Added test for BUG#12616131
     @ mysql-test/r/join_cache_jcl7.result
        Test case for BUG#52636 no longer functioned as a regression test due to changed execution plan. Fixed
        Added test for BUG#12616131
     @ mysql-test/r/join_cache_jcl8.result
        Test case for BUG#52636 no longer functioned as a regression test due to changed execution plan. Fixed
        Added test for BUG#12616131
     @ sql/sql_join_cache.cc
        JOIN_CACHE_BKA_UNIQUE::put_record(): Do not add join 
        keys with NULL values into the hash table if join 
        condition is '='. In this case, it is impossible to 
        find a join match to the key. 
        
        The first part of JOIN_CACHE_BKA_UNIQUE::put_record() 
        is equal to JOIN_CACHE::put_record(). Duplicate code 
        is now replaced with call to that method.
        
        JOIN_CACHE_BKA_UNIQUE::get_next_key(): NULL-handling
        no longer needed since keys with NULL values are not
        inserted into the hash table.

    modified:
      mysql-test/include/join_cache.inc
      mysql-test/r/join_cache_jcl0.result
      mysql-test/r/join_cache_jcl1.result
      mysql-test/r/join_cache_jcl2.result
      mysql-test/r/join_cache_jcl3.result
      mysql-test/r/join_cache_jcl4.result
      mysql-test/r/join_cache_jcl5.result
      mysql-test/r/join_cache_jcl6.result
      mysql-test/r/join_cache_jcl7.result
      mysql-test/r/join_cache_jcl8.result
      sql/sql_join_cache.cc
=== modified file 'mysql-test/include/join_cache.inc'
--- a/mysql-test/include/join_cache.inc	2011-06-08 13:24:56 +0000
+++ b/mysql-test/include/join_cache.inc	2011-06-22 09:07:01 +0000
@@ -1474,16 +1474,18 @@ INSERT INTO t1 VALUES (NULL),(3);
 CREATE TABLE t2 (a int, b int, KEY (b));
 INSERT INTO t2 VALUES (100,NULL),(150,200);
 
-explain SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+let $query= SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
+--eval EXPLAIN $query
 --sorted_result
-SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+--eval $query
 
 # test crash when no key is worth collecting by BKA for t2's ref
 delete from t1;
 INSERT INTO t1 VALUES (NULL),(NULL);
-explain SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+
+--eval EXPLAIN $query
 --sorted_result
-SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+--eval $query
 
 DROP TABLE t1,t2;
 
@@ -1646,4 +1648,45 @@ left join t8 on t3.col582 <=  1;
 
 drop table t1,t2,t3,t4,t5,t6,t7,t8;
 
+--echo #
+--echo # Bug#12616131 - JCL: NULL VS DATE + TWICE AS MANY ROWS 
+--echo #                RETURNED WHEN JCL>=7
+--echo #
+
+CREATE TABLE t1 (t1a int, t1b int);
+INSERT INTO t1 VALUES (99, NULL),(99, 3),(99,0);
+
+CREATE TABLE t2 (t2a int, t2b int, KEY idx (t2b));
+INSERT INTO t2 VALUES (100,0),(150,200),(999, 0),(999, NULL);
+
+let $query1= SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+let $query2= SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+
+--echo
+--echo # t2b is NULL-able
+--echo
+--eval EXPLAIN $query1
+--eval $query1
+--echo
+--eval EXPLAIN $query2
+--eval $query2
+--echo
+
+DROP TABLE t2;
+
+CREATE TABLE t2 (t2a int, t2b int NOT NULL, KEY idx (t2b));
+INSERT INTO t2 VALUES (100,0),(150,200),(999, 0);
+
+--echo
+--echo # t2b is NOT NULL
+--echo
+--eval EXPLAIN $query1
+--eval $query1
+--echo
+--eval EXPLAIN $query2
+--eval $query2
+--echo
+
+DROP TABLE t1,t2;
+
 set @@join_buffer_size=default;

=== modified file 'mysql-test/r/join_cache_jcl0.result'
--- a/mysql-test/r/join_cache_jcl0.result	2011-06-08 13:24:56 +0000
+++ b/mysql-test/r/join_cache_jcl0.result	2011-06-22 09:07:01 +0000
@@ -2133,21 +2133,21 @@ CREATE TABLE t1 (b int);
 INSERT INTO t1 VALUES (NULL),(3);
 CREATE TABLE t2 (a int, b int, KEY (b));
 INSERT INTO t2 VALUES (100,NULL),(150,200);
-explain SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+EXPLAIN SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	2	
 1	SIMPLE	t2	ref	b	b	5	test.t1.b	2	
-SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 a
 NULL
 NULL
 delete from t1;
 INSERT INTO t1 VALUES (NULL),(NULL);
-explain SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+EXPLAIN SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	2	
 1	SIMPLE	t2	ref	b	b	5	test.t1.b	2	
-SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 a
 NULL
 NULL
@@ -2303,6 +2303,68 @@ left join t8 on t3.col582 <=  1;
 count(*)
 32
 drop table t1,t2,t3,t4,t5,t6,t7,t8;
+#
+# Bug#12616131 - JCL: NULL VS DATE + TWICE AS MANY ROWS 
+#                RETURNED WHEN JCL>=7
+#
+CREATE TABLE t1 (t1a int, t1b int);
+INSERT INTO t1 VALUES (99, NULL),(99, 3),(99,0);
+CREATE TABLE t2 (t2a int, t2b int, KEY idx (t2b));
+INSERT INTO t2 VALUES (100,0),(150,200),(999, 0),(999, NULL);
+
+# t2b is NULL-able
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	5	test.t1.t1b	2	
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+t1a	t1b	t2a	t2b
+99	NULL	NULL	NULL
+99	3	NULL	NULL
+99	0	100	0
+99	0	999	0
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	5	test.t1.t1b	2	Using where
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+t1a	t1b	t2a	t2b
+99	NULL	999	NULL
+99	3	NULL	NULL
+99	0	100	0
+99	0	999	0
+
+DROP TABLE t2;
+CREATE TABLE t2 (t2a int, t2b int NOT NULL, KEY idx (t2b));
+INSERT INTO t2 VALUES (100,0),(150,200),(999, 0);
+
+# t2b is NOT NULL
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	4	test.t1.t1b	2	
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+t1a	t1b	t2a	t2b
+99	NULL	NULL	NULL
+99	3	NULL	NULL
+99	0	100	0
+99	0	999	0
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	4	test.t1.t1b	2	Using where
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+t1a	t1b	t2a	t2b
+99	NULL	NULL	NULL
+99	3	NULL	NULL
+99	0	100	0
+99	0	999	0
+
+DROP TABLE t1,t2;
 set @@join_buffer_size=default;
 set optimizer_join_cache_level = default;
 set optimizer_switch = default;

=== modified file 'mysql-test/r/join_cache_jcl1.result'
--- a/mysql-test/r/join_cache_jcl1.result	2011-06-08 13:24:56 +0000
+++ b/mysql-test/r/join_cache_jcl1.result	2011-06-22 09:07:01 +0000
@@ -2133,21 +2133,21 @@ CREATE TABLE t1 (b int);
 INSERT INTO t1 VALUES (NULL),(3);
 CREATE TABLE t2 (a int, b int, KEY (b));
 INSERT INTO t2 VALUES (100,NULL),(150,200);
-explain SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+EXPLAIN SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	2	
 1	SIMPLE	t2	ref	b	b	5	test.t1.b	2	
-SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 a
 NULL
 NULL
 delete from t1;
 INSERT INTO t1 VALUES (NULL),(NULL);
-explain SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+EXPLAIN SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	2	
 1	SIMPLE	t2	ref	b	b	5	test.t1.b	2	
-SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 a
 NULL
 NULL
@@ -2303,6 +2303,68 @@ left join t8 on t3.col582 <=  1;
 count(*)
 32
 drop table t1,t2,t3,t4,t5,t6,t7,t8;
+#
+# Bug#12616131 - JCL: NULL VS DATE + TWICE AS MANY ROWS 
+#                RETURNED WHEN JCL>=7
+#
+CREATE TABLE t1 (t1a int, t1b int);
+INSERT INTO t1 VALUES (99, NULL),(99, 3),(99,0);
+CREATE TABLE t2 (t2a int, t2b int, KEY idx (t2b));
+INSERT INTO t2 VALUES (100,0),(150,200),(999, 0),(999, NULL);
+
+# t2b is NULL-able
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	5	test.t1.t1b	2	
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+t1a	t1b	t2a	t2b
+99	NULL	NULL	NULL
+99	3	NULL	NULL
+99	0	100	0
+99	0	999	0
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	5	test.t1.t1b	2	Using where
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+t1a	t1b	t2a	t2b
+99	NULL	999	NULL
+99	3	NULL	NULL
+99	0	100	0
+99	0	999	0
+
+DROP TABLE t2;
+CREATE TABLE t2 (t2a int, t2b int NOT NULL, KEY idx (t2b));
+INSERT INTO t2 VALUES (100,0),(150,200),(999, 0);
+
+# t2b is NOT NULL
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	4	test.t1.t1b	2	
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+t1a	t1b	t2a	t2b
+99	NULL	NULL	NULL
+99	3	NULL	NULL
+99	0	100	0
+99	0	999	0
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	4	test.t1.t1b	2	Using where
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+t1a	t1b	t2a	t2b
+99	NULL	NULL	NULL
+99	3	NULL	NULL
+99	0	100	0
+99	0	999	0
+
+DROP TABLE t1,t2;
 set @@join_buffer_size=default;
 set optimizer_join_cache_level = default;
 set optimizer_switch = default;

=== modified file 'mysql-test/r/join_cache_jcl2.result'
--- a/mysql-test/r/join_cache_jcl2.result	2011-06-08 13:24:56 +0000
+++ b/mysql-test/r/join_cache_jcl2.result	2011-06-22 09:07:01 +0000
@@ -2133,21 +2133,21 @@ CREATE TABLE t1 (b int);
 INSERT INTO t1 VALUES (NULL),(3);
 CREATE TABLE t2 (a int, b int, KEY (b));
 INSERT INTO t2 VALUES (100,NULL),(150,200);
-explain SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+EXPLAIN SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	2	
 1	SIMPLE	t2	ref	b	b	5	test.t1.b	2	
-SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 a
 NULL
 NULL
 delete from t1;
 INSERT INTO t1 VALUES (NULL),(NULL);
-explain SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+EXPLAIN SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	2	
 1	SIMPLE	t2	ref	b	b	5	test.t1.b	2	
-SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 a
 NULL
 NULL
@@ -2303,6 +2303,68 @@ left join t8 on t3.col582 <=  1;
 count(*)
 32
 drop table t1,t2,t3,t4,t5,t6,t7,t8;
+#
+# Bug#12616131 - JCL: NULL VS DATE + TWICE AS MANY ROWS 
+#                RETURNED WHEN JCL>=7
+#
+CREATE TABLE t1 (t1a int, t1b int);
+INSERT INTO t1 VALUES (99, NULL),(99, 3),(99,0);
+CREATE TABLE t2 (t2a int, t2b int, KEY idx (t2b));
+INSERT INTO t2 VALUES (100,0),(150,200),(999, 0),(999, NULL);
+
+# t2b is NULL-able
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	5	test.t1.t1b	2	
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+t1a	t1b	t2a	t2b
+99	NULL	NULL	NULL
+99	3	NULL	NULL
+99	0	100	0
+99	0	999	0
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	5	test.t1.t1b	2	Using where
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+t1a	t1b	t2a	t2b
+99	NULL	999	NULL
+99	3	NULL	NULL
+99	0	100	0
+99	0	999	0
+
+DROP TABLE t2;
+CREATE TABLE t2 (t2a int, t2b int NOT NULL, KEY idx (t2b));
+INSERT INTO t2 VALUES (100,0),(150,200),(999, 0);
+
+# t2b is NOT NULL
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	4	test.t1.t1b	2	
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+t1a	t1b	t2a	t2b
+99	NULL	NULL	NULL
+99	3	NULL	NULL
+99	0	100	0
+99	0	999	0
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	4	test.t1.t1b	2	Using where
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+t1a	t1b	t2a	t2b
+99	NULL	NULL	NULL
+99	3	NULL	NULL
+99	0	100	0
+99	0	999	0
+
+DROP TABLE t1,t2;
 set @@join_buffer_size=default;
 set optimizer_join_cache_level = default;
 set optimizer_switch = default;

=== modified file 'mysql-test/r/join_cache_jcl3.result'
--- a/mysql-test/r/join_cache_jcl3.result	2011-06-08 13:24:56 +0000
+++ b/mysql-test/r/join_cache_jcl3.result	2011-06-22 09:07:01 +0000
@@ -2133,21 +2133,21 @@ CREATE TABLE t1 (b int);
 INSERT INTO t1 VALUES (NULL),(3);
 CREATE TABLE t2 (a int, b int, KEY (b));
 INSERT INTO t2 VALUES (100,NULL),(150,200);
-explain SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+EXPLAIN SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	2	
-1	SIMPLE	t2	ALL	b	NULL	NULL	NULL	2	Using where; Using join buffer (BNL, regular buffers)
-SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+1	SIMPLE	t2	ref	b	b	5	test.t1.b	2	
+SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 a
 NULL
 NULL
 delete from t1;
 INSERT INTO t1 VALUES (NULL),(NULL);
-explain SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+EXPLAIN SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	2	
-1	SIMPLE	t2	ALL	b	NULL	NULL	NULL	2	Using where; Using join buffer (BNL, regular buffers)
-SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+1	SIMPLE	t2	ref	b	b	5	test.t1.b	2	
+SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 a
 NULL
 NULL
@@ -2303,6 +2303,68 @@ left join t8 on t3.col582 <=  1;
 count(*)
 32
 drop table t1,t2,t3,t4,t5,t6,t7,t8;
+#
+# Bug#12616131 - JCL: NULL VS DATE + TWICE AS MANY ROWS 
+#                RETURNED WHEN JCL>=7
+#
+CREATE TABLE t1 (t1a int, t1b int);
+INSERT INTO t1 VALUES (99, NULL),(99, 3),(99,0);
+CREATE TABLE t2 (t2a int, t2b int, KEY idx (t2b));
+INSERT INTO t2 VALUES (100,0),(150,200),(999, 0),(999, NULL);
+
+# t2b is NULL-able
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	5	test.t1.t1b	2	
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+t1a	t1b	t2a	t2b
+99	NULL	NULL	NULL
+99	3	NULL	NULL
+99	0	100	0
+99	0	999	0
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	5	test.t1.t1b	2	Using where
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+t1a	t1b	t2a	t2b
+99	NULL	999	NULL
+99	3	NULL	NULL
+99	0	100	0
+99	0	999	0
+
+DROP TABLE t2;
+CREATE TABLE t2 (t2a int, t2b int NOT NULL, KEY idx (t2b));
+INSERT INTO t2 VALUES (100,0),(150,200),(999, 0);
+
+# t2b is NOT NULL
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	4	test.t1.t1b	2	
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+t1a	t1b	t2a	t2b
+99	NULL	NULL	NULL
+99	3	NULL	NULL
+99	0	100	0
+99	0	999	0
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	4	test.t1.t1b	2	Using where
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+t1a	t1b	t2a	t2b
+99	NULL	NULL	NULL
+99	3	NULL	NULL
+99	0	100	0
+99	0	999	0
+
+DROP TABLE t1,t2;
 set @@join_buffer_size=default;
 set optimizer_join_cache_level = default;
 set optimizer_switch = default;

=== modified file 'mysql-test/r/join_cache_jcl4.result'
--- a/mysql-test/r/join_cache_jcl4.result	2011-06-08 13:24:56 +0000
+++ b/mysql-test/r/join_cache_jcl4.result	2011-06-22 09:07:01 +0000
@@ -2133,21 +2133,21 @@ CREATE TABLE t1 (b int);
 INSERT INTO t1 VALUES (NULL),(3);
 CREATE TABLE t2 (a int, b int, KEY (b));
 INSERT INTO t2 VALUES (100,NULL),(150,200);
-explain SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+EXPLAIN SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	2	
-1	SIMPLE	t2	ALL	b	NULL	NULL	NULL	2	Using where; Using join buffer (BNL, incremental buffers)
-SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+1	SIMPLE	t2	ref	b	b	5	test.t1.b	2	
+SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 a
 NULL
 NULL
 delete from t1;
 INSERT INTO t1 VALUES (NULL),(NULL);
-explain SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+EXPLAIN SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	2	
-1	SIMPLE	t2	ALL	b	NULL	NULL	NULL	2	Using where; Using join buffer (BNL, incremental buffers)
-SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+1	SIMPLE	t2	ref	b	b	5	test.t1.b	2	
+SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 a
 NULL
 NULL
@@ -2303,6 +2303,68 @@ left join t8 on t3.col582 <=  1;
 count(*)
 32
 drop table t1,t2,t3,t4,t5,t6,t7,t8;
+#
+# Bug#12616131 - JCL: NULL VS DATE + TWICE AS MANY ROWS 
+#                RETURNED WHEN JCL>=7
+#
+CREATE TABLE t1 (t1a int, t1b int);
+INSERT INTO t1 VALUES (99, NULL),(99, 3),(99,0);
+CREATE TABLE t2 (t2a int, t2b int, KEY idx (t2b));
+INSERT INTO t2 VALUES (100,0),(150,200),(999, 0),(999, NULL);
+
+# t2b is NULL-able
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	5	test.t1.t1b	2	
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+t1a	t1b	t2a	t2b
+99	NULL	NULL	NULL
+99	3	NULL	NULL
+99	0	100	0
+99	0	999	0
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	5	test.t1.t1b	2	Using where
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+t1a	t1b	t2a	t2b
+99	NULL	999	NULL
+99	3	NULL	NULL
+99	0	100	0
+99	0	999	0
+
+DROP TABLE t2;
+CREATE TABLE t2 (t2a int, t2b int NOT NULL, KEY idx (t2b));
+INSERT INTO t2 VALUES (100,0),(150,200),(999, 0);
+
+# t2b is NOT NULL
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	4	test.t1.t1b	2	
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+t1a	t1b	t2a	t2b
+99	NULL	NULL	NULL
+99	3	NULL	NULL
+99	0	100	0
+99	0	999	0
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	4	test.t1.t1b	2	Using where
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+t1a	t1b	t2a	t2b
+99	NULL	NULL	NULL
+99	3	NULL	NULL
+99	0	100	0
+99	0	999	0
+
+DROP TABLE t1,t2;
 set @@join_buffer_size=default;
 set optimizer_join_cache_level = default;
 set optimizer_switch = default;

=== modified file 'mysql-test/r/join_cache_jcl5.result'
--- a/mysql-test/r/join_cache_jcl5.result	2011-06-08 13:24:56 +0000
+++ b/mysql-test/r/join_cache_jcl5.result	2011-06-22 09:07:01 +0000
@@ -2133,21 +2133,21 @@ CREATE TABLE t1 (b int);
 INSERT INTO t1 VALUES (NULL),(3);
 CREATE TABLE t2 (a int, b int, KEY (b));
 INSERT INTO t2 VALUES (100,NULL),(150,200);
-explain SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+EXPLAIN SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	2	
-1	SIMPLE	t2	ALL	b	NULL	NULL	NULL	2	Using where; Using join buffer (BNL, regular buffers)
-SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+1	SIMPLE	t2	ref	b	b	5	test.t1.b	2	Using join buffer (BKA, regular buffers)
+SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 a
 NULL
 NULL
 delete from t1;
 INSERT INTO t1 VALUES (NULL),(NULL);
-explain SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+EXPLAIN SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	2	
-1	SIMPLE	t2	ALL	b	NULL	NULL	NULL	2	Using where; Using join buffer (BNL, regular buffers)
-SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+1	SIMPLE	t2	ref	b	b	5	test.t1.b	2	Using join buffer (BKA, regular buffers)
+SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 a
 NULL
 NULL
@@ -2303,6 +2303,68 @@ left join t8 on t3.col582 <=  1;
 count(*)
 32
 drop table t1,t2,t3,t4,t5,t6,t7,t8;
+#
+# Bug#12616131 - JCL: NULL VS DATE + TWICE AS MANY ROWS 
+#                RETURNED WHEN JCL>=7
+#
+CREATE TABLE t1 (t1a int, t1b int);
+INSERT INTO t1 VALUES (99, NULL),(99, 3),(99,0);
+CREATE TABLE t2 (t2a int, t2b int, KEY idx (t2b));
+INSERT INTO t2 VALUES (100,0),(150,200),(999, 0),(999, NULL);
+
+# t2b is NULL-able
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	5	test.t1.t1b	2	Using join buffer (BKA, regular buffers)
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+t1a	t1b	t2a	t2b
+99	0	100	0
+99	0	999	0
+99	NULL	NULL	NULL
+99	3	NULL	NULL
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	5	test.t1.t1b	2	Using where; Using join buffer (BKA, regular buffers)
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+t1a	t1b	t2a	t2b
+99	0	100	0
+99	0	999	0
+99	NULL	999	NULL
+99	3	NULL	NULL
+
+DROP TABLE t2;
+CREATE TABLE t2 (t2a int, t2b int NOT NULL, KEY idx (t2b));
+INSERT INTO t2 VALUES (100,0),(150,200),(999, 0);
+
+# t2b is NOT NULL
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	4	test.t1.t1b	2	Using join buffer (BKA, regular buffers)
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+t1a	t1b	t2a	t2b
+99	0	100	0
+99	0	999	0
+99	NULL	NULL	NULL
+99	3	NULL	NULL
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	4	test.t1.t1b	2	Using where; Using join buffer (BKA, regular buffers)
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+t1a	t1b	t2a	t2b
+99	0	100	0
+99	0	999	0
+99	NULL	NULL	NULL
+99	3	NULL	NULL
+
+DROP TABLE t1,t2;
 set @@join_buffer_size=default;
 set optimizer_join_cache_level = default;
 set optimizer_switch = default;

=== modified file 'mysql-test/r/join_cache_jcl6.result'
--- a/mysql-test/r/join_cache_jcl6.result	2011-06-08 13:24:56 +0000
+++ b/mysql-test/r/join_cache_jcl6.result	2011-06-22 09:07:01 +0000
@@ -2133,21 +2133,21 @@ CREATE TABLE t1 (b int);
 INSERT INTO t1 VALUES (NULL),(3);
 CREATE TABLE t2 (a int, b int, KEY (b));
 INSERT INTO t2 VALUES (100,NULL),(150,200);
-explain SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+EXPLAIN SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	2	
-1	SIMPLE	t2	ALL	b	NULL	NULL	NULL	2	Using where; Using join buffer (BNL, incremental buffers)
-SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+1	SIMPLE	t2	ref	b	b	5	test.t1.b	2	Using join buffer (BKA, incremental buffers)
+SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 a
 NULL
 NULL
 delete from t1;
 INSERT INTO t1 VALUES (NULL),(NULL);
-explain SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+EXPLAIN SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	2	
-1	SIMPLE	t2	ALL	b	NULL	NULL	NULL	2	Using where; Using join buffer (BNL, incremental buffers)
-SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+1	SIMPLE	t2	ref	b	b	5	test.t1.b	2	Using join buffer (BKA, incremental buffers)
+SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 a
 NULL
 NULL
@@ -2303,6 +2303,68 @@ left join t8 on t3.col582 <=  1;
 count(*)
 32
 drop table t1,t2,t3,t4,t5,t6,t7,t8;
+#
+# Bug#12616131 - JCL: NULL VS DATE + TWICE AS MANY ROWS 
+#                RETURNED WHEN JCL>=7
+#
+CREATE TABLE t1 (t1a int, t1b int);
+INSERT INTO t1 VALUES (99, NULL),(99, 3),(99,0);
+CREATE TABLE t2 (t2a int, t2b int, KEY idx (t2b));
+INSERT INTO t2 VALUES (100,0),(150,200),(999, 0),(999, NULL);
+
+# t2b is NULL-able
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	5	test.t1.t1b	2	Using join buffer (BKA, incremental buffers)
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+t1a	t1b	t2a	t2b
+99	0	100	0
+99	0	999	0
+99	NULL	NULL	NULL
+99	3	NULL	NULL
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	5	test.t1.t1b	2	Using where; Using join buffer (BKA, incremental buffers)
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+t1a	t1b	t2a	t2b
+99	0	100	0
+99	0	999	0
+99	NULL	999	NULL
+99	3	NULL	NULL
+
+DROP TABLE t2;
+CREATE TABLE t2 (t2a int, t2b int NOT NULL, KEY idx (t2b));
+INSERT INTO t2 VALUES (100,0),(150,200),(999, 0);
+
+# t2b is NOT NULL
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	4	test.t1.t1b	2	Using join buffer (BKA, incremental buffers)
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+t1a	t1b	t2a	t2b
+99	0	100	0
+99	0	999	0
+99	NULL	NULL	NULL
+99	3	NULL	NULL
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	4	test.t1.t1b	2	Using where; Using join buffer (BKA, incremental buffers)
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+t1a	t1b	t2a	t2b
+99	0	100	0
+99	0	999	0
+99	NULL	NULL	NULL
+99	3	NULL	NULL
+
+DROP TABLE t1,t2;
 set @@join_buffer_size=default;
 set optimizer_join_cache_level = default;
 set optimizer_switch = default;

=== modified file 'mysql-test/r/join_cache_jcl7.result'
--- a/mysql-test/r/join_cache_jcl7.result	2011-06-08 13:24:56 +0000
+++ b/mysql-test/r/join_cache_jcl7.result	2011-06-22 09:07:01 +0000
@@ -2133,21 +2133,21 @@ CREATE TABLE t1 (b int);
 INSERT INTO t1 VALUES (NULL),(3);
 CREATE TABLE t2 (a int, b int, KEY (b));
 INSERT INTO t2 VALUES (100,NULL),(150,200);
-explain SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+EXPLAIN SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	2	
-1	SIMPLE	t2	ALL	b	NULL	NULL	NULL	2	Using where; Using join buffer (BNL, regular buffers)
-SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+1	SIMPLE	t2	ref	b	b	5	test.t1.b	2	Using join buffer (BKA_UNIQUE, regular buffers)
+SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 a
 NULL
 NULL
 delete from t1;
 INSERT INTO t1 VALUES (NULL),(NULL);
-explain SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+EXPLAIN SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	2	
-1	SIMPLE	t2	ALL	b	NULL	NULL	NULL	2	Using where; Using join buffer (BNL, regular buffers)
-SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+1	SIMPLE	t2	ref	b	b	5	test.t1.b	2	Using join buffer (BKA_UNIQUE, regular buffers)
+SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 a
 NULL
 NULL
@@ -2303,6 +2303,68 @@ left join t8 on t3.col582 <=  1;
 count(*)
 32
 drop table t1,t2,t3,t4,t5,t6,t7,t8;
+#
+# Bug#12616131 - JCL: NULL VS DATE + TWICE AS MANY ROWS 
+#                RETURNED WHEN JCL>=7
+#
+CREATE TABLE t1 (t1a int, t1b int);
+INSERT INTO t1 VALUES (99, NULL),(99, 3),(99,0);
+CREATE TABLE t2 (t2a int, t2b int, KEY idx (t2b));
+INSERT INTO t2 VALUES (100,0),(150,200),(999, 0),(999, NULL);
+
+# t2b is NULL-able
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	5	test.t1.t1b	2	Using join buffer (BKA_UNIQUE, regular buffers)
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+t1a	t1b	t2a	t2b
+99	0	100	0
+99	0	999	0
+99	NULL	NULL	NULL
+99	3	NULL	NULL
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	5	test.t1.t1b	2	Using where; Using join buffer (BKA_UNIQUE, regular buffers)
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+t1a	t1b	t2a	t2b
+99	0	100	0
+99	0	999	0
+99	NULL	999	NULL
+99	3	NULL	NULL
+
+DROP TABLE t2;
+CREATE TABLE t2 (t2a int, t2b int NOT NULL, KEY idx (t2b));
+INSERT INTO t2 VALUES (100,0),(150,200),(999, 0);
+
+# t2b is NOT NULL
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	4	test.t1.t1b	2	Using join buffer (BKA_UNIQUE, regular buffers)
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+t1a	t1b	t2a	t2b
+99	0	100	0
+99	0	999	0
+99	NULL	NULL	NULL
+99	3	NULL	NULL
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	4	test.t1.t1b	2	Using where; Using join buffer (BKA_UNIQUE, regular buffers)
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+t1a	t1b	t2a	t2b
+99	0	100	0
+99	0	999	0
+99	NULL	NULL	NULL
+99	3	NULL	NULL
+
+DROP TABLE t1,t2;
 set @@join_buffer_size=default;
 set optimizer_join_cache_level = default;
 set optimizer_switch = default;

=== modified file 'mysql-test/r/join_cache_jcl8.result'
--- a/mysql-test/r/join_cache_jcl8.result	2011-06-08 13:24:56 +0000
+++ b/mysql-test/r/join_cache_jcl8.result	2011-06-22 09:07:01 +0000
@@ -2133,21 +2133,21 @@ CREATE TABLE t1 (b int);
 INSERT INTO t1 VALUES (NULL),(3);
 CREATE TABLE t2 (a int, b int, KEY (b));
 INSERT INTO t2 VALUES (100,NULL),(150,200);
-explain SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+EXPLAIN SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	2	
-1	SIMPLE	t2	ALL	b	NULL	NULL	NULL	2	Using where; Using join buffer (BNL, incremental buffers)
-SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+1	SIMPLE	t2	ref	b	b	5	test.t1.b	2	Using join buffer (BKA_UNIQUE, incremental buffers)
+SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 a
 NULL
 NULL
 delete from t1;
 INSERT INTO t1 VALUES (NULL),(NULL);
-explain SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+EXPLAIN SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	2	
-1	SIMPLE	t2	ALL	b	NULL	NULL	NULL	2	Using where; Using join buffer (BNL, incremental buffers)
-SELECT t2.a FROM t1 LEFT JOIN t2 ON t2.b  = t1.b;
+1	SIMPLE	t2	ref	b	b	5	test.t1.b	2	Using join buffer (BKA_UNIQUE, incremental buffers)
+SELECT t2.a FROM t1 LEFT JOIN t2 FORCE INDEX (b) ON t2.b  = t1.b;
 a
 NULL
 NULL
@@ -2303,6 +2303,68 @@ left join t8 on t3.col582 <=  1;
 count(*)
 32
 drop table t1,t2,t3,t4,t5,t6,t7,t8;
+#
+# Bug#12616131 - JCL: NULL VS DATE + TWICE AS MANY ROWS 
+#                RETURNED WHEN JCL>=7
+#
+CREATE TABLE t1 (t1a int, t1b int);
+INSERT INTO t1 VALUES (99, NULL),(99, 3),(99,0);
+CREATE TABLE t2 (t2a int, t2b int, KEY idx (t2b));
+INSERT INTO t2 VALUES (100,0),(150,200),(999, 0),(999, NULL);
+
+# t2b is NULL-able
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	5	test.t1.t1b	2	Using join buffer (BKA_UNIQUE, incremental buffers)
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+t1a	t1b	t2a	t2b
+99	0	100	0
+99	0	999	0
+99	NULL	NULL	NULL
+99	3	NULL	NULL
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	5	test.t1.t1b	2	Using where; Using join buffer (BKA_UNIQUE, incremental buffers)
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+t1a	t1b	t2a	t2b
+99	0	100	0
+99	0	999	0
+99	NULL	999	NULL
+99	3	NULL	NULL
+
+DROP TABLE t2;
+CREATE TABLE t2 (t2a int, t2b int NOT NULL, KEY idx (t2b));
+INSERT INTO t2 VALUES (100,0),(150,200),(999, 0);
+
+# t2b is NOT NULL
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	4	test.t1.t1b	2	Using join buffer (BKA_UNIQUE, incremental buffers)
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b = t1.t1b;
+t1a	t1b	t2a	t2b
+99	0	100	0
+99	0	999	0
+99	NULL	NULL	NULL
+99	3	NULL	NULL
+
+EXPLAIN SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	3	
+1	SIMPLE	t2	ref	idx	idx	4	test.t1.t1b	2	Using where; Using join buffer (BKA_UNIQUE, incremental buffers)
+SELECT * FROM t1 LEFT JOIN t2 force index (idx) ON t2.t2b <=> t1.t1b;
+t1a	t1b	t2a	t2b
+99	0	100	0
+99	0	999	0
+99	NULL	NULL	NULL
+99	3	NULL	NULL
+
+DROP TABLE t1,t2;
 set @@join_buffer_size=default;
 set optimizer_join_cache_level = default;
 set optimizer_switch = default;

=== modified file 'sql/sql_join_cache.cc'
--- a/sql/sql_join_cache.cc	2011-06-11 13:20:10 +0000
+++ b/sql/sql_join_cache.cc	2011-06-22 09:07:01 +0000
@@ -748,8 +748,8 @@ bool JOIN_CACHE_BKA::check_emb_key_usage
       return FALSE;
       /*
         If this is changed so that embedded keys may contain nullable
-        components, get_next_key() willhave to test ref->null_rejecting in the
-        "embedded keys" case too.
+        components, get_next_key() and put_record() will have to test
+        ref->null_rejecting in the "embedded keys" case too.
       */
     }
   }
@@ -2652,27 +2652,35 @@ void JOIN_CACHE_BKA_UNIQUE::reset(bool f
 
 bool JOIN_CACHE_BKA_UNIQUE::put_record()
 {
-  bool is_full;
   uchar *key;
   uint key_len= key_length;
   uchar *key_ref_ptr;
-  uchar *link= 0;
   TABLE_REF *ref= &join_tab->ref;
   uchar *next_ref_ptr= pos;
-
   pos+= get_size_of_rec_offset();
-  /* Write the record into the join buffer */  
-  if (prev_cache)
-    link= prev_cache->get_curr_rec_link();
-  write_record_data(link, &is_full);
+
+  // Write record to join buffer
+  bool is_full= JOIN_CACHE::put_record();
 
   if (use_emb_key)
-    key= get_curr_emb_key();
+  {
+     key= get_curr_emb_key();
+    // Embedded is not used if one of the key columns is nullable
+  }
   else
   {
     /* Build the key over the fields read into the record buffers */ 
     cp_buffer_from_ref(join->thd, join_tab->table, ref);
     key= ref->key_buff;
+    /*
+      If the row just read into the buffer has a NULL-value for one of
+      the ref-columns and the join comparison function for that column
+      is '=' (in contrast to '<=>'), it's impossible with a join match
+      for this row. The key is therefore not inserted into the hash
+      table.
+    */
+    if (ref->impossible_null_ref())
+      return is_full;
   }
 
   /* Look for the key in the hash table */
@@ -3250,54 +3258,19 @@ bool JOIN_CACHE_BKA_UNIQUE::check_all_ma
 */
 
 uint JOIN_CACHE_BKA_UNIQUE::get_next_key(uchar ** key)
-{  
-
-  uint len= 0;
+{
+  if (curr_key_entry == last_key_entry)
+    return 0;
 
-  /* Read keys until find non-ignorable one or EOF */
-  while((curr_key_entry > last_key_entry) && (len == 0))
-  {
-    curr_key_entry-= key_entry_length;
+  curr_key_entry-= key_entry_length;
 
-    *key = use_emb_key ? get_emb_key(curr_key_entry) : curr_key_entry;
+  *key = use_emb_key ? get_emb_key(curr_key_entry) : curr_key_entry;
 
-    DBUG_ASSERT(*key >= buff && *key < hash_table);
+  DBUG_ASSERT(*key >= buff && *key < hash_table);
 
-    len= key_length;
-    DBUG_ASSERT(len != 0);
-    const TABLE_REF *ref= &join_tab->ref;
-    if (ref->null_rejecting != 0)
-    {
-      /*
-        Unlike JOIN_CACHE_BKA::get_next_key(), we have a key just read from
-        a buffer, not up-to-date fields pointed to by "ref". So we cannot use
-        ref->null_rejected(), must inspect the key.
-      */
-      const KEY *key_info= join_tab->table->key_info + ref->key;
-      const uchar *ptr= *key;
-#ifndef DBUG_OFF
-      const uchar *key_end= ptr + key_length;
-#endif
-      for (uint i= 0 ; i < ref->key_parts ; i++)
-      {
-        KEY_PART_INFO *key_part= key_info->key_part + i;
-        if (key_part->null_bit && ptr[0] && (ref->null_rejecting & 1 << i))
-        {
-          DBUG_PRINT("info", ("JOIN_CACHE_BKA_UNIQUE::get_next_key null_rejected"));
-          len= 0;
-          break;
-        }
-        ptr+= key_part->store_length;
-        DBUG_ASSERT(ptr <= key_end);
-      }
-      if (len != 0)
-        DBUG_ASSERT(ptr == key_end); /* should have read the full key */
-    }
-  }
-  return len;
+  return key_length;
 }
 
-
 /**
   Check matching to a partial join record from the join buffer, an
   implementation specialized for JOIN_CACHE_BKA_UNIQUE.


--===============4623601374052273300==
MIME-Version: 1.0
Content-Type: text/bzr-bundle; charset="us-ascii";
	name="bzr/jorgen.loland@stripped"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

# Bazaar merge directive format 2 (Bazaar 0.90)
# revision_id: jorgen.loland@stripped\
#   tbaprq34n8nseq0b
# target_branch: file:///export/home/jl208045/mysql/mysql-next-mr-opt-\
#   backporting/
# testament_sha1: 868fc73bc03476caaa3b535e01bc4be59305a49b
# timestamp: 2011-06-22 11:07:11 +0200
# base_revision_id: roy.lyseng@stripped\
#   yoilro188bil1nbf
# 
# Begin bundle
IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWTZpRyUAHoHfgHQ0Xf//////
/+C////6YBoe+j53DvWkF3uPG3vuN1u7p00qgqgKA0HiOl0GNaVS1tm0Z21C9afRqqfWS0aTTE61
VUSkRJ2+ElETTUfqhp6h6m0j0anqD1AaADIaDQA0AAaCSSNJ5VP8lT/KaZJP1T0mgAAAGQ0AAAAA
GUyGlT1P1R6gAZANNAABoZAAAAAAk1JTU8jSjaZU9HpqEHk0ntTSaYmyeqDQ8oAA0aABFFATTRkG
pkCanp6GlNTbRHpT1A00bQymRozSDygIpBATINJkyA0mIJ6VNqemiep5TyjT1AHqaaA0P1SwPtgT
lBDlF6gVOUEIAIBD2AD4ghMEP4iEwYEKAhRDuBD/gEJAhWhAKMKNoISoBIQjCQJSCJaIFoPuBzAh
AIWgh8AQvBCsAfyBCoEPvBDxBD+gIQANwISCF4QPAE8EGCqqkYKqrQQOc4GSGPdo2+rVwxRKqFAw
QYMJhA/XbPVxVMc5rc2sxO2pAZmYoki+wc+ROyWCaxox0GDTees6d/V9Jn2zb/47n+MXx3dliHWh
yQ7kLBChB3WdRbFtvEmFxpfQPAEKA/AEOOoE5AHIEJAhASSAYV5cwNT5Cd5LpJef2bNyG5CUIQIt
ohIVkFQOoSANgk4JBVkQyCYeNcZqrrzxIRDVl00C9lwmFUltFUCEjv5cs4Ou2TQIs0gg23NS6and
B159ZvBBQtasYgLP2iH9GWVFYi6BdwkHMiELVfaPt7ohg2ySSddNXIV6AP+qIV/V8hEPs391ZCcw
SoJ+iiHjl51K1JuUx96mdSIgYQhEYh/YCcp+iWwA/v4fLmzV1yd0VRwiyFLYjX0Wi25rAeNNqExh
CGBCBhCGFH3oUnKeN8i6ApfdRDG4cxJ2tYiEL7sKIUMIuiZjZPy8/JEO/38EQmiHlUOtTTwBPMTo
pd+HreP170Q+aIfWohUTUiHkK3T/BT4qUAF+P4/D7egJ2gC+minMT0EwEzU6/10jHAEsEraJbp23
9KqOf3qY6wQiBCMhPxEgEgT6lM+5Lu2BlgiqI30jqSILGRLlR5r4h5mc/XJBmPSJ4az07jothlId
FVycWchMpjioqKqqqq46sN+eAn13T2iSptljdBEZxbn13CWUIEtRmJClnARCX/WBLG7XbAm38/LS
ytw9Pzr0BN1dt8rycQbYk6Tl6WA2CIbYNllnxFcxXBmQa7GoJnddAs0NY0e3ONsyPNjjQBWhQhos
P6zmRla6DNZBIo8GdmkOuw6ohw8g7AVjrmwbO6FdLpJEJiINorZaw4RQFKr35RBO2Vg6zc0z2cUR
8QBL5CM+DhcQ1wgelgMBgMBQEBIJC3bexw1sEtBPkiGIJCiFnsiElUaCX3aatLgT0Akt8OyRNgmQ
py5sK69UyXUUBRFFE2ysUxYKrSVJBUnUQEURRZpc0tEVXtVrBzkjSSLZwBy5SznM1Yd4zeT2eir+
n0PJRm5cNaBu0wE4+mgM98hwY5Ddq3rbq0cUAypPYSSLJH5ICkBYCwFgOuQ/AIVJPjbuZKDn1cGx
41Gl1814Q7BWBIASBVphAAjq6KwH3U60Q84iE/WCYJ+PEE9wnISQrW6A7JoVQgnKJQ1iaASjxwUQ
9kFEKeQVrEtEkExN3vKqqufHv33XKqqvt5SSdL3sCQDQEJghwBFAIuCRkgg/OnTCvb5lcIr4PaLK
zMz2ZlYZv/oD8AE9tzz8ziJdtn+QjTP2d7m9L63DVvbHzv82yXvEw9O3QJjVyCNYmLobEKWqvDTH
4+mSnboJ6+05QVLsOKIQDCIQiHXQVO2C9RwR+T1O94vW/B1OTW2ta1tyuxbp2W3WX3X8gBwJITAh
AzTq2m05Al93h2Cqqqq6dOSQqhV7sgQ/MFSM5AjtxFdJISBdEIQkhApugtg31QsmE99/cfMEuBLA
SQkglwJVD6KtCUohduBJQSBOo+Dgo3uFRTWMKJbQoSRPAScm8+0+99NEavwL7UJj+UWFJKcTeiSR
dpmZCMbCqHATGzWWHK4MuYRubzWuYSFob8vW/FBh2FxcU2B2agzNtMyRkYtri0ZAh8wRJfUh3lus
kQCyJDF02CalMaNUUgq4ZkJUyc6LroQHsIFRn90eAIZfaCTROzJEvatBtkAk285ci09dn78FE7cJ
2XX89Hg3EP3omFtOfGNdZR17cq8S7fMSSJtzEtUdZAh2o7lJOBdOYhoh035g0EOIJuLFNReaoM0S
htL6E5URNeBIttVmc0K/rwqPk+u7VkcjiRPA1Zd/BTyAjcbCQVDAuL+Y3KcxVveQ2CdHBsHaYF5e
cBMHwAHWAPDdGaGgSBthWcVBN84kUA5OacmBEM6QIh2gnOhfXIAFpfyEbyWDDZiik2AQ3G0+uwRv
G0sQka3vZoYuJMsExOaFh08ZnaXtjxMik0SRkJeYEIYxEoiO42kWHhDJtLPQmd1/jiLyBOyEVkYH
ExKCImBicDcfYhmYcyp1nq832fo1bOTz8QEOGsx3sxJQMrbeVBPFOou6G9DcKWwJcee+ykUJCePj
qcTWSxM3I6uZxEcUOrwubELSqtYY3iTqzIQkXEnaJsjxLSZcajaYl0I1OJLBdSRzlwWzwfF4Uocw
hkY6NBo1snmm0QmMD0hbS6SlGBzMXcaGBO7cVLiu80MLS0TMwKCGDdzMbSmBYaR2xS+SQVb6TMCp
QD4SEtB1Hk1KG82lhLu7rOoSqGhbsdqHd0e0RjmK03ddUOSGSETQlwqSeaT0FCHv5HLHgaF7lu0w
LDMZHwEvMgtMTNGhvnaEyDHECRFyFatJGwSsqNNpfqxLCrg9pLEsvKoWBIqfchaajxbzZcYHo2G8
+7IzzwvYO87MDn2TjnZ0mGgzm+KqqwGAgxkKzatCxFXrEmkr0a1zRNaJRExKnUhXV4ZWovALj5OB
VtkJgGJh2GPjlMtW8zLTm91QnmZWoUaEWe4rSpurpWQMGw3E9C0u3zOD1vY8OT7boEg16xNc5uTs
Su7IR7DbPaiYGHU0sK89Z61ob4ckIZw8L+zXzqwZm6brstIJsXE65HMsMKV3RBM0R2Y1DWsUiE5Y
Mlgz0KpUrM1K0H35CMQwLy42lPDCMIj6ItdkZDlMTK8J2ITiWWzLE2jhqVSRFjiKmgwwMSTy2Nal
rpaVaOa+zVcazSQMG0ocQoajDEycmr8xHU7kVTXLga74zztBWbeO7LUyljQR3FjBffeUJkVZmBH0
Ey74M3Q0DI1GhtTWYmhuNibD3gIVBCAEIRfAEgSBM4WZjtRSkVp3dVU6zAydxia4D7Lv2qSx4bq4
yT7k3cZq2wTiMlOde+c7kIJAwDXLihdVGxSVoX2IzoDF9DEWV8S9fqs1gm+qZBCUJyrkppQlUJQQ
2AaxQ6HYEcL+xjudvNeEgeXG+KwGR2IqqqsRHBSRZjQ351LfrVDj61L1Qp8injgUdYmMOhR/0j9I
g+9MwK9wIfEV+xS5T/3uU7xW5XoE3kJEDCkFfmAbH6xBoBLbZE41J/tT4ohYnwFLhW0AWIUtB9yI
UAkmoETYpsAGBX/tAgwL8YjOK7aAC3qTkAL/AAWqkKtgrRTaiGA4ijoCWs+AIZyREIAFgS5EzPop
DCmIIm0Ff0AFsRDEVgVkTfALW/lgQCntLuCSghpJAhMSQ/YAQoIOYAtQBc0FDUCEIIsCs3gCwpuE
UqUgUEoVRhENqlgBUEmCu1QAJCQAsIrapMcjgK8RRbgBbFUYBP0RDcCSUxBP0BXoBEuAKEQ1CvPm
+AmKmcAXnBKKblXkJAr3qaKTooaCEKEKEIQhCEIRqFebIESvSohsFbwBcQSaITuEGqCXCupSanIT
EkQQH0AOYryRLRABpvV5KSNYQQEEBBApAIyppUkzoA1qQCfnDI6FfwPBkJ5fIqrGvd7/315iUdZk
kC66QqKQh5oeexBXMNIg2ChQTXItfgRb66RSIBDOCGIIYAh+iIbiglASSB+R95BcA0PwEiZDQJed
ROs6jrLH46jOOgIG6BqWoKHu1H2Nh9hxs5cFR59m9BKd0faXs1BkZF7zA5hfuB1g/hdswJKGoTJS
vUJbFYQo4g20S+11iNQeVU0Qc4Il/AukJ7RPBGgGN/jNITJw5pCwa4F2OXw9sh7gIiIiIiQNoDAI
bNx5AhVEIBEoJArSgP5IhMEkpMhMT8+/vPAqVJGhJsskf5NtSzzLi/xMTg2n7texEIQQ4ND3bdsz
vEfV9TIvN/eaGeRux63I53odsu54bwR7CBhEObg0ZnGTfvoRfAgR7MWZUQxq0obZ5MmWg3F7RRVr
MjcScprIHMK6iTyBEu28aEjFJCxxYS10NRQ3CUr88mTdUrr4megiHWbjnZPhxNj4eFkWU0EoqNCw
WlzTPYz94iQglpbuUi6DFBNk/GN5FcGgYf3sXg9KIhJSCvmVJiawQhTKzuiUxPhBQQpEBRAUwUxT
CkckmUpuU4dZJTjwnoCnyZdBUYHUakNMeVjFHqmlDXGCOPAoKyCSzy9pwLlSlR2Y2ukwZPmE5OBp
5WqBNhfbeIhhwBlLRL0JPuqE6rdHSJIoJouAQ3Kp3CRru9COvdZNpFikHeJWVYGh2CISJQNsAxek
DdM5VkhQSgkVUEaMgtRyTM1BrUEIQCHATkp4uZd3dSnWcCw5F/JCpnbdaWwBYUQoZHSVnHnLzIqK
uQD5lPlUuLoE5Zw2imQiQCGsWO3ApHs3w8e0+ItRuBD5Wz/0BKWCZ01CZGnOoR4RSFKW77JwB2nI
6O06i87f0xphz0iIQkeNR4mK5NLTSRhrC0cBP56iqUMbebICCCiWfWX1VBoCHhUhRtRmUB8wbm4d
lBbBHtdOSD2xq1CSIn6eNCoJWOiF9EGA+EwChCcNfNlTXtB8DaJl+0SFFKTVTe6wnN9QYF1iIbBL
m1U60ECzeCJyZYkkPsmZlFB8B+L6EgnaSJZeR0PWD0LwsKnuLypaXlhwIKgYiYFcIAemg7TUDXSK
PVsf7KeHFSFOSkoOiHZHYzFP8IEQxhtoSOjmyPU+TMlcqamxFxgQhT5n5GGe1lpF45wcUIFmJIFh
TzwceHH03Cd7caW0B/VPLakoJDIlcwJ2ME6IOo9ZiXM0KpFzWyg+8hYhBGKt8kJmzW+d1EFgNw78
yzCwpkJF+KHm0q9yi2cn+WRg7cHLjsVCWDO/fiCHYhVCDZPqAQyBNIiHpeGNP5QHmB09TxcR3op1
8nnbM5cemmWCIBcInbISBAC/RtIy/GoHL5CyEQtulxg5GWKiRNrCgEavl0nVAsAYUxt+MAPBiLJD
EEoSzoLpMjevhLknnff9Ylymrg+tDwen5XQ+L0CJOZ0iakQpT1dPcI1xNKNNDTQ00NNDTQ00NNXJ
QMKUc2DVWOD0vHdi+hotYYd/EELj83GQxkJ+MpNQIRIIQ9UZNAul0PqQ1Onc8zw+cYgYgGJhImJM
kalzh3tzQCc4u5lLYTnQtkkHxoYYJJPkpMF+QOkHd4ADmpCxCZ0ElAJRDOCF85ChyOvW2WaLdNeZ
rvozSsx4ieZRpwBitrKxeRhDWJdS4kCaw80IerbhrzR+bk2W2/GXOAEn9bJqbggKP4xmpAPIHOyN
e58pYb/2MOV2NcAYwctgTopITIIGfek3rb0tJIlMtZQogijINmehtgJRRl6iMKUVGD2ucVObULoF
zUlKCUEhYUYEQtSRBUgScpHtl4FRpAqXo2CUKSVfS02idML6eaX1/Jt1N/lEdITAK6QGAIZmQTD6
LnyiVPc48UOs8nkkd0DCNEbAY9veSJXj6hNrkJmyr7mq/jPe6nanQ3oqWAZQ/u4KMg+xwJIJBDfx
DSEcSFTlFUmSErleDP+yzq24k/venAU1R9EEuFkIhAJlW9GkKeiklBEQqympIMYsCOOW6SuHRkcL
Do+MgF9Gx39yB7nQ6/aFIRrKSlGYPkAhY4eEcbRPNQ2YbpPoBCKorvvEaUMc1VUQ8XOI62wR0m8U
OboC9HZX6BqhSSDkCQawYFmYe11dyH7kK3tExkgOsELVR6ZkASimDKIlKANRpGCXU4giTfb+uysC
lItBtQZ7BPUAyQifr/jR0fPIPRnQxBYv1Xn8qmTZJbfB/D5Pbh5hqnk8AQgNiP1PVURxTLMB9GuU
oIDRNFFDQSJMR5gQ7wQrrffIDIMGlrKsBZBZIozinnZRbS6yZSLC2kqdwDZj36m8piLtwejrQlmJ
ENuAaAhmjmI6QF1oEx8YHqUuyVC3I/zAaQIUE1C/zWqd7qB88c5X9KndGmZnDWpNFMTNAm1XkVCF
IgVjfq20irECWCwqkar7KWuvaJJSVxAlIRIllKURfQlOs53CWWiDP3tWrwr8aCLXU7wQ3oCHcDCI
QCEACdgId4lAIUghSJIiEgDIChSQiIf5iEIFmCFQSAQqIhMBJgmu7aalMdREyENiTFOgIYghgHZH
vgvBu5COoNRG/GXUGiHPBE3OYA4CVEoKR+xwW9TiVByQoRCYwVQMbfPZjhzGU0llEPIJIkwZnKBY
WDIWXIEIohbIthGy94u0ENwIXAPe7MnD0ehx8stQyJH8EKgCU7wF9qnxwR6zY6JGtUuCSlP56cEP
F5J8OYecfPZgRRLBM8xOYN3lBEEQau2rL1QsFm+zqC1+EntcXFva1CtgCuDtkBOx6AELxEIBMIEQ
3oZkMmoSoT2PI1tIj9QITIIcoORlJTVmmqkopOG2eEtIa4lpCC4OLiAhNBLke1E4aPa6tYMxsH3X
Zjchji3/F3JFOFCQNmlHJQ==


--===============4623601374052273300==--