Bug #25601 Missing m4 macro MYSQL_CHECK_TIME_T
Submitted: 12 Jan 2007 23:14 Modified: 12 Apr 2007 17:59
Reporter: Monty Taylor Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Compiling Severity:S3 (Non-critical)
Version:5.0,5.1 OS:Linux (Linux)
Assigned to: Daniel Fischer CPU Architecture:Any

[12 Jan 2007 23:14] Monty Taylor 
Description:
When building mysql 5.1.14, an error during ./configure about not having MYSQL_CHECK_TIME_T scrolls by. Upon checking, it doesn't appear to be defined anywhere. Nothing really seems to break, though ... maybe it's just cruft? 

How to repeat:
Run ./configure and watch the output. 

Suggested fix:
Define MYSQL_CHECK_TIME_T
[15 Jan 2007 10:11] Sveta Smirnova 
Thank you for the report.

Did you run autotools (BUILD/autorun.sh script) before running configure?
[16 Feb 2007 0:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[8 Mar 2007 11:39] Monty Taylor 
Yes. I ran autorun.sh and it still gives the error. 

./configure: line 33117: MYSQL_CHECK_TIME_T: command not found

I looked all through the source and can find no mention of the macro. Old cruft?
[9 Mar 2007 9:02] Daniel Fischer 
In 4.0 and 4.1, this macro is present and was likely incorrectly merged up to 5.0 and above. The lack of the MYSQL_CHECK_TIME_T macro in 5.0/5.1 likely only has the adverse effect that in MySQL running on QNX in the system time zone America/Mazatlan or America/Hermosillo, conversion between MySQL and UNIX timestamps very close to 1970-01-01 will be off a bit. Other platforms where time_t is unsigned are similarily affected, however the only supported platform where it is unsigned is QNX.
[9 Mar 2007 9:20] 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/21561

ChangeSet@1.2436, 2007-03-09 10:17:21+01:00, df@pippilotta.erinye.com +1 -0
  BUG#25601 Missing m4 macro MYSQL_CHECK_TIME_T
[3 Apr 2007 18:10] Vladimir Michl 
It looks like that this bug is still present in MySQL 5.0.38 Enterprise Commercial.
[12 Apr 2007 17:52] Bugs System 
Pushed into 5.1.18-beta
[12 Apr 2007 17:53] Bugs System 
Pushed into 5.0.40
[12 Apr 2007 17:59] Paul DuBois 
No changelog entry needed.