bzr commit into mysql-5.0-bugteam branch (holyfoot:2722) Bug#39049

[Alexey Botchkov]

#At file:///home/hf/work/mysql_common/39049/

 2722 Alexey Botchkov	2008-12-10
      Bug#39049      Wrong warning when comparing some decimal values to NULL
      
      per-file messages:
        mysql-test/r/type_newdecimal.result
      Bug#39049      Wrong warning when comparing some decimal values to NULL
              test result
        mysql-test/t/type_newdecimal.test
      Bug#39049      Wrong warning when comparing some decimal values to NULL
              test case
modified:
  mysql-test/r/type_newdecimal.result
  mysql-test/t/type_newdecimal.test

=== modified file 'mysql-test/r/type_newdecimal.result'
--- a/mysql-test/r/type_newdecimal.result	2008-11-17 15:41:09 +0000
+++ b/mysql-test/r/type_newdecimal.result	2008-12-10 11:20:03 +0000
@@ -1539,4 +1539,10 @@ select * from t1;
 5.05 / 0.014
 360.714286
 DROP TABLE t1;
+create table t1 (d decimal(20,2));
+insert into t1 values (9999999999999999.9);
+select (d*d) is null from t1;
+(d*d) is null
+0
+drop table t1;
 End of 5.0 tests

=== modified file 'mysql-test/t/type_newdecimal.test'
--- a/mysql-test/t/type_newdecimal.test	2008-11-17 15:41:09 +0000
+++ b/mysql-test/t/type_newdecimal.test	2008-12-10 11:20:03 +0000
@@ -1235,4 +1235,13 @@ show create table t1;
 select * from t1;
 DROP TABLE t1;
 
+#
+# Bug #39049    Wrong warning when comparing some decimal values to NULL
+#
+
+create table t1 (d decimal(20,2));
+insert into t1 values (9999999999999999.9);
+select (d*d) is null from t1;
+drop table t1;
+
 --echo End of 5.0 tests