๐ŸŒ AIๆœ็ดข & ไปฃ็† ไธป้กต
  1. b042751 Enhance the MSVC makefile for better debugging symbol support. by mistachkin ยท 12 years ago msvcDebug
  2. ec2da85 Make sure that sqlite3SelectDup() initializes the nSelectRow of the by drh ยท 12 years ago
  3. db718d8 Fix harmless compiler warnings in the showdb utility program. by drh ยท 12 years ago
  4. 4d06798 Fix a potential over-size and hence undefined shift operation. by drh ยท 12 years ago
  5. 9c2552f Minor bugfix in main.c so that the library builds with SQLITE_OMIT_WSD defined. by dan ยท 12 years ago
  6. 705a487 Fix a couple of problems with new test scripts causing the permutations test to fail. by dan ยท 12 years ago
  7. a820c05 Update some requirements marks to conform with improvements by drh ยท 12 years ago
  8. d0879ba Fix a problem in pagerfault.test causing an assert() to fail. by dan ยท 12 years ago
  9. 7296777 Fix (harmless) duplicate variable declaration. by drh ยท 12 years ago
  10. abfe034 Fix some problems in test scripts. No code changes. by dan ยท 12 years ago
  11. b68b977 Fix a problem causing SQLITE_OMIT_COMPOUND_SELECT builds to fail. by dan ยท 12 years ago
  12. 693e671 Fixes for various clang warnings. by drh ยท 12 years ago
  13. 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
  14. 6ef5e12 Fix harmless compiler warnings in the Tcl interface. by mistachkin ยท 12 years ago
  15. 05d3dc2 Add test cases for LIMIT and ORDER BY on recursive CTEs. by dan ยท 12 years ago
  16. dc3bb0d Use an unsigned integer to accumulate the string hash. Avoids compiler by drh ยท 12 years ago
  17. 9e2c7ae Add a few more CTE test cases to closure.test. by drh ยท 12 years ago
  18. 3c2aeae Add test cases that compare the performance of the transitive_closure by drh ยท 12 years ago
  19. b090352 Add test cases showing the use of ORDER BY on a recursive query to control by drh ยท 12 years ago
  20. 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
  21. 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
  22. edf83d1 Fix harmless compiler warnings. by drh ยท 12 years ago
  23. 953dfa4 Change the WITH RECURSIVE implementation to use a queue instead of a pair of by drh ยท 12 years ago
  24. aa9ce70 Add support for LIMIT and OFFSET in a recursive query. by drh ยท 12 years ago cte-via-queue
  25. a8a0617 Update the spellfix virtual table to optimize queries of the form "SELECT ... FROM tbl WHERE rowid=?". by dan ยท 12 years ago
  26. fe1c6bb Get ORDER BY working for recursive queries. by drh ยท 12 years ago
  27. 781def2 Add new SelectDest codes, SRT_Queue and SRT_DistQueue in anticipation of adding by drh ยท 12 years ago
  28. 4102815 Fix a typo in a comment. No changes to code or tests. by dan ยท 12 years ago
  29. 340309f Remove an unnecessary parameter from selectInnerLoop(). Clean up comments. by drh ยท 12 years ago
  30. e73f059 Change the recursive common table expression algorithm to use a queue instead by drh ยท 12 years ago
  31. 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
  32. 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
  33. 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
  34. c25e2eb Remove an unused #define and add an assert(), both associated with WITH logic. by drh ยท 12 years ago
  35. 7f3068a Do not run the tests in with2.test with SQLITE_OMIT_CTE builds. by dan ยท 12 years ago
  36. 717c09c Add a sudoku solver to the recursive query tests in with1.test. by drh ยท 12 years ago
  37. 1fe3c4b Add extra test cases. No changes to code. by dan ยท 12 years ago
  38. 75303a2 Add asserts() for a couple of unreachable conditions. Add the Mandelbrot Set by drh ยท 12 years ago
  39. 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
  40. 7c82932 Add extra tests to with2.test. by dan ยท 12 years ago
  41. c59731c Minor simplification of error message text for a couple of errors associated by drh ยท 12 years ago
  42. 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
  43. a026b98 Add tests that verify that keywords WITH, WITHOUT, and RECURSIVE can still by drh ยท 12 years ago
  44. 6785bcc Fix a compiler warning in selectPopWith(). by drh ยท 12 years ago
  45. 7185694 Add support for common table expressions (WITH clauses). by dan ยท 12 years ago
  46. b290f11 Fix some problems to do with WITH clauses and name resolution. by dan ยท 12 years ago common-table-expr
  47. 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
  48. 65a2aaa Add the ability for the authorizer callback to disallow recursive queries. by drh ยท 12 years ago
  49. 727a99f Tweaks to error message text. by drh ยท 12 years ago
  50. f2655fe Improve the error messages used to report illegal recursive cte references. by dan ยท 12 years ago
  51. 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
  52. 6ade453 Always use available indices to optimize LIKE operators even if the pattern by drh ยท 12 years ago
  53. 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
  54. 7b19f25 Merge trunk changes. Fix a possible NULL-pointer deference in WITH clause by drh ยท 12 years ago
  55. 93c36bb Remove an ALWAYS() that is no longer always true. by drh ยท 12 years ago
  56. eede6a5 Fixes so that SQLITE_OMIT_CTE builds work. by dan ยท 12 years ago
  57. c49832c Further comments on WITH-clause processing routines in select.c. by drh ยท 12 years ago
  58. 60c1a2f Add a header comment to the searchWith() routine. by drh ยท 12 years ago
  59. 62ba4e4 Disable automatic indices on recursive CTE references. by dan ยท 12 years ago
  60. 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
  61. 60e7068 Return an error if a CTE specifies a different number of columns than its SELECT statement returns. by dan ยท 12 years ago
  62. a379b32 Don't try to verify the schema of transient table (such as generated inside by drh ยท 12 years ago
  63. bfe31e7 Disable the flattening optimization if the sub-query is a recursive CTE. by dan ยท 12 years ago
  64. f9db522 Use the user-supplied table name in WITH RECURSIVE tables as the internal by drh ยท 12 years ago
  65. 8ce7184 Add code to handle recursive CTEs. by dan ยท 12 years ago
  66. 7a42965 Fix harmless compiler warning in LEMON. by mistachkin ยท 12 years ago
  67. 866b53e For the Win32 VFS, defining winShmMutexHeld should be controlled by NDEBUG, not SQLITE_DEBUG. by mistachkin ยท 12 years ago
  68. c3d6ba4 In the command-line shell, defend against a NULL-pointer dereference in the by drh ยท 12 years ago
  69. 859bc54 For statements of just an unadorned VALUES clause, assign column names by drh ยท 12 years ago
  70. a9f5c13 Fix some memory leaks and crashes that could follow an OOM condition during WITH clause parsing. by dan ยท 12 years ago
  71. 4e9119d Add code to handle non-recursive CTEs in the same way as SQL views. by dan ยท 12 years ago
  72. 7d562db Update the parser so that sub-queries and CTEs may have WITH clauses. by dan ยท 12 years ago
  73. 8b47186 Parse common table expressions. But do not do anything with them (yet). by drh ยท 12 years ago
  74. 03e1b1f In LEMON, limit the size of the grammar file to 100MB. This ensures that by drh ยท 12 years ago
  75. f59b12f Optimizations to the SQL language grammar that result in a small size by drh ยท 12 years ago
  76. ecaa9d3 Add the "%token_class" directive to the LEMON parser generator. This opens up by drh ยท 12 years ago
  77. 61f92cd In LEMON, fix a bug in the text formatter introduced by the previous by drh ยท 12 years ago lemon-updates
  78. 898799f Do not use sprintf(), strcpy() or strcat() in the implementation of the by drh ยท 12 years ago
  79. 144ffe7 Remove unused structure definition from parse.y. by drh ยท 12 years ago
  80. 75593d9 Allow a VALUES clause to be used any place that a SELECT statement can be used. by drh ยท 12 years ago
  81. c740752 Fix CREATE TABLE ... AS so that it works with column names that are empty by drh ยท 12 years ago
  82. 9871c59 Fix another harmless compiler warning in unixUnfetch(). by dan ยท 12 years ago
  83. 1bcbc62 Fix harmless compiler warning in unixUnfetch(). by drh ยท 12 years ago
  84. b66e21f Fix an typo that breaks the build when SQLITE_ENABLE_TREE_EXPLAIN is defined. by drh ยท 12 years ago
  85. 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
  86. 1c2c0b7 Avoid redundant register loads during index key generation when doing a by drh ยท 12 years ago
  87. 61019c7 Omit OP_Close operations that occur immediately prior to OP_Halt and which by drh ยท 12 years ago
  88. 54e2adb Improvements to the column-cache for nested AND/OR operators. by drh ยท 12 years ago
  89. 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
  90. 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
  91. 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
  92. 5426d80 Avoid some unnecessary OP_SCopy operations when inserting into a table by drh ยท 12 years ago
  93. 759e858 Try to factor constant subcomponents of the WHERE clause out of the loop. by drh ยท 12 years ago
  94. 762c1c4 Avoid unnecessary affinity transformations when building indices using by drh ยท 12 years ago
  95. 991a198 Be more aggressive in optimizing constant conditional expressions. by drh ยท 12 years ago
  96. b00d862 Try to detect process ID changes due to fork() calls in os_unix.c and by drh ยท 12 years ago
  97. fe98081 Enhance sqlite3_randomness(N,P) such that it resets the internal PRNG by drh ยท 12 years ago
  98. 3312348 Add -I. to the main.mk makefile for building sqlite3.o and speedtest1. by drh ยท 12 years ago
  99. 73d5b8f Move elements of the Vdbe object that are only used during statement by drh ยท 12 years ago
  100. 58c9608 Remove a stray tab character. by drh ยท 12 years ago