database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-25 09:59:22 +03:00
Code Activity
2,554 Commits 1,785 Branches 392 Tags
version-3.2.3
Commit Graph

175 Commits

Author SHA1 Message Date
drh
9f18e8a0c4 Add infrastructure for the ANALYZE command. Does not yet actually 
do anything. (CVS 2537)

FossilOrigin-Name: 05b6ac9a76fd5765c50e81588f8e71c59fe35ce4
 2005-07-08 12:13:04 +00:00
drh
eb55bd2fe9 Allow the DEFAULT value of a column to be obtained by calling a 
function that has constant arguments, such as julianday('now'). (CVS 2534)

FossilOrigin-Name: d273766ef2442eb87971b07f9ecf5682c88298ee
 2005-06-30 17:04:21 +00:00
drh
487e262f44 Remove the blob(), text() and numeric() functions added in (2524) and 
replace them with the standard CAST operator.
Ticket #1287. (CVS 2527)

FossilOrigin-Name: 17631785f9ee8ab280c82677eb53886912e085bc
 2005-06-25 18:42:14 +00:00
drh
b71090fdfb 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)

FossilOrigin-Name: 42a626ace126f730f33ecb6c41ac5679d6766a31
 2005-05-23 17:26:51 +00:00
drh
f8db1bc03b Remove some vestigal code. Add the experimental sqlite3_transfer_bindings() 
API. (CVS 2446)

FossilOrigin-Name: 88b39436f00d645cdb6333a7413c698c42227d3f
 2005-04-22 02:38:37 +00:00
danielk1977
53c0f7480b Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) 
FossilOrigin-Name: c41d55443c2dd532147962b87f542fb7d37075fd
 2005-03-29 03:10:59 +00:00
danielk1977
19a8e7e882 Add the ALTER TABLE ... ADD COLUMN command. (CVS 2393) 
FossilOrigin-Name: 94185dd4f7e2e941c74a521488d1212a75927218
 2005-03-17 05:03:38 +00:00
danielk1977
d5d565235b Fix some memory leaks that can occur if a memory allocation fails. (CVS 2388) 
FossilOrigin-Name: 9a358fc33d726d0b5782bf65b50f61f2bd096d56
 2005-03-16 12:15:20 +00:00
danielk1977
aee18ef8e2 Support for a future ALTER TABLE command to add columns with default values. (CVS 2367) 
FossilOrigin-Name: 9d5abc1ddf6da37563c12d5a0401b89bb4e51c59
 2005-03-09 12:26:50 +00:00
danielk1977
2b6d46b975 Tighten up the CREATE INDEX syntax accepted by the parser. (CVS 2329) 
FossilOrigin-Name: 41d2214b83dd52acdda64a50d0c1ef16009d06d0
 2005-02-14 06:38:40 +00:00
danielk1977
a2dc3b1a5e Allow expressions (including variables) in LIMIT and OFFSET clauses. Ticket #1096. (CVS 2316) 
FossilOrigin-Name: 515e5033a5482f55e7edb66d69ff3da7e234ff2e
 2005-02-05 12:48:48 +00:00
danielk1977
6a67fe8edf Remove code for SQL cursors. (CVS 2312) 
FossilOrigin-Name: 2eb90870556c90b8d85da3d5eb7554f74ec922c2
 2005-02-04 04:07:16 +00:00
danielk1977
b3bce66232 Modify sub-query handling. Tickets #1083 and #1084. (CVS 2286) 
FossilOrigin-Name: b1b50f315873a8614920d1e3af4a07fb29a7ff6a
 2005-01-29 08:32:43 +00:00
danielk1977
3e8c37e7f8 Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) 
FossilOrigin-Name: bb0254ab14417f0ab40f10f37cb63a60507f070a
 2005-01-21 03:12:14 +00:00
drh
51522cd34a Added the SQLITE_OMIT_SUBQUERY compile-time option and the EXISTS operator. 
Regression tests are currently failing with an assertion fault. (CVS 2245)

FossilOrigin-Name: d30fdf0f2c24cb74b48fab9b83fba4e4b2fe878a
 2005-01-20 13:36:19 +00:00
drh
1bd3644f27 Turn SQLITE_OMIT_CURSOR on by default. (CVS 2240) 
FossilOrigin-Name: 2d3ab1ab5ae08fe21f4662b171f04362c1326eb0
 2005-01-20 02:14:30 +00:00
