1
0
mirror of https://github.com/sqlite/sqlite.git synced 2025-07-26 09:41:10 +03:00
Commit Graph

9780 Commits

Author SHA1 Message Date
drh
ee696e2218 Better detection and handling of corrupt database files. (CVS 1922)
FossilOrigin-Name: 8f5b199e845fa7ae3444ef69bd840716d305cf73
2004-08-30 16:52:17 +00:00
drh
8cdbf83690 Corrections to transient table handling in compound select statments.
Tickets #826 and #875. (CVS 1912)

FossilOrigin-Name: 9cc765be4611a248cfcce1243fd1bbeaf5202968
2004-08-29 16:25:03 +00:00
drh
2c6674cf7e Host parameter names conform to SQL-2003. (CVS 1902)
FossilOrigin-Name: fd584d1ccf6643b723c2ff0a7a16c2aea3f1142c
2004-08-25 04:07:01 +00:00
drh
fdb38064b0 Fix a pager bug that might have made multi-database commits non-atomic
if a power failure occurred at just the wrong moment. (CVS 1900)

FossilOrigin-Name: b6eb4bf8c7763ef73723fc3d3697af435c19bae4
2004-08-21 19:20:42 +00:00
drh
290c19482e Optimizations to the code generator. (CVS 1899)
FossilOrigin-Name: bd6649c5aae1bf182610eb267b546c297a34481d
2004-08-21 17:54:45 +00:00
drh
92febd92ad Tcl interface transfers values directly between SQLite and Tcl_Objs, without
at translation to strings. (CVS 1898)

FossilOrigin-Name: e97c331362545ce21117776c7b61d3488668f2bf
2004-08-20 18:34:20 +00:00
drh
895d747226 Add support for named wildcards in SQL statements. (CVS 1897)
FossilOrigin-Name: d3be0b7c5a39c02b9b2d6d85f1595d591984a569
2004-08-20 16:02:39 +00:00
drh
cb4c40ba0e Make sure the database file is correctly truncated after a ROLLBACK that
occurs after a statement abort. (CVS 1893)

FossilOrigin-Name: 6afe467d146828d67ad17af21604c2e691aa5dff
2004-08-18 19:09:43 +00:00
drh
2b74d70a38 Better debug logging of the pager. (CVS 1892)
FossilOrigin-Name: 1cc0323f2597584b3f3239e8948ac3ff3db8da03
2004-08-18 16:05:18 +00:00
drh
34f4732b06 Be more agressive about not creating or opening the TEMP database if there
are no TEMP tables. (CVS 1891)

FossilOrigin-Name: 6b2b6b2dbd821070a2781685c4b63a50bc8f5cae
2004-08-18 15:58:22 +00:00
drh
dc3ff9c34c Avoid creating a TEMP database unless it is absolutely necessary. (CVS 1890)
FossilOrigin-Name: 5914a11caa4c6e778cd7ca010427897c8f971552
2004-08-18 02:10:15 +00:00
drh
ae15787643 If meta(3)>0 then make the database readonly for now. This allows the current
database to interact with future releases that might include autovacuum. (CVS 1888)

FossilOrigin-Name: 7619bf4771781005da23a3e9d7b00de405e27a64
2004-08-14 19:20:09 +00:00
drh
8dcd7cab83 Attempting to open a locked table for writing should fail immediately.
Ticket #842. (CVS 1880)

FossilOrigin-Name: fc879a9b1d05ddb8f8c552c1d334597e41b29b27
2004-08-08 19:43:29 +00:00
drh
1d64fc1a5e Do not invoke the busy callback when trying to promote a lock from SHARED
to RESERVED.  This avoids a deadlock. (CVS 1879)

FossilOrigin-Name: d33771a303d9c20dd477b1a973024ff763203211
2004-08-07 23:54:48 +00:00
drh
00afe0b374 Fix a bug in the logic that converts numbers into strings inside the VM.
Ticket #844 (CVS 1878)

FossilOrigin-Name: 863540be248d3079e1a997349be6c74199149511
2004-08-06 17:00:40 +00:00
drh
db2d9a0bbb Fix a memory leak when the auxiliary data of a database structure is used. (CVS 1874)
FossilOrigin-Name: 7ecff04a6153aa200233e6c0846a65e0213c3179
2004-08-01 03:52:17 +00:00
drh
9796ef5804 Additional test case to cover ticket #831. (CVS 1872)
FossilOrigin-Name: a62129af99b4a576a48eb4931f417af257f510c7
2004-07-27 13:38:47 +00:00
drh
adfa3daf49 Honor the ORDER BY clause in a subquery that is the right-hand side of an IN
operator.  Ticket #827. (CVS 1871)

