bk commit into 5.1 tree (sergefp:1.2281)

[Sergey Petrunia]

Below is the list of changes that have just been committed into a local
5.1 repository of psergey. When psergey does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet
  1.2281 06/04/04 15:58:59 sergefp@stripped +4 -0
  Merge spetrunia@stripped:/home/bk/mysql-5.1-new
  into mysql.com:/home/psergey/mysql-5.1-bug18558-pnd

  sql/sql_partition.cc
    1.64 06/04/04 15:58:57 sergefp@stripped +0 -1
    Auto merged

  sql/opt_range.cc
    1.210 06/04/04 15:58:57 sergefp@stripped +0 -1
    Auto merged

  mysql-test/t/partition_pruning.test
    1.10 06/04/04 15:58:57 sergefp@stripped +0 -32
    Auto merged

  mysql-test/r/partition_pruning.result
    1.11 06/04/04 15:58:57 sergefp@stripped +0 -38
    Auto merged

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	sergefp
# Host:	newbox.mylan
# Root:	/home/psergey/mysql-5.1-bug18558-pnd/RESYNC

--- 1.10/mysql-test/r/partition_pruning.result	2006-03-31 03:45:06 +04:00
+++ 1.11/mysql-test/r/partition_pruning.result	2006-04-04 15:58:57 +04:00
@@ -583,3 +583,17 @@
 id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	p1,p2,p3,p4,p5	ALL	NULL	NULL	NULL	NULL	5	Using where
 drop table t1;
+create table t1 (f_int1 integer) partition by list(abs(mod(f_int1,2)))
+subpartition by hash(f_int1) subpartitions 2
+(
+partition part1 values in (0),
+partition part2 values in (1),
+partition part4 values in (null)
+);
+insert into t1 set f_int1 = null;
+select * from t1 where f_int1 is null;
+f_int1
+NULL
+explain partitions select * from t1 where f_int1 is null;
+id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	part4_p2sp0	system	NULL	NULL	NULL	NULL	1	

--- 1.9/mysql-test/t/partition_pruning.test	2006-03-31 03:45:06 +04:00
+++ 1.10/mysql-test/t/partition_pruning.test	2006-04-04 15:58:57 +04:00
@@ -479,5 +479,19 @@
 explain partitions select * from t1 where a>='a' and a <= 'dddd';
 drop table t1;
 
+# BUG#18659: Assertion failure when subpartitioning is used and partition is
+# "IS NULL"
+create table t1 (f_int1 integer) partition by list(abs(mod(f_int1,2)))
+  subpartition by hash(f_int1) subpartitions 2
+(
+  partition part1 values in (0),
+  partition part2 values in (1),
+  partition part4 values in (null)
+);
+insert into t1 set f_int1 = null;
+
+select * from t1 where f_int1 is null;
+explain partitions select * from t1 where f_int1 is null;
+
 # No tests for NULLs in RANGE(monotonic_expr()) - they depend on BUG#15447
 # being fixed.