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
11,632 Commits 1,785 Branches 392 Tags
optimize-delete
Commit Graph

125 Commits

Author SHA1 Message Date
drh
e4bf4f08c0 Add requirements marks. No code changes. 
FossilOrigin-Name: 5e0d43ab55de006b20c58cb18b938d1c7b658e51
 2013-10-11 20:14:37 +00:00
drh
95a7b3e36d The date and time functions use the exact same notion of "now" for every 
invocation within the same call to sqlite3_step().

FossilOrigin-Name: daf6ba413cb3cb6065774ba07495eab4a28b49b0
 2013-09-16 12:57:19 +00:00
drh
3170225f19 The date/time functions return NULL if the xCurrentTime or 
xCurrentTimeInt64 VFS methods fail.
Ticket [0b803bff856c644c]

FossilOrigin-Name: c96651dd6ceadd51c9e1f4d942177d3c128c47b4
 2011-10-12 23:13:43 +00:00
drh
df3aa16e2b Fix some harmless compiler warnings that were occurring with THREADSAFE=0. 
FossilOrigin-Name: 9b191bb4c7c1e1b12b188c0b3eee1f8f587887c8
 2011-06-24 11:29:51 +00:00
drh
1f93a08070 Give the osLocaltime() function file scope in date.c. 
FossilOrigin-Name: 1577484595b5e5aab93722d76b273c911a04dc2c
 2011-06-21 15:54:24 +00:00
dan
0d37f58184 Initialize a variable introduced as part of the fix for [bd484a090c8077] in order to silence a compiler warning. 
FossilOrigin-Name: 6b9877fa43bf29a9740285f0c40a6e6cf21f8190
 2011-06-21 15:38:05 +00:00
drh
a924acad0f Rework the localtime logic yet again in order to make all branches reachable 
and to follow GNU standards for HAVE_LOCALTIME_R-type macros.
Ticket [bd484a090c8077].

FossilOrigin-Name: 176248095b8056443ebcbff819e575bd100f5e50
 2011-06-21 15:01:25 +00:00
drh
8720aeb564 Simplifications to the localtime() interface. Fix the case where 
localtime_r() is available so that it works.  Ticket [bd484a090c8077].

FossilOrigin-Name: 5b68dae320d0fa3dc433826811e5018a47461de7
 2011-06-21 14:35:30 +00:00
dan
7c8b355e65 Change the error message returned when localtime_r() fails to "local time unavailable". 
FossilOrigin-Name: 0e82175fd86f0ca5da90676aaee3118a70264d85
 2011-06-21 13:46:11 +00:00
dan
30ce189dc9 Fix an error made in the previous commit. The parameters to localtime_s() were accidentally reversed. 
FossilOrigin-Name: 97e86ec6df4d893527fe9f43eb46163d9b06416a
 2011-06-21 12:53:14 +00:00
dan
c17d696c14 Return an error if localtime_r() fails within one of the date/time functions. Fix for [bd484a090c]. 
FossilOrigin-Name: 76ae8257efc1df6e20ce5718d4824adbbde423ec
 2011-06-21 12:47:30 +00:00
drh
9339da1f22 Rework the text to numeric conversion routines so that they work with either 
UTF8 or UTF16 and do not require a NULL terminator.  This allowed text to
numeric conversion without reallocating the string.

FossilOrigin-Name: 14eed3a0e0a45c6f2904a3a134aa27c159916f7b
 2010-09-30 00:50:49 +00:00
drh
d5e6e4004b Fix a bug in the computation of the current time for the alternative 
CURRENT_TIMESTAMP functions used when SQLITE_OMIT_DATETIME is defined.

FossilOrigin-Name: e7ded46b5efabe521008d9043dd72bd1ca748316
 2010-05-03 19:17:01 +00:00
drh
b7e8ea2015 Use VFS method xCurrentTimeInt64 instead of xCurrentTime when it is available. 
Provide an implementation of xCurrentTimeInt64 for os_unix.c.

FossilOrigin-Name: ab77b3ae6da3370d8bc3b2c9c0edc723b69f5a95
 2010-05-03 14:32:30 +00:00
drh
2b1e690ff1 Fix the implementation of CURRENT_TIMESTAME and CURRENT_DATE when 
SQLITE_OMIT_DATETIME_FUNCS is defined.

FossilOrigin-Name: eb98265b59db59965b468a7070739921da55efc4
 2010-01-12 19:28:20 +00:00
drh
c81c11f62c Remove the obsolete "$Id:$" RCS identifier strings from the source code. 
FossilOrigin-Name: f6c045f649036958078cb15cd9d5453680c82b0c
 2009-11-10 01:30:52 +00:00
shane
3e82c1d99b Allow specific exclusion of localtime_s() usage on Windows. 
FossilOrigin-Name: 216bcda7d2818efda55849d5cb84aa483bc6429b
 2009-09-22 13:25:00 +00:00
