database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-11-09 14:21:03 +03:00
Code Activity
29,836 Commits 1,607 Branches 185 Tags
json-opt
Commit Graph

19158 Commits

Author SHA1 Message Date
drh
ba21256f98 Remove unused code and tighten existing code to make the library a little 
smaller. (CVS 1168)

FossilOrigin-Name: 34a6b7416c6c9bcdf301f5e7b072a0362a746105
 2004-01-08 02:17:31 +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
912184b0cf Make it safe to call sqliteMalloc() with a request for 0 bytes. Ticket #534. (CVS 1164) 
FossilOrigin-Name: 6c858db2c099c7ba73d72e02b19bf6173620db13
 2004-01-07 03:41:03 +00:00
drh
c5dd9fa8ab Preserve the HH:MM:SS for most date/time modifiers. Ticket #551. (CVS 1163) 
FossilOrigin-Name: 70df32b716b0d6a4f72bb3ae6496431e53733b6a
 2004-01-07 03:29:16 +00:00
drh
384eef32fd Use "long double" to hold intermediate values when doing ascii to binary 
and binary to ascii conversions of floating point numbers. (CVS 1162)

FossilOrigin-Name: 8371f662d22be0a3c58e0503c7511faea1640955
 2004-01-07 03:04:27 +00:00
drh
133cdf6eba Add a typecast to work around a bug in the Metrowerks Code Warrior compiler. 
Ticket #553. (CVS 1161)

FossilOrigin-Name: 4146f8cc3ff5339b5685e9c5121888ae08ee0807
 2004-01-07 02:52:07 +00:00
drh
202b2df74a Fix problem in the code generator were incorrect code was being created if 
the SQL source contained a negative integer that was too large to fit in
a 32-bit signed integer variable.  Ticket #552. (CVS 1157)

FossilOrigin-Name: b8381d9fe99273507e8626638110646801afef06
 2004-01-06 01:13:46 +00:00
drh
e807febbc2 Add the sqlite_current_time variable for testing purposes. (CVS 1156) 
FossilOrigin-Name: 23fa407d50741bc0719259792398f28c1d0f12c2
 2004-01-06 00:44:24 +00:00
drh
7739630451 Avoid an assertion fault that can occur with invalid UTF8 on the LENGTH() 
function.  Ticket #548. (CVS 1154)

FossilOrigin-Name: 7080fc39eaf98ef7a7d1c1819603f67841f35c72
 2004-01-02 13:17:48 +00:00
drh
4ec2e9612f Remove unused code from the integrity_check logic. Ticket #545. (CVS 1153) 
FossilOrigin-Name: ee51e205fb6ef412db6a46077e8bc1554aadcca1
 2004-01-01 12:33:43 +00:00
drh
cf64d8b820 Fix a bug in the SQLITE_PROFILE conditional compilation. (CVS 1152) 
FossilOrigin-Name: 597b33f696c0cde84529cd06a8f95a8ccc8f1e8e
 2003-12-31 17:57:10 +00:00
drh
89ef0eeb9b Fix for ticket #542. (CVS 1151) 
FossilOrigin-Name: 458cfa5ba82f2d676e398437a4b1d26d77582d10
 2003-12-31 17:25:47 +00:00
