List:Commits« Previous MessageNext Message »
From:Sneha Modi Date:December 20 2011 1:53pm
Subject:bzr push into mysql-trunk branch (sneha.modi:3677 to 3678) Bug#6857
Bug#11754150
View as plain text  
 3678 Sneha Modi	2011-12-20
      Bug#11754150:  A TEST CASE FOR BUG#6857 IS DISABLED IN SP.TEST
      
      current_time() truncates the time value when stored as int variable in mysql-5.5 as cmpared to mysql-trunk.
      Using unix_timestamp() instead of current_time().

    modified:
      mysql-test/r/sp.result
      mysql-test/t/sp.test
 3677 Sneha Modi	2011-12-20
      Bug#11754150:  A TEST CASE FOR BUG#6857 IS DISABLED IN SP.TEST
      
      This part has been enabled and the data-type for variables t0 and t1 in this part of the code has been 
      changed from int to time.

    modified:
      mysql-test/r/sp.result
      mysql-test/t/sp.test
=== modified file 'mysql-test/r/sp.result'
--- a/mysql-test/r/sp.result	2011-12-20 10:16:03 +0000
+++ b/mysql-test/r/sp.result	2011-12-20 13:52:25 +0000
@@ -2726,13 +2726,13 @@ drop table t3|
 drop procedure if exists bug6857|
 create procedure bug6857(counter int)
 begin
-declare t0, t1 time;
+declare t0, t1 int;
 declare plus bool default 0;
-set t0 = current_time();
+set t0 = unix_timestamp();
 while counter > 0 do
 set counter = counter - 1;
 end while;
-set t1 = current_time();
+set t1 = unix_timestamp();
 if t1 > t0 then
 set plus = 1;
 end if;

=== modified file 'mysql-test/t/sp.test'
--- a/mysql-test/t/sp.test	2011-12-20 10:16:03 +0000
+++ b/mysql-test/t/sp.test	2011-12-20 13:52:25 +0000
@@ -3194,14 +3194,14 @@ drop table t3|
 drop procedure if exists bug6857|
 create procedure bug6857(counter int)
 begin
-  declare t0, t1 time;
+  declare t0, t1 int;
   declare plus bool default 0;
 
-  set t0 = current_time();
+  set t0 = unix_timestamp();
   while counter > 0 do
     set counter = counter - 1;
   end while;
-  set t1 = current_time();
+  set t1 = unix_timestamp();
   if t1 > t0 then
     set plus = 1;
   end if;

No bundle (reason: useless for push emails).
Thread
bzr push into mysql-trunk branch (sneha.modi:3677 to 3678) Bug#6857Bug#11754150Sneha Modi21 Dec