System.Data.SQLite

          <td>PROCESSOR_ARCHITECTURE</td>
          <td>This environment variable is normally set by the operating
          system itself and should reflect the native processor architecture
          of the current process (e.g. a 32-bit x86 application running on a
          64-bit x64 operating system should have the value &quot;x86&quot;).
          </td>
        </tr>
        <tr valign="top">
          <td>SQLite_LegacyEncryptPage1</td>
          <td>If this environment variable is set [to anything], page #1 of
          database files encrypted using the (unsupported) legacy CryptoAPI
          codec will be encrypted.  This was the default behavior prior to
          release 1.0.112.3; however, it is now disabled (by default) as it
          can cause corruption and/or other malfunctions in some circumstances.
          Please do not use this environment variable unless it is absolutely
          necessary for your specific use case.</td>
        </tr>
        <tr valign="top">
          <td>SQLite_ForceLogPrepare</td>
          <td>If this environment variable is set [to anything], all calls to
          prepare a SQL query will be logged, regardless of the flags for the
          associated connection.</td>
        </tr>
        <tr valign="top">
          <td>SQLite_ForceLogLifecycle</td>
          <td>If this environment variable is set [to anything], calls into
          key members pertaining to the lifecycle of connections and their
          associated classes (e.g. LINQ, EF6, etc) will be logged.</td>
        </tr>
        <tr valign="top">
          <td>TypeName_SQLiteProviderServices</td>
          <td>If this environment variable is set [to anything], it will be
          used by the System.Data.SQLite.SQLiteFactory class as the type name
          containing the System.Data.Common.DbProviderServices implementation
          that should be used.</td>
        </tr>

      <p>
        This command must be used in conjunction with a SELECT statement.&nbsp; It only
        works when both the TYPES keyword and its value(s) are passed along with a SELECT
        statement as a single semi-colon separated unit.</p>
      <h3>
        Examples</h3>
      <p>
        <strong><span style="color: #2c2cf0">TYPES</span> [bigint], [int], [mediumint], [smallint], [tinyint];<br />
          <span style="color: #2c2cf0">SELECT</span> 1, 2, 3, 4;</strong></p>
      <p>
        The above query would return the columns as types System.Int64, System.Int32, System.Int32, System.Int16
        and System.Byte respectively.</p>
      <p>
        <strong><span style="color: #2c2cf0">TYPES</span> [bigint], [int], , [tinyint];<br />
          <span style="color: #2c2cf0">SELECT</span> 1, 2, 3, 4;</strong></p>
      <p>
        In this sample, only columns 1, 2 and 4 would have explicit typing.&nbsp; Column
        3's datatype would pass though the system and be discovered normally.</p>

          </td>
        </tr>
      </table>
    </div>
    <div id="mainSection">
    <div id="mainBody">
    <h1 class="heading">Version History</h1>
    <p><b>1.0.113.0 - June XX, 2020 <font color="red">(release scheduled)</font></b></p>
    <ul>
      <li>Updated to <a href="https://www.sqlite.org/releaselog/3_32_0.html">SQLite 3.32.0</a>.</li>
      <li>Add SQLite_ForceLogLifecycle environment variable to force logging of calls into key members pertaining to the lifecycle of connections and their associated classes (e.g. LINQ, EF6, etc).</li>

      <li>Support automatic value conversions for columns with a declared type of MEDIUMINT or MEDIUMUINT. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/515cb60b10">[515cb60b10]</a>.</li>
      <li>Add preliminary support for the .NET Framework 4.8.</li>
    </ul>
    <p><b>1.0.112.3 - Xxxx XX, 2020</b></p>
    <ul>
      <li>When using the (unsupported) legacy CryptoAPI based codec, skip encrypting page #1 because that can lead to database corruption and other malfunctions.</li>
    </ul>
    <p><b>1.0.112.2 - April 27, 2020</b></p>
    <ul>
      <li>Fix NuGet packaging for .NET Standard 2.1. Fix for <a href="https://system.data.sqlite.org/index.html/info/7c73262e6f">[7c73262e6f]</a>.</li>
    </ul>
    <p><b>1.0.112.1 - April 6, 2020</b></p>
    <ul>
      <li>Updated to <a href="https://www.sqlite.org/releaselog/3_31_1.html">SQLite 3.31.1</a>.</li>

  HCRYPTKEY hReadKey;     /* Key used to read from the database and write to the journal */
  HCRYPTKEY hWriteKey;    /* Key used to write to the database */
  DWORD     dwPageSize;   /* Size of pages */
  LPVOID    pvCrypt;      /* A buffer for encrypting/decrypting (if necessary) */
  DWORD     dwCryptSize;  /* Equal to or greater than dwPageSize.  If larger, pvCrypt is valid and this is its size */
} CRYPTBLOCK, *LPCRYPTBLOCK;

#define CRYPT_PAGE1_UNKNOWN  (0)
#define CRYPT_PAGE1_ENABLED  (1)
#define CRYPT_PAGE1_DISABLED (2)

BOOL g_bEncryptPage1 = CRYPT_PAGE1_UNKNOWN;

HCRYPTPROV g_hProvider = 0; /* Global instance of the cryptographic provider */

#define SQLITECRYPTERROR_PROVIDER "Cryptographic provider not available"

