database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-07 02:42:48 +03:00
Code Activity
30,215 Commits 1,570 Branches 184 Tags
tcl-init
Commit Graph

2168 Commits

Author SHA1 Message Date
drh
79f14b7240 A vdbe stack element might have a string value even after a call to 
Integerify().  Ticket #641. (CVS 1283)

FossilOrigin-Name: 3cac4b7b526d6c5dbf394009b534707bcb65b0da
 2004-03-03 01:51:24 +00:00
drh
eb9a9e8888 Code cleanup in the date and time functions. (CVS 1263) 
FossilOrigin-Name: 9b3bcde1530091602e551435ffd7820eb79727d5
 2004-02-22 17:49:32 +00:00
rdc
b0c374ffbb Fixed behaviour of last_insert_rowid() with triggers and add last_statement_change_count() function that works correctly with triggers. (CVS 1251) 
FossilOrigin-Name: 3383413a53bff0fef0765144de3bb9a298a5bb5c
 2004-02-20 22:53:38 +00:00
drh
d6502758b4 Remove the NullCallback opcode. Handle the empty_result_set pragma inside 
the sqlite_exec() function. (CVS 1244)

FossilOrigin-Name: f72134852bf33d13fd2bc6f35251e4b33bc10fac
 2004-02-16 03:44:01 +00:00
drh
826fb5a3f8 Eliminate obsolete code associated with the older callback functionality. (CVS 1243) 
FossilOrigin-Name: 2dbc4593ca5c1cf75039c8b4471b1e47faa849f0
 2004-02-14 23:59:57 +00:00
drh
8a6ac0adbc Fix problems with malloc-failure handling. (CVS 1241) 
FossilOrigin-Name: 398bc294c839368e7fa75a97ba8cc8d1639f9436
 2004-02-14 17:35:07 +00:00
drh
a1f9b5ee0b The sqlite_exec() function is now implemented using sqlite_compile() and 
sqlite_step().  This opens up lots of opportunity to remove old code. (CVS 1240)

FossilOrigin-Name: 9771ad1e811e02e10bb738550fbea447749083c5
 2004-02-14 16:31:02 +00:00
drh
78a7583828 Fix an uninitialized variable introduced by check-in (1202). (CVS 1235) 
FossilOrigin-Name: 9f149fdc1c6af1c663b91c878ed1903f82f80245
 2004-02-13 14:07:12 +00:00
drh
93581642d2 VACUUM returns SQLITE_INTERRUPT when interrupted. Ticket #593. (CVS 1228) 
FossilOrigin-Name: 2fe9f5101cb0f743532912ece3d37f6c873e7025
 2004-02-12 13:02:55 +00:00
drh
bbd82df617 Refactor the interface to the randomness generator. (CVS 1224) 
FossilOrigin-Name: f2bdccf4bb2f796aafb64c33e55f62a1794d750c
 2004-02-11 09:46:30 +00:00
drh
fb044c1d1c Perform updates in search order. Ticket #602. (CVS 1221) 
FossilOrigin-Name: cf1cec74ae039cd7cbc8a1032d29f067dedb4210
 2004-02-10 13:41:52 +00:00
drh
f603871326 Perpare for the 2.8.12 release. (CVS 1212) 
FossilOrigin-Name: 93ccd1b1d63b5b914b84b0463f2267bcfaadafa3
 2004-02-08 18:07:34 +00:00
drh
f1b07b0ca2 Fix a bug in the VDBE that occurs when a CreateTable or CreateIndex fails. (CVS 1211) 
FossilOrigin-Name: 42cfd541dcc31d1ef92387e3fd2346db61d0ecbd
 2004-02-08 06:17:19 +00:00
drh
3914aed1de Fix a bug introduced by the previous check-in. (CVS 1205) 
FossilOrigin-Name: 04cf22785e68fcd4098e6c10a89386108cd0bf07
 2004-01-31 20:40:42 +00:00
drh
2c79c67fcb A few more optimizations to the VDBE. (CVS 1204) 
FossilOrigin-Name: 06e7ff4cb8c73fd690c6d5b5f530a30d83f4f10c
 2004-01-31 20:20:29 +00:00
drh
6810ce677d Rework internal data structures to make the VDBE about 15% smaller. (CVS 1203) 
FossilOrigin-Name: 8273c74bd09d1a044cb5154498b0a39939f6e3ed
 2004-01-31 19:22:56 +00:00
drh
00706be366 Rework the VDBE data structures to combine string representations into the 
same structure with integer and floating point.  This opens the door to
significant optimizations. (CVS 1202)

FossilOrigin-Name: c0faa1c67a967f028cd018e58988fb08bc814d3d
 2004-01-30 14:49:16 +00:00
drh
aa940eacfe Reinsert the experimental sqlite_commit_hook() API. (CVS 1179) 
FossilOrigin-Name: 72bc84f2f18f6eeb279a4ad670310e85d154f663
 2004-01-15 02:44:03 +00:00
