sqlite/libsql
0
0
Fork 0
mirror of https://github.com/tursodatabase/libsql.git synced 2024-12-15 05:09:50 +00:00
Code

Commit Graph

  • 6f8fd3c171 Use sqliteOsFileExists() in the debugging hook in vdbe.c, instead of access(). Ticket #341. (CVS 1014) drh 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) drh 2003-06-07 11:29:50 +00:00
  • 048aa234ef Major update of vdbe tutorial to 2.8.0 engine. (CVS 1012) jplyon 2003-06-07 08:57:58 +00:00
  • 5fa7eb0dd9 Hyperlinks and minor additions/corrections for lang.tcl (CVS 1011) jplyon 2003-06-07 08:56:09 +00:00
  • 81e293b4b2 Extend the authorization mechanism to disallow the ATTACH and DETACH commands. Ticket #340. (CVS 1010) drh 2003-06-06 19:00:42 +00:00
  • 70dc85a4c2 Add btree_rb.c and opcodes.c to the source built by the "target_source" target of the main makefile. (CVS 1009) drh 2003-06-06 16:13:40 +00:00
  • d36a483704 Add a prototype for the sqlite_vmprintf() function to sqlite.h. (CVS 1008) drh 2003-06-06 15:44:00 +00:00
  • b5333fa6e4 Fix a typo in speed.html. (CVS 1007) drh 2003-06-05 15:05:34 +00:00
  • 8649d6a1a8 Remove unused code from util.c. (CVS 1006) drh 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) drh 2003-06-04 16:24:39 +00:00
  • b8ec20925d Adjust test cases to cope with the extra column returned by the database_list pragma. (CVS 1004) drh 2003-06-04 15:53:02 +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) drh 2003-06-04 15:48:33 +00:00
  • ca3bdaca19 Version 2.8.3 (CVS 1002) drh 2003-06-04 12:44:27 +00:00
  • b6ec9fed20 Update the version number to 2.8.3. (CVS 1001) drh 2003-06-04 12:40:43 +00:00
  • bc2bca0843 Disable the unreadable file test (attach-6.2) under windows because of problems in the OS. (CVS 1000) drh 2003-06-04 12:31:53 +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) drh 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) drh 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) drh 2003-06-02 23:14:13 +00:00
  • 2394e376d6 Fix a bug in the COPY command introduced by check-in (991). (CVS 996) drh 2003-06-02 22:50:25 +00:00
  • ade106c14a Fix an initialized variable in sqliteInitOne. (CVS 995) drh 2003-06-02 18:17:33 +00:00
  • 5959abd5d0 Generate anchors in opcode table html for use by new vdbe tutorial. (CVS 994) jplyon 2003-06-02 06:29:31 +00:00
  • 02be20d4f5 Added comments. (CVS 993) jplyon 2003-06-02 06:17:10 +00:00
  • 5a56422a29 Additions and corrections to vdbe documentation comments. (CVS 992) jplyon 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) drh 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) drh 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) drh 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) drh 2003-05-29 17:43:08 +00:00
  • 124e74e685 Added typeof() operator. Minor additions for ATTACH/DETACH. (CVS 987) jplyon 2003-05-29 04:21:38 +00:00
  • 6e1d288a9f Fix segfault that occurs when opening a non-existing database in the shell then immediately doing ".q". (CVS 986) drh 2003-05-19 23:55:30 +00:00
  • 6b8611126b Additional attach testing. I now believe that ticket #317 was fixed by check-in (981). (CVS 985) drh 2003-05-17 19:23:51 +00:00
  • 79a519c047 Prevent an infinite loop when deleting a table that has a TEMP trigger. (CVS 984) drh 2003-05-17 19:04:03 +00:00
  • 24f1eb74c8 Version 2.8.2 (CVS 983) drh 2003-05-17 17:52:34 +00:00
  • 369986a75f Bump the version number and update the change log. We are rushing out release 2.8.2 because of the database corruption problem fixed by the previous check-in. (CVS 982) drh 2003-05-17 17:38:37 +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) drh 2003-05-17 17:35:10 +00:00
  • 0594f5b97e Version 2.8.1 (CVS 980) drh 2003-05-17 02:44:32 +00:00
  • 8971527208 Fix the fix for newlines in echo commands. Tickets #311, #282, #256. (CVS 979) drh 2003-05-17 02:27:21 +00:00
  • 8625f9fe38 Bump the version number to 2.8.1. Update documentation prior to release. (CVS 978) drh 2003-05-17 01:39:39 +00:00
  • 299fa266df Escape backslashes in echo commands in the makefiles. Tickets #311, #282, #256. (CVS 977) drh 2003-05-17 00:24:21 +00:00
  • 9335247003 Fix memory allocation problem in the sqlite_get_table() API. Ticket #315. (CVS 976) drh 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) drh 2003-05-16 02:30:27 +00:00
  • 931634915d Removed 3rd (file) column from PRAGMA database_list until tests are fixed. (CVS 974) jplyon 2003-05-13 08:01:33 +00:00
  • 39581966a0 Fix another twos-complement negation error. Ticket #313. (CVS 973) drh 2003-05-13 01:52:31 +00:00
  • 3b2129cf77 A change to lemon related to ticket #313. (CVS 972) drh 2003-05-13 00:34:21 +00:00
  • fe4184f8d1 Remove unnecessary "#include <sqliteInt.h>" from the shell code. (CVS 971) drh 2003-05-13 00:24:41 +00:00
  • e62720d1f1 Fix a #ifdefs that are used to comment-out the VACUUM command. (CVS 970) drh 2003-05-13 00:21:59 +00:00
  • 5364f60302 Make sure hash functions always return non-negative. (CVS 969) drh 2003-05-12 23:06:52 +00:00
  • 5ca89c3d28 Changed PRAGMA database_list to show the filename. (CVS 968) jplyon 2003-05-11 20:09:19 +00:00
  • 672a1edfc8 Changed ".databases" command to use PRAGMA database_list. (CVS 967) jplyon 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) drh 2003-05-10 03:36:53 +00:00
  • a3643a2697 Removed never-used symbol SQLITE_ResultDetails. (CVS 965) jplyon 2003-05-10 03:04:34 +00:00
  • f60482044d Removed never-used pragma "result_set_details". (CVS 964) jplyon 2003-05-10 03:03:34 +00:00
  • 9098056e6f Documented the "GO" and "\" command terminators. (CVS 963) jplyon 2003-05-10 02:54:56 +00:00
  • df2245df05 Fixed metacharacter coloring with LP, RP, PLUS. Added more links. (CVS 962) jplyon 2003-05-10 02:54:02 +00:00
  • f94e371bbf Format keyword lists in lang.html using a TCL proc. (CVS 961) drh 2003-05-07 13:37:31 +00:00
  • 3aacc84e45 - Added entries for PRAGMAs database_list, temp_store and default_temp_store. - Fixed missing end tags. (CVS 960) jplyon 2003-05-07 04:04:17 +00:00
  • b2ca13ed4d Cleaned up keywords section. (CVS 959) jplyon 2003-05-07 03:59:10 +00:00
  • 8af4d3ace6 Restrain the flattener in the presence of outer joins. Ticket #306. (CVS 958) drh 2003-05-06 20:35:16 +00:00
  • 66b4ebafb2 Added tests trying (unsuccessfully) to reproduce ticket #304. (CVS 957) drh 2003-05-04 20:42:56 +00:00
  • e1e38c4d7d Shell command-line parsing enhancements suggested by Mike Hall. (CVS 956) drh 2003-05-04 18:30:59 +00:00
  • 7ad4334add Fix deficiencies in sqlite_complete() pointed out by R. Dennis Cote. (CVS 955) drh 2003-05-04 17:58:25 +00:00
  • 5640433e48 Added shell command ".databases" to list name and file of open ones. Added several missing shell commands. (CVS 954) jplyon 2003-05-04 07:31:09 +00:00
  • 6a65bb3c06 added shell command ".databases" to list name and file of open ones. (CVS 953) jplyon 2003-05-04 07:25:57 +00:00
  • b24fe71970 new section for keywords, more docs for attached databases , links, cleanup (CVS 952) jplyon 2003-05-04 07:02:55 +00:00
  • e96fa95e8a More documentation updates. (CVS 951) drh 2003-05-03 19:04:03 +00:00
  • 2bfc9dbdcf - added entry for ATTACH DATABASE. - added entry for DETACH DATABASE. - added soundex() function. - added some new TEMP modifiers. - added new VACUUM behavior. - added the Oracle8 outer join "(+)" syntax. - documented the modulus/remainder operator %. - added ALL as alternative to DISTINCT in SELECT. - fixed assignment list in UPDATE to use * metacharacter. - fixed value in PRAGMA to be optional. - added link from INSERT topic to REPLACE. - added optional CONSTRAINT <name> before column constraints. - skip 2 lines before each Section in the TCL source. (CVS 950) jplyon 2003-05-03 04:55:19 +00:00
  • e9ffc168d8 Additional tests of the new flattener added. Ticket #272. (CVS 949) drh 2003-05-02 16:44:25 +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) drh 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) drh 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) drh 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) drh 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) drh 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) drh 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) drh 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) drh 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) drh 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) drh 2003-04-26 02:50:11 +00:00
  • aba46b19f5 Do not use the return value of fcntl() to find the reason that it failed. Use errno instead. Tickets #240 and #270. (CVS 938) drh 2003-04-26 02:40:45 +00:00
  • 524a5bf5f6 Fix the sqlite_complete() routine so that it recognizes /*...*/ comments. Ticket #277. (CVS 937) drh 2003-04-26 02:31:54 +00:00
  • 85e2096fb6 Report the correct authorization context in the authorization callback when coding an INSTEAD OF trigger on an update or delete. (CVS 936) drh 2003-04-25 17:52:11 +00:00
  • 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) drh 2003-04-25 15:37:57 +00:00
  • 9c05dc6298 Work around a name collision problem on windows. (CVS 934) drh 2003-04-25 13:28:02 +00:00
  • f7c5753174 Make VACUUM work even if multiple processes have the database open at once. (CVS 933) drh 2003-04-25 13:22:51 +00:00
  • fd9903de51 Explicit casts to squelch bogus warnings for vc++. Ticket #194. (CVS 932) drh 2003-04-25 03:13:25 +00:00
  • 45a304ee8c Get VACUUM working again - with test cases. Some other minor cleanups. (CVS 931) drh 2003-04-25 02:43:08 +00:00
  • 5cf590c128 Fix some issues with INSTEAD OF triggers. (CVS 930) drh 2003-04-24 01:45:04 +00:00
  • b5a20d3ceb Remove the begin_hook and commit_hook APIs. They were a bad idea. Add a "trace" method to the TCL interface. (CVS 929) drh 2003-04-23 12:25:23 +00:00
  • e22a334b78 Update the authorizer API so that it reports the database that table and indices belong to and so that it reports when actions are taken in response to a trigger. (CVS 928) drh 2003-04-22 20:30:37 +00:00
  • 3837237959 Check for readline libs now adds appropriate curses or termcap lib when needed (CVS 927) paul 2003-04-22 08:04:49 +00:00
  • f0f258b11b Add support for TEMPORARY triggers. Such triggers can write temporary or permanent tables. (CVS 926) drh 2003-04-21 18:48:45 +00:00
  • 881b890af4 Add more tests for the in-memory database. (CVS 925) drh 2003-04-20 23:45:23 +00:00
  • b2fe7d8cb7 Added tests for the in-memory database backend. Also updated some comments in other modules. (CVS 924) drh 2003-04-20 17:29:23 +00:00
  • 2dc96f9eb8 Align config vars controlling in-memory DB with code (CVS 923) paul 2003-04-20 11:46:34 +00:00
  • f00993a30a Reset pCur->eSkip on a MoveTo (CVS 922) paul 2003-04-20 11:41:04 +00:00
  • ea1ba17cda Update comments. Remove unused field from the Index structure. (CVS 921) drh 2003-04-20 00:00:23 +00:00
  • 7bdc0c1def Modify the optimizer so that it does not assume that functions are constant. (CVS 920) drh 2003-04-19 17:27:24 +00:00
  • 37ea94b8c9 Bug in WHERE clause processing fixed. Ticket #298. (CVS 919) drh 2003-04-19 16:34:04 +00:00
  • 9d10f1d0f6 fix a memory leak in btree_rb.c. (CVS 918) drh 2003-04-18 22:52:38 +00:00
  • cab20050bb Fix for ticket #297 - bug in sqliteSortCompare(). (CVS 917) drh 2003-04-18 17:45:14 +00:00
  • a5f668327b The VACUUM command is now functioning (again). Need to do more testing. (CVS 916) drh 2003-04-18 02:31:04 +00:00
  • a69d91681d Fix triggers to work in an ATTACHed database. Ticket #295. (CVS 915) drh 2003-04-17 22:57:53 +00:00