SQLite

All files named ”test/capi2.test”
Login

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

History for test/capi2.test

2025-07-02
07:52
[fbcedffd51] part of check-in [a3ca0adbaf] Add test1.c tcl bindings for sqlite3_column_text/blob_v2(). Replace, essentially randomly, some of the v1 API calls in capi2.test and capi2.test with the v2 calls to ensure identical results. Add a couple new tests comparing results between v1 and v2. (check-in: [a3ca0adbaf] user: stephan branch: column-text-blob-v2, size: 23290)
2021-07-30
23:30
[4ee545824a] part of check-in [d2da62a9df] Recognize certain standard datatypes ("INT", "INTEGER", "REAL", "TEXT", and "BLOB") and if a column has one of those datatypes, store the type part of the bit-field information in the Column structure to save space. (check-in: [d2da62a9df] user: drh branch: trunk, size: 22950)
2018-01-10
00:40
[34a1a9a96d] part of check-in [36b89d728f] 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. (check-in: [36b89d728f] user: drh branch: trunk, size: 22950)
2017-12-27
19:43
[d3267a146d] part of check-in [a8e1545cb7] Add and use the internal sqlite3DbSpanDup() interface. (check-in: [a8e1545cb7] user: drh branch: span-refactor, size: 22956)
2013-11-05
13:33
[011c16da24] part of check-in [54b2219297] 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. (check-in: [54b2219297] user: drh branch: omit-rowid, size: 22955)
2013-02-09
15:37
[e8b18cc610] part of check-in [3f67437536] 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. (check-in: [3f67437536] user: drh branch: constraint-error-codes, size: 22927)
2011-01-17
17:42
[835d4cee9f] part of check-in [053ce76deb] 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. (check-in: [053ce76deb] user: drh branch: trunk, size: 22733)
2011-01-11
01:42
[35145f8ab5] part of check-in [d1b3c54f42] 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. (check-in: [d1b3c54f42] user: drh branch: step-autoreset, size: 22545)
2010-04-17
12:53
[00032d7504] part of check-in [3e646e3f4c] 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. (check-in: [3e646e3f4c] user: drh branch: trunk, size: 22631)
2008-12-30
17:55
[172c717ed1] part of check-in [b090d5736d] Fix a bug in the multi-index OR cost estimator. Remove leftover "breakpoint" commands from test scripts. (CVS 6086) (check-in: [b090d5736d] user: drh branch: trunk, size: 22532)
2008-09-01
15:52
[36f87803c8] part of check-in [d04d703367] 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) (check-in: [d04d703367] user: drh branch: trunk, size: 22543)
2008-01-16
17:46
[cc64df7560] part of check-in [5807921f5a] Get all tests running without memory leaks. (CVS 4714) (check-in: [5807921f5a] user: drh branch: trunk, size: 22532)
2007-08-22
00:39
[3c5066836c] part of check-in [1914044b88] Reenable the memory management logic. The quick.test script now runs with SQLITE_MEMDEBUG and SQLITE_ENABLE_MEMORY_MANAGEMENT. 7 minor errors. (CVS 4265) (check-in: [1914044b88] user: drh branch: trunk, size: 22562)
2007-01-03
23:37
[7ecc9b342c] part of check-in [70a862702d] 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) (check-in: [70a862702d] user: drh branch: trunk, size: 22559)
2006-08-16
16:42
[cb478885b8] part of check-in [8c52d2ad46] Allows UPDATE, INSERT, and DELETEs to occur while a SELECT is pending on the same table. (CVS 3355) (check-in: [8c52d2ad46] user: drh branch: trunk, size: 22545)
2006-02-10
13:33
[cddd151c7b] part of check-in [c468aa349d] Minor test file modifications for builds compiled with OMIT options. (CVS 3077) (check-in: [c468aa349d] user: danielk1977 branch: trunk, size: 22491)
07:07
[e7d3f2e719] part of check-in [5e8611e13d] Fix the origin APIs so that they correctly handle views and subqueries that cannot be flattened. (CVS 3072) (check-in: [5e8611e13d] user: danielk1977 branch: trunk, size: 22256)
03:06
[fe07532d75] part of check-in [6ebb8f9bb2] Add a symbol P3_TRANSIENT to pass to VdbeSetColName() to make it copy the string parameter up to the first 0 byte. (CVS 3070) (check-in: [6ebb8f9bb2] user: danielk1977 branch: trunk, size: 20170)
02:27
[ca76487c52] part of check-in [82f502cdc1] Add the column_origin_name() etc. APIs. (CVS 3069) (check-in: [82f502cdc1] user: danielk1977 branch: trunk, size: 20123)
2006-01-03
00:33
[b9354d6c37] part of check-in [70b228575e] 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) (check-in: [70b228575e] user: drh branch: trunk, size: 17295)
2005-03-29
03:10
[f897209386] part of check-in [c41d55443c] Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) (check-in: [c41d55443c] user: danielk1977 branch: trunk, size: 17303)
2005-02-04
04:07
[2bd71f573b] part of check-in [2eb9087055] Remove code for SQL cursors. (CVS 2312) (check-in: [2eb9087055] user: danielk1977 branch: trunk, size: 17297)
2005-01-20
22:48
[b0e12aa666] part of check-in [38401dfbd5] Bug fixes and enhancements entered while on jury recess. (CVS 2246) (check-in: [38401dfbd5] user: drh branch: trunk, size: 16829)
2005-01-12
12:44
[325e8d68fe] part of check-in [4e28c82ada] Tests to improve coverage of main.c. (CVS 2202) (check-in: [4e28c82ada] user: danielk1977 branch: trunk, size: 16820)
2004-11-22
10:02
[8279d1d5ca] part of check-in [af635cab8a] Back out changes allowing writes to tables that have open cursors. (CVS 2134) (check-in: [af635cab8a] user: danielk1977 branch: trunk, size: 16710)
2004-11-16
15:50
[cd5e149564] part of check-in [a2e1c35b32] Perform deletes in a single pass. (CVS 2104) (check-in: [a2e1c35b32] user: danielk1977 branch: trunk, size: 16940)
2004-11-03
16:27
[1ec97bf889] part of check-in [b11fc9b3f3] Update tests to work even if some features of the library are disabled. (CVS 2050) (check-in: [b11fc9b3f3] user: drh branch: trunk, size: 16701)
2004-09-02
14:57
[53e3f39907] part of check-in [d1b2915655] 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) (check-in: [d1b2915655] user: drh branch: trunk, size: 16669)
2004-06-30
06:30
[78f2c48668] part of check-in [d256c14943] Add some tests for overlapping SELECT, COMMIT and ROLLBACK commands. (CVS 1774) (check-in: [d256c14943] user: danielk1977 branch: trunk, size: 16516)
2004-06-26
09:50
[fe61f341e9] part of check-in [0af3ff3942] Minor fixes related to the tests in misuse.test (CVS 1738) (check-in: [0af3ff3942] user: danielk1977 branch: trunk, size: 16510)
2004-06-21
07:36
[9ad428f7f2] part of check-in [ee9dffd986] Update sqlite3_column_decltype() to return NULL as the declartion type for an expression that is not a column reference. (CVS 1646) (check-in: [ee9dffd986] user: danielk1977 branch: trunk, size: 17115)
06:50
[7ff5ef9efe] 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: 17120)
2004-06-19
00:16
[7a0d71b27c] part of check-in [d705d051be] 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) (check-in: [d705d051be] user: drh branch: trunk, size: 16834)
2004-06-15
02:44
[b161d9d808] part of check-in [4f5e253082] (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) (check-in: [4f5e253082] user: danielk1977 branch: trunk, size: 16840)
2004-05-21
10:08
[8fb64e8ab7] part of check-in [fc94575d77] Further work on the new API. All the functions to execute queries are there now. (CVS 1427) (check-in: [fc94575d77] user: danielk1977 branch: trunk, size: 13196)
01:47
[007f856cc7] part of check-in [307b55006c] Add new sqlite3_open() and sqlite3_open16() APIs. (CVS 1423) (check-in: [307b55006c] user: danielk1977 branch: trunk, size: 13177)
2003-08-05
13:13
[ec96e0e235] part of check-in [086aa1c992] Provide a more informative error message when a uniqueness constraint fails. Ticket #419. (CVS 1068) (check-in: [086aa1c992] user: drh branch: trunk, size: 13069)
2003-07-09
00:28
[9634deaa27] part of check-in [dd84f88f6c] Allow the output arguments in sqlite_compile and sqlite_step to be NULL pointers. Tickets #384 and #385. (CVS 1049) (check-in: [dd84f88f6c] user: drh branch: trunk, size: 13080)
2003-06-28
16:20
[3663b62fe3] part of check-in [e2ca936fee] Fix a bug in the soundex() code. Ticket #367. Add tests for ticket #261 even thought the problem could not be reproduced. (CVS 1035) (check-in: [e2ca936fee] user: drh branch: trunk, size: 12828)
2003-05-16
02:30
[dddfe84d41] part of check-in [0f92736d1f] 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) (check-in: [0f92736d1f] user: drh branch: trunk, size: 12652)
2003-03-01
19:53
[fb94bed9e2] part of check-in [13e501d190] Add more tests to make sure that sqlite_changes() works when using the non-callback API. Ticket #250. (CVS 876) (check-in: [13e501d190] user: drh branch: trunk, size: 12651)
19:45
[b5c7fd0b34] part of check-in [620e1065e9] 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) (check-in: [620e1065e9] user: drh branch: trunk, size: 12352)
2003-02-16
22:21
[0c82193ae6] part of check-in [75ba78280f] Added test code to check for file descriptor leaks. All regression tests pass now on both win2k and linux. (CVS 868) (check-in: [75ba78280f] user: drh branch: trunk, size: 11457)
2003-01-29
22:58
[b0b4b73b3e] part of check-in [af1e929946] Additional testing and bug fixing with the non-callback API. Updated the C/C++ interface document to describe the non-callback API. (CVS 855) (check-in: [af1e929946] user: drh branch: trunk, size: 11446)
18:46
[21f73319ae] part of check-in [ccc82f1ab4] Better error messages on constraint violations. Additional tests and bug fixes for the callback-free API. (CVS 854) (check-in: [ccc82f1ab4] user: drh branch: trunk, size: 4570)
14:06
Added: [158d76afd0] part of check-in [162b259188] The callback-free API is now working, though much more testing is need. (CVS 853) (check-in: [162b259188] user: drh branch: trunk, size: 2659)