UnQL
Timeline
Not logged in

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

50 most recent timeline items

2013-01-07
16:49 • Changes to wiki page UnQL (user: drh)
2011-08-11
23:04
[8facf6305c] Leaf: Completed handling of array-style lhs in UPDATE. Some semantics need review. (user: pnr, tags: trunk)
2011-08-09
21:47 • Edit [d5e5efe19b1b15cf|d5e5efe19b]: Edit check-in comment. (user: pnr)
21:44
[d5e5efe19b] 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. (user: pnr, tags: trunk)
2011-08-02
11:18
[7797f759da] minor fixups to compile with windows compilers (user: pnr, tags: trunk)
2011-08-01
11:51 • Changes to wiki page UnQL (user: drh)
2011-07-29
17:06
[e634279337] Add missing file error01.test. (user: dan, tags: trunk)
2011-07-28
20:19
[fe083ef8a6] Make the max() and min() aggregate functions magnetic. (user: dan, tags: trunk)
19:32
[2dd4975e9c] Avoid concatenating multiple "syntax error" messages together. (user: dan, tags: trunk)
18:47
[f00265864e] Allow correlated references to list variables in the outer query to be used as data sources in scalar sub-queries. (user: dan, tags: trunk)
16:43
[0030b61e78] Add optional ASYNCHRONOUS and SYNCHRONOUS keywords in front of INSERT. (user: drh, tags: trunk)
16:00
[0ef5e83925] Add aggregate functions min(), max(), avg(), sum(), and array(). Enhance count() to accept either one or zero arguments. (user: dan, tags: trunk)
15:29
[7b79de2564] Fix the UPDATE command so that each changes is independent. (user: drh, tags: trunk)
2011-07-27
16:23
[1e6ab63d25] 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. (user: dan, tags: trunk)
12:17
[21ef096d9c] Allow FLATTEN/EACH on the properties of nested objects. (user: dan, tags: trunk)
2011-07-26
19:04
[269c12e5ee] Add some support for FLATTEN. (user: dan, tags: trunk)
2011-07-25
19:26
[5d36d9f104] Add partial support for the EACH keyword. (user: dan, tags: trunk)
13:59
[4c69266688] Stubs for the flatten code. (user: drh, tags: trunk)
13:51
[6ec01596ed] 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. (user: drh, tags: trunk)
11:59
[34eea27b86] Change to using xjd1_malloc() etc. internally instead of using malloc() directly. (user: dan, tags: trunk)
09:46
[9648d8798c] Add support for scalar sub-queries. (user: dan, tags: trunk)
2011-07-23
19:53
[8b4dcb6e8a] Return an error when an unknown object is referenced. i.e. for "SELECT x FROM y", return the error "no such object: x". (user: dan, tags: trunk)
19:16
[806a057fa4] Add forgotten test file base06.test. (user: dan, tags: trunk)
15:56
[1074c34ce5] Add an EXPLAIN keyword to statements. Updates to CREATE and DROP COLLECTION. (user: drh, tags: trunk)
15:40
[14a7f767bc] Add the sorting-list bubble diagram. Use it for SELECT and for a new design for CREATE INDEX. (user: drh, tags: trunk)
15:21 • Changes to wiki page UnQL (user: drh)
15:13
[fda26c957b] Update the syntax diagrams to include CREATE and DROP INDEX statements. (user: drh, tags: trunk)
14:58
[0ae879da94] Allow an "AS <id>" alias following the result expression of a SELECT. (user: dan, tags: trunk)
11:52
[dbbf1a25b5] Change the way OFFSET, LIMIT and ORDER BY are handled internally. (user: dan, tags: trunk)
2011-07-22
19:12
[2d74ebd10f] Add support for UNION, EXCEPT, INTERSECT. Doesn't work properly with ORDER BY yet. (user: dan, tags: trunk)
2011-07-21
19:56
[66e597b565] Add an optional AS clause on the result set of a SELECT in the bubble diagrams. (user: drh, tags: trunk)
18:59
[4e6e4ec201] Add support for DISTINCT. (user: dan, tags: trunk)
18:56
[33c3f4b80d] Add fragments to the syntax diagram page: /doc/trunk/doc/syntax/all.wiki (user: drh, tags: trunk)
18:24
[5fad391dbc] Internal changes to aggregate queries. (user: dan, tags: trunk)
17:48
[c6fdb1f6a7] 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. (user: drh, tags: trunk)
17:36
[f23e2c01b8] Candidate updates to the language syntax. Also add GIFs and postscript for all bubble diagrams to the check-in. (user: drh, tags: trunk)
17:08
[8c09ee47d8] Add support for GROUP BY and HAVING. (user: dan, tags: trunk)
2011-07-20
19:50
[514e16d7cb] Add support for simple aggregates. Fix a problem with joins. (user: dan, tags: trunk)
14:13
[f19d31ea5d] Improve error handling. (user: dan, tags: trunk)
2011-07-19
19:31
[a6fb845b35] Add a scalar length() function to return the length of strings. In preparation for adding aggregation. (user: dan, tags: trunk)
17:59
[885cc57b2c] Add support for OFFSET and LIMIT on simple SELECT statements. (user: dan, tags: trunk)
13:14
[a399717a11] Add support for ORDER BY on SELECT queries. (user: dan, tags: trunk)
2011-07-18
11:15
[e4cab3b6a0] Fix for queries that feature sub-selects in the FROM clause. (user: dan, tags: trunk)
09:39
[e7c27a9690] Fix handling of "AS" in FROM clauses. (user: dan, tags: trunk)
2011-07-16
20:00
[8c6e6a4ed7] Add support for joins. (user: drh, tags: trunk)
19:42
[dba083d964] Fix compiler warnings. Remove an unused declaration. (user: drh, tags: trunk)
16:12
[5b31aa5264] Fix problems with arrays and objects with zero members. (user: dan, tags: trunk)
15:47
[0d9044c381] Add support for the [] operator on arrays and strings. (user: dan, tags: trunk)
15:28
[b77b043f2d] Add a FIX ME comment on the unfinished "\uXXXX" translator. (user: drh, tags: trunk)
15:13 • Edit [e0499521683ba6f1|e049952168]: Edit check-in comment. (user: drh)