2014-01-22 |
drh | Add support for LIMIT and OFFSET in a recursive query. cte-via-queue |
commit | commitdiff | tree |
2014-01-22 |
drh | Get ORDER BY working for recursive queries. |
commit | commitdiff | tree |
2014-01-22 |
drh | Add new SelectDest codes, SRT_Queue and SRT_DistQueue... |
commit | commitdiff | tree |
2014-01-22 |
dan | Fix a typo in a comment. No changes to code or tests. |
commit | commitdiff | tree |
2014-01-22 |
drh | Remove an unnecessary parameter from selectInnerLoop... |
commit | commitdiff | tree |
2014-01-21 |
drh | Change the recursive common table expression algorithm... |
commit | commitdiff | tree |
2014-01-21 |
dan | Remove the undocumented requirement for applications... |
commit | commitdiff | tree |
2014-01-20 |
dan | In where.c, do not allocate space in sqlite3_index_info... |
commit | commitdiff | tree |
2014-01-20 |
dan | Handle a few obscure problems that could manifest if... |
commit | commitdiff | tree |
2014-01-20 |
drh | Remove an unused #define and add an assert(), both... |
commit | commitdiff | tree |
2014-01-20 |
dan | Do not run the tests in with2.test with SQLITE_OMIT_CTE... |
commit | commitdiff | tree |
2014-01-18 |
drh | Add a sudoku solver to the recursive query tests in... |
commit | commitdiff | tree |
2014-01-18 |
dan | Add extra test cases. No changes to code. |
commit | commitdiff | tree |
2014-01-18 |
drh | Add asserts() for a couple of unreachable conditions... |
commit | commitdiff | tree |
2014-01-18 |
dan | Avoid spurious "no such table" errors in statements... |
commit | commitdiff | tree |
2014-01-17 |
dan | Add extra tests to with2.test. |
commit | commitdiff | tree |
2014-01-17 |
drh | Minor simplification of error message text for a couple... |
commit | commitdiff | tree |
2014-01-17 |
dan | Resolve table names within CTEs in the context in which... |
commit | commitdiff | tree |
2014-01-17 |
drh | Add tests that verify that keywords WITH, WITHOUT,... |
commit | commitdiff | tree |
2014-01-17 |
drh | Fix a compiler warning in selectPopWith(). |
commit | commitdiff | tree |
2014-01-17 |
dan | Add support for common table expressions (WITH clauses). |
commit | commitdiff | tree |
2014-01-17 |
dan | Fix some problems to do with WITH clauses and name... common-table-expr |
commit | commitdiff | tree |
2014-01-17 |
dan | Remove some code from resolve.c that was only required... |
commit | commitdiff | tree |
2014-01-16 |
drh | Add the ability for the authorizer callback to disallow... |
commit | commitdiff | tree |
2014-01-16 |
drh | Tweaks to error message text. |
commit | commitdiff | tree |
2014-01-16 |
dan | Improve the error messages used to report illegal recur... |
commit | commitdiff | tree |
2014-01-16 |
dan | Allow only a single recursive reference in a recursive... |
commit | commitdiff | tree |
2014-01-16 |
drh | Always use available indices to optimize LIKE operators... |
commit | commitdiff | tree |
2014-01-16 |
dan | Disable the flattening optimization if the parent query... |
commit | commitdiff | tree |
2014-01-16 |
drh | Merge trunk changes. Fix a possible NULL-pointer defer... |
commit | commitdiff | tree |
2014-01-15 |
drh | Remove an ALWAYS() that is no longer always true. |
commit | commitdiff | tree |
2014-01-15 |
dan | Fixes so that SQLITE_OMIT_CTE builds work. |
commit | commitdiff | tree |
2014-01-15 |
drh | Further comments on WITH-clause processing routines... |
commit | commitdiff | tree |
2014-01-15 |
drh | Add a header comment to the searchWith() routine. |
commit | commitdiff | tree |
2014-01-15 |
dan | Disable automatic indices on recursive CTE references. |
commit | commitdiff | tree |
2014-01-15 |
dan | When resolving names, consider a reference to a recursi... |
commit | commitdiff | tree |
2014-01-15 |
dan | Return an error if a CTE specifies a different number... |
commit | commitdiff | tree |
2014-01-15 |
drh | Don't try to verify the schema of transient table ... |
commit | commitdiff | tree |
2014-01-15 |
dan | Disable the flattening optimization if the sub-query... |
commit | commitdiff | tree |
2014-01-15 |
drh | Use the user-supplied table name in WITH RECURSIVE... |
commit | commitdiff | tree |
2014-01-14 |
dan | Add code to handle recursive CTEs. |
commit | commitdiff | tree |
2014-01-14 |
mistachkin | Fix harmless compiler warning in LEMON. |
commit | commitdiff | tree |
2014-01-14 |
mistachkin | For the Win32 VFS, defining winShmMutexHeld should... |
commit | commitdiff | tree |
2014-01-13 |
drh | In the command-line shell, defend against a NULL-pointe... |
commit | commitdiff | tree |
2014-01-13 |
drh | For statements of just an unadorned VALUES clause,... |
commit | commitdiff | tree |
2014-01-13 |
dan | Fix some memory leaks and crashes that could follow... |
commit | commitdiff | tree |
2014-01-13 |
dan | Add code to handle non-recursive CTEs in the same way... |
commit | commitdiff | tree |
2014-01-11 |
dan | Update the parser so that sub-queries and CTEs may... |
commit | commitdiff | tree |
2014-01-11 |
drh | Parse common table expressions. But do not do anything... |
commit | commitdiff | tree |
2014-01-11 |
drh | In LEMON, limit the size of the grammar file to 100MB... |
commit | commitdiff | tree |
2014-01-11 |
drh | Optimizations to the SQL language grammar that result... |
commit | commitdiff | tree |
2014-01-11 |
drh | Add the "%token_class" directive to the LEMON parser... |
commit | commitdiff | tree |
2014-01-11 |
drh | In LEMON, fix a bug in the text formatter introduced... lemon-updates |
commit | commitdiff | tree |
2014-01-10 |
drh | Do not use sprintf(), strcpy() or strcat() in the imple... |
commit | commitdiff | tree |
2014-01-10 |
drh | Remove unused structure definition from parse.y. |
commit | commitdiff | tree |
2014-01-10 |
drh | Allow a VALUES clause to be used any place that a SELEC... |
commit | commitdiff | tree |
2014-01-10 |
drh | Fix CREATE TABLE ... AS so that it works with column... |
commit | commitdiff | tree |
2014-01-10 |
dan | Fix another harmless compiler warning in unixUnfetch(). |
commit | commitdiff | tree |
2014-01-09 |
drh | Fix harmless compiler warning in unixUnfetch(). |
commit | commitdiff | tree |
2014-01-04 |
drh | Fix an typo that breaks the build when SQLITE_ENABLE_TR... |
commit | commitdiff | tree |
2014-01-04 |
dan | Add the usual "fts3" prefix to new static method setEst... |
commit | commitdiff | tree |
2014-01-04 |
drh | Avoid redundant register loads during index key generat... |
commit | commitdiff | tree |
2014-01-04 |
drh | Omit OP_Close operations that occur immediately prior... |
commit | commitdiff | tree |
2014-01-04 |
drh | Improvements to the column-cache for nested AND/OR... |
commit | commitdiff | tree |
2014-01-04 |
dan | Have FTS assign extremely high costs to plans that... |
commit | commitdiff | tree |
2014-01-04 |
dan | Instead of having the planner ignore plans with unusabl... avoid-unusable-match |
commit | commitdiff | tree |
2014-01-04 |
dan | Have the planner detect cases where a MATCH constraint... |
commit | commitdiff | tree |
2014-01-03 |
drh | Avoid some unnecessary OP_SCopy operations when inserti... |
commit | commitdiff | tree |
2014-01-02 |
drh | Try to factor constant subcomponents of the WHERE claus... |
commit | commitdiff | tree |
2014-01-02 |
drh | Avoid unnecessary affinity transformations when buildin... |
commit | commitdiff | tree |
2014-01-02 |
drh | Be more aggressive in optimizing constant conditional... |
commit | commitdiff | tree |
2014-01-01 |
drh | Try to detect process ID changes due to fork() calls... |
commit | commitdiff | tree |
2014-01-01 |
drh | Enhance sqlite3_randomness(N,P) such that it resets... |
commit | commitdiff | tree |
2013-12-24 |
drh | Add -I. to the main.mk makefile for building sqlite3... |
commit | commitdiff | tree |
2013-12-23 |
drh | Move elements of the Vdbe object that are only used... |
commit | commitdiff | tree |
2013-12-23 |
drh | Remove a stray tab character. |
commit | commitdiff | tree |
2013-12-22 |
drh | Remove a condition that is always in the logic that... |
commit | commitdiff | tree |
2013-12-22 |
drh | Make sure the WhereLoop.aLTerm[] array is large enough... |
commit | commitdiff | tree |
2013-12-21 |
drh | Fix speedtest1.c so that in --explain mode it only... |
commit | commitdiff | tree |
2013-12-21 |
drh | Avoid compiler warnings by only enabling sqlite3ErrName... |
commit | commitdiff | tree |
2013-12-21 |
drh | Fix harmless compiler warnings in FTS4. This involved... |
commit | commitdiff | tree |
2013-12-21 |
drh | Fix the ".echo on" dot-command of the shell so that... |
commit | commitdiff | tree |
2013-12-21 |
drh | Add a case to speedtest1.c that demonstrates the need... |
commit | commitdiff | tree |
2013-12-20 |
drh | Fix compiler harmless warnings in tclsqlite.c that... |
commit | commitdiff | tree |
2013-12-20 |
drh | Code simplification in sqlite3GenerateIndexKey() by... |
commit | commitdiff | tree |
2013-12-20 |
drh | Combine adjacent single-register OP_Copy instructions... |
commit | commitdiff | tree |
2013-12-20 |
drh | Allow any arbitrary expression as the filename in an... |
commit | commitdiff | tree |
2013-12-20 |
drh | Simplify the accumulator reset for aggregate query... |
commit | commitdiff | tree |
2013-12-19 |
dan | Do not inject OOM faults into SQLITE_FCNTL_COMMIT_PHASE... |
commit | commitdiff | tree |
2013-12-19 |
drh | Make sure errors encountered while initializing extensi... |
commit | commitdiff | tree |
2013-12-19 |
drh | Remove an unneeded column-cache flush in aggregate... |
commit | commitdiff | tree |
2013-12-19 |
drh | Omit an unnecessary OP_Null opcode from UPDATE. |
commit | commitdiff | tree |
2013-12-19 |
drh | Omit one or more pointless instructions that occur... |
commit | commitdiff | tree |
2013-12-18 |
drh | Remove an unnecessary column-cache flush operation... |
commit | commitdiff | tree |
2013-12-18 |
drh | Remove an unnecessary column-cache flush. Add another... column-cache-debug |
commit | commitdiff | tree |
2013-12-18 |
drh | Show changes to the column cache when PRAGMA vdbe_addop... |
commit | commitdiff | tree |
2013-12-17 |
drh | Add evidence marks and additional test cases for the... |
commit | commitdiff | tree |
2013-12-17 |
drh | Add the printf() SQL function. |
commit | commitdiff | tree |
2013-12-17 |
drh | Fix the formatting of %c in the printf() SQL function. printf-sql-function |
commit | commitdiff | tree |
2013-12-17 |
drh | Add the printf() SQL function. |
commit | commitdiff | tree |
next |