System.Data.SQLite
Check-in [837870c7bb]
Not logged in

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

Overview
Comment:Rename MapTextToAffinity connection flag to DetectTextAffinity. Update version history docs.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | tkt-3c00ec5b52
Files: files | file ages | folders
SHA1: 837870c7bbe470d3a3c90d95d2c2a9351025c56a
User & Date: mistachkin 2014-05-26 20:56:29
Context
2014-05-26
22:51
Merge updates from trunk. check-in: ce61807139 user: mistachkin tags: tkt-3c00ec5b52
20:56
Rename MapTextToAffinity connection flag to DetectTextAffinity. Update version history docs. check-in: 837870c7bb user: mistachkin tags: tkt-3c00ec5b52
20:36
Merge updates from trunk. check-in: 99904a25b4 user: mistachkin tags: tkt-3c00ec5b52
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to Doc/Extra/Provider/version.html.

    44     44       <div id="mainBody">
    45     45       <h1 class="heading">Version History</h1>
    46     46       <p><b>1.0.93.0 - June XX, 2014 <font color="red">(release scheduled)</font></b></p>
    47     47       <ul>
    48     48         <li>Updated to <a href="http://www.sqlite.org/releaselog/3_8_4_3.html">SQLite 3.8.4.3</a>.</li>
    49     49         <li>Add support for mapping transaction isolation levels to their legacy default values. Pursuant to <a href="http://system.data.sqlite.org/index.html/info/56b42d99c1">[56b42d99c1]</a>.</li>
    50     50         <li>Add support for setting the default DbType and type name used for mappings on a per-connection basis. Pursuant to <a href="http://system.data.sqlite.org/index.html/info/3c00ec5b52">[3c00ec5b52]</a>.</li>
           51  +      <li>Add DetectTextAffinity connection flag to enable automatic detection of column affinities, when necessary. Pursuant to <a href="http://system.data.sqlite.org/index.html/info/3c00ec5b52">[3c00ec5b52]</a>.</li>
    51     52         <li>Add SetChunkSize method to the SQLiteConnection class. Pursuant to [d1c008fa0a].</li>
    52     53         <li>Make the ISQLiteSchemaExtensions interface public.&nbsp;<b>** Potentially Incompatible Change **</b></li>
    53     54         <li>Have the SQLiteProviderFactory class (in the System.Data.SQLite.Linq assembly) implement the IServiceProvider interface.</li>
    54     55         <li>Fix bug in documentation generator automation that prevented some internal documentation links from working.</li>
    55     56       </ul>
    56     57       <p><b>1.0.92.0 - March 19, 2014</p>
    57     58       <ul>

Changes to System.Data.SQLite/SQLiteBase.cs.

  1062   1062         /// <summary>
  1063   1063         /// Enable mapping of unsupported transaction isolation levels to the
  1064   1064         /// closest supported transaction isolation level.
  1065   1065         /// </summary>
  1066   1066         MapIsolationLevels = 0x1000000,
  1067   1067   
  1068   1068         /// <summary>
  1069         -      /// When returning column values, attempt to map textual values
  1070         -      /// onto fully conforming values of
         1069  +      /// When returning column values, attempt to detect the affinity of
         1070  +      /// textual values to see if they fully conform to those of the
  1071   1071         /// <see cref="TypeAffinity.Null" />,
  1072   1072         /// <see cref="TypeAffinity.Int64" />,
  1073   1073         /// <see cref="TypeAffinity.Double" />,
  1074         -      /// or <see cref="TypeAffinity.DateTime" />.
         1074  +      /// or <see cref="TypeAffinity.DateTime" /> types.
  1075   1075         /// </summary>
  1076         -      MapTextToAffinity = 0x2000000,
         1076  +      DetectTextAffinity = 0x2000000,
  1077   1077   
  1078   1078         /// <summary>
  1079   1079         /// When binding parameter values or returning column values, always
  1080   1080         /// treat them as though they were plain text (i.e. no numeric,
  1081   1081         /// date/time, or other conversions should be attempted).
  1082   1082         /// </summary>
  1083   1083         BindAndGetAllAsText = BindAllAsText | GetAllAsText,

