Documentation Source Text
Check-in [f990657458]
Not logged in

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

Overview
SHA1 Hash:f990657458d8dc37bfcd002d17a3a3a5ece316f8
Date: 2013-08-02 18:27:52
User: drh
Comment:Enable partial indices.
Tags And Properties
Context
2013-08-02
23:41
[498cd0709e] Updates to requirements marks. (user: drh, tags: trunk)
18:27
[f990657458] Enable partial indices. (user: drh, tags: trunk)
18:27
[3e022afe53] Closed-Leaf: Corrections to partial index documentation. (user: drh, tags: partial-indices)
2013-08-01
17:48
[52366f9588] Fix the description of COLLATE operator precedence so that it is aligned with the implementation. (user: drh, tags: trunk)
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to art/syntax/alter-table-stmt.gif

cannot compute difference between binary files

Changes to art/syntax/analyze-stmt.gif

cannot compute difference between binary files

Changes to art/syntax/attach-stmt.gif

cannot compute difference between binary files

Changes to art/syntax/begin-stmt.gif

cannot compute difference between binary files

Changes to art/syntax/bubble-generator-data.tcl

79
80
81
82
83
84
85

86
87
88
89
90
91
92
     line RELEASE {optx SAVEPOINT} /savepoint-name
  }
  create-index-stmt {
    stack
       {line CREATE {opt UNIQUE} INDEX {opt IF NOT EXISTS}}
       {line {optx /database-name .} /index-name
             ON /table-name ( {loop indexed-column ,} )}

  }
  indexed-column {
      line /column-name {optx COLLATE /collation-name} {or ASC DESC nil} 
  }
  create-table-stmt {
    stack
       {line CREATE {or {} TEMP TEMPORARY} TABLE {opt IF NOT EXISTS}}







>







79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
     line RELEASE {optx SAVEPOINT} /savepoint-name
  }
  create-index-stmt {
    stack
       {line CREATE {opt UNIQUE} INDEX {opt IF NOT EXISTS}}
       {line {optx /database-name .} /index-name
             ON /table-name ( {loop indexed-column ,} )}
       {line {optx WHERE /expr}}
  }
  indexed-column {
      line /column-name {optx COLLATE /collation-name} {or ASC DESC nil} 
  }
  create-table-stmt {
    stack
       {line CREATE {or {} TEMP TEMPORARY} TABLE {opt IF NOT EXISTS}}

Changes to art/syntax/bubble-generator.tcl

30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
...
629
630
631
632
633
634
635



636
637
638
639

640
641
642
643
644
645
646
}
incr bn
set b $side.b$bn
button $b -text Everything -command {draw_all_graphs}
pack $b -side top -fill x -expand 1

set tagcnt 0                      ;# tag counter
set font1 {Helvetica 14 bold}     ;# default token font
set font2 {Helvetica 12}          ;# default variable font
set RADIUS 9                      ;# default turn radius
set HSEP 17                       ;# horizontal separation
set VSEP 9                        ;# vertical separation
set DPI 80                        ;# dots per inch


# Draw a right-hand turn around.  Approximately a ")"
................................................................................
  .c delete all
  wm deiconify .
  wm title . $name
  draw_diagram "line bullet [list $spec] bullet"
  foreach {x0 y0 x1 y1} [.c bbox all] break
  .c move all [expr {2-$x0}] [expr {2-$y0}]
  foreach {x0 y0 x1 y1} [.c bbox all] break



  .c config -width $x1 -height $y1
  update
  .c postscript -file $name.ps -width [expr {$x1+2}] -height [expr {$y1+2}]
  global DPI

  exec convert -density ${DPI}x$DPI -antialias $name.ps $name.gif
  if {$do_xv} {
    if {[catch {exec xv $name.gif &}]} {
      exec display $name.gif &
    }
  }
}







|
|







 







>
>
>




>







30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
...
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
}
incr bn
set b $side.b$bn
button $b -text Everything -command {draw_all_graphs}
pack $b -side top -fill x -expand 1

