1237
1237
'2010-10-10 10:10:10' + INTERVAL GeometryType(GeomFromText('POINT(1 1)')) hour_second
1238
1238
2010-10-10 10:10:10
1240
# MDEV-5745 analyze MySQL fix for bug#12368495
1242
SELECT CHAR_LENGTH(TRIM(LEADING 0x0000000000 FROM _utf32 0x00000061));
1243
CHAR_LENGTH(TRIM(LEADING 0x0000000000 FROM _utf32 0x00000061))
1245
SELECT CHAR_LENGTH(TRIM(LEADING 0x0001 FROM _utf32 0x00000061));
1246
CHAR_LENGTH(TRIM(LEADING 0x0001 FROM _utf32 0x00000061))
1248
SELECT CHAR_LENGTH(TRIM(LEADING 0x00 FROM _utf32 0x00000061));
1249
CHAR_LENGTH(TRIM(LEADING 0x00 FROM _utf32 0x00000061))
1251
SELECT CHAR_LENGTH(TRIM(TRAILING 0x0000000000 FROM _utf32 0x00000061));
1252
CHAR_LENGTH(TRIM(TRAILING 0x0000000000 FROM _utf32 0x00000061))
1254
SELECT CHAR_LENGTH(TRIM(TRAILING 0x0001 FROM _utf32 0x00000061));
1255
CHAR_LENGTH(TRIM(TRAILING 0x0001 FROM _utf32 0x00000061))
1257
SELECT CHAR_LENGTH(TRIM(TRAILING 0x61 FROM _utf32 0x00000061));
1258
CHAR_LENGTH(TRIM(TRAILING 0x61 FROM _utf32 0x00000061))
1260
SELECT CHAR_LENGTH(TRIM(BOTH 0x0000000000 FROM _utf32 0x00000061));
1261
CHAR_LENGTH(TRIM(BOTH 0x0000000000 FROM _utf32 0x00000061))
1263
SELECT CHAR_LENGTH(TRIM(BOTH 0x0001 FROM _utf32 0x00000061));
1264
CHAR_LENGTH(TRIM(BOTH 0x0001 FROM _utf32 0x00000061))
1266
SELECT CHAR_LENGTH(TRIM(BOTH 0x61 FROM _utf32 0x00000061));
1267
CHAR_LENGTH(TRIM(BOTH 0x61 FROM _utf32 0x00000061))
1269
SELECT CHAR_LENGTH(TRIM(BOTH 0x00 FROM _utf32 0x00000061));
1270
CHAR_LENGTH(TRIM(BOTH 0x00 FROM _utf32 0x00000061))
1240
1273
# End of 5.5 tests