๐ŸŒ AIๆœ็ดข & ไปฃ็† ไธป้กต
  1. ec2da85 Make sure that sqlite3SelectDup() initializes the nSelectRow of the by drh ยท 12 years ago
  2. 4d06798 Fix a potential over-size and hence undefined shift operation. by drh ยท 12 years ago
  3. 9c2552f Minor bugfix in main.c so that the library builds with SQLITE_OMIT_WSD defined. by dan ยท 12 years ago
  4. 7296777 Fix (harmless) duplicate variable declaration. by drh ยท 12 years ago
  5. b68b977 Fix a problem causing SQLITE_OMIT_COMPOUND_SELECT builds to fail. by dan ยท 12 years ago
  6. 693e671 Fixes for various clang warnings. by drh ยท 12 years ago
  7. 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
  8. 6ef5e12 Fix harmless compiler warnings in the Tcl interface. by mistachkin ยท 12 years ago
  9. dc3bb0d Use an unsigned integer to accumulate the string hash. Avoids compiler by drh ยท 12 years ago
  10. 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
  11. 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
  12. edf83d1 Fix harmless compiler warnings. by drh ยท 12 years ago
  13. aa9ce70 Add support for LIMIT and OFFSET in a recursive query. by drh ยท 12 years ago cte-via-queue
  14. fe1c6bb Get ORDER BY working for recursive queries. by drh ยท 12 years ago
  15. 781def2 Add new SelectDest codes, SRT_Queue and SRT_DistQueue in anticipation of adding by drh ยท 12 years ago
  16. 4102815 Fix a typo in a comment. No changes to code or tests. by dan ยท 12 years ago
  17. 340309f Remove an unnecessary parameter from selectInnerLoop(). Clean up comments. by drh ยท 12 years ago
  18. e73f059 Change the recursive common table expression algorithm to use a queue instead by drh ยท 12 years ago
  19. 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
  20. 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
  21. 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
  22. c25e2eb Remove an unused #define and add an assert(), both associated with WITH logic. by drh ยท 12 years ago
  23. 75303a2 Add asserts() for a couple of unreachable conditions. Add the Mandelbrot Set by drh ยท 12 years ago
  24. 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
  25. c59731c Minor simplification of error message text for a couple of errors associated by drh ยท 12 years ago
  26. 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
  27. 6785bcc Fix a compiler warning in selectPopWith(). by drh ยท 12 years ago
  28. 7185694 Add support for common table expressions (WITH clauses). by dan ยท 12 years ago
  29. b290f11 Fix some problems to do with WITH clauses and name resolution. by dan ยท 12 years ago common-table-expr
  30. 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
  31. 65a2aaa Add the ability for the authorizer callback to disallow recursive queries. by drh ยท 12 years ago
  32. 727a99f Tweaks to error message text. by drh ยท 12 years ago
  33. f2655fe Improve the error messages used to report illegal recursive cte references. by dan ยท 12 years ago
  34. 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
  35. 6ade453 Always use available indices to optimize LIKE operators even if the pattern by drh ยท 12 years ago
  36. 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
  37. 7b19f25 Merge trunk changes. Fix a possible NULL-pointer deference in WITH clause by drh ยท 12 years ago
  38. 93c36bb Remove an ALWAYS() that is no longer always true. by drh ยท 12 years ago
  39. eede6a5 Fixes so that SQLITE_OMIT_CTE builds work. by dan ยท 12 years ago
  40. c49832c Further comments on WITH-clause processing routines in select.c. by drh ยท 12 years ago
  41. 60c1a2f Add a header comment to the searchWith() routine. by drh ยท 12 years ago
  42. 62ba4e4 Disable automatic indices on recursive CTE references. by dan ยท 12 years ago
  43. 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
  44. 60e7068 Return an error if a CTE specifies a different number of columns than its SELECT statement returns. by dan ยท 12 years ago
  45. a379b32 Don't try to verify the schema of transient table (such as generated inside by drh ยท 12 years ago
  46. bfe31e7 Disable the flattening optimization if the sub-query is a recursive CTE. by dan ยท 12 years ago
  47. f9db522 Use the user-supplied table name in WITH RECURSIVE tables as the internal by drh ยท 12 years ago
  48. 8ce7184 Add code to handle recursive CTEs. by dan ยท 12 years ago
  49. 866b53e For the Win32 VFS, defining winShmMutexHeld should be controlled by NDEBUG, not SQLITE_DEBUG. by mistachkin ยท 12 years ago
  50. c3d6ba4 In the command-line shell, defend against a NULL-pointer dereference in the by drh ยท 12 years ago
  51. 859bc54 For statements of just an unadorned VALUES clause, assign column names by drh ยท 12 years ago
  52. a9f5c13 Fix some memory leaks and crashes that could follow an OOM condition during WITH clause parsing. by dan ยท 12 years ago
  53. 4e9119d Add code to handle non-recursive CTEs in the same way as SQL views. by dan ยท 12 years ago
  54. 7d562db Update the parser so that sub-queries and CTEs may have WITH clauses. by dan ยท 12 years ago
  55. 8b47186 Parse common table expressions. But do not do anything with them (yet). by drh ยท 12 years ago
  56. f59b12f Optimizations to the SQL language grammar that result in a small size by drh ยท 12 years ago
  57. 144ffe7 Remove unused structure definition from parse.y. by drh ยท 12 years ago
  58. 75593d9 Allow a VALUES clause to be used any place that a SELECT statement can be used. by drh ยท 12 years ago
  59. c740752 Fix CREATE TABLE ... AS so that it works with column names that are empty by drh ยท 12 years ago
  60. 9871c59 Fix another harmless compiler warning in unixUnfetch(). by dan ยท 12 years ago
  61. 1bcbc62 Fix harmless compiler warning in unixUnfetch(). by drh ยท 12 years ago
  62. b66e21f Fix an typo that breaks the build when SQLITE_ENABLE_TREE_EXPLAIN is defined. by drh ยท 12 years ago
  63. 1c2c0b7 Avoid redundant register loads during index key generation when doing a by drh ยท 12 years ago
  64. 61019c7 Omit OP_Close operations that occur immediately prior to OP_Halt and which by drh ยท 12 years ago
  65. 54e2adb Improvements to the column-cache for nested AND/OR operators. by drh ยท 12 years ago
  66. 5426d80 Avoid some unnecessary OP_SCopy operations when inserting into a table by drh ยท 12 years ago
  67. 759e858 Try to factor constant subcomponents of the WHERE clause out of the loop. by drh ยท 12 years ago
  68. 762c1c4 Avoid unnecessary affinity transformations when building indices using by drh ยท 12 years ago
  69. 991a198 Be more aggressive in optimizing constant conditional expressions. by drh ยท 12 years ago
  70. b00d862 Try to detect process ID changes due to fork() calls in os_unix.c and by drh ยท 12 years ago
  71. fe98081 Enhance sqlite3_randomness(N,P) such that it resets the internal PRNG by drh ยท 12 years ago
  72. 73d5b8f Move elements of the Vdbe object that are only used during statement by drh ยท 12 years ago
  73. 58c9608 Remove a stray tab character. by drh ยท 12 years ago
  74. eaf4f52 Remove a condition that is always in the logic that handles reading by drh ยท 12 years ago
  75. 6c1de30 Make sure the WhereLoop.aLTerm[] array is large enough when processing by drh ยท 12 years ago
  76. 685e3c4 Avoid compiler warnings by only enabling sqlite3ErrName() when by drh ยท 12 years ago
  77. 849a9d9 Fix the ".echo on" dot-command of the shell so that it echos comments in by drh ยท 12 years ago
  78. a47941f Fix compiler harmless warnings in tclsqlite.c that appeared with GCC 4.8.x. by drh ยท 12 years ago
  79. d42ef83 Code simplification in sqlite3GenerateIndexKey() by making use of a subroutine by drh ยท 12 years ago
  80. 4eded60 Combine adjacent single-register OP_Copy instructions into a single by drh ยท 12 years ago
  81. aed1819 Allow any arbitrary expression as the filename in an ATTACH statement, by drh ยท 12 years ago
  82. 7e61d18 Simplify the accumulator reset for aggregate query processing so that it by drh ยท 12 years ago
  83. 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
  84. f6b1a8e Make sure errors encountered while initializing extensions such as FTS4 by drh ยท 12 years ago
  85. a021f12 Remove an unneeded column-cache flush in aggregate SELECT by drh ยท 12 years ago
  86. edfac34 Omit an unnecessary OP_Null opcode from UPDATE. by drh ยท 12 years ago
  87. 46d03fc Omit one or more pointless instructions that occur in between OP_NoConflict by drh ยท 12 years ago
  88. 039468e Remove an unnecessary column-cache flush. Add another test case to the by drh ยท 12 years ago column-cache-debug
  89. 9ac7962 Show changes to the column cache when PRAGMA vdbe_addoptrace=ON is set. by drh ยท 12 years ago
  90. fc6ee9d Fix the formatting of %c in the printf() SQL function. by drh ยท 12 years ago printf-sql-function
  91. a5c1416 Add the printf() SQL function. by drh ยท 12 years ago
  92. 4a8ee3d Allow the SQLITE_DETERMINISTIC flag to be ORed into the preferred text encoding by drh ยท 12 years ago
  93. 5dee6af Performance optimizations in the pager_write() routine of pager.c. by drh ยท 12 years ago
  94. 16f9a81 Reduce the number of calls to the subjRequiresPage() routine inside of pager. by drh ยท 12 years ago
  95. da8a330 Create and use a new pager interface sqlite3PagerUnrefNotNull() that works by drh ยท 12 years ago
  96. 5d56dd2 Enhance the pcache1PinPage() routine so that it called much less often and by drh ยท 12 years ago
  97. 40f22be Avoid unnecessary calls to sqlite3_free() from within sqlite3VXPrintf(). by drh ยท 12 years ago
  98. a3cc007 Simplication and optimization of error message handling. by drh ยท 12 years ago
  99. a5f4059 Add the SQLITE_FCNTL_SYNC and SQLITE_FCNTL_COMMIT_PHASETWO file-controls by drh ยท 12 years ago
  100. 07c5d0a Merge in the latest trunk changes. by drh ยท 12 years ago zipvfs-multifile-commit