bk commit into 6.0 tree (chris:1.2653) BUG#31490

[cpowers]

Below is the list of changes that have just been committed into a local
6.0 repository of cpowers. When cpowers does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet@stripped, 2007-10-26 10:21:08-05:00, chris@stripped +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.

  mysql-test/suite/falcon/r/falcon_bug_31490.result@stripped, 2007-10-26 10:20:58-05:00, chris@stripped +53 -0
    DATETIME test case results

  mysql-test/suite/falcon/r/falcon_bug_31490.result@stripped, 2007-10-26 10:20:58-05:00, chris@stripped +0 -0

diff -Nrup a/mysql-test/suite/falcon/r/falcon_bug_31490.result b/mysql-test/suite/falcon/r/falcon_bug_31490.result
--- /dev/null	Wed Dec 31 16:00:00 196900
+++ b/mysql-test/suite/falcon/r/falcon_bug_31490.result	2007-10-26 10:20:58 -05:00
@@ -0,0 +1,53 @@
+SET SQL_MODE = 'traditional';
+CREATE TABLE t1_values
+(
+id BIGINT AUTO_INCREMENT,
+select_id BIGINT,
+my_datetime       DATETIME,
+PRIMARY KEY(id)
+) ENGINE = falcon;
+INSERT INTO t1_values SET my_datetime = '0000-01-01 00:00:00';
+INSERT INTO t1_values SET my_datetime = '0001-01-01 00:00:00';
+INSERT INTO t1_values SET my_datetime = '0099-01-01 00:00:00';
+INSERT INTO t1_values SET my_datetime = '0100-01-01 00:00:00';
+INSERT INTO t1_values SET my_datetime = '0090-01-01 00:00:00';
+INSERT INTO t1_values SET my_datetime = '0069-01-01 00:00:00';
+INSERT INTO t1_values SET my_datetime = '0070-01-01 00:00:00';
+INSERT INTO t1_values SET my_datetime = '0050-01-01 00:00:00';
+INSERT INTO t1_values SET my_datetime = '0071-01-01 00:00:00';
+INSERT INTO t1_values SET my_datetime = '0072-01-01 00:00:00';
+INSERT INTO t1_values SET my_datetime = '0073-01-01 00:00:00';
+INSERT INTO t1_values SET my_datetime = '0074-01-01 00:00:00';
+INSERT INTO t1_values SET my_datetime = '0075-01-01 00:00:00';
+INSERT INTO t1_values SET my_datetime = '0076-01-01 00:00:00';
+INSERT INTO t1_values SET my_datetime = '0077-01-01 00:00:00';
+INSERT INTO t1_values SET my_datetime = '0078-01-01 00:00:00';
+INSERT INTO t1_values SET my_datetime = '0079-01-01 00:00:00';
+INSERT INTO t1_values SET my_datetime = '0060-01-01 00:00:00';
+INSERT INTO t1_values SET my_datetime = '0999-01-01 00:00:00';
+INSERT INTO t1_values SET my_datetime = '0007-01-01 00:00:00';
+INSERT INTO t1_values SET my_datetime = '0008-01-01 00:00:00';
+SELECT * FROM t1_values;
+id	select_id	my_datetime
+1	NULL	0000-01-01 00:00:00
+2	NULL	0001-01-01 00:00:00
+3	NULL	0099-01-01 00:00:00
+4	NULL	0100-01-01 00:00:00
+5	NULL	0090-01-01 00:00:00
+6	NULL	0069-01-01 00:00:00
+7	NULL	0070-01-01 00:00:00
+8	NULL	0050-01-01 00:00:00
+9	NULL	0071-01-01 00:00:00
+10	NULL	0072-01-01 00:00:00
+11	NULL	0073-01-01 00:00:00
+12	NULL	0074-01-01 00:00:00
+13	NULL	0075-01-01 00:00:00
+14	NULL	0076-01-01 00:00:00
+15	NULL	0077-01-01 00:00:00
+16	NULL	0078-01-01 00:00:00
+17	NULL	0079-01-01 00:00:00
+18	NULL	0060-01-01 00:00:00
+19	NULL	0999-01-01 00:00:00
+20	NULL	0007-01-01 00:00:00
+21	NULL	0008-01-01 00:00:00
+DROP TABLE t1_values;