/ File History
Login

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

History of test/capi2.test

2018-01-10
00:40
Compute the correct column name even if the column identifier is the very last token in the SQL statement. This fixes a problem introduced by check-in [0fdf97efe5df745510c6b] and reported by the community during beta-testing. file: [34a1a9a9] check-in: [36b89d72] user: drh branch: trunk, size: 22950
2017-12-27
19:43
Add and use the internal sqlite3DbSpanDup() interface. file: [d3267a14] check-in: [a8e1545c] user: drh branch: span-refactor, size: 22956
2013-11-05
13:33
Standardize the error messages generated by constraint failures to a format of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases. file: [011c16da] check-in: [54b22192] user: drh branch: omit-rowid, size: 22955
2013-02-09
15:37
Rename SQLITE_CONSTRAINT_RAISE to SQLITE_CONSTRAINT_TRIGGER. Put the extended constraint error codes in alphabetical order. Add many test cases for the extended constraint error codes. file: [e8b18cc6] check-in: [3f674375] user: drh branch: constraint-error-codes, size: 22927
2011-01-17
17:42
Add the SQLITE_OMIT_AUTORESET compile-time option which if enabled causes the sqlite3_step() routine to return SQLITE_MISUSE if it is called after it has previously returned anything other than SQLITE_ROW, SQLITE_BUSY, or SQLITE_LOCKED. file: [835d4cee] check-in: [053ce76d] user: drh branch: trunk, size: 22733
2011-01-11
01:42
A proposed change to the sqlite3_step() API such that it will only auto-reset following an SQLITE_BUSY or SQLITE_LOCKED error. Calls after any other result other than SQLITE_ROW will return SQLITE_MISUSE. file: [35145f8a] check-in: [d1b3c54f] user: drh branch: step-autoreset, size: 22545
2010-04-17
12:53
Change sqlite3_step() so that it automatically calls sqlite3_reset() instead of returning SQLITE_MISUSE when invoked on a prepared statement that previously returned any value other than SQLITE_ROW. file: [00032d75] check-in: [3e646e3f] user: drh branch: trunk, size: 22631
2008-12-30
17:55
Fix a bug in the multi-index OR cost estimator. Remove leftover "breakpoint" commands from test scripts. (CVS 6086) file: [172c717e] check-in: [b090d573] user: drh branch: trunk, size: 22532
2008-09-01
15:52
Defer deleting Table objects associated with flattened subqueries until all code has been generated, in case some expression node still references the Table object. Ticket #3346. (CVS 5650) file: [36f87803] check-in: [d04d7033] user: drh branch: trunk, size: 22543
2008-01-16
17:46
Get all tests running without memory leaks. (CVS 4714) file: [cc64df75] check-in: [5807921f] user: drh branch: trunk, size: 22532
2007-08-22
00:39
Reenable the memory management logic. The quick.test script now runs with SQLITE_MEMDEBUG and SQLITE_ENABLE_MEMORY_MANAGEMENT. 7 minor errors. (CVS 4265) file: [3c506683] check-in: [1914044b] user: drh branch: trunk, size: 22562
2007-01-03
23:37
Clean up memory leaks and uninitialized variables detected by valgrind. Identify all tests where we deliberately derefence freed memory by adding a "-misuse" tag. (CVS 3550) file: [7ecc9b34] check-in: [70a86270] user: drh branch: trunk, size: 22559
2006-08-16
16:42
Allows UPDATE, INSERT, and DELETEs to occur while a SELECT is pending on the same table. (CVS 3355) file: [cb478885] check-in: [8c52d2ad] user: drh branch: trunk, size: 22545
2006-02-10
13:33
Minor test file modifications for builds compiled with OMIT options. (CVS 3077) file: [cddd151c] check-in: [c468aa34] user: danielk1977 branch: trunk, size: 22491
07:07
Fix the origin APIs so that they correctly handle views and subqueries that cannot be flattened. (CVS 3072) file: [e7d3f2e7] check-in: [5e8611e1] user: danielk1977 branch: trunk, size: 22256
03:06
Add a symbol P3_TRANSIENT to pass to VdbeSetColName() to make it copy the string parameter up to the first 0 byte. (CVS 3070) file: [fe07532d] check-in: [6ebb8f9b] user: danielk1977 branch: trunk, size: 20170
02:27
Add the column_origin_name() etc. APIs. (CVS 3069) file: [ca76487c] check-in: [82f502cd] user: danielk1977 branch: trunk, size: 20123
2006-01-03
00:33
The sqlite TCL command no longer returns the hex address of the sqlite3* structure. Instead there is a new command in testfixture to find that information. (CVS 2852) file: [b9354d6c] check-in: [70b22857] user: drh branch: trunk, size: 17295
2005-03-29
03:10
Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) file: [f8972093] check-in: [c41d5544] user: danielk1977 branch: trunk, size: 17303
2005-02-04
04:07
Remove code for SQL cursors. (CVS 2312) file: [2bd71f57] check-in: [2eb90870] user: danielk1977 branch: trunk, size: 17297
2005-01-20
22:48
Bug fixes and enhancements entered while on jury recess. (CVS 2246) file: [b0e12aa6] check-in: [38401dfb] user: drh branch: trunk, size: 16829
2005-01-12
12:44
Tests to improve coverage of main.c. (CVS 2202) file: [325e8d68] check-in: [4e28c82a] user: danielk1977 branch: trunk, size: 16820
2004-11-22
10:02
Back out changes allowing writes to tables that have open cursors. (CVS 2134) file: [8279d1d5] check-in: [af635cab] user: danielk1977 branch: trunk, size: 16710
2004-11-16
15:50
Perform deletes in a single pass. (CVS 2104) file: [cd5e1495] check-in: [a2e1c35b] user: danielk1977 branch: trunk, size: 16940
2004-11-03
16:27
Update tests to work even if some features of the library are disabled. (CVS 2050) file: [1ec97bf8] check-in: [b11fc9b3] user: drh branch: trunk, size: 16701
2004-09-02
14:57
Transactions commit on the last sqlite3_step(), not on sqlite3_finalize(). This allows the sqlite3_step() to return SQLITE_BUSY if the commit is blocked by a lock. Ticket #885. (CVS 1928) file: [53e3f399] check-in: [d1b29156] user: drh branch: trunk, size: 16669
2004-06-30
06:30
Add some tests for overlapping SELECT, COMMIT and ROLLBACK commands. (CVS 1774) file: [78f2c486] check-in: [d256c149] user: danielk1977 branch: trunk, size: 16516
2004-06-26
09:50
Minor fixes related to the tests in misuse.test (CVS 1738) file: [fe61f341] check-in: [0af3ff39] user: danielk1977 branch: trunk, size: 16510
2004-06-21
07:36
Update sqlite3_column_decltype() to return NULL as the declartion type for an expression that is not a column reference. (CVS 1646) file: [9ad428f7] check-in: [ee9dffd9] user: danielk1977 branch: trunk, size: 17115
06:50
Update sqlite3_changes() to match the documentation and add sqlite3_total_changes(). (CVS 1645) file: [7ff5ef9e] check-in: [ae2f4a09] user: danielk1977 branch: trunk, size: 17120
2004-06-19
00:16
Change the name of the TCL command from "sqlite" to "sqlite3" so that both SQLite version 2 and SQLite version 3 can be used by Tcl at the same time. (CVS 1626) file: [7a0d71b2] check-in: [d705d051] user: drh branch: trunk, size: 16834
2004-06-15
02:44
(1) Vdbe makes a copy of column types. (2) Don't invalidate other cursors when a statement or transaction is rolled back. (3) Update capi2.test for the new API. (CVS 1597) file: [b161d9d8] check-in: [4f5e2530] user: danielk1977 branch: trunk, size: 16840
2004-05-21
10:08
Further work on the new API. All the functions to execute queries are there now. (CVS 1427) file: [8fb64e8a] check-in: [fc94575d] user: danielk1977 branch: trunk, size: 13196
01:47
Add new sqlite3_open() and sqlite3_open16() APIs. (CVS 1423) file: [007f856c] check-in: [307b5500] user: danielk1977 branch: trunk, size: 13177
2003-08-05
13:13
Provide a more informative error message when a uniqueness constraint fails. Ticket #419. (CVS 1068) file: [ec96e0e2] check-in: [086aa1c9] user: drh branch: trunk, size: 13069
2003-07-09
00:28
Allow the output arguments in sqlite_compile and sqlite_step to be NULL pointers. Tickets #384 and #385. (CVS 1049) file: [9634deaa] check-in: [dd84f88f] user: drh branch: trunk, size: 13080
2003-06-28
16:20
Fix a bug in the soundex() code. Ticket #367. Add tests for ticket #261 even thought the problem could not be reproduced. (CVS 1035) file: [3663b62f] check-in: [e2ca936f] user: drh branch: trunk, size: 12828
2003-05-16
02:30
Make sure the ON CONFLICT clause on a BEGIN overrides the conflict resolution specified by an index. This fixes a bug reported on the newsgroup. (CVS 975) file: [dddfe84d] check-in: [0f92736d] user: drh branch: trunk, size: 12652
2003-03-01
19:53
Add more tests to make sure that sqlite_changes() works when using the non-callback API. Ticket #250. (CVS 876) file: [fb94bed9] check-in: [13e501d1] user: drh branch: trunk, size: 12651
19:45
Get the non-callback API working with the EXPLAIN keyword and for PRAGMAs. Tickets #258 and #257. Update the API documentation on the sqlite_changes() routine to explain how it works with the non-callback API. Ticket #250. (CVS 875) file: [b5c7fd0b] check-in: [620e1065] user: drh branch: trunk, size: 12352
2003-02-16
22:21
Added test code to check for file descriptor leaks. All regression tests pass now on both win2k and linux. (CVS 868) file: [0c82193a] check-in: [75ba7828] user: drh branch: trunk, size: 11457
2003-01-29
22:58
Additional testing and bug fixing with the non-callback API. Updated the C/C++ interface document to describe the non-callback API. (CVS 855) file: [b0b4b73b] check-in: [af1e9299] user: drh branch: trunk, size: 11446
18:46
Better error messages on constraint violations. Additional tests and bug fixes for the callback-free API. (CVS 854) file: [21f73319] check-in: [ccc82f1a] user: drh branch: trunk, size: 4570
14:06
The callback-free API is now working, though much more testing is need. (CVS 853) file: [158d76af] check-in: [162b2591] user: drh branch: trunk, size: 2659 Added