diff options
| author | unknown <serg@serg.mylan> | 2005-09-09 12:47:57 +0200 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2005-09-09 12:47:57 +0200 |
| commit | 708553e0693c678ad32e5f5793a8e28823cc5627 (patch) | |
| tree | 7d2dd1352ea94c30331d00fc3be7604daf8ff17a /mysql-test/r/group_by.result | |
| parent | 1a3313500221fc87ea333ab94bd5c70751dca711 (diff) | |
| download | mariadb-git-708553e0693c678ad32e5f5793a8e28823cc5627.tar.gz | |
aftermerge
Diffstat (limited to 'mysql-test/r/group_by.result')
| -rw-r--r-- | mysql-test/r/group_by.result | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index 45dca86f5f7..7bc886022cc 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -751,15 +751,6 @@ COUNT(DISTINCT(t1.id)) comment 1 NULL 1 a problem DROP TABLE t1, t2; -create table t1(f1 varchar(5) key); -insert into t1 values (1),(2); -select sql_buffer_result max(f1) is null from t1; -max(f1) is null -0 -select sql_buffer_result max(f1)+1 from t1; -max(f1)+1 -3 -drop table t1; create table t1 (f1 date); insert into t1 values('2005-06-06'); insert into t1 values('2005-06-06'); @@ -775,6 +766,15 @@ n Warnings: Warning 1052 Column 'n' in group statement is ambiguous DROP TABLE t1; +create table t1(f1 varchar(5) key); +insert into t1 values (1),(2); +select sql_buffer_result max(f1) is null from t1; +max(f1) is null +0 +select sql_buffer_result max(f1)+1 from t1; +max(f1)+1 +3 +drop table t1; create table t1 (c1 char(3), c2 char(3)); create table t2 (c3 char(3), c4 char(3)); insert into t1 values ('aaa', 'bb1'), ('aaa', 'bb2'); |