1
0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-07 02:42:48 +03:00
Commit Graph

9695 Commits

Author SHA1 Message Date
kwel
c7e22ee254 Added tests to exercise delete, insert, and update triggers on views (tkt #1169) (CVS 2444)
FossilOrigin-Name: 6cd19ddcba5fbea1be04b44699c911294618e948
2005-04-08 19:48:27 +00:00
danielk1977
55c45f2e1e Apply Tcl 'nullvalue' patch from Stefan Finzel. (CVS 2441)
FossilOrigin-Name: 9906ae37b9be684b615a1190cf8798513baa799a
2005-04-03 23:54:43 +00:00
drh
495c09a49a Make the ORDER BY clause return equal elements in the same order they were
seen (a stable sort).  It was returning them in exactly the reverse order. (CVS 2439)

FossilOrigin-Name: e8391491a68018406e30c2a699a4cab9e0de092c
2005-04-01 10:47:40 +00:00
drh
f4f8fd51e4 Make sure integer primary keys larger than 2^31 are handled
properly.  Ticket #1188. (CVS 2436)

FossilOrigin-Name: 1d04c2ab299430959b8a193d4679cbc4c0be31a4
2005-03-31 18:40:04 +00:00
danielk1977
bc04f8529d Reduce the space allocated for the runtime virtual machine stack. (CVS 2428)
FossilOrigin-Name: 7d6818da33a87076d1faf35ffc15a3aada0533b3
2005-03-29 08:26:13 +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
drh
92fd9d285f Changes to alter3.test to allow it to work with a codec. (CVS 2423)
FossilOrigin-Name: 9e856bab2bbb77004b049827b4a275aa6c48096b
2005-03-28 16:50:22 +00:00
danielk1977
f0b5792bdc Use SQL function substr() correctly from ALTER TABLE code. Ticket #1182. (CVS 2420)
FossilOrigin-Name: ccb9f4022b3ccb1cc2ab001628fd38becfbf8efe
2005-03-28 00:07:16 +00:00
danielk1977
b3a2cced6b Correctly allocate new columns array in ALTER TABLE .. ADD COLUMN. Ticket #1183. (CVS 2419)
FossilOrigin-Name: 3c86e63389b286a49106d8d7009cc63e3914d40f
2005-03-27 01:56:30 +00:00
danielk1977
6b456a2b46 Add function to recover from a malloc() failure. (CVS 2414)
FossilOrigin-Name: 1f9d10d7965c95d1e35f64cf4c3f128adabd41f2
2005-03-21 04:04:02 +00:00
drh
38fba69135 Fix an infinite loop in the code generator for INSERT. Ticket #1140. (CVS 2410)
FossilOrigin-Name: 876d09d9145775956913e975c29e81d7553839ac
2005-03-21 01:20:58 +00:00
drh
4cb29b4cfc Allow the character "T" between date and time in ISO-8601 date/time formats.
Ticket #1170. (CVS 2408)

FossilOrigin-Name: 2bf88daa57b01216c7bbe67972f479ee12be1193
2005-03-21 00:43:44 +00:00
drh
ab34b8f65a Fix for ticket #1167 (CVS 2405)
FossilOrigin-Name: d9aa0aa9ae2ca0dec976ba2ae4cd7047132be45b
2005-03-20 23:18:57 +00:00
drh
8aa60cb746 Do not attempt to read the journal file on windows because manditory locking
on windows will not allow it.  Ticket #1166. (CVS 2404)

FossilOrigin-Name: 1865e0d81c827cc879dde96c6a9f42e740b6a560
2005-03-20 22:54:56 +00:00
drh
41712ef171 Tentative fix for ticket #1171. More research and testing needed. (CVS 2402)
FossilOrigin-Name: f0a39cee78472b93cce5304fc255285ddea7d2bf
2005-03-20 19:10:12 +00:00
drh
072192dffa Fixed a typo in alter3.test. (CVS 2396)
FossilOrigin-Name: 698be25d3e8f0eb2b5a4c6c7d20343b3c8a06134
2005-03-17 12:33:14 +00:00
danielk1977
37b69a0130 Don't run the tests in alter3.test if SQLITE_OMIT_ALTERTABLE is defined. (CVS 2395)
FossilOrigin-Name: 800fb3bf06f73af53af57f5b172c85406af374ad
2005-03-17 07:00:55 +00:00
danielk1977
19a8e7e882 Add the ALTER TABLE ... ADD COLUMN command. (CVS 2393)
FossilOrigin-Name: 94185dd4f7e2e941c74a521488d1212a75927218
2005-03-17 05:03:38 +00:00
drh
cb9882a753 Fix a bug in the calculation of the table record header size.
Ticket #1163. (CVS 2389)

FossilOrigin-Name: bf82a04ff7c24a38d45721b3fae69d88d6e83149
2005-03-17 03:15:40 +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
drh
165ffe9708 When creating a new database, delete any preexisting journal that might be
left over from a prior database with the same name.  Ticket #1152. (CVS 2387)

FossilOrigin-Name: 856e2ec9688affbfe496cf184f460b18408e3dc0
2005-03-15 17:09:30 +00:00
drh
ae8b3615ee Allow the database name in a DETACH statement to be quoted.
Ticket #1151. (CVS 2386)

FossilOrigin-Name: 24e887735256499e58dabe90463524d9e6eb08ce
2005-03-15 02:04:12 +00:00
drh
b8ef32c3e8 Be more aggressive about using the busy handler. Ticket #1159. (CVS 2385)
FossilOrigin-Name: 644c6398e52481e5dda87671e1c196b26b1e4990
2005-03-14 02:01:49 +00:00
drh
748f763f7a Fixes so that the FULLSYNC changes will build on windows. They do not have
any effect, but neither do they cause errors. (CVS 2377)

FossilOrigin-Name: ace3e30de1cde2e8990d8429b730ca5b68acd714
2005-03-11 04:41:39 +00:00
drh
b851b2c938 Disable F_FULLSYNC if the sychronous pragma is not set to FULL. (CVS 2372)
FossilOrigin-Name: 58b8733b96165126ee8514f2ce0f88d249792847
2005-03-10 14:11:12 +00:00
drh
cca76c2f7e Disable the use of ./crashtest in builds that include a codec. (CVS 2371)
FossilOrigin-Name: 7e4af62238bf8fa3d3cbc79e2c8951e621a0c0b4
2005-03-10 12:58:21 +00:00
drh
fec8066734 Disable the alter2 tests if there is a codec compiled into the library. (CVS 2370)
FossilOrigin-Name: 06a48da67b142e92624cdfd46947bd4ccc6842b7
2005-03-10 12:52:47 +00:00
danielk1977
5fd057af68 Fix a file corruption bug in CREATE INDEX in auto-vacuum databases. (CVS 2368)
FossilOrigin-Name: 64c4c717d35c8fce9b4be073196c507f6d471188
2005-03-09 13:09:43 +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
drh
97ba4c94fc Print an error message and quit if the regression tests are run as root.
Ticket #1153. (CVS 2366)

FossilOrigin-Name: 9b96078763949a2723482328e7b90c939ba8d2d8
2005-03-02 05:18:57 +00:00
drh
bf21627b6f Add the SQLITE_OMIT_FLAG_PRAGMAS compile-time option. (CVS 2362)
FossilOrigin-Name: c167e9054249361d1f464d3840a5c277e6ed44ab
2005-02-26 18:10:44 +00:00
drh
ccae6026e6 Fix an assertion fault that can occur while autovacuuming a corrupt database
file.  Add the SQLITE_OMIT_COMPLETE compile-time parameter. (CVS 2361)

FossilOrigin-Name: bb0e7e3857a06347b08d93553ac603e737322262
2005-02-26 17:31:26 +00:00
danielk1977
3fdf826699 Fix bug reported on the mailing list for WHERE clauses like (rowid<'2'). (CVS 2357)
FossilOrigin-Name: b323f0f2832ac5d225d880db6f56314d2f766a25
2005-02-22 09:47:18 +00:00
danielk1977
36963fdca8 Support for a future file format that includes 'short' records. (CVS 2351)
FossilOrigin-Name: 173aeb256e2c09098a4392874f8623e8a760d951
2005-02-19 08:18:05 +00:00
drh
75f86a4b0b Compile-time option to limit the size of AUTOINCREMENT rowids to 32-bits. (CVS 2349)
FossilOrigin-Name: c5366deaf5beca9c99558c0f375ba73f817acd92
2005-02-17 00:03:06 +00:00
drh
0f68fd1bd9 Get vacuum working on database that used to have autoincrement tables but
where all such tables have been dropped.  Ticket #1121. (CVS 2344)

FossilOrigin-Name: 8f7c639da0f862fa2dd2f55eb7e4d453cd321540
2005-02-16 03:27:04 +00:00
drh
aee128dc20 Make sure that when a CREATE INDEX fails, it does not leave a residue behind
that can corrupt the database.  Ticket #1115. (CVS 2330)

FossilOrigin-Name: cbed92f397ec13b57771ab8b5be74c0cacf35dfd
2005-02-14 20:48:18 +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
drh
802d69a79c Update the version number in preparation for the release of 3.1.2. (CVS 2325)
FossilOrigin-Name: f3c51de7599ed6d3bcdd227e290ad75829840957
2005-02-13 23:34:24 +00:00
danielk1977
a1cb183d04 Fix a problem with sub-queries and the flattening optimization. Also handle an extra case of database corruption. (CVS 2324)
FossilOrigin-Name: f7858d8830cdd0f57b8f9bc73068d29a7062b8ac
2005-02-12 08:59:55 +00:00
drh
8cbd373ca7 Fix a problem with VACUUM that can lead to database corruption. (CVS 2323)
FossilOrigin-Name: 63894baf1b37156fd0b84eba4c9c5e8f43cee3f3
2005-02-12 00:19:30 +00:00
danielk1977
48af65aeae Add experimental collation_list pragma. (CVS 2321)
FossilOrigin-Name: f73a8aa34afd39e0b7df8f22b5c5d2c8d8979a1b
2005-02-09 03:20:37 +00:00
danielk1977
24c8ab8030 Document SQLITE_DEFAULT_CACHE_SIZE and SQLITE_DEFAULT_TEMP_CACHE_SIZE macros. (CVS 2320)
FossilOrigin-Name: ddcea6f8891b02e64f96591af161feb55c00a72c
2005-02-09 01:40:23 +00:00
danielk1977
4d88778b26 Fix a buggy interaction between "INSERT ... SELECT" processing and optimization (2170). (CVS 2319)
FossilOrigin-Name: c54ad2123693be8777d80343979e3261c4892105
2005-02-08 08:42:27 +00:00
danielk1977
a58fdfb162 Fix for correlated subqueries where the parent is an aggregate. Ticket #1105. (CVS 2318)
FossilOrigin-Name: f0d3ca10c5bccf8fca7143028ebb3e604c0e3f20
2005-02-08 07:50: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
ac17178853 Detect database corruption in rootpage flags (see also (2313)). (CVS 2314)
FossilOrigin-Name: 6d91a1e91bf0e8b4a0f5f78d079031f3ee69603b
2005-02-05 06:49:54 +00:00
danielk1977
6a67fe8edf Remove code for SQL cursors. (CVS 2312)
FossilOrigin-Name: 2eb90870556c90b8d85da3d5eb7554f74ec922c2
2005-02-04 04:07:16 +00:00
drh
62d54916c4 Get AUTOINCREMENT and VACUUM working together. Ticket #1095. (CVS 2311)
FossilOrigin-Name: 332a531d06a610e6597b02105fcda767313f0225
2005-02-03 01:08:20 +00:00
danielk1977
d0a6932f70 Handle "rowid<=X ORDER BY rowid DESC" where X is an integer. Fix for ticket #1092. (CVS 2307)
FossilOrigin-Name: 506088796c846243e24c4cba6be4ce6511fdb345
2005-02-02 01:10:44 +00:00