aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
...
* Code cleanup and simplification. Three new Mem opcodes added.drh2005-09-20
| | | | | The sqlite3VdbeJumpHere function added. (CVS 2730) FossilOrigin-Name: 2471957feee57538e5e1e50a704a337f0927d10e
* Cleanup the implementation and the documentation of the new 0x200 P1 flagdrh2005-09-20
| | | | | on the VDBE comparison operands. (CVS 2729) FossilOrigin-Name: f22d0f64a0b9100e16746fb800efa508d286e40e
* NULLs compare equal to each other when computing GROUP BY categories. (CVS 2728)drh2005-09-20
| | | FossilOrigin-Name: d9b0c9705379a8b3a28a83bb29fc1cd688fe184e
* Update comments in where.c. No code changes. (CVS 2727)drh2005-09-20
| | | FossilOrigin-Name: bb84d27eda64479d65b13fbbcaeef6a00da4d103
* ON-clause terms in a LEFT JOIN that restrict only the left table, should notdrh2005-09-19
| | | | | | really restrict the left table but instead rows that fail to meet the condition to be joined with NULL rows from the right table. (CVS 2725) FossilOrigin-Name: ea10f9785e3c5248dafcc297f3a2c5465b6e0dba
* Set the default maximum page size to 32768, not 8192. (CVS 2724)drh2005-09-19
| | | FossilOrigin-Name: b32e9ec2480f9da2c2ea705ed3c88ca77b77cf2a
* Do not optimize views with an ORDER BY clause if they are used in a UNION ALLdrh2005-09-19
| | | | | that also has an ORDER BY clause. Ticket #1444. (CVS 2723) FossilOrigin-Name: 6cc57fcf15cfa3ce73c78b1cac90f7806e5bae40
* Fix uninitialized value on a UNION ALL select with an ORDER BY clause. (CVS ↵drh2005-09-19
| | | | | 2722) FossilOrigin-Name: 92126a216101d30e16390bf063d52d7182fbc763
* The sqlite3_query_plan debugging variable now only appears with ↵drh2005-09-19
| | | | | SQLITE_TEST=1. (CVS 2721) FossilOrigin-Name: 41e226d2ff5c0021fd07388da13f6d750fac508b
* Work around limitations of MSVC++ 6. Tickets #1429, #1437, and #1440. (CVS ↵drh2005-09-19
| | | | | 2720) FossilOrigin-Name: b2d1803c25b0b823c9cbe27989bacb730b18b45b
* Change some debugging #defines in order to get SSE working again afterdrh2005-09-19
| | | | | recent upgrades. (CVS 2719) FossilOrigin-Name: 86eb7d8363559c94bfcd7e48ff6270025ecacb7b
* The sqlite3ReallocOrFree routine should set its pointer to NULL when it ↵drh2005-09-17
| | | | | fails. (CVS 2715) FossilOrigin-Name: 0e85af44faca4b625e6ab7cb21a300867298c539
* Fix a memory leak that occurs after malloc fails. (CVS 2713)drh2005-09-17
| | | FossilOrigin-Name: 85b931bf72dac88187e4531053a06abe25d6f462
* Fix a problem with the lock_status pragma and the UTF-16 encoding. (CVS 2710)drh2005-09-17
| | | FossilOrigin-Name: 1a737b457c59286d7d5c3a98391dec17dbc82d09
* Changes to make corruption errors easier to track down. (CVS 2709)drh2005-09-17
| | | FossilOrigin-Name: c07330000b9427a77f412918078beffa18de2c36
* Bug fix in the ORDER BY optimizer. Ticket #1435. (CVS 2707)drh2005-09-17
| | | FossilOrigin-Name: 553b7ba8f8ae4cb865494f2d301690149d7edb9f
* Make sure dependencies on the right-hand side of IN operators are checkeddrh2005-09-17
| | | | | correctly. Ticket #1433. (CVS 2706) FossilOrigin-Name: 21740794ab81924442f358a6adbbe6d5590cf58d
* Do not journal the locking page which doing an autovacuum. Similar to thedrh2005-09-16
| | | | | | problem of #1432 except that this one occurs on autovacuum instead of vacuum. An assert() has been added to catch any future incidents of this type. (CVS 2704) FossilOrigin-Name: 5b6dc12b7d25d999be5d282cd0b06e02e2bda765
* Do not journal the file locking page when doing a database copy asdrh2005-09-16
| | | | | part of a VACUUM. Ticket #1432. (CVS 2703) FossilOrigin-Name: 248f77972bb1be3325708ea143fd87bb7ce914a7
* Prevent the sqlite3_pagecount() function from ever returning the pending-bytedanielk19772005-09-16
| | | | | page. (CVS 2702) FossilOrigin-Name: 35a8893537ae5faed6ee49270ac9c01a6010993f
* Move the definition of sqlite3_pending_byte from test2.c to os_common.h. ↵danielk19772005-09-16
| | | | | (CVS 2701) FossilOrigin-Name: bedf702f539636fa3b65fd0d6797b087481b4613
* Fix an auto-vacuum problem with the PENDING_BYTE page. Also link the Tcldanielk19772005-09-16
| | | | | variable sqlite_pending_byte to the internal pending-byte location when in test mode. (CVS 2700) FossilOrigin-Name: 9115e0621d1fdc5a89a0288b87c0a4ce1e4b50c6
* Undo check-in (2694). (CVS 2697)drh2005-09-16
| | | FossilOrigin-Name: 6017b1962517eb206183042bbb718925d9819063
* Fix a whole host of newly discovered memory leaks the occur after adrh2005-09-16
| | | | | failure of realloc(). (CVS 2696) FossilOrigin-Name: 4686d649756a0aa301ade901ac49c89a976c5402
* Fix a memory leak: a failure to deallocate the P3 parameter on a calldrh2005-09-16
| | | | | to sqlite3VdbeChangeP3. (CVS 2695) FossilOrigin-Name: 714254cbc12564d44548707043fdcdffb17e4fde
* The table_info pragma now gives the order of columns in the primary key. ↵drh2005-09-15
| | | | | (CVS 2694) FossilOrigin-Name: 9b60f48de7fbca96c6e26266a8fb9eed8bc378f2
* Correct the sense of a test for SQLITE_DEBUG on the resent NDEBUG change.drh2005-09-13
| | | | | Ticket #1425 (CVS 2693) FossilOrigin-Name: 81fdffdff6fd107c361b1ee69649455143bf3921
* Fix a comment typo in the previous check-in. (CVS 2691)drh2005-09-13
| | | FossilOrigin-Name: 49c952807dabd80bfeb46caf55856aaab988226c
* Automatically set the NDEBUG preprocessor macro unless SQLITE_DEBUG is set.drh2005-09-13
| | | | | In this way, assert() statements become opt-in rather than opt-out. (CVS 2690) FossilOrigin-Name: 2ec2bd85741e36e410f05ff34de430ffbcf51eea
* Bug fix in the new COUNT(DISTINCT) logic. Ticket #1420. (CVS 2689)drh2005-09-12
| | | FossilOrigin-Name: 37116550d33d8e3bdc15cd9998b9d2b97dec312b
* COUNT(DISTINCT x) is now fully functional, though it could benefit fromdrh2005-09-11
| | | | | additional testing. (CVS 2688) FossilOrigin-Name: 2f397bd8142ec5e8f7238127012d14fdb558d918
* The ".dump" command from the shell correctly saves the state of thedrh2005-09-11
| | | | | sqlite_sequence and sqlite_stat1 tables, if they exist. Ticket #1419. (CVS 2687) FossilOrigin-Name: 3f191cf497e5798a8620ebc5a85e34187f58371c
* The shell does not output the sqlite_stat1 table on .dump or .schema.drh2005-09-10
| | | | | | | The ANALYZE command now gathers statistics on tables that have only a single index because this sometimes helps when reordering tables in a join. (CVS 2686) FossilOrigin-Name: 26565b8931419031f9a8dd3947e1e2bd23ccbff2
* Add the experimental EXPLAIN QUERY PLAN diagnostic capability. (CVS 2685)drh2005-09-10
| | | FossilOrigin-Name: 986efb7b12643800805ad4b1f1e90e30fcf6d38a
* Avoid a memory leak and/or assertion failure when parsing a table drh2005-09-10
| | | | | | declaration that contains a duplicate column name. Ticket #1418. (CVS 2684) FossilOrigin-Name: f43427742b1c086f2621c900f4ede1a34a8b44ee
* Use of the CROSS keyword in a join prevents table reordering. Ticket #1414. ↵drh2005-09-10
| | | | | (CVS 2683) FossilOrigin-Name: 415b8b24629aa12756d8285c094b5f85d8a8e532
* Enhanced disk-full tests. (CVS 2682)drh2005-09-09
| | | FossilOrigin-Name: 0288fa5d25886f6fbef0be782f12285d62bebd68
* Detect errors returned by SetFilePointer on windows. (CVS 2681)drh2005-09-09
| | | FossilOrigin-Name: bc8c33f94ce069f7bcfc32a59d5c40e034e023b5
* Infrastructure for the DISTINCT keyword in aggregate functions. But it doesdrh2005-09-09
| | | | | not work yet. If you try to use it you get an error message. (CVS 2680) FossilOrigin-Name: 4d62e36fe3819c2a1412737c2ec8a91ddc5e1777
* Defend against disk I/O errors that happen during an sqlite3OsSeek(). (CVS 2679)drh2005-09-09
| | | FossilOrigin-Name: 461e3a0a27ff083b0bae10c9880e3b41bb85ee31
* SUM returns NULL when it has no inputs. Ticket #1413. (CVS 2678)drh2005-09-08
| | | FossilOrigin-Name: 6281859425d39c11d82875301fefafad1f08416d
* A SUM() of all NULLs returns NULL. A SUM() of nothing return 0.drh2005-09-08
| | | | | | A SUM() of a mixture of NULLs and numbers returns the sum of the numbers. Ticket #1413. (CVS 2677) FossilOrigin-Name: 2e6230edfd651b40481ebad8aa01a22ac92ce80c
* Remove a C++ism that snuck in on one of the reason changes. (CVS 2676)drh2005-09-08
| | | FossilOrigin-Name: 48f6a331efea419fe948cd366f9c60ae41edddfd
* Remove a few unused variables detected by Borland C. Ticket #1412. (CVS 2675)drh2005-09-08
| | | FossilOrigin-Name: cdfe372a958fb446485913e860d52b87fffd34e4
* Aggregates with GROUP BY can sometimes return no result rows. (CVS 2674)drh2005-09-08
| | | FossilOrigin-Name: 0c3e368d4766685b94a44f2c514e2dea806c297c
* While doing a transaction comment, use fdatasync() instead of fsync() indrh2005-09-08
| | | | | cases there the file size is unchanged. (CVS 2673) FossilOrigin-Name: 3c555a87493128620ac967faf7c63c2a58856e9e
* Fix a comment in sqlite.h. Ticket #1321. (CVS 2670)drh2005-09-08
| | | FossilOrigin-Name: ed4e9e751be2b982af9561aba20c8e1367828b81
* The SUM() aggregate function returns an integer result if all inputs aredrh2005-09-08
| | | | | | integers. Any single non-integer input causes the result to be a floating point value. (CVS 2669) FossilOrigin-Name: 21adf4bd99e732650a1e8e9a1cc954126983a654
* Changes to comments only in sqliteInt.h. No changes to code. (CVS 2668)drh2005-09-08
| | | FossilOrigin-Name: cc2a61650ea0d4b2ef67e144424327362999526d
* Optimizations and refinements. Improvements to test coverage. (CVS 2667)drh2005-09-08
| | | FossilOrigin-Name: 7283f7c29db4f622380b6a5cb745a4dc0c8e6a25