~drizzle-trunk/drizzle/development : changes

~drizzle-trunk/drizzle/development » Changes from revision 1637.5.9

From Revision 1637.5.9 to 1627

Rev	Summary	Authors	Date
1637.5.9	Fix for Bug 592444 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.	Prafulla Tekawade	14 years ago
1637.5.8	Adding test for Bug 595305 Adding test for Bug 595305	Prafulla Tekawade	14 years ago
1637.5.7	Merge from trunk Merge from trunk	Prafulla Tekawade	14 years ago
1637.5.6	This bug is simillar to mysql bug 36133 This bug is simillar to mysql bug 36133 http://bugs.mysql.com/bug.php?id=36133 Taking changes from that fix. - The problem was that the range optimizer evaluated constant expressions, and among them it would try to evaluate IN-subquery predicates slated for handling with materialization strategy. However, these predicates require that parent_join->setup_subquery_materialization() is invoked before one attempts to evaluate them. - Fixed by making the range optimizer not to evaluate expressions that have item->is_expensive() == TRUE (these are materialization subqueries and stored function calls). This should also resolve the problem that EXPLAIN may be too long. This change cuts off some opportunities for range optimizer, but this is the price we're willing to pay for separation of query optimization and execution.	Prafulla Tekawade	14 years ago
1637.5.5	Merger from main branch Merger from main branch	Prafulla Tekawade	14 years ago
1637.5.4	Reverting some un-necessary changes. Reverting some un-necessary changes.	Prafulla Tekawade	14 years ago
1637.5.3	Reverting the fix for 592473 Reverting the fix for 592473 I checked with mysql source code. In Join::Optimize code, whenever where condition is optimized, number of tables to be read this->table needs to be set to zero. This avoided later code to go over join->join_tab and creating problem such as the bug.	Prafulla Tekawade	14 years ago
1637.5.2	Refreshing from mainline branch. Refreshing from mainline branch.	Prafulla Tekawade	14 years ago
1637.5.1	Fix for Bug 592473 Fix for Bug 592473	Prafulla Tekawade	14 years ago
1637	Merge in changes to call error on bad data input. Merge in changes to call error on bad data input.	Brian Aker	14 years ago
1636	Merge in work for count_cuted_fields Merge in work for count_cuted_fields	Brian Aker	14 years ago
1635	Merge up of Brian to trunk. Mainly work on ha_open, and some... Merge up of Brian to trunk. Mainly work on ha_open, and some current_session work.	Brian Aker	14 years ago
1634	Merge of the last bits of program_options plugin module inte... Merge of the last bits of program_options plugin module integration: printing help messages.	Monty Taylor	14 years ago
1633	Merge of Patrick's schema_dictionary test changes, Stewart's... Merge of Patrick's schema_dictionary test changes, Stewart's HA Status variable move and more module program_options work.	Monty Taylor	14 years ago
1632	Undid attempt at fixing sporadic freebsd issue. Undid attempt at fixing sporadic freebsd issue.	Monty Taylor	14 years ago
1631	Fixed the OSX build. Again. Fixed the OSX build. Again.	Monty Taylor	14 years ago
1630	Added sleep call to try to avoid the spurrious socket errors... Added sleep call to try to avoid the spurrious socket errors on freebsd.	Monty Taylor	14 years ago
1629	Merged in Brian's const TableIdentifiter work. Merged in Brian's const TableIdentifiter work.	Monty Taylor	14 years ago
1628	Rollup patch featuring: boost::program_options support for p... Rollup patch featuring: boost::program_options support for plugins, a valgrind fix, a bugfix for password processing and a few build fixes.	Monty Taylor	14 years ago
1627	Killed a valgrind warning that had snuck in. Killed a valgrind warning that had snuck in.	Monty Taylor	14 years ago

Older »