Comment 1 for bug 1384430
Revision history for this message
| Suresh Subbiah (suresh-subbiah) wrote | #1 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
0e1f616
(Get the code!)
Khaled and I also found with the display tool that the sort node was considered by the optimizer and produced a valid plan. It lost out on the basis of cost. Using a CQS that had sort explicitly specified, Khaled was able to get the required plan.
A possible fix may be such that we do not consider any plan where the source sort order is not identical to the target keys. Either such plans need not be considered or we could somehow mark them as not satisfying all required properties.