Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
27 check-ins using file www/lang.tcl version be7a241fe3
|
2002-05-26
| ||
| 21:34 | Change functions to handle NULLs correctly. Added the NULLIF() function. (CVS 590) (check-in: 46ce1a9ab6 user: drh tags: trunk) | |
| 20:54 | NULL values are distinct. A comparison involving a NULL is always false. Operations on a NULL value yield a NULL result. This change makes SQLite operate more like the SQL spec, but it may break existing applications that assumed the old behavior. All the old tests pass but we still need to add new tests to better verify the new behavior. Fix for ticket #44. (CVS 589) (check-in: 9051173742 user: drh tags: trunk) | |
|
2002-05-25
| ||
| 00:18 | Additional testing of LEFT OUTER JOIN. (CVS 588) (check-in: d8d04c14f1 user: drh tags: trunk) | |
|
2002-05-24
| ||
| 20:31 | Initial implementation of LEFT OUTER JOIN including the expanded SQL92 join syntax. The basic functionality is there but there is still a lot of testing to do. (CVS 587) (check-in: 99bd1f5b9a user: drh tags: trunk) | |
| 16:14 | Add support for the full SQL join syntax. This is just a parser enhancement. We now recognize all kinds of joins, but we don't actually do anything with them yet. (CVS 586) (check-in: e238643efd user: drh tags: trunk) | |
| 02:14 | Added tests for multi-column primary keys. (CVS 585) (check-in: ffc49e56b1 user: drh tags: trunk) | |
| 02:04 | Split the IdList structure into IdList and SrcList. SrcList is used to represent a FROM clause and IdList is used for everything else. This change allows SrcList to grow to support outer joins without burdening the other uses of IdList. (CVS 584) (check-in: a167b71d8c user: drh tags: trunk) | |
|
2002-05-23
| ||
| 22:07 | Change the names of the PushList and PopList opcodes to ListPush and ListPop so that they will appear together with the other List opcodes in the documentation. (CVS 583) (check-in: c53b0b9283 user: drh tags: trunk) | |
| 13:15 | Fix for ticket #50. (CVS 582) (check-in: 82b74a494a user: drh tags: trunk) | |
| 12:50 | Partial fix for ticket #49. The correct result is computed, but now we have a memory leak. I'm not sure if the memory leak was pre-existing or a result of this change. (CVS 581) (check-in: 4d27ee4119 user: drh tags: trunk) | |
| 02:09 | Fix some places where a malloc() failure would lead to a segfault. (CVS 580) (check-in: 01ad352c3c user: drh tags: trunk) | |
| 00:30 | Do not allow triggers on the SQLITE_MASTER table. (CVS 579) (check-in: 275ba356f3 user: drh tags: trunk) | |
|
2002-05-22
| ||
| 21:27 | Fix for ticket #46: Report an error if a CREATE TABLE contains two or more columns with the same name. (CVS 578) (check-in: ba1953abd0 user: drh tags: trunk) | |
|
2002-05-21
| ||
| 23:44 | Fix for ticket #47: Use a cast to avoid a warning about discarding a "const" inside of hash.c. (CVS 577) (check-in: 0c90346153 user: drh tags: trunk) | |
| 13:43 | Double-quoted strings resolve to column names if possible. Single-quoted strings continue to be interpreted as string literals. (CVS 576) (check-in: 55e7d65496 user: drh tags: trunk) | |
| 13:18 | Clean up some compiler warnings. (CVS 575) (check-in: 3399b01219 user: drh tags: trunk) | |
| 13:02 | Modify the shell so that when it is doing a ".dump" it always uses single quotes and not double quotes for quoting literal strings. This is for portability to other databases that only support single quote string literals. (CVS 574) (check-in: f795afd63f user: drh tags: trunk) | |
| 12:56 | Fix for ticket #45: Allow an UPDATE statement to change the INTEGER PRIMARY KEY to itself without triggering a constraint error. (CVS 573) (check-in: 592da13468 user: drh tags: trunk) | |
| 11:38 | Additional code cleanup resulting from a review of the new trigger code. (CVS 572) (check-in: 37dbdd551e user: drh tags: trunk) | |
|
2002-05-19
| ||
| 23:43 | Style fixes to triggers code in various *.c files (partial fix to ticket #39) (CVS 571) (check-in: 8a4195c746 user: danielk1977 tags: trunk) | |
|
2002-05-17
| ||
| 00:05 | Stylistic changes to src/trigger.c (partial fix to ticket #39). Also more comments. (CVS 570) (check-in: b1d72cb584 user: danielk1977 tags: trunk) | |
|
2002-05-16
| ||
| 00:13 | Fix for ticket #42: Added comments to structs Trigger, TriggerStep and TriggerStack. (CVS 569) (check-in: 9ec8a2b139 user: danielk1977 tags: trunk) | |
|
2002-05-15
| ||
| 23:26 | Fix a typo in the c_interface.html documentation file. (CVS 568) (check-in: 454879fa40 user: drh tags: trunk) | |
| 14:17 | Fix for ticket #41: Better handling of CREATE TRIGGER in the sqlite_complete() function. (CVS 567) (check-in: f45c4b767a user: drh tags: trunk) | |
| 12:45 | Beginning to clean up the trigger code. Still lots of work to do. (CVS 566) (check-in: b10346818b user: drh tags: trunk) | |
| 11:44 | Remove all tabs from the beginning of source code lines. Replace tabs with the appropriate number of spaces. (CVS 565) (check-in: 690f9a1631 user: drh tags: trunk) | |
| 11:43 | In the "lang.html" documentation file, put the CREATE TRIGGER and DROP TRIGGER sections in alphabetical order. (CVS 564) (check-in: d1d8642b57 user: drh tags: trunk) | |