UnQL

Timeline
Login

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

2011-08-11
23:04
Completed handling of array-style lhs in UPDATE. Some semantics need review. Leaf check-in: 8facf6305c user: pnr tags: trunk
2011-08-09
21:44
Added initial support for array-style lhs in the UPDATE command. Assignments that would grow an array are still unimplemented, as is accessing characters of a string using the array syntax. check-in: d5e5efe19b user: pnr tags: trunk
2011-08-02
11:18
minor fixups to compile with windows compilers check-in: 7797f759da user: pnr tags: trunk
2011-07-29
17:06
Add missing file error01.test. check-in: e634279337 user: dan tags: trunk
2011-07-28
20:19
Make the max() and min() aggregate functions magnetic. check-in: fe083ef8a6 user: dan tags: trunk
19:32
Avoid concatenating multiple "syntax error" messages together. check-in: 2dd4975e9c user: dan tags: trunk
18:47
Allow correlated references to list variables in the outer query to be used as data sources in scalar sub-queries. check-in: f00265864e user: dan tags: trunk
16:43
Add optional ASYNCHRONOUS and SYNCHRONOUS keywords in front of INSERT. check-in: 0030b61e78 user: drh tags: trunk
16:00
Add aggregate functions min(), max(), avg(), sum(), and array(). Enhance count() to accept either one or zero arguments. check-in: 0ef5e83925 user: dan tags: trunk
15:29
Fix the UPDATE command so that each changes is independent. check-in: 7b79de2564 user: drh tags: trunk
2011-07-27
16:23
Add the ".json" command to shell.c. ".json" is like ".result", but removes excess white-space and quotes unquoted identifiers from the test result before comparing it with the library output. This allows us to make test files more readable. check-in: 1e6ab63d25 user: dan tags: trunk
12:17
Allow FLATTEN/EACH on the properties of nested objects. check-in: 21ef096d9c user: dan tags: trunk
2011-07-26
19:04
Add some support for FLATTEN. check-in: 269c12e5ee user: dan tags: trunk
2011-07-25
19:26
Add partial support for the EACH keyword. check-in: 5d36d9f104 user: dan tags: trunk
13:59
Stubs for the flatten code. check-in: 4c69266688 user: drh tags: trunk
13:51
Add SQLITE_NO_SYNC to the SQLite backing store compilation. This makes tests run much faster, at the expense of crash survivability. We do not really care about surviving crashes in this prototype - at least not yet. check-in: 6ec01596ed user: drh tags: trunk
11:59
Change to using xjd1_malloc() etc. internally instead of using malloc() directly. check-in: 34eea27b86 user: dan tags: trunk
09:46
Add support for scalar sub-queries. check-in: 9648d8798c user: dan tags: trunk
2011-07-23
19:53
Return an error when an unknown object is referenced. i.e. for "SELECT x FROM y", return the error "no such object: x". check-in: 8b4dcb6e8a user: dan tags: trunk
19:16
Add forgotten test file base06.test. check-in: 806a057fa4 user: dan tags: trunk
15:56
Add an EXPLAIN keyword to statements. Updates to CREATE and DROP COLLECTION. check-in: 1074c34ce5 user: drh tags: trunk
15:40
Add the sorting-list bubble diagram. Use it for SELECT and for a new design for CREATE INDEX. check-in: 14a7f767bc user: drh tags: trunk
15:13
Update the syntax diagrams to include CREATE and DROP INDEX statements. check-in: fda26c957b user: drh tags: trunk
14:58
Allow an "AS <id>" alias following the result expression of a SELECT. check-in: 0ae879da94 user: dan tags: trunk
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