/ File History
Login

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

History of src/parse.y

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