diff options
| author | unknown <bell@sanja.is.com.ua> | 2003-01-29 20:44:47 +0200 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2003-01-29 20:44:47 +0200 |
| commit | 72e091f0f6b3347046b178cf40d99749f2c2da20 (patch) | |
| tree | 0388d71e4d05deefde23bc90c8ba8779cfaad936 /mysql-test/r/row.result | |
| parent | b627e2dbb294b3a9fe64faf017b06988c70ef378 (diff) | |
| download | mariadb-git-72e091f0f6b3347046b178cf40d99749f2c2da20.tar.gz | |
fixed row items with group functions
fixed layout
BitKeeper/etc/ignore:
Added stamp-h2 stamp-h3 stamp-h4 to the ignore list
mysql-test/r/row.result:
test of row with group function
mysql-test/t/row.test:
test of row with group function
sql/item_cmpfunc.cc:
added braces according review
sql/item_func.cc:
fixed layout
sql/item_row.cc:
fixed row item
sql/item_row.h:
fixed row items with group functions
Diffstat (limited to 'mysql-test/r/row.result')
| -rw-r--r-- | mysql-test/r/row.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/row.result b/mysql-test/r/row.result index d86ae6c7961..40beeb4d3a5 100644 --- a/mysql-test/r/row.result +++ b/mysql-test/r/row.result @@ -144,3 +144,18 @@ Cardinality error (more/less than 1 columns) select count(*) from t1 having (1,1) order by i; Cardinality error (more/less than 1 columns) drop table t1; +create table t1 (a int, b int); +insert into t1 values (1, 4); +insert into t1 values (10, 40); +insert into t1 values (1, 4); +insert into t1 values (10, 43); +insert into t1 values (1, 4); +insert into t1 values (10, 41); +insert into t1 values (1, 4); +insert into t1 values (10, 43); +insert into t1 values (1, 4); +select a, MAX(b), (1, MAX(b)) = (1, 4) from t1 group by a; +a MAX(b) (1, MAX(b)) = (1, 4) +1 4 1 +10 43 0 +drop table t1; |