bk commit into 6.0 tree (chris:1.2654) 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:23:31-05:00, chris@stripped +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.

  mysql-test/suite/falcon/r/falcon_bug_31490.result@stripped, 2007-10-26 10:23:29-05:00, chris@stripped +1 -0
    DATETIME test results

  mysql-test/suite/falcon/t/falcon_bug_31490.test@stripped, 2007-10-26 10:23:29-05:00, chris@stripped +33 -0
    Added DATETIME test cases to Falcon suite.

  mysql-test/suite/falcon/t/falcon_bug_31490.test@stripped, 2007-10-26 10:23:29-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
--- a/mysql-test/suite/falcon/r/falcon_bug_31490.result	2007-10-26 10:20:58 -05:00
+++ b/mysql-test/suite/falcon/r/falcon_bug_31490.result	2007-10-26 10:23:29 -05:00
@@ -51,3 +51,4 @@ id	select_id	my_datetime
 20	NULL	0007-01-01 00:00:00
 21	NULL	0008-01-01 00:00:00
 DROP TABLE t1_values;
+
diff -Nrup a/mysql-test/suite/falcon/t/falcon_bug_31490.test b/mysql-test/suite/falcon/t/falcon_bug_31490.test
--- /dev/null	Wed Dec 31 16:00:00 196900
+++ b/mysql-test/suite/falcon/t/falcon_bug_31490.test	2007-10-26 10:23:29 -05:00
@@ -0,0 +1,33 @@
+--source include/have_falcon.inc
+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;
+DROP TABLE t1_values;
+