This worklog has been replaced with mariadb.org/jira

This site is here for historical purposes only. Do not add or edit tasks here!

 
 
 

WorkLog Frontpage Log in / Register
High-Level Description | Task Dependencies | High-Level Specification | Low-Level Design | File Attachments | User Comments | Time Estimates | Funding and Votes | Progress Reports

 Remove lazy subquery optimization
Title
Task ID168
Queue
Version
Status
Priority
Copies to
Created byTimour06 Dec 2010Done
Supervisor   
Lead Architect    
Architecture Review  
Implementor  
Code Review  
QA  
Documentation  
 High-Level Description
Remove all instances of lazy subquery optimization after MWL#89 is complete.

Even after MWL#89, there are certain cases when subquery predicates are
executed without prior optimization. This may result in bugs as well as
high optimization/explain cost. In addition having a mixed subquery
optimization approach results in a more complex architecture and higher
degree of coupling between different query processing phases.

The goal of this task is to investigate all remaining cases of lazy
subquery optimization, and whenever possible change each such case
to utilize the general approach of MWL#89.

Currently known remaining cases:
- sql_select.cc:remove_eq_cond calls cond->const_item() without
  checking if cond is expensive.
 Task Dependencies
Others waiting for Task 168Task 168 is waiting forGraph
89 Subqueries: cost-based choice between Materialization and IN->EXISTS transformation
 
 High-Level Specification
 Low-Level Design
 File Attachments
 NameTypeSizeByDate
 User Comments
 Time Estimates
NameHours WorkedLast Updated
Total0 
 Hrs WorkedProgressCurrentOriginal
This Task01616
Total01616
 
 Funding and Votes
Votes: 1: 100%
 Change vote: Useless    Nice to have    Important    Very important    

Funding: 0 offers, total 0 Euro
 Progress Reports
(Timour - Mon, 06 Dec 2010, 12:57
    
Dependency created: WL#89 now depends on WL#168


Report Generator:
 
Saved Reports:

WorkLog v4.0.0
  © 2010  Sergei Golubchik and Monty Program AB
  © 2004  Andrew Sweger <yDNA@perlocity.org> and Addnorya
  © 2003  Matt Wagner <matt@mysql.com> and MySQL AB