bahman/sqlite
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
1,373 Commits 1,672 Branches 385 Tags
version-2.8.15
Commit Graph

473 Commits

Author SHA1 Message Date
drh
73003316a2 Add join tests to the 2.8 branch. (CVS 1850) 
FossilOrigin-Name: e5546f49c79155ed2695a1d58ca8044e79d60802
 2004-07-22 16:08:38 +00:00
drh
5d7f6e84f1 Handle quotes on table names in TABLE.* terms in SELECT. Ticket #680. (CVS 1834) 
FossilOrigin-Name: 9937ffb08e6eb3a11344d880cade9975e8dc9d5b
 2004-07-20 01:45:49 +00:00
drh
8c8ec4fd3e Fix the handling of indices with quoted names. Ticket #695. (CVS 1830) 
FossilOrigin-Name: 467309975f40bdc1ac0ed1c9c34d187e91217e12
 2004-07-20 00:50:29 +00:00
drh
0e93442494 Correct handling of views on tables with quoted column names. Ticket #756. (CVS 1827) 
FossilOrigin-Name: ef0d5ebe96b9babe275d62ed6abe95652838de5f
 2004-07-20 00:20:46 +00:00
drh
9c46d69216 Limit occurs after DISTINCT. Ticket #749. (CVS 1824) 
FossilOrigin-Name: db5ae13db3edec82dd2ead3b76fc9f89f33b2dc2
 2004-07-19 23:33:02 +00:00
drh
a8734da09b Fix for ticket #813. (CVS 1820) 
FossilOrigin-Name: 0cc612f8aa458034d3dc246861c529c57ac5b2b1
 2004-07-19 19:30:50 +00:00
drh
6951f39c72 The %W date specifier in strftime should be measured from the first Monday 
of the year.  Ticket #758. (CVS 1806)

FossilOrigin-Name: 135e5447f66fcd8ec4350c81707a2e8d3c9fd31c
 2004-07-18 22:25:15 +00:00
drh
805e7d5b42 Min() and max() ignore NULL values. Ticket #800. (CVS 1803) 
FossilOrigin-Name: 223521c04e8ad39e06fee455f7dbb31ace2d3800
 2004-07-18 21:14:05 +00:00
drh
ca69323478 The MIN() aggregate function returns NULL if any element in the result 
was NULL.  This makes MIN() consistent with ORDER BY which sorts NULL first.
Ticket #777. (CVS 1679)

FossilOrigin-Name: 78ced6e3092d69e7cb77c5c2acff70f3c92e6523
 2004-06-23 21:16:51 +00:00
danielk1977
f4ed02a34f Backport of (1628) to version 2. (CVS 1631) 
FossilOrigin-Name: cce250eaee59eac2d15437b564f049c5b241317c
 2004-06-19 04:23:25 +00:00
drh
f9ec81c84d Improvements to testing of sqlite_interrupt. More checking for interrupt 
inside of VACUUM. (CVS 1344)

FossilOrigin-Name: d596f513c3acfe0d297dc3f5c66f4b0ea2d12a34
 2004-05-10 20:27:41 +00:00
drh
1bdd9b5787 Get the temp_store and default_temp_store pragmas working. Update the 
documentation.  Also fix a malloc problem that popped up during the regression
testing. (CVS 1302)

FossilOrigin-Name: 7ace576215367101904677bd69951755ee9cb1a1
 2004-04-23 17:04:44 +00:00
drh
8b8891bf0a Fix a VDBE stack overflow that occurs when the left-hand side of an IN 
expression is NULL and the result is stored on the stack rather than used
to control a jump.  Ticket #668. (CVS 1299)

FossilOrigin-Name: fc7a7975b03c144c2db3566facd008d3701c735e
 2004-03-17 23:32:08 +00:00
drh
6e17529e97 Fix the min/max optimizer so that it works when the FROM clause is a 
subquery.  Ticket #658. (CVS 1293)

FossilOrigin-Name: 31c94acc72d318b5dec0fef1485621943add45c8
 2004-03-13 14:00:36 +00:00
drh
489c4677a0 Bump the version number to 2.8.13. Patch up the limit test so that it works 
in spite of ticket #521 - we don't want any tests failing in an official
release even if there are bugs. :-D (CVS 1285)

FossilOrigin-Name: 2c6bd21ed0e212109cfb4a37cfac2a10ab58a024
 2004-03-08 13:26:17 +00:00
drh
79f14b7240 A vdbe stack element might have a string value even after a call to 
Integerify().  Ticket #641. (CVS 1283)

FossilOrigin-Name: 3cac4b7b526d6c5dbf394009b534707bcb65b0da
 2004-03-03 01:51:24 +00:00
