mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 02:46:29 +01:00
647d5b2430
typo. system_time.start wasn't updated when system_time.sec and system_time.sec_part were.
16 lines
804 B
Text
16 lines
804 B
Text
set @old_dbug=@@debug_dbug;
|
|
select timestampdiff(minute,now(),sysdate()) as 'must be 0', (unix_timestamp(sysdate()) - unix_timestamp()) div 60 as 'must be 0';
|
|
must be 0 must be 0
|
|
0 0
|
|
set @@debug_dbug='+d,system_time_plus_one_hour';
|
|
select timestampdiff(minute,now(),sysdate()) as 'must be 0', (unix_timestamp(sysdate()) - unix_timestamp()) div 60 as 'must be 0';
|
|
must be 0 must be 0
|
|
0 0
|
|
set @@debug_dbug='+d,system_time_minus_one_hour:-d,system_time_plus_one_hour';
|
|
select timestampdiff(minute,now(),sysdate()) as 'must be 0', (unix_timestamp(sysdate()) - unix_timestamp()) div 60 as 'must be 0';
|
|
must be 0 must be 0
|
|
0 0
|
|
set @@debug_dbug=@old_dbug;
|
|
select timestampdiff(minute,now(),sysdate()) as 'must be 0', (unix_timestamp(sysdate()) - unix_timestamp()) div 60 as 'must be 0';
|
|
must be 0 must be 0
|
|
0 0
|