Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of tool/mkkeywordhash.c
|
2019-11-01
| ||
| 10:49 | Fix a potential array bounds overflow in the mkkeywordhash.c code generator. Also add marks to omit keywords specific to generated columns when building with -DSQLITE_OMIT_GENERATED_COLUMNS. file: [27ffc6f6] check-in: [cc6a4081] user: drh branch: trunk, size: 25774 | |
| 02:30 | Slightly faster keyword hash table. file: [1d4626fe] check-in: [f12e743e] user: drh branch: trunk, size: 25652 | |
|
2019-10-16
| ||
| 12:18 | Initial experimental code for generated column support. Non-functional. file: [8973d556] check-in: [11d472c1] user: drh branch: generated-columns, size: 24561 | |
|
2019-09-16
| ||
| 12:08 | Merge recent trunk enhancements into the begin-concurrent branch. file: [668c2469] check-in: [93b9ef3f] user: drh branch: begin-concurrent, size: 24354 | |
|
2019-08-12
| ||
| 16:36 | Experimental implementation of NULLS FIRST/LAST. This branch still has problems - the most significant of which is that ORDER BY clauses with a non-default NULLS FIRST/LAST qualifier can never use an index. file: [bc5bcc92] check-in: [07babb0f] user: dan branch: nulls-last, size: 24423 | |
|
2019-04-15
| ||
| 14:59 | Merge the latest enhancements from trunk. file: [cdb15209] check-in: [7c328e88] user: drh branch: begin-concurrent, size: 24147 | |
|
2019-04-02
| ||
| 13:10 | Put the list of keywords in mkkeywordhash.c into alphabetical order. file: [537b1a11] check-in: [ac98b23b] user: drh branch: trunk, size: 24216 | |
|
2019-03-14
| ||
| 20:53 | Parse EXCLUDE clauses in window frames. They do not yet work. file: [127d0b86] check-in: [d03c7533] user: dan branch: window-functions, size: 24216 | |
|
2019-03-08
| ||
| 20:02 | Finish consolidation of window frame code. Add untested support for GROUPS frames. file: [a5a59223] check-in: [954bf369] user: dan branch: window-functions, size: 24009 | |
|
2018-07-10
| ||
| 15:45 | Merge latest trunk changes into this branch. file: [1e5cfcf4] check-in: [e9a3e864] user: dan branch: begin-concurrent, size: 23871 | |
|
2018-06-22
| ||
| 20:51 | Omit all window-function related code when building with SQLITE_OMIT_WINDOWFUNC. file: [1f7f2ac1] check-in: [5f04b016] user: dan branch: exp-window-functions, size: 23940 | |
|
2018-06-08
| ||
| 20:58 | Add support for the WINDOW clause. file: [a0fd2548] check-in: [19c983b5] user: dan branch: exp-window-functions, size: 23842 | |
|
2018-05-16
| ||
| 20:58 | Start of experimental implementation of SQL window functions. Does not yet work. file: [dd4d201d] check-in: [3781e520] user: dan branch: exp-window-functions, size: 23773 | |
|
2018-04-26
| ||
| 17:54 | Merge latest changes from trunk. Including the "ORDER BY ... LIMIT" optimization. file: [d4ce28d8] check-in: [d8ae7ba0] user: dan branch: begin-concurrent, size: 23083 | |
|
2018-04-25
| ||
| 19:02 | Add new interfaces for accessing the list of SQL keywords: sqlite3_keyword_count(), sqlite3_keyword_name(), sqlite3_keyword_check(). file: [20f366ad] check-in: [7dd34e37] user: drh branch: trunk, size: 23152 | |
|
2018-04-24
| ||
| 19:21 | Merge latest trunk changes into this branch. file: [7752f80e] check-in: [b27bd799] user: dan branch: begin-concurrent, size: 22551 | |
|
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: [98d7ce6f] check-in: [810d9f63] user: drh branch: upsert, size: 22620 | |
|
2018-04-12
| ||
| 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: [9daf0805] check-in: [c48f64d8] user: drh branch: upsert, size: 22689 | |
|
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: [9f5fee13] check-in: [5cc2a5a3] user: drh branch: upsert, size: 22526 | |
|
2017-07-20
| ||
| 17:47 | Merge all the latest trunk enhancements. file: [09ee7db4] check-in: [213c61cb] user: drh branch: begin-concurrent, size: 22319 | |
|
2017-07-08
| ||
| 20:46 | Support read-only MVCC transactions in server-mode. Started using "BEGIN READONLY". file: [969c5030] check-in: [5a043aa8] user: dan branch: server-process-edition, size: 22457 | |
|
2017-07-06
| ||
| 16:33 | Change the (machine-generated) keywordhash.h file to increase the scope of the tables used for keyword matching, so that the tables are accessible to functions other then keywordCode(). file: [2e852ac0] check-in: [c5ed5ebd] user: drh branch: trunk, size: 22388 | |
|
2016-02-15
| ||
| 17:44 | Merge version 3.11.0 file: [f5ecfd09] check-in: [c393ddc7] user: drh branch: begin-concurrent, size: 21494 | |
|
2016-02-08
| ||
| 19:15 | Add code to get the tokenizer character-class logic working for EBCDIC. file: [f7f3b342] check-in: [04f7da77] user: drh branch: tokenizer-char-class, size: 21563 | |
| 03:23 | Faster keywordCode() implementation by taking advantage of the fact that the input is always pure ASCII alphabetic and underscore and that the keyword table is always upper-case. file: [4451824f] check-in: [ff406b97] user: drh branch: tokenizer-char-class, size: 21221 | |
|
2015-11-20
| ||
| 13:49 | Merge all the latest enhancements and fixes from trunk. file: [24c1fb16] check-in: [41c8b8e3] user: drh branch: begin-concurrent, size: 21023 | |
|
2015-11-17
| ||
| 19:16 | Fix harmless compiler warning. file: [06ec0b78] check-in: [eea26b6c] user: mistachkin branch: trunk, size: 21092 | |
|
2015-11-10
| ||
| 03:30 | Performance enhancement to the tokenizer. file: [37f9c2e6] check-in: [6ea2df86] user: drh branch: parser-enhancements, size: 21095 | |
|
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: [ff6fc41e] check-in: [c0bf92ec] user: drh branch: begin-concurrent, size: 22145 | |
|
2015-08-24
| ||
| 19:56 | Change "BEGIN UNLOCKED" to "BEGIN CONCURRENT". file: [8d78ea18] check-in: [ba1ab858] user: dan branch: begin-concurrent, size: 22283 | |
|
2015-07-27
| ||
| 19:31 | Add an experimental "BEGIN UNLOCKED" command. file: [de4a823f] check-in: [80794216] user: dan branch: begin-concurrent, size: 22283 | |
|
2014-05-31
| ||
| 15:39 | Fix a compile of harmless static analyzer warnings. file: [dfff09db] check-in: [7e287f20] user: drh branch: trunk, size: 22214 | |
|
2014-01-11
| ||
| 13:22 | Parse common table expressions. But do not do anything with them (yet). file: [c9e05e4a] check-in: [da98b720] user: drh branch: common-table-expr, size: 22204 | |
|
2014-01-06
| ||
| 18:32 | Start a new experimental branch for support of Oracle-style CONNECT BY syntax. file: [86acc19b] check-in: [4365ddd6] user: drh branch: connect-by, size: 22348 | |
|
2013-10-21
| ||
| 02:14 | Simplification of the syntax: Merely append "WITHOUT rowid" to the end of the table definition. file: [189d7664] check-in: [131cc6e1] user: drh branch: omit-rowid, size: 21975 | |
|
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: [d29369d1] check-in: [0248ec5e] user: drh branch: omit-rowid, size: 21975 | |
|
2012-04-18
| ||
| 10:13 | Fix a harmless compiler warning in the mkkeywordhash.c utility program. file: [bb52064a] check-in: [6015200b] user: drh branch: trunk, size: 21906 | |
|
2010-01-02
| ||
| 03:21 | Add a new sqlite3_test_control() verb that facilitates testing that all keywords are shown in the documentation. (Two keywords were found to be missing while testing the change.) file: [d2e6b4a5] check-in: [d3cdc4b1] user: drh branch: trunk, size: 21901 | |
|
2009-11-03
| ||
| 13:08 | Force all qsort() calls in mkkeywordhash.c to be stable so that we get predictable results on different platforms. file: [92163360] check-in: [3b02df27] user: drh branch: trunk, size: 21848 | |
|
2009-09-21
| ||
| 16:06 | Fix compilation with OMIT_TRIGGER defined. Ticket [1ff6d29030]. file: [8c9f8e32] check-in: [fb6ceed3] user: dan branch: trunk, size: 21842 | |
|
2009-06-09
| ||
| 14:27 | Modify mkkeywordhash.c so that it puts the original text of each token in a comment beside the "testcase()" macros. (CVS 6736) file: [511a848b] check-in: [a7d0817c] user: drh branch: trunk, size: 21704 | |
|
2009-02-01
| ||
| 00:00 | Make the TO keyword available even if SQLITE_OMIT_ALTERTABLE is defined. Ticket #3622. (CVS 6223) file: [8e57fbe8] check-in: [3890985c] user: drh branch: trunk, size: 21537 | |
|
2008-12-31
| ||
| 21:52 | Avoid surplus bytes at the end of the keyword string table. Add testcase() macros to make sure all keywords are used during testing. (CVS 6090) file: [1583825e] check-in: [73958060] user: drh branch: trunk, size: 21537 | |
|
2008-12-17
| ||
| 17:30 | Add the savepoint feature. This feature is largely untested at this point. (CVS 6036) file: [698ea044] check-in: [34b56600] user: danielk1977 branch: trunk, size: 21401 | |
|
2008-12-10
| ||
| 20:11 | Fixed typo in comment in mkkeywordhash.c. (CVS 6009) file: [b7f85b70] check-in: [b7dd05b4] user: shane branch: trunk, size: 21257 | |
|
2008-12-08
| ||
| 18:19 | The amalgamation now compiles cleanly on GCC with options -pedantic-errors -Wno-long-long. (CVS 5991) file: [7cd8f12d] check-in: [73c7302c] user: drh branch: trunk, size: 21258 | |
|
2008-10-06
| ||
| 05:32 | Allow INDEXED BY and NOT INDEXED clauses in SELECT statements. (CVS 5766) file: [c219ee2b] check-in: [98ca5580] user: danielk1977 branch: trunk, size: 20846 | |
|
2007-07-30
| ||
| 18:26 | Get rid of the following compile-time warnings: tool/mkkeywordhash.c:353: warning: array subscript has type 'char' tool/mkkeywordhash.c:354: warning: array subscript has type 'char' (CVS 4189) file: [ef93810f] check-in: [c01d7944] user: rse branch: trunk, size: 20769 | |
|
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: [fe15d1cb] check-in: [b13e497a] user: drh branch: trunk, size: 20759 | |
| 17:07 | Tighter compression of the keyword hash table. (CVS 3920) file: [39eb0ff0] check-in: [68121676] user: drh branch: trunk, size: 20828 | |
|
2007-04-26
| ||
| 14:42 | Add largely untested code for the incremental vacuum function. (CVS 3876) file: [e119bdc0] check-in: [f6a6d2b8] user: danielk1977 branch: trunk, size: 20036 | |
|
2007-04-06
| ||
| 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: [c6f797bf] check-in: [8e2559b4] user: drh branch: trunk, size: 19818 | |
|
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: [520d0016] check-in: [cbebfb89] user: drh branch: trunk, size: 19887 | |
|
2007-02-21
| ||
| 16:44 | Add comments to the top of keywordhash.h. (CVS 3651) file: [eb7cd724] check-in: [0aa9ed5b] user: drh branch: trunk, size: 19850 | |
|
2006-06-10
| ||
| 13:29 | Basic parsing of CREATE VIRTUAL TABLE statements. (CVS 3210) file: [966af86a] check-in: [66370cb9] user: drh branch: trunk, size: 19004 | |
|
2006-04-04
| ||
| 01:54 | Changes to get SQLite running on machines that use the EBCDIC character set. (CVS 3161) file: [a36f0f5e] check-in: [4342b499] user: drh branch: trunk, size: 18836 | |
|
2006-01-14
| ||
| 08:02 | Fixes for OMIT_SUBQUERY builds: Disable where clause OR->IN optimization. Include EXISTS keyword (for new CREATE TABLE syntax). Test file fixes. (CVS 2943) file: [fa58d31c] check-in: [8e79a0c2] user: danielk1977 branch: trunk, size: 18896 | |
|
2005-12-29
| ||
| 01:11 | Add support for DROP TABLE IF EXISTS. (CVS 2843) file: [9b4d521e] check-in: [a4c547de] user: drh branch: trunk, size: 18896 | |
|
2005-12-09
| ||
| 20:02 | Clean up annoying (and pointless) compiler warnings about differing signedness. (CVS 2810) file: [78479133] check-in: [83a59151] user: drh branch: trunk, size: 18827 | |
|
2005-09-10
| ||
| 16:46 | Add the experimental EXPLAIN QUERY PLAN diagnostic capability. (CVS 2685) file: [5263a654] check-in: [986efb7b] user: drh branch: trunk, size: 18811 | |
|
2005-07-08
| ||
| 12:13 | Add infrastructure for the ANALYZE command. Does not yet actually do anything. (CVS 2537) file: [e0b7833f] check-in: [05b6ac9a] user: drh branch: trunk, size: 18673 | |
|
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: [e4ba5010] check-in: [17631785] user: drh branch: trunk, size: 18400 | |
|
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: [59638994] check-in: [42a626ac] user: drh branch: trunk, size: 18244 | |
|
2005-03-17
| ||
| 05:06 | Update to keyword list for ALTER TABLE ... ADD COLUMN command. (CVS 2394) file: [02ac5c52] check-in: [173e2696] user: danielk1977 branch: trunk, size: 18175 | |
|
2005-02-04
| ||
| 04:07 | Remove code for SQL cursors. (CVS 2312) file: [c54532f0] check-in: [2eb90870] user: danielk1977 branch: trunk, size: 18037 | |
|
2005-02-01
| ||
| 01:40 | Tweaks to the keyword hash generator. Tried to make it a little faster. If nothing else, the keyword hash table is now a little smaller. (CVS 2297) file: [548b4b1a] check-in: [4eca6c05] user: drh branch: trunk, size: 18961 | |
|
2005-01-31
| ||
| 12:42 | Assorted minor changes to speed up loading the database schema. (CVS 2293) file: [18e45fb1] check-in: [dfbd684a] user: danielk1977 branch: trunk, size: 18907 | |
|
2005-01-21
| ||
| 15:52 | Final preparations for the 3.1.0 alpha release. (CVS 2255) file: [a62da87d] check-in: [17122c7e] user: drh branch: trunk, size: 18786 | |
|
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: [db33613e] check-in: [d30fdf0f] user: drh branch: trunk, size: 18638 | |
|
2004-11-23
| ||
| 12:24 | Include the 'FOR' keyword in builds that include cursors but not triggers. (CVS 2147) file: [408dccad] check-in: [3053d82d] user: danielk1977 branch: trunk, size: 18478 | |
|
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: [e83ab9c1] check-in: [fc8c1393] user: drh branch: trunk, size: 18478 | |
|
2004-11-17
| ||
| 16:41 | Add the ESCAPE clause to the LIKE operator. Not fully tested yet. (CVS 2107) file: [c2254c19] check-in: [49268c2b] user: danielk1977 branch: trunk, size: 17700 | |
|
2004-11-13
| ||
| 03:59 | Fix the keyword generator so that it works with SQLITE_OMIT_ALTERTABLE. (CVS 2096) file: [5f0d8bd4] check-in: [60ace998] user: drh branch: trunk, size: 17631 | |
|
2004-11-12
| ||
| 13:42 | Add the "ALTER TABLE xxx RENAME TO yyy" command. (CVS 2092) file: [27753dd0] check-in: [a1b2cc63] user: danielk1977 branch: trunk, size: 17632 | |
|
2004-11-03
| ||
| 16:27 | Update tests to work even if some features of the library are disabled. (CVS 2050) file: [b651bd7f] check-in: [b11fc9b3] user: drh branch: trunk, size: 17563 | |
| 03:59 | The makefile now runs mkkeywordhash.c. Keywords that are unused are omitted from the keyword hash table. (CVS 2045) file: [f1cb22f4] check-in: [007aec11] user: drh branch: trunk, size: 17563 | |
|
2004-10-23
| ||
| 05:10 | Tighter encoding of the keyword hash table in the tokenizer. (CVS 2028) file: [ed1f2a21] check-in: [7b9886f8] user: drh branch: trunk, size: 13360 | |
|
2004-10-07
| ||
| 19:03 | Optimizations to the tokenizer. (CVS 2011) file: [0cfab669] check-in: [e5540ce0] user: drh branch: trunk, size: 11112 Added | |