1524
1524
# Bug#43668: Wrong comparison and MIN/MAX for YEAR(2)
1526
1526
create table t1 (f1 year(2), f2 year(4), f3 date, f4 datetime);
1528
Note 1287 'YEAR(2)' is deprecated and will be removed in a future release. Please use YEAR(4) instead
1527
1529
insert into t1 values
1528
1530
(98,1998,19980101,"1998-01-01 00:00:00"),
1529
1531
(00,2000,20000101,"2000-01-01 00:00:01"),
1713
1715
NULL NULL NULL NULL NULL
1718
# Bug #54465: assert: field_types == 0 || field_types[field_pos] ==
1719
# MYSQL_TYPE_LONGLONG
1721
CREATE TABLE t1 (a INT);
1722
INSERT INTO t1 VALUES (1), (2);
1723
SELECT MAX((SELECT 1 FROM t1 ORDER BY @var LIMIT 1)) m FROM t1 t2, t1
1729
# Bug#58030 crash in Item_func_geometry_from_text::val_str
1731
SELECT MAX(TIMESTAMP(RAND(0)));
1732
SELECT MIN(TIMESTAMP(RAND(0)));
1734
# Bug#58177 crash and valgrind warnings in decimal and protocol sending functions...
1736
SELECT MIN(GET_LOCK('aaaaaaaaaaaaaaaaa',0) / '0b1111111111111111111111111111111111111111111111111111111111111111111111111' ^ (RAND()));
1737
SELECT MIN(GET_LOCK('aaaaaaaaaaaaaaaaa',0) / '0b1111111111111111111111111111111111111111111111111111111111111111111111111' ^ (RAND()));
1738
SELECT MIN(GET_LOCK('aaaaaaaaaaaaaaaaa',0) / '0b1111111111111111111111111111111111111111111111111111111111111111111111111' ^ (RAND()));
1739
SELECT MIN(GET_LOCK('aaaaaaaaaaaaaaaaa',0) / '0b1111111111111111111111111111111111111111111111111111111111111111111111111' ^ (RAND()));
1740
SELECT RELEASE_LOCK('aaaaaaaaaaaaaaaaa');
1742
# Bug #11766094 - 59132: MIN() AND MAX() REMOVE UNSIGNEDNESS
1744
CREATE TABLE t1 (a BIGINT UNSIGNED);
1745
INSERT INTO t1 VALUES (18446668621106209655);
1746
SELECT MAX(LENGTH(a)), LENGTH(MAX(a)), MIN(a), MAX(a), CONCAT(MIN(a)), CONCAT(MAX(a)) FROM t1;
1747
MAX(LENGTH(a)) LENGTH(MAX(a)) MIN(a) MAX(a) CONCAT(MIN(a)) CONCAT(MAX(a))
1748
20 20 18446668621106209655 18446668621106209655 18446668621106209655 18446668621106209655
1751
# Bug #11766270 59343: YEAR(4): INCORRECT RESULT AND VALGRIND WARNINGS WITH MIN/MAX, UNION
1753
CREATE TABLE t1(f1 YEAR(4));
1754
INSERT INTO t1 VALUES (0000),(2001);
1755
(SELECT MAX(f1) FROM t1) UNION (SELECT MAX(f1) FROM t1);
1756
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1757
def MAX(f1) MAX(f1) 13 4 4 Y 32864 0 63
1716
1762
End of 5.1 tests