Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix typos. (CVS 320) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | 3be8a189e8ccf8a82acc4ee72cc75b6cc92aa193 |
| User & Date: | drh 2001-11-24 13:50:53 |
Context
|
2001-11-25
| ||
| 13:18 | Add the ability to do a single .command as the second argument to the command-line shell. (CVS 321) check-in: 653f37c3 user: drh tags: trunk | |
|
2001-11-24
| ||
| 13:50 | Fix typos. (CVS 320) check-in: 3be8a189 user: drh tags: trunk | |
| 13:36 | Typos fixed. (CVS 319) check-in: e86a68c5 user: drh tags: trunk | |
Changes
Changes to www/lang.tcl.
1
2
3
4
5
6
7
8
9
10
11
...
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
|
#
# Run this Tcl script to generate the sqlite.html file.
#
set rcsid {$Id: lang.tcl,v 1.16 2001/11/24 13:23:05 drh Exp $}
puts {<html>
<head>
<title>Query Language Understood By SQLite</title>
</head>
<body bgcolor=white>
<h1 align=center>
................................................................................
process that opened the database and is automatically deleted when
the database is closed. Any indices created on a temporary table
are also temporary. Temporary tables and indices are stored in a
separate file distinct from the main database file.</p>
<p>There are no arbitrary limits on the number
of columns or on the number of constraints in a table.
The total amount of data in a single row is limited to 65535 bytes.</p>
<p>The exact text
of each CREATE TABLE statement is stored in the <b>sqlite_master</b>
table. Everytime the database is opened, all CREATE TABLE statements
are read from the <b>sqlite_master</b> table and used to regenerate
SQLite's internal representation of the table layout.</p>
}
|
|
|
>
>
|
1
2
3
4
5
6
7
8
9
10
11
...
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
|
#
# Run this Tcl script to generate the sqlite.html file.
#
set rcsid {$Id: lang.tcl,v 1.17 2001/11/24 13:50:53 drh Exp $}
puts {<html>
<head>
<title>Query Language Understood By SQLite</title>
</head>
<body bgcolor=white>
<h1 align=center>
................................................................................
process that opened the database and is automatically deleted when
the database is closed. Any indices created on a temporary table
are also temporary. Temporary tables and indices are stored in a
separate file distinct from the main database file.</p>
<p>There are no arbitrary limits on the number
of columns or on the number of constraints in a table.
The total amount of data in a single row is limited to about
1 megabytes. (This limit can be increased to 16MB by changing
a single #define in the source code and recompiling.)</p>
<p>The exact text
of each CREATE TABLE statement is stored in the <b>sqlite_master</b>
table. Everytime the database is opened, all CREATE TABLE statements
are read from the <b>sqlite_master</b> table and used to regenerate
SQLite's internal representation of the table layout.</p>
}
|
Changes to www/opcode.tcl.
1
2
3
4
5
6
7
8
9
10
11
...
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
|
#
# Run this Tcl script to generate the sqlite.html file.
#
set rcsid {$Id: opcode.tcl,v 1.8 2001/11/24 13:23:05 drh Exp $}
puts {<html>
<head>
<title>SQLite Virtual Machine Opcodes</title>
</head>
<body bgcolor=white>
<h1 align=center>
................................................................................
that is part of a larger expression.</p>
<p>The virtual machine contains a single sorter.
The sorter is able to accumulate records, sort those records,
then play the records back in sorted order. The sorter is used
to implement the ORDER BY clause of a SELECT statement.</p>
<p>The virtual machine contains a single "Lists".
The list stores a list of integers. Lists are used to hold the
rowids for records of a database table that needs to be modified.
The WHERE clause of an UPDATE or DELETE statement scans through
the table and writes the rowid of every record to be modified
into the list. Then the list is played back and the table is modified
in a separate step.</p>
<p>The virtual machine can contain an arbitrary number of "Sets".
|
|
|
|
|
1
2
3
4
5
6
7
8
9
10
11
...
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
|
#
# Run this Tcl script to generate the sqlite.html file.
#
set rcsid {$Id: opcode.tcl,v 1.9 2001/11/24 13:50:53 drh Exp $}
puts {<html>
<head>
<title>SQLite Virtual Machine Opcodes</title>
</head>
<body bgcolor=white>
<h1 align=center>
................................................................................
that is part of a larger expression.</p>
<p>The virtual machine contains a single sorter.
The sorter is able to accumulate records, sort those records,
then play the records back in sorted order. The sorter is used
to implement the ORDER BY clause of a SELECT statement.</p>
<p>The virtual machine contains a single "List".
The list stores a list of integers. The list is used to hold the
rowids for records of a database table that needs to be modified.
The WHERE clause of an UPDATE or DELETE statement scans through
the table and writes the rowid of every record to be modified
into the list. Then the list is played back and the table is modified
in a separate step.</p>
<p>The virtual machine can contain an arbitrary number of "Sets".
|