/ Check-in [7556bd9a]
Login

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

Overview
Comment:Update requirements marks. No changes to code.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 7556bd9aa5db1b9cd92d0e48effcda9fe96f3128
User & Date: drh 2014-08-08 18:26:20
Context
2014-08-11
13:53
Changes that will perhaps enable SQLite to work better on VxWorks. check-in: de27c742 user: drh tags: trunk
2014-08-08
18:26
Update requirements marks. No changes to code. check-in: 7556bd9a user: drh tags: trunk
17:49
Improvements to the way the query planner handles sorting costs, so that very large sorting costs do not overwhelm the loop costs. check-in: bdaa6947 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/resolve.c.

   350    350               if( iCol==pTab->iPKey ){
   351    351                 iCol = -1;
   352    352               }
   353    353               break;
   354    354             }
   355    355           }
   356    356           if( iCol>=pTab->nCol && sqlite3IsRowid(zCol) && HasRowid(pTab) ){
   357         -          /* IMP: R-24309-18625 */
          357  +          /* IMP: R-51414-32910 */
   358    358             /* IMP: R-44911-55124 */
   359    359             iCol = -1;
   360    360           }
   361    361           if( iCol<pTab->nCol ){
   362    362             cnt++;
   363    363             if( iCol<0 ){
   364    364               pExpr->affinity = SQLITE_AFF_INTEGER;

Changes to test/e_createtable.test.

  1171   1171     2.2    "CREATE TABLE t5(a, b, c, PRIMARY KEY(c,b,a))"       {a b c}
  1172   1172     2.3    "CREATE TABLE t5(a, b INTEGER PRIMARY KEY, c)"       {b}
  1173   1173   }
  1174   1174   
  1175   1175   # EVIDENCE-OF: R-59124-61339 Each row in a table with a primary key must
  1176   1176   # have a unique combination of values in its primary key columns.
  1177   1177   #
  1178         -# EVIDENCE-OF: R-39102-06737 If an INSERT or UPDATE statement attempts
  1179         -# to modify the table content so that two or more rows feature identical
  1180         -# primary key values, it is a constraint violation.
         1178  +# EVIDENCE-OF: R-06471-16287 If an INSERT or UPDATE statement attempts
         1179  +# to modify the table content so that two or more rows have identical
         1180  +# primary key values, that is a constraint violation.
  1181   1181   #
  1182   1182   drop_all_tables
  1183   1183   do_execsql_test 4.3.0 {
  1184   1184     CREATE TABLE t1(x PRIMARY KEY, y);
  1185   1185     INSERT INTO t1 VALUES(0,          'zero');
  1186   1186     INSERT INTO t1 VALUES(45.5,       'one');
  1187   1187     INSERT INTO t1 VALUES('brambles', 'two');

Changes to test/e_expr.test.

   446    446   do_execsql_test e_expr-10.3.3 { SELECT 'isn''t' }         {isn't}
   447    447   do_execsql_test e_expr-10.3.4 { SELECT typeof('isn''t') } {text}
   448    448   
   449    449   # EVIDENCE-OF: R-09593-03321 BLOB literals are string literals
   450    450   # containing hexadecimal data and preceded by a single "x" or "X"
   451    451   # character.
   452    452   #
   453         -# EVIDENCE-OF: R-39344-59787 For example: X'53514C697465'
          453  +# EVIDENCE-OF: R-19836-11244 Example: X'53514C697465'
   454    454   #
   455    455   do_execsql_test e_expr-10.4.1 { SELECT typeof(X'0123456789ABCDEF') } blob
   456    456   do_execsql_test e_expr-10.4.2 { SELECT typeof(x'0123456789ABCDEF') } blob
   457    457   do_execsql_test e_expr-10.4.3 { SELECT typeof(X'0123456789abcdef') } blob
   458    458   do_execsql_test e_expr-10.4.4 { SELECT typeof(x'0123456789abcdef') } blob
   459    459   do_execsql_test e_expr-10.4.5 { SELECT typeof(X'53514C697465')     } blob
   460    460