shane
11bb41f878 Fixed some warnings and an assert in the WINCE code when compiling under MSVC. 
FossilOrigin-Name: f42ec993ac9d42ca31305f26b09924108c36d9f4
 2009-09-10 20:23:30 +00:00
drh
dee0e404d6 Changes to facility full coverage testing of util.c. (CVS 6597) 
FossilOrigin-Name: a612299092a48b38c5f9cf430bbcaf41777cbcb3
 2009-05-03 20:23:53 +00:00
drh
7fee360d09 Make sure the 'unixepoch' converter in the date and time functions rounds 
to the nearest millisecond rather than truncating downward to the next
smaller millisecond.  Ticket #3808. (CVS 6512)

FossilOrigin-Name: e6e036b345b130c207716c4b81719b5b7c884a11
 2009-04-16 12:58:03 +00:00
drh
07758962f5 Use integer rather than floating point compuations in converting from julian 
day number to unix-time to avoid round-off errors on Borland compilers.
Ticket #3769. (CVS 6445)

FossilOrigin-Name: c26f97bd857f3ddb15e63216cdd4a00e06d8eac8
 2009-04-03 12:04:36 +00:00
drh
6eb41523f1 Fix the strftime() function so that the %s format can handle dates outside 
of the range of 1901 to 2038.  Ticket #3769. (CVS 6430)

FossilOrigin-Name: a95b843a9251ca9f9a23e8b67c2126f4c297a534
 2009-04-01 20:44:13 +00:00
shane
fbd60f826d Changes to completely remove all floating point ops if SQLITE_OMIT_FLOATING_POINT defined. Note that w/o fp, date/time, round, nan, etc. are all gone or limited in functionality. Updated some of the test scripts to support missing fp and 64-bit functionality. Ticket #3029. (CVS 6250) 
FossilOrigin-Name: 5cef400023205b55152b91441acc78f9cd8d58a9
 2009-02-04 03:59:25 +00:00
drh
c531a22377 Fix a round-off error when moving dates by negative modifier amounts. 
Ticket #3618.  Enhance the "NNN years" modifier to accept fractional
years. (CVS 6220)

FossilOrigin-Name: 86be908c5e77ba2b9ac98e394fa987b443d790f8
 2009-01-30 17:27:44 +00:00
drh
6711002c7b Add testcase() macros for coverage in date.c. (CVS 6209) 
FossilOrigin-Name: 90b42eba8e02402c342e04236148bbd5e4d93eb8
 2009-01-28 02:55:28 +00:00
danielk1977
78ca0e7eb4 When not compiling for an EBCDIC system, use built-in alternatives to the tolowe 
r(), toupper() and other ctype.h library functions. Ticket #3597. (CVS 6196)

FossilOrigin-Name: 1041abd6784d283bebf646c54e93599522f7889d
 2009-01-20 16:53:39 +00:00
drh
7f1e8a071f Do not use long long constants in code. Ticket #3547. (CVS 6048) 
FossilOrigin-Name: 51b3bfc3b9628ca4ec754fa7f23aef7302f890ff
 2008-12-20 13:18:50 +00:00
shane
18e526c16b Work to remove harmless MSVC compiler warnings. (CVS 6013) 
FossilOrigin-Name: 715dcd52c1372c62873cff5db97fdbdfce617808
 2008-12-10 22:30:24 +00:00
drh
1bd10f8a00 Additional work at eliminating silly compiler warnings. (CVS 6010) 
FossilOrigin-Name: ea01d43788a75e39c7f03c22681d1a338d52cf0e
 2008-12-10 21:19:56 +00:00
drh
ea6788322e Never use strlen(). Use our own internal sqlite3Strlen30() which is 
guaranteed to never overflow an integer.  Additional explicit casts to
avoid nuisance warning messages. (CVS 6007)

FossilOrigin-Name: c872d554930ecf221ac2be5f886d5d67bb35288c
 2008-12-10 19:26:22 +00:00
shane
aef3af54dd Removed some harmless compiler warnings and converted some "double" ops to "int" in date.c. (CVS 5997) 
FossilOrigin-Name: 5eb648a0b599c83504b892e2a5cefe6a837d6017
 2008-12-09 04:59:00 +00:00
danielk1977
62c14b3487 Changes to avoid "unused parameter" compiler warnings. (CVS 5921) 
FossilOrigin-Name: 88134322c36b41304aaeef99c39b4ef5b495ca3b
 2008-11-19 09:05:26 +00:00
danielk1977
00e136135e Modifications to avoid unsigned/signed comparisons in various files. (CVS 5914) 
FossilOrigin-Name: 8009220c36635dd9b6efea7dc13281ca9625c40a
 2008-11-17 19:18:54 +00:00
drh
21717ed6f0 Fix the SQLITE_OMIT_DATETIME_FUNCS compile-time option so that it builds 
successfully. (CVS 5815)

FossilOrigin-Name: c3f91645159511250c9f86c2a97d819f0253d182
 2008-10-13 15:35:08 +00:00
