Documentation Source Text

Check-in [887762cf99]
Login

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

Overview
Comment:Mention that UPSERT does not work for virtual tables.
Timelines: family | ancestors | descendants | both | branch-3.24
Files: files | file ages | folders
SHA3-256: 887762cf9916c2e9ec9165f3313a071bb8957ad2be7f900d65f77c8480e4ae6c
User & Date: drh 2018-06-26 18:24:24
Context
2018-07-23
10:53
Changes to information on support packages. check-in: 5caed7a191 user: drh tags: branch-3.24
2018-06-26
18:24
Mention that UPSERT does not work for virtual tables. check-in: 887762cf99 user: drh tags: branch-3.24
2018-06-15
19:12
Fix missing "const" in the documentation of the argv parameters to the xCreate and xConnect methods in the sqlite3_module object. check-in: 2ee890a53a user: drh tags: branch-3.24
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/lang.in.

  3442   3442   
  3443   3443   <p>In this last example, the phonebook2 entry is only
  3444   3444   updated if the validDate for the newly inserted value is
  3445   3445   newer than the entry already in the table.  If the table already
  3446   3446   contains an entry with the same name and a current validDate,
  3447   3447   then the WHERE clause causes the DO UPDATE to become a no-op.
  3448   3448   
         3449  +<h3>Limitations</h3>
         3450  +
         3451  +<p>UPSERT does not currently work for [virtual tables].
         3452  +
  3449   3453   
  3450   3454   <tcl>
  3451   3455   ##############################################################################
  3452   3456   Section {ON CONFLICT clause} conflict {{conflict clause} {ON CONFLICT}}
  3453   3457   
  3454   3458   RecursiveBubbleDiagram conflict-clause
  3455   3459   </tcl>