1859
# Bug#59839: Aggregation followed by subquery yields wrong result
1867
INSERT INTO t1 VALUES
1878
SELECT a, AVG(t1.b),
1879
(SELECT t11.c FROM t1 t11 WHERE t11.a = t1.a AND t11.b = AVG(t1.b)) AS t11c,
1880
(SELECT t12.c FROM t1 t12 WHERE t12.a = t1.a AND t12.b = AVG(t1.b)) AS t12c
1882
id select_type table type possible_keys key key_len ref rows Extra
1883
1 PRIMARY t1 index NULL a 10 NULL 9 Using index
1884
3 DEPENDENT SUBQUERY t12 ref a a 10 func,func 2 Using where
1885
2 DEPENDENT SUBQUERY t11 ref a a 10 func,func 2 Using where
1886
SELECT a, AVG(t1.b),
1887
(SELECT t11.c FROM t1 t11 WHERE t11.a = t1.a AND t11.b = AVG(t1.b)) AS t11c,
1888
(SELECT t12.c FROM t1 t12 WHERE t12.a = t1.a AND t12.b = AVG(t1.b)) AS t12c
1890
a AVG(t1.b) t11c t12c
1895
# Bug#11765254 (58200): Assertion failed: param.sort_length when grouping
1898
SET SQL_BIG_TABLES=1;
1899
CREATE TABLE t1(a INT);
1900
INSERT INTO t1 VALUES (0),(0);
1901
SELECT 1 FROM t1 GROUP BY IF(`a`,'','');
1904
SELECT 1 FROM t1 GROUP BY TRIM(LEADING RAND() FROM '');
1907
SELECT 1 FROM t1 GROUP BY SUBSTRING('',SLEEP(0),'');
1911
Warning 1292 Truncated incorrect INTEGER value: ''
1912
Warning 1292 Truncated incorrect INTEGER value: ''
1913
Warning 1292 Truncated incorrect INTEGER value: ''
1914
SELECT 1 FROM t1 GROUP BY SUBSTRING(SYSDATE() FROM 'K' FOR 'jxW<');
1918
Warning 1292 Truncated incorrect INTEGER value: 'K'
1919
Warning 1292 Truncated incorrect INTEGER value: 'jxW<'
1920
Warning 1292 Truncated incorrect INTEGER value: 'K'
1921
Warning 1292 Truncated incorrect INTEGER value: 'jxW<'
1922
Warning 1292 Truncated incorrect INTEGER value: 'K'
1923
Warning 1292 Truncated incorrect INTEGER value: 'jxW<'
1925
SET SQL_BIG_TABLES=0;
1858
1926
# End of 5.1 tests