720
Warning 1287 The syntax 'FRAC_SECOND' is deprecated and will be removed in MySQL 6.2. Please use MICROSECOND instead
720
Warning 1287 'FRAC_SECOND' is deprecated and will be removed in a future release. Please use MICROSECOND instead
721
721
select timestampdiff(SQL_TSI_DAY, '1986-02-01', '1986-03-01') as a1,
722
722
timestampdiff(SQL_TSI_DAY, '1900-02-01', '1900-03-01') as a2,
723
723
timestampdiff(SQL_TSI_DAY, '1996-02-01', '1996-03-01') as a3,
1088
1088
id select_type table type possible_keys key key_len ref rows filtered Extra
1089
1089
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used
1091
Warning 1287 The syntax 'FRAC_SECOND' is deprecated and will be removed in MySQL 6.2. Please use MICROSECOND instead
1091
Warning 1287 'FRAC_SECOND' is deprecated and will be removed in a future release. Please use MICROSECOND instead
1092
1092
Note 1003 select timestampdiff(WEEK,'2001-02-01','2001-05-01') AS `a1`,timestampdiff(SECOND_FRAC,'2001-02-01 12:59:59.120000','2001-05-01 12:58:58.119999') AS `a2`
1093
1093
select time_format('100:00:00', '%H %k %h %I %l');
1094
1094
time_format('100:00:00', '%H %k %h %I %l')
1287
1287
TIMESTAMPADD(FRAC_SECOND, 1, '2008-02-18')
1288
1288
2008-02-18 00:00:00.000001
1290
Warning 1287 The syntax 'FRAC_SECOND' is deprecated and will be removed in MySQL 6.2. Please use MICROSECOND instead
1290
Warning 1287 'FRAC_SECOND' is deprecated and will be removed in a future release. Please use MICROSECOND instead
1291
1291
SELECT TIMESTAMPDIFF(FRAC_SECOND, '2008-02-17', '2008-02-18');
1292
1292
TIMESTAMPDIFF(FRAC_SECOND, '2008-02-17', '2008-02-18')
1295
Warning 1287 The syntax 'FRAC_SECOND' is deprecated and will be removed in MySQL 6.2. Please use MICROSECOND instead
1295
Warning 1287 'FRAC_SECOND' is deprecated and will be removed in a future release. Please use MICROSECOND instead
1296
1296
SELECT DATE_ADD('2008-02-18', INTERVAL 1 FRAC_SECOND);
1297
1297
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FRAC_SECOND)' at line 1
1298
1298
SELECT DATE_SUB('2008-02-18', INTERVAL 1 FRAC_SECOND);
1301
1301
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FRAC_SECOND' at line 1
1302
1302
SELECT '2008-02-18' - INTERVAL 1 FRAC_SECOND;
1303
1303
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FRAC_SECOND' at line 1
1305
# Bug #52315 part 2 : utc_date() crashes when system time > year 2037
1307
SET TIMESTAMP=-147490000;
1308
SELECT UTC_TIMESTAMP();
1309
SET TIMESTAMP=2147483648;
1310
SELECT UTC_TIMESTAMP();
1311
SET TIMESTAMP=2147483646;
1312
SELECT UTC_TIMESTAMP();
1313
SET TIMESTAMP=2147483647;
1314
SELECT UTC_TIMESTAMP();
1316
SELECT UTC_TIMESTAMP();
1318
SELECT UTC_TIMESTAMP();
1320
SELECT UTC_TIMESTAMP();
1304
1322
End of 5.0 tests
1305
1323
select date_sub("0050-01-01 00:00:01",INTERVAL 2 SECOND);
1306
1324
date_sub("0050-01-01 00:00:01",INTERVAL 2 SECOND)
1335
1353
select date_sub("0169-01-01 00:00:01",INTERVAL 2 SECOND);
1336
1354
date_sub("0169-01-01 00:00:01",INTERVAL 2 SECOND)
1337
1355
0168-12-31 23:59:59
1356
CREATE TABLE t1(a DOUBLE NOT NULL);
1357
INSERT INTO t1 VALUES (0),(9.216e-096);
1359
SELECT 1 FROM t1 ORDER BY @x:=makedate(a,a);
1365
# Bug #52160: crash and inconsistent results when grouping
1366
# by a function and column
1368
CREATE TABLE t1(a CHAR(10) NOT NULL);
1369
INSERT INTO t1 VALUES (''),('');
1370
SELECT COUNT(*) FROM t1 GROUP BY TIME_TO_SEC(a);
1374
Warning 1292 Truncated incorrect time value: ''
1375
Warning 1292 Truncated incorrect time value: ''
1376
Warning 1292 Truncated incorrect time value: ''
1379
# Bug#11766112 59151:UNINITIALIZED VALUES IN EXTRACT_DATE_TIME WITH STR_TO_DATE(SPACE(..) ...
1381
SELECT STR_TO_DATE(SPACE(2),'1');
1382
STR_TO_DATE(SPACE(2),'1')
1385
# Bug#11765216 58154: UNINITIALIZED VARIABLE FORMAT IN STR_TO_DATE FUNCTION
1387
SET GLOBAL SQL_MODE='';
1388
DO STR_TO_DATE((''), FROM_DAYS(@@GLOBAL.SQL_MODE));
1389
SET GLOBAL SQL_MODE=DEFAULT;
1391
# Bug#11766087 59125: VALGRIND UNINITIALISED VALUE WARNING IN ULL2DEC, LONGLONG2DECIMAL
1393
SELECT FORMAT(YEAR(STR_TO_DATE('',GET_FORMAT(TIME,''))),1);
1394
FORMAT(YEAR(STR_TO_DATE('',GET_FORMAT(TIME,''))),1)
1397
# Bug#11766126 59166: ANOTHER DATETIME VALGRIND UNINITIALIZED WARNING
1399
SELECT CAST((MONTH(FROM_UNIXTIME(@@GLOBAL.SQL_MODE))) AS BINARY(1025));
1400
CAST((MONTH(FROM_UNIXTIME(@@GLOBAL.SQL_MODE))) AS BINARY(1025))
1403
# Bug#11766124 59164: VALGRIND: UNINITIALIZED VALUE IN NUMBER_TO_DATETIME
1405
SELECT ADDDATE(MONTH(FROM_UNIXTIME(NULL)),INTERVAL 1 HOUR);
1406
ADDDATE(MONTH(FROM_UNIXTIME(NULL)),INTERVAL 1 HOUR)
1409
# Bug#11889186 60503: CRASH IN MAKE_DATE_TIME WITH DATE_FORMAT / STR_TO_DATE COMBINATION
1411
SELECT DATE_FORMAT('0000-00-11', '%W');
1412
DATE_FORMAT('0000-00-11', '%W')
1414
SELECT DATE_FORMAT('0000-00-11', '%a');
1415
DATE_FORMAT('0000-00-11', '%a')
1417
SELECT DATE_FORMAT('0000-00-11', '%w');
1418
DATE_FORMAT('0000-00-11', '%w')
1421
# Bug#12403504 AFTER FIX FOR #11889186 : ASSERTION FAILED: DELSUM+(INT) Y/4-TEMP > 0
1423
SELECT MAKEDATE(11111111,1);
1424
MAKEDATE(11111111,1)
1426
SELECT WEEK(DATE_ADD(FROM_DAYS(1),INTERVAL 1 MONTH), 1);
1427
WEEK(DATE_ADD(FROM_DAYS(1),INTERVAL 1 MONTH), 1)
1430
# Bug#12584302 AFTER FIX FOR #12403504: ASSERTION FAILED: DELSUM+(INT) Y/4-TEMP > 0,
1432
DO WEEK((DATE_ADD((CAST(0 AS DATE)), INTERVAL 1 YEAR_MONTH)), 5);
1434
Warning 1292 Incorrect datetime value: '0'
1338
1435
End of 5.1 tests