summaryrefslogtreecommitdiff
path: root/sql/item_sum.h
Commit message (Collapse)AuthorAgeFilesLines
* Post-review fixes for bug #1790 'BIT_AND() result in GROUP BY different whenkonstantin@mysql.com2003-12-021-8/+6
| | | | | | | | | | SQL_BIG_RESULT used': - BIT_AND now returns BIGINT UNSIGNED - in case there were no matching rows BIT_AND returns 18446744073709551615 (but not NULL), BIT_OR returns 0 (but not NULL). That's how Monty wants it and how is described in our docs.
* fix for bug #1790: konstantin@mysql.com2003-11-211-5/+17
| | | | | | | | | "BIT_AND() result in GROUP BY different when SQL_BIG_RESULT used" return value of BIT_AND changed to BIGINT SIGNED Also the patch fixes another bug: when temporary table is in use and one of values in group is NULL, BIT_AND always returns zero. Fixed it to always skip null values.
* Fixed some varnings from valgrindmonty@narttu.mysql.fi2003-08-201-16/+16
| | | | | | Set min value of max_allowed_packet to 1024 Fixed problem with UNION's without braces and SQL_CALC_FOUND_ROWS, LIMIT #,# and ORDER BY...LIMIT
* Fixed bug in SUM() with NULL:smonty@mashka.mysql.fi2003-04-151-3/+5
| | | | | Added logging of warnings for failed connections with ssl. Fixed bug in symbolic link handling on Windows
* Better fix for count(distinct) bugmonty@mashka.mysql.fi2003-02-101-2/+2
|
* count(distint) on an empty table crash fixedserg@sergbook.mysql.com2003-02-101-2/+4
|
* Fix for MIN/MAX with empty tablesmonty@mashka.mysql.fi2003-02-031-0/+2
| | | | | MIN(key_column) could in some cases return NULL on a column with NULL and other values. MIN(key_column) and MAX(key_column) could in some cases return wrong values when used in OUTER JOIN.
* Removed wrong implementation of CUBE/ROLLUPmonty@mashka.mysql.fi2002-07-241-17/+17
| | | | | | Fixed bugfix of INSERT ... SET db_name.table_name.column_name Changed locking to external-locking Fix client hangup for some invalid SQL queries.
* OLAP functionality plus some small bug fixesSinisa@sinisa.nasamreza.org2002-07-201-0/+17
|
* Fix sorting of NULL values (Should always be first)monty@tik.mysql.fi2002-03-021-0/+3
| | | | Fix problem with HAVING and MAX() IS NOT NULL
* Update copyrightmonty@hundin.mysql.fi2001-12-061-5/+5
| | | | Fixed memory leak on shutdown (Affects the embedded version & MyODBC)
* Final fixes for INSERT into MERGE tables.monty@tik.mysql.fi2001-09-271-1/+3
| | | | | | Move MAX_BLOB_WIDTH to be global Added full support for unsigned BIGINT Fixed spelling errors
* Remove warnings and portability fixesmonty@hundin.mysql.fi2001-08-141-1/+2
| | | | | | New global read lock code Fixed bug in DATETIME with WHERE optimization Made UNION code more general.
* Fix UNIONmonty@tik.mysql.fi2001-08-021-0/+1
| | | | | | | | New faster list iterators Change list code to be simpler and faster Optimize count(distinct) New error messages for UNION Make create_tmp_table more general to be usable by UNION
* merged new 3.23 errorssasha@mysql.sashanet.com2001-06-221-1/+1
| | | | | | fixed bugs in log seq - now starting to look good fixes for SHOW BINLOG EVENTS will push this one
* mergemonty@work.mysql.com2001-06-211-7/+8
|\
| * Fixed bug in mysqlcheck when using --fastmonty@hundin.mysql.fi2001-06-191-1/+2
| | | | | | | | | | | | Fixed problem when converting bigint to double. Fixed bug in count(distinct null) Fixed bug with empty BDB tables.
* | count(distinct) cleanupsasha@mysql.sashanet.com2001-05-291-3/+4
| |
* | handle tree overflow in count(distinct)sasha@mysql.sashanet.com2001-05-241-3/+14
| | | | | | | | test heap table/tree overflow in count(distinct)
* | use tree for count(distinct) when possiblesasha@mysql.sashanet.com2001-05-111-2/+13
|/
* Portability fixes for OPENBSD, OS2 and Windowsmonty@donna.mysql.com2001-01-271-0/+3
|
* Import changesetbk@work.mysql.com2000-07-311-0/+464