๐ŸŒ AIๆœ็ดข & ไปฃ็† ไธป้กต
Google Git
Sign in
chromium / external / github.com / sqlite / sqlite / refs/heads/right-join-fix
  1. c504f67 Previous check-in accidentally inverted a test on an assert(). Fix that. by drh ยท 3 years, 8 months ago right-join-fix
  2. eab6c12 Fix assert() statements associated with artifical null-value cursors by drh ยท 3 years, 8 months ago
  3. 95b1036 Fix a harmless (false-positive) unused variable compiler warning on MSVC. by drh ยท 3 years, 8 months ago
  4. b60d1fb Make the sqlite3TreeViewSrcList() routine a no-op if called with a by drh ยท 3 years, 8 months ago
  5. 7c96039 Fix an assert() in OP_Column so that it accounts for the new type of by drh ยท 3 years, 8 months ago
  6. 3ac6243 If the OP_NullRow opcode is given a cursor that has not yet been opened, by drh ยท 3 years, 8 months ago
  7. f7ecd95 Move the explain comment for the RIGHT-JOIN post-processing loop to the by drh ยท 3 years, 8 months ago
  8. 94e615a Add support for RIGHT and FULL OUTER JOINs. by drh ยท 3 years, 8 months ago
  9. 12c35ec The rows of a RIGHT JOIN might come out in any arbitrary order. So disable by drh ยท 3 years, 8 months ago
  10. 3b79f75 Fix an assert() in btree.c that might not be true for a corrupt database file. by drh ยท 3 years, 8 months ago
  11. 146e64d Add missing VdbeCoverage() macros on new branch byte-code opcodes. by drh ยท 3 years, 8 months ago
  12. f7309bc Ensure that the JT_LTORJ bit in the SrcItem.fg.jointype is preserved during by drh ยท 3 years, 8 months ago
  13. 0879d5f For the bad join type error message "unknown or unsupported join type" by drh ยท 3 years, 8 months ago
  14. 949e2ab Factor out the RIGHT JOIN non-matched row loop from sqlite3WhereEnd(). This by drh ยท 3 years, 8 months ago
  15. 57d4b5b Merge the latest enhancements from trunk into the right-join branch. by drh ยท 3 years, 8 months ago
  16. 6625d6d Earlier detection of corruption in balance_nonroot(). dbsqlfuzz 9191ade77ebd3b7a3356e074957aa85b0c669d14. by dan ยท 3 years, 8 months ago
  17. 61dac44 The multi-index OR optimization does not work for RIGHT join, so disallow it. by drh ยท 3 years, 8 months ago
  18. a707824 Always explicitly set each table cursor to NullRow before doing the RIGHT-JOIN by drh ยท 3 years, 8 months ago
  19. f7413d9 Modify utility function sqlite3SetString() so that it may be used safely on Parse.zErrMsg. Fuzzer test case "crash-1604e5d76c92574e21e437049dab9b672e06b767.txt". by dan ยท 3 years, 8 months ago
  20. b087de0 Fix RIGHT JOIN for virtual tables. by drh ยท 3 years, 8 months ago
  21. c133bab The query flattener must add TK_IF_NULL_ROW opcodes on substituted values by drh ยท 3 years, 8 months ago
  22. ec27077 New test cases added. by drh ยท 3 years, 8 months ago
  23. 6134b2d Fix handling of "continue" and "break" from inside the loop for the right by drh ยท 3 years, 8 months ago
  24. ff02ac7 Do not attempt the LEFT JOIN strength reduction optimization on a FULL JOIN. by drh ยท 3 years, 8 months ago
  25. c583719 Show LEFT and RIGHT JOIN processing in the EXPLAIN QUERY PLAN output. by drh ยท 3 years, 8 months ago
  26. 37259f4 New test cases. by drh ยท 3 years, 8 months ago
  27. 3a6e4c5 Make a distinction between (1) WHERE clause constraints, (2) ON/USING by drh ยท 3 years, 8 months ago
  28. b77c07a Fix some comments that refer to LEFT JOIN that should refer to OUTER JOIN. by drh ๏ฟฝ๏ฟฝ 3 years, 8 months ago
  29. 189c065 Merge the Expr.w.iJoin name change from trunk into the right-join branch. by drh ยท 3 years, 8 months ago
  30. d198526 Rename the Expr.w.iRightJoinTable to just Expr.w.iJoin, so that the words by drh ยท 3 years, 8 months ago
  31. 79d2658 Ensure that the JT_LTORJ flag is preserved when flattening a subquery that by drh ยท 3 years, 8 months ago
  32. 8a28ce7 Show the JT_LTORJ flag in TreeView debugging output. by drh ยท 3 years, 8 months ago
  33. 41798d5 Do not allow query flattening nor the push-down optimization on the by drh ยท 3 years, 8 months ago
  34. 529394e Cannot use an automatic index on the right table of a RIGHT JOIN because by drh ยท 3 years, 8 months ago
  35. 9debb58 Revisit [f84b2beca7197589]: disallow co-routine implementations of tables by drh ยท 3 years, 8 months ago
  36. 62ed36b Minor improvements to the sqlite3SrcListShiftJoinType() routine. This started by drh ยท 3 years, 8 months ago
  37. fcde633 When the left-most table of a RIGHT JOIN is implemented as a co-routine, by drh ยท 3 years, 8 months ago
  38. e21e36d More test cases and bug fixes. by drh ยท 3 years, 8 months ago
  39. a20c71e More RIGHT JOIN test cases and a bug fix. by drh ยท 3 years, 8 months ago
  40. ac8c438 Add a simple test case. (It is not difficult to create additional test by drh ยท 3 years, 8 months ago
  41. 039132b Fix .import bug reported at https://sqlite.org/forum/forumpost/14db09d7e765b819 . zAutoColumn made to deliver characters, not bytes. by larrybr ยท 3 years, 8 months ago
  42. de24dd7 Bug fixes. A basic FULL OUTER JOIN now works. by drh ยท 3 years, 8 months ago
  43. 86c1beb Add byte-code that computes unmatched rows on the right table of a RIGHT JOIN. by drh ยท 3 years, 8 months ago
  44. 7c1734b The interior of the RIGHT JOIN loop is now a subroutine. by drh ยท 3 years, 8 months ago
  45. c2308ad A few bits and bobs of code generation toward getting RIGHT JOIN to work. by drh ยท 3 years, 8 months ago
  46. c187163 Merge the sqlite3WhereMalloc() routine from trunk into the right-join branch. by drh ยท 3 years, 8 months ago
  47. f8bdcfa The sqlite3WhereMalloc() routine allocates memory that is automatically by drh ยท 3 years, 8 months ago
  48. a76ac88 Preliminary code to support RIGHT JOIN. Everything seems to work, except that by drh ยท 3 years, 8 months ago
  49. 7d0ae00 Enhance the sqlite_dbpage fix at [/info/642a0b4752743216|check-in 642a0b4752743] by drh ยท 3 years, 8 months ago
  50. 81a2362 Improved explanation and commentary on the sqlite3JoinType() routine. One by drh ยท 3 years, 8 months ago
  51. ce5dd9e Fix two unreachable branches introduced by the recent by drh ยท 3 years, 8 months ago
  52. e603ab0 Enhance the EXPLAIN output formatting in the CLI so that the subroutine that by drh ยท 3 years, 8 months ago
  53. da4c7cc The ".testctrl optimizations 0x400000" command disables the generation of by drh ยท 3 years, 8 months ago
  54. db08a6d Fix the parsing of C-style comments in Lemon, as reported by by drh ยท 3 years, 8 months ago
  55. a744167 Optimization to sqlite3TriggersExist() saves over 700K CPU cycles. by drh ยท 3 years, 8 months ago
  56. 4cd8296 Avoid compiler warnings about the new sqlite3Show() debugging routines by drh ยท 3 years, 8 months ago
  57. 9c949b1 Omit an unnecessary initialization in tokenExpr(). by drh ยท 3 years, 8 months ago
  58. c381056 Fix harmless compiler warnings. by drh ยท 3 years, 8 months ago
  59. d44f8b2 Improved technique for parsing the ON and USING clauses of a join is faster by drh ยท 3 years, 8 months ago
  60. 200adc9 Faster parsing of the FROM clause in joins for the common case where there by drh ยท 3 years, 8 months ago
  61. c2d0df9 Improvements to the display of AST for DML statements. by drh ยท 3 years, 8 months ago
  62. 2a7dcbf Attempt to show triggers in the TreeView output from DELETE, INSERT, and by drh ยท 3 years, 8 months ago
  63. c16a568 Corrections and updates to the header comment describing the by drh ยท 3 years, 8 months ago
  64. 8f1eb6f Add the sqlite3Show() family of debugging interfaces under SQLITE_DEBUG. by drh ยท 3 years, 8 months ago
  65. 5e431be Rename debugging defines and variables from SELECTTRACE to TREETRACE (and by drh ยท 3 years, 8 months ago
  66. f8ef2db Add additional tree display routines for DELETE and UPDATE. No changes by drh ยท 3 years, 8 months ago
  67. 7d2c1d2 Add new diagnostic "sqlite3TreeView" routines for IdList, Upsert, and for by drh ยท 3 years, 8 months ago
  68. ec534e6 Small performance and size improvement to OP_Found. by drh ยท 3 years, 8 months ago
  69. 50f22d1 Tag an always-taken branch using ALWAYS(). by drh ยท 3 years, 8 months ago
  70. b834e0d Optimizations to the OP_Found opcode save about 600K cycles in speedtest1. by drh ยท 3 years, 8 months ago
  71. 36d2d09 Use unpacked keys for OP_Found in foreign key processing. by drh ยท 3 years, 8 months ago
  72. 0de10ac When constructing the JSON Path for the "fullpath" column of the by drh ยท 3 years, 8 months ago
  73. b07fb4f1c Fix the JSON Path parser so that it will accept zero-length object labels. by drh ยท 3 years, 8 months ago
  74. a81a9f7 Performance optimization and stronger assert()s in the comparison opcodes. by drh ยท 3 years, 8 months ago
  75. 1c84863 Only invoke sqlite3VdbeClearObject() from a single location, so that the by drh ยท 3 years, 8 months ago
  76. 8703edd Performance optimization in the sqlite3VdbeHalt() routine. by drh ยท 3 years, 8 months ago
  77. 8bb93da Performance optimization and size reduction in the OP_Halt opcode. by drh ยท 3 years, 8 months ago
  78. 18bcfb9 Omit the Vdbe.runOnlyOnce flag (simplifying the prepared statement by drh ยท 3 years, 8 months ago
  79. 8ee75f7 Performance optimization and slight size reduction in the OP_Transaction opcode. by drh ยท 3 years, 8 months ago
  80. c2808f3 Expand the getVarint32() macro in a few places, as the C-compiler seems to by drh ยท 3 years, 8 months ago
  81. 1f416db Fix harmless compiler warnings. by drh ยท 3 years, 8 months ago
  82. d13527d Ensure that a zero-blob does not cause in invocation of memcpy() with a by drh ยท 3 years, 8 months ago
  83. 2c144b0 Minor loop optimization in OP_MakeRecord. by drh ยท 3 years, 8 months ago
  84. d859dc2 In-line the sqlite3VdbeSerialPut() routine into the OP_MakeRecord opcode. by drh ยท 3 years, 8 months ago
  85. b47b1f6 The putVarint32() macro does not optimize well. So expand it into in-line by drh ๏ฟฝ๏ฟฝ 3 years, 9 months ago
  86. 759e507 Loop optimization in the OP_MakeRecord opcode. by drh ยท 3 years, 9 months ago
  87. 3b8b5be It is not necessary to de-ephermeralize the output registers in the by drh ยท 3 years, 9 months ago
  88. 35e9e35 There is no need for sqlite3_step() to check for an OOM condition prior by drh ยท 3 years, 9 months ago
  89. a24832b Omit the Vdbe.doingRerun field for a slight size reduction and performance gain. by drh ยท 3 years, 9 months ago
  90. cf6e3fd New macro ROUND8P() which works like ROUND8() but assumes that the input is by drh ยท 3 years, 9 months ago
  91. 473571b Provide and use a version of sqlite3VdbeFreeCursor() that guarantees the by drh ยท 3 years, 9 months ago
  92. 2fb448f Remove an unnecessary branch from sqlite3VdbeReset(). by drh ยท 3 years, 9 months ago
  93. 17c4865 Refactor the Vdbe.iVdbeMagic field into Vdbe.eVdbeState. Split the RUNNING by drh ยท 3 years, 9 months ago
  94. 00946d7 Avoid a harmless uninitialized variable warning in PRAGMA incremental_vacuum. by drh ยท 3 years, 9 months ago
  95. 659fdb4 Have the sqlite3_context object carry the encoding for the prepared statement by drh ยท 3 years, 9 months ago
  96. 99a2182 Split out the RUN state into separate READY and RUN states. by drh ยท 3 years, 9 months ago vdbe-state-refactor
  97. 66181ce Rename Vdbe.iVdbeMagic to eVdbeState. Remove unnecessary states. This is by drh ยท 3 years, 9 months ago
  98. c4c0ff8 Fix harmless compiler warnings. by drh ยท 3 years, 9 months ago
  99. 89cf958 Refinement to [3f9887d4a58cbfdb]: The SQLITE_CONSTRAINT error should only by drh ยท 3 years, 9 months ago
  100. 7e62146 Faster and slightly smaller implementation of sqlite3Step(). by drh ยท 3 years, 9 months ago