Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of src/parse.y
2019-11-02
| ||
13:45 | "STORED" is not actually a keyword. The parser looks for STORED as an ordinary identifier. file: [17c1ae26] check-in: [167cd574] user: drh branch: trunk, size: 62949 | |
2019-10-30
| ||
13:00 | New tokens ALWAYS, GENERATED, and STORED used by generated columns should all be fallback tokens. file: [ea567d2a] check-in: [13fe6978] user: drh branch: trunk, size: 62956 | |
2019-10-28
| ||
04:20 | ALWAYS macro added for coverage. file: [5f09d382] check-in: [a1e1ba91] user: drh branch: trunk, size: 62885 | |
2019-10-24
| ||
23:43 | Merge fixes from trunk. file: [97d46c41] check-in: [4ec57d88] user: drh branch: generated-columns, size: 62877 | |
2019-10-23
| ||
18:09 | When a vector comparison appears in the WHERE clause and the constraint side has a COLLATE clause on the first term of the vector, be sure to honor that COLLATE clause. Ticket [135c9da7513e5a97]. file: [72886e0c] check-in: [978b2d20] user: drh branch: trunk, size: 62662 | |
2019-10-16
| ||
19:31 | Simple INSERT and SELECT operations working with VIRTUAL columns. file: [bc453ce8] check-in: [7f9f90b1] user: drh branch: generated-columns, size: 62788 | |
12:18 | Initial experimental code for generated column support. Non-functional. file: [516984fb] check-in: [11d472c1] user: drh branch: generated-columns, size: 62789 | |
2019-10-09
| ||
17:06 | An alternative, experimental lookaside memory allocator that uses two different slot sizes. file: [916f6f75] check-in: [5ba8cee8] user: sperry branch: 2-size-lookaside, size: 62619 | |
2019-10-05
| ||
14:39 | Performance optimization to the lookaside-memory disabling mechanism. file: [19c8b65c] check-in: [17ce1c49] user: drh branch: trunk, size: 62573 | |
2019-09-30
| ||
16:14 | Merge the 3.30.0 beta 1 changes from trunk. file: [601f2ac4] check-in: [a003818f] user: drh branch: begin-concurrent, size: 62959 | |
2019-09-23
| ||
12:38 | Omit the sqlite3IntTokens array constant for a code simplification. file: [50bfcb34] check-in: [f907395e] user: drh branch: trunk, size: 62561 | |
2019-09-16
| ||
12:08 | Merge recent trunk enhancements into the begin-concurrent branch. file: [ea6ec925] check-in: [93b9ef3f] user: drh branch: begin-concurrent, size: 62972 | |
2019-08-27
| ||
19:59 | Add support for "ORDER BY ... NULLS FIRST" and "ORDER BY ... NULLS LAST". Use this to fix ticket [f8a7060e]. file: [6f284f74] check-in: [94085fb3] user: dan branch: trunk, size: 62574 | |
17:01 | Omit the "x IN (y)" to "x==y" optimization of check-in [e68b427afbc82e20] (and ticket [e39d032577df6942]) as it causes difficult affinity problems as demonstrated by ticket [dbaf8a6820be1ece] and the original assertion fault is no longer a factor due to countless other changes of the previous 5 years. file: [152a7275] check-in: [7f5168a7] user: drh branch: trunk, size: 62348 | |
2019-08-23
| ||
21:11 | Attempt to parse the NULLS LAST clause more efficiently. A few cycles were saved, but at the expense of more code. And there is a bug was introduced somewhere. Not worth continuing down this line. file: [1e469e2b] check-in: [12d2cf88] user: drh branch: dead-end, size: 63852 | |
20:33 | Move some things in parse.y so that TK_COLUMN and TK_AGG_COLUMN are assigned the same values as they are on trunk for a very small speedup. file: [d127bf3f] check-in: [d26fdfa3] user: dan branch: nulls-last, size: 63596 | |
2019-08-12
| ||
16:36 | Experimental implementation of NULLS FIRST/LAST. This branch still has problems - the most significant of which is that ORDER BY clauses with a non-default NULLS FIRST/LAST qualifier can never use an index. file: [61e979ce] check-in: [07babb0f] user: dan branch: nulls-last, size: 63596 | |
2019-08-05
| ||
18:01 | Refactor field Expr.affinity into Expr.affExpr to avoid confusion with other fields and variables named "affinity" and display affExpr it in sqlite3TreeViewExpr() output. file: [6d03a24b] check-in: [a29f2a7d] user: drh branch: trunk, size: 63370 | |
2019-07-16
| ||
19:44 | Add new assert() statements in an attempt to help static analyzers avoid false-positives. file: [22889d25] check-in: [9e664585] user: drh branch: trunk, size: 63373 | |
2019-07-13
| ||
18:27 | Fix a memory leak that could follow an OOM in the new FILTER code. file: [8ec5ce13] check-in: [85fd70fe] user: dan branch: trunk, size: 63353 | |
16:22 | Rework the FILTER clause implementation to share more code with window functions. file: [ef494825] check-in: [5dac8c38] user: dan branch: filter-clause, size: 63306 | |
2019-07-11
| ||
18:43 | Change the parser on this branch to more closely match trunk. This saves a few more cycles. file: [6f2e8ec7] check-in: [be01b801] user: dan branch: filter-clause, size: 63379 | |
2019-07-08
| ||
21:06 | Merge recent trunk enhancements into the begin-concurrent branch. file: [eae942fc] check-in: [7fff0803] user: drh branch: begin-concurrent, size: 63472 | |
2019-07-02
| ||
11:56 | Experimental implementation of FILTER clause for aggregate functions. file: [2902f393] check-in: [1f1ae2d6] user: dan branch: filter-clause, size: 63041 | |
2019-06-11
| ||
10:43 | Add the new sqlite3ExprUnmapAndDelete() function and use it in place of separate calls to sqlite3RenameExprUnmap() and sqlite3ExprDelete(). file: [026e3e6f] check-in: [36ea13e0] user: drh branch: trunk, size: 63074 | |
01:30 | Remove a comment made obsolete by check-in [71643deb6bbad4b4]. No changes to code. file: [9e13554d] check-in: [211c8002] user: drh branch: trunk, size: 63070 | |
2019-06-10
| ||
19:17 | Have ALTER TABLE commands ignore the lhs of "expr IN ()" and "expr NOT IN ()" expressions, just as other queries do. Fix for [533010b8ca]. file: [05480254] check-in: [71643deb] user: dan branch: trunk, size: 63421 | |
15:34 | Handle renaming a column or table when the schema contains a (meaningless) index on the constant expression ('text' IN ()) or ('text' NOT IN()). Fix for [fd76310a]. file: [954e2624] check-in: [567b1309] user: dan branch: trunk, size: 63529 | |
2019-05-18
| ||
19:49 | Avoid including the comment in the output of "PRAGMA table_info" in situations where there is a comment following a DEFAULT value within a CREATE TABLE statement. file: [91f76f43] check-in: [d91095ba] user: dan branch: trunk, size: 63115 | |
2019-05-14
| ||
21:51 | Merge the latest trunk enhancements into begin-concurrent. file: [a0a373aa] check-in: [5d3a6e18] user: drh branch: begin-concurrent, size: 63418 | |
2019-04-19
| ||
13:38 | Streamline the processing of the AND operator. Slightly smaller and faster. file: [22f64d8a] check-in: [7713996a] user: drh branch: trunk, size: 63020 | |
2019-04-15
| ||
14:59 | Merge the latest enhancements from trunk. file: [8b610cda] check-in: [7c328e88] user: drh branch: begin-concurrent, size: 63420 | |
2019-04-05
| ||
21:17 | Remove some stale references to the addopcodes.tcl script from documentation. file: [8de9b1da] check-in: [c0381b0b] user: drh branch: trunk, size: 63022 | |
20:56 | Eliminate the tool/addopcodes.tcl script. The purpose of that script was to keep the number of parser codes below 256 in order to save parser table space. But we have long since blown through that ceiling so the addopcodes.tcl script was just needless complexity. There is no longer any reason to keep it around. file: [0d461b67] check-in: [d2728192] user: drh branch: trunk, size: 63189 | |
2019-04-02
| ||
18:12 | Small optimizations to the grammar for window functions save about 120 bytes of space in the parser tables. file: [209b0e39] check-in: [bce01d95] user: drh branch: trunk, size: 61689 | |
17:45 | Including the phrase EXCLUDE NO OTHERS in the frame-spec of a window function (which is the default setting for EXCLUDE) silently disables the xInverse optimization. This is a feature, but we will keep it undocumented for now in case we later decide it is a bad idea. file: [db16b24c] check-in: [10aedce3] user: drh branch: trunk, size: 61792 | |
2019-03-19
| ||
06:40 | Ensure that all the new window-function keywords can still be used as SQL identifiers. file: [a020386a] check-in: [a6d61dfd] user: dan branch: window-functions, size: 61788 | |
2019-03-16
| ||
20:29 | Fix problems with RANGE windows and string, blob and NULL values. file: [cff56367] check-in: [cebe09e1] user: dan branch: window-functions, size: 61759 | |
2019-03-14
| ||
20:53 | Parse EXCLUDE clauses in window frames. They do not yet work. file: [a2a79da7] check-in: [d03c7533] user: dan branch: window-functions, size: 61763 | |
2019-03-08
| ||
20:02 | Finish consolidation of window frame code. Add untested support for GROUPS frames. file: [e5628381] check-in: [954bf369] user: dan branch: window-functions, size: 61349 | |
15:30 | Merge all the latest enhancements from trunk. file: [e53f9012] check-in: [667cce3d] user: drh branch: begin-concurrent-pnu, size: 61276 | |
2019-02-16
| ||
17:27 | Add support for chaining of WINDOW definitions. file: [deae85a1] check-in: [c155125f] user: dan branch: window-functions, size: 61301 | |
2019-01-31
| ||
02:42 | If the amalgamation file "sqlite3.c" is generated using the SQLITE_ENABLE_UPDATE_DELETE_LIMIT option, but then subsequently (mis-)compiled without that option, and then a particular syntax error could cause a memory leak, but for this fix. file: [741a270b] check-in: [1bb17c86] user: drh branch: trunk, size: 60919 | |
2019-01-24
| ||
16:27 | Fix a problem with running ALTER TABLE on a schema that contains expressions of the type "col IN ()" (empty set on RHS of IN operator). file: [9e5fc4c9] check-in: [2d9cd067] user: dan branch: trunk, size: 60780 | |
2019-01-17
| ||
15:40 | Revamp the SrcList allocator routines to be methods of Parse instead of being methods of the "sqlite3" object, so that they can leave better error messages when the SrcList object grows too large. file: [489673ac] check-in: [df08d472] user: drh branch: trunk, size: 60735 | |
2019-01-11
| ||
13:32 | The keywords TRUE and FALSE should only act as boolean literal values if unquoted. file: [e801b38c] check-in: [5547f39d] user: drh branch: trunk, size: 60767 | |
2018-12-15
| ||
20:59 | Merge latest wal2 changes into this branch. file: [8206217f] check-in: [06bb80ee] user: dan branch: begin-concurrent-wal2, size: 61190 | |
2018-12-08
| ||
00:43 | Allow the INTO clause of VACUUM to be a text-valued expression. file: [a3c0db59] check-in: [af172b53] user: drh branch: vacuum-into, size: 60833 | |
2018-12-07
| ||
17:28 | Prototype implementation for the VACUUM INTO command. file: [3bf1b720] check-in: [036e3320] user: drh branch: vacuum-into, size: 60782 | |
2018-12-05
| ||
13:44 | Merge enhancements from trunk, especially the enhanced sqlite3_normalized_sql() interface. file: [9281e994] check-in: [47b73f6b] user: drh branch: begin-concurrent, size: 60995 | |
2018-12-04
| ||
01:18 | Attempt to make the parser a little faster by storing the ON and USING clause in a single OnUsing object. file: [c4da3ae9] check-in: [6770ed08] user: drh branch: on-using-opt, size: 60622 | |
2018-12-03
| ||
01:47 | Fix a parser bug in the use of parentheses around table-valued functions. file: [5cf85c2b] check-in: [58a51123] user: drh branch: trunk, size: 60638 | |
2018-09-28
| ||
20:58 | Merge latest trunk into this branch. file: [9e69c380] check-in: [86750c92] user: dan branch: begin-concurrent, size: 60801 | |
2018-09-20
| ||
19:02 | Combine the Expr.pTab and Expr.pWin fields into a union named "y". Add a new EP_WinFunc property that is only true if Expr.y.pWin is a valid pointer. This reduces the size of the Expr object by 8 bytes, reduces the overall amount of code, and shaves over 1 million cycles off of the speed test. file: [6840fe7c] check-in: [ad130bb8] user: drh branch: trunk, size: 60444 | |
2018-09-19
| ||
20:14 | Reduce the size of Expr to 64-bytes. This works somewhat, but there are test failures. More importantly, the size reduction from 80- to 64-bytes has not lowered the schema memory usage, but it has made the code a little bigger and a little slower. So the initial evidence is that this Expr refactoring experiment is not working... file: [96a86b76] check-in: [24b0f66a] user: drh branch: expr-simplify, size: 60268 | |
14:54 | Reduce the size of Expr from 80 to 72 bytes moving the pRight field inside the "x" union. This is an incremental check-in that still has issues. file: [cea885dd] check-in: [147c61a6] user: drh branch: expr-simplify, size: 60287 | |
2018-09-18
| ||
21:35 | In the Expr object, the Expr.eX field determines what value is stored in the Expr.x union. This mostly works, but there are issues identified by valgrind. file: [15eeb0ea] check-in: [8849a463] user: drh branch: expr-simplify, size: 60251 | |
2018-09-06
| ||
18:56 | Fix a problem with ALTER TABLE when there are views or triggers in the schema that contain "<expr> IS NULL" expressions. file: [4118dbf9] check-in: [91aab32e] user: dan branch: trunk, size: 60499 | |
2018-08-29
| ||
21:00 | Extend RENAME TABLE to edit triggers and views. Still buggy. file: [b3ca0eba] check-in: [01308bae] user: dan branch: alter-table-rename-table, size: 60478 | |
2018-08-23
| ||
18:50 | The Expr.iColumn field must also be initialized in tokenExpr(). file: [adc9a1fb] check-in: [772985f1] user: drh branch: alter-table-rename-column, size: 60234 | |
18:22 | Make sure the Expr.iTable field is initialized by tokenExpr(). file: [766b6f1c] check-in: [02a05a3b] user: drh branch: alter-table-rename-column, size: 60212 | |
2018-08-21
| ||
16:32 | Rename internal function sqlite3RenameToken() to sqlite3RenameTokenMap() and sqlite3MoveRenameToken() to sqlite3RenameTokenRemap(). file: [0182e56e] check-in: [b9ae9a0a] user: dan branch: alter-table-rename-column, size: 60191 | |
08:29 | Minor changes to function tokenExpr() in order to claw back cycles lost to the rename-column change. file: [d13912c9] check-in: [47997695] user: dan branch: alter-table-rename-column, size: 60179 | |
2018-08-15
| ||
20:28 | Have ALTER TABLE RENAME COLUMN edit trigger programs. Only partly working. file: [57f53335] check-in: [e272dc2b] user: dan branch: edit-trigger-wrapper, size: 59947 | |
2018-08-13
| ||
17:14 | Edit the WHEN and UPDATE OF clauses of trigger programs as part of ALTER TABLE RENAME COLUMN. file: [1cdfb517] check-in: [5fdb6b0a] user: dan branch: edit-trigger-wrapper, size: 59959 | |
13:43 | Fix issues with ALTER TABLE RENAME COLUMN associated with OOM errors. file: [035b397b] check-in: [0b28dd5c] user: drh branch: alter-table-rename-column, size: 59967 | |
2018-08-10
| ||
14:23 | Fix a problem with renaming columns on tables with REFERENCES clauses that specify a large number of columns. file: [cec1d230] check-in: [d48f7bbd] user: dan branch: alter-table-rename-column, size: 59962 | |
2018-08-09
| ||
20:47 | Experimental implementation of ALTER TABLE ... RENAME COLUMN. Still buggy. file: [b981ac46] check-in: [fa0fc01e] user: dan branch: alter-table-rename-column, size: 59957 | |
2018-07-27
| ||
23:33 | Improvements to the parser to increase coverage. Fix the parser so that at least one expresssion is required after PARTITION BY and within the list of expressions on VALUES(). file: [704c9462] check-in: [02204f8b] user: drh branch: trunk, size: 59517 | |
22:14 | Minor grammar changes that help the parser run faster by reducing the number of NUL rule reductions. file: [a3020c88] check-in: [cfd1b005] user: drh branch: trunk, size: 59903 | |
2018-07-12
| ||
19:28 | Merge latest trunk changes into this branch. file: [70e577a1] check-in: [6a00a34e] user: dan branch: begin-concurrent, size: 59841 | |
2018-07-10
| ||
19:48 | Identify Select objects within a single statement using small sequential integers rather than "0x%p". This is more readable and yields the same result on successive runs. file: [3bd43415] check-in: [a7cdc5bc] user: drh branch: trunk, size: 59484 | |
15:45 | Merge latest trunk changes into this branch. file: [2578339a] check-in: [e9a3e864] user: dan branch: begin-concurrent, size: 60802 | |
2018-07-09
| ||
22:49 | Fixes for various harmless compiler warnings. file: [2eee45f4] check-in: [5023b1b8] user: drh branch: trunk, size: 60445 | |
16:24 | Simplification to the grammar rules for window functions. Fix a memory leak that can follow an OOM while parsing a comma-separated list of window definitions. file: [a7e0fb37] check-in: [a568f9c9] user: drh branch: trunk, size: 60439 | |
2018-07-06
| ||
13:48 | Prevent "UNBOUNDED FOLLOWING" from being used as the starting boundary of a window-frame. And "UNBOUNDED PRECEDING" from being used as the ending boundary. file: [5bd22618] check-in: [e51fdf66] user: dan branch: trunk, size: 60456 | |
07:42 | Return an error if DISTINCT is used with a window-function (e.g. "count(DISTINCT <expr>) OVER (...)"). file: [58ea7c7b] check-in: [d59bcc8e] user: dan branch: trunk, size: 60134 | |
2018-06-30
| ||
18:54 | Have the tokenizer handle fallback for tokens "OVER" and "FILTER" in the same way as it does for "WINDOW". file: [9b57f1d0] check-in: [12d819e1] user: dan branch: weak-fallback, size: 60134 | |
2018-06-29
| ||
20:43 | Further performance related tweaks for sqlite3RunParser(). file: [5a53ee98] check-in: [5eb47765] user: dan branch: weak-fallback, size: 60137 | |
17:44 | Instead of using a lemon %fallback directive, have the tokenizer try to figure out whether an instance of "WINDOW" should be TK_WINDOW or TK_ID. file: [216e0e95] check-in: [022079cb] user: dan branch: weak-fallback, size: 59767 | |
2018-06-28
| ||
20:05 | Modifications to parse.y to better support backwards compatibility for the "window" keyword. file: [9b5eb0e6] check-in: [7c4b879b] user: dan branch: weak-fallback, size: 59866 | |
03:38 | Introduce the concept of "weak fallback" in the parser. A weak fallback only occurs if a syntax error would result otherwise. file: [9517b50d] check-in: [c41d7079] user: drh branch: weak-fallback, size: 59778 | |
2018-06-22
| ||
20:51 | Omit all window-function related code when building with SQLITE_OMIT_WINDOWFUNC. file: [4661ac13] check-in: [5f04b016] user: dan branch: exp-window-functions, size: 59636 | |
2018-06-19
| ||
19:15 | Merge latest trunk changes with this branch. file: [4350d8b7] check-in: [6ad0e64b] user: dan branch: exp-window-functions, size: 59368 | |
11:15 | Minor change to the input grammar to make the parser tables slightly smaller. file: [4a86c88d] check-in: [320fa69e] user: drh branch: trunk, size: 56176 | |
2018-06-15
| ||
19:01 | Fix another problem in lead()/lag(). And some errors that could occur following OOM faults. file: [3b5e69c8] check-in: [fadd4dc1] user: dan branch: exp-window-functions, size: 59417 | |
2018-06-08
| ||
20:58 | Add support for the WINDOW clause. file: [788f41e7] check-in: [19c983b5] user: dan branch: exp-window-functions, size: 59355 | |
2018-06-06
| ||
17:03 | Merge changes from trunk, including all the 3.24.0 changes plus some later enhancements. file: [161e5d85] check-in: [d7299bfe] user: drh branch: begin-concurrent, size: 56582 | |
2018-06-04
| ||
08:28 | Merge latest trunk changes into this branch. file: [9eaa457c] check-in: [83d6416a] user: dan branch: exp-window-functions, size: 58193 | |
2018-05-30
| ||
01:14 | Fix the parser so that it builds with -DSQLITE_OMIT_CTE. file: [0b814724] check-in: [86ee267e] user: drh branch: trunk, size: 56225 | |
2018-05-19
| ||
14:15 | Fix minor problems on this branch. file: [9ae79a4f] check-in: [19c2e4b2] user: dan branch: exp-window-functions, size: 58140 | |
2018-05-16
| ||
20:58 | Start of experimental implementation of SQL window functions. Does not yet work. file: [5df899a4] check-in: [3781e520] user: dan branch: exp-window-functions, size: 58093 | |
2018-05-14
| ||
17:12 | Experimental syntax enhancement for an "INDEXED" keyword following a FROM-clause subquery that indicates that an automatic index on that subquery is suggested. file: [da3ecddd] check-in: [32b3d110] user: drh branch: exp-indexed-clause, size: 56343 | |
2018-04-24
| ||
19:21 | Merge latest trunk changes into this branch. file: [87ff3ca6] check-in: [b27bd799] user: dan branch: begin-concurrent, size: 56529 | |
2018-04-21
| ||
13:51 | Add the %extra_context directive to lemon, as an alternative to %extra_argument. Use this to improve the performance of the parser. file: [07784439] check-in: [be47a6f5] user: drh branch: trunk, size: 56172 | |
2018-04-19
| ||
11:45 | Fix the table name aliasing on INSERT so that it occurs before the column list rather than afterwards, just as it does for PostgreSQL. Add table name aliasing to UPDATE and DELETE. file: [1095d04a] check-in: [861a2e2a] user: drh branch: trunk, size: 56145 | |
2018-04-17
| ||
21:59 | Remove unreachable branches. 100% MC/DC in TH3 now. file: [54195765] check-in: [558865d5] user: drh branch: upsert, size: 55849 | |
2018-04-16
| ||
13:26 | Remove the MySQL upsert syntax. As an optional alias to the insert table name in order to finish out PostgreSQL upsert syntax emulation. file: [06555966] check-in: [810d9f63] user: drh branch: upsert, size: 55455 | |
13:00 | Add support for the "excluded.*" names in the UPDATE clause of an upsert. file: [22da8d03] check-in: [0203f34f] user: drh branch: upsert, size: 55383 | |
2018-04-13
| ||
13:06 | Back off of the extended upsert syntax that allows multiple ON CONFLICT clauses. The syntax now is exactly as in PostgreSQL and MySQL. Add support for WHERE clauses on the conflict-target phrase, for partial indexes. file: [5fde091c] check-in: [2c1b1987] user: drh branch: upsert, size: 55379 | |
01:15 | Begin adding upsert logic. This is an incremental check-in. file: [f6d42ac9] check-in: [80969643] user: drh branch: upsert, size: 55466 | |
2018-04-12
| ||
17:28 | Extend the upsert syntax to allow a WHERE clause on the UPDATE. file: [e2562b4d] check-in: [e4396c54] user: drh branch: upsert, size: 55465 | |
15:43 | Update the upsert parsing so that it accepts conflict-target labels using the PostgreSQL syntax, and also accepts the MySQL "ON DUPLICATE KEY" syntax. file: [0345f039] check-in: [c48f64d8] user: drh branch: upsert, size: 55417 | |
13:15 | Add the Upsert object for holding upsert clause information. file: [d12dad9b] check-in: [d83eaed5] user: drh branch: upsert, size: 54953 | |
12:25 | Merge changes from trunk. file: [306ece8a] check-in: [9f6f1180] user: drh branch: upsert, size: 56103 | |
2018-04-11
| ||
17:10 | Help the parser run faster by avoiding the "explain ::= ." production. file: [e3c4116e] check-in: [d7ec7b59] user: drh branch: trunk, size: 53900 | |
2018-04-09
| ||
20:36 | Minor changes to the input grammar resulting in a faster and slightly smaller parser. file: [22ca6e5b] check-in: [a2c443c0] user: drh branch: trunk, size: 53899 | |
2018-04-07
| ||
15:04 | More complete parsing of UPSERT, including UPSERT within a trigger. The sqlite3Insert() logic to actually perform the UPSERT is not yet implemented, however. file: [2779b5f1] check-in: [5cc2a5a3] user: drh branch: upsert, size: 55938 | |
2018-04-06
| ||
19:36 | Demonstration of how the parser can be augmented to recognize a PostgreSQL-style UPSERT. This check-in implements parsing only. file: [b6f92771] check-in: [9b22905b] user: drh branch: upsert, size: 54588 | |
2018-03-28
| ||
15:41 | Update this branch with latest trunk changes. file: [a3ab9037] check-in: [df52e89f] user: dan branch: server-process-edition, size: 53795 | |
2018-03-20
| ||
13:52 | Merge all recent enhancements from trunk. file: [5e4afc0c] check-in: [b0c2f760] user: drh branch: begin-concurrent, size: 54092 | |
2018-03-19
| ||
22:28 | Minor improvements to ".selecttrace". No changes to non-debug code. file: [140bbc53] check-in: [03e541f6] user: drh branch: trunk, size: 53735 | |
2018-03-16
| ||
19:10 | Fix a parsing issue associated with a corrupt sqlite_master table. file: [927e2875] check-in: [5f779ff6] user: mistachkin branch: corrupt-schema, size: 53896 | |
2018-03-02
| ||
17:40 | Merge latest trunk changes into this branch. file: [678b3afe] check-in: [36801eff] user: dan branch: begin-concurrent, size: 54115 | |
2018-02-28
| ||
04:30 | Fix a potential NULL pointer deref following OOM in the new IS TRUE logic. file: [3be4b2b5] check-in: [48775ec6] user: drh branch: trunk, size: 53758 | |
2018-02-27
| ||
14:49 | Clean up comments and variable names prior to merge. file: [97b31a67] check-in: [6445519e] user: drh branch: is-true-operator, size: 53739 | |
2018-02-26
| ||
21:26 | Code simplifications. New test cases. file: [b875c74b] check-in: [57508518] user: drh branch: is-true-operator, size: 53741 | |
20:15 | Get the "DEFAULT true" and "DEFAULT false" phrases working correctly in CREATE TABLE. file: [6319911f] check-in: [8002f87d] user: drh branch: is-true-operator, size: 53727 | |
2018-01-10
| ||
00:40 | Compute the correct column name even if the column identifier is the very last token in the SQL statement. This fixes a problem introduced by check-in [0fdf97efe5df745510c6b] and reported by the community during beta-testing. file: [4e750e1b] check-in: [36b89d72] user: drh branch: trunk, size: 53645 | |
2017-12-27
| ||
20:38 | Show the text of individual statements within a trigger, as they execute, as comments in the output from sqlite3_trace() and sqlite3_trace_v2(). file: [44cbbc3e] check-in: [fe3d2b97] user: drh branch: span-refactor, size: 53630 | |
2017-12-24
| ||
17:01 | Grammar changes: the sclp non-terminal should always be followed by a scanpt. file: [2b0653fd] check-in: [74a0181f] user: drh branch: span-refactor, size: 53584 | |
00:18 | Remove the ExprSpan object. Instead, keep track of the test of subphrases in the parse using the "scanpt" non-terminal. file: [1e29222b] check-in: [3eab7bdc] user: drh branch: span-refactor, size: 53577 | |
2017-11-14
| ||
23:48 | In the parse tree, combine LIMIT and OFFSET into a single expression rooted on a TK_LIMIT node, for a small code size reduction and performance increase, and a reduction in code complexity. file: [d79001da] check-in: [3925facd] user: drh branch: trunk, size: 56309 | |
20:06 | Merge changes from trunk. This fixes the SQLITE_ENABLE_UPDATE_DELETE_LIMIT functionality so that it works with views and WITHOUT ROWID tables. file: [839e0614] check-in: [d90e5f34] user: dan branch: begin-concurrent, size: 57062 | |
18:26 | Fix the SQLITE_ENABLE_UPDATE_DELETE_LIMIT functionality so that it works with views and WITHOUT ROWID tables. This is a modified cherrypick of [dae4a97a]. file: [69d085ed] check-in: [b2679d3b] user: dan branch: branch-3.8.9, size: 52866 | |
2017-11-10
| ||
20:13 | Omit some extra code from non-SQLITE_ENABLE_UPDATE_DELETE_LIMIT builds. file: [f5f02ef3] check-in: [72be33f9] user: dan branch: update-delete-limit-fix, size: 56732 | |
15:42 | Fix a problem with (DELETE...LIMIT) statements against WITHOUT ROWID tables with a single column PK. file: [49eb13a5] check-in: [35477a3d] user: dan branch: update-delete-limit-fix, size: 56730 | |
2017-11-09
| ||
19:53 | Add SQLITE_ENABLE_UPDATE_DELETE_LIMIT for views and WITHOUT ROWID tables. file: [5fbc16a4] check-in: [584b88aa] user: dan branch: update-delete-limit-fix, size: 56816 | |
2017-09-22
| ||
20:18 | Merge in all the trunk enhancements of the previous 7 months. The LIKE optimization has stopped working when there is an ESCAPE - that problem will be addressed in a subsequent check-in. file: [6fa01cad] check-in: [8d2a1cca] user: drh branch: est_count_pragma, size: 57304 | |
2017-08-11
| ||
19:16 | Merge the latest enhancements from trunk. file: [bcd8c5d9] check-in: [47e71695] user: drh branch: begin-concurrent, size: 57153 | |
2017-08-07
| ||
14:15 | Update this branch with latest trunk changes. file: [58a2de13] check-in: [17bc7ded] user: dan branch: server-process-edition, size: 56883 | |
2017-08-02
| ||
11:04 | Rearrange integer token values in the parser and logic in the resolveP2Values() routine for a small size reduction and performance increase. file: [52ef3cec] check-in: [1cad2926] user: drh branch: trunk, size: 56823 | |
2017-07-20
| ||
17:47 | Merge all the latest trunk enhancements. file: [e4dbcc61] check-in: [213c61cb] user: drh branch: begin-concurrent, size: 56423 | |
2017-07-19
| ||
18:54 | Merge latest trunk changes with this branch. file: [3a1babd6] check-in: [be0df0a6] user: dan branch: server-process-edition, size: 56153 | |
2017-07-12
| ||
17:26 | Remove unnecessary EP_Leaf settings on the Expr object. file: [e384cb73] check-in: [f951c8b7] user: drh branch: trunk, size: 56093 | |
17:08 | The EP_Resolved flag on the Expr object is not required for correctness nor performance, so remove it. file: [213fda2a] check-in: [54f55d3b] user: drh branch: trunk, size: 56198 | |
2017-07-08
| ||
20:46 | Support read-only MVCC transactions in server-mode. Started using "BEGIN READONLY". file: [f732ca9e] check-in: [5a043aa8] user: dan branch: server-process-edition, size: 56270 | |
2017-07-06
| ||
01:28 | Slightly more compact implementation of the byte-code generator for the COMMIT and ROLLBACK commands. file: [71bf06b0] check-in: [4da663d9] user: drh branch: trunk, size: 56210 | |
2017-06-28
| ||
14:26 | Minor tweak to the SQL grammar to make the parser tables a few bytes smaller. file: [b13c9fc8] check-in: [cc4810b2] user: drh branch: trunk, size: 56271 | |
2017-05-15
| ||
17:34 | Merge the latest changes from trunk. file: [21660e52] check-in: [14ea8400] user: drh branch: begin-concurrent, size: 56636 | |
2017-04-14
| ||
19:03 | Add the TK_IF_NULL_ROW opcode to deal with non-NULL result columns in the result set of a view or subquery on the RHS of a LEFT JOIN that gets flattened. file: [0513387c] check-in: [3a5860d8] user: drh branch: left-join-view, size: 56306 | |
2017-03-24
| ||
15:09 | Merge all recent enhancements from trunk. file: [f48aeacb] check-in: [fd5676fe] user: drh branch: begin-concurrent, size: 56627 | |
2017-03-07
| ||
03:25 | Small size reduction and performance increase in the name resolver routine for expressions. file: [48b03113] check-in: [1a3554e1] user: drh branch: trunk, size: 56306 | |
2017-02-20
| ||
14:30 | Small grammar simplification. file: [af883009] check-in: [0d8a868a] user: drh branch: trunk, size: 56294 | |
2017-02-17
| ||
16:26 | Add the "PRAGMA analyze_as_needed" command. file: [d5695ae4] check-in: [e93db237] user: drh branch: auto-analyze, size: 56329 | |
2017-02-16
| ||
14:02 | Merge recent enhancements from trunk. file: [26827d62] check-in: [325ccfa9] user: drh branch: est_count_pragma, size: 56804 | |
2017-01-28
| ||
20:46 | In the amalgamation, allocate the parser engine object from stack rather than from heap, for improved performance. This only happens in the amalgamation, since otherwise the sqlite3RunParser() routine does not know the object size. file: [591704fc] check-in: [4fe879d4] user: drh branch: trunk, size: 56323 | |
2017-01-09
| ||
06:33 | Upgrade this branch to 3.16 plus the various fixes that appeared after its release. file: [bb387a07] check-in: [d0e212d0] user: dan branch: begin-concurrent, size: 56129 | |
2016-12-12
| ||
12:58 | Merge recent enhancements from trunk. file: [5280d00e] check-in: [dc006e08] user: drh branch: est_count_pragma, size: 56289 | |
2016-12-06
| ||
22:47 | Performance improvement and size reduction in the Expr node allocator function sqlite3PExpr(). file: [29153738] check-in: [2a81763e] user: drh branch: trunk, size: 55808 | |
2016-10-20
| ||
18:20 | Add the ability for the PRAGMA statement to accept multiple arguments. Currently all arguments other than the first are ignored. file: [07f68096] check-in: [fd81d8a4] user: drh branch: multi-arg-pragma, size: 56278 | |
2016-10-03
| ||
15:28 | Avoid unnecessary strlen() calls in sqlite3ExprAssignVarNumber() by passing in the token length from the parser. file: [0338f906] check-in: [d15ae2e5] user: drh branch: trunk, size: 55797 | |
2016-09-26
| ||
12:38 | Inline the relevent parts of sqlite3ExprAlloc() into spanExpr(), for a performance improvement. file: [6ad22b8f] check-in: [fe89225e] user: drh branch: trunk, size: 55777 | |
2016-09-24
| ||
17:42 | Omit the LikeOp object from the parser. Change more sqlite3PExpr() calls into sqlite3ExprAlloc() calls. file: [b556d432] check-in: [795454a3] user: drh branch: trunk, size: 55221 | |
2016-09-23
| ||
21:36 | Add the EP_Leaf flag bit to the Expr.flags field to indicate Expr nodes that do not have substructure. Use that bit to avoid unnecessary recursion. file: [028b531b] check-in: [8a6ea455] user: drh branch: trunk, size: 55499 | |
20:59 | Use sqlite3ExprAlloc() instead of sqlite3PExpr() for leaf nodes in the expression tree, where appropriate. This is both smaller and faster. file: [2e0ac10d] check-in: [afac0709] user: drh branch: trunk, size: 55446 | |
2016-08-20
| ||
18:06 | Fixes for problems following OOM errors. file: [0e0b6d46] check-in: [9041ee4a] user: drh branch: rowvalue, size: 55441 | |
00:51 | Add support for vector assignments in the SET clause of an UPDATE statement. file: [9895eddb] check-in: [f320d47d] user: drh branch: rowvalue, size: 55360 | |
2016-08-19
| ||
15:41 | Merge recent enhancements from trunk. file: [3d02d64f] check-in: [b1787236] user: drh branch: rowvalue, size: 55133 | |
14:20 | Add the capability to VACUUM an attached database by specifying the schema name as an argument to the VACUUM command. Since version 2.0, VACUUM has accepted an argument which was silently ignored. Now it has meaning. file: [ed6990c2] check-in: [29d63059] user: drh branch: vacuum-attached-db, size: 54909 | |
2016-08-18
| ||
15:36 | Since the TK_VECTOR token is not actually used by the parser, make it an extra token code added by the tool/addopcodes.tcl script during parser build. file: [d240b151] check-in: [b40b202c] user: drh branch: rowvalue, size: 55128 | |
2016-08-11
| ||
19:12 | Merge version 3.14 plus some subsequent patches (including the page-cache performance patch) from trunk. file: [e87265f2] check-in: [d9f8918c] user: drh branch: begin-concurrent, size: 55225 | |
2016-07-26
| ||
18:15 | Merge latest trunk changes into this branch. file: [a7402dff] check-in: [d4f3d52c] user: dan branch: rowvalue, size: 55143 | |
2016-07-25
| ||
14:40 | Add a new %ifdef to parse.y so that the build works with SQLITE_OMIT_SUBQUERY. file: [99b676e6] check-in: [38a48cfb] user: drh branch: trunk, size: 54904 | |
2016-07-09
| ||
20:23 | Add some support for using row value constructors in certain parts of SQL expressions. There are many bugs on this branch. file: [fa040d74] check-in: [b2204215] user: dan branch: rowvalue, size: 55087 | |
2016-07-02
| ||
12:33 | Fix a problem in table-valued functions on the RHS of an IN operator that occurs following an OOM error. file: [f374ab20] check-in: [bead151e] user: drh branch: trunk, size: 54848 | |
12:08 | Add support for table-valued functions on the RHS of an IN operator. file: [3660ab75] check-in: [ac6000f0] user: drh branch: trunk, size: 54833 | |
2016-06-29
| ||
06:19 | Add the ability to have a table-valued function on the RHS of an IN operator. file: [300a3038] check-in: [ba1b441b] user: drh branch: prototype-int-array, size: 54918 | |
2016-05-31
| ||
21:18 | An experimental branch with code that allows virtual tables to be declared as WITHOUT ROWID tables. This might be useful for virtual tables that model external data sources that do not have a convenient way of computing a unique rowid. The current check-in almost works, but there are still serious issues. file: [01b9f37c] check-in: [49638f18] user: drh branch: without-rowid-vtab, size: 54484 | |
2016-04-20
| ||
12:16 | Merge all recent enhancements from trunk. file: [2e1d371f] check-in: [1f709fbf] user: drh branch: begin-concurrent, size: 54662 | |
2016-04-11
| ||
13:36 | Remove the VdbeOp.opflags field and its associated initialization overhead. Update mkopcodeh.tcl to reorder opcode numbers to help the resolveP2Values() routine run faster. file: [10eb2f3f] check-in: [099478fa] user: drh branch: trunk, size: 54341 | |
01:43 | Back off of the parser optimization in the previous check-in, slightly, to preserve some backwards compatibility regarding some undocumented behavior in the '#AAA' style query parameter. file: [52cdeb4f] check-in: [ef1966c2] user: drh branch: trunk, size: 54340 | |
01:26 | Small size reduction and performance improvement in the parser. file: [55670f9b] check-in: [16df7128] user: drh branch: trunk, size: 54311 | |
01:06 | Factor out the common operation of setting the Expr.x.pSelect field of an Expr object into a subroutine. file: [b6fcbc84] check-in: [6a5cceee] user: drh branch: trunk, size: 54323 | |
2016-03-17
| ||
18:41 | An alternative method of encoding the wildcard in "SELECT *". This is an experiment. file: [fc4d11e4] check-in: [41335d88] user: drh branch: select-wildcard, size: 54961 | |
2016-03-16
| ||
19:34 | Merge the latest enhancements from trunk. file: [a74adac1] check-in: [a7978ab6] user: drh branch: begin-concurrent, size: 55265 | |
2016-02-29
| ||
13:37 | Further simplifications to the grammar. file: [5ea8c81c] check-in: [519fd03b] user: drh branch: schema-storage, size: 54966 | |
2016-02-27
| ||
23:25 | Update the parser so that it pulls out the column name and type all in one go, rather than using separate reductions. file: [3a29fc29] check-in: [ad3ffe2e] user: drh branch: schema-storage, size: 55212 | |
2016-02-17
| ||
12:34 | More agressive use of /*A-overwrites-X*/ in the parser. Fix an off-by-one error in parser stack overflow detection. file: [c3ce2c4a] check-in: [417e7777] user: drh branch: parser-performance, size: 55249 | |
04:33 | Enhance Lemon so that if reduce code contains a comment of the form "/*A-overwrites-X*/" then a LHS label A is allowed to overwrite the RHS label X. file: [8c2f7e7e] check-in: [5cfe9545] user: drh branch: parser-performance, size: 55023 | |
01:46 | Further improvements to the Lemon-generated code for yy_reduce(). file: [b845cfc4] check-in: [ef95a7d6] user: drh branch: parser-performance, size: 54724 | |
01:18 | In Lemon, add the ability for the left-most RHS label to be the same as the LHS label, causing the LHS values to be written directly into the stack. file: [eb7d241c] check-in: [4bb94c7c] user: drh branch: parser-performance, size: 54736 | |
2016-02-16
| ||
21:19 | Experimental changes to Lemon for improved parser performance. file: [36a367a6] check-in: [a65d583c] user: drh branch: parser-performance, size: 55461 | |
2016-02-05
| ||
14:34 | Merge PRAGMA synchronous=EXTRA and OOM performance enhancements from trunk. file: [2d29daf0] check-in: [332c8036] user: drh branch: begin-concurrent, size: 55864 | |
01:55 | Improvements to the way that OOM errors are processed. file: [d7bff41d] check-in: [c3ef0347] user: drh branch: oom-handling, size: 55528 | |
2016-02-02
| ||
02:53 | Merge recent enhancements from trunk. file: [e6a091ae] check-in: [347f6a80] user: drh branch: begin-concurrent, size: 55660 | |
2016-01-28
| ||
18:22 | Modify the order of terms in an "if" condition to avoid implicitly comparing a dangling pointer to NULL following an OOM error. file: [426a91fb] check-in: [5372f800] user: dan branch: trunk, size: 55324 | |
2016-01-14
| ||
15:46 | Merge the latest enhancements and fixes from trunk. file: [2a2b07ab] check-in: [fccc5f20] user: dan branch: begin-concurrent, size: 55660 | |
2016-01-07
| ||
17:09 | Small performance and size optimization spotted while working on the shared-cache problem. file: [caad1e98] check-in: [828958ff] user: drh branch: trunk, size: 55324 | |
2015-11-20
| ||
13:49 | Merge all the latest enhancements and fixes from trunk. file: [b0ad0241] check-in: [41c8b8e3] user: drh branch: begin-concurrent, size: 55722 | |
2015-11-19
| ||
16:33 | Create the new TK_ASTERISK token to represent the "*" in "SELECT *". Formerly that operator was TK_ALL, which was also used for UNION ALL. Less confusion if they operator symbols are distinct. file: [23737e64] check-in: [201ac6d4] user: drh branch: trunk, size: 55386 | |
2015-11-12
| ||
15:04 | Fix a #define in parse.y that disabled unused code in the generated parser. file: [aad5cc86] check-in: [f84e3085] user: drh branch: trunk, size: 55371 | |
2015-11-10
| ||
13:45 | Save a few bytes in the parser by using "int" instead of "u8" or "u16" for all small integer types. file: [8a364a7a] check-in: [5dcd212b] user: drh branch: trunk, size: 55369 | |
00:02 | Remove an unused non-terminal from the grammar. file: [56cd095d] check-in: [3c37c522] user: drh branch: parser-enhancements, size: 55370 | |
2015-11-09
| ||
19:33 | Change the parser to use the standard "lempar.c" template over in the tool/ folder rather than the customized "lempar.c" found in src/. file: [89784cfb] check-in: [0a72991f] user: drh branch: parser-enhancements, size: 55390 | |
2015-10-30
| ||
17:17 | Merge the sqlite3_db_cacheflush() enhancements and other changes from trunk. file: [764d5b40] check-in: [f2cde4cf] user: drh branch: begin-concurrent, size: 55446 | |
2015-10-28
| ||
16:05 | Factor out adding NOT expression nodes in the parser into a subroutine. file: [11078cd8] check-in: [00185418] user: drh branch: trunk, size: 55110 | |
2015-09-07
| ||
18:23 | For the Lemon-generated parser, add a new action type SHIFTREDUCE and use it to further compress the parser tables and improve parser performance. file: [9e1777c6] check-in: [531c3974] user: drh branch: lemon-update, size: 55060 | |
2015-09-04
| ||
16:39 | Remove the EXCLUSIVE and CONCURRENT tokens from the tokenizer. Let the BEGIN statement be followed by an ID, but throw a syntax error if the ID is anything other than EXCLUSIVE or CONCURRENT. file: [0dcce0ae] check-in: [c0bf92ec] user: drh branch: begin-concurrent, size: 55404 | |
2015-08-25
| ||
11:16 | Merge latest trunk changes with this branch. file: [1e645cac] check-in: [3e7d6dd6] user: dan branch: begin-concurrent, size: 55111 | |
2015-08-24
| ||
20:21 | Enhances the parser so that it accepts arbitrary expressions for the arguments of an index, though the code generator still rejects everything other than simple column names. The sqlite3RestrictColumnListSyntax() routine is removed since that feature is now handled by the parser. file: [f599aa5e] check-in: [bed42116] user: drh branch: trunk, size: 55068 | |
19:56 | Change "BEGIN UNLOCKED" to "BEGIN CONCURRENT". file: [dc3dda4b] check-in: [ba1ab858] user: dan branch: begin-concurrent, size: 53751 | |
17:42 | Enhance the CREATE VIEW syntax so that the names of columns of the view can be specified after the view name. file: [07f2084f] check-in: [d794b34d] user: drh branch: trunk, size: 53667 | |
15:39 | Disallow the use of COLLATE clauses and the ASC and DESC keywords within foreign key constraints and in the argument list to common table expressions. file: [b5e0a5f8] check-in: [83cbc4d8] user: drh branch: trunk, size: 53667 | |
2015-08-21
| ||
16:22 | Merge trunk changes with this branch. file: [e9accdb2] check-in: [deaf3b18] user: dan branch: begin-concurrent, size: 53749 | |
2015-08-19
| ||
17:11 | A list of arguments following a table name translates into equality constraints against hidden columns in that table. file: [ad9af855] check-in: [40e12cfe] user: drh branch: table-valued-functions, size: 53708 | |
15:20 | Minor refactor of the SrcList object so that it is able to hold the argument list to a table-valued-function in the FROM clause. file: [2ed6efe3] check-in: [b9193761] user: drh branch: table-valued-functions, size: 53491 | |
2015-07-27
| ||
19:31 | Add an experimental "BEGIN UNLOCKED" command. file: [199145cd] check-in: [80794216] user: dan branch: begin-concurrent, size: 53529 | |
2015-06-13
| ||
11:48 | Add the IS DISTINCT FROM and IS NOT DISTINCT FROM operators. file: [d3388f70] check-in: [0be44782] user: drh branch: is-distinct-from, size: 53876 | |
2015-05-29
| ||
01:35 | Using "SELECT ALL" instead of just "SELECT" on a query that uses a single unflattenable subquery or view in its FROM clause will force the subquery to be manifested into a temporary table rather than run incrementally using a co-routine. This is a stop-gap means of controlling the decision to manifest while we try to work out a better to make that decision automatically. file: [6d60dda8] check-in: [a29e117d] user: drh branch: trunk, size: 53488 | |
2015-05-27
| ||
13:06 | CTEs have never had working rowids. So disallow the use of the "rowid" column within CTEs. file: [44e16058] check-in: [0055df04] user: drh branch: no-rowid-in-cte, size: 53470 | |
2015-05-20
| ||
19:34 | Fix a problem causing collation sequence names to be dequoted multiple times under some circumstances. Cherrypick of [eddc05e7bb31]. file: [ce1a34cd] check-in: [fc1a4f29] user: dan branch: branch-3.8.6, size: 51925 | |
00:15 | Fix handling of queries with VALUES on the left and UNION ALL SELECT on the right and a LIMIT clause. file: [af55d4fb] check-in: [c403502c] user: drh branch: trunk, size: 53450 | |
2015-04-16
| ||
23:04 | Restrict the scope of a local-use function in the parser. file: [c4e0387b] check-in: [cd6598f4] user: drh branch: trunk, size: 53367 | |
20:27 | Fix a couple of unreachable branches. file: [5944031b] check-in: [8f391dff] user: drh branch: trunk, size: 53360 | |
14:13 | Improvements to the way VALUES clauses are parsed. file: [b5c16bc5] check-in: [ec5a493a] user: drh branch: trunk, size: 53352 | |
2015-03-20
| ||
08:43 | Fix a problem causing collation sequence names to be dequoted multiple times under some circumstances. file: [1299c66e] check-in: [eddc05e7] user: dan branch: trunk, size: 52957 | |
2015-02-09
| ||
16:09 | Propagate the COLLATE operator upward through function calls. Initial fix for ticket [ca0d20b6cdddec5e8]. file: [0f8e7d60] check-in: [c053448a] user: drh branch: tkt-2f7170d7, size: 52948 | |
15:21 | Disable the query flattener for aggregate subqueries if the parent query uses other subqueries in its result set or WHERE clause or ORDER BY clause. Preliminary fix for ticket [2f7170d73bf9abf8]. However it still contains a defect similar to the COLLATE problem of [ca0d20b6cddd]. file: [d6507371] check-in: [0b7d65e3] user: drh branch: tkt-2f7170d7, size: 52900 | |
2015-01-05
| ||
19:16 | Handle compound-select statements originating from VALUES clauses as a special case that does not use recursion. file: [c5d0d964] check-in: [9ce9e43a] user: drh branch: many-VALUEs, size: 52852 | |
16:27 | Towards getting INSERT statements to except many VALUE terms (more than the limit imposed by SQLITE_LIMIT_COMPOUND_SELECT). This check-in segfaults on a stack overflow. And it is slow. file: [075cad65] check-in: [c9d65f73] user: drh branch: many-VALUEs, size: 52745 | |
2014-10-02
| ||
21:52 | Avoid a NULL pointer deference when processing the IS operator if the right-hand side is an illegal "#ID" style variable. Fix for ticket [8c32a33a53092c85a15b] file: [5dfead8a] check-in: [ffe75736] user: drh branch: trunk, size: 52705 | |
2014-09-30
| ||
12:33 | Remove the SQLITE_ENABLE_TREE_EXPLAIN compile-time option. Add alternative debugging display routines: sqlite3TreeViewExpr(), sqlite3TreeViewExprList(), and sqlite3TreeViewSelect(). file: [ce149430] check-in: [4ff51325] user: drh branch: trunk, size: 52716 | |
2014-09-21
| ||
00:27 | Improved ".selecttrace" output. file: [b98772da] check-in: [c0b61f70] user: drh branch: select-trace, size: 52835 | |
2014-09-20
| ||
18:18 | Enable SELECT query planning tracing when compiled with SQLITE_ENABLE_SELECTTRACE and either SQLITE_DEBUG or SQLITE_TEST. file: [1976d28f] check-in: [cbe0cf9d] user: drh branch: select-trace, size: 52841 | |
2014-05-06
| ||
15:28 | Experimental changes that reduce the size of Expr objects from 72 to 64 bytes each on x64 and from 48 to 44 bytes each on x32. file: [b9adfa13] check-in: [8ad0a123] user: drh branch: smaller-expr, size: 52085 | |
2014-03-20
| ||
19:04 | Remove a testcase() that is now always true due to the "x IN (?)" optimization. Add an ALWAYS() around a conditional in the parser that cannot be false. file: [22d6a074] check-in: [d5a1530b] user: drh branch: trunk, size: 51916 | |
17:03 | The "x IN (?)" optimization in check-ins [2ff3b25f40] and [e68b427afb] is incorrect, as demonstrated by the in4-5.1 test case in this check-in. The "COLLATE binary" that was being added to the RHS of IN was overriding the implicit collating sequence of the LHS. This change defines the EP_Generic expression node property that blocks all affinity or collating sequence information in the expression subtree and adds that property to the expression taken from RHS of the IN operator. file: [fb3280d8] check-in: [2ea4a9f7] user: drh branch: trunk, size: 51760 | |
15:14 | Fix harmless compiler warnings. file: [d2107545] check-in: [b1435f26] user: drh branch: trunk, size: 51473 | |
14:56 | Previous check-in is not quite correct. "x IN (?)" is not exactly the same as "x==?" do to collation and affinity issues. The correct converstion should be to "x==(+? COLLATE binary)". The current check-in fixes this problem and provides test cases. Ticket [e39d032577df69] file: [c9189eca] check-in: [2ff3b25f] user: drh branch: trunk, size: 51524 | |
13:26 | Convert expressions of the form "X IN (?)" with exactly one value on the RHS of the IN into equality tests: "X=?". Add test cases to verify that statements work correctly on this corner case. Fix for ticket [e39d032577df6942]. file: [52d749e7] check-in: [e68b427a] user: drh branch: trunk, size: 51333 | |
2014-02-19
| ||
01:31 | Make sure a multi-row VALUES clause works correctly in a compound SELECT. file: [2613ca5d] check-in: [85b355cf] user: drh branch: trunk, size: 50879 | |
2014-02-09
| ||
18:02 | Use the WITH clause to help resolve names for SELECT statements on the left of a compound query. Proposed fix for ticket [31a19d11b97088296a]. file: [cce844cc] check-in: [67bfd59d] user: drh branch: trunk, size: 50640 | |
2014-01-22
| ||
18:31 | Fix harmless compiler warnings. file: [bd51bc17] check-in: [dea2ca6a] user: drh branch: trunk, size: 50210 | |
2014-01-17
| ||
14:59 | Fix some problems to do with WITH clauses and name resolution. file: [475896cb] check-in: [6a549187] user: dan branch: common-table-expr, size: 50207 | |
2014-01-15
| ||
14:17 | Disable the flattening optimization if the sub-query is a recursive CTE. file: [824eeb75] check-in: [9472f6d8] user: dan branch: common-table-expr, size: 50187 | |
2014-01-13
| ||
16:36 | Fix some memory leaks and crashes that could follow an OOM condition during WITH clause parsing. file: [e5c4a23f] check-in: [8839850c] user: dan branch: common-table-expr, size: 50154 | |
15:12 | Add code to handle non-recursive CTEs in the same way as SQL views. file: [b433588d] check-in: [a26f399b] user: dan branch: common-table-expr, size: 50091 | |
2014-01-11
| ||
19:19 | Update the parser so that sub-queries and CTEs may have WITH clauses. file: [1e3fd22f] check-in: [704d3931] user: dan branch: common-table-expr, size: 49867 | |
13:22 | Parse common table expressions. But do not do anything with them (yet). file: [0ccd364d] check-in: [da98b720] user: drh branch: common-table-expr, size: 49563 | |
03:54 | Optimizations to the SQL language grammar that result in a small size reduction and speed increase. file: [3c538453] check-in: [cb5d1f83] user: drh branch: trunk, size: 49197 | |
2014-01-10
| ||
20:51 | Remove unused structure definition from parse.y. file: [60baa3ac] check-in: [7f1e7ae3] user: drh branch: trunk, size: 49253 | |
20:46 | Allow a VALUES clause to be used any place that a SELECT statement can be used. file: [0a284e3f] check-in: [c9ea7d19] user: drh branch: trunk, size: 49349 | |
2014-01-06
| ||
18:32 | Start a new experimental branch for support of Oracle-style CONNECT BY syntax. file: [201902e2] check-in: [4365ddd6] user: drh branch: connect-by, size: 51591 | |
2013-11-21
| ||
14:44 | Remove the obsolete TK_CONST_FUNC token type. file: [acee1a99] check-in: [9b4217f0] user: drh branch: trunk, size: 50674 | |
2013-10-21
| ||
23:55 | Minor refactoring of the PRIMARY KEY parsing logic to facilitate enhancements. file: [eb49c2c7] check-in: [4e69dd5f] user: drh branch: omit-rowid, size: 50702 | |
02:14 | Simplification of the syntax: Merely append "WITHOUT rowid" to the end of the table definition. file: [073a8294] check-in: [131cc6e1] user: drh branch: omit-rowid, size: 50850 | |
2013-10-19
| ||
23:31 | Experimental changes toward "index only" tables. Add the ability to specify options on CREATE TABLE statements using the WITH clause modeled after PostgreSQL and SQL Server. Only the "omit_rowid" option is currently recognized and that option is currently a no-op. file: [909868a9] check-in: [0248ec5e] user: drh branch: omit-rowid, size: 50719 | |
2013-09-12
| ||
16:50 | Increase the number of bits available in Expr.flags. Other tweaks aimed at making expression processing more robust. file: [a97566d6] check-in: [579a5125] user: drh branch: expr-tuning, size: 50581 | |
2013-08-05
| ||
22:05 | Performance optimization: Avoid calling convertCompoundSelecctToSubquery() on queries that do not use the UNION, EXCEPT, or INTERSECT operators. file: [27c6b413] check-in: [c589b2fe] user: drh branch: trunk, size: 50503 | |
2013-08-01
| ||
03:36 | Test cases and bug fixes for the partial index logic. file: [599bc633] check-in: [6b73ae7c] user: drh branch: partial-indices, size: 50458 | |
2013-07-31
| ||
18:12 | Here begins an experimental branch for exploring the idea of a partial index. This check-in is able to parse a WHERE clause on a CREATE INDEX statement, but does not actually do anythingn with that WHERE clause yet. file: [a950b48d] check-in: [6794b2dc] user: drh branch: partial-indices, size: 50521 | |
2013-05-28
| ||
12:11 | Many small harmless comment changes. Removal of obsolete comments and fixing misspelled words. No changes to code. file: [9acfcc83] check-in: [a0d5cc93] user: drh branch: trunk, size: 50449 | |
2013-04-30
| ||
14:06 | Make sure extra parentheses around subqueries in the FROM clause are harmless. Ticket [28c6e830f239ea5]. file: [97083655] check-in: [1c795692] user: drh branch: trunk, size: 50448 | |
2012-12-18
| ||
19:36 | Optimize the degenerate case of a FROM clause table name enclosed all by itself inside parentheses. Generate code as if the parentheses did not exist, rather than the old behavior of manifesting the parenthesized table into a transient table. Also, tag every FROM-clause SELECT subquery that is generated by a parenthesized FROM-clause expression using the SF_NestedFrom flag. The new SF_NestedFrom flag is not yet used for anything. file: [5d5e1277] check-in: [7fecced4] user: drh branch: trunk, size: 50382 | |
13:12 | Remove old commented-out code from parse.y. Fix some over-length source lines in parse.y. No logical changes. file: [15fdc2c9] check-in: [7e30c021] user: drh branch: trunk, size: 49986 | |
2012-12-07
| ||
18:38 | Some errors in veryquick resolved. Many more to go. file: [c2b4a645] check-in: [972443b4] user: drh branch: ticket-71e333e7, size: 50452 | |
2012-10-16
| ||
21:08 | An optimization that converts "a IN (b)" into "a==b". Seems to work, but needs additional test cases. file: [bf81c919] check-in: [8b4c3c5e] user: drh branch: degenerate_IN, size: 51049 | |
2012-07-18
| ||
16:07 | Remove another branch from the DbMalloc() paths. file: [6548920e] check-in: [defd828e] user: dan branch: calloc, size: 50586 | |
2012-05-12
| ||
18:29 | Parser bug fix: Make sure the table constraints allowed by prior releases can still be parsed, even if they are technically not allowed by the syntax diagram. file: [f29df90b] check-in: [e536ac04] user: drh branch: trunk, size: 50598 | |
2012-05-08
| ||
11:17 | Further changes to constraint parsing to support legacy syntax. file: [de06f412] check-in: [38bf90af] user: drh branch: trunk, size: 50623 | |
2012-05-07
| ||
19:21 | Adjust the parser so that certain legacy schema constructs (that are not valid according to the syntax diagram) continue to be accepted, so that older databases that happen to use those constructs are still readable. This fixes an issue introduced by check-in [1b75f301affac6] file: [ad29af00] check-in: [a1c014d8] user: drh branch: trunk, size: 50588 | |
2012-03-30
| ||
15:48 | When a named CHECK constraint fails, include the name of the constraint in the error message. file: [eb054bb4] check-in: [1b75f301] user: drh branch: trunk, size: 50492 | |
12:10 | Change the name of a local variable from "not" to "bNot" to lessen the chances of it colliding with some prior #define in the appliation. file: [537c8db1] check-in: [cbdd8638] user: drh branch: trunk, size: 50551 | |
2012-03-07
| ||
19:13 | If a CHECK constraint is named, report that name on the error message when the constraint fails. file: [180976f4] check-in: [9a0f90d9] user: drh branch: named-check-constraints, size: 50643 | |
2012-02-10
| ||
17:38 | Disable the ability to have multiple values in the VALUES clause of an INSERT statement when SQLITE_OMIT_COMPOUND_SELECT is used. file: [1ddd71ae] check-in: [92131195] user: drh branch: trunk, size: 50544 | |
2012-01-28
| ||
19:44 | Remove a couple of unnecessary nonterminals from the grammar. file: [f36fb379] check-in: [2b2a7d8d] user: drh branch: trunk, size: 50331 | |
19:41 | Add support for IF NOT EXISTS on CREATE VIRTUAL TABLE. file: [fcda1cc4] check-in: [230983e8] user: drh branch: trunk, size: 50437 | |
15:22 | Add support for multiple rows of VALUES in an INSERT statement. file: [203ea330] check-in: [eb3b6a0c] user: drh branch: trunk, size: 50403 | |
2011-12-06
| ||
19:44 | Begin adding the data-structure explaining subsystem. All is contained within file: [fabb2e70] check-in: [79ae51c5] user: drh branch: tree-explain, size: 49315 | |
2011-11-29
| ||
15:40 | Remove unused fields from the Parse object. Documentation and formatting improvements on data structure definitions. file: [d02cc7bd] check-in: [431556ca] user: drh branch: trunk, size: 49196 | |
2010-08-17
| ||
23:13 | Cherrypick the changes for enhancement requests [e090183531fc27474] (use indices on LIKE with no wildcards) and [4711020446da7d93d993] (use nocase index for LIKE even if the column is binary) into the 3.6.23.1 release of the Apple-OSX branch. file: [07fdc757] check-in: [220cca50] user: drh branch: apple-osx-3623, size: 48658 | |
2010-07-22
| ||
17:49 | Enhance the LIKE/GLOB query optimization so that it works as long as there is an index with the appropriate collating sequence and even if the default collating sequence of the column is different. Ticket [4711020446da7d93d99]. file: [12b7ebd6] check-in: [9f932655] user: drh branch: trunk, size: 49248 | |
2010-07-19
| ||
02:30 | Fix a parser bug that was causing the relative precedence of LIKE and < operators to be incorrect. file: [220a11ac] check-in: [3e5975aa] user: drh branch: trunk, size: 49227 | |
2010-07-15
| ||
11:14 | Change a comment inside a block of code in parse.y from C++ to C style. file: [06a61a57] check-in: [dea7d33b] user: dan branch: trunk, size: 49038 | |
2010-07-14
| ||
18:24 | Make the result of an IN or NOT IN expression with an empty set on the right-hand side always either false or true, respectively, even if the left-hand side is NULL. Ticket [80e031a00f45dc] file: [3d7f529e] check-in: [c288ac64] user: drh branch: trunk, size: 49038 | |
2009-12-09
| ||
21:43 | Restore the incorrect legacy ON INSERT syntax to the parser as a no-op. That way, older databases that actually use this meaningless syntax will still be readable. file: [ace5c7a1] check-in: [54b955c3] user: drh branch: trunk, size: 48637 | |
2009-12-03
| ||
04:40 | Fix a couple of compiler warnings under MSVC. file: [b172fba9] check-in: [e3aa0870] user: shaneh branch: trunk, size: 48560 | |
2009-11-12
| ||
03:46 | Suppress excess OP_Null opcodes caused by binary IS or IS NOT operators that are converted into unary ISNULL or NOTNULL operators. file: [f785d814] check-in: [cff1b36a] user: drh branch: trunk, size: 48556 | |
2009-11-10
| ||
01:30 | Remove the obsolete "$Id:$" RCS identifier strings from the source code. file: [0a36c62c] check-in: [f6c045f6] user: drh branch: trunk, size: 48241 | |
2009-10-21
| ||
13:48 | Add evidence marks to parse.y. Fix a broken evidence link in e_fkey.tcl. file: [0204f0df] check-in: [0441d28e] user: drh branch: trunk, size: 48305 | |
2009-09-23
| ||
08:43 | Add missing comments to fkey.c. Also, change the terminology used for comments and names in fkey.c from "referenced/referencing" to "parent/child". This is arguably less correct, but is easier to follow. file: [2b75a329] check-in: [540c2d18] user: dan branch: trunk, size: 48167 | |
02:29 | Generalize the IS and IS NOT operators so that their right-hand side can be an arbitrary expression and not simple the constant NULL. They work like = and <> except that NULL values compare equal to one another an unequal to everything else. file: [563ecc9e] check-in: [98853f61] user: drh branch: trunk, size: 48167 | |
2009-09-22
| ||
20:08 | Factor the UMINUS and UPLUS tokens out of the parser so that the parser tables can go back to using 8-bit values instead of 16-bit values. file: [749f39fa] check-in: [3fc938c9] user: drh branch: trunk, size: 47832 | |
2009-09-21
| ||
16:06 | Fix compilation with OMIT_TRIGGER defined. Ticket [1ff6d29030]. file: [030c85b2] check-in: [fb6ceed3] user: dan branch: trunk, size: 47848 | |
2009-09-19
| ||
17:00 | Check in implementation of foreign key constraints. file: [e2a89b59] check-in: [d5d39981] user: dan branch: trunk, size: 47844 | |
2009-08-10
| ||
03:57 | Removed some warnings from the MSVC compile. (CVS 6965) file: [6c42631e] check-in: [ee034cfc] user: shane branch: trunk, size: 47861 | |
2009-07-03
| ||
15:37 | Make explicit the restrictions on UPDATE, DELETE, and INSERT statement syntax within triggers. Ticket #3947. (CVS 6840) file: [bcd46d43] check-in: [c8bf40df] user: drh branch: trunk, size: 47857 | |
2009-07-01
| ||
14:56 | Do not ignore alias "a" in a query of the form "SELECT ... FROM (...) AS a" Fix for #3935. Also expand upon (6751) to fix some similar obscure memory leaks. (CVS 6831) file: [c48ce202] check-in: [42f9d1e5] user: danielk1977 branch: trunk, size: 46882 | |
2009-06-19
| ||
14:06 | Reorganize and cleanup the prepared statement object. Remove code that has been commented out for ages and is no longer relevant to anything. (CVS 6786) file: [b6e99f42] check-in: [37ae5f5e] user: drh branch: trunk, size: 46930 | |
2009-06-12
| ||
13:53 | The lemon parser generator now inserts yytestcase() macros on reduce action and on each destructor, to verify that all have been executed. yytestcase() is a no-op by default but can be set to something more useful inside of %include. (CVS 6755) file: [bab89225] check-in: [fe9c9177] user: drh branch: trunk, size: 46983 | |
12:04 | Enable the SQLITE_LIMIT_FUNCTION_ARG limiter. (CVS 6753) file: [d4bade53] check-in: [a17e3317] user: drh branch: trunk, size: 46898 | |
03:47 | An additional memory leak in the parser fixed. Ticket #3911. (CVS 6751) file: [90bcb72d] check-in: [6197b492] user: drh branch: trunk, size: 46876 | |
02:27 | Modifications to the parser to eliminate unreachable code. (CVS 6749) file: [5d6ab030] check-in: [457e0b24] user: drh branch: trunk, size: 46820 | |
2009-05-28
| ||
01:00 | Additional refinements to Expr handling. Restore compression of trigger expressions. Change Expr.zToken to Expr.u.zToken and added Expr.u.iValue. Remove an unnecessary ExprDup from CHECK constraint processing. And so forth. (CVS 6682) file: [07690df9] check-in: [4ac2bdfb] user: drh branch: trunk, size: 46690 | |
2009-05-27
| ||
10:31 | Simplifications to the Expr object: Remove Expr.span completely and convert Expr.token into a char* Expr.zToken. Also simplify the Token object by removing the Token.dyn and Token.quoted fields. (CVS 6681) file: [6b55e52f] check-in: [7cb1c3ba] user: drh branch: trunk, size: 46690 | |
2009-05-11
| ||
18:22 | Enhance the parser to allow nested parentheses in the module argument of a CREATE VIRTUAL TABLE statement. (CVS 6625) file: [ba2fa210] check-in: [93772bd7] user: drh branch: trunk, size: 43057 | |
2009-05-01
| ||
21:13 | Record within the Token structure itself whether or not the token has been dequoted. This steals one bit from the length of a token and thus limits the size of tokens to 1GiB. (CVS 6589) file: [a0e8b8e5] check-in: [12bcb03d] user: drh branch: trunk, size: 43068 | |
2009-04-06
| ||
14:16 | Allow "default" to be a keyword used by PRAGMA statements. (CVS 6454) file: [b7e4341b] check-in: [ed99d2d9] user: drh branch: trunk, size: 43039 | |
2009-04-03
| ||
01:43 | Fix the PRAGMA parser so that it can accept negative numbers in parentheses, like the syntax diagrams say it should be able to. (CVS 6444) file: [070215cf] check-in: [286e8317] user: drh branch: trunk, size: 42992 | |
2009-03-24
| ||
15:08 | Changes to insure that lookaside memory allocations are never used to hold schema content. Ticket #3743. (CVS 6377) file: [b9ba0946] check-in: [ea74d8dc] user: drh branch: trunk, size: 42881 | |
2009-03-22
| ||
20:36 | Allow the keyword INDEXED to be used as the name of a table or index or column - for backwards compatibility. (CVS 6370) file: [30ae25cd] check-in: [53149c9f] user: drh branch: trunk, size: 42754 | |
2009-03-05
| ||
03:48 | Removed compiler warnings from MSVC builds. Ticket #3701. (CVS 6335) file: [c315b6f9] check-in: [5477833e] user: shane branch: trunk, size: 42722 | |
2009-02-19
| ||
14:39 | Changes to reduce the heap space consumed by triggers, views and tables in the in-memory representation of the schema. Also to reduce the space used by prepared statements slightly. (CVS 6305) file: [5202dc71] check-in: [d9f6ffbc] user: danielk1977 branch: trunk, size: 42722 | |
2009-01-29
| ||
19:27 | Add test cases to make sure that keywords that we say can be used as identifiers really can be used as identifiers. These tests were inspired by ticket #3612, but they do not directly address ticket #3612. (CVS 6214) file: [4f4d16ae] check-in: [6041ca87] user: drh branch: trunk, size: 42538 | |
2009-01-16
| ||
11:04 | Allow recently added keywords 'savepoint' and 'release' to be used as database object names. Just as they could be prior to 3.6.8. Ticket #3590. (CVS 6186) file: [b214295a] check-in: [54ab8326] user: danielk1977 branch: trunk, size: 42525 | |
2008-12-17
| ||
17:30 | Add the savepoint feature. This feature is largely untested at this point. (CVS 6036) file: [4d0e33a7] check-in: [34b56600] user: danielk1977 branch: trunk, size: 42507 | |
2008-12-10
| ||
18:03 | More explicit type casting to silence VC++. (CVS 6006) file: [3dfd9415] check-in: [14e6d19c] user: drh branch: trunk, size: 42172 | |
2008-12-08
| ||
16:01 | Fix two unused-parameter warnings in the parser. (CVS 5990) file: [1f4b7ad6] check-in: [cf419d0b] user: drh branch: trunk, size: 42119 | |
2008-12-03
| ||
23:23 | Allow the entire FROM clause of a SELECT statement to be in parentheses. (CVS 5973) file: [72397fe3] check-in: [72ebc8cb] user: drh branch: trunk, size: 41985 | |
2008-10-23
| ||
05:45 | Fix a bug in pragma table_info. Column default values specified as negative numbers (col DEFAULT -1) were being reported as NULL by the pragma. (CVS 5839) file: [2c4758b4] check-in: [0e448bc6] user: danielk1977 branch: trunk, size: 41612 | |
2008-10-11
| ||
17:35 | Fix to sqlite3DbMallocRaw() when SQLITE_OMIT_LOOKASIDE is defined so that once it fails it continues to fail. Add a comment explaining why this is important. (CVS 5804) file: [f4620f42] check-in: [63dd8be7] user: drh branch: trunk, size: 41567 | |
17:06 | Fix a OOM segfault in the BETWEEN operator parsing - discovered while using SQLITE_OMIT_LOOKASIDE. Add SQLITE_OMIT_LOOKASIDE to test_config.c and bypass lookaside.test when defined. (CVS 5803) file: [e73dc413] check-in: [2a21d52c] user: drh branch: trunk, size: 41608 | |
2008-10-10
| ||
18:25 | Further simplifications of the code for the LIMIT clause on an UPDATE or DELETE. Added a few test cases to wherelimit.test. (CVS 5797) file: [e8620c7e] check-in: [282c6a46] user: shane branch: trunk, size: 41569 | |
17:47 | Change 'pragma foreign_key_list' to return some extra information. (CVS 5795) file: [8862ab33] check-in: [3bb33cf5] user: danielk1977 branch: trunk, size: 41822 | |
14:27 | Simplify the parser reduction code for the LIMIT clause on an UPDATE or DELETE. (CVS 5792) file: [72fc66fd] check-in: [3de17963] user: drh branch: trunk, size: 41813 | |
04:34 | Updated LIMIT support for DELETE/UPDATE. Omit option changed to SQLITE_ENABLE_UPDATE_DELETE_LIMIT. (CVS 5788) file: [ecabcd64] check-in: [c10e8a3c] user: shane branch: trunk, size: 41992 | |
2008-10-07
| ||
05:27 | Initial support for LIMIT clause on DELETEs and UPDATEs. Changes likely with more testing. The code can be omitted with the define SQLITE_OMIT_UPDATE_DELETE_LIMIT. (CVS 5774) file: [85d57c1d] check-in: [9c8b132e] user: shane branch: trunk, size: 41984 | |
2008-10-06
| ||
16:18 | Allow INDEXED BY and NOT INDEXED to be used in UPDATE and DELETE statements. (CVS 5772) file: [d8edf095] check-in: [83a7e446] user: danielk1977 branch: trunk, size: 40816 | |
05:32 | Allow INDEXED BY and NOT INDEXED clauses in SELECT statements. (CVS 5766) file: [c69312df] check-in: [98ca5580] user: danielk1977 branch: trunk, size: 40666 | |
2008-08-20
| ||
16:35 | Refactor the name resolution procedures in the code generator. (CVS 5569) file: [d0f76d2c] check-in: [daf730d1] user: drh branch: trunk, size: 39949 | |
2008-08-11
| ||
14:26 | Disallow empty triggers. Ticket #3283. This does not present a backwards compatibility problem because prior to this change, an empty trigger would segfault. (CVS 5550) file: [84003422] check-in: [571adab9] user: drh branch: trunk, size: 39960 | |
2008-08-08
| ||
15:06 | Back out part of (5546): Even though ON CONFLICT clauses on CHECK constraints are no-ops, if a schema includes them, the database will be unreadable if we do not at least parse and ignore the clause. (CVS 5548) file: [95d377a7] check-in: [efcaeb68] user: drh branch: trunk, size: 39841 | |
14:19 | Disallow the ON CONFLICT clause on CHECK constraints. The syntax used to be allowed but never worked, so this should not present compatibility problems. Other internal grammar simplifications. (CVS 5546) file: [3bd91b93] check-in: [4cedc641] user: drh branch: trunk, size: 39834 | |
2008-07-31
| ||
01:40 | Omit calls to sqlite3Pragma() if SQLITE_OMIT_PARSER defined. Not technically needed, as the entire generated parse.c file should not be included. (CVS 5506) file: [d962e544] check-in: [10e04508] user: shane branch: trunk, size: 39919 | |
2008-07-28
| ||
19:34 | Implement the "lookaside" memory allocation cache. Use of this cache makes the speed1.test script run about 15% faster. Added new interfaces to control the cache. (CVS 5488) file: [5ce0b04d] check-in: [e48f9697] user: drh branch: trunk, size: 39864 | |
2008-07-18
| ||
17:03 | Make sure expression spans are set correctly for "x.*" expressions in the result set of a SELECT. Ticket #3229. (CVS 5438) file: [d1316f1b] check-in: [17a9984e] user: drh branch: trunk, size: 39288 | |
2008-07-08
| ||
23:40 | Remove obsolete code from select.c, including the "affinity" parameter to the sqlite3Select() module. (CVS 5380) file: [097bff73] check-in: [cbd3c158] user: drh branch: trunk, size: 39284 | |
2008-06-05
| ||
16:47 | Reorganize some of the code that detects expression trees with a depth greater than EXPR_MAX_DEPTH so that they are detected earlier. This further reduces the opportunities for stack overflow. (CVS 5189) file: [8c2c3145] check-in: [16d4c53a] user: danielk1977 branch: trunk, size: 39295 | |
2008-04-17
| ||
20:59 | Continuing progress on the journal_mode pragma. It still does not work. (CVS 5027) file: [fc4bd35c] check-in: [4a72a7bb] user: drh branch: trunk, size: 39239 | |
2008-03-29
| ||
12:50 | add two missing initializer values (CVS 4937) file: [bc1b1cc6] check-in: [bf28f1c2] user: rse branch: trunk, size: 39154 | |
2008-03-20
| ||
16:30 | Reinstate test cases for the limit tests. The sqlite3_limit() API is now tested and working. (CVS 4899) file: [b0ee84d9] check-in: [4c4be4c3] user: drh branch: trunk, size: 39148 | |
2008-01-22
| ||
23:37 | Improved test coverage for the tokenizer and sqlite3_complete() interface. Fix bugs in parsing blob literals and SQL variables beginning with $. (CVS 4743) file: [00f2698c] check-in: [c82033fa] user: drh branch: trunk, size: 39204 | |
14:50 | Remove dead code from the lemon-generated parser. Better testing of the sqlite3_file_control() interface, and in particular make sure the interface works on :memory: databases. (CVS 4738) file: [bcc6092d] check-in: [83ca4fc7] user: drh branch: trunk, size: 39243 | |
01:48 | Changes to lemon to generate additional comments in the output file and to remove unreachable code. Additional test cases for improved test coverage. (CVS 4736) file: [0a0878dd] check-in: [2a0bc1e1] user: drh branch: trunk, size: 39272 | |
2008-01-02
| ||
16:27 | Combine the eDest and iParm arguments to sqlite3Select() into a single type - "SelectDest". (CVS 4657) file: [2ae06e8d] check-in: [86dcdfe6] user: danielk1977 branch: trunk, size: 39282 | |
2007-11-17
| ||
22:23 | Fix a bug in the grammar. We were giving the ones-complement operator ~ the same precedence as the NOT operator, which is incorrect. (CVS 4548) file: [a780b33e] check-in: [b48a4bfd] user: drh branch: trunk, size: 39242 | |
2007-11-12
| ||
09:50 | Allow collation sequence names to be quoted. Ticket #2744. (CVS 4537) file: [9640f5b9] check-in: [06749ac7] user: danielk1977 branch: trunk, size: 39151 | |
2007-08-21
| ||
10:44 | Remove unnecessary #includes of "os.h". New mutex implementations. (CVS 4255) file: [2d2ce439] check-in: [fbbd5bda] user: drh branch: trunk, size: 39215 | |
2007-08-16
| ||
10:09 | More work on refactoring of malloc() interfaces. There are still many errors. (CVS 4233) file: [c03529c3] check-in: [77b16713] user: danielk1977 branch: trunk, size: 39242 | |
04:30 | Half-way through a major refactoring of the memory allocation. I have not even attempted to compile so I am certain there are countless errors. (CVS 4231) file: [4934dc7e] check-in: [deb7ecd6] user: drh branch: trunk, size: 39225 | |
2007-06-20
| ||
12:18 | Disallow empty GROUP BY clauses. Ticket #2431. (CVS 4099) file: [ad2ce256] check-in: [9581e7a4] user: drh branch: trunk, size: 38394 | |
2007-06-15
| ||
17:03 | Fix a memory leak in the parser that can occur following a malloc failure. (CVS 4071) file: [2ed1d91f] check-in: [d0b6e9a0] user: drh branch: trunk, size: 38411 | |
2007-05-30
| ||
10:36 | Add some extra tests for malloc failure during expression parsing and execution using fuzzily generated SQL. (CVS 4043) file: [e3d8e3f7] check-in: [7522d2fb] user: danielk1977 branch: trunk, size: 38382 | |
2007-05-15
| ||
16:51 | Make sure pParse->rc gets set whenever sqlite3ErrorMsg() is called. This is added insurance that parsing will stop quickly after an error. This change did make the parser stop faster in some cases, which required some revisions to tests. (CVS 4010) file: [e276a0c3] check-in: [f84d9dab] user: drh branch: trunk, size: 38369 | |
00:09 | Make sure the parser aborts quickly following a syntax error. (CVS 3996) file: [5d4d60e7] check-in: [d07cdd3c] user: drh branch: trunk, size: 38400 | |
2007-05-11
| ||
01:44 | Additional parsing bugs fixed. (CVS 3981) file: [8451c5b0] check-in: [d12a8924] user: drh branch: trunk, size: 38369 | |
2007-05-10
| ||
10:46 | Add code to enforce the MAX_EXPR_DEPTH limit. (CVS 3968) file: [39b25cc7] check-in: [2c9c94a2] user: danielk1977 branch: trunk, size: 38437 | |
2007-05-08
| ||
17:54 | Add a few more tests to sqllimit1.test. (CVS 3954) file: [fe7efcbf] check-in: [eeee6b71] user: danielk1977 branch: trunk, size: 38253 | |
13:58 | Add more code to enforce the limits specified in limits.h. (CVS 3946) file: [efbca804] check-in: [c59d4360] user: drh branch: trunk, size: 38036 | |
2007-05-04
| ||
18:30 | Change incremental vacuum to be triggered by a pragma rather than a command. We have a lot to learn about this yet and we do not want to paint ourselves into a corner by commiting to specific syntax too early. (CVS 3921) file: [a5bdc301] check-in: [b13e497a] user: drh branch: trunk, size: 37860 | |
16:14 | Optional parameter in the INCREMENTAL VACUUM statement specifies how many pages to vacuum from the database. (CVS 3919) file: [502cec81] check-in: [ed713f9c] user: drh branch: trunk, size: 38059 | |
14:14 | Make "incremental" a fallback token so that you can set "auto_vacuum=incremental" without having to quote the "incremental". (CVS 3917) file: [c4ee802a] check-in: [9d7a2e2b] user: drh branch: trunk, size: 37972 | |
2007-04-26
| ||
14:42 | Add largely untested code for the incremental vacuum function. (CVS 3876) file: [a3940369] check-in: [f6a6d2b8] user: danielk1977 branch: trunk, size: 37968 | |
2007-04-06
| ||
15:02 | Binary file I/O infrastructure added and used to increase test coverage for detection of corrupt database files. (CVS 3822) file: [b6cfbadb] check-in: [479b3d96] user: drh branch: trunk, size: 37860 | |
11:26 | The FOR EACH STATEMENT clause in a trigger is now a syntax error. It used to be silently ignored. STATEMENT is no longer a keyword. (CVS 3821) file: [6112045e] check-in: [8e2559b4] user: drh branch: trunk, size: 37425 | |
2007-03-27
| ||
14:44 | The -DSQLITE_OMIT_ATTACH=1 option now omits both the ATTACH and VACUUM commands. Ticket #2268. The regression test suite depends on both of these commands and will not run if compiled with this option. (CVS 3727) file: [207ab042] check-in: [cbebfb89] user: drh branch: trunk, size: 37683 | |
2007-02-02
| ||
12:44 | Minor tweaks to collating sequences. We'll hold of making major changes until 3.4.0, since we'll likely end up with some minor technical imcompatibilities. (CVS 3626) file: [bcfe366c] check-in: [9740aa95] user: drh branch: trunk, size: 37656 | |
2007-02-01
| ||
23:02 | First cut at adding the COLLATE operator. Regression tests pass (or at least the quick set does) and a few new tests have been added. But many more tests are needed. Rules for combining collations need to be worked out. (CVS 3624) file: [ebf4253e] check-in: [85cca7cd] user: drh branch: trunk, size: 37648 | |
2007-01-27
| ||
02:38 | Parser changes to allow parenthesized numerical arguments to pragmas, in support of the integrity_check enhancement of check-in (3609) and ticket #2176. (CVS 3610) file: [31ea08df] check-in: [ab6322bf] user: drh branch: trunk, size: 37600 | |
2006-12-20
| ||
02:15 | Allow constraint names on DEFAULT values in a table definition. Ticket #2109. (CVS 3535) file: [2f571c5f] check-in: [893d58c2] user: drh branch: trunk, size: 37581 | |
2006-12-16
| ||
16:25 | Query optimizer enhancement: In "FROM a,b,c left join d" allow the C table to be reordered with A and B. This used to be the case but the capability was removed by (3203) and (3052) in response to ticket #1652. This change restores the capability. (CVS 3529) file: [9b3d1c0f] check-in: [7393c81b] user: drh branch: trunk, size: 37576 | |
2006-09-21
| ||
11:02 | Be more aggressive with the SQLITE_OMIT_VACUUM macro. Saves about 150 bytes of code space. (CVS 3432) file: [8c79a1de] check-in: [7e618db4] user: drh branch: trunk, size: 38045 | |
2006-09-11
| ||
23:45 | Add support for IF EXISTS on CREATE/DROP TRIGGER/VIEW. Ticket #1899. (CVS 3406) file: [3279443a] check-in: [e4fe736c] user: drh branch: trunk, size: 37870 | |
2006-08-25
| ||
23:42 | Add support for INSERT INTO ... DEFAULT VALUES. Tickets #299, #1940. (CVS 3368) file: [b26898e5] check-in: [bc84cb54] user: drh branch: trunk, size: 37803 | |
2006-08-14
| ||
14:23 | Change the table_info pragma to show the text of the default value expression, not the result of evaluating the default value expression. Ticket #1919. (CVS 3353) file: [ec897a96] check-in: [b4d53974] user: drh branch: trunk, size: 37678 | |
2006-07-11
| ||
10:42 | Fix a possible NULL-pointer deference following a malloc failure. Error discovered by Klocwork. (CVS 3327) file: [ecac6660] check-in: [368bcf26] user: drh branch: trunk, size: 37651 | |
2006-07-08
| ||
18:35 | For infix functions (LIKE, GLOB, REGEXP, and MATCH) treat the left operand as the first argument for the purposes of virtual table function overloading, even though the left operand is really the the second argument. (CVS 3324) file: [438e0f94] check-in: [6e98373c] user: drh branch: trunk, size: 37630 | |
2006-06-16
| ||
08:01 | Add some tests (and fixes) for virtual tables and the authorization callback. Still more to come. (CVS 3260) file: [e0831a26] check-in: [9497c66e] user: danielk1977 branch: trunk, size: 37602 | |
2006-06-13
| ||
15:37 | Add support for the MATCH operator. (CVS 3231) file: [14ce6fb2] check-in: [815b84d5] user: drh branch: trunk, size: 37592 | |
2006-06-11
| ||
23:41 | Progress toward CREATE VIRTUAL TABLE. Still not even close to working... (CVS 3211) file: [05cd1419] check-in: [898ec36b] user: drh branch: trunk, size: 37466 | |
2006-06-10
| ||
13:29 | Basic parsing of CREATE VIRTUAL TABLE statements. (CVS 3210) file: [79c32462] check-in: [66370cb9] user: drh branch: trunk, size: 36957 | |
2006-05-25
| ||
12:17 | Syntax errors override errors from the code generator, not the other way around. (CVS 3192) file: [50ab45ec] check-in: [5031ffc6] user: drh branch: trunk, size: 36582 | |
2006-03-13
| ||
12:54 | Additional changes due to Coverity scans. (CVS 3130) file: [ee1887ce] check-in: [a69f697d] user: drh branch: trunk, size: 36527 | |
2006-02-27
| ||
22:22 | The parser now permits very large triggers - triggers with 10000 or more statements. (CVS 3113) file: [c2daaa24] check-in: [b4fa96d0] user: drh branch: trunk, size: 36474 | |
21:58 | Detect stack overflow in the parser and report an error. (CVS 3112) file: [969fa5dd] check-in: [bd2c38f4] user: drh branch: trunk, size: 36414 | |
2006-02-24
| ||
02:53 | Remove unused parameters on internal APIs. Suppress warnings from CodeWarrior. (CVS 3110) file: [52b8cdcc] check-in: [4b22e4b8] user: drh branch: trunk, size: 36342 | |
2006-02-10
| ||
02:27 | Add the column_origin_name() etc. APIs. (CVS 3069) file: [6d666d60] check-in: [82f502cd] user: danielk1977 branch: trunk, size: 36360 | |
2006-01-30
| ||
23:04 | Remove support for the non-standard ON CONFLICT clause on CREATE INDEX. Ticket #1486. The ON CONFLICT clause has never worked on CREATE INDEX so removing it should not break anything. (CVS 3042) file: [ce7182bf] check-in: [669bcf5a] user: drh branch: trunk, size: 36351 | |
2006-01-23
| ||
13:22 | Do not name variables "operator" because some compilers do not realize that "operator" is not a reserved word in ANSI-C. Ticket #1625. (CVS 2997) file: [4285cd2d] check-in: [1f42a338] user: drh branch: trunk, size: 36422 | |
2006-01-07
| ||
14:02 | Fix some memory leaks caused by obscure syntax errors in SQL. (CVS 2882) file: [83df51fe] check-in: [6593199a] user: danielk1977 branch: trunk, size: 36426 | |
2006-01-04
| ||
15:54 | Add support for CREATE INDEX IF NOT EXISTS and DROP INDEX IF EXISTS. (CVS 2855) file: [58258759] check-in: [551cdd6c] user: drh branch: trunk, size: 36183 | |
2005-12-29
| ||
23:33 | Add support for CREATE TABLE IF NOT EXISTS. (CVS 2847) file: [fea607bd] check-in: [0bd9e35f] user: drh branch: trunk, size: 36150 | |
01:11 | Add support for DROP TABLE IF EXISTS. (CVS 2843) file: [13343510] check-in: [a4c547de] user: drh branch: trunk, size: 36023 | |
2005-12-16
| ||
01:06 | Initial infrastructure for recognizing DESC indices and being able to read and write older databases that specify DESC indices but do not really use them. Nothing is close to working yet. (CVS 2822) file: [142a4b34] check-in: [cd110aa2] user: drh branch: trunk, size: 35893 | |
2005-12-09
| ||
20:02 | Clean up annoying (and pointless) compiler warnings about differing signedness. (CVS 2810) file: [d0b1f9a4] check-in: [83a59151] user: drh branch: trunk, size: 35759 | |
2005-12-06
| ||
17:19 | Modify ATTACH and DETACH to execute at runtime instead of compile time. (CVS 2803) file: [87080d89] check-in: [5e04ec69] user: danielk1977 branch: trunk, size: 35732 | |
2005-11-24
| ||
22:22 | Reduce the number of distinct token symbols in the parser so that the parser can store tokens in a single byte and thus be smaller in size. (CVS 2776) file: [e4d57c2f] check-in: [2dfc9863] user: drh branch: trunk, size: 35826 | |
2005-11-14
| ||
22:29 | Create separate affinities for INTEGER and REAL. (CVS 2766) file: [9399852d] check-in: [ce06c123] user: drh branch: trunk, size: 36252 | |
2005-11-06
| ||
04:06 | About 0.5KiB of additional compression in the parser tables. (CVS 2764) file: [6322f4b2] check-in: [f39974eb] user: drh branch: trunk, size: 36126 | |
2005-11-03
| ||
02:03 | Disallow subqueries in CHECK constraints. (CVS 2756) file: [1d5afb97] check-in: [db27afc4] user: drh branch: trunk, size: 37286 | |
00:41 | First cut at supporting CHECK constraints. Everything appears to work, but much more testing is needed as well as documentation. (CVS 2754) file: [416bc5ed] check-in: [2313d912] user: drh branch: trunk, size: 37239 | |
2005-09-16
| ||
02:38 | Fix a whole host of newly discovered memory leaks the occur after a failure of realloc(). (CVS 2696) file: [5602d5cb] check-in: [4686d649] user: drh branch: trunk, size: 37224 | |
2005-09-11
| ||
11:56 | COUNT(DISTINCT x) is now fully functional, though it could benefit from additional testing. (CVS 2688) file: [3bceaece] check-in: [2f397bd8] user: drh branch: trunk, size: 37027 | |
2005-09-10
| ||
16:46 | Add the experimental EXPLAIN QUERY PLAN diagnostic capability. (CVS 2685) file: [c97d885c] check-in: [986efb7b] user: drh branch: trunk, size: 37131 | |
2005-09-09
| ||
01:33 | Infrastructure for the DISTINCT keyword in aggregate functions. But it does not work yet. If you try to use it you get an error message. (CVS 2680) file: [13c3d16e] check-in: [4d62e36f] user: drh branch: trunk, size: 37042 | |
2005-09-07
| ||
21:22 | Rewrite the aggregate handling logic so that it runs in O(1) space. This is the first cut at the code. Many regression tests fail. (CVS 2662) file: [4c0cf6b0] check-in: [17039ec3] user: drh branch: trunk, size: 36882 | |
2005-07-08
| ||
12:13 | Add infrastructure for the ANALYZE command. Does not yet actually do anything. (CVS 2537) file: [d57cdd2a] check-in: [05b6ac9a] user: drh branch: trunk, size: 36871 | |
2005-06-30
| ||
17:04 | Allow the DEFAULT value of a column to be obtained by calling a function that has constant arguments, such as julianday('now'). (CVS 2534) file: [6caf6855] check-in: [d273766e] user: drh branch: trunk, size: 36617 | |
2005-06-25
| ||
18:42 | Remove the blob(), text() and numeric() functions added in (2524) and replace them with the standard CAST operator. Ticket #1287. (CVS 2527) file: [562246a7] check-in: [17631785] user: drh branch: trunk, size: 36544 | |
2005-05-23
| ||
17:26 | The REGEXP operator is recognized. It tries to invoke a function named regexp() which does not exist in the native build. But users who want to can add an appropriate regexp() function using sqlite3_create_function(). (CVS 2478) file: [72cd7553] check-in: [42a626ac] user: drh branch: trunk, size: 35443 | |
2005-04-22
| ||
02:38 | Remove some vestigal code. Add the experimental sqlite3_transfer_bindings() API. (CVS 2446) file: [3e314b3a] check-in: [88b39436] user: drh branch: trunk, size: 35556 | |
2005-03-29
| ||
03:10 | Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) file: [1770b867] check-in: [c41d5544] user: danielk1977 branch: trunk, size: 35564 | |
2005-03-17
| ||
05:03 | Add the ALTER TABLE ... ADD COLUMN command. (CVS 2393) file: [10c0ace9] check-in: [94185dd4] user: danielk1977 branch: trunk, size: 35530 | |
2005-03-16
| ||
12:15 | Fix some memory leaks that can occur if a memory allocation fails. (CVS 2388) file: [5c8336e7] check-in: [9a358fc3] user: danielk1977 branch: trunk, size: 35112 | |
2005-03-09
| ||
12:26 | Support for a future ALTER TABLE command to add columns with default values. (CVS 2367) file: [0b613526] check-in: [9d5abc1d] user: danielk1977 branch: trunk, size: 34945 | |
2005-02-14
| ||
06:38 | Tighten up the CREATE INDEX syntax accepted by the parser. (CVS 2329) file: [450fc9c4] check-in: [41d2214b] user: danielk1977 branch: trunk, size: 34945 | |
2005-02-05
| ||
12:48 | Allow expressions (including variables) in LIMIT and OFFSET clauses. Ticket #1096. (CVS 2316) file: [ee046c1e] check-in: [515e5033] user: danielk1977 branch: trunk, size: 34926 | |
2005-02-04
| ||
04:07 | Remove code for SQL cursors. (CVS 2312) file: [7a4965d6] check-in: [2eb90870] user: danielk1977 branch: trunk, size: 34809 | |
2005-01-29
| ||
08:32 | Modify sub-query handling. Tickets #1083 and #1084. (CVS 2286) file: [959948ee] check-in: [b1b50f31] user: danielk1977 branch: trunk, size: 36270 | |
2005-01-21
| ||
03:12 | Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) file: [5f2c197f] check-in: [bb0254ab] user: danielk1977 branch: trunk, size: 36273 | |
2005-01-20
| ||
13:36 | Added the SQLITE_OMIT_SUBQUERY compile-time option and the EXISTS operator. Regression tests are currently failing with an assertion fault. (CVS 2245) file: [301d07db] check-in: [d30fdf0f] user: drh branch: trunk, size: 36247 | |
02:14 | Turn SQLITE_OMIT_CURSOR on by default. (CVS 2240) file: [276efb30] check-in: [2d3ab1ab] user: drh branch: trunk, size: 35869 | |
2005-01-19
| ||
23:24 | Continued refactoring of the name resolution logic and query optimizer. (CVS 2236) file: [a1084470] check-in: [d8b2a7e0] user: drh branch: trunk, size: 35865 | |
2004-11-22
| ||
19:12 | Add initial infrastructure for cursors. In where.c, optimize out clauses of the form "ORDER BY rowid" if a table scan is being performed. Do a reverse table scan if "ORDER BY rowid DESC" is present. (CVS 2141) file: [ceba179b] check-in: [fc8c1393] user: drh branch: trunk, size: 35862 | |
2004-11-17
| ||
16:41 | Add the ESCAPE clause to the LIKE operator. Not fully tested yet. (CVS 2107) file: [0a4bdfd7] check-in: [49268c2b] user: danielk1977 branch: trunk, size: 34413 | |
2004-11-13
| ||
15:59 | More compile-time options for removing components. (CVS 2098) file: [3282026b] check-in: [dcbc0c22] user: drh branch: trunk, size: 34199 | |
03:48 | Autoincrement is now working and has regression tests. (CVS 2095) file: [7978be17] check-in: [10c712a2] user: drh branch: trunk, size: 34143 | |
2004-11-12
| ||
13:42 | Add the "ALTER TABLE xxx RENAME TO yyy" command. (CVS 2092) file: [b64ebeb9] check-in: [a1b2cc63] user: danielk1977 branch: trunk, size: 34611 | |
03:56 | Autoincrement code installed. Simple smoke-testing only. No regression tests developed yet. (CVS 2091) file: [91a01b5f] check-in: [8fde833c] user: drh branch: trunk, size: 34391 | |
2004-11-09
| ||
16:13 | Have "DEFAULT CURRENT_TIME" & co. work even if SQLITE_OMIT_DATETIME_FUNCS is defined. (CVS 2083) file: [02e0d88a] check-in: [f81b9c1c] user: danielk1977 branch: trunk, size: 33946 | |
12:44 | Port the "DEFAULT CURRENT_TIME" etc. functionality from an earlier fork of sqlite. (CVS 2082) file: [0af8d009] check-in: [0d27c8ff] user: danielk1977 branch: trunk, size: 33946 | |
2004-11-05
| ||
23:46 | First cut at a REINDEX command. Basic testing only. No documentation. (CVS 2072) file: [84567268] check-in: [11dba47e] user: drh branch: trunk, size: 33486 | |
05:10 | More use of sqlite3NestedParse. This version of the code does not work. (CVS 2060) file: [97247c0a] check-in: [ac2d5a60] user: drh branch: trunk, size: 33240 | |
00:43 | Incremental check-in of changes that will ultimately lead to a working autoincrement. (CVS 2056) file: [e7f4e87a] check-in: [10c3d883] user: drh branch: trunk, size: 33172 | |
2004-11-03
| ||
13:59 | More work on optionally removing unused features at compile-time. (CVS 2049) file: [4a274506] check-in: [a82980fd] user: drh branch: trunk, size: 32987 | |
03:59 | The makefile now runs mkkeywordhash.c. Keywords that are unused are omitted from the keyword hash table. (CVS 2045) file: [625750bf] check-in: [007aec11] user: drh branch: trunk, size: 32987 | |
2004-10-31
| ||
02:22 | Insert #ifdefs that can optionally remove features at compiletime resulting in a database engine with a smaller footprint. (CVS 2034) file: [08f4971f] check-in: [be661acf] user: drh branch: trunk, size: 32932 | |
2004-10-07
| ||
03:06 | Additional parser optimizations. (CVS 2010) file: [8d97a91c] check-in: [618dee12] user: drh branch: trunk, size: 32581 | |
2004-10-06
| ||
14:39 | Size optimization in the parser. (CVS 2004) file: [329d1bca] check-in: [8e2ae244] user: drh branch: trunk, size: 33384 | |
2004-10-05
| ||
02:41 | Add support for DEFERRED, IMMEDIATE, and EXCLUSIVE transactions. (CVS 2000) file: [e03d7d7f] check-in: [81ff8107] user: drh branch: trunk, size: 33745 | |
2004-10-04
| ||
13:38 | More changes to take advantage of the TK_ and OP_ alignments to avoid unnecessary translations. (CVS 1999) file: [3616bdde] check-in: [e8e972ba] user: drh branch: trunk, size: 33524 | |
13:19 | Save about 800 bytes of code space by aligning TK_ and OP_ constants so that we do not have to translate between them. (CVS 1998) file: [eb4920f6] check-in: [4c817e3f] user: drh branch: trunk, size: 33524 | |
2004-09-30
| ||
14:22 | Correctly parser column typenames that contain more than one identifier. Ticket #934. (CVS 1990) file: [96823135] check-in: [85ad1871] user: drh branch: trunk, size: 33215 | |
2004-09-25
| ||
15:29 | Remove unused CLUSTER keyword from the parser. (CVS 1986) file: [52ca09ee] check-in: [54ee1664] user: drh branch: trunk, size: 33225 | |
13:12 | Code simplifications and size reductions. (CVS 1983) file: [93edda0f] check-in: [cb631a13] user: drh branch: trunk, size: 33233 | |
2004-09-07
| ||
16:19 | Wildcards with the same name map into the same variable number. New api sqlite3_bind_parameter_index() added to map wildcard names into wildcard index numbers. Support for "?nnn" wildcards. (CVS 1945) file: [9389af67] check-in: [435b3f30] user: drh branch: trunk, size: 33233 | |
2004-08-25
| ||
04:07 | Host parameter names conform to SQL-2003. (CVS 1902) file: [581a2ce0] check-in: [fd584d1c] user: drh branch: trunk, size: 33243 | |
2004-08-20
| ||
16:02 | Add support for named wildcards in SQL statements. (CVS 1897) file: [8b4cab19] check-in: [d3be0b7c] user: drh branch: trunk, size: 33387 | |
2004-08-19
| ||
15:12 | Enhance lemon so that a @X instead of just X in the code expands to the major token value rather than the minor token value. Use this to make the parser a few hundred bytes smaller. (CVS 1895) file: [7b71425a] check-in: [28215096] user: drh branch: trunk, size: 33186 | |
2004-08-01
| ||
00:10 | Add the ".import" command to the command-line shell. (CVS 1873) file: [589b1a39] check-in: [b56afe64] user: drh branch: trunk, size: 33210 | |
2004-07-22
| ||
15:02 | Fix bugs associated with the codec. (CVS 1846) file: [0bcc53bb] check-in: [b0a3becd] user: drh branch: trunk, size: 33241 | |
2004-07-20
| ||
14:06 | Lemon collapses common destructors and reduce actions into a single case. (CVS 1837) file: [1c22ccb2] check-in: [3c5aa850] user: drh branch: trunk, size: 32980 | |
2004-06-30
| ||
09:49 | Coverage tests for vacuum.c (CVS 1776) file: [51c8e696] check-in: [152e9940] user: danielk1977 branch: trunk, size: 32991 | |
2004-06-26
| ||
06:37 | Remove default_synchronous and temp_store pragmas. Allow the safety-level and cache-size to be set for attached databases. (CVS 1735) file: [e19e066e] check-in: [212de3ce] user: danielk1977 branch: trunk, size: 32983 | |
2004-06-09
| ||
09:55 | Some progress on user-defined collation sequences. (CVS 1544) file: [09743867] check-in: [c634e71f] user: danielk1977 branch: trunk, size: 32962 | |
00:48 | Start all transactions and verify all schema cookies near the beginning of of each vdbe program. (CVS 1543) file: [19972fba] check-in: [10861964] user: drh branch: trunk, size: 32632 | |
2004-05-31
| ||
08:55 | Remove the <ON CONFLICT> clause from BEGIN (CVS 1501) file: [27c1ce09] check-in: [9029274b] user: danielk1977 branch: trunk, size: 32632 | |
2004-05-29
| ||
10:23 | Fix vacuum so that it works with blobs. (CVS 1490) file: [facaa7d0] check-in: [4feb4b9a] user: danielk1977 branch: trunk, size: 32644 | |
02:37 | Allow CREATE and DROP TRIGGER on attached databases. (CVS 1488) file: [fbb23787] check-in: [4060a37d] user: danielk1977 branch: trunk, size: 32621 | |
2004-05-28
| ||
12:33 | Allow CREATE and DROP VIEW on attached databases. (CVS 1485) file: [9d3be712] check-in: [ad879a95] user: danielk1977 branch: trunk, size: 32568 | |
12:11 | Allow DROP TABLE and DROP INDEX on attached databases. (CVS 1484) file: [32d6d4b2] check-in: [2fb3708e] user: danielk1977 branch: trunk, size: 32521 | |
11:37 | Allow CREATE TABLE and CREATE INDEX on attached databases. (CVS 1483) file: [1ab0393a] check-in: [4984a130] user: danielk1977 branch: trunk, size: 32487 | |
2004-05-27
| ||
17:22 | Remove the COPY command. (CVS 1477) file: [63d39b6f] check-in: [287f8673] user: drh branch: trunk, size: 32513 | |
09:28 | Various bugfixes. 68 Test cases still fail. (CVS 1471) file: [1a39b219] check-in: [67a140cf] user: danielk1977 branch: trunk, size: 32875 | |
2004-05-20
| ||
23:37 | Fix a bug that prevented sorting by index. Down to 162 failed tests. (CVS 1421) file: [56771886] check-in: [b032b646] user: drh branch: trunk, size: 32800 | |
22:16 | Add internal support for collating sequences. This breaks 244 tests. (CVS 1420) file: [7c8eb3a3] check-in: [a6cb09d7] user: drh branch: trunk, size: 32784 | |
12:41 | Fix problems with types and the recognition of BLOB as having no affinity. (CVS 1418) file: [4ed66f12] check-in: [8411718f] user: drh branch: trunk, size: 32837 | |
2004-05-18
| ||
10:06 | Fix many problems with manifest types and column affinity. Most things are working now. (CVS 1393) file: [d2e22665] check-in: [ad4a9641] user: danielk1977 branch: trunk, size: 32813 | |
2004-05-08
| ||
08:23 | Change lots of internal symbols from sqliteXXX to sqlite3XXX so that the library links again. It doesn't work yet, due to changes in the btree layer calling convention. (CVS 1324) file: [d0258aa3] check-in: [8af6474c] user: danielk1977 branch: trunk, size: 32810 | |
2004-02-22
| ||
18:40 | Use sqliteErrorMsg instead of sqliteSetString whereever practical. (CVS 1264) file: [023720cb] check-in: [69aac043] user: drh branch: trunk, size: 32550 | |
16:27 | Rearrange the grammar some so that tokens that are used together appear together in the grammar file. This reduces the size of the parser tables and some of the jump tables in switch statements. (CVS 1262) file: [b990b584] check-in: [d372c16e] user: drh branch: trunk, size: 32635 | |
2004-02-14
| ||
23:59 | Eliminate obsolete code associated with the older callback functionality. (CVS 1243) file: [226bbdba] check-in: [2dbc4593] user: drh branch: trunk, size: 32377 | |
2004-02-12
| ||
18:46 | Add hooks on each attached database connection for storing auxiliary information. Add the USING clause to ATTACH. (CVS 1232) file: [1e311dc6] check-in: [800c11f4] user: drh branch: trunk, size: 32430 | |
17:28 | All REPLACE INTO syntax inside of triggers. Ticket #610. (CVS 1231) file: [eb3af3b6] check-in: [a6b862a9] user: drh branch: trunk, size: 32300 | |
2004-01-24
| ||
20:18 | Add the ability to group FROM terms using parentheses. Names of columns in a join no longer include the table name. (CVS 1197) file: [7a121554] check-in: [3626f6d4] user: drh branch: trunk, size: 32306 | |
2004-01-15
| ||
03:30 | Allow "expr IN table" as a shorthand for "expr IN (SELECT * FROM table)" (CVS 1180) file: [e41722d1] check-in: [01874d25] user: drh branch: trunk, size: 32027 | |
2003-12-06
| ||
21:43 | Always use "(char*)0" to terminate the argument list of sqliteSetString(). This is needed for 64-bit systems that use a 32-bit integer by default. (CVS 1126) file: [c65aa6c5] check-in: [656c9038] user: drh branch: trunk, size: 31373 | |
2003-11-27
| ||
00:48 | Disallow temporary indices on persistent tables. (CVS 1122) file: [1c72ca2a] check-in: [72bf73b2] user: drh branch: trunk, size: 31366 | |
2003-09-30
| ||
01:54 | All LIKE and GLOB operators to use function notation. "A LIKE B" can be expressed as "LIKE(B,A)". (CVS 1108) file: [ec5d0d0a] check-in: [95b27ebd] user: drh branch: trunk, size: 31379 | |
2003-09-27
| ||
13:39 | Remove support for the Oracle8 outer join syntax. (CVS 1106) file: [8ef7f4e0] check-in: [824430b3] user: drh branch: trunk, size: 31370 | |
2003-09-06
| ||
22:18 | Update Makefile.in for the new vdbeaux.c file. Remove the experimental "sqlite_instantiate()" routine and replace it with "sqlite_bind()" which is more like ODBC and JDBC. (CVS 1095) file: [121daf21] check-in: [990bb118] user: drh branch: trunk, size: 31509 | |
01:10 | The beginnings of changes to support pre-compiled SQL. Mostly untested, though all regression tests to pass. (CVS 1093) file: [5cd707f0] check-in: [912f47c7] user: drh branch: trunk, size: 31467 | |
2003-07-16
| ||
02:19 | Allow negative values for LIMIT and OFFSET. Add tests for negative LIMITs and OFFSETs. Make the OFFSET work even if LIMIT is 0 or negative. (CVS 1052) file: [16aed0e3] check-in: [e6a752bf] user: drh branch: trunk, size: 31396 | |
2003-05-17
| ||
19:04 | Prevent an infinite loop when deleting a table that has a TEMP trigger. (CVS 984) file: [917250e5] check-in: [c8c823b0] user: drh branch: trunk, size: 31320 | |
2003-04-29
| ||
17:19 | Allow the ASC or DESC keyword to appear after a column name in a CREATE INDEX statement. SQLite indices are aways ASC (ascending) regardless of which keyword is used. (CVS 943) file: [39b5240c] check-in: [1a0c5420] user: drh branch: trunk, size: 31322 | |
2003-04-21
| ||
18:48 | Add support for TEMPORARY triggers. Such triggers can write temporary or permanent tables. (CVS 926) file: [15ae47e7] check-in: [58ddd587] user: drh branch: trunk, size: 31322 | |
2003-04-17
| ||
22:57 | Fix triggers to work in an ATTACHed database. Ticket #295. (CVS 915) file: [ad40843a] check-in: [1e5e00fb] user: drh branch: trunk, size: 31167 | |
2003-03-31
| ||
00:30 | The ATTACH and DETACH statements are now coded but are still mostly untested. (CVS 890) file: [3be47fa1] check-in: [c7c5e927] user: drh branch: trunk, size: 31166 | |
2003-03-27
| ||
12:51 | Changes to the "sqlite" structure that allow simultaneous operations on multiple database files. Many regession tests pass - but not all of them. Do not use this version except for debugging SQLite itself. (CVS 883) file: [243cfc27] check-in: [d2fb2bb5] user: drh branch: trunk, size: 31091 | |
2003-03-20
| ||
01:16 | Record the database name in addition to the table name for DELETE, INSERT, and UPDATE statements. (CVS 879) file: [7a9f333e] check-in: [a5d8fc95] user: drh branch: trunk, size: 30575 | |
2003-02-20
| ||
00:44 | Fix the parsing of the LIMIT clause when the limit and offset are separated by a comma. The offset comes before the limit in that case. Ticket #245. (CVS 872) file: [4c4b2ff3] check-in: [6ef91a36] user: drh branch: trunk, size: 30016 | |
2003-01-29
| ||
18:46 | Better error messages on constraint violations. Additional tests and bug fixes for the callback-free API. (CVS 854) file: [cdaed500] check-in: [ccc82f1a] user: drh branch: trunk, size: 29928 | |
2003-01-28
| ||
23:13 | First code for the new callback-free API. All regression tests pass but the new API is mostly untested and is unlikely to work. (CVS 852) file: [aea0819c] check-in: [065fa818] user: drh branch: trunk, size: 29902 | |
2003-01-18
| ||
20:11 | Fix datatype reporting and collating sequence selection so that it works correctly on views and with the UNION, EXCEPT, and INTERCEPT operators. (CVS 839) file: [a4fbfbe3] check-in: [71cc292d] user: drh branch: trunk, size: 29711 | |
2003-01-13
| ||
23:27 | Revise the sqlite_set_authorizer API to provide more detailed information about the SQL statement being authorized. Only partially tested so far. (CVS 830) file: [58655a50] check-in: [45de93f9] user: drh branch: trunk, size: 29715 | |
2003-01-07
| ||
02:47 | More optimizations. (CVS 816) file: [427a1788] check-in: [a362981b] user: drh branch: trunk, size: 29713 | |
2002-10-27
| ||
19:35 | Minimal support for oracle8 outer join syntax. (CVS 771) file: [469c9636] check-in: [31df3690] user: drh branch: trunk, size: 29696 | |
2002-10-22
| ||
23:38 | Correctly handle column names and string constants in parentheses. Fix for ticket #179. (CVS 770) file: [e37e66aa] check-in: [3b68aa25] user: drh branch: trunk, size: 29557 | |
2002-08-31
| ||
18:53 | Parse foreign key constraints and populate internal data structures appropriately. Constraints are still not enforced. (CVS 738) file: [818b03a7] check-in: [170711ca] user: drh branch: trunk, size: 29659 | |
2002-08-24
| ||
18:24 | Change the way token memory is allocated in an effort to fix ticket #136. There is now a memory leak when using views of views. (CVS 725) file: [1b180e14] check-in: [22d8726e] user: drh branch: trunk, size: 28323 | |
2002-08-18
| ||
22:41 | This COLLATE keyword was not being parsed correctly inside CREATE TABLE statements - it was being included as part of the datatype. This fixes the problem. (CVS 722) file: [5de87bb0] check-in: [39bd52d3] user: drh branch: trunk, size: 28087 | |
2002-08-11
| ||
20:10 | Fix for ticket #9: Add the ability to read little-endian database files from a big-endian machine and vice versa. (CVS 704) file: [66e7da55] check-in: [ce4b943b] user: drh branch: trunk, size: 28095 | |
2002-07-15
| ||
18:55 | Fix for ticket #102: Honor the ORDER BY clause in subqueries. (CVS 677) file: [5307e1a7] check-in: [7e918c8b] user: drh branch: trunk, size: 28072 | |
2002-07-08
| ||
22:03 | Add support for TEMPORARY views. The code is here but it is mostly untested. (CVS 668) file: [9267b768] check-in: [87cd10c1] user: drh branch: trunk, size: 28157 | |
2002-07-05
| ||
21:42 | All the code is now in place for SQLite to distinguish between NUMERIC and TEXT datatypes. Still need to turn on the new code and test it. (CVS 659) file: [35437ac2] check-in: [b4737a16] user: drh branch: trunk, size: 28146 | |
2002-07-01
| ||
12:27 | Fix for tickets #90 and #89: Make the AS keyword optional again. (CVS 654) file: [dcaf2196] check-in: [1f8a73b1] user: drh branch: trunk, size: 28133 | |
2002-06-25
| ||
01:09 | Added support for the "sqlite_temp_master" table. Increased the version number to 2.5.2. (CVS 640) file: [c75ea258] check-in: [9c1432bf] user: drh branch: trunk, size: 27892 | |
2002-06-17
| ||
17:07 | Add preliminary logic for the eventual move to having separate TEXT and NUMTEXT datatypes. Also change the version number to 2.5.0 in preparation for an interim release. (CVS 625) file: [2285d896] check-in: [05783a9d] user: drh branch: trunk, size: 27828 | |
2002-06-11
| ||
02:25 | Add RAISE() function, which allows more advanced flow-control in trigger programs (ticket #55) (CVS 614) file: [42920305] check-in: [d4a2fb10] user: danielk1977 branch: trunk, size: 27559 | |
2002-06-06
| ||
19:04 | Additional grammar cleanup resulting from the %fallback directive. (CVS 606) file: [3b4989cb] check-in: [c0cb3a01] user: drh branch: trunk, size: 26902 | |
18:54 | Added the %fallback directive to the lemon parser generator and used this in the parser to make the parse tables much smaller. This reduced the size of the library by 15K. (CVS 605) file: [e8c65150] check-in: [7ac5bd29] user: drh branch: trunk, size: 28045 | |
2002-06-02
| ||
18:19 | Add the ability to parse FOREIGN KEYs. Foreign keys are still ignored, but at least they now do not cause a syntax error. (CVS 603) file: [68c0ab3d] check-in: [6fdcee3c] user: drh branch: trunk, size: 27699 | |
2002-05-24
| ||
16:14 | Add support for the full SQL join syntax. This is just a parser enhancement. We now recognize all kinds of joins, but we don't actually do anything with them yet. (CVS 586) file: [c681da70] check-in: [e238643e] user: drh branch: trunk, size: 26577 | |
02:04 | Split the IdList structure into IdList and SrcList. SrcList is used to represent a FROM clause and IdList is used for everything else. This change allows SrcList to grow to support outer joins without burdening the other uses of IdList. (CVS 584) file: [8053fead] check-in: [a167b71d] user: drh branch: trunk, size: 25261 | |
2002-05-23
| ||
00:30 | Do not allow triggers on the SQLITE_MASTER table. (CVS 579) file: [3f2f7334] check-in: [275ba356] user: drh branch: trunk, size: 24767 | |
2002-05-21
| ||
11:38 | Additional code cleanup resulting from a review of the new trigger code. (CVS 572) file: [964a7cc9] check-in: [37dbdd55] user: drh branch: trunk, size: 24733 | |
2002-05-15
| ||
14:17 | Fix for ticket #41: Better handling of CREATE TRIGGER in the sqlite_complete() function. (CVS 567) file: [12d6f6c0] check-in: [f45c4b76] user: drh branch: trunk, size: 24600 | |
08:30 | Added FOR EACH ROW triggers functionality (CVS 562) file: [16478953] check-in: [794bf67b] user: danielk1977 branch: trunk, size: 24575 | |
2002-05-08
| ||
21:46 | Fix for ticket #35: Ignore any ORDER BY clause on a subquery in a FROM clause. (CVS 557) file: [83850a81] check-in: [1b0ee944] user: drh branch: trunk, size: 22264 | |
2002-04-20
| ||
14:24 | Fix for ticket #1: Implement the GLOB and LIKE operators as functions that can be overridden. This way, a developer can change the LIKE operator to be case sensitive, for example. (CVS 537) file: [0ce56f1c] check-in: [51572bf7] user: drh branch: trunk, size: 22094 | |
2002-04-06
| ||
13:57 | Make the FROM clause on a SELECT optional. If omitted, the result of the SELECT is a single row consisting of the values in the expression list. (CVS 520) file: [9a8a2311] check-in: [28ce42f7] user: drh branch: trunk, size: 21985 | |
2002-04-04
| ||
02:10 | Fix for bug #2: Add support for TABLE.* in SELECT statements. (CVS 518) file: [d63f93b6] check-in: [c2320eab] user: drh branch: trunk, size: 21907 | |
2002-03-30
| ||
15:26 | Fix for bug #3: Allow VIEW as a column name. Also allow COPY. (CVS 507) file: [a0943e27] check-in: [d2bdc0fe] user: drh branch: trunk, size: 21697 | |
2002-03-24
| ||
13:13 | Added support for CASE expressions - patches from Dan Kennedy. (CVS 437) file: [e6f300a3] check-in: [836b59d0] user: drh branch: trunk, size: 21629 | |
2002-03-13
| ||
18:54 | Fix bug in anonymous subquery in a join. Parser requires a semicolon or end-of-input before executing. (CVS 429) file: [9a8be2ee] check-in: [c0e3f1c5] user: drh branch: trunk, size: 20835 | |
2002-03-05
| ||
01:11 | Add the ability to turn of calls to fsync() using the "synchronous" pragma. Increased the default cache size from 100 to 2000 and made the "cache_size" pragma persistent. (CVS 418) file: [f7483ccf] check-in: [414da4af] user: drh branch: trunk, size: 20826 | |
2002-03-03
| ||
23:06 | More bugs fixed for views. (CVS 416) file: [25b794bf] check-in: [81307762] user: drh branch: trunk, size: 20826 | |
2002-03-02
| ||
17:04 | Subquery flattening is implemented and passes all regression tests. We still need to add addition tests to the suite to further exercise the flattener, however. (CVS 408) file: [d62960cd] check-in: [d5d3e79c] user: drh branch: trunk, size: 20821 | |
2002-02-23
| ||
02:32 | Code to implement CREATE VIEW is in place. A quick smoke test shows that it works, but there are probably still many bugs. (CVS 387) file: [fc460cda] check-in: [39fed2df] user: drh branch: trunk, size: 20812 | |
2002-02-18
| ||
22:49 | Bug fix: CREATE TABLE, followed by DROP TABLE within the same transaction is working now. (CVS 378) file: [b8227891] check-in: [553579f9] user: drh branch: trunk, size: 20582 | |
18:30 | Add support for CREATE TABLE AS. (CVS 377) file: [722bc0b6] check-in: [78a50971] user: drh branch: trunk, size: 20534 | |
13:56 | Allow general expressions in the VALUES clause of an INSERT statement. (CVS 376) file: [39c336ff] check-in: [ec1f3fae] user: drh branch: trunk, size: 20514 | |
01:17 | Add support for subqueries in the FROM clause of a SELECT. Still need to add tests for this feature. (CVS 372) file: [f7a6d812] check-in: [89ffa9ff] user: drh branch: trunk, size: 21215 | |
2002-02-03
| ||
17:37 | Put in PRAGMA SANITY_CHECK in place of VACUUM. (CVS 365) file: [734ba1e0] check-in: [7c65029e] user: drh branch: trunk, size: 20947 | |
00:56 | Five-algorithm conflict resolution appears to be working. (CVS 363) file: [f081d7d4] check-in: [0115518f] user: drh branch: trunk, size: 20874 | |
2002-02-02
| ||
15:01 | Checkpoint code added to the pager. Regression tests work but the new APIs have not been tested yet. (CVS 361) file: [88856227] check-in: [aaa53e11] user: drh branch: trunk, size: 21088 | |
2002-01-31
| ||
15:54 | Change to five conflict resolution algorithms: ROLLBACK, ABORT, FAIL, IGNORE, and REPLACE. This checkin is code only. Documentation and tests are still needed. Also, ABORT is not fully implemented. (CVS 360) file: [90e9fc91] check-in: [d0e7cf4a] user: drh branch: trunk, size: 20752 | |
2002-01-30
| ||
16:17 | Added ON CONFLICT support to COPY. Updates to documentation. Bug fixes. (CVS 359) file: [e80f1cf6] check-in: [cf1538d7] user: drh branch: trunk, size: 20582 | |
2002-01-29
| ||
18:41 | Beginning to insert the infrastructure for ON CONFLICT clauses. (CVS 355) file: [fd79a092] check-in: [e00a9ff8] user: drh branch: trunk, size: 20554 | |
2002-01-06
| ||
17:07 | Comment updates most. Also some small changes to the VDBE. (CVS 339) file: [f3fc4fb5] check-in: [9b0be4fc] user: drh branch: trunk, size: 19528 | |
2001-12-22
| ||
14:49 | Bug fixing in the new integer primary key code. (CVS 334) file: [f050644e] check-in: [29cab124] user: drh branch: trunk, size: 19494 | |
2001-12-21
| ||
14:30 | Added support for the INTEGER PRIMARY KEY column type. (CVS 333) file: [c62f32e3] check-in: [236a54d2] user: drh branch: trunk, size: 19494 | |
2001-12-16
| ||
20:05 | Added the ability to say things like "SELECT rowid, * FROM table1;" (CVS 332) file: [23ff6728] check-in: [ffbdd43f] user: drh branch: trunk, size: 19509 | |
2001-11-06
| ||
04:00 | Implement indices that occur in sort order and the LIMIT...OFFSET clause of SELECT statements. (CVS 301) file: [5295f393] check-in: [eb07768a] user: drh branch: trunk, size: 19420 | |
2001-10-13
| ||
02:59 | 2.0.3 (CVS 287) file: [148e4cd1] check-in: [75e90cf0] user: drh branch: trunk, size: 18964 | |
2001-10-12
| ||
17:30 | Fix an assertion failure when the disk fills up. Add tests for a full disk situation. (CVS 285) file: [2275a832] check-in: [0a7848b6] user: drh branch: trunk, size: 18964 | |
2001-10-08
| ||
13:22 | Support for temporary tables added. Still need more testing. (CVS 279) file: [e88f1efe] check-in: [9368c62e] user: drh branch: trunk, size: 18335 | |
2001-10-06
| ||
16:33 | Adding table column query capability to support ODBC. (CVS 278) file: [fcd34526] check-in: [b63b3f36] user: drh branch: trunk, size: 18177 | |
2001-10-01
| ||
14:29 | The .dump output uses INSERT instead of COPY now. Expression syntax of the form "expr NOT NULL" is now supported. (CVS 276) file: [5ead6fe1] check-in: [20382325] user: drh branch: trunk, size: 16999 | |
2001-09-27
| ||
15:11 | Fixed the support of UNIQUE and PRIMARY KEY. (CVS 268) file: [7a61488c] check-in: [116fdad0] user: drh branch: trunk, size: 16783 | |
03:22 | Added basic support for enforcement of UNIQUE on indices and primary keys. Support for addition constraints is to follow. (CVS 267) file: [a136e0a2] check-in: [34c42967] user: drh branch: trunk, size: 16667 | |
2001-09-16
| ||
00:13 | Disclaimed copyright. Preparing for release 2.0. (CVS 250) file: [2bcf47bb] check-in: [4e926efe] user: drh branch: trunk, size: 16595 | |
2001-09-14
| ||
18:54 | Added a PRAGMA statement. Took out the special comment parsing. (CVS 245) file: [8b30e072] check-in: [5e372460] user: drh branch: trunk, size: 17150 | |
2001-04-11
| ||
14:28 | better handling of out-of-memory errors (CVS 207) file: [8fc09694] check-in: [86b30cd0] user: drh branch: trunk, size: 16567 | |
2001-04-04
| ||
11:48 | Added transaction support (CVS 196) file: [1ba81d3b] check-in: [35a8feed] user: drh branch: trunk, size: 16481 | |
2001-01-04
| ||
14:20 | :-) (CVS 171) file: [25ee4d8e] check-in: [d49e10fb] user: drh branch: trunk, size: 15399 | |
2000-08-01
| ||
09:56 | fix parser stack overflow (CVS 119) file: [5d199034] check-in: [bffca90f] user: drh branch: trunk, size: 15398 | |
2000-07-29
| ||
13:06 | better column labels in select results (CVS 110) file: [754653f0] check-in: [3bf434d9] user: drh branch: trunk, size: 15398 | |
2000-06-21
| ||
13:59 | :-) (CVS 104) file: [86e268c2] check-in: [e1bf96a4] user: drh branch: trunk, size: 14848 | |
2000-06-19
| ||
19:09 | :-) (CVS 102) file: [974ed077] check-in: [8cce4d27] user: drh branch: trunk, size: 14831 | |
2000-06-16
| ||
20:51 | :-) (CVS 100) file: [766844e4] check-in: [1d4fe559] user: drh branch: trunk, size: 14820 | |
2000-06-09
| ||
14:14 | :-) (CVS 91) file: [6a3085fd] check-in: [d573b431] user: drh branch: trunk, size: 14732 | |
2000-06-08
| ||
16:26 | :-) (CVS 82) file: [03d246c2] check-in: [33355b2d] user: drh branch: trunk, size: 14740 | |
15:10 | :-) (CVS 81) file: [389687d2] check-in: [61c381e7] user: drh branch: trunk, size: 14796 | |
13:36 | remove all memory leaks (CVS 80) file: [e6c61f20] check-in: [bf98cf82] user: drh branch: trunk, size: 14882 | |
2000-06-07
| ||
23:51 | :-) (CVS 74) file: [bb2126c8] check-in: [2ffeb850] user: drh branch: trunk, size: 14934 | |
14:42 | :-) (CVS 1697) file: [4a2e6b14] check-in: [5d773b5d] user: drh branch: trunk, size: 14926 | |
2000-06-06
| ||
21:56 | :-) (CVS 62) file: [8b632f4c] check-in: [f4d9089c] user: drh branch: trunk, size: 14817 | |
17:27 | GROUP BY and HAVING installed (CVS 58) file: [210c888c] check-in: [db88a0c2] user: drh branch: trunk, size: 14390 | |
13:54 | added IN and BETWEEN operators (CVS 57) file: [51ef63a4] check-in: [54d19818] user: drh branch: trunk, size: 14029 | |
01:50 | :-) (CVS 55) file: [9c459212] check-in: [bd8b2645] user: drh branch: trunk, size: 13276 | |
2000-06-05
| ||
18:54 | :-) (CVS 52) file: [79b40324] check-in: [c02268bd] user: drh branch: trunk, size: 12888 | |
16:01 | separate Select structure (CVS 51) file: [020e5da7] check-in: [ce45dea9] user: drh branch: trunk, size: 12796 | |
2000-06-03
| ||
19:19 | :-) (CVS 47) file: [9ec48660] check-in: [729d6586] user: drh branch: trunk, size: 12366 | |
18:06 | added default values (CVS 46) file: [64d9e480] check-in: [27c06786] user: drh branch: trunk, size: 12280 | |
2000-05-31
| ||
20:00 | added DISTINCT on select (CVS 27) file: [16322c46] check-in: [1f0c4ffd] user: drh branch: trunk, size: 11256 | |
18:20 | :-) (CVS 25) file: [038e0f0f] check-in: [35a8f523] user: drh branch: trunk, size: 11129 | |
15:34 | added aggregate functions like count(*) (CVS 21) file: [bdfcd0a3] check-in: [dee7a8be] user: drh branch: trunk, size: 11345 | |
02:27 | :-) (CVS 20) file: [05de7dec] check-in: [01d85b35] user: drh branch: trunk, size: 11356 | |
2000-05-30
| ||
16:27 | :-) (CVS 15) file: [50ca06d4] check-in: [8d66c735] user: drh branch: trunk, size: 11087 | |
2000-05-29
| ||
20:41 | :-) (CVS 6) file: [265c8596] check-in: [1517f852] user: drh branch: trunk, size: 10851 Added | |