set tagcnt 0                      ;# tag counter
set font1 {Helvetica 12 bold}     ;# default token font
set font2 {Helvetica 10}           ;# default variable font
set RADIUS 9                      ;# default turn radius
set HSEP 17                       ;# horizontal separation
set VSEP 9                        ;# vertical separation
set DPI 80                        ;# dots per inch


# Draw a right-hand turn around.  Approximately a ")"
................................................................................
  .c delete all
  wm deiconify .
  wm title . $name
  draw_diagram "line bullet [list $spec] bullet"
  foreach {x0 y0 x1 y1} [.c bbox all] break
  .c move all [expr {2-$x0}] [expr {2-$y0}]
  foreach {x0 y0 x1 y1} [.c bbox all] break
  .c create rect -100 -100 [expr {$x1+100}] [expr {$y1+100}] \
     -fill white -outline white -tags bgrect
  .c lower bgrect
  .c config -width $x1 -height $y1
  update
  .c postscript -file $name.ps -width [expr {$x1+2}] -height [expr {$y1+2}]
  global DPI
  .c delete bgrect
  exec convert -density ${DPI}x$DPI -antialias $name.ps $name.gif
  if {$do_xv} {
    if {[catch {exec xv $name.gif &}]} {
      exec display $name.gif &
    }
  }
}

Changes to art/syntax/column-constraint.gif

cannot compute difference between binary files

Changes to art/syntax/column-def.gif

cannot compute difference between binary files

Changes to art/syntax/comment-syntax.gif

cannot compute difference between binary files

Changes to art/syntax/commit-stmt.gif

cannot compute difference between binary files

Changes to art/syntax/compound-operator.gif

cannot compute difference between binary files

Changes to art/syntax/conflict-clause.gif

cannot compute difference between binary files

Changes to art/syntax/create-index-stmt.gif

cannot compute difference between binary files

Changes to art/syntax/create-table-stmt.gif

cannot compute difference between binary files

Changes to art/syntax/create-trigger-stmt.gif

cannot compute difference between binary files

Changes to art/syntax/create-view-stmt.gif

cannot compute difference between binary files

Changes to art/syntax/create-virtual-table-stmt.gif

cannot compute difference between binary files

Changes to art/syntax/delete-stmt-limited.gif

cannot compute difference between binary files

Changes to art/syntax/delete-stmt.gif

cannot compute difference between binary files

Changes to art/syntax/detach-stmt.gif

cannot compute difference between binary files

Changes to art/syntax/drop-index-stmt.gif

cannot compute difference between binary files

Changes to art/syntax/drop-table-stmt.gif

cannot compute difference between binary files

Changes to art/syntax/drop-trigger-stmt.gif

cannot compute difference between binary files

Changes to art/syntax/drop-view-stmt.gif

cannot compute difference between binary files

Changes to art/syntax/expr.gif

cannot compute difference between binary files

Changes to art/syntax/foreign-key-clause.gif

cannot compute difference between binary files

Changes to art/syntax/indexed-column.gif

cannot compute difference between binary files

Changes to art/syntax/insert-stmt.gif

cannot compute difference between binary files

Changes to art/syntax/join-constraint.gif

cannot compute difference between binary files

Changes to art/syntax/join-op.gif

cannot compute difference between binary files

Changes to art/syntax/join-source.gif

cannot compute difference between binary files

Changes to art/syntax/literal-value.gif

cannot compute difference between binary files

Changes to art/syntax/numeric-literal.gif

cannot compute difference between binary files

Changes to art/syntax/ordering-term.gif

cannot compute difference between binary files

Changes to art/syntax/pragma-stmt.gif

cannot compute difference between binary files

Changes to art/syntax/pragma-value.gif

cannot compute difference between binary files

Changes to art/syntax/qualified-table-name.gif

cannot compute difference between binary files

Changes to art/syntax/raise-function.gif

cannot compute difference between binary files

Changes to art/syntax/reindex-stmt.gif

cannot compute difference between binary files

Changes to art/syntax/release-stmt.gif

cannot compute difference between binary files

Changes to art/syntax/result-column.gif

cannot compute difference between binary files

Changes to art/syntax/rollback-stmt.gif

