| drh | dce2cbe | 2000-05-31 02:27:49 +0000 | [diff] [blame] | 1 | # |
| 2 | # Run this script to generated a changes.html output file |
| 3 | # |
| 4 | puts {<html> |
| 5 | <head> |
| 6 | <title>SQLite Change Log</title> |
| 7 | </head> |
| 8 | <body bgcolor="white"> |
| 9 | <h1 align="center">Recent Changes To SQLite</h1> |
| 10 | |
| 11 | <DL> |
| 12 | } |
| 13 | |
| 14 | |
| 15 | proc chng {date desc} { |
| 16 | puts "<DT><B>$date</B></DT>" |
| 17 | puts "<DD><P><UL>$desc</UL></P></DD>" |
| 18 | } |
| 19 | |
| drh | 6206d50 | 2000-06-19 19:09:08 +0000 | [diff] [blame] | 20 | chng {2000 June 19} { |
| drh | 7ed1990 | 2000-06-19 19:10:28 +0000 | [diff] [blame^] | 21 | <li>Column names in UPDATE statements were case sensitive. |
| 22 | This mistake has now been fixed.</li> |
| drh | 6206d50 | 2000-06-19 19:09:08 +0000 | [diff] [blame] | 23 | } |
| 24 | |
| drh | 0040077 | 2000-06-16 20:51:26 +0000 | [diff] [blame] | 25 | chng {2000 June 16} { |
| 26 | <li>Added the concatenate string operator (||)</li> |
| 27 | } |
| 28 | |
| drh | 61fc2c6 | 2000-06-12 12:29:25 +0000 | [diff] [blame] | 29 | chng {2000 June 12} { |
| drh | e91cd0c | 2000-06-12 12:36:36 +0000 | [diff] [blame] | 30 | <li>Added the fcnt() function to the SQL interpreter. The fcnt() function |
| 31 | returns the number of database "Fetch" operations that have occurred. |
| 32 | This function is designed for use in test scripts to verify that |
| 33 | queries are efficient and appropriately optimized. Fcnt() has no other |
| 34 | useful purpose, as far as I know.</li> |
| 35 | <li>Added a bunch more tests that take advantage of the new fcnt() function. |
| drh | 61fc2c6 | 2000-06-12 12:29:25 +0000 | [diff] [blame] | 36 | The new tests did not uncover any new problems.</li> |
| drh | 6de4f4c | 2000-06-12 12:20:48 +0000 | [diff] [blame] | 37 | } |
| 38 | |
| drh | dcc7c74 | 2000-06-09 03:51:26 +0000 | [diff] [blame] | 39 | chng {2000 June 8} { |
| 40 | <li>Added lots of new test cases</li> |
| 41 | <li>Fix a few bugs discovered while adding test cases</li> |
| 42 | <li>Begin adding lots of new documentation</li> |
| 43 | } |
| 44 | |
| drh | 49c8780 | 2000-06-06 18:24:42 +0000 | [diff] [blame] | 45 | chng {2000 June 6} { |
| drh | 37f0b25 | 2000-06-09 03:52:04 +0000 | [diff] [blame] | 46 | <li>Added compound select operators: <B>UNION</b>, <b>UNION ALL</B>, |
| drh | f500577 | 2000-06-06 22:19:00 +0000 | [diff] [blame] | 47 | <b>INTERSECT</b>, and <b>EXCEPT</b></li> |
| drh | 49c8780 | 2000-06-06 18:24:42 +0000 | [diff] [blame] | 48 | <li>Added support for using <b>(SELECT ...)</b> within expressions</li> |
| 49 | <li>Added support for <b>IN</b> and <b>BETWEEN</b> operators</li> |
| 50 | <li>Added support for <b>GROUP BY</b> and <b>HAVING</b></li> |
| 51 | <li>NULL values are now reported ot the callback as a NULL pointer |
| 52 | rather than an empty string.</li> |
| 53 | } |
| 54 | |
| drh | 32aa77e | 2000-06-03 19:28:48 +0000 | [diff] [blame] | 55 | chng {2000 June 3} { |
| 56 | <li>Added support for default values on columns of a table.</li> |
| 57 | <li>Improved test coverage. Fixed a few obscure bugs found by the |
| 58 | improved tests.</li> |
| 59 | } |
| 60 | |
| drh | bed8690 | 2000-06-02 13:27:59 +0000 | [diff] [blame] | 61 | chng {2000 June 2} { |
| 62 | <li>All database files to be modified by an UPDATE, INSERT or DELETE are |
| 63 | now locked before any changes are made to any files. |
| 64 | This makes it safe (I think) to access |
| 65 | the same database simultaneously from multiple processes.</li> |
| 66 | <li>The code appears stable so we are now calling it "beta".</li> |
| 67 | } |
| 68 | |
| 69 | chng {2000 June 1} { |
| 70 | <li>Better support for file locking so that two or more processes |
| 71 | (or threads) |
| 72 | can access the same database simultaneously. More work needed in |
| 73 | this area, though.</li> |
| 74 | } |
| 75 | |
| drh | 7203e28 | 2000-05-31 15:35:42 +0000 | [diff] [blame] | 76 | chng {2000 May 31} { |
| drh | bf66fff | 2000-05-31 15:43:25 +0000 | [diff] [blame] | 77 | <li>Added support for aggregate functions (Ex: <b>COUNT(*)</b>, <b>MIN(...)</b>) |
| drh | cce7d17 | 2000-05-31 15:34:51 +0000 | [diff] [blame] | 78 | to the SELECT statement.</li> |
| drh | 56d48ad | 2000-05-31 21:06:30 +0000 | [diff] [blame] | 79 | <li>Added support for <B>SELECT DISTINCT ...</B></li> |
| drh | cce7d17 | 2000-05-31 15:34:51 +0000 | [diff] [blame] | 80 | } |
| 81 | |
| drh | dce2cbe | 2000-05-31 02:27:49 +0000 | [diff] [blame] | 82 | chng {2000 May 30} { |
| 83 | <li>Added the <b>LIKE</b> operator.</li> |
| 84 | <li>Added a <b>GLOB</b> operator: similar to <B>LIKE</B> |
| 85 | but it uses Unix shell globbing wildcards instead of the '%' |
| 86 | and '_' wildcards of SQL.</li> |
| 87 | <li>Added the <B>COPY</b> command patterned after |
| 88 | <a href="http://www.postgresql.org/">PostgreSQL</a> so that SQLite |
| 89 | can now read the output of the <b>pg_dump</b> database dump utility |
| 90 | of PostgreSQL.</li> |
| 91 | <li>Added a <B>VACUUM</B> command that that calls the |
| 92 | <b>gdbm_reorganize()</b> function on the underlying database |
| 93 | files.</li> |
| 94 | <li>And many, many bug fixes...</li> |
| 95 | } |
| 96 | |
| 97 | chng {2000 May 29} { |
| 98 | <li>Initial Public Release of Alpha code</li> |
| 99 | } |
| 100 | |
| 101 | puts { |
| 102 | </DL> |
| 103 | <p><hr /></p> |
| 104 | <p><a href="index.html"><img src="/goback.jpg" border=0 /> |
| 105 | Back to the SQLite Home Page</a> |
| 106 | </p> |
| 107 | |
| 108 | </body></html>} |