From 305f99a0fbcf9d0369d460b61d589ca9ea18103f Mon Sep 17 00:00:00 2001 From: drh Date: Sun, 25 Aug 2002 20:11:18 +0000 Subject: [PATCH] Documentation updates prior to the releae of 2.7.0. (CVS 728) FossilOrigin-Name: e2d95f85a3c4beeb5f8e78498f52fc00475f38ed --- manifest | 14 +++++++------- manifest.uuid | 2 +- www/changes.tcl | 4 +++- www/lang.tcl | 36 +++++++++++++++++++++++++++++++----- 4 files changed, 42 insertions(+), 14 deletions(-) diff --git a/manifest b/manifest index 518de99808..1a20b58506 100644 --- a/manifest +++ b/manifest @@ -1,5 +1,5 @@ -C Fix\sfor\sticket\s#136:\s\sAdded\sthe\sOP_RenameCursor\sVDBE\sinstruction\sand\sused\sit\nto\smake\scursor\snumbers\sright\son\snested\ssubqueries.\s\sAlso\sadded\sOP_Gosub\sand\nOP_Return\sbut\shave\snot\sactually\sused\sthem\sfor\sanything\syet.\s(CVS\s727) -D 2002-08-25T19:20:40 +C Documentation\supdates\sprior\sto\sthe\sreleae\sof\s2.7.0.\s(CVS\s728) +D 2002-08-25T20:11:19 F Makefile.in bcb81f40d9a17bd94f59e67157b1e1c54c046c2b F Makefile.linux-gcc b86a99c493a5bfb402d1d9178dcdc4bd4b32f906 F README f1de682fbbd94899d50aca13d387d1b3fd3be2dd @@ -128,7 +128,7 @@ F www/arch.png 82ef36db1143828a7abc88b1e308a5f55d4336f4 F www/arch.tcl 679a0c48817f71bc91d5911ef386e5ef35d4f178 F www/audit.tcl 90e09d580f79c7efec0c7d6f447b7ec5c2dce5c0 F www/c_interface.tcl e76c9fd609326c34cd45cd040b508b0e21908800 -F www/changes.tcl 7326bd48555132ca7f21a0dec84dacea76eacc65 +F www/changes.tcl bb15b92cf350b00cd9e6b70ee5d0b2638e563f80 F www/conflict.tcl 81dd21f9a679e60aae049e9dd8ab53d59570cda2 F www/crosscompile.tcl 3622ebbe518927a3854a12de51344673eb2dd060 F www/datatypes.tcl 0cb28565580554fa7e03e8fcb303e87ce57757ae @@ -138,7 +138,7 @@ F www/faq.tcl 207d3e31597c63ed3bbecd58aaeaa38c53d39dd4 F www/fileformat.tcl a4b5c2c6e89b7d42d09f97fd4d7bbd39cbf24936 F www/formatchng.tcl b4449e065d2da38b6563bdf12cf46cfe1d4d765e F www/index.tcl 33881038e9664a36e56df3b80ef0828594c8dcd9 -F www/lang.tcl d2be2be0328f5c2fea06add825a1e442a1f8ed55 +F www/lang.tcl bf9d830aa0042718ae157e25fc7539f5378c46ff F www/mingw.tcl f1c7c0a7f53387dd9bb4f8c7e8571b7561510ebc F www/omitted.tcl 118062f40a203fcb88b8d68ef1d7c0073ac191ec F www/opcode.tcl 33c5f2061a05c5d227c72b84c080b3bf74c74f8b @@ -147,7 +147,7 @@ F www/speed.tcl a20a792738475b68756ea7a19321600f23d1d803 F www/sqlite.tcl ae3dcfb077e53833b59d4fcc94d8a12c50a44098 F www/tclsqlite.tcl 1db15abeb446aad0caf0b95b8b9579720e4ea331 F www/vdbe.tcl 2013852c27a02a091d39a766bc87cff329f21218 -P b957dafc26383af514795df18bc7b8f367c9bd21 -R 1508fec7d872ab78a02b8e4a6441e47b +P c602603e7cd8dc5c8bb9db2748eacab650de5bf0 +R 1887224d7be529eb62028d618058de77 U drh -Z b7a5fabc6af8b4c88e87d19c813a614d +Z f85ad7a4a68c1afc1c9866ad59b71b62 diff --git a/manifest.uuid b/manifest.uuid index 35d6f79268..13720e1e95 100644 --- a/manifest.uuid +++ b/manifest.uuid @@ -1 +1 @@ -c602603e7cd8dc5c8bb9db2748eacab650de5bf0 \ No newline at end of file +e2d95f85a3c4beeb5f8e78498f52fc00475f38ed \ No newline at end of file diff --git a/www/changes.tcl b/www/changes.tcl index f392bac71c..7beebe5d9a 100644 --- a/www/changes.tcl +++ b/www/changes.tcl @@ -25,12 +25,14 @@ proc chng {date desc} { puts "

