microtime_type.max [ fail ]
drizzletest: At line 6: query 'INSERT into t2 VALUES ("20660101000000.00000")' failed: 1685: Received an invalid value '20660101000000.00000' for a UNIX timestamp.
The result from queries just before the failure was:
CREATE TABLE t2 (
_value TIMESTAMP(6)
);
INSERT into t2 VALUES ("20660101000000.00000");
Getting test failures - regression.592690 microtime_ type.decimal microtime_type.max
--- .././tests/ suite/microtime _type/r/ decimal. result 2011-01-14 05:58:28.446261000 +0300 suite/microtime _type/r/ decimal. reject 2011-01-14 21:34:44.103791539 +0300
+++ .././tests/
@@ -14,6 +14,6 @@
SELECT _value FROM t2;
_value
2003-01-01 00:00:00.000000
-2003-01-01 00:00:00.125000
-2003-01-01 00:00:00.898437
+2003-01-01 00:00:00.123456
+2003-01-01 00:00:00.900000
DROP TABLE t1,t2;
microtime_type.max [ fail ] 0.00000" )' failed: 1685: Received an invalid value '20660101000000 .00000' for a UNIX timestamp.
drizzletest: At line 6: query 'INSERT into t2 VALUES ("2066010100000
The result from queries just before the failure was: 0.00000" );
CREATE TABLE t2 (
_value TIMESTAMP(6)
);
INSERT into t2 VALUES ("2066010100000
mysql_compatibi lity.zerofill [ pass ] 2 suite/regressio n/r/592690. result 2011-01-14 05:58:28.446261000 +0300 suite/regressio n/r/592690. reject 2011-01-14 21:34:30.083175783 +0300 1272945599. 90000), from_unixtime( 1272945599) , from_unixtime( "1272945599. 90000") ; 1272945599. 90000) from_unixtime( 1272945599) from_unixtime( "1272945599. 90000")
regression.592690 [ fail ]
--- .././tests/
+++ .././tests/
@@ -1,3 +1,5 @@
select from_unixtime(
from_unixtime(
-2010-05-04 03:59:59.900000 2010-05-04 03:59:59 2010-05-04 03:59:59.900000
+2010-05-04 04:00:00 2010-05-04 03:59:59 2010-05-04 03:59:59
+Warnings:
+Warning 1292 Truncated incorrect INTEGER value: '1272945599.90000'
microtime_ type.decimal [ fail ] suite/microtime _type/r/ decimal. result 2011-01-14 05:58:28.446261000 +0300 suite/microtime _type/r/ decimal. reject 2011-01-14 21:34:44.103791539 +0300
--- .././tests/
+++ .././tests/
@@ -14,6 +14,6 @@
SELECT _value FROM t2;
_value
2003-01-01 00:00:00.000000
-2003-01-01 00:00:00.125000
-2003-01-01 00:00:00.898437
+2003-01-01 00:00:00.123456
+2003-01-01 00:00:00.900000
DROP TABLE t1,t2;