1713
1713
NULL NULL NULL NULL NULL
1716
# Bug #54465: assert: field_types == 0 || field_types[field_pos] ==
1717
# MYSQL_TYPE_LONGLONG
1719
CREATE TABLE t1 (a INT);
1720
INSERT INTO t1 VALUES (1), (2);
1721
SELECT MAX((SELECT 1 FROM t1 ORDER BY @var LIMIT 1)) m FROM t1 t2, t1
1727
# Bug#58030 crash in Item_func_geometry_from_text::val_str
1729
SELECT MAX(TIMESTAMP(RAND(0)));
1730
SELECT MIN(TIMESTAMP(RAND(0)));
1732
# Bug#58177 crash and valgrind warnings in decimal and protocol sending functions...
1734
SELECT MIN(GET_LOCK('aaaaaaaaaaaaaaaaa',0) / '0b1111111111111111111111111111111111111111111111111111111111111111111111111' ^ (RAND()));
1735
SELECT MIN(GET_LOCK('aaaaaaaaaaaaaaaaa',0) / '0b1111111111111111111111111111111111111111111111111111111111111111111111111' ^ (RAND()));
1736
SELECT MIN(GET_LOCK('aaaaaaaaaaaaaaaaa',0) / '0b1111111111111111111111111111111111111111111111111111111111111111111111111' ^ (RAND()));
1737
SELECT MIN(GET_LOCK('aaaaaaaaaaaaaaaaa',0) / '0b1111111111111111111111111111111111111111111111111111111111111111111111111' ^ (RAND()));
1738
SELECT RELEASE_LOCK('aaaaaaaaaaaaaaaaa');
1740
# Bug #11766094 - 59132: MIN() AND MAX() REMOVE UNSIGNEDNESS
1742
CREATE TABLE t1 (a BIGINT UNSIGNED);
1743
INSERT INTO t1 VALUES (18446668621106209655);
1744
SELECT MAX(LENGTH(a)), LENGTH(MAX(a)), MIN(a), MAX(a), CONCAT(MIN(a)), CONCAT(MAX(a)) FROM t1;
1745
MAX(LENGTH(a)) LENGTH(MAX(a)) MIN(a) MAX(a) CONCAT(MIN(a)) CONCAT(MAX(a))
1746
20 20 18446668621106209655 18446668621106209655 18446668621106209655 18446668621106209655
1749
# Bug #11766270 59343: YEAR(4): INCORRECT RESULT AND VALGRIND WARNINGS WITH MIN/MAX, UNION
1751
CREATE TABLE t1(f1 YEAR(4));
1752
INSERT INTO t1 VALUES (0000),(2001);
1753
(SELECT MAX(f1) FROM t1) UNION (SELECT MAX(f1) FROM t1);
1754
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1755
def MAX(f1) MAX(f1) 13 4 4 Y 32864 0 63
1716
1760
End of 5.1 tests