summaryrefslogtreecommitdiff
path: root/mysql-test/r/having.result
Commit message (Collapse)AuthorAgeFilesLines
* Fix for BUG#11211 "GROUP BY doesn't work correctly"timour@mysql.com2005-06-151-0/+1
| | | | | | | | | | | | | | | | | | | | | | | | When the GROUP BY clause contains a column reference that can be resolved to both an aliased column in the SELECT list, and to a column in the FROM clause, the group column is resolved to the column in the FROM clause (for ANSI conformance). However, it may be so that the user's intent is just the other way around, and he/she gets the query results grouped by a completely different column than expexted. This patch adds a warning in such cases that tells the user that there is potential ambiguity in the group column. sql/sql_select.cc - Added a warning when a GROUP column is ambiguous due to that there is a column reference with the same name both in the SELECT and FROM clauses. In this case we resolve to the column in FROM clause and warn the user of a possible ambiguity. - More extensive comments. - Changed the function to return bool instead of int (as in other places). mysql-test/t/group_by.test Added test for BUG#11211. mysql-test/r/group_by.result Added test for BUG#11211.
* WL#1972 "Evaluate HAVING before SELECT select-list"timour@mysql.com2004-11-091-0/+7
| | | | | - post-review fix regarding Item_fields - added test for the changed name resolution
* WL#1972 "Evaluate HAVING before SELECT"timour@mysql.com2004-11-051-50/+124
| | | | - more tests, post-review changes, bug-fixes, simplifications, and improved comments
* WL#1972 "Evaluate HAVING before SELECT select-list"timour@mysql.com2004-11-021-0/+3
| | | | | | | - Changed name resolution for GROUP BY so that derived columns do not shadow table columns from the FROM clause. As a result GROUP BY now is handled as a true ANSI extentsion. - Issue a warning when HAVING is resolved into ambiguous columns, and prefer the columns from the GROUP BY clause over SELECT columns.
* Implementation of WL#1972 "Evaluate HAVING before SELECT select-list"timour@mysql.com2004-10-281-0/+116
|
* Merge with 4.1monty@mysql.com2004-09-061-0/+41
|\ | | | | | | | | (Includes merge of arena code in 4.1 and 5.0)
| * Portability fixesmonty@mysql.com2004-08-261-0/+1
| | | | | | | | Fixed bug in end space handle for WHERE text_column="constant"
| * after merge fixesserg@serg.mylan2004-08-191-3/+3
| |
| * manually mergedserg@serg.mylan2004-08-181-0/+40
| |\
| | * fixed Bug #4358 Problem with HAVING clause that uses aliasvva@eagle.mysql.r18.ru2004-08-121-0/+40
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | from the select list and TEXT field make setup_copy_fields to insert Item_copy_string for blobs in the beginning of the copy_funcs (push_back instead of push_front) the thing is that Item_copy_string::copy for function can call Item_copy_string::val_int for blob via Item_ref. But if Item_copy_string::copy for blob isn't called before, it's value will be wrong. So all the Item_copy_string::copy for blobs should be called before Item_copy_string::copy for functions.
* | | mark subquery in the FROM clause like derived and quoate all identifiers ↵bell@sanja.is.com.ua2004-07-201-1/+1
|/ / | | | | | | (BUG#4609)
* | fixed flags of printed querybell@sanja.is.com.ua2004-05-131-1/+1
| |
* | added code covarage for functions convert(), nullif(), crc32(), ↵bell@sanja.is.com.ua2003-10-301-0/+5
| | | | | | | | | | | | | | | | is_used_lock(), char_lengtrh(), bit_xor() added string length for more speed made code covarage for print() method of Item fixed printability of some items (SCRUM) (WL#1274)
* | Merge with 4.0.13monty@narttu.mysql.fi2003-05-191-0/+15
|\ \ | |/
| * Safety fix to enable RAID in max binariesmonty@mashka.mysql.fi2003-05-131-0/+8
| | | | | | | | | | Better fix for format('nan') Fix for HAVING COUNT(DISTINCT...)
| * A fix for bug #176Sinisa@sinisa.nasamreza.org2003-03-241-0/+7
| | | | | | | | code cleanup
* | add VARIANCE functionvva@eagle.mysql.r18.ru2002-12-141-0/+4
|/
* Fix sorting of NULL values (Should always be first)monty@tik.mysql.fi2002-03-021-0/+19
| | | | Fix problem with HAVING and MAX() IS NOT NULL
* Fixes up things after merge from 3.23.44monty@hundin.mysql.fi2001-11-051-1/+36
| | | | | Portability fixes. Don't delete temporary tables on FLUSH tables.
* use local version when doing merge with 3.23.44monty@hundin.mysql.fi2001-11-041-2/+7
|
* Portability fixesmonty@hundin.mysql.fi2001-10-311-0/+2
| | | | | | Fix for consistent 0000-00-00 date handling Close + open binary logs on flush tables Fix for AVG() in HAVING.
* Fixed for bugs that was found when getting full code coverage of BDBmonty@donna.mysql.com2001-01-171-0/+4
Fixed bug with HEAP tables on windows Fixed bug with HAVING on empty tables
View Lorry Controller Status