Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Changes In Branch index-info-on-table Excluding Merge-Ins
This is equivalent to a diff from b1158564 to fe49fb03
|
2016-10-26
| ||
| 13:58 | Merge the SQLITE_ENABLE_URI_00_ERROR compile-time option. (check-in: 86675ae0 user: drh tags: trunk) | |
| 12:15 | Add compile time option SQLITE_ENABLE_URI_00_ERROR. If defined, any "%00" escape found in a URI is treated as an error. (check-in: e8a9bfec user: dan tags: uri-00-error) | |
|
2016-10-25
| ||
| 17:28 | Merge recent trunk changes, and especially the PRAGMA index_info enhancement which is needed on this branch. (check-in: c3570e46 user: drh tags: est_count_pragma) | |
| 15:39 | Enhance the "PRAGMA index_info" and "PRAGMA index_xinfo" statements so that they work on WITHOUT ROWID tables and provide information about the underlying index btree that implements the WITHOUT ROWID table. (Leaf check-in: fe49fb03 user: drh tags: index-info-on-table) | |
| 15:06 | Add test case to demonstrate a "BEGIN EXCLUSIVE" command returning SQLITE_BUSY_SNAPSHOT. (check-in: b1158564 user: dan tags: trunk) | |
|
2016-10-24
| ||
| 01:01 | Performance optimization in moveToRoot(). Avoid repeated validity checking of the root page on each call. Once is enough. (check-in: 98795c2d user: drh tags: trunk) | |
Changes to src/pragma.c.
| ︙ | |||
1118 1119 1120 1121 1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 | 1118 1119 1120 1121 1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 | + + + + |
}
break;
case PragTyp_INDEX_INFO: if( zRight ){
Index *pIdx;
Table *pTab;
pIdx = sqlite3FindIndex(db, zRight, zDb);
if( pIdx==0 ){
pTab = sqlite3FindTable(db, zRight, zDb);
if( pTab && !HasRowid(pTab) ) pIdx = sqlite3PrimaryKeyIndex(pTab);
}
if( pIdx ){
static const char *azCol[] = {
"seqno", "cid", "name", "desc", "coll", "key"
};
int i;
int mx;
if( pPragma->iArg ){
|
| ︙ |
Changes to test/without_rowid1.test.
| ︙ | |||
323 324 325 326 327 328 329 330 331 332 | 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 | + + + + + + + + + + + + + + + + + + + |
} {1 {CHECK constraint failed: t70a}}
do_catchsql_test 7.3 {
CREATE TABLE t70b(
a INT CHECK( rowid!=33 ),
b TEXT PRIMARY KEY
) WITHOUT ROWID;
} {1 {no such column: rowid}}
# The PRAGMA index_info and index_xinfo pragmas work on
# WITHOUT ROWID tables too, but not on rowid tables.
#
do_execsql_test 8.1 {
CREATE TABLE t80a(a TEXT, b INT, c BLOB, PRIMARY KEY(c,b));
PRAGMA index_info(t80a);
} {}
do_execsql_test 8.2 {
PRAGMA index_xinfo(t80a);
} {}
do_execsql_test 8.3 {
CREATE TABLE t80b(a TEXT, b INT, c BLOB, PRIMARY KEY(c,b)) WITHOUT ROWID;
PRAGMA index_info(t80b);
} {0 2 c 1 1 b}
do_execsql_test 8.4 {
PRAGMA index_xinfo(t80b);
} {0 2 c 0 BINARY 1 1 1 b 0 BINARY 1 2 0 a 0 BINARY 0}
finish_test
|