drh
1398ad3639 Continued refactoring of the name resolution logic and query optimizer. (CVS 2236) 
FossilOrigin-Name: d8b2a7e09187564fe66a2b4bf0992c6a017146cf
 2005-01-19 23:24:50 +00:00
drh
b6c29897eb 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)

FossilOrigin-Name: fc8c1393c86017a816beb52725b68af3b973f979
 2004-11-22 19:12:19 +00:00
danielk1977
7c6303c042 Add the ESCAPE clause to the LIKE operator. Not fully tested yet. (CVS 2107) 
FossilOrigin-Name: 49268c2b7a84c4c618214dac8bef0f541440fe6b
 2004-11-17 16:41:29 +00:00
drh
13d7042a73 More compile-time options for removing components. (CVS 2098) 
FossilOrigin-Name: dcbc0c22cf269e2f67002aa3f1bc0c66aaeff5f1
 2004-11-13 15:59:14 +00:00
drh
f338814455 Autoincrement is now working and has regression tests. (CVS 2095) 
FossilOrigin-Name: 10c712a21961dbc3bff89c49d5ec3b84b9187c80
 2004-11-13 03:48:06 +00:00
danielk1977
9fd2a9a028 Add the "ALTER TABLE xxx RENAME TO yyy" command. (CVS 2092) 
FossilOrigin-Name: a1b2cc63e604785bd51e358ff72c485d858752e3
 2004-11-12 13:42:30 +00:00
drh
2958a4e6a5 Autoincrement code installed. Simple smoke-testing only. No regression 
tests developed yet. (CVS 2091)

FossilOrigin-Name: 8fde833c812b91c5a574208a70b5f92b9d4b0a87
 2004-11-12 03:56:15 +00:00
danielk1977
752e679a1e Have "DEFAULT CURRENT_TIME" & co. work even if SQLITE_OMIT_DATETIME_FUNCS is defined. (CVS 2083) 
FossilOrigin-Name: f81b9c1c022772378aad32ec45d0027beeb36574
 2004-11-09 16:13:33 +00:00
danielk1977
7977a17f06 Port the "DEFAULT CURRENT_TIME" etc. functionality from an earlier fork of sqlite. (CVS 2082) 
FossilOrigin-Name: 0d27c8ff48f327ad82dd5b5b3b47b8d221f119b7
 2004-11-09 12:44:37 +00:00
drh
4343fea20f First cut at a REINDEX command. Basic testing only. No documentation. (CVS 2072) 
FossilOrigin-Name: 11dba47e61279bdf3be6f64a6259b877f3bf6155
 2004-11-05 23:46:15 +00:00
drh
4e0cff6080 More use of sqlite3NestedParse. This version of the code does not work. (CVS 2060) 
FossilOrigin-Name: ac2d5a605c873cac68bfde4bbe3797608a47b21e
 2004-11-05 05:10:28 +00:00
drh
205f48e635 Incremental check-in of changes that will ultimately lead to a 
working autoincrement. (CVS 2056)

FossilOrigin-Name: 10c3d88305e404b9e4cc4eef0b8e5dc7864a5937
 2004-11-05 00:43:11 +00:00
drh
a71aa00102 More work on optionally removing unused features at compile-time. (CVS 2049) 
FossilOrigin-Name: a82980fd70285820c64b42393ef85a9e21addc5d
 2004-11-03 13:59:04 +00:00
drh
52fb6d71f5 The makefile now runs mkkeywordhash.c. Keywords that are unused are 
omitted from the keyword hash table. (CVS 2045)

FossilOrigin-Name: 007aec11333432e08d1091b728773011e9078bc3
 2004-11-03 03:59:57 +00:00
drh
b7f9164e98 Insert #ifdefs that can optionally remove features at compiletime resulting 
in a database engine with a smaller footprint. (CVS 2034)

FossilOrigin-Name: be661acfa849bb0d5692797dd221f5a8a457f8ad
 2004-10-31 02:22:47 +00:00
drh
74ad7fe980 Additional parser optimizations. (CVS 2010) 
FossilOrigin-Name: 618dee121e41d8e5c9b4d5c167475b11ddcda2d7
 2004-10-07 03:06:28 +00:00
