~drizzle-trunk/drizzle/development

  • Committer: Prafulla Tekawade
  • Date: 2010-07-18 03:36:32 UTC
  • mto: (1662.1.4 rollup)
  • Revision ID: prafulla_t@users.sourceforge.net-20100718033632-p7q6qtgliqbhe38p
Fix for Bug 592444

There were two problems:
o. In greedy_search optimizer method, best_extension_by_limited search
   maintains join embedding(nestedness) of tables added so far, so that 
   correct(valid)  join order is selected
   These are requirements from nested outer join executioner.
   The problem was, embedding_map was not correctly updated when a table 
   is added to optimal plan outside best_extension_by_limited search, 
   by greedy_search method. We need to update join->cur_embedding_map
   correctly here so that execution plan for other tables get
   generated.
   Invoked checked_interleaving_with_nj from greedy_search on the
   best_table selected. Fixed its prototype to take only one JoinTab
   This is same as mysql 5.1 source tree.
o. The other problem was, join->cur_embedding_map was not restored correctly
   when a table is added to the optimal plan to reflect the current embedding 
   map. 
   Taken good documented method restore_prev_nj_state which restores 
   cur_embedding_map from mysql 5.1 source tree and modified it for drizzled 
   code.
Filename Latest Rev Last Changed Committer Comment Size
..
ha_heap.cc 1642 14 years ago Brian Aker This adds const to SchemaIdentifier. 26.8 KB Diff Download File
ha_heap.h 1491.1.10 15 years ago Jay Pipes ha_rnd_init -> startTableScan, rnd_init -> doStart 3.7 KB Diff Download File
heap.h 1491.1.8 15 years ago Jay Pipes Removes HEAP-specific Cursor::implicit_emptied mem 10.3 KB Diff Download File
heap_priv.h 1410.3.4 15 years ago Djellel E. Difallah update references to old my_'s 5.6 KB Diff Download File
hp_block.cc 1241.9.1 15 years ago Monty Taylor Removed global.h. Fixed all the headers. Also fixe 4.6 KB Diff Download File
hp_clear.cc 1280.1.10 15 years ago Monty Taylor Put everything in drizzled into drizzled namespace 3.6 KB Diff Download File
hp_close.cc 1241.9.1 15 years ago Monty Taylor Removed global.h. Fixed all the headers. Also fixe 1.2 KB Diff Download File
hp_create.cc 1299 15 years ago Brian Aker Merge. 14.7 KB Diff Download File
hp_delete.cc 1241.9.57 15 years ago Monty Taylor Oy. Bigger change than I normally like - but this 5.8 KB Diff Download File
hp_dspace.cc 1241.9.57 15 years ago Monty Taylor Oy. Bigger change than I normally like - but this 13.9 KB Diff Download File
hp_extra.cc 1280.1.10 15 years ago Monty Taylor Put everything in drizzled into drizzled namespace 2.2 KB Diff Download File
hp_hash.cc 1280.1.10 15 years ago Monty Taylor Put everything in drizzled into drizzled namespace 23.8 KB Diff Download File
hp_info.cc 1130.3.28 15 years ago Monty Taylor Moved heapdef.h and myisamdef.h to *_priv.h for ea 1.7 KB Diff Download File
hp_open.cc 1241.9.57 15 years ago Monty Taylor Oy. Bigger change than I normally like - but this 2.7 KB Diff Download File
hp_panic.cc 1280.1.10 15 years ago Monty Taylor Put everything in drizzled into drizzled namespace 1.5 KB Diff Download File
hp_record.cc 1280.1.10 15 years ago Monty Taylor Put everything in drizzled into drizzled namespace 9.2 KB Diff Download File
hp_rectest.cc 1241.9.57 15 years ago Monty Taylor Oy. Bigger change than I normally like - but this 1 KB Diff Download File
hp_rename.cc 1241.9.57 15 years ago Monty Taylor Oy. Bigger change than I normally like - but this 1.1 KB Diff Download File
hp_rfirst.cc 1280.1.10 15 years ago Monty Taylor Put everything in drizzled into drizzled namespace 2.4 KB Diff Download File
hp_rkey.cc 1280.1.10 15 years ago Monty Taylor Put everything in drizzled into drizzled namespace 2.6 KB Diff Download File
hp_rlast.cc 1280.1.10 15 years ago Monty Taylor Put everything in drizzled into drizzled namespace 1.7 KB Diff Download File
hp_rnext.cc 1280.1.10 15 years ago Monty Taylor Put everything in drizzled into drizzled namespace 4.1 KB Diff Download File
hp_rprev.cc 1280.1.10 15 years ago Monty Taylor Put everything in drizzled into drizzled namespace 2.7 KB Diff Download File
hp_rrnd.cc 1241.9.57 15 years ago Monty Taylor Oy. Bigger change than I normally like - but this 2.8 KB Diff Download File
hp_rsame.cc 1241.9.57 15 years ago Monty Taylor Oy. Bigger change than I normally like - but this 1.6 KB Diff Download File
hp_scan.cc 1241.9.57 15 years ago Monty Taylor Oy. Bigger change than I normally like - but this 2 KB Diff Download File
hp_static.cc 1130.3.28 15 years ago Monty Taylor Moved heapdef.h and myisamdef.h to *_priv.h for ea 930 bytes Diff Download File
hp_update.cc 1280.1.10 15 years ago Monty Taylor Put everything in drizzled into drizzled namespace 3.5 KB Diff Download File
hp_write.cc 1280.1.10 15 years ago Monty Taylor Put everything in drizzled into drizzled namespace 10.2 KB Diff Download File
plugin.am 1497.3.22 15 years ago Monty Taylor Fix typos. 1.6 KB Diff Download File
plugin.ini 1241.9.56 15 years ago Monty Taylor More mysys cleaning. 168 bytes Diff Download File