" } -chng {2002 Aug ?? (2.7.0)} { +chng {2002 Aug 25 (2.7.0)} {
  • Make a distinction between numeric and text values when sorting. Text values sort according to memcmp(). Numeric values sort in numeric order.
  • Allow multiple simulataneous readers under windows by simulating the reader/writers locks that are missing from Win95/98/ME.
    • +
  • An error is now returned when trying to start a transaction if + another transaction is already active.
    • } chng {2002 Aug 12 (2.6.3)} { diff --git a/www/lang.tcl b/www/lang.tcl index 9e184611a4..e48701ba3c 100644 --- a/www/lang.tcl +++ b/www/lang.tcl @@ -1,7 +1,7 @@ # # Run this Tcl script to generate the sqlite.html file. # -set rcsid {$Id: lang.tcl,v 1.44 2002/08/18 19:09:24 drh Exp $} +set rcsid {$Id: lang.tcl,v 1.45 2002/08/25 20:11:19 drh Exp $} puts { @@ -724,7 +724,10 @@ a result immediately based on their inputs. Aggregate functions may only be used in a SELECT statement. Aggregate functions compute their result across all rows of the result set.

    -

    The following simple functions are currently supported:

    +

    The functions shown below are available by default. Additional +functions may be written in C and added to the database engine using +the sqlite_create_function() +API.

    @@ -738,6 +741,16 @@ their result across all rows of the result set.

    all arguments are NULL then NULL is returned. + + + + + + + + + +
    glob(X,Y)This function is used to implement the +"Y GLOB X" syntax of SQLite. The +sqlite_create_function() +interface can +be used to override this function and thereby change the operation +of the GLOB operator.
    last_insert_rowid() Return the ROWID of the last row insert from this @@ -752,6 +765,16 @@ If SQLite is configured to support UTF-8, then the number of UTF-8 characters is returned, not the number of bytes.
    like(X,Y)This function is used to implement the +"Y LIKE X" syntax of SQL. The +sqlite_create_function() +interface can +be used to override this function and thereby change the operation +of the LIKE operator.
    lower(X) Return a copy of string X will all characters @@ -811,8 +834,9 @@ UTF-8 strings.

    -The following aggregate functions are supported: -

    +The following aggregate functions are available by default. Additional +aggregate functions written in C may be added using the +sqlite_create_aggregate() API.

    @@ -1172,7 +1196,9 @@ result is specified by the expression list in between the SELECT and FROM keywords. Any arbitrary expression can be used as a result. If a result expression is } puts "[Operator *] then all columns of all tables are substituted" -puts {for that one expression.

    +puts {for that one expression. If the expression is the name of} +puts "a table followed by [Operator .*] then the result is all columns" +puts {in that one table.

    The query is executed against one or more tables specified after the FROM keyword. If multiple tables names are separated by commas, -- 2.47.3