Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 check-ins occurring around a8abdbeadb52a66a.
2011-07-23
| ||
11:52 | Change the way OFFSET, LIMIT and ORDER BY are handled internally. check-in: dbbf1a25b5 user: dan tags: trunk | |
2011-07-22
| ||
19:12 | Add support for UNION, EXCEPT, INTERSECT. Doesn't work properly with ORDER BY yet. check-in: 2d74ebd10f user: dan tags: trunk | |
2011-07-21
| ||
19:56 | Add an optional AS clause on the result set of a SELECT in the bubble diagrams. check-in: 66e597b565 user: drh tags: trunk | |
18:59 | Add support for DISTINCT. check-in: 4e6e4ec201 user: dan tags: trunk | |
18:56 | Add fragments to the syntax diagram page: /doc/trunk/doc/syntax/all.wiki check-in: 33c3f4b80d user: drh tags: trunk | |
18:24 | Internal changes to aggregate queries. check-in: 5fad391dbc user: dan tags: trunk | |
17:48 | Fix the postscript generation to omit the creation date, so that we do not change the postscript on every rerun of the generator script. Change sql-stmt to unql-stmt. Add the all.wiki page. check-in: c6fdb1f6a7 user: drh tags: trunk | |
17:36 | Candidate updates to the language syntax. Also add GIFs and postscript for all bubble diagrams to the check-in. check-in: f23e2c01b8 user: drh tags: trunk | |
17:08 | Add support for GROUP BY and HAVING. check-in: 8c09ee47d8 user: dan tags: trunk | |
2011-07-20
| ||
19:50 | Add support for simple aggregates. Fix a problem with joins. check-in: 514e16d7cb user: dan tags: trunk | |
14:13 | Improve error handling. check-in: f19d31ea5d user: dan tags: trunk | |
2011-07-19
| ||
19:31 | Add a scalar length() function to return the length of strings. In preparation for adding aggregation. check-in: a6fb845b35 user: dan tags: trunk | |
17:59 | Add support for OFFSET and LIMIT on simple SELECT statements. check-in: 885cc57b2c user: dan tags: trunk | |
13:14 | Add support for ORDER BY on SELECT queries. check-in: a399717a11 user: dan tags: trunk | |
2011-07-18
| ||
11:15 | Fix for queries that feature sub-selects in the FROM clause. check-in: e4cab3b6a0 user: dan tags: trunk | |
09:39 | Fix handling of "AS" in FROM clauses. check-in: e7c27a9690 user: dan tags: trunk | |
2011-07-16
| ||
20:00 | Add support for joins. check-in: 8c6e6a4ed7 user: drh tags: trunk | |
19:42 | Fix compiler warnings. Remove an unused declaration. check-in: dba083d964 user: drh tags: trunk | |
16:12 | Fix problems with arrays and objects with zero members. check-in: 5b31aa5264 user: dan tags: trunk | |
15:47 | Add support for the [] operator on arrays and strings. check-in: 0d9044c381 user: dan tags: trunk | |
15:28 | Add a FIX ME comment on the unfinished "\uXXXX" translator. check-in: b77b043f2d user: drh tags: trunk | |
15:12 | Implement the WITHIN operator. check-in: 0eba200fb2 user: drh tags: trunk | |
14:53 | Provide an implementation for the "in" operator. check-in: 4f893cfaf7 user: drh tags: trunk | |
12:26 | Add support for the [] operator on objects. Using the [] operator with an array or string does not work yet. check-in: e049952168 user: dan tags: trunk | |
12:22 | Add parsing of "in" and "WITHIN" operators. Missing implementions. check-in: a8abdbeadb user: drh tags: trunk | |
06:53 | Add support for SELECT queries with no FROM clause (i.e. "SELECT <expr>;"). check-in: 61dc9bee92 user: dan tags: trunk | |
2011-07-15
| ||
21:15 | Added support for the ?: operator. check-in: a9a0c2d16e user: drh tags: trunk | |
20:41 | Parser changes to bring expression processing closer to javascript. check-in: 47a517ea6e user: drh tags: trunk | |
19:33 | Add ===, !== and >>> operators. check-in: 1296cc1b15 user: drh tags: trunk | |
18:36 | Change the NOT operator into !. check-in: 59096a3d9c user: drh tags: trunk | |
18:22 | Keywords "true", "false", and "null" are now lower-case. ("NULL" can also optionally be all upper-case.) Use && and || instead of AND and OR. check-in: 340cf0441f user: drh tags: trunk | |
18:14 | Add the bitwise expression operators (&, |, <<, >> and ~). Also fix the unary minus operator. check-in: d06f20c02a user: dan tags: trunk | |
16:11 | Add support for logical expression operators AND, OR and NOT. check-in: b4ea7f84c7 user: dan tags: trunk | |
2011-07-14
| ||
19:17 | Fix a cut and paste bug in update.c. check-in: 55db23bf44 user: dan tags: trunk | |
2011-07-08
| ||
19:19 | Add tcl scripts to generate bubble diagrams for the query language syntax. check-in: 1afab97fd6 user: dan tags: trunk | |
2011-07-02
| ||
23:19 | Work towards subqueries. check-in: 14c401fdc2 user: drh tags: trunk | |
2011-06-30
| ||
23:40 | Tweak the Makefile so that it builds out-of-the-box on Linux and Mac. check-in: 6a68e48733 user: drh tags: trunk | |
23:22 | Added demonstration script #1. check-in: 4893830330 user: drh tags: trunk | |
22:24 | Update adds new fields as appropriate. check-in: 05d60ec33a user: drh tags: trunk | |
20:44 | Basic UPDATE statements (and UPSERT) is now working. However, new fields are not added yet. check-in: e2bc14a5be user: drh tags: trunk | |
20:13 | Incremental check-in. Various bug fixes. Progress toward getting UPDATE running. check-in: 0a23ab0e48 user: drh tags: trunk | |
15:51 | Added preliminary UPSERT syntax. Added some simple UPDATE test cases, but since the UPDATE code is not in place, those test cases are currently failing. check-in: c0f72777e2 user: drh tags: trunk | |
00:09 | Get DELETE statements working. check-in: f4d26bb1e0 user: drh tags: trunk | |
2011-06-29
| ||
23:08 | Basic WHERE clauses working on simple SELECT statements. check-in: 0f90d3efaf user: drh tags: trunk | |
20:10 | Document references within expressions now working. check-in: ce30690c86 user: drh tags: trunk | |
19:02 | Change the parse tree to use zero-terminated strings rather than Token objects. check-in: 365b149fa1 user: drh tags: trunk | |
17:53 | Change DATASET to COLLECTION. check-in: 1db9558acf user: drh tags: trunk | |
2011-06-28
| ||
15:15 | Got all test cases passing again. check-in: 423cc63722 user: drh tags: trunk | |
13:46 | Change the syntax so that the result specified in between SELECT and FROM keywords is a single JSON structure (actually any expression) rather than a SQL-style list. This check-in compiles and runs, but there are bugs so that the tests fail. check-in: 56a739ec3b user: drh tags: trunk | |
2011-06-27
| ||
17:56 | Allow JSON strings in the column list. check-in: 51c49e25e9 user: drh tags: trunk | |