/* Needed for re-keying */
static void * sqlite3pager_get_codecarg(Pager *pPager)
{

/* Encrypt/Decrypt functionality, called by pager.c */
static void *sqlite3Codec(void *pArg, void *data, Pgno nPageNum, int nMode)
{
  LPCRYPTBLOCK pBlock = (LPCRYPTBLOCK)pArg;
  DWORD dwPageSize;
  LPVOID pvTemp = NULL;

  if (g_bEncryptPage1 == CRYPT_PAGE1_UNKNOWN)
  {
    WCHAR aBuf[2];
    memset(aBuf, 0, sizeof(aBuf));
    if ((GetEnvironmentVariableW(L"SQLite_LegacyEncryptPage1", aBuf, sizeof(aBuf)) != 0)
     || (GetLastError() != ERROR_ENVVAR_NOT_FOUND))
    {
      g_bEncryptPage1 = CRYPT_PAGE1_ENABLED;
    } else {
      g_bEncryptPage1 = CRYPT_PAGE1_DISABLED;
    }
  }

  if (!pBlock) return data;
  if (g_bEncryptPage1 == CRYPT_PAGE1_DISABLED)
  {
    if (nPageNum == 1) // BUGFIX: Skip first page as it contains metadata
                       //         necessary to initialize the pager.  For
                       //         backward compatibility, decrypt page #1
                       //         for any existing databases.
    {
      //
      // NOTE: If this is page #1 and it starts with the file header, it
      //       should not be encrypted; so, do nothing to it; otherwise,
      //       it is encrypted and must be decrypted.
      //
      if (memcmp(data, zMagicHeader, sizeof(zMagicHeader)) == 0)
      {
        return data;
      }
    }
  }
  if (pBlock->pvCrypt == NULL) return NULL; /* This only happens if CreateCryptBlock() failed to make scratch space */

  switch(nMode)
  {
  case 0: /* Undo a "case 7" journal file encryption */
  case 2: /* Reload a page */
  case 3: /* Load a page */

        public object GetService(
            Type serviceType
            )
        {
            if ((serviceType == typeof(ISQLiteSchemaExtensions)) ||
                (serviceType == typeof(DbProviderServices)))
            {
                object result = SQLiteProviderServices.Instance;

                if (SQLite3.ForceLogLifecycle())
                {
                    SQLiteLog.LogMessage(HelperMethods.StringFormat(
                        CultureInfo.CurrentCulture,
                        "Success of \"{0}\" from SQLiteProviderFactory.GetService(\"{1}\")...",
                        (result != null) ? result.ToString() : "<null>",
                        (serviceType != null) ? serviceType.ToString() : "<null>"));
                }

                return result;
            }

            if (SQLite3.ForceLogLifecycle())
            {
                SQLiteLog.LogMessage(HelperMethods.StringFormat(
                    CultureInfo.CurrentCulture,
                    "Failure of SQLiteProviderFactory.GetService(\"{0}\")...",
                    (serviceType != null) ? serviceType.ToString() : "<null>"));
            }

            return null;
        }
        #endregion

        ///////////////////////////////////////////////////////////////////////

              architecture of the current process (e.g. a 32-bit x86
              application running on a 64-bit x64 operating system should have
              the value "x86").
    -->
    <!--
    <add key="PROCESSOR_ARCHITECTURE" value="%PROCESSOR_ARCHITECTURE%" />
    -->

    <!--
        NOTE: If this environment variable is set [to anything], page #1
              of database files encrypted using the (unsupported) legacy
              CryptoAPI codec will be encrypted.  This was the default
              behavior prior to release 1.0.112.3; however, it is now
              disabled (by default) as it can cause corruption and/or other
              malfunctions in some circumstances.  Please do not use this
              environment variable unless it is absolutely necessary for your
              specific use case.

        NOTE: Since this environment variable is (only) read from the native
              interop assembly, it cannot be set via this configuration file.
              It can only be set within the process environment.
    -->
    <!--
    <add key="SQLite_LegacyEncryptPage1" value="1" />
    -->

    <!--
        NOTE: If this environment variable is set [to anything], all calls to
              prepare a SQL query will be logged, regardless of the flags for
              the associated connection.
    -->
    <!--
    <add key="SQLite_ForceLogPrepare" value="1" />
    -->

    <!--
        NOTE: If this environment variable is set [to anything], calls into
              key members pertaining to the lifecycle of connections and their
              associated classes (e.g. LINQ, EF6, etc) will be logged.
    -->
    <!--
    <add key="SQLite_ForceLogLifecycle" value="1" />
    -->

    <!--
        NOTE: If this environment variable is set [to anything], it will be
              used by the System.Data.SQLite.SQLiteFactory class as the type
              name containing the System.Data.Common.DbProviderServices
              implementation that should be used.
    -->

/********************************************************
 * ADO.NET 2.0 Data Provider for SQLite Version 3.X
 * Written by Robert Simpson (robert@blackcastlesoft.com)
 * 
 * Released to the public domain, use at your own risk!
 ********************************************************/

namespace System.Data.SQLite
{
  using System.Globalization;
  using System.Data.Common;

  public sealed partial class SQLiteConnection
  {
    /// <summary>
    /// Returns the <see cref="SQLiteFactory" /> instance.
    /// </summary>
    protected override DbProviderFactory DbProviderFactory
    {
      get
      {
        DbProviderFactory result = SQLiteFactory.Instance;

        if (SQLite3.ForceLogLifecycle())
        {
          SQLiteLog.LogMessage(HelperMethods.StringFormat(
            CultureInfo.CurrentCulture,
            "Returning \"{0}\" from SQLiteConnection.DbProviderFactory...",
            (result != null) ? result.ToString() : "<null>"));
        }

        return result;
      }
    }
  }
}

    //       situation may need to change.
    //
    private static readonly string DefaultTypeName =
      "System.Data.SQLite.Linq.SQLiteProviderServices, System.Data.SQLite.Linq, " +
      "Version={0}, Culture=neutral, PublicKeyToken=db937bc2d44ff139";

    private static readonly BindingFlags DefaultBindingFlags =
        BindingFlags.NonPublic | BindingFlags.Static;

    ///////////////////////////////////////////////////////////////////////////

    private static Type _dbProviderServicesType;
    private static object _sqliteServices;

    ///////////////////////////////////////////////////////////////////////////

    static SQLiteFactory()
    {
      InitializeDbProviderServices();
    }

    ///////////////////////////////////////////////////////////////////////////

    /// <summary>
    /// This method is called to perform preliminary static initialization
    /// necessary for this class.
    /// </summary>
    internal static void PreInitialize()
    {
#if (SQLITE_STANDARD || USE_INTEROP_DLL || PLATFORM_COMPACTFRAMEWORK) && PRELOAD_NATIVE_LIBRARY
        UnsafeNativeMethods.Initialize();
#endif

        SQLiteLog.Initialize(typeof(SQLiteFactory).Name);
    }

    ///////////////////////////////////////////////////////////////////////////

    /// <summary>
    /// This method is called to perform some of the static initialization
    /// necessary for this class.
    /// </summary>
    private static void InitializeDbProviderServices()
    {
        PreInitialize();

        string version =
#if NET_40 || NET_45 || NET_451 || NET_452 || NET_46 || NET_461 || NET_462 || NET_47 || NET_471 || NET_472 || NET_STANDARD_20 || NET_STANDARD_21
            "4.0.0.0";
#else
            "3.5.0.0";
#endif

        _dbProviderServicesType = Type.GetType(HelperMethods.StringFormat(CultureInfo.InvariantCulture, "System.Data.Common.DbProviderServices, System.Data.Entity, Version={0}, Culture=neutral, PublicKeyToken=b77a5c561934e089", version), false);
    }

    ///////////////////////////////////////////////////////////////////////////

    /// <summary>
    /// Will provide a <see cref="IServiceProvider" /> object in .NET 3.5.
    /// </summary>
    /// <param name="serviceType">The class or interface type to query for.</param>
    /// <returns></returns>
    object IServiceProvider.GetService(Type serviceType)
    {
      if (serviceType == typeof(ISQLiteSchemaExtensions) ||
        (_dbProviderServicesType != null && serviceType == _dbProviderServicesType))
      {
        object result = GetSQLiteProviderServicesInstance();

        if (SQLite3.ForceLogLifecycle())
        {
          SQLiteLog.LogMessage(HelperMethods.StringFormat(
            CultureInfo.CurrentCulture,
            "Success of \"{0}\" from SQLiteFactory.GetService(\"{1}\")...",
            (result != null) ? result.ToString() : "<null>",
            (serviceType != null) ? serviceType.ToString() : "<null>"));
        }

        return result;
      }

      if (SQLite3.ForceLogLifecycle())
      {
        SQLiteLog.LogMessage(HelperMethods.StringFormat(
          CultureInfo.CurrentCulture,
          "Failure of SQLiteFactory.GetService(\"{0}\")...",
          (serviceType != null) ? serviceType.ToString() : "<null>"));
      }

      return null;
    }

    ///////////////////////////////////////////////////////////////////////////

#if !NET_STANDARD_20 && !NET_STANDARD_21
    [ReflectionPermission(SecurityAction.Assert, MemberAccess = true)]
#endif
    private object GetSQLiteProviderServicesInstance()
    {
        if (_sqliteServices == null)

                FieldInfo field = type.GetField(
                    "Instance", DefaultBindingFlags);

                if (field != null)
                    _sqliteServices = field.GetValue(null);
            }
        }

        return _sqliteServices;
    }
  }
}

    <IsLong>false</IsLong>
    <IsNullable>true</IsNullable>
    <IsSearchable>true</IsSearchable>
    <IsSearchableWithLike>false</IsSearchableWithLike>
    <IsUnsigned>false</IsUnsigned>
    <IsBestMatch>true</IsBestMatch>
  </DataTypes>
  <DataTypes>
    <TypeName>mediumint</TypeName>
    <ProviderDbType>11</ProviderDbType>
    <ColumnSize>10</ColumnSize>
    <DataType>System.Int32</DataType>
    <CreateFormat>mediumint</CreateFormat>
    <IsAutoIncrementable>false</IsAutoIncrementable>
    <IsCaseSensitive>false</IsCaseSensitive>
    <IsFixedLength>true</IsFixedLength>
    <IsFixedPrecisionScale>true</IsFixedPrecisionScale>
    <IsLong>false</IsLong>
    <IsNullable>true</IsNullable>
    <IsSearchable>true</IsSearchable>
    <IsSearchableWithLike>false</IsSearchableWithLike>
    <IsUnsigned>false</IsUnsigned>
    <IsBestMatch>false</IsBestMatch>
  </DataTypes>
  <DataTypes>
    <TypeName>real</TypeName>
    <ProviderDbType>8</ProviderDbType>
    <ColumnSize>6</ColumnSize>
    <DataType>System.Double</DataType>
    <CreateFormat>real</CreateFormat>
    <IsAutoIncrementable>false</IsAutoIncrementable>

    /// "SQLite_ForceLogPrepare" environment variable has been queried.  If so,
    /// it will only be non-zero if the environment variable was present.
    /// </summary>
    private static bool? forceLogPrepare = null;

    ///////////////////////////////////////////////////////////////////////////////////////////////

    /// <summary>
    /// This field is used to keep track of whether or not the
    /// "SQLite_ForceLogLifecycle" environment variable has been queried.  If
    /// so, it will only be non-zero if the environment variable was present.
    /// </summary>
    private static bool? forceLogLifecycle = null;

    ///////////////////////////////////////////////////////////////////////////////////////////////

    /// <summary>
    /// Determines if all calls to prepare a SQL query will be logged,
    /// regardless of the flags for the associated connection.
    /// </summary>
    /// <returns>
    /// Non-zero to log all calls to prepare a SQL query.
    /// </returns>

                    forceLogPrepare = false;
                }
            }

            return (bool)forceLogPrepare;
        }
    }

    ///////////////////////////////////////////////////////////////////////////////////////////////

    /// <summary>
    /// Determines if calls into key members pertaining to the lifecycle of
    /// connections and their associated classes will be logged, regardless
    /// of the flags for the associated connection.
    /// </summary>
    /// <returns>
    /// Non-zero to log calls into key members pertaining to the lifecycle of
    /// connections and their associated classes (e.g. LINQ, EF6, etc).
    /// </returns>
    internal static bool ForceLogLifecycle()
    {
        lock (syncRoot)
        {
            if (forceLogLifecycle == null)
            {
                if (UnsafeNativeMethods.GetSettingValue(
                        "SQLite_ForceLogLifecycle", null) != null)
                {
                    forceLogLifecycle = true;
                }
                else
                {
                    forceLogLifecycle = false;
                }
            }

            return (bool)forceLogLifecycle;
        }
    }
    #endregion

    ///////////////////////////////////////////////////////////////////////////////////////////////

    internal override SQLiteStatement Prepare(SQLiteConnection cnn, string strSql, SQLiteStatement previous, uint timeoutMS, ref string strRemain)
    {
      if (!String.IsNullOrEmpty(strSql)) strSql = strSql.Trim();

            new SQLiteDbTypeMapping("INTEGER32", DbType.Int32, false),
            new SQLiteDbTypeMapping("INTEGER64", DbType.Int64, false),
            new SQLiteDbTypeMapping("LOGICAL", DbType.Boolean, false),
            new SQLiteDbTypeMapping("LONG", DbType.Int64, false),
            new SQLiteDbTypeMapping("LONGCHAR", DbType.String, false),
            new SQLiteDbTypeMapping("LONGTEXT", DbType.String, false),
            new SQLiteDbTypeMapping("LONGVARCHAR", DbType.String, false),
            new SQLiteDbTypeMapping("MEDIUMINT", DbType.Int32, false),
            new SQLiteDbTypeMapping("MEDIUMUINT", DbType.UInt32, false),
            new SQLiteDbTypeMapping("MEMO", DbType.String, false),
            new SQLiteDbTypeMapping("MONEY", DbType.Decimal, false),
            new SQLiteDbTypeMapping("NCHAR", DbType.StringFixedLength, true),
            new SQLiteDbTypeMapping("NOTE", DbType.String, false),
            new SQLiteDbTypeMapping("NTEXT", DbType.String, false),
            new SQLiteDbTypeMapping("NUMBER", DbType.Decimal, false),
            new SQLiteDbTypeMapping("NUMERIC", DbType.Decimal, false),

  set result
} -cleanup {
  cleanupDb $fileName

  unset -nocomplain error result db fileName
} -constraints {eagle System.Data.SQLite.Encryption monoBug28 command.sql\
compile.DATA SQLite System.Data.SQLite} -match regexp -result {^1 \{(?:file is\
not a database|database disk image is malformed)\} 1 \{(?:file is not a\
database|database disk image is malformed)\} 0 1 0 2$}}

