Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
36 check-ins using file VERSION version 80c0f75cf7
|
2002-03-03
| ||
| 23:06 | More bugs fixed for views. (CVS 416) (check-in: 8130776230 user: drh tags: trunk) | |
| 18:59 | VIEWs are bound to tables when they are used, not when they are first entered. This works around the problem of what to do if a table is deleted that a view refers to. (CVS 415) (check-in: 6121e5ab93 user: drh tags: trunk) | |
| 03:42 | Fix a memory leak in expression processing. (CVS 414) (check-in: dfe431c9b7 user: drh tags: trunk) | |
| 03:11 | Additional tests of flattening (CVS 413) (check-in: e1d93c5923 user: drh tags: trunk) | |
| 03:03 | Suppress superfluous OP_OpenTemps when flattening subqueries. (CVS 412) (check-in: 000441c8fe user: drh tags: trunk) | |
| 02:49 | Bug fixes and additional tests for the subquery flattener. (CVS 411) (check-in: 2c05389eda user: drh tags: trunk) | |
|
2002-03-02
| ||
| 20:41 | Pager optimization: do not write or journal free pages. This results in a 2x performance gain for large INSERTs and a 5x performance gain for large DELETEs. (CVS 410) (check-in: cf1ebcfb74 user: drh tags: trunk) | |
| 19:00 | Change the btree node balancers to sort nodes into accending order. This improves insert and delete speed by 25%. (CVS 409) (check-in: abbb999d4f user: drh tags: trunk) | |
| 17:04 | Subquery flattening is implemented and passes all regression tests. We still need to add addition tests to the suite to further exercise the flattener, however. (CVS 408) (check-in: d5d3e79cc5 user: drh tags: trunk) | |
|
2002-02-28
| ||
| 04:10 | Bug fix when -DMEMORY_DEBUG is off. (CVS 407) (check-in: e14b0c82f3 user: drh tags: trunk) | |
| 04:00 | Fix bugs in substr() for UTF-8. (CVS 406) (check-in: e9fd9e7b0f user: drh tags: trunk) | |
| 03:31 | Remove unused opcodes from the VDBE and fix a bug in the substr() function. (CVS 405) (check-in: e8611e0c05 user: drh tags: trunk) | |
| 03:14 | Change the IFNULL and NVL functions to COALESCE. Change MIN and MAX so that they require at least one argument. (CVS 404) (check-in: 7d86749d4a user: drh tags: trunk) | |
| 03:04 | The new function code passes regression tests. (CVS 403) (check-in: b00cf110b1 user: drh tags: trunk) | |
| 01:46 | Fix the coredump. There are still problems in the test suite though. (CVS 402) (check-in: 6af10cc53a user: drh tags: trunk) | |
| 00:46 | Added IFNULL and NVL functions. (CVS 401) (check-in: c6a85c8ee3 user: drh tags: trunk) | |
| 00:41 | Completely remove the old SQL function system and replace it with the new user functions. The code currently compiles but it coredumps on the test suite. Do not use in its present state. (CVS 400) (check-in: 50797fee50 user: drh tags: trunk) | |
|
2002-02-27
| ||
| 19:50 | Try to reduce the number of malloc() for user-defined functions. Begin transfering built-in functions over to the user-define function mechanism. (CVS 399) (check-in: c4f9e017b4 user: drh tags: trunk) | |
| 19:00 | Revise the API for user-defined functions. (CVS 398) (check-in: 633951f0fa user: drh tags: trunk) | |
| 01:53 | The user-defined function routines failed to detect a malloc() failure. (CVS 397) (check-in: 085b0d671a user: drh tags: trunk) | |
| 01:47 | Bug fixes in the VIEW implementation. (CVS 396) (check-in: 668ef6380e user: drh tags: trunk) | |
|
2002-02-26
| ||
| 23:55 | Comment changes only. (CVS 395) (check-in: 63b87f2ea6 user: drh tags: trunk) | |
| 23:24 | Fix a bug in the quoting of .dump output. By Rajit Singh. (CVS 394) (check-in: f2310f36d5 user: drh tags: trunk) | |
|
2002-02-24
| ||
| 17:12 | Added a "stddev()" aggregate function for testing the new user aggregate function interface. (CVS 393) (check-in: 2198109712 user: drh tags: trunk) | |
| 03:25 | Code for user-defined aggregates added. Legacy tests all pass but there has been no testing of the new user-defined aggregate code. (CVS 392) (check-in: 1e037eb303 user: drh tags: trunk) | |
| 01:55 | Move the build-in function definitions into a new source file "func.c". (CVS 391) (check-in: 530b0f4f2d user: drh tags: trunk) | |
|
2002-02-23
| ||
| 23:45 | Added support for user-defined normal functions. Support for user-defined aggregates is pending. (CVS 390) (check-in: c490a1ff95 user: drh tags: trunk) | |
| 19:39 | Modify lemon to use much less memory for its parser tables. This reduces the size of the library by 50K, which is important for an embedded library. (CVS 389) (check-in: 67a135a051 user: drh tags: trunk) | |
| 18:45 | Bug fix in lemon: 3-way conflicts (SHIFT/REDUCE/REDUCE) were not detected or resolved. This is now fixed. Also, table compression works a little better. (CVS 388) (check-in: 8da0ac9a8b user: drh tags: trunk) | |
| 02:32 | Code to implement CREATE VIEW is in place. A quick smoke test shows that it works, but there are probably still many bugs. (CVS 387) (check-in: 39fed2df11 user: drh tags: trunk) | |
|
2002-02-21
| ||
| 12:01 | Change the SQLITE_MASTER format to version 2 in preparation for adding views. (CVS 386) (check-in: b2a9807fed user: drh tags: trunk) | |
| 02:25 | Do not allow dot-commands to occur in the middle of a real SQL command. (CVS 385) (check-in: ffb00bf36a user: drh tags: trunk) | |
|
2002-02-19
| ||
| 22:43 | Fix a comment. (CVS 384) (check-in: 953928537c user: drh tags: trunk) | |
| 22:42 | New ROWIDs are numbered sequentially. (CVS 383) (check-in: 1686196a8a user: drh tags: trunk) | |
| 15:00 | Optimize simple min() and max() queries. (CVS 382) (check-in: cc5abfe392 user: drh tags: trunk) | |
| 13:39 | Change the name of the sanity_check PRAGMA to "integrity_check" and make it available on all compiles. (CVS 381) (check-in: c6e9048e66 user: drh tags: trunk) | |