drh
f65c76d49c Do not use double unnecessarily in date+time functions. Ticket #3422. (CVS 5776) 
FossilOrigin-Name: b03231323a7f06c736c38ae3c5535d2fd025583f
 2008-10-07 12:32:13 +00:00
drh
106cee5498 Work around an issue with the WINSCW compiler. (CVS 5671) 
FossilOrigin-Name: e333c3f4c3629dba05b58318e2cd0514843e5394
 2008-09-03 17:11:16 +00:00
danielk1977
075c23af26 Begin adding support for the SQLITE_OMIT_WSD macro. Some (many) WSD variables still need wrappers added to them. (CVS 5652) 
FossilOrigin-Name: 573d92abb9adb1c321ebc2fcadcf14374213b093
 2008-09-01 18:34:20 +00:00
drh
777c5386c3 Move date+time functions to start-time initialization. Additional 
start-time function cleanup. (CVS 5585)

FossilOrigin-Name: 80d6a31cb3851704c09ac9d99fe4bc241df3c180
 2008-08-21 20:21:34 +00:00
drh
633e6d57d9 Implement the "lookaside" memory allocation cache. Use of this cache makes 
the speed1.test script run about 15% faster.  Added new interfaces to
control the cache. (CVS 5488)

FossilOrigin-Name: e48f9697e9fea339e150ddc32940760027dd07d9
 2008-07-28 19:34:53 +00:00
drh
66cccd9b24 Add an SQLITE_OMIT_LOCALTIME around the "utc" modifier in date/time functions. (CVS 5483) 
FossilOrigin-Name: 71486e93b274b7ca954314dd3e4146192a8b6d79
 2008-07-25 16:39:24 +00:00
danielk1977
59f8c08ecc Implement the 'CONFIG_SINGLETHREAD' and 'CONFIG_MULTITHREAD' configuration modes. (CVS 5234) 
FossilOrigin-Name: 5059644c4bc5f6679afd939e0bc26080f42a9918
 2008-06-18 17:09:10 +00:00
drh
e5ae5735c0 Continuing work on the new memory allocation subsystem. 
Added routines for temporary memory allocation.  Right the btree
balance mechanism to only do one temporary allocation at a time. (CVS 5220)

FossilOrigin-Name: 65fe7b62cfe7d11cd667681a64c96fe7b2fe5685
 2008-06-15 02:51:47 +00:00
drh
85f477a141 Convert the date/time functions to work with milliseconds since the 
julian epoch internally (instead of days since the epoch) in order to avoid
problems with floating-point roundoff error.  The interface is unchanged. (CVS 5215)

FossilOrigin-Name: ed35f8a98323dadb64b423615287fb24ea262ffb
 2008-06-12 16:35:38 +00:00
drh
3af5d685d7 Avoid unnecessary float->text->float conversions in date/time processing. 
This change necessary to reproduce the problem reported by BareFoot. (CVS 5213)

FossilOrigin-Name: 6ec4d7653b1e67ba0951e909ee23fe774762d646
 2008-06-12 13:50:00 +00:00
drh
66147c9715 Add the ability to disable the "localtime" modifier in the date/time 
functions.  This might be necessary for systems that do not support
localtime_r() or localtime_s(). (CVS 5212)

FossilOrigin-Name: 12f3ba11e72b2310abf51d040d5344c81fe5ebd3
 2008-06-12 12:51:37 +00:00
shane
b8109ad375 Updated to use localtime_s() in Windows build environments that support it. Ticket #3126. (CVS 5164) 
FossilOrigin-Name: 1518827e48bc3a259b6079a5a4b8dca47b265172
 2008-05-27 19:49:21 +00:00
drh
bb4957f858 Initial implementation of per-connection limits and the sqlite3_limit() API. 
The sqllimits1.test script crashes.  SQLITE_LIMIT_PAGE_COUNT and
SQLITE_LIMIT_VDBE_OP are currently ignored. (CVS 4897)

FossilOrigin-Name: 60c77882b2de9f6a45f8bd87c9c6a0cc613f8373
 2008-03-20 14:03:29 +00:00
drh
fa4a4b9159 Add a new interface, sqlite3_context_db_handle(), that returns the database 
connection pointer for an application-defined function. (CVS 4889)

FossilOrigin-Name: 54c55cae556af5a16c0ce8be1a96d2932db80ad8
 2008-03-19 21:45:51 +00:00
drh
8257f0c1da Use the xCurrentTime method of the default VFS instead of stdlib time() to 
get the current time when compiling with SQLITE_OMIT_DATETIME_FUNCS. (CVS 4887)

FossilOrigin-Name: 73fbac7cf7b61b23831f62b996fbdd358695b473
 2008-03-19 20:18:27 +00:00
drh
1cfdc90b43 Accept "Z" as the zulu timezone at the end of date strings. (CVS 4805) 
FossilOrigin-Name: 4c9a7b42b797f42f2b1e2e8d6a260044bd22ef2d
 2008-02-21 20:40:43 +00:00