drh
07fa2a60ea Fix a bug (ticket #541) introduced by the previous check-in ((1149)). (CVS 1150) 
FossilOrigin-Name: 646244008fb8a6eef4169291d75da59fa1ab26f9
 2003-12-31 16:00:19 +00:00
drh
dff7ec2cbd Reduce the randomness in the sqliteRandomSeed() routine in order to silence 
bogus errors from valgrind.  Tickets #535 and #536. (CVS 1149)

FossilOrigin-Name: cfe0acf9ec6c89f1e77b8be7dcc23029984de1ce
 2003-12-31 13:21:18 +00:00
dougcurrie
ae53418df4 minor edits for new date.c with mingw/msys on Windows (CVS 1148) 
FossilOrigin-Name: 9392c514501be333a3c22b552dc036e083eb22b4
 2003-12-24 01:41:19 +00:00
drh
f586aa8b96 Update date/time functions so that they correctly handle NULL arguments. (CVS 1147) 
FossilOrigin-Name: a5a5fbd60153dd068ec2559455146e84da075b90
 2003-12-23 16:34:12 +00:00
drh
7091cb0566 Add localtime<-->UTC conversions to the date functions. (CVS 1146) 
FossilOrigin-Name: 8482b8c44766e7f80fc449b3dbdd3f37396c332b
 2003-12-23 16:22:18 +00:00
drh
90f405e3ba Test functions tolerate an "0x" before a pointer value. Ticket #452. (CVS 1145) 
FossilOrigin-Name: c6c5e07b65ae1c30117f0276a1002d5036697cf1
 2003-12-23 03:06:23 +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
2fd2fa0851 Fix some minor problems with the new test4.c module used for doing thread 
testing. (CVS 1142)

FossilOrigin-Name: 952924084aac4a7fa84a7cb7aaac869d35db1896
 2003-12-20 04:00:52 +00:00
drh
f93e41442e Remove a comma at the end of an enum definition. Some compilers could not 
deal with it. (CVS 1140)

FossilOrigin-Name: b1890a5b9c1222086b3aae92e49eb090a17a6492
 2003-12-19 12:32:45 +00:00
drh
acf01e7ddd A better fix for ticket #530 - one that is likely to work on unix 
implementations in addition to linux.  Also more tests for multi-thread
locking added. (CVS 1138)

FossilOrigin-Name: 7dddbeb586504de30c64a1e61614da447f18c8ba
 2003-12-19 08:40:22 +00:00
drh
a6064dcf3b Add new thread-testing code and fix locking under Linux threads. Ticket #530. (CVS 1137) 
FossilOrigin-Name: b36a4bb61094d539273c21a9e4042384f10a7806
 2003-12-19 02:52:05 +00:00
drh
acf4ac96e3 Make sure the pagers in-memory cache states in sync with the disk file. 
Ticket #529. (CVS 1133)

FossilOrigin-Name: da00efb13fe8ccf1c27e4e1193df6b53de9463f4
 2003-12-17 23:57:34 +00:00
drh
4be295be07 Improvements to the way PRAGMA integrity_check works. More likely to output 
userful information when given a corrupt database. (CVS 1132)

FossilOrigin-Name: b92c31d6c138f9462730cecfe14f7dde19778e79
 2003-12-16 03:44:47 +00:00
drh
256ada0fda Fix a bulk-memory initialization problem in the expression list logic. (CVS 1130) 
FossilOrigin-Name: d6549954408b01e5eaf865b9100739c94de28f16
 2003-12-10 03:13:43 +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
447623d9aa Fail an ATTACH if the auxiliary database is locked. Ticket #514. (CVS 1127) 
FossilOrigin-Name: ac428c8d4a731678cc26cf198689814a8a56d141
 2003-12-06 22:22: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
drh
3a6629d27e Use sqlite_freemem() instead of free() in the shell. Windows needs this. 
(Unix does not care.)  Ticket #444. (CVS 1125)

FossilOrigin-Name: e5e6a8481b2225e826c8e890ddc44f06759fe72b
 2003-12-04 20:51:41 +00:00
drh
4925ca00a3 Disallow temporary indices on persistent tables. (CVS 1122) 
FossilOrigin-Name: 72bf73b2c1e3594aa85920e47fc345bba56c80d0
 2003-11-27 00:48:57 +00:00
drh
0a5294bc06 Fix a typo in a #define that was commented out. No impact to working code. 
Ticket #476. (CVS 1119)

FossilOrigin-Name: 21c2f96e814004d00691e3d7a632f193b0e49ee5
 2003-11-11 23:30:35 +00:00
drh
7014aff37d Revised date/time functions - now broken out into a separate source file. 
See the DateAndTimeFunctions wiki page for additional information. (CVS 1116)

FossilOrigin-Name: 68ef9b45bd3abdedf3721011ad0fb22e8735e721
 2003-11-01 01:53:53 +00:00
drh
8548a059ff Comment changes to the lemon parser template. Change some sqliteMalloc() calls 
to sqliteMallocRaw() for speed.  Update the website template. (CVS 1114)

FossilOrigin-Name: c637caf13f579959ecdb6b134d0114e8efbcac60
 2003-10-22 22:15:27 +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
4df92bbd44 Update to the date functions. (CVS 1110) 
FossilOrigin-Name: 06d4e88394217fb1390b069bad82d6ac71981f72
 2003-10-10 02:09:56 +00:00
drh
191c0323c0 Allow quoted trigger names. Ticket #468. (CVS 1109) 
FossilOrigin-Name: 54aa0fb236d17b53b194a667d68c71007c8e7687
 2003-10-03 00:13:38 +00:00
drh
319e4e7484 All LIKE and GLOB operators to use function notation. "A LIKE B" can be 
expressed as "LIKE(B,A)". (CVS 1108)

FossilOrigin-Name: 95b27ebd1322a877112dee514dffddb0937e45fa
 2003-09-30 01:54:13 +00:00
drh
dab3518880 Remove support for the Oracle8 outer join syntax. (CVS 1106) 
FossilOrigin-Name: 824430b3ce435386b83ceb882f1510ac9f27d8fa
 2003-09-27 13:39:38 +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
562528c480 Do all WHERE clauses tests, even if an index is used for lookup so that 
we know the test cannot be FALSE.  The test might end up being NULL in which
case it would need to be treated as false.  Ticket #461. (CVS 1103)

FossilOrigin-Name: 5aea81488b2d3bcdc009ccf0f0ffcda046e38d79
 2003-09-27 00:41:27 +00:00
drh
f911221a1e A failed malloc() could have resulted in a segfault. Fixed by this check-in. (CVS 1102) 
FossilOrigin-Name: 4bb256ee3ecd44d71d90556e16bb56c0389fd5b5
 2003-09-23 10:25:32 +00:00
drh
61b487d02a The tokenizer should never return a negative size of the next token. 
Ticket #453. (CVS 1098)

FossilOrigin-Name: 4fbca3ab09596c530da7c50657f3bc9140178dd5
 2003-09-12 02:08:14 +00:00
drh
82a4851a4b Add initial test cases for the new sqlite_bind() API. Fix bugs that the new 
test cases found. (CVS 1096)

FossilOrigin-Name: f6c4908e9b5b6ac9adc4af50dc5110dbb655dae3
 2003-09-06 22:45:20 +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