sqlite/libsql
0
0
Fork 0
mirror of https://github.com/tursodatabase/libsql.git synced 2024-12-17 00:11:43 +00:00
Code

Commit Graph

  • 29dda4ae65 Split the OP_Integer opcode into OP_Integer and OP_Int64. This allows comments to be added to OP_Integer. Cleanup in the optimizer. Allow terms of the FROM clause to be reordered automatically. (CVS 2556) drh 2005-07-21 18:23:20 +00:00
  • 7ec764a29e Add comments to test cases. Improvements to the query plan test variable. (CVS 2555) drh 2005-07-21 03:48:20 +00:00
  • fe05af87f8 In where.c, split out the code that selects an index into a separate subroutine. (CVS 2554) drh 2005-07-21 03:14:59 +00:00
  • 013972052e Extra memory usage instrumentation added. (CVS 2553) drh 2005-07-20 14:31:53 +00:00
  • e8b9727835 More refactoring in where.c. (CVS 2552) drh 2005-07-19 22:22:12 +00:00
  • 0fcef5e110 Refactoring of the query optimizer in advance of adding better optimization. (CVS 2551) drh 2005-07-19 17:38:22 +00:00
  • 0aa74edd72 Allow an unlimited number of terms in the WHERE clause. The old limit was 100. (CVS 2550) drh 2005-07-16 13:33:20 +00:00
  • 9042f395cc Fix bugs in the new query plan instrumention logic. (CVS 2549) drh 2005-07-15 23:24:23 +00:00
  • 84bfda41db Add test instrumentation that will be needed during the development of forthcoming optimizer enhancements. (CVS 2548) drh 2005-07-15 13:05:21 +00:00
  • 4cfb644e5f Add remark in the changelog that mentions 64-bit alignment fixes in 3.2.2. (CVS 2547) drh 2005-07-09 23:11:22 +00:00
  • c0f2a01926 Fix a comment error. No changes to code. Ticket #1320. (CVS 2546) drh 2005-07-09 02:39:40 +00:00
  • e866fcb923 Use the internal sqlite3_snprintf function instead of sprintf to avoid cross-platform incompatibilities. Ticket #1316. (CVS 2545) drh 2005-07-09 02:38:06 +00:00
  • df3816974c Patch to Makefile.in so that it works with OS X. Ticket #1292. (CVS 2544) drh 2005-07-09 02:23:24 +00:00
  • a4afb65cb7 Make sure there is only one busy counter. Ticket #1315. (CVS 2543) drh 2005-07-09 02:16:02 +00:00
  • 57dbd7b324 Allow the IN operator to take a list of arbitrary expressions on its right-hand side. The expressions no longer need to be constant. The current implementation seems to work but needs more testing and optimization. (CVS 2542) drh 2005-07-08 18:25:26 +00:00
  • 9170dd7e1c Change the name of the OpenTemp opcode to OpenVirtual which is more descriptive of what it does. (CVS 2541) drh 2005-07-08 17:13:46 +00:00
  • 392e597c8a Add the EP_OptOnly flag on expressions for WHERE clause terms that are added by the optimizer but should not be coded. (CVS 2540) drh 2005-07-08 14:14:22 +00:00
  • 70031fa396 Add the SQLITE_CASE_SENSITIVE_LIKE compile-time option. (CVS 2539) drh 2005-07-08 13:53:21 +00:00
  • a01f79df49 Replace OP_List with OP_Fifo. This is the first step toward allowing recursive delete triggers and later foreign keys with cascading deletes. (CVS 2538) drh 2005-07-08 13:07:59 +00:00
  • 9f18e8a0c4 Add infrastructure for the ANALYZE command. Does not yet actually do anything. (CVS 2537) drh 2005-07-08 12:13:04 +00:00
  • 26d0e2a6da Fix a quoting problem in the configure script. (CVS 2536) drh 2005-07-06 13:51:27 +00:00
  • 7bac700686 Fix typos in comments. No changes to code. (CVS 2535) drh 2005-07-01 11:38:44 +00:00
  • eb55bd2fe9 Allow the DEFAULT value of a column to be obtained by calling a function that has constant arguments, such as julianday('now'). (CVS 2534) drh 2005-06-30 17:04:21 +00:00
  • 67ce73b466 Check for zero-byte allocations in sqlite3MallocRaw. (CVS 2533) drh 2005-06-29 17:24:23 +00:00
  • ba336867c4 Make sqlite3Malloc always return NULL when the number of bytes to allocate is 0. (CVS 2532) drh 2005-06-29 15:33:00 +00:00
  • 54f080e82c Update SQL syntax documentation to describe the new CAST expressions. (CVS 2531) drh 2005-06-26 20:00:46 +00:00
  • d1e4733d07 Tcl interface uses Tcl_Objs to implement user-defined functions, thus allowing BLOB values to be transferred correctly. Ticket #1304. (CVS 2530) drh 2005-06-26 17:55:33 +00:00
  • 8a15132904 Documentation fixes. Ticket #1306. (CVS 2529) drh 2005-06-25 19:42:37 +00:00
  • df0bddaef3 The TCL interface binds variables as BLOB only if they have a bytearray representation but no text representation. Ticket #1287. (CVS 2528) drh 2005-06-25 19:31:48 +00:00
  • 487e262f44 Remove the blob(), text() and numeric() functions added in (2524) and replace them with the standard CAST operator. Ticket #1287. (CVS 2527) drh 2005-06-25 18:42:14 +00:00
  • 7f057c9166 NULL values in a row of a unique index cause the row to be distinct. Ticket #1301. More testing and optimization needs to be done on this before closing the ticket. (CVS 2526) drh 2005-06-24 03:53:06 +00:00
  • 2f47149691 Make sure the String8 opcode always has a non-null P3 argument in the foreign_key_list pragma. Ticket #1297. (CVS 2525) drh 2005-06-23 03:15:07 +00:00
  • 5708d2deac Add built-in functions numeric(), text(), and blob() that coerce types. Ticket #1287. (CVS 2524) drh 2005-06-22 10:53:59 +00:00
  • 288d37f1b4 Allow parameters to be introduced by characters ':', '$' and '#'. This is an experimental change. (CVS 2523) drh 2005-06-22 08:48:06 +00:00
  • edef8fcd73 Fix a bug in an assert found while investigating ticket #1287 but otherwise unrelated to that problem. (CVS 2522) drh 2005-06-22 02:36:37 +00:00
  • 13aebc66f2 Change the documentation to explain that a database handle can only be used in the same thread in which it was created. Ticket #1272. (CVS 2521) drh 2005-06-16 19:48:39 +00:00
  • cf5f58fa3e Fix the THREADSAFE macro in Makefile.in. We really need to rework the whole autoconf build system.... (CVS 2520) drh 2005-06-16 18:47:38 +00:00
  • bf8f1b3460 Change to Makefile.in to fix a problem with the Borland linker. Ticket #1291. (CVS 2519) drh 2005-06-16 16:51:15 +00:00
  • 6eb8577cae Fix to the "make doc" makefile target. Ticket #1289. (CVS 2518) drh 2005-06-15 18:07:39 +00:00
  • 2b4b5962c4 Changes to the unix OS layer aimed at finding and fixing tickets #1272 and #1285. (CVS 2517) drh 2005-06-15 17:47:55 +00:00
  • 8d904f058b Fix an NDEBUG versus SQLITE_DEBUG confusion issue. (CVS 2516) drh 2005-06-14 17:47:58 +00:00
  • 556b2a2322 Provide the SQLITE_FILE_HEADER command-line option for changing the text that appears at the beginning of databases. (CVS 2515) drh 2005-06-14 16:04:05 +00:00
  • 3f73708ce4 Fix a bug in the default busy handler for systems that lack usleep(). Ticket #1284. (CVS 2514) drh 2005-06-14 02:24:31 +00:00
  • 78776ecdb1 Do not record existance the sqlite_sequence table until it is actually created. Ticket #1283. (CVS 2513) drh 2005-06-14 02:12:46 +00:00
  • 7c3d49c275 Fix documentation typo. Ticket #1282. (CVS 2512) drh 2005-06-13 00:47:59 +00:00
  • 4fd81a51fa Version 3.2.2 (CVS 2511) drh 2005-06-12 23:17:23 +00:00
  • 3d334bcb1f Update the EXPORT definitions list to include the latest additions to the API. (CVS 2510) drh 2005-06-12 23:16:20 +00:00
  • e44d483818 Updates in preparation for the release of version 3.2.2. (CVS 2509) drh 2005-06-12 22:23:40 +00:00
  • 65efb65e46 Fix documentation typos. (CVS 2508) drh 2005-06-12 22:12:39 +00:00
  • 51942bc3c3 Documentation updates (ticket #1279). Add the sqlite3_db_handle API. (ticket #1275). (CVS 2507) drh 2005-06-12 22:01:42 +00:00
  • f0863fe568 Update older opcode names to be more meaningful in light of the latest code design. (CVS 2506) drh 2005-06-12 21:35:51 +00:00
  • 4a9f241c37 Elminiate a VM opcode that was no longer needed. (CVS 2505) drh 2005-06-12 12:01:19 +00:00
  • 0ccebe7e2d Changes to support linking without a parser and without a disk I/O interface. (CVS 2504) drh 2005-06-07 22:22:50 +00:00
  • 80f93bf41f In the documentation, amplify the fact that encodings cannot be changed on a database that already exists. Ticket #1277. (CVS 2503) drh 2005-06-07 20:07:24 +00:00
  • db0441b155 Remove SSE vacuum hook. (CVS 2502) danielk1977 2005-06-07 09:21:07 +00:00
  • cbe21be330 Add "#ifndef OMIT_DISKIO" condition around sqlite3_opentemp_count variable in test interface code. (CVS 2501) danielk1977 2005-06-07 07:58:48 +00:00
  • af6df11f8a Add tests to make sure statement journals are only opened when necessary. (CVS 2500) drh 2005-06-07 02:12:30 +00:00
  • 3844990cfc Do not open a statement journal unless absolutely necessary. (CVS 2499) drh 2005-06-07 01:43:41 +00:00
  • ed8a3bb108 Reference count Table structures so that they are not deallocated too soon. Ticket #1210. (CVS 2498) drh 2005-06-06 21:19:56 +00:00
  • 473d179d8a Return SQLITE_MISUSE when passing a NULL pointer into sqlite3_bind routines. Ticket #1219. (CVS 2497) drh 2005-06-06 17:54:55 +00:00
  • ba0232a0df Any non-zero value is considered TRUE in a WHERE clause. Ticket #1211. (CVS 2496) drh 2005-06-06 17:27:19 +00:00
  • 873fac0cae Avoid ambiguous column name errors when the column name is in the USING clause of a join. Ticket #743. (CVS 2495) drh 2005-06-06 17:11:46 +00:00
  • 355ef36114 Naming the join columns in the result set of a natural join does not result in an "ambiguous column name" error. Ticket #1217. (CVS 2494) drh 2005-06-06 16:59:24 +00:00
  • d70dc52d79 Honor the full_column_names pragma on * results. Ticket #1263. (CVS 2493) drh 2005-06-06 16:34:33 +00:00
  • 7c3d64f151 Do not allow parameters in VIEW definitions. Ticket #1270. (CVS 2492) drh 2005-06-06 15:32:08 +00:00
  • d7ae9475a8 Handle failures of getcwd() without segfaulting. Ticket #1274. (CVS 2491) drh 2005-06-06 15:07:02 +00:00
  • 41f5852eea Handle failures of getcwd() without segfaulting. Ticket #1274. (CVS 2490) drh 2005-06-06 15:06:39 +00:00
  • defc997230 Fix a bug in the malloc2 tests introduced by checkin (2473). (CVS 2489) drh 2005-06-06 14:45:42 +00:00
  • a38b4134e7 Omit a couple of test cases if the library is compiled without subqueries. (CVS 2488) danielk1977 2005-05-29 14:23:12 +00:00
  • 44ee5bf795 Minor changes to help build and test SSE. (CVS 2487) danielk1977 2005-05-27 09:41:12 +00:00
  • 3e1d8e6356 Add an experimental sqlite3_get_autocommit() API used to test whether or not changes are committed automatically. (CVS 2486) drh 2005-05-26 16:23:34 +00:00
  • 105afed6a0 Add a -cleanup option to Tcl test proc do_ioerr_test. (CVS 2485) danielk1977 2005-05-26 15:20:53 +00:00
  • 5c2d9155de If SSE is enabled, set the P1 field of OP_AggInit instructions to the number of arguments that will be passed to the aggregate function. (CVS 2484) danielk1977 2005-05-26 14:41:47 +00:00
  • 1f723bd904 Fix minor problems with the SSE hooks. (CVS 2483) danielk1977 2005-05-26 12:37:29 +00:00
  • 4dade03788 Rearrange code so that SSE can invoke the collation factory. (CVS 2482) danielk1977 2005-05-25 10:45:10 +00:00
  • fa256a3306 Split main.c into two files to make building without the parser easier. (CVS 2481) danielk1977 2005-05-25 04:11:56 +00:00
  • 97903fef77 Remove the config.h file from the build. Ticket #1224. (CVS 2480) drh 2005-05-24 20:19:57 +00:00
  • fd9a0a45a7 Move a few things around to make building without the parser easier. (CVS 2479) danielk1977 2005-05-24 12:01:00 +00:00
  • b71090fdfb The REGEXP operator is recognized. It tries to invoke a function named regexp() which does not exist in the native build. But users who want to can add an appropriate regexp() function using sqlite3_create_function(). (CVS 2478) drh 2005-05-23 17:26:51 +00:00
  • 15ccce1c0d Make sure that the use of a double-quoted string literal does not trick the optimizer into using a correlated subquery when a static subquery would suffice. (CVS 2477) drh 2005-05-23 15:06:39 +00:00
  • 0bb8f36d05 Retain the error string if an error is generated by SSE during a VACUUM. (CVS 2476) danielk1977 2005-05-23 13:00:57 +00:00
  • 7e900abf0a Add pFetch variable (used by SSE) to sqlite3 structure. (CVS 2475) danielk1977 2005-05-23 04:51:01 +00:00
  • eb43e5c7b7 The cache_size pragma should not reset the synchronous pragma. Ticket #1260. (CVS 2474) drh 2005-05-22 20:30:39 +00:00
  • 132d8d6ab9 Never user a pointer to standard library routines malloc() and free(). This rule is to work around limitations of MSVC and the _fastcall calling convention. Ticket #1256. (CVS 2473) drh 2005-05-22 20:12:37 +00:00
  • edc1cc5b3e Fix a memory leak. Ticket #1259. (CVS 2472) drh 2005-05-22 19:21:51 +00:00
  • fd9e1f3179 Add hook to register SSE user-functions. (CVS 2471) danielk1977 2005-05-22 10:44:34 +00:00
  • 3a3f38e090 Allow schema objects beginning with sqlite_ to be created if the SQLITE_WriteSchema flag is set. (CVS 2470) danielk1977 2005-05-22 06:49:56 +00:00
  • 3c68582188 Speed improvements as described by tickets #1257 and #1258. These changes help some but are nowhere near the 23% claimed in the tickets. (CVS 2469) drh 2005-05-21 18:32:18 +00:00
  • fcd35c7b8c More structure rearrangements for additional size reductions. Ticket #1253. (CVS 2468) drh 2005-05-21 02:48:08 +00:00
  • 6d156e464d Reorder structure fields to reduce code footprint. Ticket #1253. Need to do more of this. (CVS 2467) drh 2005-05-20 20:11:20 +00:00
  • 1c7880e501 Do not allow the pagesize of :memory: databases to be changed. Silently ignore PRAGMA page_size=N requests for :memory: databases. Ticket #1144 and #1252. (CVS 2466) drh 2005-05-20 20:01:55 +00:00
  • e590fbde7c Comment changes in vdbeapi.c (CVS 2465) drh 2005-05-20 19:36:01 +00:00
  • 562e8d3c3b Fix memory leaks in Tcl user function interface. (CVS 2464) danielk1977 2005-05-20 09:40:55 +00:00
  • 1f55c05660 Always use a more specific type (P3_FUNCDEF) instead of P3_POINTER as the P3 type of a vdbe instruction. (CVS 2463) danielk1977 2005-05-19 08:42:59 +00:00
  • dd9f8b45ef Fix an array index that is out of bounds. Ticket #1251. (CVS 2462) drh 2005-05-19 01:26:14 +00:00
  • 8e855770de Provide a compile-time parameter to set the default file creation permissions under Unix. Ticket #1247. (CVS 2461) drh 2005-05-17 11:25:31 +00:00
  • c43e8be80c Fix an uninitialized variable. Ticket #1244. (CVS 2460) drh 2005-05-16 22:37:54 +00:00
  • 5205b40393 Modify documentation to explain default value of "pragma synchronous". No code changes. (CVS 2459) danielk1977 2005-05-16 02:13:17 +00:00
  • 29f214bdaa Change to the lemon parser suggested by Geert Janssen. Appears to have no impact on SQLite. (CVS 2458) drh 2005-05-11 14:28:14 +00:00
  • 6601e9e898 Fix a typo in the CREATE TABLE documentation. (CVS 2457) drh 2005-05-10 16:11:41 +00:00