From: Date: March 2 2006 5:07pm
Subject: bk commit into 5.0 tree (gluh:1.2090) BUG#17826
List-Archive: http://lists.mysql.com/commits/3393
X-Bug: 17826
Message-Id: <20060302160750.3C25D5288D9@eagle.intranet.mysql.r18.ru>

Below is the list of changes that have just been committed into a local
5.0 repository of gluh. When gluh 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.2090 06/03/02 20:07:39 gluh@stripped +3 -0
  Fix for bug#17826 'type_decimal' fails with ps-protocol
   removed unnecessary calculation of cache value 
   otherwise Join::preapre tries to calculate 
   undefined values(filed values) 

  sql/item_cmpfunc.cc
    1.192 06/03/02 20:07:33 gluh@stripped +0 -6
    Fix for bug#17826 'type_decimal' fails with ps-protocol
     removed unnecessary calculation of cache value 
     otherwise Join::preapre tries to calculate 
     undefined values(filed values) 

  mysql-test/t/type_decimal.test
    1.31 06/03/02 20:07:33 gluh@stripped +8 -0
    Fix for bug#17826 'type_decimal' fails with ps-protocol
     test case

  mysql-test/r/type_decimal.result
    1.41 06/03/02 20:07:33 gluh@stripped +7 -0
    Fix for bug#17826 'type_decimal' fails with ps-protocol
     test case

# 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:	gluh
# Host:	eagle.intranet.mysql.r18.ru
# Root:	/home/gluh/MySQL/Bugs/5.0.17602

--- 1.191/sql/item_cmpfunc.cc	Tue Feb 14 16:21:59 2006
+++ 1.192/sql/item_cmpfunc.cc	Thu Mar  2 20:07:33 2006
@@ -697,12 +697,6 @@ bool Item_in_optimizer::fix_left(THD *th
     return 1;
 
   cache->setup(args[0]);
-  /*
-    If it is preparation PS only then we do not know values of parameters =>
-    cant't get there values and do not need that values.
-  */
-  if (!thd->stmt_arena->is_stmt_prepare())
-    cache->store(args[0]);
   if (cache->cols() == 1)
   {
     if ((used_tables_cache= args[0]->used_tables()))

--- 1.40/mysql-test/r/type_decimal.result	Tue Jan 17 22:10:41 2006
+++ 1.41/mysql-test/r/type_decimal.result	Thu Mar  2 20:07:33 2006
@@ -772,3 +772,10 @@ productid	zlevelprice
 003trans	39.98
 004trans	31.18
 drop table t1, t2;
+create table t1 (f1 decimal(5));
+insert into t1 values (40);
+flush tables;
+select f1 from t1 where f1 in (select f1 from t1);
+f1
+40
+drop table t1;

--- 1.30/mysql-test/t/type_decimal.test	Tue Jan 17 22:10:41 2006
+++ 1.31/mysql-test/t/type_decimal.test	Thu Mar  2 20:07:33 2006
@@ -377,3 +377,11 @@ insert INTO t2 SELECT * FROM t1;
 select * from t2; 
 drop table t1, t2;
 
+#
+# Bug #17826 'type_decimal' fails with ps-protocol
+#
+create table t1 (f1 decimal(5));
+insert into t1 values (40);
+flush tables;
+select f1 from t1 where f1 in (select f1 from t1);
+drop table t1;