Bug #31490 The funcs_1 test "falcon_func_view" fails due to differences in a datetime col

Description:
The value "0001-01-01 00:00:00" was changed to "2001-01-01 00:00:00" for a column of type datetime. Further tesimg shows that the range for year from 0070 to 0099 is changed to 1970 to 1999, the range from 0000 to 0069 is changed to 2000 to 2069. 
If that behaviour is desired, then a switch is necessary to have a possibility to use the ranges about without changing them and it must be described in the manual.

How to repeat:
put the attached test into "mysql-test/t" and execute
./mysql-test-run.pl --bug

Thank you for the bug report.

This is a duplicate of Bug#22168

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/36439

ChangeSet@1.2653, 2007-10-26 10:21:08-05:00, chris@xeno.mysql.com +1 -0
  Bug#31490 "The funcs_1 test falcon_func_view fails due to differences in a datetime col"
  
  Added DATETIME testcase to Falcon suite.

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/36440

ChangeSet@1.2654, 2007-10-26 10:23:31-05:00, chris@xeno.mysql.com +2 -0
  Bug#31490 "The funcs_1 test falcon_func_view fails due to differences in a datetime col"
  
  Added DATETIME test to Falcon suite.

Testcase succeeds. Added testcase as falcon_bug_31490.test to Falcon suite.

Test passes now:

TEST                           RESULT         TIME (ms)
-------------------------------------------------------

falcon.falcon_bug_31490        [ pass ]            173
-------------------------------------------------------
Stopping All Servers
All 1 tests were successful.
The servers were restarted 1 times
Spent 0.173 of 6 seconds executing testcases

Pushed into 6.0.4-alpha

A note has been added to the 6.0.4 changelog: 

When inserting dates into a DATETIME column with a Falcon, the values would automatically be converted with values between 70 and 99 converted to 1970-1999, and values from 00 to 69 converted to 2000 to 2069.