diff options
| author | unknown <evgen@moonbone.local> | 2005-10-27 17:44:28 +0400 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2005-10-27 17:44:28 +0400 |
| commit | 111b40e1569832156f1448afc572dfdd4009347d (patch) | |
| tree | c1c2167585e33975e5a43a49bae5fb73bd71f543 /mysql-test/t/select.test | |
| parent | 4cccc642e9169cafd865f4a7acf7bbd8f1a77eca (diff) | |
| parent | a1d92b8a1b289bbb6a983ba58034b6df5c1f91b9 (diff) | |
| download | mariadb-git-111b40e1569832156f1448afc572dfdd4009347d.tar.gz | |
Manually merged
include/config-netware.h:
Auto merged
sql/sql_select.cc:
Auto merged
mysql-test/r/select.result:
Manually merged fix for bug#13855
mysql-test/t/select.test:
Manuall merged fix for bug#13855
Diffstat (limited to 'mysql-test/t/select.test')
| -rw-r--r-- | mysql-test/t/select.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/select.test b/mysql-test/t/select.test index 56fab52729e..39c7cdfa8a9 100644 --- a/mysql-test/t/select.test +++ b/mysql-test/t/select.test @@ -2228,4 +2228,13 @@ SELECT t2.a, t2.b, IF(t1.b IS NULL,'',c) AS c, COUNT(*) AS d FROM t2,t1 WHERE t2.a = t1.a AND t2.b = t1.b GROUP BY a, b, c; DROP TABLE IF EXISTS t1, t2; +# +# Bug #13855 select distinct with group by caused server crash +# +create table t1 (f1 int primary key, f2 int); +create table t2 (f3 int, f4 int, primary key(f3,f4)); +insert into t1 values (1,1); +insert into t2 values (1,1),(1,2); +select distinct count(f2) >0 from t1 left join t2 on f1=f3 group by f1; +drop table t1,t2; # End of 4.1 tests |