drh
b1aa04fccc Make sure a LIMIT clause on a SELECT cleans up the vdbe stack so that if it 
occurs inside a trigger, it won't cause a stack overflow.  Ticket #640. (CVS 1282)

FossilOrigin-Name: 5aaa2939baa972231def086ed5f9d9ba63302532
 2004-03-02 18:37:41 +00:00
drh
0d131ab716 One more fix to the new HH:MM:SS modifier. This time add some test 
procedures too. (CVS 1280)

FossilOrigin-Name: 7b3b8968ee9a5349dd6e9ae1e7a311bf8906607c
 2004-02-29 01:08:17 +00:00
rdc
f146a77677 Add comments and prototype for experimental sqlite_last_statement_changes() API function. Also, allow function to be called from tcl. (CVS 1273) 
FossilOrigin-Name: ca99920b0dbf773962b47766d690154fd1276513
 2004-02-25 22:51:06 +00:00
drh
268380ca9e Min() and max() functions honor the distinction between TEXT and NUMERIC 
data.  Ticket #623.  typeof() is now a user function.  Some tests are
now failing due to ticket #521. (CVS 1272)

FossilOrigin-Name: adbe31adf1ad0ca723203ca3d7dc480324c60d43
 2004-02-25 13:47:31 +00:00
drh
946966f2a1 Disable an assert which (as it turns out) is not always true. Ticket #615. (CVS 1269) 
FossilOrigin-Name: 2773c1d384b750eee037e6ccc61bc56b5204d690
 2004-02-25 02:20:41 +00:00
drh
02f75f19e5 Make sure BEGIN, COMMIT, and ROLLBACK are really no-ops when preceded 
by EXPLAIN.  Ticket #626. (CVS 1267)

FossilOrigin-Name: 2af1f065b5eb39fd3ecac00f8a66d1b4186aead5
 2004-02-24 01:04:11 +00:00
drh
b621c23775 Test cases for printf of double overflows. (CVS 1260) 
FossilOrigin-Name: 96a6d2d3ff5bd0aaff188ee1c5e2f02cbea435b2
 2004-02-21 19:41:04 +00:00
drh
8eb2cce55c Enhance date/time functions to work with negative years. Ticket #617. (CVS 1255) 
FossilOrigin-Name: ffa971934867b6bbe943c004154d5f161e0ea697
 2004-02-21 03:28:18 +00:00
rdc
a503d7312a Fixed behaviour of last_insert_rowid() with triggers and add last_statement_change_count() function that works correctly with triggers. (CVS 1252) 
FossilOrigin-Name: 6734c923395ca41ce453f56dd7d6e7794fbb3bb5
 2004-02-20 22:54:25 +00:00
drh
9cbe7ca7db Fix a memory leak that occurs if you call sqlite_interrupt() on a query 
using aggregate functions where the aggregate function returns a string
longer than 32 characters. (CVS 1248)

FossilOrigin-Name: 2c1e74e58a702fd2be954467a12e69a33b252831
 2004-02-18 16:57:23 +00:00
