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

 Move the transformations for inequality predicates with ALL/ANY subqueries from the prepare phase into the optimization phase.
Title
Task ID148
Queue
Version
Status
Priority
Copies toMonty

Created bySanja15 Sep 2010Done
Supervisor   
Lead Architect    
Architecture Review  
Implementor  
Code Review  
QA  
Documentation  
 High-Level Description
Move the transformations for inequality predicates with ALL/ANY subqueries from 
the prepare phase into the optimization phase from preparation phase.

It could be done in any place of the optimisation.

Now there is 2 kind of the MAX/MIN optimisation for non-correlated subqueries:

If it is possible (there is no aggregate functions in the subquery) ALL/ANY 
converted to 

<LEFT> <comp> (SELECT <min/max>(<select_list>) ...)

Otherwise:

<LEFT> <comp> (MAX/MIN_SELECT <select_list> ...)

Where MAX/MIN_SELECT is special subquery which returns max or min result of all 
found by the subquery.
 Task Dependencies
Others waiting for Task 148Task 148 is waiting forGraph
 
 High-Level Specification
 Low-Level Design
 File Attachments
 NameTypeSizeByDate
 User Comments
 Time Estimates
NameHours WorkedLast Updated
Total0 
 Hrs WorkedProgressCurrentOriginal
This Task06464
Total06464
 
 Funding and Votes
Votes: 0: 0%
 Make vote: Useless    Nice to have    Important    Very important    

Funding: 0 offers, total 0 Euro
 Progress Reports


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