Bug #20496 func_time.test failure
Submitted: 16 Jun 2006 9:33 Modified: 21 Jun 2006 4:57
Reporter: Ramil Kalimullin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S7 (Test Cases)
Version:4.1 OS:Other (QNX)
Assigned to: Ramil Kalimullin CPU Architecture:Any

[16 Jun 2006 9:33] Ramil Kalimullin 
Description:
-------------------------------------------------------
*** r/func_time.result	Thu Jun 15 23:27:12 2006
--- r/func_time.reject	Thu Jun 15 23:57:01 2006
***************
*** 754,760 ****
  select now() - now() + 0, curtime() - curtime() + 0, 
  sec_to_time(1) + 0, from_unixtime(1) + 0;
  now() - now() + 0	curtime() - curtime() + 0	sec_to_time(1) + 0	from_unixtime(1) + 0
! 0.000000	0.000000	1.000000	19700101030001.000000
  explain extended select timestampdiff(SQL_TSI_WEEK, '2001-02-01', '2001-05-01') as a1,
  timestampdiff(SQL_TSI_FRAC_SECOND, '2001-02-01 12:59:59.120000', '2001-05-01 12:58:58.119999') as a2;
  id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
--- 754,760 ----
  select now() - now() + 0, curtime() - curtime() + 0, 
  sec_to_time(1) + 0, from_unixtime(1) + 0;
  now() - now() + 0	curtime() - curtime() + 0	sec_to_time(1) + 0	from_unixtime(1) + 0
! 0.000000	0.000000	1.000000	19700101030000.999999
  explain extended select timestampdiff(SQL_TSI_WEEK, '2001-02-01', '2001-05-01') as a1,
  timestampdiff(SQL_TSI_FRAC_SECOND, '2001-02-01 12:59:59.120000', '2001-05-01 12:58:58.119999') as a2;
  id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-------------------------------------------------------

How to repeat:
ran the test on QNX
[19 Jun 2006 5:55] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/7823
[19 Jun 2006 8:00] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/7826
[20 Jun 2006 11:14] Ramil Kalimullin 
fixed in 4.1.21
[21 Jun 2006 4:57] Paul DuBois 
Changes to test case only.
No changelog entry needed.