๐ŸŒ AIๆœ็ดข & ไปฃ็† ไธป้กต
  1. c81e845 Better comments on the bindvtab.c implementation. All the two-argument by drh ยท 8 years ago shell-bindings
  2. ec814a8 Add the ability to use bind parameters in the CLI. The new ".set KEY=VALUE" by drh ๏ฟฝ๏ฟฝ 8 years ago
  3. ef9e3d7 Enhance the comments in the templatevtab.c implementation. by drh ยท 8 years ago
  4. 6876dcc The previous fix for ticket [d85fffd6ffe856092ed8da] in check-in by drh ยท 8 years ago
  5. c040e2b When processing an "ORDER BY ... LIMIT" that does not use an index, check by dan ยท 8 years ago
  6. f226f03 When processing an "ORDER BY ... LIMIT" that does not use an index, check by dan ยท 8 years ago sorter-limit-opt
  7. 909066b Ensure that new.* values of an UPDATE do not get clobbered after the by drh ยท 8 years ago
  8. de7ca50 Clarification of the behavior of a BEFORE UPDATE trigger when the trigger by drh ยท 8 years ago
  9. 896494e Improved VDBE comment on the OP_Param opcode. No substantial changes. by drh ยท 8 years ago
  10. 1e08074 Update the "fuzz_malloc.test" script to print SQL statements in which OOM by dan ยท 8 years ago
  11. fc0ec3e Add new interfaces for accessing the list of SQL keywords: by drh ยท 8 years ago
  12. 7eabc44 Add the new DO and NOTHING keywords to the keyword lists maintained by drh ยท 8 years ago
  13. d11b8f6 Add the new SQLITE_SHELL_INIT_PROC compile-time entry point to the CLI. This by drh ยท 8 years ago
  14. b2c8559 Avoid many unnecessary calls to sqlite3ReadSchema() and sqlite3Init() when by drh ยท 8 years ago
  15. 3215872 Add an assert() to ensure that schema mutexes are held prior to accessing by drh ยท 8 years ago
  16. ccb9eb7 Remove a recently added NEVER() macro from a branch that can be taken in by dan ยท 8 years ago
  17. 820fcd2 Fix a problem with processing "LEFT JOIN tbl ON tbl.a = ? AND (tbl.b=? OR by dan ยท 8 years ago
  18. c447595 Do not attempt to use terms from the WHERE clause to drive indexes on the by drh ยท 8 years ago
  19. cd90ca7 Update the expert extension test cases to account for the fact that by drh ยท 8 years ago
  20. cb23e5d All the OR optimization to proceed even if the OR is also converted into by drh ยท 8 years ago
  21. 5776c13 Add a hyperlink to the ticket on the code comment for the fix to by drh ยท 8 years ago
  22. 4da04f7 Do not attempt to read values from indexes-on-expressions if the index is on by dan ยท 8 years ago
  23. 4b5345c Enhance the CLI to render EXPLAIN QUERY PLAN using an ASCII-art graph. by drh ยท 8 years ago
  24. 4d3e614 Fix a memory leak following failure to open an external CSV file in the by drh ยท 8 years ago
  25. 8349c11 In EXPLAIN QUERY PLAN output, do not show an EXECUTE LIST SUBQUERY line for by drh ยท 8 years ago
  26. 5279af8 Fix to check-in [ca34c2dd20ee071e] - avoid a NULL pointer dereference by drh ยท 8 years ago
  27. f49ff6f Fix a problem in sqlite3ExprCompare() associated with UPSERT. by drh ยท 8 years ago
  28. fbe0753 Fix a formatting issue in the TreeView output for bare expression lists. by drh ยท 8 years ago
  29. 48d219a Add the ".imposter off" variant of the ".imposter" dot-command in the CLI. by drh ยท 8 years ago
  30. f20609d The ".selecttrace 0x2000" command causes just the top-level parse tree to by drh ยท 8 years ago
  31. e2243d2 The ".selecttrace 4" command now shows only a single parse tree after by drh ยท 8 years ago
  32. 1bddf23 Do not restore the iSelectId value until after the last SELECTTRACE when by drh ยท 8 years ago
  33. b3b0d31 In the ".selecttrace" output, include the EXPLAIN QUERY PLAN iSelectId as by drh ยท 8 years ago
  34. 4751b87 Ensure that there are no bind-parameters or incorrect schema references in by drh ยท 8 years ago
  35. 05ef50d Fix an unreachable branch associated with stack overflow in the by drh ยท 8 years ago
  36. fd39c58 Performance improvements on the main loop of the LEMON-generated parser. by drh ยท 8 years ago
  37. 539e741 Enhance LEMON to track which symbols actually carry semantic content. by drh ยท 8 years ago
  38. 42d1816 A few more tests for upsert. by dan ยท 8 years ago
  39. fb32c44 Add the %extra_context directive to lemon, as an alternative to %extra_argument. by drh ยท 8 years ago
  40. f3d7bbb Fix UPSERT so that it plays nicely with AUTOINCREMENT. by drh ยท 8 years ago
  41. 9f88e6d Add the -dDIRECTORY command-line option to LEMON. by drh ยท 8 years ago
  42. 340e9e1 Enhance the "rbu" command line utility a bit. by dan ยท 8 years ago
  43. 4b8bd84 Fix a harmless compiler warning. by drh ยท 8 years ago
  44. 7c48360 Avoid the use of statement journals on DELETEs of a single row without by drh ยท 8 years ago
  45. ac9151d Avoid opening a statement journal on single-row UPDATEs without triggers or by drh ยท 8 years ago
  46. 9cadb23 Fix a VDBE comment on upsert. Provide an error message when upsert detects by drh ยท 8 years ago
  47. 224d92c Add tests for name resolution in ON CONFLICT clauses. by dan ยท 8 years ago
  48. 4da91ee Avoid unnecessary cursor seeking when performing an UPSERT. by drh ยท 8 years ago
  49. 023e897 Improved VDBE comment on UPSERT code. by drh ยท 8 years ago upsert-opt2
  50. 5deb181 Minor simplification of the previous checkin. by drh ยท 8 years ago
  51. fb2213e Avoid unnecessary cursor seeks during upsert processing. by drh ยท 8 years ago
  52. a46838c Add test cases for UPSERT. And a fix for a "REPLACE INTO ... ON CONFLICT" by dan ยท 8 years ago
  53. 7fc3aba Enhance UPSERT so that the UPDATE uses the same set of cursors as the INSERT. by drh ยท 8 years ago
  54. 2ac4e5c Minor simplification of the cursor allocation logic for update. by drh ยท 8 years ago
  55. 7963691 Fix the handling of "PRAGMA count_changes=ON" with UPSERT. Also improved by drh ยท 8 years ago
  56. 2633b28 Minor simplification to the upsert logic. by drh ยท 8 years ago
  57. a67d02f Modify a test case in zipfile2.test to take into account that with some by dan ยท 8 years ago
  58. 482dc64 Add the --upsert option to the wordcount test program. by drh ยท 8 years ago
  59. 55a3490 Add the ext/misc/tmeplatevtab.c template for virtual tables. This is a by drh ๏ฟฝ๏ฟฝ 8 years ago
  60. bb6b1ca Fix a problem in the new upsert implemention, discovered by OSSFuzz. by drh ยท 8 years ago
  61. 5e3a6eb Fix the table name aliasing on INSERT so that it occurs before the column list by drh ยท 8 years ago
  62. dedff6b Add the "sorter-reference" optimization, allowing SQLite to be configured so by dan ยท 8 years ago
  63. 52b3e34 Minor changes to test script upsert4.test. by dan ยท 8 years ago
  64. 5a2e65e Avoid a NULL-pointer deref following OOM. by drh ยท 8 years ago sorter-reference
  65. 4e8b992 Fix a test case inside distinct.test. by drh ยท 8 years ago
  66. 277434e Improved matching of COLLATE clauses within the ON CONFLICT conflict-target. by drh ยท 8 years ago
  67. 370c326 Add extra test cases for UPSERT. by dan ยท 8 years ago
  68. e79f629 Fix a problem in the sqlite3ExprCompare() function that caused two by drh ยท 8 years ago
  69. 6651e10 Add support for PostgreSQL UPSERT syntax and functionality. by drh ยท 8 years ago
  70. 5412eb5 Fix the build for SQLITE_OMIT_UPSERT by drh ยท 8 years ago upsert
  71. a90d84f Add the --sorterref N option to the CLI. by drh ยท 8 years ago
  72. bbade8d Omit some code not used without SQLITE_ENABLE_SORTER_REFERENCES. Improvements by drh ยท 8 years ago
  73. 7590d09 Remove an unused local variable. by drh ยท 8 years ago
  74. 3bc4315 Enhance ALTER TABLE ADD COLUMN to support "DEFAULT true" and "DEFAULT false". by drh ยท 8 years ago
  75. e7df892 Add checks to the CLI that issue a warning if SQLite gets initialized prior by drh ยท 8 years ago
  76. 16a4742 Fix a problem in the shell preventing it from working with by dan ยท 8 years ago
  77. 9916048 Add new testcase() macros and fix a bug that was revealed when trying to by drh ยท 8 years ago
  78. 54514c9 Remove unreachable branches. 100% MC/DC in TH3 now. by drh ยท 8 years ago
  79. 7ef8a3e Added a comment on the assert() added to the previous check-in. by drh ยท 8 years ago
  80. 7f5f306 Fixes to the logic for constraint check reordering during upsert. by drh ยท 8 years ago
  81. 2928546 During PRAGMA vdbe_addoptrace=ON, show calls to sqlite3VdbeResolveLabel() by drh ยท 8 years ago
  82. 6e341b9 TK_REGISTER expressions nodes are probably not constant. Make sure by drh ยท 8 years ago
  83. dedbc50 Simplification to the upsert logic. by drh ยท 8 years ago
  84. 2cc0042 Add some more simple test cases for UPSERT. And a minor fix. by dan ยท 8 years ago
  85. 5015c9b New test cases for upsert. by drh ยท 8 years ago
  86. 2e3a5a8 Add SQLITE_CONFIG_SORTERREF_SIZE configuration option. by dan ยท 8 years ago
  87. f1a0223 Merge the Lemon enhancement from trunk, resulting in smaller parser tables. by drh ยท 8 years ago
  88. ed0c15b Lemon enhancements: (1) Do not allocate space for the 'error' non-terminal by drh ยท 8 years ago
  89. 0a6259f Remove the MySQL upsert syntax. As an optional alias to the insert table by drh ยท 8 years ago
  90. eac9fab Add support for the "excluded.*" names in the UPDATE clause of an upsert. by drh ยท 8 years ago
  91. 1d621f7 Merge changes from trunk. by drh ยท 8 years ago
  92. f5ced1f Increase the version number to 3.24.0 by drh ยท 8 years ago
  93. 25c3b8c Reduce the size of the NameContext object by grouping seldom-used fields by drh ยท 8 years ago
  94. e966a36 Get upsert working on WITHOUT ROWID tables. by drh ยท 8 years ago
  95. 096fd47 Make sure constraint checks occur in the correct order, even in the by drh ยท 8 years ago
  96. 24e25d3 Experimental change to "SELECT * FROM ... ORDER BY" processing to load some by dan ยท 8 years ago
  97. 0b30a11 First cut at logic to perform DO UPDATE for rowid tables. by drh ยท 8 years ago
  98. 9eddaca Add infrastructure for doing an UPDATE as part of an UPSERT. Still no actual by drh ยท 8 years ago
  99. 12e40ce Merge the preupdate hook change from trunk. by drh ยท 8 years ago
  100. 54f2cd9 Remove an always-true branch from the preupdate hook logic. by drh ยท 8 years ago