Documentation Source Text

Check-in [b0db418b5a]
Login

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

Overview
Comment:Update the changelog to mention IF NOT EXISTS on virtual tables.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: b0db418b5ac421719e4541bbfd32d1ebcae2acc2
User & Date: drh 2012-01-28 19:47:40
Context
2012-02-05
05:19
Fix an error in the FTS matchinfo documentation. check-in: 4a7f0dacc7 user: dan tags: trunk
2012-01-28
19:47
Update the changelog to mention IF NOT EXISTS on virtual tables. check-in: b0db418b5a user: drh tags: trunk
19:42
Update the syntax diagram for CREATE VIRTUAL TABLE to show the optional IF NOT EXISTS clause. check-in: d170aa6e3f user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

41
42
43
44
45
46
47


48
49
50
51
52
53
54
    hd_enable_main 1
  }
}

chng {2012 April 16 (3.7.11)} {
<li>Enhance the [INSERT] syntax to allow multiple rows to be inserted
    via the VALUES clause.


}

chng {2012 January 16 (3.7.10)} {
<li>The default [schema format number] is changed from 1 to 4.
    This means that, unless
    the [PRAGMA legacy_file_format | PRAGMA legacy_file_format=ON] statement is
    run, newly created database files will be unreadable by version of SQLite







>
>







41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
    hd_enable_main 1
  }
}

chng {2012 April 16 (3.7.11)} {
<li>Enhance the [INSERT] syntax to allow multiple rows to be inserted
    via the VALUES clause.
<li>Enhance the [CREATE VIRTUAL TABLE] command to support the
    IF NOT EXISTS clause.
}

chng {2012 January 16 (3.7.10)} {
<li>The default [schema format number] is changed from 1 to 4.
    This means that, unless
    the [PRAGMA legacy_file_format | PRAGMA legacy_file_format=ON] statement is
    run, newly created database files will be unreadable by version of SQLite