drh
751f41217e Fix comparisons of ROWID against floating point numbers so that they work 
correctly.  Ticket #377 and #567. (CVS 1178)

FossilOrigin-Name: c9ac3db8e08403398ec344757385334601a59374
 2004-01-14 21:59:22 +00:00
drh
143f3c45a7 Rework the fix to ticket #461 so that we do not have to do redundant tests 
of WHERE clause terms looking for NULLs.  See also check-in (1103). (CVS 1167)

FossilOrigin-Name: 5fd581787e88173f0303f870fc956ec9285cca4e
 2004-01-07 20:37:52 +00:00
drh
d1d9fc3397 Permit sqlite_exec() to be called from within user-defined functions. (CVS 1166) 
FossilOrigin-Name: 03636c94a542b1f90a3acfbe65a9c2976872073f
 2004-01-07 19:24:48 +00:00
drh
a11846b77a Defer the {quote: MoveTo} 
opcode in VDBE until the data is actually needed.  Sometimes
the data is never needed, resulting in a performance increase.  On an indexed
order search with a large OFFSET, queries times can be an order of magnitude
faster. (CVS 1165)

FossilOrigin-Name: d3e96da20d269a068188915b3cc0eb02d330d316
 2004-01-07 18:52:56 +00:00
drh
93a5c6bdf4 Use a built-in atof() function instead of the one from the library to 
avoid problems with locale.  Ticket #305. (CVS 1144)

FossilOrigin-Name: 4d9edbc50f7dee64edbadad2e2dc4f93d8248b3b
 2003-12-23 02:17:35 +00:00
drh
0f18bfa789 Fix the code generator to a void a VDBE stack overflow on 3-way joins. 
Ticket #519. (CVS 1129)

FossilOrigin-Name: 230a4ff2c8a3927533baf5b22edc9f25490d5443
 2003-12-10 01:31:21 +00:00
