Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix for queries that use and inequality on ROWID in the WHERE clause. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
32de931aa1a6eb9c8e1b2fccad5af328 |
| User & Date: | drh 2013-01-19 02:16:12 |
Context
|
2013-01-19
| ||
| 02:38 | Change the hexadecimal digits generated by the hex() and quote() functions to lower-case. check-in: 3025370e1f user: drh tags: trunk | |
| 02:16 | Fix for queries that use and inequality on ROWID in the WHERE clause. check-in: 32de931aa1 user: drh tags: trunk | |
|
2013-01-18
| ||
| 23:15 | Add support for multiple VALUES in a single INSERT statement. check-in: 4ea88c4882 user: drh tags: trunk | |
Changes
Changes to src/where.c.
4233 4234 4235 4236 4237 4238 4239 4240 4241 4242 4243 4244 4245 4246 4247 |
/* If there are inequality constraints, check that the value
** of the table column that the inequality constrains is not NULL.
** If it is, jump to the next iteration of the loop. */
r1 = sqlite4GetTempReg(pParse);
testcase( pLevel->plan.wsFlags & WHERE_BTM_LIMIT );
testcase( pLevel->plan.wsFlags & WHERE_TOP_LIMIT );
if( (pLevel->plan.wsFlags & (WHERE_BTM_LIMIT|WHERE_TOP_LIMIT))!=0 ){
sqlite4VdbeAddOp3(v, OP_Column, iCur, iIneq, r1);
sqlite4VdbeAddOp2(v, OP_IsNull, r1, addrCont);
}
sqlite4ReleaseTempReg(pParse, r1);
/* Record the instruction used to terminate the loop. Disable
** WHERE clause terms made redundant by the index range scan.
*/
|
| |
4233 4234 4235 4236 4237 4238 4239 4240 4241 4242 4243 4244 4245 4246 4247 |
/* If there are inequality constraints, check that the value
** of the table column that the inequality constrains is not NULL.
** If it is, jump to the next iteration of the loop. */
r1 = sqlite4GetTempReg(pParse);
testcase( pLevel->plan.wsFlags & WHERE_BTM_LIMIT );
testcase( pLevel->plan.wsFlags & WHERE_TOP_LIMIT );
if( (pLevel->plan.wsFlags & (WHERE_BTM_LIMIT|WHERE_TOP_LIMIT))!=0 ){
sqlite4ExprCodeGetColumnOfTable(v, pIdx->pTable, iCur, iIneq, r1);
sqlite4VdbeAddOp2(v, OP_IsNull, r1, addrCont);
}
sqlite4ReleaseTempReg(pParse, r1);
/* Record the instruction used to terminate the loop. Disable
** WHERE clause terms made redundant by the index range scan.
*/
|