drh
230680276c Add more tests of the sqlite_interrupt() logic - looking for a reported 
memory leak.  (Didn't find it.) (CVS 1246)

FossilOrigin-Name: e4c8b1c3aa9d288f518c6394187354e6fa18978e
 2004-02-18 01:31:53 +00:00
dougcurrie
960ac04f4f Avoid line endings munging by Cygwin; ticket #370 (CVS 1245) 
FossilOrigin-Name: 50e67948f89380f2f4b536add0b8179e6db960a5
 2004-02-17 18:26:57 +00:00
drh
a1f9b5ee0b The sqlite_exec() function is now implemented using sqlite_compile() and 
sqlite_step().  This opens up lots of opportunity to remove old code. (CVS 1240)

FossilOrigin-Name: 9771ad1e811e02e10bb738550fbea447749083c5
 2004-02-14 16:31:02 +00:00
drh
b5f70c2ef1 Disable the malloc.test tests if not compiled with -DMEMORY_DEBUG (CVS 1239) 
FossilOrigin-Name: 41b6ad78a6097f35bfac6ff40d2e5d6071a1c4cd
 2004-02-14 01:39:50 +00:00
drh
c602f9ae01 Add the SQLITE_NOTADB return code for cases when you try to open a file 
that does not even remotely resemble an SQLite database file. (CVS 1233)

FossilOrigin-Name: 0c77cee70f078152969933c1d340cea1c86286b0
 2004-02-12 19:01:04 +00:00
drh
4d189ca48f Add hooks on each attached database connection for storing auxiliary 
information.  Add the USING clause to ATTACH. (CVS 1232)

FossilOrigin-Name: 800c11f4bce014a07110eb539992a609e6418406
 2004-02-12 18:46:38 +00:00
drh
3054efee07 All REPLACE INTO syntax inside of triggers. Ticket #610. (CVS 1231) 
FossilOrigin-Name: a6b862a9db6d409a53cc13e7008b27d4848b5509
 2004-02-12 17:28:13 +00:00
drh
8ef83ffed8 Always reload the schema after a rollback. Ticket #594. (CVS 1229) 
FossilOrigin-Name: 12c7a83f8e4055c4590983ef212648c781ebd963
 2004-02-12 15:31:21 +00:00
drh
93581642d2 VACUUM returns SQLITE_INTERRUPT when interrupted. Ticket #593. (CVS 1228) 
FossilOrigin-Name: 2fe9f5101cb0f743532912ece3d37f6c873e7025
 2004-02-12 13:02:55 +00:00
drh
9eb9e26b82 Pass all (relevant) regression tests when using the codec. (CVS 1223) 
FossilOrigin-Name: 5200e9edc5fdba0285a3cb1cd808cbf66d7a349e
 2004-02-11 02:18:05 +00:00
drh
fb044c1d1c Perform updates in search order. Ticket #602. (CVS 1221) 
FossilOrigin-Name: cf1cec74ae039cd7cbc8a1032d29f067dedb4210
 2004-02-10 13:41:52 +00:00
drh
d0ba193dc7 Allow SQLITE_PAGE_SIZE to be redefined on the compiler command-line. (CVS 1217) 
FossilOrigin-Name: 4c7bf714b5f3d2bb7366367ddf906141a7e36407
 2004-02-10 01:54:28 +00:00
drh
e2201971ac Add test case for ticket #601. (CVS 1215) 
FossilOrigin-Name: 096312dacb9eb2f8da3cec1504aef8629b505e7f
 2004-02-09 14:35:28 +00:00
drh
585a3d7c22 Add the crashtest1.c program used to test the ability of the database to 
survive a program crash or power failure.  Ticket #599. (CVS 1210)

FossilOrigin-Name: 597a59a72d662b291fb09a069547efd08aa5adb1
 2004-02-08 06:06:37 +00:00
drh
e84a306b91 Remove undocumented extensions from sqlite_mprintf() and friends in order to 
make it about 10% smaller. (CVS 1207)

FossilOrigin-Name: 0b3f552b986fd89c48c350b0746be93b9d276ecc
 2004-02-02 12:29:25 +00:00
drh
22fbcb8ddd Fix the handling of -init option to the sqlite shell. Ticket #568. 
Also add hooks for encrypting the database. (CVS 1206)

FossilOrigin-Name: 3c796de8d1af55944f396f08feaa9e69c1652896
 2004-02-01 01:22:50 +00:00
drh
0c37e6309b Make sure min() and max() optimizations work for subqueries. Ticket #587. (CVS 1201) 
FossilOrigin-Name: af73fbca839f8cbe39c21f1f9e439fe9b79005c8
 2004-01-30 02:01:03 +00:00
drh
b733d03749 Add the ability to group FROM terms using parentheses. Names of columns in 
a join no longer include the table name. (CVS 1197)

FossilOrigin-Name: 3626f6d4a1adb4209d5bd9e6477343b52bddbdf2
 2004-01-24 20:18:12 +00:00
drh
30c84bfd5f In test programs, an SQLITE_SCHEMA return is retried repeatedly, not just once. (CVS 1195) 
FossilOrigin-Name: df3509e13dc05751b7a5af07b57bca449fe5244c
 2004-01-21 13:35:13 +00:00
drh
0bca353087 Make ATTACH and DETACH work with the non-callback API. Ticket #574. (CVS 1194) 
FossilOrigin-Name: c32a80fe3cd6dda5238e59bd48d9dd22b4856304
 2004-01-20 11:54:03 +00:00
drh
d1bec47a3d More aggressive retry schedule in sqlite_busy_timeout(). (CVS 1181) 
FossilOrigin-Name: 5e85025be7aa4a03b0cfb4d0f28a2e44653b9d3f
 2004-01-15 13:29:31 +00:00
drh
23b2db23b4 Allow "<expr> IN <table>" as a shorthand for 
"<expr> IN (SELECT * FROM <table>)" (CVS 1180)

FossilOrigin-Name: 01874d252ac44861e927dea3f5534f67e19b1fa8
 2004-01-15 03:30:24 +00:00
drh
aa940eacfe Reinsert the experimental sqlite_commit_hook() API. (CVS 1179) 
FossilOrigin-Name: 72bc84f2f18f6eeb279a4ad670310e85d154f663
 2004-01-15 02:44:03 +00:00
drh
751f41217e Fix comparisons of ROWID against floating point numbers so that they work 
correctly.  Ticket #377 and #567. (CVS 1178)

FossilOrigin-Name: c9ac3db8e08403398ec344757385334601a59374
 2004-01-14 21:59:22 +00:00