/ Check-in [2e7c1e0a]
Login

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

Overview
Comment:Clarify that OTA is unable to update or delete rows with NULL values in primary key fields.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | ota-update
Files: files | file ages | folders
SHA1:2e7c1e0a0d128d9bac119692b2505b5ed0abe87a
User & Date: dan 2015-03-18 19:04:40
Context
2015-03-18
20:03
Allow whereShortCut() to use the PRIMARY KEY index of a WITHOUT ROWID table to optimize a vector of "IS" operators in a WHERE clause. check-in: 52e73eec user: dan tags: ota-update
19:04
Clarify that OTA is unable to update or delete rows with NULL values in primary key fields. check-in: 2e7c1e0a user: dan tags: ota-update
2015-03-09
13:24
Merge recent trunk enhancements into the ota-update branch. check-in: 5489cb68 user: drh tags: ota-update
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to ext/ota/sqlite3ota.h.

    58     58   **
    59     59   **   * The transaction must consist of INSERT, UPDATE and DELETE operations
    60     60   **     only.
    61     61   **
    62     62   **   * INSERT statements may not use any default values.
    63     63   **
    64     64   **   * UPDATE and DELETE statements must identify their target rows by 
    65         -**     PRIMARY KEY values. If the table being written has no PRIMARY KEY,
    66         -**     affected rows must be identified by rowid.
           65  +**     non-NULL PRIMARY KEY values. Rows with NULL values stored in PRIMARY
           66  +**     KEY fields may not be updated or deleted. If the table being written 
           67  +**     has no PRIMARY KEY, affected rows must be identified by rowid.
    67     68   **
    68     69   **   * UPDATE statements may not modify PRIMARY KEY columns.
    69     70   **
    70     71   **   * No triggers will be fired.
    71     72   **
    72     73   **   * No foreign key violations are detected or reported.
    73     74   **