/ History for test/insert2.test
Login

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

History for test/insert2.test

2015-04-21
15:49
[4d14b8f1] part of check-in [718d5d0e] 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. (check-in: [718d5d0e] user: dan branch: trunk, size: 7435)
2008-01-16
18:20
[4f3a04d1] part of check-in [3a289b6d] Use 1<<$x instead of pow(2,$x) in the test suite code. (CVS 4715) (check-in: [3a289b6d] user: danielk1977 branch: trunk, size: 6984)
2005-10-05
11:35
[5a20e1ac] part of check-in [533a85ee] 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) (check-in: [533a85ee] user: drh branch: trunk, size: 6978)
2005-05-29
14:23
[792ad079] part of check-in [6bc37297] Omit a couple of test cases if the library is compiled without subqueries. (CVS 2488) (check-in: [6bc37297] user: danielk1977 branch: trunk, size: 6853)
2005-03-29
03:10
[8d71cb24] part of check-in [c41d5544] Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) (check-in: [c41d5544] user: danielk1977 branch: trunk, size: 6818)
2005-02-08
08:42
[065f179a] part of check-in [c54ad212] Fix a buggy interaction between "INSERT ... SELECT" processing and optimization (2170). (CVS 2319) (check-in: [c54ad212] user: danielk1977 branch: trunk, size: 6751)
2005-01-21
03:12
[420cb5c2] part of check-in [bb0254ab] Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) (check-in: [bb0254ab] user: danielk1977 branch: trunk, size: 6191)
2004-11-22
13:35
[0bb50ff9] part of check-in [007be591] Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) (check-in: [007be591] user: danielk1977 branch: trunk, size: 5602)
2004-09-17
17:23
[614a29d3] part of check-in [709bb22d] 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) (check-in: [709bb22d] user: drh branch: trunk, size: 5512)
2004-06-21
06:50
[ea5d4f8d] part of check-in [ae2f4a09] Update sqlite3_changes() to match the documentation and add sqlite3_total_changes(). (CVS 1645) (check-in: [ae2f4a09] user: danielk1977 branch: trunk, size: 4719)
2002-06-25
13:16
[c288375a] part of check-in [52eba4de] Enhance the INTEGRITY_CHECK pragma to test the auxiliary database file in addition to the main database file. (CVS 642) (check-in: [52eba4de] user: drh branch: trunk, size: 4666)
2002-04-12
10:08
[eb848187] part of check-in [6e71493b] Fix for bug #15: Add the sqlite_changes() API function for retrieving the number of rows that changed in the previous operation. (CVS 526) (check-in: [6e71493b] user: drh branch: trunk, size: 4714)
2002-03-03
02:49
[2f02b1e0] part of check-in [2c05389e] Bug fixes and additional tests for the subquery flattener. (CVS 411) (check-in: [2c05389e] user: drh branch: trunk, size: 4569)
2002-02-19
13:39
[65c2b2aa] part of check-in [c6e9048e] Change the name of the sanity_check PRAGMA to "integrity_check" and make it available on all compiles. (CVS 381) (check-in: [c6e9048e] user: drh branch: trunk, size: 3115)
2002-02-03
19:06
[3fd65470] part of check-in [20ea7375] Fix a serious bug in INSERT when the source is a SELECT. (CVS 366) (check-in: [20ea7375] user: drh branch: trunk, size: 3112)
2001-10-15
00:44
[d6901ca9] part of check-in [747bf1b3] 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) (check-in: [747bf1b3] user: drh branch: trunk, size: 2464)
2001-09-16
00:13
[252d7130] part of check-in [4e926efe] Disclaimed copyright. Preparing for release 2.0. (CVS 250) (check-in: [4e926efe] user: drh branch: trunk, size: 2297)
2001-09-14
03:24
[5177c188] part of check-in [e7b65e37] 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) (check-in: [e7b65e37] user: drh branch: trunk, size: 2840)
2000-06-07
15:11
[732405e3] part of check-in [d3baa046] :-) (CVS 70) (check-in: [d3baa046] user: drh branch: trunk, size: 2820)
14:42
[2d529bc4] part of check-in [5d773b5d] :-) (CVS 1697) (check-in: [5d773b5d] user: drh branch: trunk, size: 2382) Added