FossilOrigin-Name: 76fe68cff6ce75dada510544b063dc1069eb2e0e
2004-07-26 23:32:26 +00:00
drh
cced337e35 Get VACUUM working with UNIQUE indices. Ticket #829. (CVS 1870)
FossilOrigin-Name: 88a19a4386708c3c10448740d2bbe149055bcc6e
2004-07-26 23:07:51 +00:00
drh
1211de3709 Fix problems for 64-bit machines and when SQLITE_OMIT_AUTHORIZATION is defined. (CVS 1868)
FossilOrigin-Name: e3cad1ab6226089265b4d15c6fc67cc33a31425f
2004-07-26 12:24:22 +00:00
drh
956bc92cde Prepared statements now work with CREATE and DROP. All tests pass.
No memory leaks. (CVS 1866)

FossilOrigin-Name: ebdb661e0eefe123c422d3c1c371e325bb6cf673
2004-07-24 17:38:29 +00:00
drh
3f7d4e49d8 Fix more problems with deferred execution of CREATE. Still need to do DROP.
There is now a memory leak. (CVS 1865)

FossilOrigin-Name: 6db3f122aad25b5226670ce682b7263d55c0d301
2004-07-24 14:35:58 +00:00
drh
234c39dff7 Progress towards getting prepared statements and CREATE and DROP to play
nicely together.  Work is incomplete.  Some tests are known to fail. (CVS 1864)

FossilOrigin-Name: 49b991492496e104f5eca620a5d465a742b7ff3a
2004-07-24 03:30:47 +00:00
drh
25d6543de5 Fix bugs associated with the codec. (CVS 1846)
FossilOrigin-Name: b0a3becd82b9a4203c23f35dc5a5fd725e046f21
2004-07-22 15:02:25 +00:00
drh
6d08b4d647 Add the '%ifdef' capability to lemon. Other minor changes. (CVS 1836)
FossilOrigin-Name: 522ff721ccc33c4b89072fed4e451f0df82e8140
2004-07-20 12:45:22 +00:00
drh
cf55b7aef7 Handle quotes on the table name in TABLE.* terms in SELECT statements.
Ticket #680. (CVS 1833)

FossilOrigin-Name: 826b6797a9f08c69b9378cb403d746e91a54dcde
2004-07-20 01:45:19 +00:00
drh
78d153eecd Add test for creating indices with quoted names. Ticket #695. (CVS 1831)
FossilOrigin-Name: 7e72c5b7b5e355e41c30d4ef47268e11f4c97425
2004-07-20 00:52:44 +00:00
drh
2c61c070d2 Correct handling of views on tables with quoted column names. Ticket #756. (CVS 1826)
FossilOrigin-Name: 8ac5a8ad5eec381585adb6812fc39a1a30aee4c1
2004-07-20 00:20:23 +00:00
drh
bab39e1358 Refinements to the LIMIT patch (1823) for ticket #749. (CVS 1825)
FossilOrigin-Name: 9d4f43f030438b3e7358032de2e04132b80e04a8
2004-07-19 23:38:11 +00:00
drh
ea48eb2eef LIMIT occurs after DISTINCT. Ticket #749. (CVS 1823)
FossilOrigin-Name: e6bc8aa80824a9156e78fc99b5ac7045b97d29c3
2004-07-19 23:16:38 +00:00
drh
8d7e24f1d3 Remove debugging code that was accidently left in join4.test. (CVS 1819)
FossilOrigin-Name: e36e59f02eec166ef2c4e0991c97ceb536e3c3f3
2004-07-19 19:28:44 +00:00
drh
2ffb11855a Fix for ticket #813. (CVS 1818)
FossilOrigin-Name: 88e4bfa154e33c627ff2abb15cc55a100359d370
2004-07-19 19:14:01 +00:00
drh
c275b4ea91 Store schema cookies on the TEMP database. Ticket #807. (CVS 1817)
FossilOrigin-Name: c6c13dc460094e6adea2b14849edf9f485238b99
2004-07-19 17:25:24 +00:00
drh
8feb4b1d9e Correctly handle joins of more than 32 tables. Ticket #806. (CVS 1812)
FossilOrigin-Name: 880644097004cba1e215a5697d0553b3b98c9884
2004-07-19 02:12:14 +00:00
drh
755b6ba9f0 A failed ATTACH leaves the database in a consistent state. Ticket #811. (CVS 1811)
FossilOrigin-Name: c22f9feb1bb00d1d54a8a87b557195573463fda9
2004-07-19 00:56:23 +00:00
drh
5f6a87b3dd When comparing two expressions do not apply affinity to either operand.
Ticket #805. (CVS 1810)

