/ File History
Login

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

History of tool/mkkeywordhash.c

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