diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2013-01-28 13:36:05 +0100 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2013-01-28 13:36:05 +0100 |
| commit | 87de27e46b889d86cd872adf8ce613128d379911 (patch) | |
| tree | 87f3ec6d65538b9bc199408f58daaa2ec9e7a702 /mysql-test/r/distinct.result | |
| parent | f08a404a6d87f7c8c7fef1862eaf768cf920677b (diff) | |
| parent | 34e84c227f1cb76771eabf229b4cf1b5292eef25 (diff) | |
| download | mariadb-git-87de27e46b889d86cd872adf8ce613128d379911.tar.gz | |
5.3 merge
Diffstat (limited to 'mysql-test/r/distinct.result')
| -rw-r--r-- | mysql-test/r/distinct.result | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/mysql-test/r/distinct.result b/mysql-test/r/distinct.result index 75f054ecbbe..459ece978fd 100644 --- a/mysql-test/r/distinct.result +++ b/mysql-test/r/distinct.result @@ -847,6 +847,38 @@ time(f1) 00:00:00.000200 00:00:00.000300 drop table t1; +create table t1(i int, g int); +insert into t1 values (null, 1), (0, 2); +select distinct i from t1 group by g; +i +NULL +0 +drop table t1; +create table t1(i int, g blob); +insert into t1 values (null, 1), (0, 2); +select distinct i from t1 group by g; +i +NULL +0 +drop table t1; +create table t1 (a int) engine=myisam; +insert into t1 values (0),(7); +create table t2 (b int) engine=myisam; +insert into t2 values (7),(0),(3); +create algorithm=temptable view v as +select distinct (select max(a) from t1 where alias.b = a) as field1 from t2 as alias group by field1; +select * from v; +field1 +NULL +0 +7 +select distinct (select max(a) from t1 where alias.b = a) as field1 from t2 as alias group by field1; +field1 +NULL +0 +7 +drop view v; +drop table t1, t2; # # Bug #11744875: 4082: integer lengths cause truncation with distinct concat and innodb # |