###############################################################################

runTest {test data-1.40 {encrypted database, wrong password} -setup {
  setupDb [set fileName data-1.40.db] "" "" "" "" "Password=12345;"
} -body {
  sql execute $db "CREATE TABLE t1(x);"

  set result
} -cleanup {
  cleanupDb $fileName

  unset -nocomplain error result db fileName
} -constraints {eagle System.Data.SQLite.Encryption monoBug28 command.sql\
compile.DATA SQLite System.Data.SQLite} -match regexp -result {^1 \{(?:file is\
not a database|database disk image is malformed)\} 1 \{(?:file is not a\
database|database disk image is malformed)\} 0 1 0 2$}}

###############################################################################

runTest {test data-1.41 {encrypted database, password w/start-space} -setup {
  setupDb [set fileName data-1.41.db] "" "" "" "" "Password= 1234;"
} -body {
  sql execute $db "CREATE TABLE t1(x);"

  setupDb $fileName "" "" "" "" "Password= 1234;" true false

  lappend result [catch {sql execute $db \
      "INSERT INTO t1 (x) VALUES(1);"} error] $error

  lappend result [catch {sql execute -execute scalar $db \
      "SELECT COUNT(*) FROM t1;"} error] $error

  cleanupDb $fileName db true false false

  lappend result [expr {
      [string equal [readDbFileHeader [file join \
      [getDatabaseDirectory] $fileName]] \
      [getDbFileHeader]] == ![page1MustBeEncrypted]
  }]

  set result
} -cleanup {
  cleanupDb $fileName

  unset -nocomplain error result db fileName
} -constraints {eagle System.Data.SQLite.Encryption monoBug28 command.sql\
compile.DATA SQLite System.Data.SQLite} -result {0 1 0 1 0 1 0 3 True}}

###############################################################################

runTest {test data-1.42 {encrypted database, w/quoted-start-space} -setup {
  setupDb [set fileName data-1.42.db] "" "" "" "" "Password=\" 1234\";"
} -body {
  sql execute $db "CREATE TABLE t1(x);"

  set result
} -cleanup {
  cleanupDb $fileName

  unset -nocomplain error result db fileName
} -constraints {eagle System.Data.SQLite.Encryption monoBug28 command.sql\
compile.DATA SQLite System.Data.SQLite} -match regexp -result {^1 \{(?:file is\
not a database|database disk image is malformed)\} 1 \{(?:file is not a\
database|database disk image is malformed)\} 0 1 0 2$}}

