/ File History
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History of test/insert2.test

2015-04-21
15:49
Fix an obscure problem with "INSERT INTO tbl(cols) SELECT" statements where the SELECT is a compound with an ORDER BY and "cols" is a strict subset of tbl's columns. file: [4d14b8f1] check-in: [718d5d0e] user: dan branch: trunk, size: 7435
2008-01-16
18:20
Use 1<<$x instead of pow(2,$x) in the test suite code. (CVS 4715) file: [4f3a04d1] check-in: [3a289b6d] user: danielk1977 branch: trunk, size: 6984
2005-10-05
11:35
Fix an assert or memory leak that occurs when trying to EXPLAIN a statement other than a SELECT that outputs results. Examples of such statements include PRAGMA integrity_check or INSERT/DELETE/UPDATE with PRAGMA count_changes=ON. (CVS 2743) file: [5a20e1ac] check-in: [533a85ee] user: drh branch: trunk, size: 6978
2005-05-29
14:23
Omit a couple of test cases if the library is compiled without subqueries. (CVS 2488) file: [792ad079] check-in: [6bc37297] user: danielk1977 branch: trunk, size: 6853
2005-03-29
03:10
Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) file: [8d71cb24] check-in: [c41d5544] user: danielk1977 branch: trunk, size: 6818
2005-02-08
08:42
Fix a buggy interaction between "INSERT ... SELECT" processing and optimization (2170). (CVS 2319) file: [065f179a] check-in: [c54ad212] user: danielk1977 branch: trunk, size: 6751
2005-01-21
03:12
Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) file: [420cb5c2] check-in: [bb0254ab] user: danielk1977 branch: trunk, size: 6191
2004-11-22
13:35
Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) file: [0bb50ff9] check-in: [007be591] user: danielk1977 branch: trunk, size: 5602
2004-09-17
17:23
The INSERT code generator does a better job of detecting if the table being written into is used in the SELECT on the right-hand side. ticket #901. (CVS 1961) file: [614a29d3] check-in: [709bb22d] user: drh branch: trunk, size: 5512
2004-06-21
06:50
Update sqlite3_changes() to match the documentation and add sqlite3_total_changes(). (CVS 1645) file: [ea5d4f8d] check-in: [ae2f4a09] user: danielk1977 branch: trunk, size: 4719
2002-06-25
13:16
Enhance the INTEGRITY_CHECK pragma to test the auxiliary database file in addition to the main database file. (CVS 642) file: [c288375a] check-in: [52eba4de] user: drh branch: trunk, size: 4666
2002-04-12
10:08
Fix for bug #15: Add the sqlite_changes() API function for retrieving the number of rows that changed in the previous operation. (CVS 526) file: [eb848187] check-in: [6e71493b] user: drh branch: trunk, size: 4714
2002-03-03
02:49
Bug fixes and additional tests for the subquery flattener. (CVS 411) file: [2f02b1e0] check-in: [2c05389e] user: drh branch: trunk, size: 4569
2002-02-19
13:39
Change the name of the sanity_check PRAGMA to "integrity_check" and make it available on all compiles. (CVS 381) file: [65c2b2aa] check-in: [c6e9048e] user: drh branch: trunk, size: 3115
2002-02-03
19:06
Fix a serious bug in INSERT when the source is a SELECT. (CVS 366) file: [3fd65470] check-in: [20ea7375] user: drh branch: trunk, size: 3112
2001-10-15
00:44
Added support for the COUNT_CHANGES pragma in order to help out the ODBC driver. Fixed a but on count(*) when applied to empty tables. (CVS 289) file: [d6901ca9] check-in: [747bf1b3] user: drh branch: trunk, size: 2464
2001-09-16
00:13
Disclaimed copyright. Preparing for release 2.0. (CVS 250) file: [252d7130] check-in: [4e926efe] user: drh branch: trunk, size: 2297
2001-09-14
03:24
All tests now pass. But there are still issues. For example, inserts are way too slow. And additional tests are needed for new features. (CVS 243) file: [5177c188] check-in: [e7b65e37] user: drh branch: trunk, size: 2840
2000-06-07
15:11
:-) (CVS 70) file: [732405e3] check-in: [d3baa046] user: drh branch: trunk, size: 2820
14:42
:-) (CVS 1697) file: [2d529bc4] check-in: [5d773b5d] user: drh branch: trunk, size: 2382 Added