Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | First attempt at documenting WITHOUT ROWID. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
3819df0c0d69867a7fd8fb6f2442dcad |
| User & Date: | drh 2013-11-08 20:06:21 |
Context
|
2013-11-09
| ||
| 17:14 | Add the WITHOUT ROWID document. Enhance the file-format, CREATE TABLE, and AUTOINCREMENT documents to reflect changes due to WITHOUT ROWID. check-in: ffe4c464ea user: drh tags: trunk | |
|
2013-11-08
| ||
| 20:06 | First attempt at documenting WITHOUT ROWID. check-in: 3819df0c0d user: drh tags: trunk | |
|
2013-10-27
| ||
| 03:44 | Fix a typo in the documentation for the ABS() function. check-in: 9e1d78e903 user: drh tags: trunk | |
Changes
Changes to art/syntax/bubble-generator-data.tcl.
87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 |
}
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}}
{line {optx /database-name .} /table-name
{tailbranch
{line ( {loop column-def ,} {loop {} {, table-constraint}} )}
{line AS select-stmt}
}
}
}
column-def {
line /column-name {or type-name nil} {loop nil {nil column-constraint nil}}
}
type-name {
line {loop /name {}} {or {}
|
| < | > | < |
87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 |
}
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}}
{line {optx /database-name .} /table-name}
{or {line ( {loop column-def ,} {loop {} {, table-constraint}} )
{opt WITHOUT ROWID}}
{line AS select-stmt}
}
}
column-def {
line /column-name {or type-name nil} {loop nil {nil column-constraint nil}}
}
type-name {
line {loop /name {}} {or {}
|
Changes to art/syntax/bubble-generator.tcl.
30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 |
}
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 ")"
#
proc draw_right_turnback {tag x y0 y1} {
global RADIUS
if {$y0 + 2*$RADIUS < $y1} {
|
| | | |
30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 |
}
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 16 bold} ;# default token font
set font2 {GillSans 14 bold} ;# 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 ")"
#
proc draw_right_turnback {tag x y0 y1} {
global RADIUS
if {$y0 + 2*$RADIUS < $y1} {
|
Changes to art/syntax/create-table-stmt.gif.
cannot compute difference between binary files
Changes to pages/changes.in.
13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
<tcl>
set nChng 0
proc chng {date desc {options {}}} {
global nChng aChng
set aChng($nChng) [list $date $desc $options]
incr nChng
}
chng {2013-10-17 (3.8.1)} {
<li>Added the [unlikely()] and [likelihood()] SQL functions to be used
as hints to the query planner.
<li>Enhancements to the query planner:
<ul>
<li>Take into account the fact WHERE clause terms that cannot be used with indices
|
> > > > |
13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
<tcl>
set nChng 0
proc chng {date desc {options {}}} {
global nChng aChng
set aChng($nChng) [list $date $desc $options]
incr nChng
}
chng {2013-12-?? (3.8.2)} {
<li>Added support for [WITHOUT ROWID] tables.
}
chng {2013-10-17 (3.8.1)} {
<li>Added the [unlikely()] and [likelihood()] SQL functions to be used
as hints to the query planner.
<li>Enhancements to the query planner:
<ul>
<li>Take into account the fact WHERE clause terms that cannot be used with indices
|
Changes to pages/index.in.
91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 |
</td> <td width="20"></td><td bgcolor="#044a64" width="1"></td><td width="20"></td> <td valign="top"> <h3>Current Status</h3> <p><ul> <li><a href="releaselog/3_8_1.html">Version 3.8.1</a> of SQLite is recommended for all new development. Upgrading from version 3.7.17 and 3.8.0.2 is optional. Upgrading from all other prior versions of SQLite is recommended.</li> </ul></p> <h3>Common Links</h3> <p><ul> |
| | |
91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 |
</td> <td width="20"></td><td bgcolor="#044a64" width="1"></td><td width="20"></td> <td valign="top"> <h3>Current Status</h3> <p><ul> <li><a href="releaselog/3_8_2.html">Version 3.8.2</a> of SQLite is recommended for all new development. Upgrading from versions 3.7.17, 3.8.0.2, and 3.8.1 is optional. Upgrading from all other prior versions of SQLite is recommended.</li> </ul></p> <h3>Common Links</h3> <p><ul> |
Changes to pages/opcode.in.
12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
unset -nocomplain OpcodeList
foreach line [split $file \n] {
set line [string trim $line]
if {[string index $line 1]!="*"} {
set current_op {}
continue
}
if {[regexp {^/\* Opcode: } $line]} {
set current_op [lindex $line 2]
set txt [lrange $line 3 end]
regsub -all {>} $txt {\>} txt
regsub -all {<} $txt {\<} txt
set Opcode($current_op:args) $txt
lappend OpcodeList $current_op
|
> |
12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
unset -nocomplain OpcodeList
foreach line [split $file \n] {
set line [string trim $line]
if {[string index $line 1]!="*"} {
set current_op {}
continue
}
if {[regexp {^\*\* Synopsis:} $line]} continue
if {[regexp {^/\* Opcode: } $line]} {
set current_op [lindex $line 2]
set txt [lrange $line 3 end]
regsub -all {>} $txt {\>} txt
regsub -all {<} $txt {\<} txt
set Opcode($current_op:args) $txt
lappend OpcodeList $current_op
|