diff options
| author | unknown <monty@mashka.mysql.fi> | 2003-01-17 13:57:15 +0200 |
|---|---|---|
| committer | unknown <monty@mashka.mysql.fi> | 2003-01-17 13:57:15 +0200 |
| commit | 4dd2eb198f8ab61ed5b4957851d3c6b04a999014 (patch) | |
| tree | 93c907d7855ec60548b1d139fc8e212e90cb3f28 /mysql-test/r/group_by.result | |
| parent | 90b2534f8f8fda105fdda2731273ba839b328da3 (diff) | |
| download | mariadb-git-4dd2eb198f8ab61ed5b4957851d3c6b04a999014.tar.gz | |
After merge fix
BitKeeper/etc/ignore:
added extra/mysql_waitpid
Diffstat (limited to 'mysql-test/r/group_by.result')
| -rw-r--r-- | mysql-test/r/group_by.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index ddddb3fa07d..02773f2eb44 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -467,3 +467,17 @@ NOT NULL); max(value) 4 drop table t1,t2,t3; +create table t1 (a blob null); +insert into t1 values (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(""),(""),(""),("b"); +select a,count(*) from t1 group by a; +a count(*) +NULL 9 + 3 +b 1 +set option sql_big_tables=1; +select a,count(*) from t1 group by a; +a count(*) +NULL 9 + 3 +b 1 +drop table t1; |