sqlite3_step()

 ... This is not considered a compatibility break because any application that ever receives an SQLITE_MISUSE error is broken by definition. The SQLITE_OMIT_AUTORESET compile-time option can be used to restore the legacy behavior. Goofy Interface Alert: In the legacy interface ... 

 ... So to prevent your code from being broken by future enhancements, you should normally quote any identifier that is an English language word, even if you do not have to. The list below shows all possible keywords used by any ... 

5.3. Repositories The SQLite source is broken up into multiple repositories, each described in a separate section below.

9.1. Broken Locking Implementations  ... We have received reports of implementations of both Windows network filesystems and NFS in which locking was subtly broken. We can not verify these reports, but as locking is difficult to get right on a network filesystem we have no ... 

 ... This is because fcntl() file locking is broken on many NFS implementations. You should avoid putting SQLite database files on NFS if multiple processes might try to access the file at the same time. On Windows, Microsoft's documentation says ... 

1.6. Multi-Column Indices  ... That case does not happen in our sample data, but there is one case (fruit='Orange') where there is a tie on the first column which must be broken by the second column. Given the new multi-column Idx3 index ... 

1. Overview  ... WAL uses many fewer fsync() operations and is thus less vulnerable to problems on systems where the fsync() system call is broken. But there are also disadvantages: WAL normally requires that the VFS support shared-memory primitives. (Exception: WAL without ... 

2.1. Filesystems with broken or missing lock implementations SQLite depends on the underlying filesystem to do locking as the documentation says it will. But some filesystems contain bugs in their locking logic such that the locks do not always behave as advertised. This is especially true of network ... 

 ... Rows are first sorted based on the results of evaluating the left-most expression in the ORDER BY list, then ties are broken by evaluating the second left-most expression and so on. The order in which two rows for ... 

2. WHERE Clause Analysis The WHERE clause on a query is broken up into "terms" where each term is separated from the others by an AND operator. If the WHERE clause is composed of constraints separated by the OR operator then the entire clause ...