Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix an issue that was causing ORDER BY DESC to come out in ascending order. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | nextgen-query-plan-exp |
| Files: | files | file ages | folders |
| SHA1: |
029840124022387a8f6d2e1a685a0036 |
| User & Date: | drh 2013-06-03 15:34:48 |
Context
|
2013-06-03
| ||
| 16:03 | Fix to the logic that disables constraints on virtual tables. check-in: 62d38240 user: drh tags: nextgen-query-plan-exp | |
| 15:34 | Fix an issue that was causing ORDER BY DESC to come out in ascending order. check-in: 02984012 user: drh tags: nextgen-query-plan-exp | |
| 15:24 | Virtual tables now always report 25 rows instead of 0 rows in the EXPLAIN QUERY PLAN output. Adjust tests accordingly. check-in: 7d91f688 user: drh tags: nextgen-query-plan-exp | |
Changes
Changes to src/where.c.
4763 4764 4765 4766 4767 4768 4769 4770 4771 4772 4773 4774 4775 4776 |
isOrdered = 0;
isOrderedValid = 1;
rCost += rSortCost;
break;
default: /* Cannot tell yet. Try again on the next iteration */
break;
}
}
/* Check to see if pWLoop should be added to the mxChoice best so far */
for(jj=0, pTo=aTo; jj<nTo; jj++, pTo++){
if( pTo->maskLoop==maskNew && pTo->isOrderedValid==isOrderedValid ){
break;
}
}
|
> > |
4763 4764 4765 4766 4767 4768 4769 4770 4771 4772 4773 4774 4775 4776 4777 4778 |
isOrdered = 0;
isOrderedValid = 1;
rCost += rSortCost;
break;
default: /* Cannot tell yet. Try again on the next iteration */
break;
}
}else{
revMask = pFrom->revLoop;
}
/* Check to see if pWLoop should be added to the mxChoice best so far */
for(jj=0, pTo=aTo; jj<nTo; jj++, pTo++){
if( pTo->maskLoop==maskNew && pTo->isOrderedValid==isOrderedValid ){
break;
}
}
|