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 | Added: [0cfab669] part of check-in [e5540ce0] Optimizations to the tokenizer. (CVS 2011) (check-in: [e5540ce0] user: drh branch: trunk, size: 11112) | |