diff options
| author | unknown <monty@mysql.com> | 2005-02-07 18:13:57 +0200 |
|---|---|---|
| committer | unknown <monty@mysql.com> | 2005-02-07 18:13:57 +0200 |
| commit | d6ed8cd7097391b55936a1dfec248da65e7f64f9 (patch) | |
| tree | 3fa14495db5e1376fa69b1a6f662a5e7afdc82da /mysql-test/r/user_var.result | |
| parent | ad21db5e0727704ee0527c08410bafff4d3150f4 (diff) | |
| download | mariadb-git-d6ed8cd7097391b55936a1dfec248da65e7f64f9.tar.gz | |
Fixed bug in HAVING when refering to RAND() through alias
(BUG 8216)
mysql-test/r/group_by.result:
New test case
mysql-test/r/user_var.result:
Test changed (to be more correct) with bug fix
mysql-test/t/group_by.test:
Added test for HAVING bug
sql/item_cmpfunc.cc:
Fixed bug in HAVING when refering to RAND()
sql/item_func.cc:
Fixed bug in HAVING when refering to RAND()
sql/item_row.cc:
Fixed bug in HAVING when refering to RAND()
sql/item_strfunc.cc:
Fixed bug in HAVING when refering to RAND()
sql/unireg.h:
Added PSEUDO_TABLES_BITS for easy testing of real table reference
Diffstat (limited to 'mysql-test/r/user_var.result')
| -rw-r--r-- | mysql-test/r/user_var.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/user_var.result b/mysql-test/r/user_var.result index 81846391795..041d1b836b7 100644 --- a/mysql-test/r/user_var.result +++ b/mysql-test/r/user_var.result @@ -109,8 +109,8 @@ select @a:=0; select @a, @a:=@a+count(*), count(*), @a from t1 group by i; @a @a:=@a+count(*) count(*) @a 0 1 1 0 -0 2 2 0 -0 3 3 0 +0 3 2 0 +0 6 3 0 select @a:=0; @a:=0 0 |