Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
38 descendants and 50 ancestors of e4cab3b6a030862532fd2f8c99fa2e0709953b10
|
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 | |
|
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 | |
|
2011-06-24
| ||
| 19:14 | Typing in more code. check-in: 9d3d2f9226 user: drh tags: trunk | |
|
2011-06-21
| ||
| 20:36 | Improvisations directed toward implementing the query engine. check-in: 26fd1b039d user: drh tags: trunk | |
| 17:42 | Fix an uninitialized structure that was causing segfaults. check-in: dc86933067 user: drh tags: trunk | |
| 17:31 | Rename TABLE to DATASET. check-in: b854a47a54 user: drh tags: trunk | |
| 17:10 | Begin adding code to perform queries. Compiles and links, but probably does not work. This is code from a few days ago that I am just now coming back to work on again. check-in: fb25f79d0f user: drh tags: trunk | |
|
2011-06-14
| ||
| 18:47 | Get INSERT working. Improved error messages. check-in: c9b9b54e59 user: drh tags: trunk | |
| 17:16 | Begin adding error message handling logic and code to implement statements. Incremental check-in because I have to stop to work on something else. check-in: 6299c43154 user: drh tags: trunk | |
| 14:33 | JSON string parsing and rendering appears to work. check-in: 52ddc082d1 user: drh tags: trunk | |