/ Check-in [93f32dd2]
Login

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

Overview
Comment:Merge the auto_vacuum bug fix and all other changes from the 3.19.3 release.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | apple-osx
Files: files | file ages | folders
SHA3-256: 93f32dd2dd572bd601215cc431318fd4da4bb897d8cf555d35d3b1ad60c4afe3
User & Date: drh 2017-06-08 14:41:05
Context
2017-06-23
21:05
Merge all recent trunk enhancements into the apple-osx branch. check-in: 53b14a38 user: drh tags: apple-osx
2017-06-08
14:41
Merge the auto_vacuum bug fix and all other changes from the 3.19.3 release. check-in: 93f32dd2 user: drh tags: apple-osx
14:26
Version 3.19.3 check-in: 0ee482a1 user: drh tags: release, version-3.19.3, branch-3.19
2017-05-25
17:36
Merge all fixes from the 3.19.2 release. check-in: 12964240 user: drh tags: apple-osx
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to VERSION.

     1         -3.19.2
            1  +3.19.3

Changes to configure.

     1      1   #! /bin/sh
     2      2   # Guess values for system-dependent variables and create Makefiles.
     3         -# Generated by GNU Autoconf 2.69 for sqlite 3.19.2.
            3  +# Generated by GNU Autoconf 2.69 for sqlite 3.19.3.
     4      4   #
     5      5   #
     6      6   # Copyright (C) 1992-1996, 1998-2012 Free Software Foundation, Inc.
     7      7   #
     8      8   #
     9      9   # This configure script is free software; the Free Software Foundation
    10     10   # gives unlimited permission to copy, distribute and modify it.
................................................................................
   722    722   subdirs=
   723    723   MFLAGS=
   724    724   MAKEFLAGS=
   725    725   
   726    726   # Identity of this package.
   727    727   PACKAGE_NAME='sqlite'
   728    728   PACKAGE_TARNAME='sqlite'
   729         -PACKAGE_VERSION='3.19.2'
   730         -PACKAGE_STRING='sqlite 3.19.2'
          729  +PACKAGE_VERSION='3.19.3'
          730  +PACKAGE_STRING='sqlite 3.19.3'
   731    731   PACKAGE_BUGREPORT=''
   732    732   PACKAGE_URL=''
   733    733   
   734    734   # Factoring default headers for most tests.
   735    735   ac_includes_default="\
   736    736   #include <stdio.h>
   737    737   #ifdef HAVE_SYS_TYPES_H
