892f671cf3
Added missing error string to sqlite_error_string(). (CVS 1018)
...
FossilOrigin-Name: 3afb7b3586be81202c76692afea9d2b7a63b4b93
2003-06-12 08:59:00 +00:00
2e0d738b60
Suppress the warning message about print_node() being unused in btree_rb.c.
...
Ticket #347 . (CVS 1017)
FossilOrigin-Name: b52f07e1c894a52bb12459d03fd0efcee05dd08c
2003-06-10 02:46:15 +00:00
7571c96c4c
Remove redundant "return" statement from btree_rb.c. (CVS 1016)
...
FossilOrigin-Name: 373d077173f1b31896dc0e0d724371dd506d52f3
2003-06-09 11:53:12 +00:00
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
94ce4c1e3b
Do not assume that a pointer can fit in a long inside the printf() code.
...
Ticket #342 . (CVS 1013)
FossilOrigin-Name: 5dad7c05e9789e101d5ce75a6f3ea2ffb278b29d
2003-06-07 11:29:50 +00:00
81e293b4b2
Extend the authorization mechanism to disallow the ATTACH and DETACH commands.
...
Ticket #340 . (CVS 1010)
FossilOrigin-Name: a97dca73aed0b42d8dcf944360667ae93c5324fd
2003-06-06 19:00:42 +00:00
d36a483704
Add a prototype for the sqlite_vmprintf() function to sqlite.h. (CVS 1008)
...
FossilOrigin-Name: 048cf55c7da92e363f6a2ab594e17280c9573410
2003-06-06 15:44:00 +00:00
8649d6a1a8
Remove unused code from util.c. (CVS 1006)
...
FossilOrigin-Name: 1bcaa841a396e4d592de30d10846f7cefbbdcd0e
2003-06-05 14:27:56 +00:00
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
5e8e1981dc
Change the "database_list" pragma to return a third column containing the
...
filename of the underlying database file. Always use an in-memory TEMP
database with an in-memory main database. (CVS 1003)
FossilOrigin-Name: f39100f5759d0d8b9c71e18d38a148dee4643020
2003-06-04 15:48:33 +00:00
5383ae5c12
Avoid corrupting indices when doing a REPLACE on a table with an
...
INTEGER PRIMARY KEY that also has another index. Ticket #334 . (CVS 999)
FossilOrigin-Name: e813faae0e4086571d13c769f793add7f1f979af
2003-06-04 12:23:30 +00:00
4312db55d9
Additional testing of the ATTACH command with bug fixes for the new problems
...
that the tests found. (CVS 998)
FossilOrigin-Name: 3e8889d7ce5e99fc855526fc1bb62ddbe282bfc5
2003-06-03 01:47:11 +00:00
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
2394e376d6
Fix a bug in the COPY command introduced by check-in (991). (CVS 996)
...
FossilOrigin-Name: 77ec13dab85b70795ef06ff2c714cca0cd496837
2003-06-02 22:50:25 +00:00
ade106c14a
Fix an initialized variable in sqliteInitOne. (CVS 995)
...
FossilOrigin-Name: 89957b09ce746cf98d5d75cab2a23994e27c4937
2003-06-02 18:17:33 +00:00
02be20d4f5
Added comments. (CVS 993)
...
FossilOrigin-Name: 1276ddb3074b74e22c579bad6951ea52384c08dd
2003-06-02 06:17:10 +00:00
5a56422a29
Additions and corrections to vdbe documentation comments. (CVS 992)
...
FossilOrigin-Name: b648987de3383d6835df58aa0efee54fa8f10d26
2003-06-02 06:15:58 +00:00
a0217ba720
Add the ability to INSERT or UPDATE using the "rowid" column even on tables
...
that lack an integer primary key. (CVS 991)
FossilOrigin-Name: 903adbe802ca0e987b867e5ad33aae02ad2a43d4
2003-06-01 01:10:33 +00:00
f26e09c87f
Tighter binding of views, triggers, and indices to their respective
...
databases. Ticket #323 . Much more testing needs to be done to the
sqliteFix...() routines in attach.c. (CVS 990)
FossilOrigin-Name: 7202d4f1a8853368954a967b7ccca9d8a6645a2e
2003-05-31 16:21:12 +00:00
8372b8d134
Change the row-size limit back to 1MB. It was temporarily raised to 16MB.
...
We'll probably move it to 16MB eventually, but not just yet. (CVS 989)
FossilOrigin-Name: b84c4035c6b06469055798cf412fa4da8b50fa17
2003-05-29 17:50:55 +00:00
9ac717d7f6
Modify the windows locking code so that it works correctly for a database
...
being shared between Win95/98/ME and WinNT/2K/XP systems. Ticket #310 . (CVS 988)
FossilOrigin-Name: 8c402db7e0745622d9950e5ca5d4d8e933da436c
2003-05-29 17:43:08 +00:00
6e1d288a9f
Fix segfault that occurs when opening a non-existing database in the shell
...
then immediately doing ".q". (CVS 986)
FossilOrigin-Name: e8566cf5a381fa7655caacbc0fe95091e1137fea
2003-05-19 23:55:30 +00:00
79a519c047
Prevent an infinite loop when deleting a table that has a TEMP trigger. (CVS 984)
...
FossilOrigin-Name: c8c823b068916711857fa67db10fb479999b55c2
2003-05-17 19:04:03 +00:00
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
9335247003
Fix memory allocation problem in the sqlite_get_table() API. Ticket #315 . (CVS 976)
...
FossilOrigin-Name: f1d955efd91093994db43a1540080d32442d5ac0
2003-05-17 00:05:49 +00:00
a996e477d0
Make sure the ON CONFLICT clause on a BEGIN overrides the conflict resolution
...
specified by an index. This fixes a bug reported on the newsgroup. (CVS 975)
FossilOrigin-Name: 0f92736d1fbe3b587592fe1f26dfb3558cc49727
2003-05-16 02:30:27 +00:00
931634915d
Removed 3rd (file) column from PRAGMA database_list until tests are fixed. (CVS 974)
...
FossilOrigin-Name: 4183cf97676e64d19978941a7c4a3fe521fcb1fb
2003-05-13 08:01:33 +00:00
39581966a0
Fix another twos-complement negation error. Ticket #313 . (CVS 973)
...
FossilOrigin-Name: f267a8a4ff52eb7ee3ac20a8e3a8ab5fe19e445d
2003-05-13 01:52:31 +00:00
fe4184f8d1
Remove unnecessary "#include <sqliteInt.h>" from the shell code. (CVS 971)
...
FossilOrigin-Name: 6e5c497a42e52236edae8d99b4892d4b93db43f5
2003-05-13 00:24:41 +00:00
e62720d1f1
Fix a #ifdefs that are used to comment-out the VACUUM command. (CVS 970)
...
FossilOrigin-Name: 22d5324073a727627d4294870a441fa2316fb049
2003-05-13 00:21:59 +00:00
5364f60302
Make sure hash functions always return non-negative. (CVS 969)
...
FossilOrigin-Name: 39a3e403f0440acb2f85a064ec23d404f9cdfbc4
2003-05-12 23:06:52 +00:00
5ca89c3d28
Changed PRAGMA database_list to show the filename. (CVS 968)
...
FossilOrigin-Name: 3da10d2d02e331f136fcf857dc4c435c67ee7196
2003-05-11 20:09:19 +00:00
672a1edfc8
Changed ".databases" command to use PRAGMA database_list. (CVS 967)
...
FossilOrigin-Name: bad2065337d8dcaacd519b8f1730a90f1c933c3e
2003-05-11 20:07:05 +00:00
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
a3643a2697
Removed never-used symbol SQLITE_ResultDetails. (CVS 965)
...
FossilOrigin-Name: 26bd7bb1779e14f19c00e450aaa9529f2aabf131
2003-05-10 03:04:34 +00:00
f60482044d
Removed never-used pragma "result_set_details". (CVS 964)
...
FossilOrigin-Name: bf558e79524c04339f1174dc935e39d47cb33457
2003-05-10 03:03:34 +00:00
8af4d3ace6
Restrain the flattener in the presence of outer joins. Ticket #306 . (CVS 958)
...
FossilOrigin-Name: 6d4b6597e560578253960d9876dc8c8657f41fef
2003-05-06 20:35:16 +00:00
e1e38c4d7d
Shell command-line parsing enhancements suggested by Mike Hall. (CVS 956)
...
FossilOrigin-Name: 5656fe48b192dc84cb5977f826ff99d81684791f
2003-05-04 18:30:59 +00:00
7ad4334add
Fix deficiencies in sqlite_complete() pointed out by R. Dennis Cote. (CVS 955)
...
FossilOrigin-Name: 54b33a5ed9f7a89435c2f1395a3177e8c778bb8a
2003-05-04 17:58:25 +00:00
6a65bb3c06
added shell command ".databases" to list name and file of open ones. (CVS 953)
...
FossilOrigin-Name: 741a5a8d3975fb5db18914b7879b12aead59279b
2003-05-04 07:25:57 +00:00
c31c2eb82c
Enhance the query flattener to handle subqueries that are joins.
...
All regressions pass but new tests need to be added before release.
Ticket #272 . (CVS 948)
FossilOrigin-Name: ad57693e9f1b83a8cc4d028264b35018a9a4a701
2003-05-02 16:04:17 +00:00
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
56e452cf3a
Correctly create an index that uses an INTEGER PRIMARY KEY as one of columns
...
to be indexed. (CVS 946)
FossilOrigin-Name: 6d019e0baa3219614a9bc5b550a0f9fe3f7e731a
2003-05-01 16:56:03 +00:00
44c2eb128d
In the shell tool, delay opening the database until it is needed but also
...
make sure it is opened before trying to use the "db" pointer. Ticket #302 . (CVS 945)
FossilOrigin-Name: 20fcead42bc875f13eec52971530342ff00c5eda
2003-04-30 11:38:26 +00:00
a9b1716296
Accept a "/" or "go" on a line by itself as an SQL statement terminator
...
in the command-line shell. This allows SQL Server and Oracle scripts to
be played into SQLite without change. (CVS 944)
FossilOrigin-Name: 8211f57b38b87a42c856e267bd243984b5abf9cc
2003-04-29 18:01:28 +00:00
86e5cc058d
Allow the ASC or DESC keyword to appear after a column name in a CREATE INDEX
...
statement. SQLite indices are aways ASC (ascending) regardless of which
keyword is used. (CVS 943)
FossilOrigin-Name: 1a0c542088618ba24d1efae9b13a8eca104d6cc8
2003-04-29 17:19:18 +00:00
63eb5f294c
The sqlite_complete() function should ignore carriage-return characters.
...
(Oops - some unrelated edits also made it into this check-in.) (CVS 942)
FossilOrigin-Name: c6bf62e41cf44e8ebf740b103204b00e8b826c90
2003-04-29 16:20:44 +00:00
7d8085a8e4
In the test code, make several attempts to convert a pointer to a string
...
and test each attempt to make sure it works before returnning, in order to
work around incompatibilities between various systems. Ticket #284 . (CVS 941)
FossilOrigin-Name: 333011ffddc0be91f76811458f03ad1ec0331b51
2003-04-26 13:19:38 +00:00
70c7a4b1da
Fix the shell tool to do a better job of ignoring whitespace. Ticket #234 . (CVS 940)
...
FossilOrigin-Name: 639957e9f793eddce027050d2655863d82fe8ac9
2003-04-26 03:03:06 +00:00
4328c8b7c7
Only print the "Loading resources from..." line when the output is a TTY.
...
Ticket #168 . (CVS 939)
FossilOrigin-Name: 92ded93376635f37e2f5a7a8f4077c85d5bce735
2003-04-26 02:50:11 +00:00
