1dcafe1ad8
CVS missed a commit (because I pressed Ctrl-C in the middle). This
...
extra commit will hopefully help clear things up. (CVS 1091)
FossilOrigin-Name: 522c2efeb5bdccadf3306234d458425b94cdbbe3
2003-08-27 22:57:07 +00:00
0d4f801c28
Add locks to the in-memory database so that recursive writes will be detected
...
and rejected. Ticket #436 . (CVS 1090)
FossilOrigin-Name: 966b1a16f6687df08f8c21787c1c8b1af1d79e1e
2003-08-27 22:52:34 +00:00
ec1bd0bd72
Fix compiler warnings under OpenVMS. Ticket #357 . (CVS 1088)
...
FossilOrigin-Name: c95f347cac27732533a2f6fd4ba50bf00eef59f3
2003-08-26 11:41:27 +00:00
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
03ab7336cd
Fix a bug in sqliteRealloc() that only occurs if there is memory corruption
...
and debugging is enabled. Ticket #421 . (CVS 1086)
FossilOrigin-Name: eebc82b77dbf35a18d2eae47336038d4b67806c6
2003-08-26 11:29:07 +00:00
901afd4341
If the database filename is an empty string, open a temporary file to hold
...
the database. Ticket #432 . (CVS 1085)
FossilOrigin-Name: da53369f0bf133b89b213bbb1ccea13eb93ab6ed
2003-08-26 11:25:58 +00:00
3ca65151d5
Fix a bug in the new "pk" column of the table_info pragma that was added
...
by check-in (1081). (CVS 1082)
FossilOrigin-Name: ad7b017a1277c00b356343b36ade565baf404d6a
2003-08-24 16:38:17 +00:00
78100cc928
Add a "pk" column to the table_info pragma which is true for each column
...
that is part of the primary key. Add a "foreign_key_list" pragma that gives
information about all foreign keys for a table. Both changes are experimental. (CVS 1081)
FossilOrigin-Name: 5232b0665b84a9339a85918570093a376a0ea91f
2003-08-23 22:40:53 +00:00
4739470341
Add the experimental "quote()" function to the set of build-in functions. (CVS 1077)
...
FossilOrigin-Name: 9699c68508db5da6238904e518835a629d430db6
2003-08-20 01:03:33 +00:00
5d9d757626
Add the "onecolumn" method to the TCL language bindings. (CVS 1076)
...
FossilOrigin-Name: c7b4c28fbc0bca5645af5750fd353f4eca400b40
2003-08-19 14:31:01 +00:00
e5e3760e1c
Make the compile work under cygwin.
...
Tickets #327 , #213 , #316 , #322 , #349 , #373 , and #429 . (CVS 1075)
FossilOrigin-Name: 7d8d3252df1e9f6bec5e105b6eca3313cb7e226a
2003-08-16 13:10:51 +00:00
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
8e18bac793
Fix a segfault that occurs in the VACUUM command if run on an empty database
...
with the EMPTY_RESULT_CALLBACKS pragma enabled. Ticket #427 . (CVS 1073)
FossilOrigin-Name: 3563e9cf9d6b20f09e92deb21fdda93bcd8fb583
2003-08-15 13:24:51 +00:00
41a8230fef
Make the sqliteOsCurrentTime() function work for Windows. Code contributed
...
by "e4liberty" on the mailing list. (CVS 1071)
FossilOrigin-Name: 02fac304c9ec9012f3cc4f04d2c4cac5e37b0024
2003-08-10 16:16:22 +00:00
87adaa9a99
tighter coding of the date and time functions. Better comments. A bug fix. (CVS 1070)
...
FossilOrigin-Name: 94243edac14b90ef898093b85e1959c20fa23ae9
2003-08-10 01:50:54 +00:00
771d8c3bae
Add experimental date and time functions based on julian day number. (CVS 1069)
...
FossilOrigin-Name: a6197e2075fdf9db862484255ac16b2855bbef0a
2003-08-09 21:32:28 +00:00
37ed48ed2f
Provide a more informative error message when a uniqueness constraint
...
fails. Ticket #419 . (CVS 1068)
FossilOrigin-Name: 086aa1c9922b7bf399b3ee8b73ba7353d126b119
2003-08-05 13:13:38 +00:00
4305d10360
The {quote: SrcList} object was not being expanded correctly by a call to
...
sqliteSrcListAppend() if the {quote: SrcList} had previously been duplicated by
a call to sqliteSrcListDup(). Ticket #416 . This check-in fixes that problem
by keeping a separate nAlloc field on {quote: SrcList}. A similar change is made
to {quote: IdList} and {quote: ExprList} to avoid future problems. (CVS 1067)
FossilOrigin-Name: da6273255471673841fdcadc688aeac80722e130
2003-07-30 12:34:12 +00:00
a76c82eb0d
When creating a new journal file, open a (read-only) file descriptor on the
...
directory containing the journal and sync that directory once to make sure
that the journal filename entry gets into the directory. Ticket #410 . (CVS 1066)
FossilOrigin-Name: 09c10fe3c99cffc64ed02c2929f206d99c8e3309
2003-07-27 18:59:42 +00:00
98e3e60012
Make sure the schema loader callback can handle EMPTY_RESULT_CALLBACKS being
...
on. Ticket #406 . (CVS 1065)
FossilOrigin-Name: 8c163fc0c7c721b7a5fa6727b0e90bff4484c782
2003-07-27 17:26:22 +00:00
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
999af643a0
Add experimental sqlite_reset() API (allows pre-compiled queries) (CVS 1060)
...
FossilOrigin-Name: 1d2fcb017811db90e85d63f2ca76867c00ab8f1b
2003-07-22 09:24:43 +00:00
4d87325d61
Make sure temporary file names in windows have a full 15 characters of
...
random text at the end. (CVS 1059)
FossilOrigin-Name: 6ccb92b14f2e6e01bb60dac10331fa7be0b4525e
2003-07-22 00:39:13 +00:00
7b58daeafe
Fix the LIMIT clause so that it applies to the entire query in a compound
...
query. Prior to this change LIMITs on compound queries did not work at
all. Ticket #393 . (CVS 1058)
FossilOrigin-Name: 543479e3aed77976a0c689cf40811bf88353f706
2003-07-20 01:16:46 +00:00
e5f50722b4
Make sure the min() and max() optimizer works correctly when there
...
is a LIMIT clause. Ticket #396 . (CVS 1057)
FossilOrigin-Name: c35e50717678703763c696e3e9b265add2ca6454
2003-07-19 00:44:14 +00:00
9347b20050
In the sqlite shell, change the name of function getline() to local_getline()
...
to avoid a clash with a library function. Ticket #400 . (CVS 1056)
FossilOrigin-Name: 558969ee8697180c74308f3f880d3240eb575af1
2003-07-18 01:30:59 +00:00
a88dc3f629
Make LIMIT 0 return no rows. LIMIT -1 still returns all rows. Ticket #346 . (CVS 1053)
...
FossilOrigin-Name: a31d0bd90af7cc95f8e36ca8ece21515f872235e
2003-07-16 11:51:35 +00:00
ef0cae500d
Allow negative values for LIMIT and OFFSET. Add tests for negative LIMITs
...
and OFFSETs. Make the OFFSET work even if LIMIT is 0 or negative. (CVS 1052)
FossilOrigin-Name: e6a752bfef24f773973c151c6262ff331a9dc57a
2003-07-16 02:19:37 +00:00
d4f5ee2805
Initialize a variable to prevent an MSVC compiler warning. Ticket #394 . (CVS 1051)
...
FossilOrigin-Name: 96e3c539586bf86c4fe8de0ac25de6655f704035
2003-07-16 00:54:31 +00:00
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
3e4c852889
A proported fix for ticket #374 . (CVS 1047)
...
FossilOrigin-Name: a49ee69e98df80b479aa6bb97a9af9c6abf04e3f
2003-07-07 10:47:10 +00:00
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
3c8bf55a04
Make sure indices in ATTACH-ed databases are put into the right hash table.
...
Ticket #354 . (CVS 1044)
FossilOrigin-Name: eb4582831d536cd26a1738f9ad197e40486d0958
2003-07-01 18:13:14 +00:00
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
d6ae597393
Fix a bad memory leak in the in-memory database module. (CVS 1039)
...
FossilOrigin-Name: 9cca95937837333c91f5dee8c48178cf7e06d59f
2003-06-29 18:29:47 +00:00
82f725df08
Minor change to a comment in encode.c. (CVS 1036)
...
FossilOrigin-Name: 3f252b72c9d9ea586161a1b2c5ae297594a1cd4a
2003-06-28 16:25:33 +00:00
937dd84de8
Fix a bug in the soundex() code. Ticket #367 . Add tests for ticket #261
...
even thought the problem could not be reproduced. (CVS 1035)
FossilOrigin-Name: e2ca936feee35b3fce99c95c2cf8c0ad05cd9c3b
2003-06-28 16:20:22 +00:00
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
18706c08cb
Remove a surplus "return" statement accidentaly left in check-in (1032). (CVS 1033)
...
FossilOrigin-Name: c697410af4a61d2037e7e319efe8dd78d7b83365
2003-06-23 15:15:03 +00:00
6cb2c52d96
Remove all references to SQLITE_OMIT_TRACE. Tracing is always enabled.
...
Ticket #361 . (CVS 1032)
FossilOrigin-Name: ec31a5292cbc5d2fb68449838b929638f48e31a7
2003-06-23 11:06:01 +00:00
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
44ce7e20f8
Remove unused variable. Ticket #355 . (CVS 1030)
...
FossilOrigin-Name: 5228cecdb84a665b96750fc0dc7c81e3f50a3ce8
2003-06-17 02:57:17 +00:00
7a73eb48f8
Fix compiler errors and warnings win SQLITE_OMIT_AUTHORIZATION is defined.
...
Ticket #353 . (CVS 1029)
FossilOrigin-Name: 6920b633c2e4a94ee5de7d2db3933a873ee3513b
2003-06-16 19:18:12 +00:00
d93d8a812e
Add the %z format to the sqlite_mprintf() and related functions. (CVS 1028)
...
FossilOrigin-Name: eca1398eaac67d772aff2676a470d9a6d96a93ca
2003-06-16 03:08:18 +00:00
3fc673e622
Do not flatten a subquery which is the right term of a LEFT OUTER JOIN
...
if the subquery contains a WHERE clause. Ticket #350 . (CVS 1027)
FossilOrigin-Name: dd8943e8583cf7ed3b662570a5607856fd246dac
2003-06-16 00:40:34 +00:00
f817b6be7f
Preserve blank lines in the middle of SQL statements in the shell.
...
Ticket #352 (CVS 1026)
FossilOrigin-Name: bcf5eeecdfd9897bc7c257119d7515fd34d222c1
2003-06-16 00:16:41 +00:00
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
3ca691106b
Updated sqlite_encode_binary() comments with tighter bounds on output length. (CVS 1023)
...
FossilOrigin-Name: 826aab43d5967ece2a272c49ce62021fa4a2ceb3
2003-06-15 10:35:04 +00:00
c45d95f9de
Bug fix: sqliteFree() called twice on the same allocation during error
...
handling in attach.c. (CVS 1020)
FossilOrigin-Name: 9ec40935b9435ddc3749cab517387477e4045f6b
2003-06-14 12:04:07 +00:00
e2227f0092
Open the journal file for read-only when doing a playback. Ticket #351 . (CVS 1019)
...
FossilOrigin-Name: 66ac7aea3df8533a49c8c05ba57c5a7015626828
2003-06-14 11:42:57 +00:00
