MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:Alexey Kopytov Date:February 14 2009 3:58pm
Subject:bzr commit into mysql-5.0-bugteam branch (Alexey.Kopytov:2746)
Bug#21205
View as plain text  
#At file:///Users/kaa/src/bzr/mysql-5.0-bugteam/ based on revid:alexey.kopytov@stripped

 2746 Alexey Kopytov	2009-02-14
      Fixed several test failures in the funcs_1 suite introduced by the patch for bug #21205.
modified:
  mysql-test/suite/funcs_1/r/memory_func_view.result
  mysql-test/suite/funcs_1/r/memory_views.result
  mysql-test/suite/funcs_1/r/myisam_func_view.result
  mysql-test/suite/funcs_1/r/myisam_views.result

per-file messages:
  mysql-test/suite/funcs_1/r/memory_func_view.result
    Take additional precision into account.
  mysql-test/suite/funcs_1/r/memory_views.result
    Take additional precision into account.
  mysql-test/suite/funcs_1/r/myisam_func_view.result
    Take additional precision into account.
  mysql-test/suite/funcs_1/r/myisam_views.result
    Take additional precision into account.
=== modified file 'mysql-test/suite/funcs_1/r/memory_func_view.result'
--- a/mysql-test/suite/funcs_1/r/memory_func_view.result	2008-05-13 13:46:38 +0000
+++ b/mysql-test/suite/funcs_1/r/memory_func_view.result	2009-02-14 15:58:07 +0000
@@ -5245,7 +5245,7 @@ WHERE select_id = 1 OR select_id IS NULL
 sqrt(my_bigint)	my_bigint	id
 NULL	NULL	1
 NULL	-9223372036854775808	2
-3037000499.976	9223372036854775807	3
+3037000499.97605	9223372036854775807	3
 0	0	4
 NULL	-1	5
 2	4	6
@@ -5259,7 +5259,7 @@ WHERE select_id = 1 OR select_id IS NULL
 sqrt(my_bigint)	my_bigint	id
 NULL	NULL	1
 NULL	-9223372036854775808	2
-3037000499.976	9223372036854775807	3
+3037000499.97605	9223372036854775807	3
 0	0	4
 NULL	-1	5
 2	4	6

=== modified file 'mysql-test/suite/funcs_1/r/memory_views.result'
--- a/mysql-test/suite/funcs_1/r/memory_views.result	2008-05-13 13:46:38 +0000
+++ b/mysql-test/suite/funcs_1/r/memory_views.result	2009-02-14 15:58:07 +0000
@@ -22825,7 +22825,7 @@ f1	f2
 ABC	3
 SELECT * FROM v1 order by 2;
 f1	my_sqrt
-ABC	1.7320508075689
+ABC	1.73205080756888
 ALTER TABLE t1 CHANGE COLUMN f2 f2 VARCHAR(30);
 INSERT INTO t1   SET f1 = 'ABC', f2 = 'DEF';
 DESCRIBE t1;
@@ -22843,7 +22843,7 @@ ABC	DEF
 SELECT * FROM v1 order by 2;
 f1	my_sqrt
 ABC	0
-ABC	1.7320508075689
+ABC	1.73205080756888
 SELECT SQRT('DEF');
 SQRT('DEF')
 0
@@ -22863,7 +22863,7 @@ my_sqrt	double	YES		NULL	
 SELECT * FROM v2 order by 2;
 f1	my_sqrt
 ABC	0
-ABC	1.7320508075689
+ABC	1.73205080756888
 CREATE TABLE t2 AS SELECT f1, SQRT(f2) my_sqrt FROM t1;
 SELECT * FROM t2 order by 2;
 f1	ABC

=== modified file 'mysql-test/suite/funcs_1/r/myisam_func_view.result'
--- a/mysql-test/suite/funcs_1/r/myisam_func_view.result	2008-05-13 13:46:38 +0000
+++ b/mysql-test/suite/funcs_1/r/myisam_func_view.result	2009-02-14 15:58:07 +0000
@@ -5245,7 +5245,7 @@ WHERE select_id = 1 OR select_id IS NULL
 sqrt(my_bigint)	my_bigint	id
 NULL	NULL	1
 NULL	-9223372036854775808	2
-3037000499.976	9223372036854775807	3
+3037000499.97605	9223372036854775807	3
 0	0	4
 NULL	-1	5
 2	4	6
@@ -5259,7 +5259,7 @@ WHERE select_id = 1 OR select_id IS NULL
 sqrt(my_bigint)	my_bigint	id
 NULL	NULL	1
 NULL	-9223372036854775808	2
-3037000499.976	9223372036854775807	3
+3037000499.97605	9223372036854775807	3
 0	0	4
 NULL	-1	5
 2	4	6

=== modified file 'mysql-test/suite/funcs_1/r/myisam_views.result'
--- a/mysql-test/suite/funcs_1/r/myisam_views.result	2008-05-13 13:46:38 +0000
+++ b/mysql-test/suite/funcs_1/r/myisam_views.result	2009-02-14 15:58:07 +0000
@@ -24527,7 +24527,7 @@ f1	f2
 ABC	3
 SELECT * FROM v1 order by 2;
 f1	my_sqrt
-ABC	1.7320508075689
+ABC	1.73205080756888
 ALTER TABLE t1 CHANGE COLUMN f2 f2 VARCHAR(30);
 INSERT INTO t1   SET f1 = 'ABC', f2 = 'DEF';
 DESCRIBE t1;
@@ -24545,7 +24545,7 @@ ABC	DEF
 SELECT * FROM v1 order by 2;
 f1	my_sqrt
 ABC	0
-ABC	1.7320508075689
+ABC	1.73205080756888
 SELECT SQRT('DEF');
 SQRT('DEF')
 0
@@ -24565,7 +24565,7 @@ my_sqrt	double	YES		NULL	
 SELECT * FROM v2 order by 2;
 f1	my_sqrt
 ABC	0
-ABC	1.7320508075689
+ABC	1.73205080756888
 CREATE TABLE t2 AS SELECT f1, SQRT(f2) my_sqrt FROM t1;
 SELECT * FROM t2 order by 2;
 f1	ABC

Thread
bzr commit into mysql-5.0-bugteam branch (Alexey.Kopytov:2746)Bug#21205Alexey Kopytov14 Feb