- ec2da85 Make sure that sqlite3SelectDup() initializes the nSelectRow of the by drh ยท 12 years ago
- 4d06798 Fix a potential over-size and hence undefined shift operation. by drh ยท 12 years ago
- 9c2552f Minor bugfix in main.c so that the library builds with SQLITE_OMIT_WSD defined. by dan ยท 12 years ago
- 7296777 Fix (harmless) duplicate variable declaration. by drh ยท 12 years ago
- b68b977 Fix a problem causing SQLITE_OMIT_COMPOUND_SELECT builds to fail. by dan ยท 12 years ago
- 693e671 Fixes for various clang warnings. by drh ยท 12 years ago
- 53bed45 Select collation sequences for ORDER BY expressions attached to recursive CTEs in the same way as they are selected for other compound SELECT statements. by dan ยท 12 years ago
- 6ef5e12 Fix harmless compiler warnings in the Tcl interface. by mistachkin ยท 12 years ago
- dc3bb0d Use an unsigned integer to accumulate the string hash. Avoids compiler by drh ยท 12 years ago
- afcf9bd Modifications to test files to omit any tests that intentionally access out-of-bounds locations in clang -fsanitize=address builds. by dan ยท 12 years ago
- cfe2458 Avoid an extra seek when inserting records into the epheremal index used to ensure that rows returned by UNION recursive queries are unique. by dan ยท 12 years ago
- edf83d1 Fix harmless compiler warnings. by drh ยท 12 years ago
- aa9ce70 Add support for LIMIT and OFFSET in a recursive query. by drh ยท 12 years ago cte-via-queue
- fe1c6bb Get ORDER BY working for recursive queries. by drh ยท 12 years ago
- 781def2 Add new SelectDest codes, SRT_Queue and SRT_DistQueue in anticipation of adding by drh ยท 12 years ago
- 4102815 Fix a typo in a comment. No changes to code or tests. by dan ยท 12 years ago
- 340309f Remove an unnecessary parameter from selectInnerLoop(). Clean up comments. by drh ยท 12 years ago
- e73f059 Change the recursive common table expression algorithm to use a queue instead by drh ยท 12 years ago
- 8561c81 Remove the undocumented requirement for applications that use an SQLITE_ENABLE_SQLLOG build to define a sqlite3_init_sqllog() function. by dan ยท 12 years ago
- a4ff825 In where.c, do not allocate space in sqlite3_index_info structures for the internal WHERE clause "terms" generated to record column equivalencies. by dan ยท 12 years ago
- 7df42ab Handle a few obscure problems that could manifest if a database corrupted in a certain way was written by a connection in the middle of a SELECT statement on the same db. by dan ยท 12 years ago
- c25e2eb Remove an unused #define and add an assert(), both associated with WITH logic. by drh ยท 12 years ago
- 75303a2 Add asserts() for a couple of unreachable conditions. Add the Mandelbrot Set by drh ยท 12 years ago
- ebbf08a Avoid spurious "no such table" errors in statements of the form "INSERT INTO tbl WITH xxx AS (...) SELECT * FROM xxx". by dan ยท 12 years ago
- c59731c Minor simplification of error message text for a couple of errors associated by drh ยท 12 years ago
- 98f45e5 Resolve table names within CTEs in the context in which the CTE is declared, not the context in which it is used. by dan ยท 12 years ago
- 6785bcc Fix a compiler warning in selectPopWith(). by drh ยท 12 years ago
- 7185694 Add support for common table expressions (WITH clauses). by dan ยท 12 years ago
- b290f11 Fix some problems to do with WITH clauses and name resolution. by dan ยท 12 years ago common-table-expr
- 2d4dc5f Remove some code from resolve.c that was only required for recursive cte references in sub-queries. Also a stray "finish_test" command in pagerfault.test. by dan ยท 12 years ago
- 65a2aaa Add the ability for the authorizer callback to disallow recursive queries. by drh ยท 12 years ago
- 727a99f Tweaks to error message text. by drh ยท 12 years ago
- f2655fe Improve the error messages used to report illegal recursive cte references. by dan ยท 12 years ago
- eae73fb Allow only a single recursive reference in a recursive CTE. Also require that this reference is not part of a sub-query. by dan ยท 12 years ago
- 6ade453 Always use available indices to optimize LIKE operators even if the pattern by drh ยท 12 years ago
- 8290c2a Disable the flattening optimization if the parent query is the recursive part of a recursive CTE and the sub-query is a compound query. by dan ยท 12 years ago
- 7b19f25 Merge trunk changes. Fix a possible NULL-pointer deference in WITH clause by drh ยท 12 years ago
- 93c36bb Remove an ALWAYS() that is no longer always true. by drh ยท 12 years ago
- eede6a5 Fixes so that SQLITE_OMIT_CTE builds work. by dan ยท 12 years ago
- c49832c Further comments on WITH-clause processing routines in select.c. by drh ยท 12 years ago
- 60c1a2f Add a header comment to the searchWith() routine. by drh ยท 12 years ago
- 62ba4e4 Disable automatic indices on recursive CTE references. by dan ยท 12 years ago
- f43fe6e When resolving names, consider a reference to a recursive CTE column as equivalent to a reference to the outermost name-context. This ensures that correlated sub-queries are correctly identified as such. by dan ยท 12 years ago
- 60e7068 Return an error if a CTE specifies a different number of columns than its SELECT statement returns. by dan ยท 12 years ago
- a379b32 Don't try to verify the schema of transient table (such as generated inside by drh ยท 12 years ago
- bfe31e7 Disable the flattening optimization if the sub-query is a recursive CTE. by dan ยท 12 years ago
- f9db522 Use the user-supplied table name in WITH RECURSIVE tables as the internal by drh ยท 12 years ago
- 8ce7184 Add code to handle recursive CTEs. by dan ยท 12 years ago
- 866b53e For the Win32 VFS, defining winShmMutexHeld should be controlled by NDEBUG, not SQLITE_DEBUG. by mistachkin ยท 12 years ago
- c3d6ba4 In the command-line shell, defend against a NULL-pointer dereference in the by drh ยท 12 years ago
- 859bc54 For statements of just an unadorned VALUES clause, assign column names by drh ยท 12 years ago
- a9f5c13 Fix some memory leaks and crashes that could follow an OOM condition during WITH clause parsing. by dan ยท 12 years ago
- 4e9119d Add code to handle non-recursive CTEs in the same way as SQL views. by dan ยท 12 years ago
- 7d562db Update the parser so that sub-queries and CTEs may have WITH clauses. by dan ยท 12 years ago
- 8b47186 Parse common table expressions. But do not do anything with them (yet). by drh ยท 12 years ago
- f59b12f Optimizations to the SQL language grammar that result in a small size by drh ยท 12 years ago
- 144ffe7 Remove unused structure definition from parse.y. by drh ยท 12 years ago
- 75593d9 Allow a VALUES clause to be used any place that a SELECT statement can be used. by drh ยท 12 years ago
- c740752 Fix CREATE TABLE ... AS so that it works with column names that are empty by drh ยท 12 years ago
- 9871c59 Fix another harmless compiler warning in unixUnfetch(). by dan ยท 12 years ago
- 1bcbc62 Fix harmless compiler warning in unixUnfetch(). by drh ยท 12 years ago
- b66e21f Fix an typo that breaks the build when SQLITE_ENABLE_TREE_EXPLAIN is defined. by drh ยท 12 years ago
- 1c2c0b7 Avoid redundant register loads during index key generation when doing a by drh ยท 12 years ago
- 61019c7 Omit OP_Close operations that occur immediately prior to OP_Halt and which by drh ยท 12 years ago
- 54e2adb Improvements to the column-cache for nested AND/OR operators. by drh ยท 12 years ago
- 5426d80 Avoid some unnecessary OP_SCopy operations when inserting into a table by drh ยท 12 years ago
- 759e858 Try to factor constant subcomponents of the WHERE clause out of the loop. by drh ยท 12 years ago
- 762c1c4 Avoid unnecessary affinity transformations when building indices using by drh ยท 12 years ago
- 991a198 Be more aggressive in optimizing constant conditional expressions. by drh ยท 12 years ago
- b00d862 Try to detect process ID changes due to fork() calls in os_unix.c and by drh ยท 12 years ago
- fe98081 Enhance sqlite3_randomness(N,P) such that it resets the internal PRNG by drh ยท 12 years ago
- 73d5b8f Move elements of the Vdbe object that are only used during statement by drh ยท 12 years ago
- 58c9608 Remove a stray tab character. by drh ยท 12 years ago
- eaf4f52 Remove a condition that is always in the logic that handles reading by drh ยท 12 years ago
- 6c1de30 Make sure the WhereLoop.aLTerm[] array is large enough when processing by drh ยท 12 years ago
- 685e3c4 Avoid compiler warnings by only enabling sqlite3ErrName() when by drh ยท 12 years ago
- 849a9d9 Fix the ".echo on" dot-command of the shell so that it echos comments in by drh ยท 12 years ago
- a47941f Fix compiler harmless warnings in tclsqlite.c that appeared with GCC 4.8.x. by drh ยท 12 years ago
- d42ef83 Code simplification in sqlite3GenerateIndexKey() by making use of a subroutine by drh ยท 12 years ago
- 4eded60 Combine adjacent single-register OP_Copy instructions into a single by drh ยท 12 years ago
- aed1819 Allow any arbitrary expression as the filename in an ATTACH statement, by drh ยท 12 years ago
- 7e61d18 Simplify the accumulator reset for aggregate query processing so that it by drh ยท 12 years ago
- 1001ee8 Do not inject OOM faults into SQLITE_FCNTL_COMMIT_PHASE_TWO file-control invocations. It causes problems for test scripts. by dan ยท 12 years ago
- f6b1a8e Make sure errors encountered while initializing extensions such as FTS4 by drh ยท 12 years ago
- a021f12 Remove an unneeded column-cache flush in aggregate SELECT by drh ยท 12 years ago
- edfac34 Omit an unnecessary OP_Null opcode from UPDATE. by drh ยท 12 years ago
- 46d03fc Omit one or more pointless instructions that occur in between OP_NoConflict by drh ยท 12 years ago
- 039468e Remove an unnecessary column-cache flush. Add another test case to the by drh ยท 12 years ago column-cache-debug
- 9ac7962 Show changes to the column cache when PRAGMA vdbe_addoptrace=ON is set. by drh ยท 12 years ago
- fc6ee9d Fix the formatting of %c in the printf() SQL function. by drh ยท 12 years ago printf-sql-function
- a5c1416 Add the printf() SQL function. by drh ยท 12 years ago
- 4a8ee3d Allow the SQLITE_DETERMINISTIC flag to be ORed into the preferred text encoding by drh ยท 12 years ago
- 5dee6af Performance optimizations in the pager_write() routine of pager.c. by drh ยท 12 years ago
- 16f9a81 Reduce the number of calls to the subjRequiresPage() routine inside of pager. by drh ยท 12 years ago
- da8a330 Create and use a new pager interface sqlite3PagerUnrefNotNull() that works by drh ยท 12 years ago
- 5d56dd2 Enhance the pcache1PinPage() routine so that it called much less often and by drh ยท 12 years ago
- 40f22be Avoid unnecessary calls to sqlite3_free() from within sqlite3VXPrintf(). by drh ยท 12 years ago
- a3cc007 Simplication and optimization of error message handling. by drh ยท 12 years ago
- a5f4059 Add the SQLITE_FCNTL_SYNC and SQLITE_FCNTL_COMMIT_PHASETWO file-controls by drh ยท 12 years ago
- 07c5d0a Merge in the latest trunk changes. by drh ยท 12 years ago zipvfs-multifile-commit