Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
None
-
None
-
None
-
Windows, Debug, 32 bit, compiled with VS2015
Description
Here is the output of func_time test
perl mysql-test-run.pl func_time --ps-protocol
There are 2 problems in this output:
1. Junk after a string
-02:30:01.100000 838:59:59.999999
+02:30:01.100000 838:59:59.999999ýýýý
2.Extraneous trailing zeros in fraction part, which are not present in mysqlclient
-2005-05-04 1970-01-01 02:33:25 19700101023325.000000
-2000-02-23 1970-01-01 02:33:20 19700101023320.000000
+2005-05-04 1970-01-01 02:33:25.000000 19700101023325.000000
+2000-02-23 1970-01-01 02:33:20.000000 19700101023320.000000
The output of the test follows.
CURRENT_TEST: main.func_time
— D:/work/server/mysql-test/r/func_time.result 2016-06-02 13:06:36.110880600 +0000
+++ D:\work\server\mysql-test\r\func_time.reject 2016-06-02 16:20:20.027071200 +0000
@@ -33,7 +33,7 @@
-02:30:01.1 -23001.10000 -23001.1 -23001
select sec_to_time(90011e-1), sec_to_time(1234567890123e30);
sec_to_time(90011e-1) sec_to_time(1234567890123e30)
-02:30:01.100000 838:59:59.999999
+02:30:01.100000 838:59:59.999999ýýýý
Warnings:
Warning 1292 Truncated incorrect time value: '1.234567890123e42'
select sec_to_time(1234567890123), sec_to_time('99999999999999999999999999999');
@@ -2106,8 +2106,8 @@
INSERT INTO t1 VALUES ('2005-05-04'),('2000-02-23');
SELECT a, FROM_UNIXTIME(CONCAT(a,'10')) AS f1, FROM_UNIXTIME(CONCAT(a,'10'))+0 AS f2 FROM t1;
a f1 f2
-2005-05-04 1970-01-01 02:33:25 19700101023325.000000
-2000-02-23 1970-01-01 02:33:20 19700101023320.000000
+2005-05-04 1970-01-01 02:33:25.000000 19700101023325.000000
+2000-02-23 1970-01-01 02:33:20.000000 19700101023320.000000
Attachments
Issue Links
- blocks
-
MDEV-9293 change clients to use Connector/C
- Closed