cannot compute difference between binary files

Changes to art/syntax/savepoint-stmt.gif

cannot compute difference between binary files

Changes to art/syntax/select-core.gif

cannot compute difference between binary files

Changes to art/syntax/select-stmt.gif

cannot compute difference between binary files

Changes to art/syntax/signed-number.gif

cannot compute difference between binary files

Changes to art/syntax/single-source.gif

cannot compute difference between binary files

Changes to art/syntax/sql-stmt-list.gif

cannot compute difference between binary files

Changes to art/syntax/sql-stmt.gif

cannot compute difference between binary files

Changes to art/syntax/table-constraint.gif

cannot compute difference between binary files

Changes to art/syntax/type-name.gif

cannot compute difference between binary files

Changes to art/syntax/update-stmt-limited.gif

cannot compute difference between binary files

Changes to art/syntax/update-stmt.gif

cannot compute difference between binary files

Changes to art/syntax/vacuum-stmt.gif

cannot compute difference between binary files

Changes to matrix.tcl

600
601
602
603
604
605
606


607
608
609
610
611
612
613
614
    set req [string map {&lt; < &gt; > &#91; [ &#93; ] &amp; &} $req]
    set req [string trim $req]
    set rno R-[md5-10x8 $req]
    set shortrno [string range $rno 0 12]
    append out "<a name=\"$rno\"></a><font color=\"blue\"><b>\n"
    set link "<a href=\"$matrixpath#$rno\" style=\"color: #0000ff\">"
    append out "$link$shortrno</a>:\[</b></font>"


    if {$proof($rno)>=2} {
      set clr green
    } elseif {$proof($rno)==1} {
      set clr orange
    } else {
      set clr red
    }
    append out "<font color=\"$clr\">$orig</font>\n"







>
>
|







600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
    set req [string map {&lt; < &gt; > &#91; [ &#93; ] &amp; &} $req]
    set req [string trim $req]
    set rno R-[md5-10x8 $req]
    set shortrno [string range $rno 0 12]
    append out "<a name=\"$rno\"></a><font color=\"blue\"><b>\n"
    set link "<a href=\"$matrixpath#$rno\" style=\"color: #0000ff\">"
    append out "$link$shortrno</a>:\[</b></font>"
    if {![info exists proof($rno)]} {
      set clr red
    } elseif {$proof($rno)>=2} {
      set clr green
    } elseif {$proof($rno)==1} {
      set clr orange
    } else {
      set clr red
    }
    append out "<font color=\"$clr\">$orig</font>\n"

Changes to pages/changes.in

38
39
40
41
42
43
44
45

46
47
48
49
50
51
52
      http://www.sqlite.org/src/timeline</a>.</p>
    }
    hd_close_aux
    hd_enable_main 1
  }
}

chng {2013-08-15 (3.8.0)} {

<li>Cut-over to the [next generation query planner] for faster and better query plans.
<li>The [EXPLAIN QUERY PLAN] output no longer shows an estimate of the number of 
    rows generated by each loop in a join.
<li>Added the [FTS4 notindexed option], allowing non-indexed columns in an FTS4 table.
<li>Added the [SQLITE_STMTSTATUS_VM_STEP] option to [sqlite3_stmt_status()].
<li>Added the "percentile()" function as a [loadable extension] in the ext/misc
    subdirectory of the source tree.







|
>







38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
      http://www.sqlite.org/src/timeline</a>.</p>
    }
    hd_close_aux
    hd_enable_main 1
  }
}

chng {2013-08-29 (3.8.0)} {
<li>Add support for [partial indexes]</li>
<li>Cut-over to the [next generation query planner] for faster and better query plans.
<li>The [EXPLAIN QUERY PLAN] output no longer shows an estimate of the number of 
    rows generated by each loop in a join.
<li>Added the [FTS4 notindexed option], allowing non-indexed columns in an FTS4 table.
<li>Added the [SQLITE_STMTSTATUS_VM_STEP] option to [sqlite3_stmt_status()].
<li>Added the "percentile()" function as a [loadable extension] in the ext/misc
    subdirectory of the source tree.