Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

• branch=trunk inherited from [b2e03e19ab]
• sym-trunk inherited from [b2e03e19ab]

Changes to pages/changes.in

   61      the REGEXP operator.                                                              61      the REGEXP operator.
   62  <li>Improved error messages in the [RTREE] extension.                                 62  <li>Improved error messages in the [RTREE] extension.
   63  <li>Enhance the [command-line shell] so that a non-zero argument to the               63  <li>Enhance the [command-line shell] so that a non-zero argument to the
   64      ".exit" command causes the shell to exist immediately without cleanly             64      ".exit" command causes the shell to exist immediately without cleanly
   65      shutting down the database connection.                                            65      shutting down the database connection.
   66  <li>Improved error messages for invalid boolean arguments to dot-commands             66  <li>Improved error messages for invalid boolean arguments to dot-commands
   67      in the [command-line shell].                                                      67      in the [command-line shell].
                                                                                        >    68  <li>Improved error messages for "foreign key mismatch" showing the names of
                                                                                        >    69      the two tables involved.
   68  <li>Remove all uses of umask() in the unix VFS.                                       70  <li>Remove all uses of umask() in the unix VFS.
   69  <li>Added the [PRAGMA vdbe_debug] command.                                       |    71  <li>Added the [PRAGMA vdbe_addoptrace] and [PRAGMA vdbe_debug] commands.
   70                                                                                        72  
   71  <li>Bug fix: Issue an error message if the 16-bit reference counter on a              73  <li>Bug fix: Issue an error message if the 16-bit reference counter on a
   72      view overflows due to an overly complex query.                                    74      view overflows due to an overly complex query.
   73  <li>Bug fix: Avoid leaking memory on LIMIT and OFFSET clauses in deeply               75  <li>Bug fix: Avoid leaking memory on LIMIT and OFFSET clauses in deeply
   74      nested UNION ALL queries.                                                         76      nested UNION ALL queries.
   75  <li>Bug fix: Make sure the schema is up-to-date prior to running pragmas              77  <li>Bug fix: Make sure the schema is up-to-date prior to running pragmas
   76      table_info, index_list, index_info, and foreign_key_list.                         78      table_info, index_list, index_info, and foreign_key_list.

Changes to pages/pragma.in

 1122                                                                                      1122  
 1123  DebugPragma vdbe_debug {                                                            1123  DebugPragma vdbe_debug {
 1124      <p><b>PRAGMA vdbe_debug = </b><i>boolean</i><b>;</b></p>                        1124      <p><b>PRAGMA vdbe_debug = </b><i>boolean</i><b>;</b></p>
 1125                                                                                      1125  
 1126      DISCLAIMER                                                                      1126      DISCLAIMER
 1127                                                                                      1127  
 1128      <p>If SQLite has been compiled with the [SQLITE_DEBUG] compile-time             1128      <p>If SQLite has been compiled with the [SQLITE_DEBUG] compile-time
 1129      option, then the vdbe_debug pragma can be used to cause a complete           |  1129      option, then the vdbe_debug pragma is a shorthand for three other
 1130      listing of the virtual machine opcodes to appear on standard output          |  1130      debug-only pragmas: vdbe_addoptrace, vdbe_listing, and vdbe_trace.
 1131      as each statement is evaluated, and to cause each to cause virtual           |  1131      This feature is used for debugging SQLite itself.  See the
 1132      machine opcodes to be printed on standard output as they are evaluated.      |  1132      <a href="vdbe.html#trace">VDBE documentation</a> for more
 1133      (In other words, vdbe_debug is a combination of vdbe_listing and             |  1133      information.</p>
 1134      vdbe_trace.)  In addition, the vdbe_debug pragma also enables tracing        <
                                                                                        >  1134  }
                                                                                        >  1135  DebugPragma vdbe_addoptrace {
                                                                                        >  1136      <p><b>PRAGMA vdbe_addoptrace = </b><i>boolean</i><b>;</b></p>
                                                                                        >  1137  
                                                                                        >  1138      DISCLAIMER
                                                                                        >  1139  
                                                                                        >  1140      <p>If SQLite has been compiled with the [SQLITE_DEBUG] compile-time
                                                                                        >  1141      option, then the vdbe_addoptrace pragma can be used to cause a complete
 1135      of calls to sqlite3VdbeAddOp() during code generation.                       |  1142      VDBE opcodes to be displayed as they are created during code generation.
 1136      This feature is used for debugging SQLite itself.  See the                      1143      This feature is used for debugging SQLite itself.  See the
 1137      <a href="vdbe.html#trace">VDBE documentation</a> for more                       1144      <a href="vdbe.html#trace">VDBE documentation</a> for more
 1138      information.</p>                                                                1145      information.</p>
 1139  }                                                                                   1146  }
 1140                                                                                      1147  
 1141  Pragma wal_checkpoint {                                                             1148  Pragma wal_checkpoint {
 1142      <p><b>PRAGMA </b><i>database</i><b>.wal_checkpoint;</b><br>                     1149      <p><b>PRAGMA </b><i>database</i><b>.wal_checkpoint;</b><br>