Commits

Branch selector

 master

User selector

All users

All time

Commit history

Commits on Apr 23, 2022

• Prevent the ORDER BY LIMIT optimization from running if the innermost loop

  Show description for ecb386b
  

  drh

  committed
  ecb386b

  Copy full SHA for ecb386b

• In debug builds, add extra code to verify that there are no jumps that try to

  Show description for 30d2aab
  

  drh

  committed
  30d2aab

  Copy full SHA for 30d2aab

• Fix false-positives in sqlite3VdbeNoJumpsOutsideSubrtn(). All tests pass now.

  Show description for 6c7e89b
  

  drh

  committed
  6c7e89b

  Copy full SHA for 6c7e89b

• For debug builds, if the RIGHT JOIN body subroutine contains a jump that

  Show description for b77c312
  

  drh

  committed
  b77c312

  Copy full SHA for b77c312

Commits on Apr 22, 2022

• Make use of the "%!S" format when running ExplainSubquery.

  Show description for d6bb600
  

  drh

  committed
  d6bb600

  Copy full SHA for d6bb600

• Improve EXPLAIN QUERY PLAN output and comments on bytecode listings by

  Show description for da653b8
  

  drh

  committed
  da653b8

  Copy full SHA for da653b8

• Honor the MATERIALIZED keyword on a common table expression by not flattening

  Show description for 67f70be
  

  drh

  committed
  67f70be

  Copy full SHA for 67f70be

• Add test cases to check the handling of SQLITE_BUSY in rbu.

  Show description for 9b843f0
  

  dan

  authored and

  dan

  committed
  9b843f0

  Copy full SHA for 9b843f0

• Simplification of data structures in the wildcard expander for

  Show description for 1ca14b7
  

  drh

  committed
  1ca14b7

  Copy full SHA for 1ca14b7

• Minor simplification to the result-set wildcard expander for SF_NestedFrom.

  Show description for 9c2d7aa
  

  drh

  committed
  9c2d7aa

  Copy full SHA for 9c2d7aa

• Merge the latest trunk fixes into the right-join branch.

  Show description for 8318b55
  

  drh

  committed
  8318b55

  Copy full SHA for 8318b55

Commits on Apr 21, 2022

• Previous fix to join8.test needs a return.

  Show description for 1c69bc9
  

  drh

  committed
  1c69bc9

  Copy full SHA for 1c69bc9

• Disable join8.test if the build lacks support for virtual tables.

  Show description for abb4e75
  

  drh

  committed
  abb4e75

  Copy full SHA for abb4e75

• Add support for RIGHT and FULL JOIN.

  Show description for 11140ad
  

  drh

  committed
  11140ad

  Copy full SHA for 11140ad

• Fix harmless compiler warnings.

  Show description for 6dab33b
  

  drh

  committed
  6dab33b

  Copy full SHA for 6dab33b

• Fix a harmless uninitialized variable warning in MSVC.

  Show description for a74b4c4
  

  drh

  committed
  a74b4c4

  Copy full SHA for a74b4c4

• Fix harmless compiler warnings in the CLI.

  Show description for 7e9a56f
  

  drh

  committed
  7e9a56f

  Copy full SHA for 7e9a56f

• Make sure the code generator knows to invoke row-value subroutines which

  Show description for 503ad9c
  

  drh

  committed
  503ad9c

  Copy full SHA for 503ad9c

• Ensure correct fg.isNestedFrom values even on crazy parses.

  Show description for 825a6bf
  

  drh

  committed
  825a6bf

  Copy full SHA for 825a6bf

• Avoid materializing columns of SF_NestedFrom subqueries that are never used.

  Show description for 18f8600
  

  drh

  committed
  18f8600

  Copy full SHA for 18f8600

Commits on Apr 20, 2022

• For CLI, fix how columnar mode fills in empty portions of wrapped row outputs.

  Show description for 6403e77
  

  larrybr

  committed
  6403e77

  Copy full SHA for 6403e77

• Small correction to the new bUsed logic of sqlite3ProcessJoin().

  Show description for 22b410d
  

  drh

  committed
  22b410d

  Copy full SHA for 22b410d

• Merge window function fix from trunk.

  Show description for e60ffa3
  

  drh

  committed
  e60ffa3

  Copy full SHA for e60ffa3

• Remove an unnecessary assignment operation.

  Show description for 910e57b
  

  drh

  committed
  910e57b

  Copy full SHA for 910e57b

• Fix a problem with using multiple SQLITE_SUBTYPE function as window functions in a single query.

  Show description for 41150bf
  

  dan

  authored and

  dan

  committed
  41150bf

  Copy full SHA for 41150bf

• Comment fixes and improvements in sqlite3ProcessJoin().

  Show description for bc656e2
  

  drh

  committed
  bc656e2

  Copy full SHA for bc656e2

• Improved tracking of nested SELECT objects used to implement

  Show description for 815b782
  

  drh

  committed
  815b782

  Copy full SHA for 815b782

• Also show the ENAME_SPAN value in sqlite3TreeViewExprList(), if there is one.

  Show description for b465a83
  

  drh

  committed
  b465a83

  Copy full SHA for b465a83

• Improved TreeView output for ExprList: Show the ENAME_TAB value, if there

  Show description for d4e9caf
  

  drh

  committed
  d4e9caf

  Copy full SHA for d4e9caf

• Add a new comment to the body of lookupName(). No code changes.

  Show description for 2627cbd
  

  drh

  committed
  2627cbd

  Copy full SHA for 2627cbd

Commits on Apr 19, 2022

• Merge the ALTER TABLE fix from trunk.

  Show description for befbb40
  

  drh

  committed
  befbb40

  Copy full SHA for befbb40

• Fix a problem in ALTER TABLE with handling "table.*" expressions within SELECT statements in triggers.

  Show description for cbde37d
  

  dan

  authored and

  dan

  committed
  cbde37d

  Copy full SHA for cbde37d

• Improved comment on the JF_LTORJ constant definition.

  Show description for 4d0d071
  

  drh

  committed
  4d0d071

  Copy full SHA for 4d0d071

• Fix a NULL-pointer dereference that can occur on an aggregate query that

  Show description for 3117b7b
  

  drh

  committed
  3117b7b

  Copy full SHA for 3117b7b

• Mark an unreachable "just-in-case" branch as unreachable.

  Show description for e32d6a0
  

  drh

  committed
  e32d6a0

  Copy full SHA for e32d6a0