Test main.type_temporal_fractional is unstable

[Laurynas Biveinis]

On 5.6 trunk:

main.type_temporal_fractional w1 [ fail ]
        Test ended at 2017-03-14 09:45:32

CURRENT_TEST: main.type_temporal_fractional
--- /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/ubuntu-precise-64bit/mysql-test/r/type_temporal_fractional.result 2017-03-08 15:06:33.345662559 +0300
+++ /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/ubuntu-precise-64bit/build/mysql-test/var/1/log/type_temporal_fractional.reject 2017-03-14 16:45:32.192047323 +0300
@@ -15911,6 +15911,7 @@
 WHERE col_time_2_not_null = GREATEST(CURRENT_DATE(),col_timestamp_6_key)
 ORDER BY 1;
 c1
[phone]:45:31.47000
 DROP TABLE t1;
 SET @@time_zone='+00:00';
 CREATE TABLE t1 (col_datetime_4_not_null DATETIME(4) NOT NULL);

mysqltest: Result content mismatch

[Laurynas Biveinis (laurynas-biveinis)]

Added asserts and confirmed that the failure happens when CURRENT_TIMESTAMP at INSERT time happens to have four trailing zeroes in microseconds, comparing equal to TIME(2) column.

[Laurynas Biveinis (laurynas-biveinis)]

     https://github.com/percona/percona-server/pull/1666
     https://github.com/percona/percona-server/pull/1667

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2247