An error occurred fetching the project authors.
- 16 Oct, 2006 1 commit
-
-
gkodinov/kgeorge@macbook.gmz authored
When using index for group by and range access the server isolates a set of ranges based on the conditions over the key parts of the index used. Then it uses only the ranges over the GROUP BY fields to jump from one group to another. Since the GROUP BY fields may form a prefix over the index, we may use only a prefix of the ranges produced by the range optimizer. Each range contains a notion on whether it includes its border values. The problem is that when using a range prefix, the last range is open because it assumes that there is a range on the next keypart. Thus when we use a prefix range as it is, it excludes all border values. The solution is when ignoring the suffix of the range conditions (to jump over the GROUP BY prefix only) the server must change the remaining intervals so they always contain their borders, e.g. if the whole range was : (1,-inf) <= (<group_by_col>,<min_max_arg_col>) < (1, 3) we must make (1) <= (<group_by_col>) <= (1) because (a,b) < (c1,c2) means : a < c1 OR (a = c1 AND b < c2).
-
- 18 Sep, 2006 1 commit
-
-
gkodinov@dl145s.mysql.com authored
-
- 15 Aug, 2006 1 commit
-
-
sergefp@mysql.com authored
BUG#21077: Possible crash caused by invalid sequence of handler::* calls: The crash was caused by invalid sequence of handler::** calls: ha_smth->index_init(); ha_smth->index_next_same(); (2) (2) is an invalid call as it was not preceeded by any 'scan setup' call like index_first() or index_read(). The cause was that QUICK_SELECT::reset() didn't "fully reset" the quick select- current QUICK_RANGE wasn't forgotten, and quick select might attempt to continue reading the range, which would result in the above mentioned invalid sequence of handler calls. 5.x versions are not affected by the bug - they already have the missing "range=NULL" clause.
-
- 03 Aug, 2006 1 commit
-
-
gkodinov/kgeorge@macbook.gmz authored
Reseting subqueries with "quick" access methods was incomplete. Partially backported the correct reseting of QUICK_SELECTs from 5.x.
-
- 15 Jul, 2006 1 commit
-
-
igor@rurik.mysql.com authored
The bug caused a crash of the server if a subquery with ORDER BY DESC used the range access method. The bug happened because the method QUICK_SELECT_DESC::reset was not reworked after MRR interface had been introduced.
-
- 03 Jan, 2006 1 commit
-
-
serg@serg.mylan authored
-
- 30 Sep, 2005 1 commit
-
-
sergefp@mysql.com authored
optimization: now can use index to find records to update/delete when there is no WHERE clause.
-
- 03 Jun, 2005 1 commit
-
-
monty@mysql.com authored
Ensure that 'null_value' is not accessed before val() is called in FIELD() functions Fixed initialization of key maps. This fixes some problems with keys when you have more than 64 keys Fixed that ROLLUP don't always create a temporary table. This fix ensures that func_gconcat.test results are now predictable
-
- 02 Jun, 2005 1 commit
-
-
brian@zim.(none) authored
Mainly cleanups for gcc 4.0. Some small pieces from looking at -Wall. Removed a number of dumb things in ha_tina.
-
- 04 May, 2005 1 commit
-
-
msvensson@neptunus.(none) authored
- Introduce ifdefs so we can control when to use #pragma interface on cygwin
-
- 28 Apr, 2005 1 commit
-
-
sergefp@mysql.com authored
Make get_quick_select_for_ref() accept estimated # records as parameter and set QUICK_RANGE_SELECT::records, as this value is used to allocate buffers in Multi-Range Read.
-
- 29 Dec, 2004 1 commit
-
-
sergefp@mysql.com authored
* remove get_next_init and move its functionality to QUICK_RANGE_SELECT::reset() * added more comments * added empty FT_SELECT::reset()
-
- 23 Dec, 2004 1 commit
-
-
ingo@mysql.com authored
Added the required structures and functions for handing over multiple key ranges to the table handler.
-
- 21 Nov, 2004 1 commit
-
-
sergefp@mysql.com authored
* Make index merge quick selects code allow perform several scans. * Delay additional handler objects creation till row retrieval is started.
-
- 16 Nov, 2004 1 commit
-
-
bell@sanja.is.com.ua authored
-
- 27 Aug, 2004 1 commit
-
-
timour@mysql.com authored
- after-review changes - merged with the source tree from 204-08-27
-
- 11 Aug, 2004 1 commit
-
-
sergefp@mysql.com authored
The crash is eliminated but still it is weird/inefficent that ROR-intersection is used when performing updates in empty table.
-
- 21 Jul, 2004 1 commit
-
-
serg@serg.mylan authored
-
- 20 Jul, 2004 1 commit
-
-
serg@serg.mylan authored
-
- 15 Jul, 2004 2 commits
-
-
serg@serg.mylan authored
-
monty@mysql.com authored
Note: The following tests fails - fulltext (Sergei has promised to fix) - rpl_charset (Guilhem should fix) - rpl_timezone (Dimitray has promised to fix) Sanja needs to check out the calling of close_thread_tables() in sp_head.cc
-
- 23 Jun, 2004 1 commit
-
-
serg@serg.mylan authored
more logical table/index_flags return HA_ERR_WRONG_COMMAND instead of abstract methods where appropriate max_keys and other limits renamed to max_supported_keys/etc max_keys/etc are now wrappers to max_supported_keys/etc ha_index_init/ha_rnd_init/ha_index_end/ha_rnd_end are now wrappers to real {index,rnd}_{init,end} to enforce strict pairing
-
- 01 Jun, 2004 1 commit
-
-
sergefp@mysql.com authored
Fixed an incorrect optimizer choice for ror-intersect(key, clustered_primary) Typo bug fixed in multitable update
-
- 28 May, 2004 1 commit
-
-
sergefp@mysql.com authored
* Fixed a problem with wrong query results for partially covering keys in ROR-index_merge * ROR-intersection retrieval plan choice algorithm now uses less disk IO - and properly processes clustered PK range scans * Fixed several minor range optimizer problems * Added more comments * Code cleanup
-
- 16 May, 2004 1 commit
-
-
monty@mishka.local authored
New records_in_range() interface (similar to read_range()) Macros for faster bitmap handling Simplify read_range() code (#WL1786) New general key_cmp() function to compare keys
-
- 14 May, 2004 1 commit
-
-
pem@mysql.comhem.se authored
Note: One sp.test still fails (prime), and rpl_server_id2.test fails (will be fixed by guilhem ASAP).
-
- 12 May, 2004 1 commit
-
-
sergefp@mysql.com authored
This is first cset for WL#1394 "Optimize index merge when all involved index ranges include only values with equal keys" The main idea is to exploit the fact that key scans for "key=const" return ordered sequences of rowids.
-
- 08 Apr, 2004 1 commit
-
-
monty@mysql.com authored
This gives the handler more optimization possiblities and is needed for NDB cluster Fixed not-initialized memory error detected by valgrind
-
- 07 Apr, 2004 1 commit
-
-
monty@mysql.com authored
Cleanup/optimizations of structures and key usage to make it easier to move key-range-search to handler
-
- 15 Mar, 2004 1 commit
-
-
sergefp@mysql.com authored
-
- 11 Feb, 2004 1 commit
-
-
pem@mysql.comhem.se authored
-
- 05 Feb, 2004 1 commit
-
-
monty@mysql.com authored
Added SQL_SELECT::cleanup() to make it easier to reuse SQL_SELECT item's for sub selects. Needed for proper fix for bug #2479. Added 'select_to_file' class to be able to merge identical code for select_export and select_dump
-
- 03 Feb, 2004 1 commit
-
-
ram@gw.mysql.r18.ru authored
we don't need opt_range.h and opt_range.cc files at all.
-
- 02 Feb, 2004 1 commit
-
-
ram@gw.mysql.r18.ru authored
-
- 18 Dec, 2003 1 commit
-
-
sergefp@mysql.com authored
-
- 09 Dec, 2003 1 commit
-
-
sergefp@mysql.com authored
-
- 24 Nov, 2003 1 commit
-
-
sergefp@mysql.com authored
-
- 21 Nov, 2003 1 commit
-
-
sergefp@mysql.com authored
-
- 20 Nov, 2003 1 commit
-
-
sergefp@mysql.com authored
Logging to logging@openlogging.org accepted sql_union.cc, sql_select.cc, opt_range.h, opt_range.cc, opt_ft.h: Post-merge fixes Many files: new file
-
- 18 Nov, 2003 1 commit
-
-
sergefp@mysql.com authored
-