d9c847dcd1
Reset the temp_store_directory each iteration of tests in all.test. (CVS 2181)
...
FossilOrigin-Name: 7373a5d4cf2db921b33132c736ad62ab702d7cde
2005-01-07 10:42:48 +00:00
49d642dba8
Allow GROUP BY on aggregate queries only. Ticket #1039 . (CVS 2176)
...
FossilOrigin-Name: 8ef2c644ebce851d7a3e0db3b2266fc2519485cd
2005-01-03 02:26:54 +00:00
c89b91beee
Fix typos in comments in test code.
...
(Oops. This check-in also picked up some unrelated
changes to documentation.) (CVS 2175)
FossilOrigin-Name: 586acc85b170f84d6e0dbd2e293da19551242f5a
2005-01-03 01:32:59 +00:00
9a09a3caed
Add PRAGMA 'temp_store_directory'. Added os_*.c function
...
sqlite3OsIsDirWritable(), split pragma.c changeTempStorage() function into
invalidateTempStorage(). (CVS 2171)
FossilOrigin-Name: 772e22cbd69463be41c2e73b4fd4eb33946193c4
2004-12-20 19:01:32 +00:00
9012bcbc0a
The optimizer now uses only the index and ignores the table if it can get
...
away with doing so, thus saving a single BTree search per row of result.
This could potentially double the speed of certain queries. The
code passes all regression tests but new tests to exercise the new
functionality are yet to be added. (CVS 2170)
FossilOrigin-Name: e5aa489453bf31126da6473ef93c89ec27935cde
2004-12-19 00:11:35 +00:00
51669863a8
Improvements to the query optimizer. This is a work in progress. (CVS 2169)
...
FossilOrigin-Name: 9b86993ff721b577b920c7c67fb41d3d4355fe88
2004-12-18 18:40:26 +00:00
1067fe1104
Add 'copy' method for tcl interface. Behaves similar to shell .import or COPY statment in 2.x. (CVS 2167)
...
FossilOrigin-Name: a9311d9df054a91e231d4e4332df0d661675744d
2004-12-17 15:41:11 +00:00
be5fd4906d
Make sure LIMITs are handled correctly on UNION operators. Ticket #1035 . (CVS 2166)
...
FossilOrigin-Name: ece0085f86bd715c95a6c59f41b4a97de2555faf
2004-12-16 21:09:16 +00:00
2530378003
Only evaluate expressions once for UPDATE and INSERT statements that
...
have BEFORE triggers. Fix for ticket #980 . (CVS 2158)
FossilOrigin-Name: 4852186aca3be6ea40069b6831079197e5fa757a
2004-12-07 15:41:48 +00:00
251b067ccd
fulltest runs now, but still finds a memory leak. (CVS 2150)
...
FossilOrigin-Name: 5944d51e6c164270301b57e4351add4cb6137be6
2004-11-23 22:16:39 +00:00
1d54df88e3
Add authorization callbacks for REINDEX. (CVS 2148)
...
FossilOrigin-Name: 9f0d744ee4d99f44e88c6f799821791c3b5f31b6
2004-11-23 15:41:16 +00:00
11cf9fbcf2
Make the test suite pass when SQLITE_OMIT_SCHEMA_VERSION_PRAGMAS is defined. (CVS 2146)
...
FossilOrigin-Name: ff20c623c64d67b19c13c4fd3afe8ea137bb8a0b
2004-11-23 11:16:42 +00:00
c7b4a44cda
Ensure the test suite runs with SQLITE_OMIT_PAGER_PRAGMAS defined. (CVS 2145)
...
FossilOrigin-Name: 2d1f0b923d3c5a669959a03a4344fddcb69c7a98
2004-11-23 10:52:51 +00:00
27188fb5f0
Have tests pass when SQLITE_OMIT_SCHEMA_PRAGMAS is defined. (CVS 2144)
...
FossilOrigin-Name: 6ccb589bd94fc7d33e07caa39e011c3628563e9b
2004-11-23 10:13:03 +00:00
ae82558bd0
Fix a bug involving balance_shallow() and the sqlite_master table. (CVS 2143)
...
FossilOrigin-Name: 557be3ff5b1c46a3f3836ea3a9d9dede5dc46998
2004-11-23 09:06:55 +00:00
e4e7207248
More work on the implementation of cursors, but they are still not
...
functioning. (CVS 2142)
FossilOrigin-Name: 8b61d1ae1ca469b80f2b344d550c3b363448b193
2004-11-23 01:47:30 +00:00
b6c29897eb
Add initial infrastructure for cursors. In where.c, optimize out clauses
...
of the form "ORDER BY rowid" if a table scan is being performed. Do a
reverse table scan if "ORDER BY rowid DESC" is present. (CVS 2141)
FossilOrigin-Name: fc8c1393c86017a816beb52725b68af3b973f979
2004-11-22 19:12:19 +00:00
d8702b4d40
Fix a couple of extra test-suite problems with SQLITE_OMIT_VIEW. (CVS 2139)
...
FossilOrigin-Name: 894c142d115b31506b6b8212e1b850ea28c4ca11
2004-11-22 15:05:58 +00:00
27c774388a
Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138)
...
FossilOrigin-Name: 007be591b7829f9ff38e4b14ba5a5043796c2ff3
2004-11-22 13:35:41 +00:00
81650dc6c8
Ensure tests pass when SQLITE_OMIT_TRIGGER is defined. (CVS 2137)
...
FossilOrigin-Name: 53894988ac1ad44ec65a1e1c420e2a26eb4c2efd
2004-11-22 11:51:13 +00:00
125254784d
Fix a test-suite error made in check-in (2132) (CVS 2136)
...
FossilOrigin-Name: 48c7eb7fb9fbc2166aaa7dbdb7c7e92c68f8eff3
2004-11-22 10:20:13 +00:00
12b13002ce
Back out changes allowing writes to tables that have open cursors. (CVS 2134)
...
FossilOrigin-Name: af635cab8a1d761c469e35208dda08a29f0964a1
2004-11-22 10:02:21 +00:00
0fa8ddbdec
Modify test suite to work when SQLITE_OMIT_VIEW is defined. (CVS 2132)
...
FossilOrigin-Name: 711e8d7695dfc74b3f1ee00591dcdda2cd7fc7d5
2004-11-22 08:43:32 +00:00
03aded4924
Have tests pass when SQLITE_OMIT_MEMORYDB is defined. (CVS 2131)
...
FossilOrigin-Name: 9df837c03939cdcb31856ac17b2425a6dd92d7b2
2004-11-22 05:26:27 +00:00
215e64da5e
Fix auth.test to work when SQLITE_OMIT_ALTERTABLE is defined. (CVS 2130)
...
FossilOrigin-Name: 27a8379b54d6a1169b89e540ba44f4f94d006fb7
2004-11-22 03:34:21 +00:00
b08153d0fb
Better error message on an SQLITE_RANGE error. Ticket #991 . (CVS 2124)
...
FossilOrigin-Name: accd432e4d9626353e555e63298fb7a56a41e53d
2004-11-20 20:18:55 +00:00
4693423b09
Rig the sqliteMalloc() routine so that we can make it fail multiple times
...
in a row. Modify the malloc.test procedure to make malloc fail in this
way and verify that the failures are still handled correctly. (CVS 2121)
FossilOrigin-Name: 519bc9d9975bbdb4ba056799534d5c465e0cd042
2004-11-20 19:18:00 +00:00
023f41762c
Ensure ALTER TABLE respects the system table convention - "sqlite_*". (CVS 2115)
...
FossilOrigin-Name: f635b6aae661ac85eec49b197f3bb4b85172a457
2004-11-19 08:41:34 +00:00
aacd732b11
Update the sqlite_sequence table when a table is renamed with ALTER_TABLE. (CVS 2114)
...
FossilOrigin-Name: 6e971868808e3c3f77fa521de626f1510ba9644a
2004-11-19 08:02:14 +00:00
343e92610e
Fix bugs in ALTER TABLE related to (a) whitespace in table defn, (b) temp triggers. (CVS 2112)
...
FossilOrigin-Name: 1fd8e835a3656799c23f4ef6ea1311fecf5a15cb
2004-11-19 05:14:54 +00:00
d641d646ff
Handle triggers correctly in ALTER TABLE. (CVS 2111)
...
FossilOrigin-Name: c61b7de107cea76b561d0d6cd90c752b62c5df95
2004-11-18 15:44:29 +00:00
7c6303c042
Add the ESCAPE clause to the LIKE operator. Not fully tested yet. (CVS 2107)
...
FossilOrigin-Name: 49268c2b7a84c4c618214dac8bef0f541440fe6b
2004-11-17 16:41:29 +00:00
c7dc75334f
Extra tests and resulting bugfixes for btree cursors. (CVS 2106)
...
FossilOrigin-Name: e1530854c9004c25f5ffa21f9cfb9c44c83cc7f0
2004-11-17 10:22:03 +00:00
ed326d7047
Perform deletes in a single pass. (CVS 2104)
...
FossilOrigin-Name: a2e1c35b327e33684ab19e5f65727c42c7b2949c
2004-11-16 15:50:19 +00:00
6a43f9b3ff
Allow btree cursors to persist through BtreeDelete() calls. (CVS 2103)
...
FossilOrigin-Name: 6ad5fc8e1a119b750a82fc1426704164a2042d57
2004-11-16 04:57:24 +00:00
7b4e7268f1
Add test cases for escape characters in the GLOB operator. (CVS 2101)
...
FossilOrigin-Name: bb2d9ff881e4c6fe0cf60a13609d39426346fa9d
2004-11-15 01:40:47 +00:00
6c62608fc6
The SQLITE_OMIT_UTF16 macro now removes lots of code and all tests still pass. (CVS 2100)
...
FossilOrigin-Name: 98c7a55478f7c465b219edc1a33eee222586fd65
2004-11-14 21:56:29 +00:00
5436dc2d97
Changes toward reducing code size when SQLITE_OMIT_UTF16 is enabled. (CVS 2099)
...
FossilOrigin-Name: 59a0a8b7cebc011731654bd0545cf8d19612ca8e
2004-11-14 04:04:17 +00:00
ce9a7b1e57
Code toward having btree cursors persist when their table is written too. Doesn't work properly yet. (CVS 2097)
...
FossilOrigin-Name: 5eaa18d43f2996a9d354bb4fb9c81e267e98be29
2004-11-13 13:19:56 +00:00
f338814455
Autoincrement is now working and has regression tests. (CVS 2095)
...
FossilOrigin-Name: 10c712a21961dbc3bff89c49d5ec3b84b9187c80
2004-11-13 03:48:06 +00:00
b92b70bb0a
Change pragmas schema_cookie and user_cookie to schema_version and user_version. (CVS 2094)
...
FossilOrigin-Name: 5e058318441bb5043c609cc8fba1653995e90efb
2004-11-12 16:11:59 +00:00
1c8c23cc36
Add authorization callbacks to ALTER TABLE. (CVS 2093)
...
FossilOrigin-Name: c4115aa3a1b010704af76c5ae9f6dcbfa4038df8
2004-11-12 15:53:37 +00:00
9fd2a9a028
Add the "ALTER TABLE xxx RENAME TO yyy" command. (CVS 2092)
...
FossilOrigin-Name: a1b2cc63e604785bd51e358ff72c485d858752e3
2004-11-12 13:42:30 +00:00
dae2495b1f
Add the schema_cookie and user_cookie pragmas. (CVS 2089)
...
FossilOrigin-Name: d28d1d68e5104726e6088361dfa7bf2cdd9985c7
2004-11-11 05:10:43 +00:00
45901d622c
Ensure the test suite can run with either SQLITE_OMIT_AUTOVACUUM or SQLITE_DEFAULT_AUTOVACUUM=1 defined. (CVS 2087)
...
FossilOrigin-Name: 0747b55882cf218c03b443e1eadec9eb19889554
2004-11-10 15:27:38 +00:00
ae381aa1b6
Fix expr.test so that it works when the date-time functions are compiled out of the library. (CVS 2086)
...
FossilOrigin-Name: 540ce7de1b3f1882c40d4e20d3986775e1dcf77a
2004-11-10 12:34:20 +00:00
e6efa74b9f
Ensure tables cannot be created/dropped when btree cursors are open. (CVS 2085)
...
FossilOrigin-Name: 8e5c2e5df8b824f7efb27e776240f005c6f1f0ff
2004-11-10 11:55:10 +00:00
752e679a1e
Have "DEFAULT CURRENT_TIME" & co. work even if SQLITE_OMIT_DATETIME_FUNCS is defined. (CVS 2083)
...
FossilOrigin-Name: f81b9c1c022772378aad32ec45d0027beeb36574
2004-11-09 16:13:33 +00:00
7977a17f06
Port the "DEFAULT CURRENT_TIME" etc. functionality from an earlier fork of sqlite. (CVS 2082)
...
FossilOrigin-Name: 0d27c8ff48f327ad82dd5b5b3b47b8d221f119b7
2004-11-09 12:44:37 +00:00
8f5a31b50f
A few more auto-vacuum tests. (CVS 2079)
...
FossilOrigin-Name: 9d4a60bbd67704ff3a9503678db94498dc700ccc
2004-11-08 12:32:50 +00:00