###############################################################################

runTest {test data-1.43 {encrypted database, password w/mid-space} -setup {
  setupDb [set fileName data-1.43.db] "" "" "" "" "Password=12 45;"
} -body {
  sql execute $db "CREATE TABLE t1(x);"

  set result
} -cleanup {
  cleanupDb $fileName

  unset -nocomplain error result db fileName
} -constraints {eagle System.Data.SQLite.Encryption monoBug28 command.sql\
compile.DATA SQLite System.Data.SQLite} -match regexp -result {^1 \{(?:file is\
not a database|database disk image is malformed)\} 1 \{(?:file is not a\
database|database disk image is malformed)\} 0 1 0 2$}}

###############################################################################

runTest {test data-1.44 {encrypted database, password w/end-space} -setup {
  setupDb [set fileName data-1.44.db] "" "" "" "" "Password=1234 ;"
} -body {
  sql execute $db "CREATE TABLE t1(x);"

  setupDb $fileName "" "" "" "" "Password=1234 ;" true false

  lappend result [catch {sql execute $db \
      "INSERT INTO t1 (x) VALUES(1);"} error] $error

  lappend result [catch {sql execute -execute scalar $db \
      "SELECT COUNT(*) FROM t1;"} error] $error

  cleanupDb $fileName db true false false

  lappend result [expr {
      [string equal [readDbFileHeader [file join \
      [getDatabaseDirectory] $fileName]] \
      [getDbFileHeader]] == ![page1MustBeEncrypted]
  }]

  set result
} -cleanup {
  cleanupDb $fileName

  unset -nocomplain error result db fileName
} -constraints {eagle System.Data.SQLite.Encryption monoBug28 command.sql\
compile.DATA SQLite System.Data.SQLite} -result {0 1 0 1 0 1 0 3 True}}

###############################################################################

runTest {test data-1.45 {encrypted database, w/quoted-end-space} -setup {
  setupDb [set fileName data-1.45.db] "" "" "" "" "Password=\"1234 \";"
} -body {
  sql execute $db "CREATE TABLE t1(x);"

  set result
} -cleanup {
  cleanupDb $fileName

  unset -nocomplain error result db fileName
} -constraints {eagle System.Data.SQLite.Encryption monoBug28 command.sql\
compile.DATA SQLite System.Data.SQLite} -match regexp -result {^1 \{(?:file is\
not a database|database disk image is malformed)\} 1 \{(?:file is not a\
database|database disk image is malformed)\} 0 1 0 2$}}

###############################################################################

runTest {test data-1.46 {encrypted database, password via builder} -setup {
  setupDb [set fileName data-1.46.db] "" "" "" "" "Password=67 89;"
} -body {
  sql execute $db "CREATE TABLE t1(x);"

  setupDb $fileName "" "" "" "" "Password=\"67 89\";" true false

  lappend result [catch {sql execute $db \
      "INSERT INTO t1 (x) VALUES(1);"} error] $error

  lappend result [catch {sql execute -execute scalar $db \
      "SELECT COUNT(*) FROM t1;"} error] $error

  cleanupDb $fileName db true false false

  lappend result [expr {
      [string equal [readDbFileHeader [file join \
      [getDatabaseDirectory] $fileName]] \
      [getDbFileHeader]] == ![page1MustBeEncrypted]
  }]

  set result
} -cleanup {
  unset -nocomplain connection

  cleanupDb $fileName; # NOTE: After object disposal.

  unset -nocomplain connectionStringBuilder error result db fileName
} -constraints {eagle command.object System.Data.SQLite.Encryption monoBug28\
command.sql compile.DATA SQLite System.Data.SQLite} -result \
{0 1 0 1 0 1 0 3 True}}

###############################################################################

runTest {test data-1.47 {quoted connection string properties} -setup {
  unset -nocomplain result list pair strings string
} -body {
  set result [list]

runTest {test data-1.55 {SQLiteConvert TypeNameToDbType} -setup {
  unset -nocomplain result typeName
} -body {
  foreach typeName [list \
      BIGINT BIGUINT BINARY BIT BLOB BOOL BOOLEAN CHAR CLOB COUNTER CURRENCY \
      DATE DATETIME DECIMAL DOUBLE FLOAT GENERAL GUID IDENTITY IMAGE INT INT8 \
      INT16 INT32 INT64 INTEGER INTEGER8 INTEGER16 INTEGER32 INTEGER64 \
      LOGICAL LONG LONGCHAR LONGTEXT LONGVARCHAR MEDIUMINT MEDIUMUINT MEMO \
      MONEY NCHAR NOTE NTEXT NUMBER NUMERIC NVARCHAR OLEOBJECT RAW REAL SINGLE \
      SMALLDATE SMALLINT SMALLUINT STRING TEXT TIME TIMESTAMP TINYINT TINYSINT \
      UINT UINT8 UINT16 UINT32 UINT64 ULONG UNIQUEIDENTIFIER UNSIGNEDINTEGER \
      UNSIGNEDINTEGER8 UNSIGNEDINTEGER16 UNSIGNEDINTEGER32 UNSIGNEDINTEGER64 \
      VARBINARY VARCHAR VARCHAR2 YESNO] {
    lappend result [list $typeName [object invoke -flags +NonPublic \
        System.Data.SQLite.SQLiteConvert TypeNameToDbType null $typeName None]]
  }
  set result
} -cleanup {
  unset -nocomplain result typeName
} -constraints {eagle command.object System.Data.SQLite} -result {{BIGINT\
Int64} {BIGUINT UInt64} {BINARY Binary} {BIT Boolean} {BLOB Binary} {BOOL\
Boolean} {BOOLEAN Boolean} {CHAR AnsiStringFixedLength} {CLOB String} {COUNTER\
Int64} {CURRENCY Decimal} {DATE DateTime} {DATETIME DateTime} {DECIMAL Decimal}\
{DOUBLE Double} {FLOAT Double} {GENERAL Binary} {GUID Guid} {IDENTITY Int64}\
{IMAGE Binary} {INT Int32} {INT8 SByte} {INT16 Int16} {INT32 Int32} {INT64\
Int64} {INTEGER Int64} {INTEGER8 SByte} {INTEGER16 Int16} {INTEGER32 Int32}\
{INTEGER64 Int64} {LOGICAL Boolean} {LONG Int64} {LONGCHAR String} {LONGTEXT\
String} {LONGVARCHAR String} {MEDIUMINT Int32} {MEDIUMUINT UInt32} {MEMO\
String} {MONEY Decimal} {NCHAR StringFixedLength} {NOTE String} {NTEXT String}\
{NUMBER Decimal} {NUMERIC Decimal} {NVARCHAR String} {OLEOBJECT Binary} {RAW\
Binary} {REAL Double} {SINGLE Single} {SMALLDATE DateTime} {SMALLINT Int16}\
{SMALLUINT UInt16} {STRING String} {TEXT String} {TIME DateTime} {TIMESTAMP\
DateTime} {TINYINT Byte} {TINYSINT SByte} {UINT UInt32} {UINT8 Byte} {UINT16\
UInt16} {UINT32 UInt32} {UINT64 UInt64} {ULONG UInt64} {UNIQUEIDENTIFIER Guid}\
{UNSIGNEDINTEGER UInt64} {UNSIGNEDINTEGER8 Byte} {UNSIGNEDINTEGER16 UInt16}\
{UNSIGNEDINTEGER32 UInt32} {UNSIGNEDINTEGER64 UInt64} {VARBINARY Binary}\
{VARCHAR AnsiString} {VARCHAR2 AnsiString} {YESNO Boolean}}}

###############################################################################

runTest {test data-1.56 {totype extension} -setup {
  setupDb [set fileName data-1.56.db]
} -body {
  set connection [getDbConnection]

  freeDbConnection

  unset -nocomplain dataRow dataRows dataTable results connection db fileName
} -constraints {eagle command.object monoBug28 command.sql compile.DATA SQLite\
System.Data.SQLite} -result {{autoincrement 12} {bigint 12} {binary 1} {bit 3}\
{blob 1} {bool 3} {boolean 3} {char 16} {counter 12} {currency 7} {date 6}\
{datetime 6} {decimal 7} {double 8} {float 8} {general 1} {guid 9} {identity\
12} {image 1} {int 11} {integer 12} {logical 3} {long 12} {longtext 16}\
{mediumint 11} {memo 16} {money 7} {nchar 16} {note 16} {ntext 16} {numeric 7}\
{nvarchar 16} {oleobject 1} {real 8} {single 15} {smalldate 6} {smallint 10}\
{string 16} {text 16} {time 6} {timestamp 6} {tinyint 2} {uniqueidentifier 9}\
{varbinary 1} {varchar 16} {yesno 3}}}

###############################################################################

runSQLiteTestEpilogue
runTestEpilogue

  set result
} -cleanup {
  cleanupDb $fileName

  unset -nocomplain error result db fileName
} -constraints {eagle System.Data.SQLite.Encryption monoBug28 command.sql\
compile.DATA SQLite System.Data.SQLite} -match regexp -result {^1 \{(?:file is\
not a database|database disk image is malformed)\} 1 \{(?:file is not a\
database|database disk image is malformed)\} 0 1 0 2$}}

