sqlite/libsql
0
0
Fork 0
mirror of https://github.com/tursodatabase/libsql.git synced 2025-10-03 15:09:52 +00:00
Code Activity

Commit Graph

  • 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
  • d4d595f94c Make sure the min() and max() optimizations work on empty indexed tables. Ticket #296. (CVS 914) drh 2003-04-17 12:44:23 +00:00
  • 8396566204 Change the shell to use the sqliteIsNumber() routine for determining if values are numeric. Modified os.c so that it should now work with DJGPP - though I have no way of testing this. (CVS 913) drh 2003-04-17 02:54:13 +00:00
  • 95b5084409 Rollback if a commit hook fails. (CVS 912) drh 2003-04-16 21:03:13 +00:00
  • 027850b676 Fix the authorizer so that it correctly interprets attempts to read the OLD and NEW pseudo-tables of a trigger. (CVS 911) drh 2003-04-16 20:24:52 +00:00
  • bb07e9a34f Simplify the number processing code. Fix for ticket #281. (CVS 910) drh 2003-04-16 02:17:35 +00:00
  • 144f9eadf6 Remove some unnecessary code and complication from the btree interface. (CVS 909) drh 2003-04-16 01:28:16 +00:00
  • 70ce3f0c58 Get triggers working on tables with INTEGER PRIMARY KEYs. Ticket #291. This may also fix #159. Still need to add tests so both bugs remain open for the time being. (CVS 908) drh 2003-04-15 19:22:22 +00:00
  • 048bd5937b Added btree_rb.c (CVS 907) paul 2003-04-15 17:22:30 +00:00
  • 49449834fc Do not record the inserted rowid on when doing an INSERT within a trigger. Ticket #290. (CVS 906) drh 2003-04-15 14:01:43 +00:00
  • f9a2e7bb8d Change lemon to use <stdarg.h> instead of <varargs.h> because GCC no longer supports varargs.h. Tickets #288 and #280. Ironically, lemon originally used varargs.h because stdarg.h was not supported by the compiler I was using in 1989 (which was gcc if I recall correctly.) (CVS 905) drh 2003-04-15 01:49:48 +00:00
  • 13bff81537 Change some variable names and comments in the new in-memory database file implementation. Partial (non-working) implementation of the VACUUM command. (CVS 904) drh 2003-04-15 01:19:47 +00:00
  • b0208ccaa3 Support in-memory databases for temp tables (CVS 903) paul 2003-04-13 18:26:49 +00:00
  • c11d4f9360 Split the implementation of COPY, PRAGMA, and ATTACH into separate source code files. (CVS 902) drh 2003-04-06 21:08:24 +00:00
  • e1051c653e Move the implementation of VACUUM into a separate source file. (CVS 901) drh 2003-04-06 20:52:32 +00:00
  • 73509eee84 Simplify the BTree interface by shortening names. Added two new methods for accessing the current filename and for changing the name of the database file. (CVS 900) drh 2003-04-06 20:44:45 +00:00
  • a73af533de More testing of ATTACH and DETACH. (CVS 899) drh 2003-04-05 16:56:28 +00:00
  • 2d4583473b Begin testing the new ATTACH and DETACH commands. (CVS 898) drh 2003-04-05 03:42:26 +00:00
  • f539f6a7e9 Fix for ticket #276. (CVS 897) drh 2003-04-03 19:35:02 +00:00
  • 0d1a643aea Added experimental APIs: sqlite_begin_hook() and sqlite_commit_hook(). (CVS 896) drh 2003-04-03 15:46:04 +00:00
  • 048c530c01 Use a intermediate table when inserting a TEMP table from a SELECT that reads from that same TEMP table. Ticket #275. (CVS 895) drh 2003-04-03 01:50:44 +00:00
  • b95a8864c9 Add infrastructure to suport multiple btree implementations (CVS 894) paul 2003-04-01 21:16:41 +00:00
  • 738a68b250 Minor follow-on changes to the recent ATTACH patch. (CVS 893) drh 2003-03-31 13:36:09 +00:00
  • 665de47ac3 Minor follow-on changes to the recent ATTACH patch. (CVS 892) drh 2003-03-31 13:36:09 +00:00
  • da93d238c2 Add the sqliteErrorMsg() function and use it to generate error message text during parsing and code generation. This simplifies the code somewhat and makes it easier to handle names with a database prefix. (CVS 891) drh 2003-03-31 02:12:46 +00:00
  • 1c2d84148a The ATTACH and DETACH statements are now coded but are still mostly untested. (CVS 890) drh 2003-03-31 00:30:47 +00:00
  • 180487389b Remove the experimental sqlite_open_aux_file() API. It will soon be replaced by ATTACH and DETACH SQL commands. (CVS 1732) drh 2003-03-30 19:17:02 +00:00
  • 3aa31a16e6 Remove the experimental sqlite_open_aux_file() API. It will soon be replaced by ATTACH and DETACH SQL commands. (CVS 889) drh 2003-03-30 19:17:01 +00:00
  • 9077ba8ee5 Remove the obsolete documentation on how to crosscompile version 1.0 of SQLite. (CVS 888) drh 2003-03-30 18:58:58 +00:00
  • 1dd8c40e8f Detect when a child node of a btree page has zero entries and report that as a case of database corruption. (CVS 887) drh 2003-03-30 18:41:22 +00:00
  • 0be9df076a Fix a memory leak in triggers and update tests to show the latest error message text. (CVS 886) drh 2003-03-30 00:19:49 +00:00
  • 812d7a21dd Regression tests now work - except for some changes in error message text. The library is now safe to use for experimental work. (CVS 885) drh 2003-03-27 13:50:00 +00:00
  • 0951d703f2 Fix a segfault in the trigger code. (CVS 884) drh 2003-03-27 13:01:28 +00:00
  • 1694cab424 Changes to the "sqlite" structure that allow simultaneous operations on multiple database files. Many regession tests pass - but not all of them. Do not use this version except for debugging SQLite itself. (CVS 1731) drh 2003-03-27 12:51:25 +00:00
  • d24cc427b7 Changes to the "sqlite" structure that allow simultaneous operations on multiple database files. Many regession tests pass - but not all of them. Do not use this version except for debugging SQLite itself. (CVS 883) drh 2003-03-27 12:51:24 +00:00
  • 84e6335c0c Re-generated. (CVS 882) a.rottmann 2003-03-24 09:42:16 +00:00
  • 62507b650a Updated libtool. (CVS 881) a.rottmann 2003-03-24 09:40:34 +00:00
  • c7e9383a9e Added pkg-config support. (CVS 880) a.rottmann 2003-03-24 09:39:32 +00:00
  • 113088ec68 Record the database name in addition to the table name for DELETE, INSERT, and UPDATE statements. (CVS 879) drh 2003-03-20 01:16:58 +00:00
  • 001bbcbb8f Modifications to the VDBE to support more than one database file. (CVS 878) drh 2003-03-19 03:14:00 +00:00