SQLite

All files named ”test/insert2.test”
Login

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

History for test/insert2.test

2015-04-21
15:49
[4d14b8f1b8] part of check-in [718d5d0eab] 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: [718d5d0eab] user: dan branch: trunk, size: 7435)
2008-01-16
18:20
[4f3a04d168] part of check-in [3a289b6d28] Use 1<<$x instead of pow(2,$x) in the test suite code. (CVS 4715) (check-in: [3a289b6d28] user: danielk1977 branch: trunk, size: 6984)
2005-10-05
11:35
[5a20e1ace5] part of check-in [533a85eee2] 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: [533a85eee2] user: drh branch: trunk, size: 6978)
2005-05-29
14:23
[792ad079f5] part of check-in [6bc3729783] Omit a couple of test cases if the library is compiled without subqueries. (CVS 2488) (check-in: [6bc3729783] user: danielk1977 branch: trunk, size: 6853)
2005-03-29
03:10
[8d71cb249c] part of check-in [c41d55443c] Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) (check-in: [c41d55443c] user: danielk1977 branch: trunk, size: 6818)
2005-02-08
08:42
[065f179a21] part of check-in [c54ad21236] Fix a buggy interaction between "INSERT ... SELECT" processing and optimization (2170). (CVS 2319) (check-in: [c54ad21236] user: danielk1977 branch: trunk, size: 6751)
2005-01-21
03:12
[420cb5c239] part of check-in [bb0254ab14] Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) (check-in: [bb0254ab14] user: danielk1977 branch: trunk, size: 6191)
2004-11-22
13:35
[0bb50ff999] part of check-in [007be591b7] Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) (check-in: [007be591b7] user: danielk1977 branch: trunk, size: 5602)
2004-09-17
17:23
[614a29d3ed] part of check-in [709bb22d6d] 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: [709bb22d6d] user: drh branch: trunk, size: 5512)
2004-06-21
06:50
[ea5d4f8dcb] part of check-in [ae2f4a0943] Update sqlite3_changes() to match the documentation and add sqlite3_total_changes(). (CVS 1645) (check-in: [ae2f4a0943] user: danielk1977 branch: trunk, size: 4719)
2002-06-25
13:16
[c288375a64] part of check-in [52eba4de30] Enhance the INTEGRITY_CHECK pragma to test the auxiliary database file in addition to the main database file. (CVS 642) (check-in: [52eba4de30] user: drh branch: trunk, size: 4666)
2002-04-12
10:08
[eb8481878a] part of check-in [6e71493b9d] 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: [6e71493b9d] user: drh branch: trunk, size: 4714)
2002-03-03
02:49
[2f02b1e0db] part of check-in [2c05389eda] Bug fixes and additional tests for the subquery flattener. (CVS 411) (check-in: [2c05389eda] user: drh branch: trunk, size: 4569)
2002-02-19
13:39
[65c2b2aae0] part of check-in [c6e9048e66] Change the name of the sanity_check PRAGMA to "integrity_check" and make it available on all compiles. (CVS 381) (check-in: [c6e9048e66] user: drh branch: trunk, size: 3115)
2002-02-03
19:06
[3fd6547056] part of check-in [20ea737536] Fix a serious bug in INSERT when the source is a SELECT. (CVS 366) (check-in: [20ea737536] user: drh branch: trunk, size: 3112)
2001-10-15
00:44
[d6901ca931] part of check-in [747bf1b30b] 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: [747bf1b30b] user: drh branch: trunk, size: 2464)
2001-09-16
00:13
[252d7130d8] part of check-in [4e926efe2b] Disclaimed copyright. Preparing for release 2.0. (CVS 250) (check-in: [4e926efe2b] user: drh branch: trunk, size: 2297)
2001-09-14
03:24
[5177c1889e] part of check-in [e7b65e37fd] 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: [e7b65e37fd] user: drh branch: trunk, size: 2840)
2000-06-07
15:11
[732405e303] part of check-in [d3baa046c9] :-) (CVS 70) (check-in: [d3baa046c9] user: drh branch: trunk, size: 2820)
14:42
Added: [2d529bc4ac] part of check-in [5d773b5d4e] :-) (CVS 1697) (check-in: [5d773b5d4e] user: drh branch: trunk, size: 2382)