danielk1977
b3dff964bd
Replace sqlite3AffinityType() with a slightly faster version. (CVS 2296)
...
FossilOrigin-Name: abe9f5e81f1196f28eec628e898b2a994c4d659d
2005-02-01 01:21:55 +00:00
drh
59f19c15c5
Performance tweaks for sqlite3AffinityType. (CVS 2295)
...
FossilOrigin-Name: 32b926154aaae9264359fa1e9a7189afd08b0bb7
2005-01-31 23:45:55 +00:00
danielk1977
52a83fbbe9
Move sqlite3HashNoCase to hash.c. (CVS 2294)
...
FossilOrigin-Name: 5c10ccd8e99cab7e9f8e733dfd1447c2df1d25c1
2005-01-31 12:56:44 +00:00
danielk1977
c60e9b82db
Assorted minor changes to speed up loading the database schema. (CVS 2293)
...
FossilOrigin-Name: dfbd684a913022ad43ce59c3422d3d94f776d547
2005-01-31 12:42:29 +00:00
danielk1977
142bdf4051
Respect collation sequences in views. Ticket #1088 . (CVS 2291)
...
FossilOrigin-Name: 9843c0dd795ceda3c260986f95b101a0cbc7cf64
2005-01-30 11:11:44 +00:00
danielk1977
6c18b6e0f4
Have the optimization introduced in (2170) deal with OP_NullRow as well as OP_Column and OP_Recno. Fix for #1086 . (CVS 2290)
...
FossilOrigin-Name: 356d31e03fe856642c5637f5ea5665947ff681fc
2005-01-30 09:17:58 +00:00
danielk1977
b3bce66232
Modify sub-query handling. Tickets #1083 and #1084 . (CVS 2286)
...
FossilOrigin-Name: b1b50f315873a8614920d1e3af4a07fb29a7ff6a
2005-01-29 08:32:43 +00:00
drh
b659e9bf7a
Make sure the #include of "sqliteInt.h" always comes first in C source files. (CVS 2284)
...
FossilOrigin-Name: 522c094f799220468780acb77731edb715bf5e3c
2005-01-28 01:29:08 +00:00
danielk1977
e63739a868
Fix a warning introduced by (2280). (CVS 2283)
...
FossilOrigin-Name: dc1b8106c4ce0ab378ee26324df4537ffe68a940
2005-01-27 00:33:37 +00:00
drh
52f159e040
More changes to improve propagation of SQLITE_CORRUPT errors. (CVS 2282)
...
FossilOrigin-Name: e4b5c16858db3b17a13cb572896bfd3dc08b88c1
2005-01-27 00:33:21 +00:00
danielk1977
33a5edc3a4
Have REINDEX handle missing collation sequences correctly. (CVS 2280)
...
FossilOrigin-Name: 1c1904f44310fa0e327d8f0a77f1cf97599b630a
2005-01-27 00:22:02 +00:00
drh
536065afef
Propagate detected database corruption up through the call stack. (CVS 2279)
...
FossilOrigin-Name: 2c54aba5ba781f4da1f14ed7a3986b6dc17728d7
2005-01-26 21:55:31 +00:00
drh
5742b63e4a
An optimization to sqlite3VdbeSerialType(). (CVS 2278)
...
FossilOrigin-Name: db36773830cc81c38b78d1776a495d49475523be
2005-01-26 17:47:02 +00:00
danielk1977
e257300f2e
Allow GROUP BY on non-aggregate queries. Ticket #1064 (CVS 2276)
...
FossilOrigin-Name: 0642d3e3d6636a5f922f75c05252c9c1372d3936
2005-01-26 03:58:35 +00:00
danielk1977
9636c4e102
Prevent collation sequences and user functions from being deleted or changed while SQL statements are executing. (CVS 2275)
...
FossilOrigin-Name: cabab62bc10568d435806a7059fad7274f0dd4c8
2005-01-25 04:27:54 +00:00
danielk1977
bfb9e35b30
More test cases to do with invalidating precompiled statements. (CVS 2273)
...
FossilOrigin-Name: b243681a0e328ee0bbf1140abfb60d65d2102ad5
2005-01-24 13:03:32 +00:00
danielk1977
a21c6b6fe0
Modifications and bugfixes so that the test suite passes with the TCL statement cache turned on. (CVS 2271)
...
FossilOrigin-Name: d5233e0747789dea04d35a8350b408321d23a64d
2005-01-24 10:25:59 +00:00
drh
fb7e7651ca
Change the TCL interface so that it can cache VMs and reuse them without
...
recompiling. But for now leave the cache turned off by default. (CVS 2269)
FossilOrigin-Name: 8db6bfef52c1f35afdb8b60cba34f6807a5917f4
2005-01-24 00:28:42 +00:00
danielk1977
4af00c6cee
Modification to shell.c to avoid a compiler warning on some compilers. (CVS 2268)
...
FossilOrigin-Name: 0778383b6f9e6f58202ca20e74b399f8dce90ec4
2005-01-23 23:43:21 +00:00
danielk1977
940fac9dc5
Minor changes to avoid warnings on some compilers. (CVS 2267)
...
FossilOrigin-Name: 4daf1d1f9d4d32397d785d660394c5579c296b1f
2005-01-23 22:41:37 +00:00
drh
f4d173ae14
Fix a bug in change counting that comes up when sqlite3_finalize() is
...
called right after sqlite3_reset(). (CVS 2266)
FossilOrigin-Name: 1a64295e055d083539e05f069df6f1bea12e14b2
2005-01-23 19:04:42 +00:00
drh
178286b5df
ATTACH and DETACH cause prepared statements to expire.
...
sqlite3_finalize() can now be called right after sqlite3_reset(). (CVS 2265)
FossilOrigin-Name: 6c631b86e5e166f650d3f7d53c773aa859391c2b
2005-01-23 13:14:55 +00:00
danielk1977
32554c10d0
Test script changes: Bug fix and cleanup on ioerr tests. Also, don't use TCL "file copy" command on windows. (CVS 2264)
...
FossilOrigin-Name: 764b55adb5dff944db36d0d19ce5e7cc758b3a9e
2005-01-22 03:39:39 +00:00
drh
d89bd007ba
Add the experimental sqlite3_expired() API. (CVS 2263)
...
FossilOrigin-Name: df648d50c0696cf7ada2fe5973d285b494891964
2005-01-22 03:03:54 +00:00
drh
52370e2c95
Add <stddef.h> to sqliteInt.h. (CVS 2262)
...
FossilOrigin-Name: fede252d19cce6a88f6baff3362b057ab3b8af4b
2005-01-21 21:31:40 +00:00
drh
1ba1e6e0b9
More documentation changes. Allow SQLITE_DEFAULT_CACHE_SIZE to set the
...
default cache size for the pager at compile-time. (CVS 2261)
FossilOrigin-Name: 2ddb6748751c0135a42e6d0bcc303d06d8e17cf3
2005-01-21 21:22:52 +00:00
drh
842b864118
Initialize the random number generator from /dev/urandom, if available. (CVS 2258)
...
FossilOrigin-Name: aab8e7f8d81ffa786d5fae5a13963c6e58a8eefc
2005-01-21 17:53:17 +00:00
danielk1977
576ec6b32a
Improve test coverage for minimum feature builds. (CVS 2254)
...
FossilOrigin-Name: 9c4d0e13e8c5f3fc4d7fd8f495898372293f7fad
2005-01-21 11:55:25 +00:00
danielk1977
93758c8dcc
Exclude a few more lines of code using OMIT macros. (CVS 2253)
...
FossilOrigin-Name: c6fc49e61033419e78b6b10638d57f4942087961
2005-01-21 08:13:14 +00:00
danielk1977
3e8c37e7f8
Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251)
...
FossilOrigin-Name: bb0254ab14417f0ab40f10f37cb63a60507f070a
2005-01-21 03:12:14 +00:00
danielk1977
83715c3edd
Change the implementation of ALTER TABLE so that it does not use the IN() operattor. (CVS 2249)
...
FossilOrigin-Name: 06887afb323fa1fb6988a136f96a456467cf7b2f
2005-01-21 00:44:22 +00:00
drh
4eec4c1b0c
Fix a segfault that occurs on a corrupt database. (CVS 2248)
...
FossilOrigin-Name: d1166472fd17960eb3016f3d5d3bf44afc9f5bc8
2005-01-21 00:22:37 +00:00
drh
fe2093d73e
Bug fixes and enhancements entered while on jury recess. (CVS 2246)
...
FossilOrigin-Name: 38401dfbd5e3b50dd4e7a11562a7770347cebdf4
2005-01-20 22:48:47 +00:00
drh
51522cd34a
Added the SQLITE_OMIT_SUBQUERY compile-time option and the EXISTS operator.
...
Regression tests are currently failing with an assertion fault. (CVS 2245)
FossilOrigin-Name: d30fdf0f2c24cb74b48fab9b83fba4e4b2fe878a
2005-01-20 13:36:19 +00:00
danielk1977
5338a5f74d
Remove a few more lines of code when SQLITE_OMIT_** macros are defined. (CVS 2244)
...
FossilOrigin-Name: 417bbba93ad7ed5c03d9db6afc12e170155bd152
2005-01-20 13:03:10 +00:00
danielk1977
b84f96f854
Extend the influence of a couple of SQLITE_OMIT_** macros a little bit. (CVS 2243)
...
FossilOrigin-Name: 5b1a9bf6aa5a5c466b88f649e322e81b8466851f
2005-01-20 11:32:23 +00:00
danielk1977
1ad7f64aac
Changes so that crash.test works when SQLITE_OMIT_PAGER_PRAGMAS is defined. (CVS 2242)
...
FossilOrigin-Name: f0add0a60e0afb833202e42cdba97bafe6a59dfc
2005-01-20 05:24:32 +00:00
drh
1bd3644f27
Turn SQLITE_OMIT_CURSOR on by default. (CVS 2240)
...
FossilOrigin-Name: 2d3ab1ab5ae08fe21f4662b171f04362c1326eb0
2005-01-20 02:14:30 +00:00
drh
3119bc421a
Expression generator bug fix. (CVS 2239)
...
FossilOrigin-Name: 39cf97a902523b1e3953da8fca6983119700d682
2005-01-20 01:51:25 +00:00
danielk1977
6d32959693
Minor fix for sqlite3_clear_bindings(). (CVS 2238)
...
FossilOrigin-Name: ff5b338cfbd4a957c8ea5e72d6340df25be68a6f
2005-01-20 01:17:44 +00:00
danielk1977
600dd0ba33
Add the experimental sqlite3_sleep() and sqlite3_clear_bindings() APIs. (CVS 2237)
...
FossilOrigin-Name: 9480209e8600bf411975b3950c407d60c800e5c6
2005-01-20 01:14:23 +00:00
drh
1398ad3639
Continued refactoring of the name resolution logic and query optimizer. (CVS 2236)
...
FossilOrigin-Name: d8b2a7e09187564fe66a2b4bf0992c6a017146cf
2005-01-19 23:24:50 +00:00
drh
030530de9b
Make sure USING and NATURAL work on joins even if the columns are renamed
...
using an AS phrase. Ticket #523 . (CVS 2233)
FossilOrigin-Name: c06add57bf0ce17503181b584ea4197b39b9e538
2005-01-18 17:40:04 +00:00
drh
79d5f63fa2
CREATE TABLE ... AS ... uses short names for columns. Ticket #1036 . (CVS 2232)
...
FossilOrigin-Name: b1d4c42d2be07adda68d31c570ba7cf8b115c3ad
2005-01-18 17:20:10 +00:00
drh
47a6db2bfd
Column names coming back from a SELECT are now just the name of the
...
source column without the "table." prefix. In other words,
"PRAGMA short_column_names=ON" is now the default.
This makes the names of columns behave more like other SQL engines.
The old behavior can be restored by setting "PRAGMA short_column_names=OFF". (CVS 2231)
FossilOrigin-Name: 9295050af1bf2d9d4dc63adc225a2848d67cbe17
2005-01-18 16:02:40 +00:00
drh
9b3187e113
Continue refactoring name resolution. Fix for ticket #1047 . (CVS 2230)
...
FossilOrigin-Name: 88d4834fec7583a9b6400a1ce5b928c1f8a390dd
2005-01-18 14:45:47 +00:00
drh
73b211abed
Refinements to the name resolution logic. Change the name of the
...
keywordhash.c file to keywordhash.h. (CVS 2229)
FossilOrigin-Name: 0142ae6f0004bf18a1c2d8e49c09d2a9a27d6369
2005-01-18 04:00:42 +00:00
drh
626a879a25
Infrastructure changes to handle name resolution differently. This is needed
...
to fix various long-standing problems with column names in joins. It will
also make the implementation of correlated subqueries easier. (CVS 2228)
FossilOrigin-Name: 4a7534396a72ccb300303df28798bb2c50293782
2005-01-17 22:08:19 +00:00
danielk1977
3719d7f9c4
Fix a bug reported on the mailing list concerning a conflict between "INSERT INTO ... SELECT" statements and the "SELECT max(x) FROM tbl" optimization. (CVS 2227)
...
FossilOrigin-Name: 5a9da62ae303800ded99942aed30eadeb3863da3
2005-01-17 08:57:09 +00:00
danielk1977
5558a8a697
Fix some memory leak problems with corrupt.test and auto-vacuum databases. (CVS 2226)
...
FossilOrigin-Name: 6244252915fa312a6c4d192464023d95aaef4661
2005-01-17 07:53:44 +00:00