drh
6f8c91caa0 Make the VACUUM command run out of the VDBE like all other commands. 
(Ticket #464).  Make the VACUUM command work even if there are VIEWs
in the SQLITE_MASTER table that come before tables they reference.
(Ticket #515) (CVS 1128)

FossilOrigin-Name: 614cbbafa180469744421f8fbe56cb392f48d05f
 2003-12-07 00:24:35 +00:00
drh
41743984bf Always use "(char*)0" to terminate the argument list of sqliteSetString(). 
This is needed for 64-bit systems that use a 32-bit integer by default. (CVS 1126)

FossilOrigin-Name: 656c90387a4a714b4f31040ece9b0e15e30934af
 2003-12-06 21:43:55 +00:00
danielk1977
348bb5d6c8 Add sqlite_progress_handler() API for specifying an progress callback (CVS 1111) 
FossilOrigin-Name: ddb364635a207658664ea92fc677cf16a143a938
 2003-10-18 09:37:26 +00:00
drh
3775084a75 Add additional backslash escapes to the COPY command for compatibility 
with PostgreSQL.  Ticket #460. (CVS 1104)

FossilOrigin-Name: 70a50bdda318f353c8be1ba200f9aedc34642c93
 2003-09-27 00:56:31 +00:00
drh
7c972dec5c Update Makefile.in for the new vdbeaux.c file. Remove the experimental 
"sqlite_instantiate()" routine and replace it with "sqlite_bind()" which
is more like ODBC and JDBC. (CVS 1095)

FossilOrigin-Name: 990bb11898a539bb0795a4a216fcd989943a0fb2
 2003-09-06 22:18:07 +00:00
drh
9a32464b54 Split almost 1300 lines of code out of vdbe.c into separate files 
vdbeInt.h and vdbeaux.c. (CVS 1094)

FossilOrigin-Name: bfd69391d3d63675f206ffd8ff0401ea1cbcc073
 2003-09-06 20:12:01 +00:00
drh
5045789694 The beginnings of changes to support pre-compiled SQL. Mostly untested, 
though all regression tests to pass. (CVS 1093)

FossilOrigin-Name: 912f47c72d3597c6d5acff765d94922bd660339a
 2003-09-06 01:10:47 +00:00
drh
8460ea0652 Try to work around a bug in VC++ by only passing unsigned characters to 
the isspace() routine.  Bug reported on the mailing list. (CVS 1087)

FossilOrigin-Name: cbe32216966c987902ceb4d85332fc95801dbda2
 2003-08-26 11:35:00 +00:00
drh
9b1b01bb76 Do not delete tables with the same name when dropping triggers. 
Ticket #430. (CVS 1074)

FossilOrigin-Name: ef58f163b08d13f8e9b69459bd83e0bf9d5b404b
 2003-08-16 12:37:51 +00:00
drh
dc2d94de56 In the VDBE, when an integer value will not fit into a 32-bit int, store it 
in a double instead.  Ticket #408. (CVS 1064)

FossilOrigin-Name: 7514c3db165e8cc5c696b2b345844949a0e45a61
 2003-07-27 17:16:06 +00:00
danielk1977
999af643a0 Add experimental sqlite_reset() API (allows pre-compiled queries) (CVS 1060) 
FossilOrigin-Name: 1d2fcb017811db90e85d63f2ca76867c00ab8f1b
 2003-07-22 09:24:43 +00:00
drh
073e5a7751 Allow the output arguments in sqlite_compile and sqlite_step to be NULL 
pointers.  Tickets #384 and #385. (CVS 1049)

FossilOrigin-Name: dd84f88f6c4012e4a093a4881f6fe50527bb2006
 2003-07-09 00:28:13 +00:00
drh
1dd59e0f94 Correctly handle comparing an INTEGER PRIMARY KEY against a floating point 
number.  Ticket #377. (CVS 1045)

FossilOrigin-Name: 982aa3356bcc217003cd9e6a829619219c334797
 2003-07-06 17:22:25 +00:00
drh
dc339ee29c The prior fix of ticket #360 was incorrect and caused a memory leak. This 
check-in plugs the memory leak and correctly fixes ticket #360. (CVS 1040)

FossilOrigin-Name: fc490f677b89e623b41f9e7f5f3bade9b981562c
 2003-06-29 20:25:08 +00:00
drh
d60ccc6a75 In a SELECT, the rowid of a view or subquery which is really a join is 
set to NULL if the join is flattened.  Ticket #364. (CVS 1034)

FossilOrigin-Name: bad8b55833f5120003a19883154dac5146cc36a3
 2003-06-24 10:39:46 +00:00
drh
8ce10ba65e Make sure the source of a PULL opcode is not an ephemeral string. Ticket #360. (CVS 1031) 
FossilOrigin-Name: cb70ee67ea9f5a47d58820e0e8b28c8f945217ed
 2003-06-22 01:41:49 +00:00
drh
ed717fe3b2 Enhance the "PRAGMA integrity_check" command to verify that all indices are 
correctly constructed.  New calls to integrity_check are made in the test
suite. These changes are intended to prevent any future problems such
as seen in ticket #334. (CVS 1024)

FossilOrigin-Name: c9734c27074d2039a1896a8c6965c08d03711b13
 2003-06-15 23:42:24 +00:00
drh
6f8fd3c171 Use sqliteOsFileExists() in the debugging hook in vdbe.c, instead of access(). 
Ticket #341. (CVS 1014)

FossilOrigin-Name: 7d3405b95bae74e0c476a7bdf708ca518723eaf7
 2003-06-07 11:33:45 +00:00
drh
7d02cb73ca Fix a bug in UPDATE OR REPLACE that was introduced by check-in (999). 
Also clean up some compiler warnings for VC++. (CVS 1005)

FossilOrigin-Name: af6f2bdf59fb621ff3e1d061e429f01ebd7d0b42
 2003-06-04 16:24:39 +00:00
drh
1aa4965ae3 The OP_Checkpoint opcode is now a no-op if invoked on a database that already 
has an active checkpoint journal.  Ticket #333. (CVS 997)

FossilOrigin-Name: daf7b94017f03638da1ef65830f3762be030b93c
 2003-06-02 23:14:13 +00:00
jplyon
5a56422a29 Additions and corrections to vdbe documentation comments. (CVS 992) 
FossilOrigin-Name: b648987de3383d6835df58aa0efee54fa8f10d26
 2003-06-02 06:15:58 +00:00
drh
8bf8dc9208 Fix problems with TEMP indices that lead to corrupt databases. These 
problems were discovered while working on ticket #317.  No sure yet if
that ticket is fixed. (CVS 981)

FossilOrigin-Name: 01398fb78bab7e5c6f439f2b743f26e82118468a
 2003-05-17 17:35:10 +00:00
drh
5fe2d8c913 Changes to comments. In particular, a lengthy comment was added to encode.c 
that explains how the encoder algorithm works. (CVS 966)

FossilOrigin-Name: 8b388b2f690dbfd50eefc0fdede1c7785f78afa1
 2003-05-10 03:36:53 +00:00
drh
6a3ea0e6ef VDBE cursors numbers for tables in a join do not have to be consecutive. 
This is one step on the road to fixing ticket #272. (CVS 947)

FossilOrigin-Name: be7aed2011b4af868b6a0c370c3d41354ae0cdf4
 2003-05-02 14:32:12 +00:00
drh
2e6d11bc07 Add tests to insure VACUUM works in the presence of I/O errors. Fix some 
problems that came to light by these tests. (CVS 935)

FossilOrigin-Name: 8d3e879349fc9523c72cb46111e0058b57ce9341
 2003-04-25 15:37:57 +00:00
drh
b5a20d3ceb Remove the begin_hook and commit_hook APIs. They were a bad idea. Add a 
"trace" method to the TCL interface. (CVS 929)

FossilOrigin-Name: 6289b863590ecc5de3d1efaaa60aa6f3f64fefb3
 2003-04-23 12:25:23 +00:00