UnQL

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

50 check-ins occurring around d06f20c02a9f5f1d.

2011-07-21
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
17:27
Reference counting of JsonNode objects. check-in: 0d3c641331 user: drh tags: trunk
16:01
Begin adding support for the expression list in between SELECT and FROM. check-in: 6d55502945 user: drh tags: trunk
14:08
Base test infrastructure working. Added "make test" to the makefile. check-in: 9432de00a5 user: drh tags: trunk
12:49
Enhance the shell with parser and command tracing and "echo". check-in: d780db9196 user: drh tags: trunk
12:19
Rework the shell command to make it useful as a test harness. check-in: e5de41b4de user: drh tags: trunk
2011-06-25
00:13
Fix memory leaks. check-in: 9ee98afd91 user: drh tags: trunk
00:07
Very simply queries working. check-in: 4eda880431 user: drh tags: trunk