###############################################################################

runTest {test tkt-1c456ae75f-1.2 {database, hex password} -setup {
  setupDb [set fileName tkt-1c456ae75f-1.2.db] "" "" "" "" \
      "HexPassword=3132333435;"
} -body {

  setupDb $fileName "" "" "" "" "HexPassword=3132333435;" true false

  lappend result [catch {sql execute $db \
      "INSERT INTO t1 (x) VALUES(1);"} error] $error

  lappend result [catch {sql execute -execute scalar $db \
      "SELECT COUNT(*) FROM t1;"} error] $error

  cleanupDb $fileName db true false false

  lappend result [expr {
      [string equal [readDbFileHeader [file join \
      [getDatabaseDirectory] $fileName]] \
      [getDbFileHeader]] == ![page1MustBeEncrypted]
  }]

  set result
} -cleanup {
  cleanupDb $fileName

  unset -nocomplain error result db fileName
} -constraints {eagle System.Data.SQLite.Encryption monoBug28 command.sql\
compile.DATA SQLite System.Data.SQLite} -result {0 1 0 1 0 1 0 3 True}}

###############################################################################

runTest {test tkt-1c456ae75f-1.3 {database, wrong hex password} -setup {
  setupDb [set fileName tkt-1c456ae75f-1.3.db] "" "" "" "" \
      "HexPassword=3132333435;"
} -body {

  set result
} -cleanup {
  cleanupDb $fileName

  unset -nocomplain error result db fileName
} -constraints {eagle System.Data.SQLite.Encryption monoBug28 command.sql\
compile.DATA SQLite System.Data.SQLite} -match regexp -result {^1 \{(?:file is\
not a database|database disk image is malformed)\} 1 \{(?:file is not a\
database|database disk image is malformed)\} 0 1 0 2$}}

###############################################################################

runTest {test tkt-1c456ae75f-1.4 {database, hex password via builder} -setup {
  setupDb [set fileName tkt-1c456ae75f-1.4.db] "" "" "" "" \
      "HexPassword=3132333435;"
} -body {

  setupDb $fileName "" "" "" "" "Password=\"12345\";" true false

  lappend result [catch {sql execute $db \
      "INSERT INTO t1 (x) VALUES(1);"} error] $error

  lappend result [catch {sql execute -execute scalar $db \
      "SELECT COUNT(*) FROM t1;"} error] $error

  cleanupDb $fileName db true false false

  lappend result [expr {
      [string equal [readDbFileHeader [file join \
      [getDatabaseDirectory] $fileName]] \
      [getDbFileHeader]] == ![page1MustBeEncrypted]
  }]

  set result
} -cleanup {
  unset -nocomplain connection

  cleanupDb $fileName; # NOTE: After object disposal.

  unset -nocomplain connectionStringBuilder error result db fileName
} -constraints {eagle command.object System.Data.SQLite.Encryption monoBug28\
command.sql compile.DATA SQLite System.Data.SQLite} -result \
{0 1 0 1 0 1 0 3 True}}

###############################################################################

