- b042751 Enhance the MSVC makefile for better debugging symbol support. by mistachkin ยท 12 years ago msvcDebug
- ec2da85 Make sure that sqlite3SelectDup() initializes the nSelectRow of the by drh ยท 12 years ago
- db718d8 Fix harmless compiler warnings in the showdb utility program. 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
- 705a487 Fix a couple of problems with new test scripts causing the permutations test to fail. by dan ยท 12 years ago
- a820c05 Update some requirements marks to conform with improvements by drh ยท 12 years ago
- d0879ba Fix a problem in pagerfault.test causing an assert() to fail. by dan ยท 12 years ago
- 7296777 Fix (harmless) duplicate variable declaration. by drh ยท 12 years ago
- abfe034 Fix some problems in test scripts. No code changes. by dan ยท 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
- 05d3dc2 Add test cases for LIMIT and ORDER BY on recursive CTEs. by dan ยท 12 years ago
- dc3bb0d Use an unsigned integer to accumulate the string hash. Avoids compiler by drh ยท 12 years ago
- 9e2c7ae Add a few more CTE test cases to closure.test. by drh ยท 12 years ago
- 3c2aeae Add test cases that compare the performance of the transitive_closure by drh ยท 12 years ago
- b090352 Add test cases showing the use of ORDER BY on a recursive query to control 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
- 953dfa4 Change the WITH RECURSIVE implementation to use a queue instead of a pair of by drh ยท 12 years ago
- aa9ce70 Add support for LIMIT and OFFSET in a recursive query. by drh ยท 12 years ago cte-via-queue
- a8a0617 Update the spellfix virtual table to optimize queries of the form "SELECT ... FROM tbl WHERE rowid=?". by dan ยท 12 years ago
- 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
- 7f3068a Do not run the tests in with2.test with SQLITE_OMIT_CTE builds. by dan ยท 12 years ago
- 717c09c Add a sudoku solver to the recursive query tests in with1.test. by drh ยท 12 years ago
- 1fe3c4b Add extra test cases. No changes to code. by dan ยท 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
- 7c82932 Add extra tests to with2.test. 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
- a026b98 Add tests that verify that keywords WITH, WITHOUT, and RECURSIVE can still by drh ยท 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
- 7a42965 Fix harmless compiler warning in LEMON. by mistachkin ยท 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
- 03e1b1f In LEMON, limit the size of the grammar file to 100MB. This ensures that by drh ยท 12 years ago
- f59b12f Optimizations to the SQL language grammar that result in a small size by drh ยท 12 years ago
- ecaa9d3 Add the "%token_class" directive to the LEMON parser generator. This opens up by drh ยท 12 years ago
- 61f92cd In LEMON, fix a bug in the text formatter introduced by the previous by drh ยท 12 years ago lemon-updates
- 898799f Do not use sprintf(), strcpy() or strcat() in the implementation of the 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
- 2e08486 Add the usual "fts3" prefix to new static method setEstimatedRows() in fts3.c. This fixes a problem when compiling the amalgamation, as the r-tree module also contains a static method named setEstimatedRows. by dan ยท 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
- 8c7d4dd Have FTS assign extremely high costs to plans that feature unusable MATCH constraints. This discourages the planner from choosing such plans, which lead to "unable to use function MATCH in the requested context" errors. by dan ยท 12 years ago
- 6901439 Instead of having the planner ignore plans with unusable MATCH constraints, have FTS assign extremely high costs to such plans in order to discourage the planner from using them. by dan ยท 12 years ago avoid-unusable-match
- 4289954 Have the planner detect cases where a MATCH constraint is applied to a virtual table, and ignore any plans that do not allow the virtual table implementation to implement the MATCH filtering. by dan ยท 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
- 3312348 Add -I. to the main.mk makefile for building sqlite3.o and speedtest1. 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