/ History for tool/mkkeywordhash.c
Login

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

History for tool/mkkeywordhash.c

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