Changes to System.Data.SQLite/SQLiteDataReader.cs.

  1132   1132   
  1133   1133         if (i >= VisibleFieldCount && _keyInfo != null)
  1134   1134           return _keyInfo.GetValue(i - VisibleFieldCount);
  1135   1135   
  1136   1136         SQLiteConnectionFlags flags = SQLiteCommand.GetFlags(_command);
  1137   1137         SQLiteType typ = GetSQLiteType(flags, i);
  1138   1138   
  1139         -      if (((flags & SQLiteConnectionFlags.MapTextToAffinity) == SQLiteConnectionFlags.MapTextToAffinity) &&
  1140         -          (typ != null) && (typ.Affinity == TypeAffinity.Text))
         1139  +      if (((flags & SQLiteConnectionFlags.DetectTextAffinity) == SQLiteConnectionFlags.DetectTextAffinity) &&
         1140  +          ((typ == null) || (typ.Affinity == TypeAffinity.Text)))
  1141   1141         {
  1142   1142             typ = GetSQLiteType(
  1143   1143                 typ, _activeStatement._sql.GetText(_activeStatement, i));
  1144   1144         }
  1145   1145   
  1146   1146         return _activeStatement._sql.GetValue(_activeStatement, flags, i, typ);
  1147   1147       }
................................................................................
  1428   1428       /// <param name="text">
  1429   1429       /// The textual value of the column for a given row.
  1430   1430       /// </param>
  1431   1431       /// <returns>
  1432   1432       /// The SQLiteType structure.
  1433   1433       /// </returns>
  1434   1434       private SQLiteType GetSQLiteType(
  1435         -        SQLiteType oldType,
         1435  +        SQLiteType oldType, /* PASS-THROUGH */
  1436   1436           string text
  1437   1437           )
  1438   1438       {
  1439   1439           if (SQLiteConvert.LooksLikeNull(text))
  1440   1440               return new SQLiteType(TypeAffinity.Null, DbType.Object);
  1441   1441   
  1442   1442           if (SQLiteConvert.LooksLikeInt64(text))

Changes to readme.htm.

   211    211   <p>
   212    212       <b>1.0.93.0 - June XX, 2014 <font color="red">(release scheduled)</font></b>
   213    213   </p>
   214    214   <ul>
   215    215       <li>Updated to <a href="http://www.sqlite.org/releaselog/3_8_4_3.html">SQLite 3.8.4.3</a>.</li>
   216    216       <li>Add support for mapping transaction isolation levels to their legacy default values. Pursuant to [56b42d99c1].</li>
   217    217       <li>Add support for setting the default DbType and type name used for mappings on a per-connection basis. Pursuant to [3c00ec5b52].</li>
          218  +    <li>Add DetectTextAffinity connection flag to enable automatic detection of column affinities, when necessary. Pursuant to [3c00ec5b52].</li>
   218    219       <li>Add SetChunkSize method to the SQLiteConnection class. Pursuant to [d1c008fa0a].</li>
   219    220       <li>Make the ISQLiteSchemaExtensions interface public.&nbsp;<b>** Potentially Incompatible Change **</b></li>
   220    221       <li>Have the SQLiteProviderFactory class (in the System.Data.SQLite.Linq assembly) implement the IServiceProvider interface.</li>
   221    222       <li>Fix bug in documentation generator automation that prevented some internal documentation links from working.</li>
   222    223   </ul>
   223    224   <p>
   224    225       <b>1.0.92.0 - March 19, 2014</b>

Changes to www/news.wiki.

     5      5   <p>
     6      6       <b>1.0.93.0 - June XX, 2014 <font color="red">(release scheduled)</font></b>
     7      7   </p>
     8      8   <ul>
     9      9       <li>Updated to <a href="http://www.sqlite.org/releaselog/3_8_4_3.html">SQLite 3.8.4.3</a>.</li>
    10     10       <li>Add support for mapping transaction isolation levels to their legacy default values. Pursuant to [56b42d99c1].</li>
    11     11       <li>Add support for setting the default DbType and type name used for mappings on a per-connection basis. Pursuant to [3c00ec5b52].</li>
           12  +    <li>Add DetectTextAffinity connection flag to enable automatic detection of column affinities, when necessary. Pursuant to [3c00ec5b52].</li>
    12     13       <li>Add SetChunkSize method to the SQLiteConnection class. Pursuant to [d1c008fa0a].</li>
    13     14       <li>Make the ISQLiteSchemaExtensions interface public.&nbsp;<b>** Potentially Incompatible Change **</b></li>
    14     15       <li>Have the SQLiteProviderFactory class (in the System.Data.SQLite.Linq assembly) implement the IServiceProvider interface.</li>
    15     16       <li>Fix bug in documentation generator automation that prevented some internal documentation links from working.</li>
    16     17   </ul>
    17     18   <p>
    18     19       <b>1.0.92.0 - March 19, 2014</b>