FossilOrigin-Name: 88a4e400f916d7af088b39a9653d6452b3666577
2004-07-19 00:39:45 +00:00
drh
83ca160a33 Unsuccessful attempt to reproduce ticket #807. (CVS 1809)
FossilOrigin-Name: d7e9772c74a2b9377f17149cc1baa3b2d0dfbfb8
2004-07-18 23:47:53 +00:00
drh
1020d49a31 The %W date specifier in strftime should be measured from the first Monday
of the year.  Ticket #758. (CVS 1805)

FossilOrigin-Name: 50b016b00470e6303ede1173d0447d8239563263
2004-07-18 22:22:43 +00:00
drh
1af3fdb4dc An improved fix for the min() problem of ticket #800. (CVS 1804)
FossilOrigin-Name: b6e8b7a13cd9f90e2f7d963d9ddbe591571f3a27
2004-07-18 21:33:01 +00:00
drh
9eb516c0eb min() ignores NULL values. Ticket #800. (CVS 1802)
FossilOrigin-Name: 166234a2b61e1d6a501e48dde1caec0a02bec90b
2004-07-18 20:52:32 +00:00
drh
e29b1a05a7 mprintf() correctly handles "%s","". Fix for ticket #812. (CVS 1800)
FossilOrigin-Name: 4f56db1149f65dc2edf6626fa20ae255a5f5280c
2004-07-17 21:56:09 +00:00
drh
4ebfef14e3 Added tests for sqlite3_changes after a DELETE. (CVS 1798)
FossilOrigin-Name: c01f13267f592dc2678e78ea45dadddcdc154f82
2004-07-15 20:08:39 +00:00
drh
75f6a032c4 Implement the experimental sqlite3_bind_parameter_count() API in support
of DBD::SQLite.  Also fix the sqlite3.def export list. (CVS 1797)

FossilOrigin-Name: c44943e6fe0c88830102253591a501dc7d724d2f
2004-07-15 14:15:00 +00:00
drh
3ea64406fc Skip bigfile.test on Mac OS X. Darwin does not handle large sparse files
efficiently and so this test takes a really long time. (CVS 1779)

FossilOrigin-Name: a3c38a6d286ab37a9cdcc8b2243ea3258cc61ff0
2004-06-30 11:28:13 +00:00
drh
91b48aa1af When a statement causes a ROLLBACK due to an ON CONFLICT clause, other active
VMs abort. (CVS 1778)

FossilOrigin-Name: 0fedf74e30026afe2c8caacff3d62cf5c1b1f528
2004-06-30 11:14:18 +00:00
05056307fd Make sure vacuum.test closes all files. (CVS 1777)
FossilOrigin-Name: 4077f9a30b0c30a8749a596031aa4f7adc3a4891
2004-06-30 10:54:29 +00:00
96fb0dd55a Coverage tests for vacuum.c (CVS 1776)
FossilOrigin-Name: 152e9940b919a53fcd0da4091dbf75ab8ef15b38
2004-06-30 09:49:22 +00:00
bc6ada4103 Fixes for compiler warnings. Also more coverage. (CVS 1775)
FossilOrigin-Name: fa19c77bf045787faa4cdc40bcfbd9eeae8594ae
2004-06-30 08:20:16 +00:00
46c43edd39 Add some tests for overlapping SELECT, COMMIT and ROLLBACK commands. (CVS 1774)
FossilOrigin-Name: d256c14943968e7adf4b73988cac6af941c9b12d
2004-06-30 06:30:25 +00:00
drh
9d213ef022 Improve test coverage of util.c (CVS 1773)
FossilOrigin-Name: 68ac32213766c5e83de54373b90030a458538017
2004-06-30 04:02:11 +00:00