drh
2e3a1f16b6 Size optimization in the parser. (CVS 2004) 
FossilOrigin-Name: 8e2ae2449882f70fe4e77c100193c053d7669ae6
 2004-10-06 14:39:28 +00:00
drh
684917c269 Add support for DEFERRED, IMMEDIATE, and EXCLUSIVE transactions. (CVS 2000) 
FossilOrigin-Name: 81ff8107ad63113782cf5a9ba7a512496114ba08
 2004-10-05 02:41:42 +00:00
drh
9a43267ba2 More changes to take advantage of the TK_ and OP_ alignments to avoid 
unnecessary translations. (CVS 1999)

FossilOrigin-Name: e8e972ba65fc36171f6b685e8a8f67f93452e031
 2004-10-04 13:38:09 +00:00
drh
f2bc013c70 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)

FossilOrigin-Name: 4c817e3f293a9c1365e632f7dc13ae440263332a
 2004-10-04 13:19:23 +00:00
drh
596bd23554 Correctly parser column typenames that contain more than one identifier. 
Ticket #934. (CVS 1990)

FossilOrigin-Name: 85ad18712d2bd2b4322ceb617f33c265c1933240
 2004-09-30 14:22:47 +00:00
drh
10e8266b91 Remove unused CLUSTER keyword from the parser. (CVS 1986) 
FossilOrigin-Name: 54ee1664aaaa1a3380009b5206a0fa79cd286fc5
 2004-09-25 15:29:09 +00:00
drh
94a11211f5 Code simplifications and size reductions. (CVS 1983) 
FossilOrigin-Name: cb631a135da92fd689ee40a8b7e2695a510eb765
 2004-09-25 13:12:14 +00:00
drh
fa6bc0000f 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)

FossilOrigin-Name: 435b3f301fbb6953adc974c7f03589b06e9114c3
 2004-09-07 16:19:52 +00:00
drh
2c6674cf7e Host parameter names conform to SQL-2003. (CVS 1902) 
FossilOrigin-Name: fd584d1ccf6643b723c2ff0a7a16c2aea3f1142c
 2004-08-25 04:07:01 +00:00
drh
895d747226 Add support for named wildcards in SQL statements. (CVS 1897) 
FossilOrigin-Name: d3be0b7c5a39c02b9b2d6d85f1595d591984a569
 2004-08-20 16:02:39 +00:00
drh
7ac25c7510 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)

FossilOrigin-Name: 28215096e0748b5b02776ddb4c964e0161bc0f16
 2004-08-19 15:12:26 +00:00
drh
feac5f8dbc Add the ".import" command to the command-line shell. (CVS 1873) 
FossilOrigin-Name: b56afe640f7f3f2837120e3dd923c529c4a3123a
 2004-08-01 00:10:45 +00:00
drh
25d6543de5 Fix bugs associated with the codec. (CVS 1846) 
FossilOrigin-Name: b0a3becd82b9a4203c23f35dc5a5fd725e046f21
 2004-07-22 15:02:25 +00:00
drh
0bb132bedc Lemon collapses common destructors and reduce actions into a single case. (CVS 1837) 
FossilOrigin-Name: 3c5aa850eeec5c75c5200a3707852cc5fc9e780b
 2004-07-20 14:06:51 +00:00
danielk1977
96fb0dd55a Coverage tests for vacuum.c (CVS 1776) 
FossilOrigin-Name: 152e9940b919a53fcd0da4091dbf75ab8ef15b38
 2004-06-30 09:49:22 +00:00
danielk1977
91cf71b01f Remove default_synchronous and temp_store pragmas. Allow the safety-level 
and cache-size to be set for attached databases. (CVS 1735)

FossilOrigin-Name: 212de3ce66f746036cb2267a9f924fd55fa2f37a
 2004-06-26 06:37:06 +00:00
danielk1977
0202b29ef7 Some progress on user-defined collation sequences. (CVS 1544) 
FossilOrigin-Name: c634e71f1909819fb55c728bc410e5cc390428e3
 2004-06-09 09:55:16 +00:00
drh
80242055e5 Start all transactions and verify all schema cookies near the beginning of 
of each vdbe program. (CVS 1543)

FossilOrigin-Name: 1086196460e261718e78512d77e25dde021a117d
 2004-06-09 00:48:12 +00:00