runSQLiteTestEpilogue
runTestEpilogue

      a11 INT64,             -- Int64
      a12 INTEGER,           -- Int64
      a13 INTEGER8,          -- SByte
      a14 INTEGER16,         -- Int16
      a15 INTEGER32,         -- Int32
      a16 INTEGER64,         -- Int64
      a17 LONG,              -- Int64
      a18 MEDIUMINT,         -- Int32
      a19 MEDIUMUINT,        -- UInt32
      a20 SMALLINT,          -- Int16
      a21 SMALLUINT,         -- UInt16
      a22 TINYINT,           -- Byte
      a23 TINYSINT,          -- SByte
      a24 UINT,              -- UInt32
      a25 UINT8,             -- Byte
      a26 UINT16,            -- UInt16
      a27 UINT32,            -- UInt32
      a28 UINT64,            -- UInt64
      a29 ULONG,             -- UInt64
      a30 UNSIGNEDINTEGER,   -- UInt32
      a31 UNSIGNEDINTEGER8,  -- Byte
      a32 UNSIGNEDINTEGER16, -- UInt16
      a33 UNSIGNEDINTEGER32, -- UInt32
      a34 UNSIGNEDINTEGER64  -- UInt64
    );
  }

  #
  # NOTE: These are the numeric values being tested against all the types in
  #       the database table defined above.  This list includes values that
  #       are out-of-bounds for each primitive integral type.

      32767 32768 \
      65535 65536 \
      2147483647 2147483648 \
      4294967295 4294967296 \
      9223372036854775807 9223372036854775808 \
      18446744073709551615 18446744073709551616]

  for {set index 1} {$index <= 34} {incr index} {
    set name [appendArgs a [format %02d $index]]
    foreach value $values {
      sql execute $db [subst {
        INSERT INTO t1 (a00, $name) VALUES('$name', $value);
      }]
    }
  }

  set results [list]

  for {set index 1} {$index <= 34} {incr index} {
    set name [appendArgs a [format %02d $index]]
    set count [sql execute -execute scalar $db [subst {
      SELECT COUNT(*) FROM t1 WHERE a00 = '$name';
    }]]
    for {set offset 0} {$offset < $count} {incr offset} {
      set code [catch {
        sql execute -execute scalar $db [subst {

a17 22 True 4294967296 0 4294967296
a17 23 True 9223372036854775807 0 9223372036854775807
a17 24 False 9223372036854775808 0 9223372036854775807
a17 25 False 18446744073709551615 0 9223372036854775807
a17 26 False 18446744073709551616 0 9223372036854775807
a18 0 False -9223372036854775809 0 0
a18 1 False -9223372036854775808 0 0
a18 2 False -2147483649 0 2147483647
a18 3 True -2147483648 0 -2147483648
a18 4 True -32769 0 -32769
a18 5 True -32768 0 -32768
a18 6 True -129 0 -129
a18 7 True -128 0 -128
a18 8 True -1 0 -1
a18 9 True 0 0 0
a18 10 True 1 0 1
a18 11 True 127 0 127
a18 12 True 128 0 128
a18 13 True 255 0 255
a18 14 True 256 0 256
a18 15 True 32767 0 32767
a18 16 True 32768 0 32768
a18 17 True 65535 0 65535
a18 18 True 65536 0 65536
a18 19 True 2147483647 0 2147483647
a18 20 False 2147483648 0 -2147483648
a18 21 False 4294967295 0 -1
a18 22 False 4294967296 0 0
a18 23 False 9223372036854775807 0 -1
a18 24 False 9223372036854775808 0 -1
a18 25 False 18446744073709551615 0 -1
a18 26 False 18446744073709551616 0 -1
a19 0 False -9223372036854775809 0 0
a19 1 False -9223372036854775808 0 0
a19 2 False -2147483649 0 2147483647
a19 3 False -2147483648 0 2147483648
a19 4 False -32769 0 4294934527
a19 5 False -32768 0 4294934528
a19 6 False -129 0 4294967167
a19 7 False -128 0 4294967168
a19 8 False -1 0 4294967295
a19 9 True 0 0 0
a19 10 True 1 0 1
a19 11 True 127 0 127
a19 12 True 128 0 128
a19 13 True 255 0 255
a19 14 True 256 0 256
a19 15 True 32767 0 32767
a19 16 True 32768 0 32768
a19 17 True 65535 0 65535
a19 18 True 65536 0 65536
a19 19 True 2147483647 0 2147483647
a19 20 True 2147483648 0 2147483648
a19 21 True 4294967295 0 4294967295
a19 22 False 4294967296 0 0
a19 23 False 9223372036854775807 0 4294967295
a19 24 False 9223372036854775808 0 4294967295
a19 25 False 18446744073709551615 0 4294967295
a19 26 False 18446744073709551616 0 4294967295
a20 0 False -9223372036854775809 0 0
a20 1 False -9223372036854775808 0 0
a20 2 False -2147483649 0 -1
a20 3 False -2147483648 0 0
a20 4 False -32769 0 32767
a20 5 True -32768 0 -32768
a20 6 True -129 0 -129
a20 7 True -128 0 -128
a20 8 True -1 0 -1
a20 9 True 0 0 0
a20 10 True 1 0 1
a20 11 True 127 0 127
a20 12 True 128 0 128
a20 13 True 255 0 255
a20 14 True 256 0 256
a20 15 True 32767 0 32767
a20 16 False 32768 0 -32768
a20 17 False 65535 0 -1
a20 18 False 65536 0 0
a20 19 False 2147483647 0 -1
a20 20 False 2147483648 0 0
a20 21 False 4294967295 0 -1
a20 22 False 4294967296 0 0
a20 23 False 9223372036854775807 0 -1
a20 24 False 9223372036854775808 0 -1
a20 25 False 18446744073709551615 0 -1
a20 26 False 18446744073709551616 0 -1
a21 0 False -9223372036854775809 0 0
a21 1 False -9223372036854775808 0 0
a21 2 False -2147483649 0 65535
a21 3 False -2147483648 0 0
a21 4 False -32769 0 32767
a21 5 False -32768 0 32768
a21 6 False -129 0 65407
a21 7 False -128 0 65408
a21 8 False -1 0 65535
a21 9 True 0 0 0
a21 10 True 1 0 1
a21 11 True 127 0 127
a21 12 True 128 0 128
a21 13 True 255 0 255
a21 14 True 256 0 256
a21 15 True 32767 0 32767
a21 16 True 32768 0 32768
a21 17 True 65535 0 65535
a21 18 False 65536 0 0
a21 19 False 2147483647 0 65535
a21 20 False 2147483648 0 0
a21 21 False 4294967295 0 65535
a21 22 False 4294967296 0 0
a21 23 False 9223372036854775807 0 65535
a21 24 False 9223372036854775808 0 65535
a21 25 False 18446744073709551615 0 65535
a21 26 False 18446744073709551616 0 65535
a22 0 False -9223372036854775809 0 0
a22 1 False -9223372036854775808 0 0
a22 2 False -2147483649 0 255
a22 3 False -2147483648 0 0
a22 4 False -32769 0 255
a22 5 False -32768 0 0
a22 6 False -129 0 127
a22 7 False -128 0 128
a22 8 False -1 0 255
a22 9 True 0 0 0
a22 10 True 1 0 1
a22 11 True 127 0 127
a22 12 True 128 0 128
a22 13 True 255 0 255
a22 14 False 256 0 0
a22 15 False 32767 0 255
a22 16 False 32768 0 0
a22 17 False 65535 0 255
a22 18 False 65536 0 0
a22 19 False 2147483647 0 255
a22 20 False 2147483648 0 0
a22 21 False 4294967295 0 255
a22 22 False 4294967296 0 0
a22 23 False 9223372036854775807 0 255
a22 24 False 9223372036854775808 0 255
a22 25 False 18446744073709551615 0 255
a22 26 False 18446744073709551616 0 255
a23 0 False -9223372036854775809 0 0
a23 1 False -9223372036854775808 0 0
a23 2 False -2147483649 0 -1
a23 3 False -2147483648 0 0
a23 4 False -32769 0 -1
a23 5 False -32768 0 0
a23 6 False -129 0 127
a23 7 True -128 0 -128
a23 8 True -1 0 -1
a23 9 True 0 0 0
a23 10 True 1 0 1
a23 11 True 127 0 127
a23 12 False 128 0 -128
a23 13 False 255 0 -1
a23 14 False 256 0 0
a23 15 False 32767 0 -1
a23 16 False 32768 0 0
a23 17 False 65535 0 -1
a23 18 False 65536 0 0
a23 19 False 2147483647 0 -1
a23 20 False 2147483648 0 0
a23 21 False 4294967295 0 -1
a23 22 False 4294967296 0 0
a23 23 False 9223372036854775807 0 -1
a23 24 False 9223372036854775808 0 -1
a23 25 False 18446744073709551615 0 -1
a23 26 False 18446744073709551616 0 -1
a24 0 False -9223372036854775809 0 0
a24 1 False -9223372036854775808 0 0
a24 2 False -2147483649 0 2147483647
a24 3 False -2147483648 0 2147483648
a24 4 False -32769 0 4294934527
a24 5 False -32768 0 4294934528
a24 6 False -129 0 4294967167
a24 7 False -128 0 4294967168
a24 8 False -1 0 4294967295
a24 9 True 0 0 0
a24 10 True 1 0 1
a24 11 True 127 0 127
a24 12 True 128 0 128
a24 13 True 255 0 255
a24 14 True 256 0 256
a24 15 True 32767 0 32767
a24 16 True 32768 0 32768
a24 17 True 65535 0 65535
a24 18 True 65536 0 65536
a24 19 True 2147483647 0 2147483647
a24 20 True 2147483648 0 2147483648
a24 21 True 4294967295 0 4294967295
a24 22 False 4294967296 0 0
a24 23 False 9223372036854775807 0 4294967295
a24 24 False 9223372036854775808 0 4294967295
a24 25 False 18446744073709551615 0 4294967295
a24 26 False 18446744073709551616 0 4294967295
a25 0 False -9223372036854775809 0 0
a25 1 False -9223372036854775808 0 0
a25 2 False -2147483649 0 255
a25 3 False -2147483648 0 0
a25 4 False -32769 0 255
a25 5 False -32768 0 0
a25 6 False -129 0 127
a25 7 False -128 0 128
a25 8 False -1 0 255
a25 9 True 0 0 0
a25 10 True 1 0 1
a25 11 True 127 0 127
a25 12 True 128 0 128
a25 13 True 255 0 255
a25 14 False 256 0 0
a25 15 False 32767 0 255
a25 16 False 32768 0 0
a25 17 False 65535 0 255
a25 18 False 65536 0 0
a25 19 False 2147483647 0 255
a25 20 False 2147483648 0 0
a25 21 False 4294967295 0 255
a25 22 False 4294967296 0 0
a25 23 False 9223372036854775807 0 255
a25 24 False 9223372036854775808 0 255
a25 25 False 18446744073709551615 0 255
a25 26 False 18446744073709551616 0 255
a26 0 False -9223372036854775809 0 0
a26 1 False -9223372036854775808 0 0
a26 2 False -2147483649 0 65535
a26 3 False -2147483648 0 0
a26 4 False -32769 0 32767
a26 5 False -32768 0 32768
a26 6 False -129 0 65407
a26 7 False -128 0 65408
a26 8 False -1 0 65535
a26 9 True 0 0 0
a26 10 True 1 0 1
a26 11 True 127 0 127
a26 12 True 128 0 128
a26 13 True 255 0 255
a26 14 True 256 0 256
a26 15 True 32767 0 32767
a26 16 True 32768 0 32768
a26 17 True 65535 0 65535
a26 18 False 65536 0 0
a26 19 False 2147483647 0 65535
a26 20 False 2147483648 0 0
a26 21 False 4294967295 0 65535
a26 22 False 4294967296 0 0
a26 23 False 9223372036854775807 0 65535
a26 24 False 9223372036854775808 0 65535
a26 25 False 18446744073709551615 0 65535
a26 26 False 18446744073709551616 0 65535
a27 0 False -9223372036854775809 0 0
a27 1 False -9223372036854775808 0 0
a27 2 False -2147483649 0 2147483647
a27 3 False -2147483648 0 2147483648
a27 4 False -32769 0 4294934527
a27 5 False -32768 0 4294934528
a27 6 False -129 0 4294967167
a27 7 False -128 0 4294967168
a27 8 False -1 0 4294967295
a27 9 True 0 0 0
a27 10 True 1 0 1
a27 11 True 127 0 127
a27 12 True 128 0 128
a27 13 True 255 0 255
a27 14 True 256 0 256
a27 15 True 32767 0 32767
a27 16 True 32768 0 32768
a27 17 True 65535 0 65535
a27 18 True 65536 0 65536
a27 19 True 2147483647 0 2147483647
a27 20 True 2147483648 0 2147483648
a27 21 True 4294967295 0 4294967295
a27 22 False 4294967296 0 0
a27 23 False 9223372036854775807 0 4294967295
a27 24 False 9223372036854775808 0 4294967295
a27 25 False 18446744073709551615 0 4294967295
a27 26 False 18446744073709551616 0 4294967295
a28 0 False -9223372036854775809 0 9223372036854775808
a28 1 False -9223372036854775808 0 9223372036854775808
a28 2 False -2147483649 0 18446744071562067967
a28 3 False -2147483648 0 18446744071562067968
a28 4 False -32769 0 18446744073709518847
a28 5 False -32768 0 18446744073709518848
a28 6 False -129 0 18446744073709551487

a28 20 True 2147483648 0 2147483648
a28 21 True 4294967295 0 4294967295
a28 22 True 4294967296 0 4294967296
a28 23 True 9223372036854775807 0 9223372036854775807
a28 24 False 9223372036854775808 0 9223372036854775807
a28 25 False 18446744073709551615 0 9223372036854775807
a28 26 False 18446744073709551616 0 9223372036854775807
a29 0 False -9223372036854775809 0 9223372036854775808
a29 1 False -9223372036854775808 0 9223372036854775808
a29 2 False -2147483649 0 18446744071562067967
a29 3 False -2147483648 0 18446744071562067968
a29 4 False -32769 0 18446744073709518847
a29 5 False -32768 0 18446744073709518848
a29 6 False -129 0 18446744073709551487
a29 7 False -128 0 18446744073709551488
a29 8 False -1 0 18446744073709551615
a29 9 True 0 0 0
a29 10 True 1 0 1
a29 11 True 127 0 127
a29 12 True 128 0 128
a29 13 True 255 0 255
a29 14 True 256 0 256
a29 15 True 32767 0 32767
a29 16 True 32768 0 32768
a29 17 True 65535 0 65535
a29 18 True 65536 0 65536
a29 19 True 2147483647 0 2147483647
a29 20 True 2147483648 0 2147483648
a29 21 True 4294967295 0 4294967295
a29 22 True 4294967296 0 4294967296
a29 23 True 9223372036854775807 0 9223372036854775807
a29 24 False 9223372036854775808 0 9223372036854775807
a29 25 False 18446744073709551615 0 9223372036854775807
a29 26 False 18446744073709551616 0 9223372036854775807
a30 0 False -9223372036854775809 0 9223372036854775808
a30 1 False -9223372036854775808 0 9223372036854775808
a30 2 False -2147483649 0 18446744071562067967
a30 3 False -2147483648 0 18446744071562067968
a30 4 False -32769 0 18446744073709518847
a30 5 False -32768 0 18446744073709518848
a30 6 False -129 0 18446744073709551487
a30 7 False -128 0 18446744073709551488
a30 8 False -1 0 18446744073709551615
a30 9 True 0 0 0
a30 10 True 1 0 1
a30 11 True 127 0 127
a30 12 True 128 0 128
a30 13 True 255 0 255
a30 14 True 256 0 256
a30 15 True 32767 0 32767
a30 16 True 32768 0 32768
a30 17 True 65535 0 65535
a30 18 True 65536 0 65536
a30 19 True 2147483647 0 2147483647
a30 20 True 2147483648 0 2147483648
a30 21 True 4294967295 0 4294967295
a30 22 True 4294967296 0 4294967296
a30 23 True 9223372036854775807 0 9223372036854775807
a30 24 False 9223372036854775808 0 9223372036854775807
a30 25 False 18446744073709551615 0 9223372036854775807
a30 26 False 18446744073709551616 0 9223372036854775807
a31 0 False -9223372036854775809 0 0
a31 1 False -9223372036854775808 0 0
a31 2 False -2147483649 0 255
a31 3 False -2147483648 0 0
a31 4 False -32769 0 255
a31 5 False -32768 0 0
a31 6 False -129 0 127
a31 7 False -128 0 128
a31 8 False -1 0 255
a31 9 True 0 0 0
a31 10 True 1 0 1
a31 11 True 127 0 127
a31 12 True 128 0 128
a31 13 True 255 0 255
a31 14 False 256 0 0
a31 15 False 32767 0 255
a31 16 False 32768 0 0
a31 17 False 65535 0 255
a31 18 False 65536 0 0
a31 19 False 2147483647 0 255
a31 20 False 2147483648 0 0
a31 21 False 4294967295 0 255
a31 22 False 4294967296 0 0
a31 23 False 9223372036854775807 0 255
a31 24 False 9223372036854775808 0 255
a31 25 False 18446744073709551615 0 255
a31 26 False 18446744073709551616 0 255
a32 0 False -9223372036854775809 0 0
a32 1 False -9223372036854775808 0 0
a32 2 False -2147483649 0 65535
a32 3 False -2147483648 0 0
a32 4 False -32769 0 32767
a32 5 False -32768 0 32768
a32 6 False -129 0 65407
a32 7 False -128 0 65408
a32 8 False -1 0 65535
a32 9 True 0 0 0
a32 10 True 1 0 1
a32 11 True 127 0 127
a32 12 True 128 0 128
a32 13 True 255 0 255
a32 14 True 256 0 256
a32 15 True 32767 0 32767
a32 16 True 32768 0 32768
a32 17 True 65535 0 65535
a32 18 False 65536 0 0
a32 19 False 2147483647 0 65535
a32 20 False 2147483648 0 0
a32 21 False 4294967295 0 65535
a32 22 False 4294967296 0 0
a32 23 False 9223372036854775807 0 65535
a32 24 False 9223372036854775808 0 65535
a32 25 False 18446744073709551615 0 65535
a32 26 False 18446744073709551616 0 65535
a33 0 False -9223372036854775809 0 0
a33 1 False -9223372036854775808 0 0
a33 2 False -2147483649 0 2147483647
a33 3 False -2147483648 0 2147483648
a33 4 False -32769 0 4294934527
a33 5 False -32768 0 4294934528
a33 6 False -129 0 4294967167
a33 7 False -128 0 4294967168
a33 8 False -1 0 4294967295
a33 9 True 0 0 0
a33 10 True 1 0 1
a33 11 True 127 0 127
a33 12 True 128 0 128
a33 13 True 255 0 255
a33 14 True 256 0 256
a33 15 True 32767 0 32767
a33 16 True 32768 0 32768
a33 17 True 65535 0 65535
a33 18 True 65536 0 65536
a33 19 True 2147483647 0 2147483647
a33 20 True 2147483648 0 2147483648
a33 21 True 4294967295 0 4294967295
a33 22 False 4294967296 0 0
a33 23 False 9223372036854775807 0 4294967295
a33 24 False 9223372036854775808 0 4294967295
a33 25 False 18446744073709551615 0 4294967295
a33 26 False 18446744073709551616 0 4294967295
a34 0 False -9223372036854775809 0 9223372036854775808
a34 1 False -9223372036854775808 0 9223372036854775808
a34 2 False -2147483649 0 18446744071562067967
a34 3 False -2147483648 0 18446744071562067968
a34 4 False -32769 0 18446744073709518847
a34 5 False -32768 0 18446744073709518848
a34 6 False -129 0 18446744073709551487
a34 7 False -128 0 18446744073709551488
a34 8 False -1 0 18446744073709551615
a34 9 True 0 0 0
a34 10 True 1 0 1
a34 11 True 127 0 127
a34 12 True 128 0 128
a34 13 True 255 0 255
a34 14 True 256 0 256
a34 15 True 32767 0 32767
a34 16 True 32768 0 32768
a34 17 True 65535 0 65535
a34 18 True 65536 0 65536
a34 19 True 2147483647 0 2147483647
a34 20 True 2147483648 0 2147483648
a34 21 True 4294967295 0 4294967295
a34 22 True 4294967296 0 4294967296
a34 23 True 9223372036854775807 0 9223372036854775807
a34 24 False 9223372036854775808 0 9223372036854775807
a34 25 False 18446744073709551615 0 9223372036854775807
a34 26 False 18446744073709551616 0 9223372036854775807
$}}

###############################################################################

runTest {test tkt-c010fa6584-1.2 {UInt32 parameter} -setup {
  setupDb [set fileName tkt-c010fa6584-1.2.db]
} -body {

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title></title>
</head>
<body>
ADO.NET SQLite Data Provider<br />
Version 1.0.113.0 - June XX, 2020 <font color="red">(release scheduled)</font><br />
Using <a href="https://www.sqlite.org/releaselog/3_32_0.html">SQLite 3.32.0</a><br />Originally written by Robert Simpson<br />
Released to the public domain, use at your own risk!<br />
Official provider website:&nbsp;<a href="https://system.data.sqlite.org/">https://system.data.sqlite.org/</a><br />
Legacy versions:&nbsp;<a href="https://sourceforge.net/projects/sqlite-dotnet2/">https://sourceforge.net/projects/sqlite-dotnet2/</a><br />
<br />
The current development version can be downloaded from <a href="https://system.data.sqlite.org/index.html/timeline?y=ci">
https://system.data.sqlite.org/index.html/timeline?y=ci</a>
<br />

designed for robustness and maximum backward compatibility with previously
released versions of System.Data.SQLite.
</p>

<h2><b>Version History</b></h2>

<p>
    <b>1.0.113.0 - June XX, 2020 <font color="red">(release scheduled)</font></b>
</p>
<ul>
    <li>Updated to <a href="https://www.sqlite.org/releaselog/3_32_0.html">SQLite 3.32.0</a>.</li>
    <li>Add SQLite_ForceLogLifecycle environment variable to force logging of calls into key members pertaining to the lifecycle of connections and their associated classes (e.g. LINQ, EF6, etc).</li>

    <li>Support automatic value conversions for columns with a declared type of MEDIUMINT or MEDIUMUINT. Pursuant to [515cb60b10].</li>
    <li>Add preliminary support for the .NET Framework 4.8.</li>
</ul>
<p>
    <b>1.0.112.3 - Xxxx XX, 2020</b>
</p>
<ul>
    <li>When using the (unsupported) legacy CryptoAPI based codec, skip encrypting page #1 because that can lead to database corruption and other malfunctions.</li>
</ul>
<p>
    <b>1.0.112.2 - April 27, 2020</b>
</p>
<ul>
    <li>Fix NuGet packaging for .NET Standard 2.1. Fix for [7c73262e6f].</li>
</ul>
<p>

    Access to archived release packages will be granted on a case-by-case basis.
  </li>
</ul>

<div align="center"><h2><b>Version History</b></h2></div>

<p>
    <b>1.0.113.0 - June XX, 2020 <font color="red">(release scheduled)</font></b>
</p>
<ul>
    <li>Updated to [https://www.sqlite.org/releaselog/3_32_0.html|SQLite 3.32.0].</li>
    <li>Add SQLite_ForceLogLifecycle environment variable to force logging of calls into key members pertaining to the lifecycle of connections and their associated classes (e.g. LINQ, EF6, etc).</li>

    <li>Support automatic value conversions for columns with a declared type of MEDIUMINT or MEDIUMUINT. Pursuant to [515cb60b10].</li>
    <li>Add preliminary support for the .NET Framework 4.8.</li>
</ul>
<p>
    <b>1.0.112.3 - Xxxx XX, 2020</b>
</p>
<ul>
    <li>When using the (unsupported) legacy CryptoAPI based codec, skip encrypting page #1 because that can lead to database corruption and other malfunctions.</li>
</ul>
<p>
    <b>1.0.112.2 - April 27, 2020</b>
</p>
<ul>
    <li>Fix NuGet packaging for .NET Standard 2.1. Fix for [7c73262e6f].</li>
</ul>
<p>