diff options
| author | Magne Mahre <magne.mahre@sun.com> | 2009-11-04 10:17:39 +0100 |
|---|---|---|
| committer | Magne Mahre <magne.mahre@sun.com> | 2009-11-04 10:17:39 +0100 |
| commit | 6f5418515fb479ea2a2537d454f8938052a947ed (patch) | |
| tree | cb93480c9817f196d03df0f95357afc99be8aaad /mysql-test/r/func_sapdb.result | |
| parent | 9c5a86377ad8b5a0fad6eca809bc432c93ed14ba (diff) | |
| parent | 2e17ce5db3f974a8bc20f6880cba85ce0f0354f8 (diff) | |
| download | mariadb-git-6f5418515fb479ea2a2537d454f8938052a947ed.tar.gz | |
Backport to 5.6.0
Diffstat (limited to 'mysql-test/r/func_sapdb.result')
| -rw-r--r-- | mysql-test/r/func_sapdb.result | 32 |
1 files changed, 16 insertions, 16 deletions
diff --git a/mysql-test/r/func_sapdb.result b/mysql-test/r/func_sapdb.result index 831c2899f66..2d6154cd1f7 100644 --- a/mysql-test/r/func_sapdb.result +++ b/mysql-test/r/func_sapdb.result @@ -282,33 +282,33 @@ TIMEDIFF(TIME('17:59:00'),TIME('17:00:00')), TIMEDIFF(TIME('17:00:00'),TIME('17:59:00')); 1Eq 1NEq1 1NEq2 2Eq 2NEq1 2NEq2 3Eq 3NEq1 3NEq2 Time0 Time00 Literal0000 TIMEDIFF(TIME('17:59:00'),TIME('17:00:00')) TIMEDIFF(TIME('17:00:00'),TIME('17:59:00')) 1 0 0 1 0 0 1 0 0 00:00:00 00:00:00 00:00:00 00:59:00 -00:59:00 -SELECT sec_to_time(3020399)=time('838:59:59'); -sec_to_time(3020399)=time('838:59:59') +SELECT sec_to_time(3020399)=TIME('838:59:59'); +sec_to_time(3020399)=TIME('838:59:59') 1 -SELECT sec_to_time(-3020399)=time('-838:59:59'); -sec_to_time(-3020399)=time('-838:59:59') +SELECT sec_to_time(-3020399)=TIME('-838:59:59'); +sec_to_time(-3020399)=TIME('-838:59:59') 1 SELECT sec_to_time(-3020399)='-838:59:59'; sec_to_time(-3020399)='-838:59:59' 1 -SELECT time(sec_to_time(-3020399))=time('-838:59:59'); -time(sec_to_time(-3020399))=time('-838:59:59') +SELECT time(sec_to_time(-3020399))=TIME('-838:59:59'); +time(sec_to_time(-3020399))=TIME('-838:59:59') 1 -SELECT time(sec_to_time(-3020399))=time('-838:59:58'); -time(sec_to_time(-3020399))=time('-838:59:58') +SELECT time(sec_to_time(-3020399))=TIME('-838:59:58'); +time(sec_to_time(-3020399))=TIME('-838:59:58') 0 SELECT maketime(-1,0,1)='-01:00:01'; maketime(-1,0,1)='-01:00:01' 1 -SELECT TIME(maketime(-1,0,1))=TIME('-01:00:01'); -TIME(maketime(-1,0,1))=TIME('-01:00:01') +SELECT TIME(maketime(-1,0,1))=CAST('-01:00:01' AS TIME); +TIME(maketime(-1,0,1))=CAST('-01:00:01' AS TIME) 1 -SELECT maketime(-1,0,1)=TIME('-01:00:01'); -maketime(-1,0,1)=TIME('-01:00:01') +SELECT maketime(-1,0,1)=CAST('-01:00:01' AS TIME); +maketime(-1,0,1)=CAST('-01:00:01' AS TIME) 1 -SELECT maketime(1,0,1)=TIME('01:00:01'); -maketime(1,0,1)=TIME('01:00:01') +SELECT maketime(1,0,1)=CAST('01:00:01' AS TIME); +maketime(1,0,1)=CAST('01:00:01' AS TIME) 1 -SELECT maketime(1,0,1)=TIME('01:00:02'); -maketime(1,0,1)=TIME('01:00:02') +SELECT maketime(1,0,1)=CAST('01:00:02' AS TIME); +maketime(1,0,1)=CAST('01:00:02' AS TIME) 0 |