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)
1357
1375
Warning 1292 Truncated incorrect time value: ''
1358
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'
1360
1435
End of 5.1 tests