................................................................................
  1459   1459   #
  1460   1460   # Report the --help message.
  1461   1461   #
  1462   1462   if test "$ac_init_help" = "long"; then
  1463   1463     # Omit some internal or obsolete options to make the list less imposing.
  1464   1464     # This message is too long to be a string in the A/UX 3.1 sh.
  1465   1465     cat <<_ACEOF
  1466         -\`configure' configures sqlite 3.19.2 to adapt to many kinds of systems.
         1466  +\`configure' configures sqlite 3.19.3 to adapt to many kinds of systems.
  1467   1467   
  1468   1468   Usage: $0 [OPTION]... [VAR=VALUE]...
  1469   1469   
  1470   1470   To assign environment variables (e.g., CC, CFLAGS...), specify them as
  1471   1471   VAR=VALUE.  See below for descriptions of some of the useful variables.
  1472   1472   
  1473   1473   Defaults for the options are specified in brackets.
................................................................................
  1524   1524     --build=BUILD     configure for building on BUILD [guessed]
  1525   1525     --host=HOST       cross-compile to build programs to run on HOST [BUILD]
  1526   1526   _ACEOF
  1527   1527   fi
  1528   1528   
  1529   1529   if test -n "$ac_init_help"; then
  1530   1530     case $ac_init_help in
  1531         -     short | recursive ) echo "Configuration of sqlite 3.19.2:";;
         1531  +     short | recursive ) echo "Configuration of sqlite 3.19.3:";;
  1532   1532      esac
  1533   1533     cat <<\_ACEOF
  1534   1534   
  1535   1535   Optional Features:
  1536   1536     --disable-option-checking  ignore unrecognized --enable/--with options
  1537   1537     --disable-FEATURE       do not include FEATURE (same as --enable-FEATURE=no)
  1538   1538     --enable-FEATURE[=ARG]  include FEATURE [ARG=yes]
................................................................................
  1648   1648       cd "$ac_pwd" || { ac_status=$?; break; }
  1649   1649     done
  1650   1650   fi
  1651   1651   
  1652   1652   test -n "$ac_init_help" && exit $ac_status
  1653   1653   if $ac_init_version; then
  1654   1654     cat <<\_ACEOF
  1655         -sqlite configure 3.19.2
         1655  +sqlite configure 3.19.3
  1656   1656   generated by GNU Autoconf 2.69
  1657   1657   
  1658   1658   Copyright (C) 2012 Free Software Foundation, Inc.
  1659   1659   This configure script is free software; the Free Software Foundation
  1660   1660   gives unlimited permission to copy, distribute and modify it.
  1661   1661   _ACEOF
  1662   1662     exit
................................................................................
  2067   2067     eval $as_lineno_stack; ${as_lineno_stack:+:} unset as_lineno
  2068   2068   
  2069   2069   } # ac_fn_c_check_header_mongrel
  2070   2070   cat >config.log <<_ACEOF
  2071   2071   This file contains any messages produced by compilers while
  2072   2072   running configure, to aid debugging if configure makes a mistake.
  2073   2073   
  2074         -It was created by sqlite $as_me 3.19.2, which was
         2074  +It was created by sqlite $as_me 3.19.3, which was
  2075   2075   generated by GNU Autoconf 2.69.  Invocation command line was
  2076   2076   
  2077   2077     $ $0 $@
  2078   2078   
  2079   2079   _ACEOF
  2080   2080   exec 5>>config.log
  2081   2081   {
................................................................................
 11352  11352   else
 11353  11353     enable_memsys5=no
 11354  11354   fi
 11355  11355   
 11356  11356   { $as_echo "$as_me:${as_lineno-$LINENO}: checking whether to support MEMSYS5" >&5
 11357  11357   $as_echo_n "checking whether to support MEMSYS5... " >&6; }
 11358  11358   if test "${enable_memsys5}" = "yes"; then
 11359         -  OPT_FEATURE_FLAGS="$(OPT_FEATURE_FLAGS) -DSQLITE_ENABLE_MEMSYS5"
        11359  +  OPT_FEATURE_FLAGS="${OPT_FEATURE_FLAGS} -DSQLITE_ENABLE_MEMSYS5"
 11360  11360     { $as_echo "$as_me:${as_lineno-$LINENO}: result: yes" >&5
 11361  11361   $as_echo "yes" >&6; }
 11362  11362   else
 11363  11363     { $as_echo "$as_me:${as_lineno-$LINENO}: result: no" >&5
 11364  11364   $as_echo "no" >&6; }
 11365  11365   fi
 11366  11366   # Check whether --enable-memsys3 was given.
................................................................................
 11369  11369   else
 11370  11370     enable_memsys3=no
 11371  11371   fi
 11372  11372   
 11373  11373   { $as_echo "$as_me:${as_lineno-$LINENO}: checking whether to support MEMSYS3" >&5
 11374  11374   $as_echo_n "checking whether to support MEMSYS3... " >&6; }
 11375  11375   if test "${enable_memsys3}" = "yes" -a "${enable_memsys5}" = "no"; then
 11376         -  OPT_FEATURE_FLAGS="$(OPT_FEATURE_FLAGS) -DSQLITE_ENABLE_MEMSYS3"
        11376  +  OPT_FEATURE_FLAGS="${OPT_FEATURE_FLAGS} -DSQLITE_ENABLE_MEMSYS3"
 11377  11377     { $as_echo "$as_me:${as_lineno-$LINENO}: result: yes" >&5
 11378  11378   $as_echo "yes" >&6; }
 11379  11379   else
 11380  11380     { $as_echo "$as_me:${as_lineno-$LINENO}: result: no" >&5
 11381  11381   $as_echo "no" >&6; }
 11382  11382   fi
 11383  11383   
................................................................................
 11387  11387   if test "${enable_fts3+set}" = set; then :
 11388  11388     enableval=$enable_fts3; enable_fts3=yes
 11389  11389   else
 11390  11390     enable_fts3=no
 11391  11391   fi
 11392  11392   
 11393  11393   if test "${enable_fts3}" = "yes" ; then
 11394         -  OPT_FEATURE_FLAGS="$(OPT_FEATURE_FLAGS) -DSQLITE_ENABLE_FTS3"
        11394  +  OPT_FEATURE_FLAGS="${OPT_FEATURE_FLAGS} -DSQLITE_ENABLE_FTS3"
 11395  11395   fi
 11396  11396   # Check whether --enable-fts4 was given.
 11397  11397   if test "${enable_fts4+set}" = set; then :
 11398  11398     enableval=$enable_fts4; enable_fts4=yes
 11399  11399   else
 11400  11400     enable_fts4=no
 11401  11401   fi
 11402  11402   
 11403  11403   if test "${enable_fts4}" = "yes" ; then
 11404         -  OPT_FEATURE_FLAGS="$(OPT_FEATURE_FLAGS) -DSQLITE_ENABLE_FTS4"
        11404  +  OPT_FEATURE_FLAGS="${OPT_FEATURE_FLAGS} -DSQLITE_ENABLE_FTS4"
 11405  11405     { $as_echo "$as_me:${as_lineno-$LINENO}: checking for library containing log" >&5
 11406  11406   $as_echo_n "checking for library containing log... " >&6; }
 11407  11407   if ${ac_cv_search_log+:} false; then :
 11408  11408     $as_echo_n "(cached) " >&6
 11409  11409   else
 11410  11410     ac_func_search_save_LIBS=$LIBS
 11411  11411   cat confdefs.h - <<_ACEOF >conftest.$ac_ext
................................................................................
 11463  11463   if test "${enable_fts5+set}" = set; then :
 11464  11464     enableval=$enable_fts5; enable_fts5=yes
 11465  11465   else
 11466  11466     enable_fts5=no
 11467  11467   fi
 11468  11468   
 11469  11469   if test "${enable_fts5}" = "yes" ; then
 11470         -  OPT_FEATURE_FLAGS="$(OPT_FEATURE_FLAGS) -DSQLITE_ENABLE_FTS5"
        11470  +  OPT_FEATURE_FLAGS="${OPT_FEATURE_FLAGS} -DSQLITE_ENABLE_FTS5"
 11471  11471     { $as_echo "$as_me:${as_lineno-$LINENO}: checking for library containing log" >&5
 11472  11472   $as_echo_n "checking for library containing log... " >&6; }
 11473  11473   if ${ac_cv_search_log+:} false; then :
 11474  11474     $as_echo_n "(cached) " >&6
 11475  11475   else
 11476  11476     ac_func_search_save_LIBS=$LIBS
 11477  11477   cat confdefs.h - <<_ACEOF >conftest.$ac_ext
................................................................................
 11532  11532   if test "${enable_json1+set}" = set; then :
 11533  11533     enableval=$enable_json1; enable_json1=yes
 11534  11534   else
 11535  11535     enable_json1=no
 11536  11536   fi
 11537  11537   
 11538  11538   if test "${enable_json1}" = "yes" ; then
 11539         -  OPT_FEATURE_FLAGS="$(OPT_FEATURE_FLAGS) -DSQLITE_ENABLE_JSON1"
        11539  +  OPT_FEATURE_FLAGS="${OPT_FEATURE_FLAGS} -DSQLITE_ENABLE_JSON1"
 11540  11540   fi
 11541  11541   
 11542  11542   #########
 11543  11543   # See whether we should enable RTREE
 11544  11544   # Check whether --enable-rtree was given.
 11545  11545   if test "${enable_rtree+set}" = set; then :
 11546  11546     enableval=$enable_rtree; enable_rtree=yes
 11547  11547   else
 11548  11548     enable_rtree=no
 11549  11549   fi
 11550  11550   
 11551  11551   if test "${enable_rtree}" = "yes" ; then
 11552         -  OPT_FEATURE_FLAGS="$(OPT_FEATURE_FLAGS) -DSQLITE_ENABLE_RTREE"
        11552  +  OPT_FEATURE_FLAGS="${OPT_FEATURE_FLAGS} -DSQLITE_ENABLE_RTREE"
 11553  11553   fi
 11554  11554   
 11555  11555   #########
 11556  11556   # See whether we should enable the SESSION extension
 11557  11557   # Check whether --enable-session was given.
 11558  11558   if test "${enable_session+set}" = set; then :
 11559  11559     enableval=$enable_session; enable_session=yes
 11560  11560   else
 11561  11561     enable_session=no
 11562  11562   fi
 11563  11563   
 11564  11564   if test "${enable_session}" = "yes" ; then
 11565         -  OPT_FEATURE_FLAGS="$(OPT_FEATURE_FLAGS) -DSQLITE_ENABLE_SESSION"
 11566         -  OPT_FEATURE_FLAGS="$(OPT_FEATURE_FLAGS) -DSQLITE_ENABLE_PREUPDATE_HOOK"
        11565  +  OPT_FEATURE_FLAGS="${OPT_FEATURE_FLAGS} -DSQLITE_ENABLE_SESSION"
        11566  +  OPT_FEATURE_FLAGS="${OPT_FEATURE_FLAGS} -DSQLITE_ENABLE_PREUPDATE_HOOK"
 11567  11567   fi
 11568  11568   
 11569  11569   #########
 11570         -# attempt to duplicate any OMITS and ENABLES into the $(OPT_FEATURE_FLAGS) parameter
        11570  +# attempt to duplicate any OMITS and ENABLES into the ${OPT_FEATURE_FLAGS} parameter
 11571  11571   for option in $CFLAGS $CPPFLAGS
 11572  11572   do
 11573  11573     case $option in
 11574  11574       -DSQLITE_OMIT*) OPT_FEATURE_FLAGS="$OPT_FEATURE_FLAGS $option";;
 11575  11575       -DSQLITE_ENABLE*) OPT_FEATURE_FLAGS="$OPT_FEATURE_FLAGS $option";;
 11576  11576     esac
 11577  11577   done
................................................................................
 12147  12147   test $as_write_fail = 0 && chmod +x $CONFIG_STATUS || ac_write_fail=1
 12148  12148   
 12149  12149   cat >>$CONFIG_STATUS <<\_ACEOF || ac_write_fail=1
 12150  12150   # Save the log message, to keep $0 and so on meaningful, and to
 12151  12151   # report actual input values of CONFIG_FILES etc. instead of their
 12152  12152   # values after options handling.
 12153  12153   ac_log="
 12154         -This file was extended by sqlite $as_me 3.19.2, which was
        12154  +This file was extended by sqlite $as_me 3.19.3, which was
 12155  12155   generated by GNU Autoconf 2.69.  Invocation command line was
 12156  12156   
 12157  12157     CONFIG_FILES    = $CONFIG_FILES
 12158  12158     CONFIG_HEADERS  = $CONFIG_HEADERS
 12159  12159     CONFIG_LINKS    = $CONFIG_LINKS
 12160  12160     CONFIG_COMMANDS = $CONFIG_COMMANDS
 12161  12161     $ $0 $@
................................................................................
 12213  12213   
 12214  12214   Report bugs to the package provider."
 12215  12215   
 12216  12216   _ACEOF
 12217  12217   cat >>$CONFIG_STATUS <<_ACEOF || ac_write_fail=1
 12218  12218   ac_cs_config="`$as_echo "$ac_configure_args" | sed 's/^ //; s/[\\""\`\$]/\\\\&/g'`"
 12219  12219   ac_cs_version="\\
 12220         -sqlite config.status 3.19.2
        12220  +sqlite config.status 3.19.3
 12221  12221   configured by $0, generated by GNU Autoconf 2.69,
 12222  12222     with options \\"\$ac_cs_config\\"
 12223  12223   
 12224  12224   Copyright (C) 2012 Free Software Foundation, Inc.
 12225  12225   This config.status script is free software; the Free Software Foundation
 12226  12226   gives unlimited permission to copy, distribute and modify it."
 12227  12227   

Changes to configure.ac.

   592    592   # Do we want to support memsys3 and/or memsys5
   593    593   #
   594    594   AC_ARG_ENABLE(memsys5, 
   595    595     AC_HELP_STRING([--enable-memsys5],[Enable MEMSYS5]),
   596    596     [enable_memsys5=yes],[enable_memsys5=no])
   597    597   AC_MSG_CHECKING([whether to support MEMSYS5])
   598    598   if test "${enable_memsys5}" = "yes"; then
   599         -  OPT_FEATURE_FLAGS="$(OPT_FEATURE_FLAGS) -DSQLITE_ENABLE_MEMSYS5"
          599  +  OPT_FEATURE_FLAGS="${OPT_FEATURE_FLAGS} -DSQLITE_ENABLE_MEMSYS5"
   600    600     AC_MSG_RESULT([yes])
   601    601   else
   602    602     AC_MSG_RESULT([no])
   603    603   fi
   604    604   AC_ARG_ENABLE(memsys3, 
   605    605     AC_HELP_STRING([--enable-memsys3],[Enable MEMSYS3]),
   606    606     [enable_memsys3=yes],[enable_memsys3=no])
   607    607   AC_MSG_CHECKING([whether to support MEMSYS3])
   608    608   if test "${enable_memsys3}" = "yes" -a "${enable_memsys5}" = "no"; then
   609         -  OPT_FEATURE_FLAGS="$(OPT_FEATURE_FLAGS) -DSQLITE_ENABLE_MEMSYS3"
          609  +  OPT_FEATURE_FLAGS="${OPT_FEATURE_FLAGS} -DSQLITE_ENABLE_MEMSYS3"
   610    610     AC_MSG_RESULT([yes])
   611    611   else
   612    612     AC_MSG_RESULT([no])
   613    613   fi
   614    614   
   615    615   #########
   616    616   # See whether we should enable Full Text Search extensions
   617    617   AC_ARG_ENABLE(fts3, AC_HELP_STRING([--enable-fts3],
   618    618         [Enable the FTS3 extension]),
   619    619         [enable_fts3=yes],[enable_fts3=no])
   620    620   if test "${enable_fts3}" = "yes" ; then
   621         -  OPT_FEATURE_FLAGS="$(OPT_FEATURE_FLAGS) -DSQLITE_ENABLE_FTS3"
          621  +  OPT_FEATURE_FLAGS="${OPT_FEATURE_FLAGS} -DSQLITE_ENABLE_FTS3"
   622    622   fi
   623    623   AC_ARG_ENABLE(fts4, AC_HELP_STRING([--enable-fts4],
   624    624         [Enable the FTS4 extension]),
   625    625         [enable_fts4=yes],[enable_fts4=no])
   626    626   if test "${enable_fts4}" = "yes" ; then
   627         -  OPT_FEATURE_FLAGS="$(OPT_FEATURE_FLAGS) -DSQLITE_ENABLE_FTS4"
          627  +  OPT_FEATURE_FLAGS="${OPT_FEATURE_FLAGS} -DSQLITE_ENABLE_FTS4"
   628    628     AC_SEARCH_LIBS([log],[m])
   629    629   fi
   630    630   AC_ARG_ENABLE(fts5, AC_HELP_STRING([--enable-fts5],
   631    631         [Enable the FTS5 extension]),
   632    632         [enable_fts5=yes],[enable_fts5=no])
   633    633   if test "${enable_fts5}" = "yes" ; then
   634         -  OPT_FEATURE_FLAGS="$(OPT_FEATURE_FLAGS) -DSQLITE_ENABLE_FTS5"
          634  +  OPT_FEATURE_FLAGS="${OPT_FEATURE_FLAGS} -DSQLITE_ENABLE_FTS5"
   635    635     AC_SEARCH_LIBS([log],[m])
   636    636   fi
   637    637   
   638    638   #########
   639    639   # See whether we should enable JSON1
   640    640   AC_ARG_ENABLE(json1, AC_HELP_STRING([--enable-json1],
   641    641         [Enable the JSON1 extension]),
   642    642         [enable_json1=yes],[enable_json1=no])
   643    643   if test "${enable_json1}" = "yes" ; then
   644         -  OPT_FEATURE_FLAGS="$(OPT_FEATURE_FLAGS) -DSQLITE_ENABLE_JSON1"
          644  +  OPT_FEATURE_FLAGS="${OPT_FEATURE_FLAGS} -DSQLITE_ENABLE_JSON1"
   645    645   fi
   646    646   
   647    647   #########
   648    648   # See whether we should enable RTREE
   649    649   AC_ARG_ENABLE(rtree, AC_HELP_STRING([--enable-rtree],
   650    650         [Enable the RTREE extension]),
   651    651         [enable_rtree=yes],[enable_rtree=no])
   652    652   if test "${enable_rtree}" = "yes" ; then
   653         -  OPT_FEATURE_FLAGS="$(OPT_FEATURE_FLAGS) -DSQLITE_ENABLE_RTREE"
          653  +  OPT_FEATURE_FLAGS="${OPT_FEATURE_FLAGS} -DSQLITE_ENABLE_RTREE"
   654    654   fi
   655    655   
   656    656   #########
   657    657   # See whether we should enable the SESSION extension
   658    658   AC_ARG_ENABLE(session, AC_HELP_STRING([--enable-session],
   659    659         [Enable the SESSION extension]),
   660    660         [enable_session=yes],[enable_session=no])
   661    661   if test "${enable_session}" = "yes" ; then
   662         -  OPT_FEATURE_FLAGS="$(OPT_FEATURE_FLAGS) -DSQLITE_ENABLE_SESSION"
   663         -  OPT_FEATURE_FLAGS="$(OPT_FEATURE_FLAGS) -DSQLITE_ENABLE_PREUPDATE_HOOK"
          662  +  OPT_FEATURE_FLAGS="${OPT_FEATURE_FLAGS} -DSQLITE_ENABLE_SESSION"
          663  +  OPT_FEATURE_FLAGS="${OPT_FEATURE_FLAGS} -DSQLITE_ENABLE_PREUPDATE_HOOK"
   664    664   fi
   665    665   
   666    666   #########
   667         -# attempt to duplicate any OMITS and ENABLES into the $(OPT_FEATURE_FLAGS) parameter
          667  +# attempt to duplicate any OMITS and ENABLES into the ${OPT_FEATURE_FLAGS} parameter
   668    668   for option in $CFLAGS $CPPFLAGS
   669    669   do
   670    670     case $option in
   671    671       -DSQLITE_OMIT*) OPT_FEATURE_FLAGS="$OPT_FEATURE_FLAGS $option";;
   672    672       -DSQLITE_ENABLE*) OPT_FEATURE_FLAGS="$OPT_FEATURE_FLAGS $option";;
   673    673     esac
   674    674   done

Changes to src/btree.c.

  8176   8176         goto end_insert;
  8177   8177       }
  8178   8178       oldCell = findCell(pPage, idx);
  8179   8179       if( !pPage->leaf ){
  8180   8180         memcpy(newCell, oldCell, 4);
  8181   8181       }
  8182   8182       rc = clearCell(pPage, oldCell, &info);
  8183         -    if( info.nSize==szNew && info.nLocal==info.nPayload ){
         8183  +    if( info.nSize==szNew && info.nLocal==info.nPayload 
         8184  +     && (!ISAUTOVACUUM || szNew<pPage->minLocal)
         8185  +    ){
  8184   8186         /* Overwrite the old cell with the new if they are the same size.
  8185   8187         ** We could also try to do this if the old cell is smaller, then add
  8186   8188         ** the leftover space to the free list.  But experiments show that
  8187   8189         ** doing that is no faster then skipping this optimization and just
  8188         -      ** calling dropCell() and insertCell(). */
         8190  +      ** calling dropCell() and insertCell(). 
         8191  +      **
         8192  +      ** This optimization cannot be used on an autovacuum database if the
         8193  +      ** new entry uses overflow pages, as the insertCell() call below is
         8194  +      ** necessary to add the PTRMAP_OVERFLOW1 pointer-map entry.  */
  8189   8195         assert( rc==SQLITE_OK ); /* clearCell never fails when nLocal==nPayload */
  8190   8196         if( oldCell+szNew > pPage->aDataEnd ) return SQLITE_CORRUPT_BKPT;
  8191   8197         memcpy(oldCell, newCell, szNew);
  8192   8198         return SQLITE_OK;
  8193   8199       }
  8194   8200       dropCell(pPage, idx, info.nSize, &rc);
  8195   8201       if( rc ) goto end_insert;

Changes to test/autovacuum.test.

   701    701     execsql { INSERT INTO t1 SELECT NULL, randstr(50,50) FROM t1 }
   702    702   } {}
   703    703   do_test autovacuum-9.5 {
   704    704     execsql { DELETE FROM t1 WHERE rowid > (SELECT max(a)/2 FROM t1) }
   705    705     file size test.db
   706    706   } $::sqlite_pending_byte
   707    707    
          708  +do_execsql_test autovacuum-10.1 {
          709  +  DROP TABLE t1;
          710  +  CREATE TABLE t1(a INTEGER PRIMARY KEY, b);
          711  +  INSERT INTO t1 VALUES(25, randomblob(104));
          712  +  REPLACE INTO t1 VALUES(25, randomblob(1117));
          713  +  PRAGMA integrity_check;
          714  +} {ok}
   708    715   
   709    716   finish_test