~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
..
prototest 1302.4.8 15 years ago Eric Day Added prototest test case for mysql_protocol. Diff
tests 1302.4.8 15 years ago Eric Day Added prototest test case for mysql_protocol. Diff
errmsg.h 1337.4.1 15 years ago Eric Day Removed unused functions and extra complexity in M 3 KB Diff Download File
mysql_password.cc 1337.5.3 15 years ago Eric Day Moved sha1 to algorithm directory. 1.8 KB Diff Download File
mysql_password.h 1337.4.2 15 years ago Eric Day Added MYSQL_PASSWORD() UDF. 1.2 KB Diff Download File
mysql_protocol.cc 1639.2.4 14 years ago Vijay Samuel Merge fixes for variables.test and error printing. 28.2 KB Diff Download File
mysql_protocol.h 1337.4.5 15 years ago Eric Day Added MySQL password hash support. 2.9 KB Diff Download File
net_serv.cc 1537.1.1 15 years ago Joe Daly add bytes_sent and bytes_received counters 24.4 KB Diff Download File
net_serv.h 1337.4.1 15 years ago Eric Day Removed unused functions and extra complexity in M 3.4 KB Diff Download File
options.h 971.7.11 15 years ago Eric Day Fixed header file guards and fixed test cases. 5.2 KB Diff Download File
plugin.am 1302.4.14 15 years ago Eric Day Forgot to update autmake rules with rename. 607 bytes Diff Download File
plugin.ini 1509.1.1 15 years ago Monty Taylor Undid the libdrizzled.so. 334 bytes Diff Download File
vio.cc 1337.4.1 15 years ago Eric Day Removed unused functions and extra complexity in M 5.8 KB Diff Download File
vio.h 1337.4.1 15 years ago Eric Day Removed unused functions and extra complexity in M 2.7 KB Diff Download File